110,535
社区成员
发帖
与我相关
我的任务
分享
static DataView getdv(string SQLText)
{
string strconn = System.Configuration.ConfigurationManager.AppSettings["kdatastrconn"];
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlCommand mCommand = new SqlCommand(SQLText, conn);
mCommand.CommandType = CommandType.Text;
mCommand.CommandText = SQLText;
mCommand.CommandTimeout = 3600;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
adapter.SelectCommand = mCommand;
adapter.Fill(ds, "t1");
conn.Close();
return ds.Tables[0].DefaultView;
}