anurag guhe

anurag guhe

  • NA
  • 43
  • 6.7k

retriving data in griedviewtextboxcolumn

Aug 2 2016 9:49 AM
i am developing windows form and in that windows form i have 1 button  1 griedview & within griedview 1 griedviewcomboboxcolumn & 1 griedviewtextboxcolumn ..i am sucessfully retriving data in griedviewcomboboxcolumn from sql  but when i am selecting name from griedviewcomboboxcolumn it does not retriving the price in griedviewtextboxcolumn so how i can solve these problem can any one help me following is the sucessful  code for retriving data in griedviewcomboboxcolumn
 
private void fillcombo()
{
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
string sql = ("SELECT Service_Name from Customer_Services");
cmd = new SqlCommand(sql, con);
adapter.SelectCommand = cmd;
adapter.Fill(ds);
dt = ds.Tables[0];
ArrayList row = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
row.Add(dr["Service_Name"].ToString());
}
Service_Name.Items.AddRange(row.ToArray());
}
 
private void entery_level_Load(object sender, EventArgs e)
{
fillcombo();
 }

Answers (2)