通过本文主要向大家介绍了c#asp.net视频教程,c#和asp.net的区别,c#asp.net教程,c#asp.net,c#和asp.net的关系等相关知识,希望对您有所帮助,也希望大家支持linkedu.com www.linkedu.com
//实例化sql连接
SqlConnection conn = new SqlConnection("server=.; database=dbName; uid=sa; pwd=sa");
conn.Open();
//实例化sql命令
SqlCommand cmd = new SqlCommand(sqlStr, conn);
//执行sql命令
cmd.ExecuteNonQuery();
//关闭连接
conn.Close();
</div>
我的代码：
sqlStr += "num int,";
sqlStr += "Colour varchar(50),";
sqlStr += "Other varchar(50),";
sqlStr += " )";
//实例化sql连接
string sss = "Data Source=(local);Initial Catalog=" + dataconnect + ";Integrated Security=True";
SqlConnection conn = new SqlConnection(sss );
conn.Open();
//实例化sql命令
SqlCommand cmd = new SqlCommand(sqlStr, conn);
//执行sql命令
cmd.ExecuteNonQuery();
//关闭连接
conn.Close();
</div>