string cusql = "SELECT * FROM Amailsd WHERE SE01='" + cutoday + "' AND SE05='100帐套'"; //判断一下
DataTable dt = Maticsoft.DBUtility.DbHelperSQL.QueryDt(cusql, connectionHNERP3, 500);
引用的部分代码如下
public static DataTable QueryDt(string SQLString, string ConnectionString,int Times)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
SqlDataAdapter command = new SqlDataAdapter(SQLString, connection);
command.SelectCommand.CommandTimeout = Times;
command.Fill(ds, "ds");
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception(ex.Message);
}
return ds.Tables[0];
}
}
大神们,帮忙指点一下,非常感谢。