get another table column value on gridview click event.

vishnu vardhan

i have a form with gridview and textbox in gridview i have table(bookmaster) data. now if i click on gridview row the respective book id book stock should be displayed in the textbox. but my problem is bookstock column is available in another table i.e bookstock. so how to retrieve that data in click event??

2 Replies

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

vishnu vardhan12y ago
Thanks For ur Reply Priti

But i got it without Join see my code here ....

private void DGVBooks_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
MySqlConnection Con = new MySqlConnection(MyConString);
MySqlCommand Cmd = Con.CreateCommand();
string S="SELECT Quantity_Available FROM bookshop.bookstockWHERE Book_Id='"+this.DGVBooks.CurrentRow.Cells[0].Value.ToString()+"'";
Cmd = new MySqlCommand(S, Con);
MySqlDataReader Dr;
try
{
Con.Open();
Dr = Cmd.ExecuteReader();
while (Dr.Read())
{
string Quantity = Dr.GetInt32("Quantity_Available").ToString();
txtStock.Text = Quantity;
}

}
catch (Exception ex)
{

MessageBox.Show(ex.Message);
}
txtStock.Enabled = false;
}

Thanks
Priti Kumari12y ago
You have to apply join between Bookmaster table and Bookstock table on the basis of book id in sql query.