110,534
社区成员
发帖
与我相关
我的任务
分享
//返回查询到的数据集
public static DataSet ExecuteQuery(string strSQL)
{
try
{
DataSet ds = new DataSet();
String strConnect = "Data Source=XIAOCUI2007\\MSSQLSERVER08;Initial Catalog=WaterSediDyMonit_YellowRiver;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(strConnect);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
da.Fill(ds);
conn.Close();
return ds;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "警告!");
//终止该操作怎么写?但是还要写返回值怎么办?这个函数必须有返回值
}
//调用
private void btExecuteQuery_Click(object sender, EventArgs e)
{
DataSet ds = ExecuteQuery(strSQL);
//操作
}
public static DataSet ExecuteQuery(string strSQL)
{
DataSet ds = new DataSet();
String strConnect = "Data Source=XIAOCUI2007\\MSSQLSERVER08;Initial Catalog=WaterSediDyMonit_YellowRiver;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(strConnect);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
da.Fill(ds);
conn.Close();
return ds;
}
//调用
private void btExecuteQuery_Click(object sender, EventArgs e)
{
try {
DataSet ds = ExecuteQuery(strSQL);
}
catch(Exception MyEx) {
//PageHelper.ShowExceptionMessage(MyEx);这是我们的处理
MessageBox.Show(ex.ToString(), "警告!");
}
}