22,301
社区成员




DBCC SHRINKDATABASE('test')
BACKUP DATABASE test TO disk = 'c:\test.db.config'
var conn = new SqlConnection("");
conn.InfoMessage += new SqlInfoMessageEventHandler(conn_InfoMessage);
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "Print 1";
cmd.ExecuteNonQuery();
}
void conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
MessageBox.Show(e.Message);
}
SqlCommand cmd = CreateSqlComand(CommandText, ParamValues, Conn);
cmd.Connection.Open();
string r = "";
if (cmd != null)
{
SqlDataReader sr = cmd.ExecuteReader();
while (sr.Read())
{
for (int i = 0; i < sr.FieldCount; i++)
{
r += i + "." + sr[i].ToString() + "|";
}
}
}
cmd.Connection.Close();
return r;
读出来的并没有文本信息,不知道原因何在,楼上的兄台提供的是PHP的 ,不知道是不是不SQL的,还是MySQL