Click here to Skip to main content
12,951,971 members (64,424 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
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 24-Jan-13 11:05am
Updated 24-Jan-13 11:09am
CHill60189.8K
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

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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/[^]
  Permalink  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,239
CHill60 3,490
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,880


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 24 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100