110,571
社区成员
发帖
与我相关
我的任务
分享
DbProviderFactory provider = DbProviderFactories.GetFactory(...);
Public DbCommand GetCommand(sring strSql)
{
using(DbConnection conn = provider.CreateConnection())
{
conn.connection = connectionString;
conn.Open();
try
{
DbCommand cmd=provider.CreateCommand();
cmd.Connection = conn;
cmd.CommandText= strSql;
cmd.CommandType=CommandType.Text;
return cmd;
}
catch(DbException e)
{
conn.Close();
conn.Dispose();
throw new Exception(e.Message);
}
}
}