try { string strsql="BACKUP DATABASE test TO DISK = 'g:\baktest.mdf'"; sqlcomm=new SqlCommand (strsql,sqlconn); sqlcomm.CommandType=CommandType.Text ; sqlcomm.ExecuteNonQuery(); } catch(Exception ex) { MessageBox .Show (ex.Message ); }
string strsql="BACKUP DATABASE test TO DISK = 'g:\baktest.mdf'"; sqlcomm=new SqlCommand (strsql,sqlconn); sqlcomm.CommandType=CommandType.Text ;//这行有何意义? sqlcomm.ExecuteNonQuery(); //加上这行
{
string strsql="BACKUP DATABASE test TO DISK = 'g:\baktest.mdf'";
sqlcomm=new SqlCommand (strsql,sqlconn);
sqlcomm.CommandType=CommandType.Text ;
sqlcomm.ExecuteNonQuery();
}
catch(Exception ex)
{
MessageBox .Show (ex.Message );
}
sqlcomm=new SqlCommand (strsql,sqlconn);
sqlcomm.CommandType=CommandType.Text ;//这行有何意义?
sqlcomm.ExecuteNonQuery(); //加上这行
记着如果想还原数据库的话,要连接到master数据库