110,538
社区成员
发帖
与我相关
我的任务
分享
public static System.Data.DataSet GetDataSet(string strTableName, string strSQL, string strConnectionString)
{
System.Data.SqlClient.SqlConnection conn;
System.Data.SqlClient.SqlDataAdapter da;
System.Data.DataSet ds;
conn = new System.Data.SqlClient.SqlConnection(strConnectionString);
ds = new System.Data.DataSet();
try
{
if (conn.State == ConnectionState.Closed)
conn.Open();
da = new SqlDataAdapter(strSQL, conn);
da.Fill(ds, strTableName);
}
catch (Exception ex)
{
string x = ex.Message.ToString();
throw ex;
}
finally
{
conn.Close();
}
return ds;
}
<add key="LabellingConnString" value="server=10.18.16.1;database=测试下载;uid=sa;pwd=qaz123;Connect Timeout=5000"/>