public SqlConnection conn= new SqlConnection("Data Source=;Initial
Catalog=;Integrated Security=SSPI;UserID=sa;Password=;"); ;
public SqlCommand com;
string strSql = "SELECT * FROM SahanaMusical";
conn.Open();
com = new SqlCommand(strSql, conn);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds12 = new DataSet();
da.Fill(ds12, "SahanaMusical");
dataGrid4.DataContext = ds12;
dataGrid4.ItemsSource = ds12.Tables[0].ToString();
conn.Close();
com.Dispose();
Loading
Jaish MathewsPosted Mar 30, 2010, 8:20 AM
You may missed adding below namesspace
using System.Data;
using System.Data.SqlClient;
Jitendra PatelPosted Mar 30, 2010, 7:18 AM
In your code you are not pass sqlcommand value to dataadapter.
so this errors accured.
SqlDataAdapter da = new SqlDataAdapter(com);
miss this code
da.selectcommand = com;
DataSet ds12 = new DataSet();
Try this,
Replay and if it is helpfull than marks me.
Thanks,
Jitendra Patel