Database

Question

How can I call an ID of the user form database for e.g ID USERNAME 1Tests 2Testss I want to get the id and undate the database?

Tan Kai Kai · Answer

I have try using that but it just do not session the ID how can this be done after they have log in?

Tan Kai Kai · Answer

User can sign up for an event they have to fill in the name, email and so one after they after done. As different people sign up they will go to different table they can go on to the next tab. If not they cloud go on the the next tab (this can be work) and they will fill up some thing and will update on the same row that is where the error come as I cloud not get the id of the row as they have insert to the table for the first tab

Sanjeeb Lenka · Answer

hi, you have to maintain userid at the of login. better to use session. ex- Session["ID"]=ID; now you can able to access it in every page. ex- int CustomerID = Convert.ToInt32(Session["ID"]);

Iftikar Hussain · Answer

how you are maintaining the current user details in your application? Regards, Iftikar

Tan Kai Kai · Answer

no. is there any way if no how can I do that because my page got a tab and want user click next after they fill the name email and so on they will come to a tab on the same page that as that to fill the address and so on and will update the table from there

Iftikar Hussain · Answer

are you passing the query string value in your page like YourPage.apsx? id=1 Regards, Iftikar

Tan Kai Kai · Answer

Here is the simple of my code "Update [Table name] SET [FirstName] = @FristName WHERE CUSTOMER ID=@CustomerID"; Cmd.Parameters.AddWithValue ("@CustomerID", Customer_ID()); Cmd.Parameters.AddWithValue ("@FirstName", txtFirstName.Text); public in Customer_ID() { intCustomerID =0; CustomerID = int.Parse(Request.QueryString[ "id" ]); return Customer; } I have error in the the red colour word say null that this is string How can I slove this?

Sanjeeb Lenka · Answer

select ID,Username from TableName where Username='username you want to match' or select ID,Usernam from TableName where ID='pass the ID you want to match'

Iftikar Hussain · Answer

in what condition you want id and name? since there are multiple records in your table. Please provide more details. Regards, Iftikar

Tan Kai Kai · Answer

Nope I want the username and get the ID

Sanjeeb Lenka · Answer

select ID from TableName where Username='username you want to match'

Iftikar Hussain · Answer

Hi, You can do like this string constring = @"Data SourceSQLEXPRESS;Initial Catalog=MyDataBasee;Persist Security Info=True;User ID=MyUserId;Password=MyPassword"; SqlConnection conn = new SqlConnection(constring); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT ID FROM UserTable WHERE USERNAME=@Field"); cmd.CommandText = "spadmin2"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Field", TxtBoxUserName.Text); object tempName = cmd.ExecuteScalar(); conn.Close(); if (tempName != null) { string userName = tempName.ToString(); } Regards, Iftikar

Jignesh Trivedi · Answer

hi, you mean to say, you want Id from username right? if yes than you can write following query.. select Id from Users where Username = 'test' if you look other than this please provide more information.

Database

Answers (13)