You haven't set Command.Connection Property.
On Feb 16, 9:27 am, Sunilsingh <[email protected]> wrote: > Hi Santosh > Try this > > try > { > con = new SqlConnection(); > con.ConnectionString = "Data Source=santhosh;Initial > Catalog=ecop;User ID=sa;Password=test"; > con.Open(); > SqlCommand cmd = new SqlCommand(); > *cmd.connection = con;// new line inserted* > cmd.CommandText="INSERT INTO > com(st_id,name,addres,phone, > > > > > > > ct_type,brief_incident,suspect,date,time) > > > VALUES(@st_id,@name,@addres,@phone,@ct_type,@brief_incident,@suspect,@date,@time)"; > > cmd.Parameters.Add(new > > SqlParameter("@st_id",DropDownList1.SelectedValue)); > > cmd.Parameters.Add(new SqlParameter("@name",TextBox1.Text)); > > cmd.Parameters.Add(new SqlParameter("@addres",TextBox2.Text)); > > cmd.Parameters.Add(new SqlParameter("@phone",TextBox3.Text)); > > cmd.Parameters.Add(new > > SqlParameter("@ct_type",DropDownList2.SelectedItem)); > > cmd.Parameters.Add(new > > SqlParameter("@brief_incident",TextBox6.Text)); > > cmd.Parameters.Add(new > > SqlParameter("@suspect",TextBox4.Text)); > > cmd.Parameters.Add(new SqlParameter("@date",TextBox5.Text)); > > cmd.Parameters.Add(new SqlParameter("@time",TextBox7.Text)); > > *// SqlDataReader dr = cmd.ExecuteReader();* > > *int i =cmd.ExecuteNonQuery(); > if(i=0) > { > //not inserted} > > * > *else > { > //inserted}* > *con.close()*; > } > > *catch > { > con.close(); > > }* > > Thanks and Regards > Sunilsingh Bhadoria > Cell Number: +91 9922755668 > > On Sun, Feb 14, 2010 at 9:30 PM, santhoshvkumar > <[email protected]>wrote: > > > Hi All, > > For more than two days I m trying this problem. Some one > > please help me out. My scenario is I want to directly insert data into > > my table from the input which I get it from text boxes. Here is my > > code... > > > con = new SqlConnection(); > > con.ConnectionString = "Data Source=santhosh;Initial > > Catalog=ecop;User ID=sa;Password=test"; > > con.Open(); > > SqlCommand cmd = new SqlCommand(); > > cmd.CommandText="INSERT INTO > > com(st_id,name,addres,phone,ct_type,brief_incident,suspect,date,time) > > > VALUES(@st_id,@name,@addres,@phone,@ct_type,@brief_incident,@suspect,@date,@time)"; > > cmd.Parameters.Add(new > > SqlParameter("@st_id",DropDownList1.SelectedValue)); > > cmd.Parameters.Add(new SqlParameter("@name",TextBox1.Text)); > > cmd.Parameters.Add(new SqlParameter("@addres",TextBox2.Text)); > > cmd.Parameters.Add(new SqlParameter("@phone",TextBox3.Text)); > > cmd.Parameters.Add(new > > SqlParameter("@ct_type",DropDownList2.SelectedItem)); > > cmd.Parameters.Add(new > > SqlParameter("@brief_incident",TextBox6.Text)); > > cmd.Parameters.Add(new > > SqlParameter("@suspect",TextBox4.Text)); > > cmd.Parameters.Add(new SqlParameter("@date",TextBox5.Text)); > > cmd.Parameters.Add(new SqlParameter("@time",TextBox7.Text)); > > SqlDataReader dr = cmd.ExecuteReader();------> In this > > particular line I m getting Connection property has not been > > initialized. > > > some one help me out to get ride of this problem... > > > With Regards, > > Santhosh V Kumar
