|
Are you using inbuilt login control ?
katelva wrote: I do not know the SQL connection to connect the SQL and check the username and password?
System.Data.SQLClient is the namespace where ADO.NET classes used for communicating with SQL server are located. Use SQLConnection to create a connection. Use SQLCommand for supplying a query. Use SQLDataReader for reading the data.
|
|
|
|
|
Hi,
Thanks for your information.
But, I am wondering how to I validate the user input with SQL database using asp.net C#? For example, I create a login.aspx and I put the code in login.aspx.cs. I have put the SQL connection inside but I do not know how to I validate user input with SQL database? Do you have any good websites suggested for that? Mostly I search is in VB.net not asp.net in C#. I don't know the asp.net C# syntax of checking the user input with SQL database?
Thanks.
Regards,
Katelva
|
|
|
|
|
Hi,
Thanks for your information. But I am wondering how to I validate the user input with SQL database? I have created a login.aspx with user input username and password, I put the code in login.aspx.cs,but I am not sure the syntax for asp.net in C#. So far, all the codes I search are for VB.net. I am not sure how do I validate user input with SQL database using asp.net in C#?
Do you have any recommended websites for this?
Thanks.
Regards,
Katelva
|
|
|
|
|
Dear,
I use GridView in ASP.NET and I use asp:HyperLinkField but it not work when I use DataNavigateUrlFormatString="javascript:showProfile('{0}').
It not recornize sign ":", so how can i do?
Socheat
|
|
|
|
|
previous12… 7891011next
iam having total 11 pages.
if the cursor is one previous button should be disabled.
if the cursor is 11 next button should be disabled..
plz send me code .
|
|
|
|
|
kathyani wrote: urgent
Please read this[^]
kathyani wrote: plz send me code .
Check this[^]. It's urgent
|
|
|
|
|
i havent get ..
plz tell me ...
|
|
|
|
|
kathyani wrote: plz send me code .
you didnt say pretty please
We are not a Code Charity
|
|
|
|
|
i have no idea ,how to achieve the requirment.
if u have any idea plz send me code
|
|
|
|
|
kathyani wrote: plz send me code
You are in a wrong place. People do voluntary help here and probably won't send any code. Asking urgent help is considered as rude. So please change the way you ask questions. Explain the problem you are facing clearly. Use google before you ask and read the links which is in my first post as well.
|
|
|
|
|
thnks for u r valuable and good suggestion.
|
|
|
|
|
Hi,
I have developed one user control,i have written most of the functionality on that control, just i have added that to the aspx page, in the ASCX, i have loaded dyamic controls like checkboxes, labels... based on the Checkbox selection, i want some DDL operations(Edit, Create Delete), on database in the button click. in the button click i want checkbox ID, to find which box is selected. i am not getting that ID. Please help me if any knows.
Thanking you
modified on Monday, July 7, 2008 8:36 AM
|
|
|
|
|
Hi
I need to write a loop to loop all items in a listbox and run a query for each one.
i have this so far:
for (int i = 0; i < departments.SelectedItem.Selected; i++)
{
}
but its not working, i basically need this
for each row which is selected run query
any help would be great
thanks!
We are not a Code Charity
|
|
|
|
|
There's no listbox in ASP.NET ?
use foreach to iterate over the selectedItems, or use a for loop that goes through all the items and checks which ones are selected. What you've written surely won't compile ?
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
Christian Graus wrote: There's no listbox in ASP.NET ?
There is one. Check this[^], or am I missing something ?
|
|
|
|
|
OK, I didn't think it was called that as an ASP.NET control. I'm wrong, I admit it.
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
Christian Graus wrote: I'm wrong, I admit it.
Its a day of miracles!
We are not a Code Charity
|
|
|
|
|
There is a ListBox CG.
Thanks for the answer though I was bit off with my loop.
We are not a Code Charity
|
|
|
|
|
foreach (ListItem item in departments.Items) {
if(item.Selected)
}
|
|
|
|
|
Yep ive got that now:
for (int i = 0; i < departments.Items.Count; i++)
{
if (departments.Items[i].Selected)
{
but how would I set the value selected from the listbox would it simply be
departments.SelectedValue?
thanks
We are not a Code Charity
|
|
|
|
|
.netman wrote: but how would I set the value selected from the listbox would it simply be
ListItem has Text and Value properties which can be used.
|
|
|
|
|
Ok, Ive tried this:
ListItem item = departments.Items[i].Value;
but get the error:
Cannot implicitly convert type 'string' to 'System.Web.UI.WebControls.ListItem'
I cant find the correct syntax to set the item value.
We are not a Code Charity
|
|
|
|
|
.netman wrote: ListItem item = departments.Items[i].Value;
You are totally lost. Value returns string not ListItem. It should be
ListItem item = departments.Items[i];
item.Value use foreach as I shown in my first post. foreach is cleaner than this.
|
|
|
|
|
ok sorted it:
string string1 = departments.Items[i].Value;
cheers everyone!!!!
We are not a Code Charity
|
|
|
|
|
.netman wrote: i < departments.SelectedItem.Selected
Its wrong, the 'Selected' property returns a boolean value.
As CG said you can use Foreach to loop throught all selected items,
OR a for loop to loop through all items and find selected items.
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|