读书人

如何用C#取到select count(*) from ma

发布时间: 2012-02-12 17:16:33 作者: rapoo

怎么用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();

读书人网 >C#

热点推荐