Populating a datagrid on a Windows form

Hi,

I'm fine using asp.net and ado.net on the web app side of things. But I have just started learning about Windows applications and nothing seems to work! Just trying to populate a simple datagrid now seems impossible. There now does not appear to be the .DataBind or .DataKeyField methods??
My code is as follows:

private void button1_Click_1(object sender, System.EventArgs e)

{

SqlConnection myConnection = new SqlConnection ();

myConnection.ConnectionString = "server=myserver.com;database=myName;uid=sa;pwd=pwd3";

SqlCommand cmdDisplayStudent = new SqlCommand ("DisplayStudentsSingleCol",myConnection);

cmdDisplayStudent.CommandType = CommandType.StoredProcedure;

SqlDataAdapter myAdapter = new SqlDataAdapter ();

DataSet ds = new DataSet();

myConnection.Open();

myAdapter.Fill(ds);

this.dataGrid1.DataSource = ds;

this.dataGrid1.DataMember = "StudentID";

}

But how do I finish it off? Can anyone please help?

Many thanks,
James

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

James20y ago
Yes it works fine now - many thanks!
Edgar Santos20y ago
you have to associate the myAdapter with the cmdDisplayStudent , i think its something like myAdapter.selectcommand = cmdDisplayStudent , something like that. Secondly , i don't know what you mean by "DisplayStudentsSingleCol" , this supposely would be a sql select command? the rest seems ok , if you need further help, contact me in MSN Messenger, [email protected].