|
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
|
|
|
|
|
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
|
|
|
|
|
<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)
|
|
|
|
|
Try with Javascript for the Date Validation.
Regards,
Satips.
|
|
|
|
|
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
|
|
|
|
|
|
RTFM
only two letters away from being an asset
|
|
|
|
|
use a date time picker control.. that`ll save u the burden of validating the date..
Kunal
|
|
|
|
|
and the date time picker i can define the user to select only dates that are after today am i rite?
|
|
|
|
|
obv not.. u can select from the dates before today.. infact, 5-7 yrs back as well..
Kunal
|
|
|
|
|
and where can i find my date time control? i can see it in the toolbar >><
|
|
|
|
|
well.. there wudnt be ny in the tool bar.. ...
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
|
|
|
|
|
yes pls and thx in advance
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
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
|
|
|
|
|
And your question is???
only two letters away from being an asset
|
|
|
|
|
|
Hi,
Iam using VS 2005 for building my ASP.NET applications. I do not see the drop down where i can switch between release and debug configuration in VS 2005. Is there a short cut key to bring the build configuration window???
Thanks
Ridge
|
|
|
|
|
Try going to your menu tools then customize
The select the standard toobar. The debug / release drop down should be in that tool bar. Perhaps you have un docked that tool bar and hidden it or closed it.
Hope that helps.
Ben
|
|
|
|
|
Hi,
I am trying to make this work here, I set a form authentication on my site from a SQLDatabase. Now the membership tool did not seem to give me all I needed so I followed an example using tickets to specify user roles from the database. All in all it works well. The only problem I am having is that whenever I am authenticated with a lesser user role (let say Role 1) and I am trying to axs a page requiring Role 2 let's say, I am redirected to the login page - not the error page. I tried to find a trick to redirect to the error page all users already authenticated (meaning that most of the time it would be because they tried to axs a page to which they can't axs) but that means even if the user wants to go back to the login page he will be redirected to the error page, which doesn't make sense.
So my question is - Is there a variable or a way to know that a user tried to axs a restricted page even though he was already authenticated??
JC
PS: I hope it's clear, I seem to have difficulties putting it to words
JC
|
|
|
|
|
I don't know if there is any way of doing what you are trying to do. What you can do is if you are using a site.map file to show your links to the different pages you can to role trimming which will only show the links that the users role allows.
Hope that helps.
Ben
|
|
|
|
|
I just wanted to proof my site so if I or anyone else type in manually the URL of a restricted page, they would go to an error page instead of the login (not indicating why).
I guess I found a workaround - probably if I put the error page as my login page in the webconfig and then redirect to login if not autenticated it would work. Although I find it a bit sloppy and I cannot beleive there isn't a better way to do this ...
but thanks for the input
|
|
|
|
|
I have an ASP.Net app that creates a bitmap image and tries to save it to the images folder of that application. When I browse to the page, I get a "generic error occured in GDI+" in the Bitmap.Save method. I tried everything I knew to do to set permissions for the application, but it still doesn't work. Tha application works fine on another machine.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
)