dataset error Solved/Closed

Question

Hello,
sir .....
          SqlConnection con = new SqlConnection(@"Server=ASHOK\MYSQLSERVER;Database=sample;Trusted_Connectopn=True");
            SqlCommand cmd = new SqlCommand("insert into emp values("+this.TextBox1 .Text+",'"+this.TextBox2.Text+"',"+this.TextBox3 .Text +")",con);
            con.Open();
            DataSet ds = new DataSet(cmd,con);
            SqlDataAdapter da = new SqlDataAdapter();
            da.Fill(ds);
            con.Close(); 
the error message is:Error	1	The best overloaded method match for 'System.Data.DataSet.DataSet(System.Runtime.Serialization.SerializationInfo, System.Runtime.Serialization.StreamingContext)' has some invalid arguments	C:\ashok\SampleApp1\SampleApp1\WebForm2.aspx.cs	26	26	SampleApp1
                              Error	2	Argument '1': cannot convert from 'System.Data.SqlClient.SqlCommand' to 'System.Runtime.Serialization.SerializationInfo'	C:\ashok\SampleApp1\SampleApp1\WebForm2.aspx.cs	26	38	SampleApp1
                            Error	3	Argument '2': cannot convert from 'System.Data.SqlClient.SqlConnection' to 'System.Runtime.Serialization.StreamingContext'	C:\ashok\SampleApp1\SampleApp1\WebForm2.aspx.cs	26	42	SampleApp1
                The above three error I cant find the error please help me sir .........................

abdul · Answer

SqlConnection con = new SqlConnection(@"Server=ASHOK\MYSQLSERVER;Database=sample;Trusted_Connectopn=True"); 
SqlCommand cmd = new SqlCommand("insert into emp values("+this.TextBox1 .Text+",'"+this.TextBox2.Text+"',"+this.TextBox3 .Text +")",con); 
con.Open(); 
DataSet ds = new DataSet(); 
SqlDataAdapter da = new SqlDataAdapter(cmd); 
da.Fill(ds); 
con.Close();

abdul · Answer

SqlConnection con = new SqlConnection(@"Server=ASHOK\MYSQLSERVER;Database=sample;Trusted_Connectopn=True"); 
SqlCommand cmd = new SqlCommand("insert into emp values("+this.TextBox1 .Text+",'"+this.TextBox2.Text+"',"+this.TextBox3 .Text +")",con); 
con.Open(); 
DataSet ds = new DataSet();                  //check it out 
SqlDataAdapter da = new SqlDataAdapter(cmd); // check it out too 
da.Fill(ds); 
con.Close();

Ambucias · Answer

Hello Abdul,

You have posted your solution twice.  I guess that you were waining for a reply from the person who posted the question.

Have you noticed that the initial question was posted on March 3, 2010?  That is the reason why you did not receive a thank you note.

However, I will thank you for your contribution.  I will also have the thread marked as solved.  It will remain on the forum for years to come.

If there further questions or gratitude marks, you will receive them here and through your e-mail.

Thank you again for helping

My very best regards

Dataset error

3 responses

Similar discussions

Subscribe To Our Newsletter!