判断方法一:
string sqlStr = "if objectproperty(object_id('test'),'IsUserTable')=1 select 1 else select 0";
SqlCommand cmd = new SqlCommand(sqlStr, conn);
object obj= cmd.ExecuteScalar();
if (obj.ToString() == "1")
{
MessageBox.Show("该表已存在!");
}
else if (obj.ToString() == "0")
{
MessageBox.Show("该表未创建!");
}
判断方法二:
private bool IsExist(SqlConnection conn,string table)
{
//table为表名,如果存在返回true,否则返回false
string sql = "select * from sysobjects where type='U' and name='" + @table + "'";
SqlDataAdapter myAdapter = new SqlDataAdapter(sql, conn);
DataSet myDataSet = new DataSet();
myAdapter.Fill(myDataSet);
if (myDataSet).Tables[0].Rows.Count == 0){return false;}else{return true;}}
转载请标明出处
http://blog.csdn.net/jasonhds/
版权所有,翻版必究~谢谢合作