110,535
社区成员
发帖
与我相关
我的任务
分享
string sqlSelectOwn = string.Format("select * from table where workname='航空' and name='{0}'", uid);
DataTable dtOwnResult = Common.SqlHelper.ExecuteDt(sqlSelectOwn);
//获取链接
public static String GetSqlConnection()
{
String conn = ConfigurationManager.ConnectionStrings["connection"].ToString();
return conn;
}
//查询
public static DataTable ExecuteDt(String Sqlstr)
{
String ConnStr = GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
SqlDataAdapter da = new SqlDataAdapter(Sqlstr, conn);
DataTable dt = new DataTable();
conn.Open();
da.Fill(dt);
conn.Close();
return dt;
}
}
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText=Sqlstr;
SqlDataAdapter da = new SqlDataAdapter(cmd);
下面的还是按照之前的那样去写