Hello Team,
Am trying to load data in the textbox but is like my formart is not working
private void btn_Search_Click(object sender, EventArgs e) { int i = 0; dataGridView1.Rows.Clear(); cn.Open(); cm = new SqlCommand("select PCode,ProductDate, ProductName,Category,CostPrice,Profit,SalesPrice, Tax,TotalPrice,Barcode from tblProduct where PCode like '%" + txt_SearchProduct.Text + "%'", cn); dr = cm.ExecuteReader(); while (dr.Read()) {
txt_ProductCode.Text = dr.Item("PCode"); dtProductDate.Text = dr.Item("ProductDate"); txt_Productname.Text = dr.Item("ProductName"); cbo_Category.SelectedValue = dr.Item("Category"); txt_CostPrice.Text = dr.Item("CostPrice"); txt_SalesPrice.Text = dr.Item("SalesPrice"); cbo_Tax.SelectedValue = dr.Item("Tax"); txt_TotalPrice.Text = dr.Item("TotalPrice"); txt_Barcode.Text = dr.Item("Barcode"); dr.Close(); cn.Close(); }
}