C# 创建数据库 问题

来源：百度知道 编辑：UC知道 时间：2024/06/21 20:10:09
string s = "server=.:integrated security=sspi;";
try
{
SqlConnection conn = new SqlConnection(s);
conn.Open();
SqlCommand com = new SqlCommand();
com.ExecuteNonQuery();
conn.Close();
}
catch (SqlException e)
{
MessageBox.Show(e.Message.ToString());
}

高人 看看哪错了
不好意思发错了
是这个
帮忙看看
string s = "server=.:integrated security=sspi;";
try
{
SqlConnection conn = new SqlConnection(s);
conn.Open();
SqlCommand com = new SqlCommand("create database FlightDB", conn);
com.ExecuteNonQuery();
conn.Close();
}
catch(...)
{....}

你没有执行语句....执行什么??当然错了..
还有conn.Close()写错地方了.应该写在finally里.

string s = "..................";
try
{
SqlConnection conn = new SqlConnection(s);
conn.Open();
SqlCommand com = new SqlCommand("insert into ........",conn);
com.ExecuteNonQuery();
}
catch (SqlException e)
{
MessageBox.Show(e.Message.ToString());
}finally{
conn.Close();
}