to add datagridview columns to another table using windowsapplications.

[anureddy]

help me
how to add datagridview columns to another table,using windowsapplications.
and set the displaymember and value member datagridviewcomboboxcolumn.

i used this below code but that not exicute.
how can i write that code.
pls send me code.



private void add_Click(object sender, EventArgs e)
{
MySqlConnection cn = new MySqlConnection("Data Source=localhost;Database=newdem;User ID=root;Password=root;");
cn.Open();
JoborderMaster jomobj = new JoborderMaster(true);
jomobj.Orderid = Convert.ToInt32(orderid);
MySqlDataAdapter dbaElements = new MySqlDataAdapter("select * from joborder_master", cn);
DataSet ds = new DataSet();
dbaElements.Fill(ds, "joborder_master");
DataTable dtbElements = new DataTable();
dtbElements = jomobj.SelectOne();
ds.Tables.Add(dtbElements);
{
dtbElements.Columns.Add("type_id", typeof(String));

dtbElements.Rows.Add("001");
dtbElements.Rows.Add("002");
dtbElements.Rows.Add("003");
dtbElements.Rows.Add("004");

dtbElements.Columns.Add("type", typeof(String));


dtbElements.Rows.Add("001", "aaa");

dtbElements.Rows.Add("002", "bbb");

dtbElements.Rows.Add("003", "ccc");

dtbElements.Rows.Add("004", "ddd");


dtbElements.Columns.Add("title", typeof(String));
dtbElements.Columns.Add("state", typeof(String));
dtbElements.Columns.Add("city", typeof(String));

DataGridViewComboBoxColumn colComboColumn = new DataGridViewComboBoxColumn();

colComboColumn.Name = type_id;
colComboColumn.DisplayMember = type;

colComboColumn.ValueMember = type_id;

colComboColumn.DataSource = "joborder_master";

dataGridView1.Columns.Add(colComboColumn);
dataGridView1.DataSource = ds;

}