ASP.NET

how to retrieve multiple data from sql database and store in variables

9-Apr-07 18:32

try this... htis one masks the time..
Mask control

you may also use the AJAX ASP.net control toolkit...
hope it helps..

Kunal

neodeaths9-Apr-07 16:15

Re: how to retrieve multiple data from sql database and store in variables

9-Apr-07 16:15

hi guys i would like to learn how to retrive data from sql database and stored in multiple variables.

so far i learned executescaler which retrieve the 1st row,1st col data and store it in the specified variable.

so how can i select multiple row,col and store them?

i understand some of the steps are :

SqlConnection conn = new SqlConnection((ConfigurationManager.ConnectionStrings["HASDBConnectionString1"]).ToString());

SqlCommand sc = new SqlCommand("SELECT Name,age,add FROM STUDENT", conn);

sc.ExecuteNonQuery();

................<== from here on in i dont know

please guild me in my learning tour thx

Not Active9-Apr-07 16:55

need help: validation of date

9-Apr-07 16:55

It would not be an ExecuteNonQuery, that is more for update or insert statements, a command that does not return data.

Try reseaching the ExecuteReader method

only two letters away from being an asset

neodeaths9-Apr-07 16:07

9-Apr-07 16:07

<asp:Label ID="Label2" runat="server"<br />
BorderStyle="None" Width="80px"<br />
Text="date:" /><br />
<asp:TextBox ID="txtdate" runat="server" /><br />
 <br />
<asp:RequiredFieldValidator<br />
ID="RequiredFieldValidator2" runat="server"<br />
ControlToValidate="txtdate"<br />
ErrorMessage="Required." /><br />
<br />

the above code is field validator.

is there a function to make sure the entered date is today and days after?(any time after today)

Sathesh Sakthivel9-Apr-07 16:49

Sathesh Sakthivel

9-Apr-07 16:49

Try with Javascript for the Date Validation.

Regards,

Satips.

Not Active9-Apr-07 16:51

9-Apr-07 16:51

You could use a CustomValidator control and supply either a Javascript or Serve-Side method, or both.

only two letters away from being an asset

neodeaths9-Apr-07 19:49

9-Apr-07 19:49

how would i do that?

Not Active10-Apr-07 2:04

10-Apr-07 2:04

RTFM

only two letters away from being an asset

Kunal P9-Apr-07 18:23

9-Apr-07 18:23

use a date time picker control.. that`ll save u the burden of validating the date..

Kunal

neodeaths9-Apr-07 18:42

9-Apr-07 18:42

and the date time picker i can define the user to select only dates that are after today am i rite?

Kunal P9-Apr-07 18:45

9-Apr-07 18:45

obv not.. u can select from the dates before today.. infact, 5-7 yrs back as well..

Kunal

neodeaths9-Apr-07 18:46

9-Apr-07 18:46

and where can i find my date time control? i can see it in the toolbar >><

Kunal P9-Apr-07 18:59

9-Apr-07 18:59

well.. there wudnt be ny in the tool bar.. Laugh | :laugh:

...

u got to download it from the net.. go to ajax.asp.net to download the toolkit.. which has the same.. or any other third party asp.net date time picker control.. i have one.. as well.. built in javascript.. shud i mail you..

Kunal

neodeaths9-Apr-07 19:00

9-Apr-07 19:00

yes pls and thx in advance

Reference

hahii9-Apr-07 14:18

hahii

9-Apr-07 14:18

I have a table in aspx page and I dragged a dropdownlist from toolbox. When I tried to change it's ID e.g ddlUser it gives me a messagebox saying that if you have references in markup they will not be removed.

What does it means and it is not allowing me to change the name of the control.

Thanks

hahii

Re: Reference

Christian Graus9-Apr-07 14:45

Christian Graus

9-Apr-07 14:45

It probably means that the toolbox sucks, you should just write your aspx page by hand.

What happens if you go into the code and change it ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

encrypted

hahii9-Apr-07 12:19

hahii

9-Apr-07 12:19

Hi All,

I have a login status control in my aspx page and I want to encrypt
the login passward and compare with encrypted tbUsers.UserPass where
tbUsers is the name of my table and UserPass is my field name.

Really Thanks in advance.

hahii

Re: encrypted

Not Active9-Apr-07 16:59