G
Guest
Hi..
I need to diplay a single record from mysqldb..'
i just create the dataset...
-----------------------
myConnectionString = "Database=altia;Data Source=development;User
Id=root;Password=citranet";
string mySelectQuery = "select * from tbluser where (txtUserName = '" +
TextBox1.Text + "')";
MySqlConnection myConnection = new MySqlConnection(myConnectionString);
MySqlDataAdapter myrecord = new MySqlDataAdapter(mySelectQuery,myConnection);
myConnection.Open();
ds = new DataSet();
ds.Tables.Add("tbluser");
logaccess = myrecord.Fill(ds,"tbluser").ToString();
//i try this but it return 1 as it is a single
record
Label1.Text = //this is the place that i need the data to display
myConnection.Close();
Please help...
I need to diplay a single record from mysqldb..'
i just create the dataset...
-----------------------
myConnectionString = "Database=altia;Data Source=development;User
Id=root;Password=citranet";
string mySelectQuery = "select * from tbluser where (txtUserName = '" +
TextBox1.Text + "')";
MySqlConnection myConnection = new MySqlConnection(myConnectionString);
MySqlDataAdapter myrecord = new MySqlDataAdapter(mySelectQuery,myConnection);
myConnection.Open();
ds = new DataSet();
ds.Tables.Add("tbluser");
logaccess = myrecord.Fill(ds,"tbluser").ToString();
//i try this but it return 1 as it is a single
record
Label1.Text = //this is the place that i need the data to display
myConnection.Close();
Please help...