22,209
社区成员
发帖
与我相关
我的任务
分享
SqlUDT mySql = SqlUDT.GetNewInstance("server=./SQLEXPRESS;" + "integrated security=SSPI;" + "Initial Catalog=AnodTestJoin;");
string strcmd = "select * where age=20 from Person";
int a =mySql.QueryData(strcmd);
MessageBox.Show(a.ToString());
public class SqlUDT
{
public static SqlUDT GetNewInstance(string strConection)
{
SqlUDT myUDT = new SqlUDT();
myUDT.Connecttion = new SqlConnection(strConection);
return myUDT;
}
private SqlTransaction mConnectTrans = null;
public SqlTransaction ConnectTrans
{
get
{
return mConnectTrans;
}
}
private SqlConnection mConnecttion = null;
public SqlConnection Connecttion
{
get
{
return mConnecttion;
}
set
{
mConnecttion = value;
}
}
public int QueryData(string strCmd)
{
if (mConnecttion.State != ConnectionState.Open)
mConnecttion.Open();//这里表示连接不上
SqlCommand cmd = new SqlCommand();
{
cmd.Connection = mConnecttion;
// cmd.Transaction = mConnectTrans;
cmd.CommandTimeout = 120;
cmd.CommandText = strCmd;
cmd.CommandType = CommandType.Text;
// cmd.Parameters
}
int n= cmd.ExecuteNonQuery();
mConnecttion.Close();
return n;
}
}
string strsource = "server=(local);" + "integrated security=SSPI;" + "database=AnodTestJoin;";
string strcmd = "select * from Person where age=20";
using (SqlConnection sql = new SqlConnection(strsource))
{
if (sql.State != ConnectionState.Open)
{
sql.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = sql;
cmd.CommandTimeout = 120;
cmd.CommandText = strcmd;
cmd.CommandType = CommandType.Text;
int n = cmd.ExecuteNonQuery();
sql.Close();
MessageBox.Show(n.ToString());