M
Marc Jennings
Hi there,
I'm new to C#, and I have a small problem.
I have created a new DataSet using the code below, and I would like to
be able to populat a drop-down list with the results of the "name"
field. Can anyone help me, please?
*************************************************
string m_Connect = "Data Source=(local);integrated
security=SSPI;Initial Catalog=database_name;";
SqlConnection myConn = new SqlConnection(m_Connect);
SqlDataAdapter da = new SqlDataAdapter();
myConn.Open();
DataSet ds1 = new DataSet();
string sQueryString1 = "";
sQueryString1 = "SELECT * FROM sysobjects where type='U'";
da.SelectCommand = new SqlCommand(sQueryString1,myConn);
da.Fill(ds1, "ImportTable");
*************************************************
Thanks,
Marc.
I'm new to C#, and I have a small problem.
I have created a new DataSet using the code below, and I would like to
be able to populat a drop-down list with the results of the "name"
field. Can anyone help me, please?
*************************************************
string m_Connect = "Data Source=(local);integrated
security=SSPI;Initial Catalog=database_name;";
SqlConnection myConn = new SqlConnection(m_Connect);
SqlDataAdapter da = new SqlDataAdapter();
myConn.Open();
DataSet ds1 = new DataSet();
string sQueryString1 = "";
sQueryString1 = "SELECT * FROM sysobjects where type='U'";
da.SelectCommand = new SqlCommand(sQueryString1,myConn);
da.Fill(ds1, "ImportTable");
*************************************************
Thanks,
Marc.