ASP.NET

eyeseetee9-Jul-08 4:43

9-Jul-08 4:43

If I have got my datasource set in my aspx page how do I set a value selected from that query to my dropdown

i have this

DropDownList dd = ((DropDownList)row.FindControl("ddorder"));
dd.DataValueField =

thats in my databound event but how do I set it to the field from the query. I'm not sure of the syntax.
In my aspx the other fields in the gridview are just set like normal bound fields

Christian Graus9-Jul-08 4:48

9-Jul-08 4:48

I have no idea, I'd never use that nasty 'set a data source in the presentation layer' stuff that MS has built in to ASP.NET in recent times.

Christian Graus

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

eyeseetee9-Jul-08 4:50

9-Jul-08 4:50

Ok, if i set my datasource in the c# instead like:

SqlDataSource1.SelectCommand = "select field from table"

how do I reference a field from that?

Christian Graus9-Jul-08 4:53

9-Jul-08 4:53

I believe you set the DisplayMember property to the name of the column you want to show.

Christian Graus

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

eyeseetee9-Jul-08 5:00

9-Jul-08 5:00

Hi
sqldatasource does not have that attribute.

thanks anyway I will try the web.

cheers

Christian Graus9-Jul-08 5:03

9-Jul-08 5:03

No, the drop down list does.

Christian Graus

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

Impement AJAX,

codelinks9-Jul-08 4:25

9-Jul-08 4:25

Imagine this is my initial page DSIHome.aspx
I need to implement AJAX in existing project, my requirement is………

I have a menu with sub menus,, which is again generated dynamically (XML).
On clicking in any of the sub menus, I pass the argument to the URL , just like below

location.href="DSIHome.aspx?hdnfld=" + obj + "&catName="+ catName ;

this will initiate the postback and pass the values to the URL,
and I can retrieve the form content based on the URL values using QueryString,

my part here is to STOP postback,
i need to implment AJAX and stop the postback happening while clicking the sub menu

do u have any suggestion for this ?

winnie

Christian Graus9-Jul-08 4:34

9-Jul-08 4:34

The URL does not change when you use AJAX, so you need to rethink your whole approach. You could pass the values via the AJAX call and store them in jscript if you need them locally.

What's on the page, that is, what sort of navigation are you hoping to replace with AJAX ?

Christian Graus

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

codelinks9-Jul-08 4:40

9-Jul-08 4:40

thanks for the quick reponse,

I havent found the method to solve the problem, i can take your suggestion using AJAX call, can you provide me with links, samples on how to implement that.
regards

winnie

Christian Graus9-Jul-08 4:48

9-Jul-08 4:48

Umm.... I asked you some questions, could you answer them ?

Christian Graus

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

codelinks9-Jul-08 4:55

9-Jul-08 4:55

the page contains treeview and 2 datalist, the data on these controls is loaded based on the values on the URL,
as you said the values should be available locally ,
hope im conveying the problem in right words
regards

winnie

Christian Graus9-Jul-08 5:04

9-Jul-08 5:04

OK, you should use ASP.NET AJAX for this, which will just wrap everything for you. Trying to populate those controls using your own JS is a PITA. If you put everything in an update panel, it will just AJAX it for you.

Christian Graus

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

codelinks9-Jul-08 5:10

Logout > Back Button in Browser

9-Jul-08 5:10

thanks

winnie

butchzn9-Jul-08 4:23

butchzn

9-Jul-08 4:23

Hi Guys,

When i LogOut a user on my site a User is still able to hit the Back button in their browser and essentially view a logged in only page.
Ideal scenario would be for this page to send them to Login screen.

What would be the best way to stop this from happening?

FYI.
When a user logs in, i store a loggedIn value in a session variable.
On logout i reset this session to indicate the user is loggedOut.

I am using c# .net

Many Thanks.

Re: Logout > Back Button in Browser

Christian Graus9-Jul-08 4:33

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