Saturday, February 28, 2015

Connect to Sql Database using C#

SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=MCS000009-PC\SQL;
InitialCatalog=ExceptionDatabase; Trusted_Connection=True;";

 string query1 = "insert into ExceptionsTb(MSg,Type)  
values( '" + exdb.Message.ToString() + "',  '" + exdb.GetType().Name.ToString() + "')";
 SqlCommand cmd1 = new SqlCommand(query1, con);
  con.Open();
  cmd1.ExecuteNonQuery();
  con.Close();

No comments:

Post a Comment