怎么用C#取到select count(*) from master..sysdatabases where name in('PengclDB')的返回值做判断呢
怎么用C#取到select count(*) from master..sysdatabases where name in( 'PengclDB ')的返回值做判断呢 谁能给我一个小例子
[解决办法]
int.ret = (int)cmd.ExecuteScalar();
if(ret > 1)
{
}
[解决办法]
点击管理
给分之后 输入密码 确定
[解决办法]
string sql = "INSERT INTO Production.ProductCategory (Name) VALUES (@Name); "
+ "SELECT CAST(scope_identity() AS int) ";
SqlConnection conn = new SqlConnection(connString)
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add( "@Name ", SqlDbType.VarChar);
cmd.Parameters[ "@name "].Value = newName;
try
{
conn.Open();
newProdID = (Int32)cmd.ExecuteScalar();
if(newProdID> 1)
{
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
[解决办法]
int RecordCount=(int)cmd.ExecuteScalar();
