ASP.NET

SetParameterValue Not passing parameters to the SP

9-Jul-08 4:33

You need to make sure the browser doesn't cache your page. If you hit refresh, does it go to the login page ? If so, this is your problem. Put Response.Cache.SetCacheability(HttpCacheability.NoCache) in your pages, preferably via a common base page ( the place where you check if the session is set is a good place to do it.

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

allende9-Jul-08 4:14

allende

9-Jul-08 4:14

HI friends, this question is regarding Crystal Reports in VS 2005

My report here is attached to a SP. I'm trying to pass parameters but it raises an error:

Procedure or function 'sp_wfsAppByCounsReport' expects parameter '@StartingDate', which was not supplied.

Here is my code, I'm passing the parameter. I can even trace it and the rdDocument variable has them attached after the SetParameteValue....why the report is not sending them to the SP???

Here is my code:

protected void Page_Load(object sender, EventArgs e)
{
    DateTime dtStartingDate =  DateTime.Parse(DateTime.Today.Month.ToString() + "/" + "1" + "/" + DateTime.Today.Year.ToString());

    ConnectionInfo ciLogin = new ConnectionInfo();
    ciLogin.ServerName = "myserver.com";
    ciLogin.DatabaseName = "mydb";
    ciLogin.UserID = "dbuser";
    ciLogin.Password = "mypass";
    TableLogOnInfo tbLogonTable = new TableLogOnInfo();
    tbLogonTable.ConnectionInfo = ciLogin;

    ReportDocument rdMonthReport = new ReportDocument();
    rdMonthReport.Load(Server.MapPath("couns-month.rpt"));
    rdMonthReport.SetParameterValue("@StartingDate", dtStartingDate);
    rdMonthReport.SetParameterValue("@EndingDate", DateTime.Today);

    foreach (CrystalDecisions.CrystalReports.Engine.Table tbTable in rdMonthReport.Database.Tables)
    {
        tbTable.ApplyLogOnInfo(tbLogonTable);
    }
    CrystalReportViewer.ReportSource = rdMonthReport;
    CrystalReportViewer.RefreshReport();
}

Any help is appreciated!!

Re: SetParameterValue Not passing parameters to the SP

Christian Graus9-Jul-08 4:16

Re: SetParameterValue Not passing parameters to the SP

9-Jul-08 4:16

Is your date format correct ? Is MM/DD/YYYY what your server expects ? any need to write code that works out hte local format and uses it ?

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

allende9-Jul-08 4:23

allende

9-Jul-08 4:23

I think so. The parameters in the SP are DateTime..and I'm passing DateTime as parameters too.

Stop Timer Plz

Member 34356149-Jul-08 3:29

Member 3435614

9-Jul-08 3:29

I created one page which contain one timer which will execute some function after every 5 min and send one mail to my id. Now the problem is i m not able to stop that one after every 5 min i receive mails. I close that page so it not execute but still it is running. How to stop that timer.

Christian Graus9-Jul-08 3:44

9-Jul-08 3:44

I don't see how that is possible. How do you set your timer ? Posting code would help.

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

eyeseetee9-Jul-08 4:36

9-Jul-08 4:36

The timer should stop when you leave your application i.e. close your web browser

Christian Graus9-Jul-08 4:53

9-Jul-08 4:53

Well, obviously. I am assuming that he's perhaps running a timer in his code behind, given that he's using it to send email. I then assume it isn't within a page, given that it runs on a timer. This would explain why it keeps running, it's server code that runs outside a page. But, unless he answers my question, it will be hard to help him further.

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

Re: Regarding ASP.Net AJAX

Member 34356149-Jul-08 19:03

Member 3435614

9-Jul-08 19:03

sorry for late reply..

Timer timer = null;
timer = new Timer();
timer.Interval = 120000; //60 seconds (10000 - 10 seconds)
timer.Elapsed += new ElapsedEventHandler(timer_Elapsed);
timer.Enabled = true;
timer.Start();

this is in page load event and i m calling timer_Elapsed function....

void timer_Elapsed(object sender, ElapsedEventArgs e)
{
AutoSendMailToCustomers();
}

Regarding ASP.Net AJAX

dhanunjaya219-Jul-08 3:20

dhanunjaya21

9-Jul-08 3:20

Hi ,
how to display and refresh images on

after the page load completed using Asp.net Ajax concepts (Updatepanel and timer control or etc ) .

like

sdfjshjdfnksandfnsandfnsdjnfsndfnsdnfmnsdmnfnsdfndsdhsdfsdjk
sdjfhsjdhfjshjfjdjfjsjdkhfjsjjdfhkjdhskjfjskhfjhjdhfjhsjjdfhjshjf
sdhgshghdghsgfhdghsghdgdghsdhsdfhdsfdhghsfhgsdhfhsgdhghsdhfshgdfgsdgfh
djhjsfjsdhjfhsjdhfjhdhfshdhfsjhdjfhsjdhfjhsjdhfjshdjfhjsdhfjsdfsdfS
jsjdhjsdjsdshdsdhsjhdjshjdhjshdjhsjdjhsjhdjs

pageload ...
pageload completed .

display the image1 on div
<asp:image mode="hold" xmlns:asp="#unknown">
delay 3 sec
display or refresh image 2 on same div
<asp:image mode="hold" xmlns:asp="#unknown">
delay 3 sec
display or refresh image 3 on same div
<asp:image mode="hold" xmlns:asp="#unknown">
thats it ..
it is a simple.. i done but i am not getting on div ?..

if u know how to do or done ..
send me replay to here
or mail me :
mails2dhanunjaya@gmail.com

Thanks ..

Dhanu

Christian Graus9-Jul-08 3:46

Merging onClick events in ASP.net

9-Jul-08 3:46

I am certain there's a control built into that library that does this for you, you just provide the image URLs

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

imnotso#9-Jul-08 3:19

imnotso#

9-Jul-08 3:19

Hi,

I'm adding a button to an existing app. I need to open a new window once this button is clicked. The new button has been added to an existing User Control and takes on all the attributes of the other buttons. Great.

I need to add an onClick event to my button in the code behind that will open a new browser via some javascript (window.open). When I add it it and run the code it renders the button with 2 onClick events (1 from the global attributes of the user control I guess) My onClick doesn't funtion (not a shock) I know I can have 2 functions running on 1 onClick - I separate with a semi-colon - how do I merge my onClick event into the existing one? Attribute.Add("onClick"),myButton creats a new one.

Any ideas welocme !!

Thanks

combo box -- ddl

trilokharry9-Jul-08 2:44

trilokharry

9-Jul-08 2:44

suppose one combo box have 10 values then how to pick up 5th value from combo box using java script function ?

thanks

You get the best out of others when you give the best of yourself.

Re: combo box -- ddl

Imran Khan Pathan9-Jul-08 2:51

Imran Khan Pathan

9-Jul-08 2:51

trilokharry wrote:
suppose one combo box have 10 values then how to pick up 5th value from combo box using java script function ?

alert(document.getElementById('ddlID').options[5].value);

regard
khan

please don't forget to vote on the post that helped you.

Master to Content page

Agweet9-Jul-08 2:07

Agweet

9-Jul-08 2:07

hi all,

can any one help...im fairly new at C#...im trying to pass data from my master page to a page in my content place holder...please help...thanks in advance.

living life on the flip side

Re: Master to Content page

eyeseetee9-Jul-08 2:55

Re: Master to Content page

9-Jul-08 2:55

So you mean youve got a masterpage and then that is included in your main page.
How are you passing data?
Normally a masterpage is included in every normal page and thats where you get the main style/layout to

Agweet9-Jul-08 3:01

Agweet

9-Jul-08 3:01

i have my master page..with a content place holder on it and in the content place holder...is the new page. what happens is...i click on my treeview in the master page and i want to send the values of the treeview to my page in the content place holder...i hope this helps

living life on the flip side

masterpage+js

niki_nilu9-Jul-08 1:47

9-Jul-08 1:47

hello sir
i am using master page in webapplication.
and i used c# language.
i have one .js file.
i want to use it in my application.
i want to add form tag because i want to write this code

where i add form tag.bec i used masterpage.
pls help me its really urgent.
gayatri

Gayatri

eyeseetee9-Jul-08 2:56

9-Jul-08 2:56

where do you want the form tag? or are you asking where to put it?
Normally it would go in your aspx page
can you explain again

niki_nilu9-Jul-08 3:08

9-Jul-08 3:08

sir
i want form tag in my webform.
in that web form i used masterpage.
so when i take form tag that time i gave error.
so i ask you where i put it.
when i put it in content.that time i have error.

i want to use .js file.
the code ---

// JScript File
function valForm()
{
if(!valid_required(document.form1.txtFirstName.value))
{
alert("First name is required field.")
return false
}
return true
}

this i want to use in my webform's html source code
my code=-----

<@>
CodeFile="Client.aspx.cs" Inherits="Client" Title="Untitled Page" %>

<asp:content id="Content1" contentplaceholderid="ContentPlaceHolder1" runat="Server" xmlns:asp="#unknown">

this code i have run time error--A page can have only one server-side Form tag.

so pls help me.

Gayatri

Imran Khan Pathan9-Jul-08 3:15

Imran Khan Pathan

9-Jul-08 3:15

niki_nilu wrote:
this code i have run time error--A page can have only one server-side Form tag.

Master Page already has a form tag.
you can use your javascript in head tag in master page.

please don't forget to vote on the post that helped you.

niki_nilu9-Jul-08 3:25

9-Jul-08 3:25

master page code

<@>

<title>Chanakya

now error is

Invalid postback or callback argument. Event validation is enabled using <pages enableeventvalidation="true"> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.

Gayatri

Imran Khan Pathan9-Jul-08 3:37

Imran Khan Pathan

9-Jul-08 3:37

niki_nilu wrote:
nvalid postback or callback argument. Event validation is enabled using in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.

Set EnableEventValidation="true in page directory

regard
kHan

please don't forget to vote on the post that helped you.

eyeseetee9-Jul-08 3:17

9-Jul-08 3:17

As far as I am aware you cant have a form tag inside another form tag which is what you would be doing if you included a masterpage in another page as there would be two form tags.

niki_nilu9-Jul-08 2:57