C#连接SQL Server2012并执行插入数据的方法

it2024-07-09  39

C#连接SQL Server2012,并向表插入数据。使用ExecuteReader()方法。具体实例如下:

/// <summary> /// 执行SQL语句,插入一条数据 /// </summary> public void Insert(string SQLString) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"].ToString())) { using (SqlCommand cmd = new SqlCommand(SQLString, connection)) { try { connection.Open(); cmd.ExecuteReader(); } catch (System.Data.SqlClient.SqlException E) { connection.Close(); throw new Exception(E.Message); } } } }
最新回复(0)