Click here to Skip to main content
15,886,519 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
C#
com = new SqlCommand();
           con = new SqlConnection(stcon);//problem here
           com.Connection = con;
           com.CommandText = "insert into client(name)values(@a)";
           com.Parameters.AddWithValue("@",name);
           try
           {
               con.Open();
               int i = com.ExecuteNonQuery();
               if (i>0)
                   con.Close();
           }
           catch(Exception ex)
           {
               throw ex;
           }
Posted
Updated 24-Jan-13 11:09am
v3
Comments
CHill60 24-Jan-13 17:11pm    
so what is your question?? If you have a problem where the comment indicates then at least tell us what stcon is set to
Zoltán Zörgő 24-Jan-13 17:14pm    
It would be better to tell us
1) what is your database server (including version)
2) your connection string (the content of "stcon")

1 solution

It would be nice if you would put the connection string in the question. However I'm willing to bet that a quick perusal of this web site will tell you everything you need to solve your problem.

Book mark it: http://www.connectionstrings.com/[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900