DataGridViewRow using Dataset

[C Coudou]

Dudes, Is it possible to show the data in datagridviewrow /datagridview using the dataset(not using the wizard). ex. DataSet ds; ds = new DataSet(); ... if it is. can you give me the order of codings. thanks u so much, jeof

****************************** I just want to know everything

[Assaf82]

Just give the dtg.. the DataSource and DataMember "dtgCreditInfo.DataSource = ds; dtgCreditInfo.DataMember = "TableName";"

Assaf

[C Coudou]

thanks assaf for your quick reply. one more thing. what should i put in datagrid. ex. (i used this using textbox) txtUsrName_pca.Text = dataSet.Tables[0].Rows[0][3].ToString(); in datagrid, what will i used? is it the same?

****************************** I just want to know everything

[T EDY]

YourDataGridName.DataSource = YourDataSet; Try this for example : dgvAllData.DataSource = myDataSet; dgvAllData.DataMember = "ID"; Hope can help

Regards, Tomi

[C Coudou]

thanks tomi, should i still use Fill method right. heres my new code: adp = new SqlDataAdapter(cmd); ds = new DataSet(); <- should i comment this line? dtg.DataSource = ds; dtg.DataMember = "M_CUSTOMER"; adp.Fill(ds); btw, i dont want to use statement in my code.

****************************** I just want to know everything

[Assaf82]

in yur code you assign a value for the txt... from the dataset if you want the to do the same from the datagrid: txtUsrName_pca.Text = dtg.Rows[i].Cells["CreditCardOwner"].Value.ToString();

Assaf

[C Coudou]

thanks assaf,

Assaf82 wrote:

from the dataset if you want the to do the same from the datagrid: txtUsrName_pca.Text = dtg.Rows[i].Cells["CreditCardOwner"].Value.ToString();

yes. i got it. ;)whew:doh:

****************************** I just want to know everything

[Assaf82]

you're welcome

Assaf

[C Coudou]

hi assaf, got an error when compiling. 'System.ArgumentException' in this line adp = new SqlDataAdapter(cmd); ds = new DataSet(); dtg.DataSource = ds; dtg.DataMember = "M_CUSTOMER"; --> got an error here! adp.Fill(ds);

****************************** I just want to know everything

[Assaf82]

This Exception here mean that the table "M_CUSTOMER" doesn't belong to the dataset "ds" So verify when you run the program that the dataset contain this table and check his Name hope that this help you ...

Assaf