110,502
社区成员
发帖
与我相关
我的任务
分享
public static byte[] getDataSetBySQL(string[] sqlstr, string[] namestr)//返回一個可以包括多個表的序列化並加壓後的數據集,
{
SqlConnection conn = new SqlConnection(connstring);//connsting中有timeoute=0;
conn.Open();
DataSet DS = new DataSet();
try
{
for (int i = 0; i < sqlstr.Length; i++)
{
SqlDataAdapter DA = new SqlDataAdapter(sqlstr[i], conn);
DA.Fill(DS, namestr[i]);
}
return SerializationDataset(DS);
}
catch
{
return null;
}
finally
{
conn.Close();
}
}
SqlCommand cmd = new SqlCommand(sqlstr[i], conn);
cmd.CommandTimeout = 10000000;
SqlDataAdapter DA = new SqlDataAdapter(cmd);
public static byte[] getDataSetBySQL(string[] sqlstr, string[] namestr)//返回一個可以包括多個表的序列化並加壓後的數據集,
{
SqlConnection conn = new SqlConnection(connstring);
conn.Open();
string s = conn.ConnectionTimeout.ToString();
DataSet DS = new DataSet();
try
{
for (int i = 0; i < sqlstr.Length; i++)
{
SqlCommand cmd = new SqlCommand(sqlstr[i], conn);
cmd.CommandTimeout = 10000000;
SqlDataAdapter DA = new SqlDataAdapter(cmd);
DA.Fill(DS, namestr[i]);
}
return SerializationDataset(DS);
}
catch
{
return null;
}
finally
{
conn.Close();
}
}