Database

Tan Kai Kai

13y1.4kSQL

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?

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tan Kai Kai13y ago
I have try using that but it just do not session the ID

how can this be done after they have log in?
0
Tan Kai Kai13y ago
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

0
Sanjeeb Lenka13y ago
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"]);
0
Iftikar Hussain13y ago
how you are maintaining the current user details in your application?

Regards,
Iftikar
0
Tan Kai Kai13y ago
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
0
Iftikar Hussain13y ago
are you passing the query string value in your page like YourPage.apsx?id=1

Regards,
Iftikar
0
Tan Kai Kai13y ago
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?
0
Sanjeeb Lenka13y ago

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'
0
Iftikar Hussain13y ago
in what condition you want id and name? since there are multiple records in your table. Please provide more details.

Regards,
Iftikar
0
Tan Kai Kai13y ago
Nope I want the username and get the ID
0
Sanjeeb Lenka13y ago
select ID from TableName where Username='username you want to match'
0
Iftikar Hussain13y ago
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
0
Jignesh Trivedi13y ago
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.
0