The SelectCommand property has not been initialized before calling “Fill

Question

Anonymous User · Answer

Hi,adp.fill(ds); will take care of every thing.Remove cmd.ExecuteNonQuery();.try as followingtry{ SqlConnection cn = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\MANTHAN\Documents\Visual Studio 2010\WebSites\sample\App_Data\Database.mdf;Integrated Security=True;User Instance=True"); SqlCommand cmd = new SqlCommand("SELECT * FROM stu1", cn); SqlDataAdapter adp = new SqlDataAdapter(cmd); //cmd.Executenonquery(); removed DataSet ds = new DataSet(); adp.Fill(ds); GridView1.DataSource = ds.Tables[0];} catch(exception ex) { Messagebox.show(ex.Message); }I hope it helpful for you.

forum

The SelectCommand property has not been initialized before calling “Fill

Can you answer this question?

1 Answers