hi all
pls help me
urgent i want this exicution program.
i wrote that code. but can't exicute.displaymember and value members see the null values.
and does not exicute that columns.pls modify and send that code.urgent insertquery.
i used four fields.
using windowsapplication datagridview.
private void button1_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);
//string strStatement = "INSERT INTO joborder_master(title,client_id,contact_id,city) VALUES("?Column1;?Column2;?Column3;?Column4")");
this insert query is the wrong.pls send that query.
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);
//if (dtbElements.Rows.Count > 0)
{
dtbElements.Columns.Add("title", typeof(String));
dtbElements.Columns.Add("client_id", typeof(String));
dtbElements.Rows.Add("001");
dtbElements.Rows.Add("002");
dtbElements.Rows.Add("003");
dtbElements.Rows.Add("004");
dtbElements.Columns.Add("contact_id", 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("city", typeof(String));
DataGridViewComboBoxColumn colComboColumn = new DataGridViewComboBoxColumn();
colComboColumn.DisplayMember = contact_id;
colComboColumn.ValueMember = client_id;
colComboColumn.DataSource = "joborder_master";
dataGridView1.Columns.Add(colComboColumn);
dataGridView1.DataSource = ds;
|
| Author: Selvakumar 12 Oct 2007 | Member Level: Gold | Rating:  Points: 2 |
colComboColumn.DataSource = dtbElements;
colComboColumn.DisplayMember = columnname in doublequote;
clComboColumn.ValueMember = columnname in doublequote;
try this and let me know if u have any problem
|
| Author: Murugesan 12 Oct 2007 | Member Level: Gold | Rating: Points: 2 |
Do u mean...... syntax error?
|
| Author: lakshmi 12 Oct 2007 | Member Level: Silver | Rating: Points: 2 |
but that not exicute.
thanks for u r reply
|
| Author: Murugesan 15 Oct 2007 | Member Level: Gold | Rating: Points: 2 |
Halo... I am nt gud in Backend and i don't knw abt performance and all... bt hope this will be usefull
SqlDataAdapter dt = new SqlDataAdapter("select * from dbtable", con);
dt.TableMappings.Add("Table", "SomeKey"); //Add custom name
DataSet ds = new DataSet();
dt.Fill(ds);
DataViewManager dv = ds.DefaultViewManager;
this.comboBox2.DataSource = dv;
this.comboBox2.DisplayMember = "SomeKey.UserName"; //SomeKey is customkey and UserName is your column name
|