我要实现的功能是 取出supportID为1的所有行集合中的goodsN文本字段中的最大值,系统调试时提示val是不可识别的函数,请问各位大大如何解决
SqlConnection conn;
conn = new SqlConnection("Server=localhost; Uid=sa;pwd=sa; database=byproduct");
conn.Open();
//insert sql
string chek = "select max(Conversion.Val(goodsN)) as b from table where supportID ="1""; SqlDataAdapter dk = new SqlDataAdapter();
dk.SelectCommand = new SqlCommand();
dk.SelectCommand.Connection = conn;
dk.SelectCommand.CommandText = chek;
DataSet myDataset = new DataSet();
dk.Fill(myDataset, "table");
string hh = myDataset.Tables["SellingWaste_Info"].Rows[0]["b"].ToString().Trim();
SqlConnection conn;
conn = new SqlConnection("Server=localhost; Uid=sa;pwd=sa; database=byproduct");
conn.Open();
//insert sql
string chek = "select max(Conversion.Val(goodsN)) as b from table where supportID ="1""; SqlDataAdapter dk = new SqlDataAdapter();
dk.SelectCommand = new SqlCommand();
dk.SelectCommand.Connection = conn;
dk.SelectCommand.CommandText = chek;
DataSet myDataset = new DataSet();
dk.Fill(myDataset, "table");
string hh = myDataset.Tables["SellingWaste_Info"].Rows[0]["b"].ToString().Trim();
但是为什么在C#中不可以呀,先谢谢大家关心了
但是
string hh 无法读出数值, 估计myDataset.Tables[ "SellingWaste_Info "].Rows[0][ "b "].ToString().Trim()有错;
改为Tables[0]
用下面的代码,不知可否 SqlDataAdapter dk = new SqlDataAdapter();
dk.SelectCommand = new SqlCommand();
dk.SelectCommand.Connection = conn;
dk.SelectCommand.CommandText = chek;
DataSet myDataset = new DataSet();
dk.Fill(myDataset, "table ");
string hh = myDataset.Tables[ "table"].Rows[0][ "maxb "].ToString().Trim();
但是我写成 string chek = "DECLARE @supportor INT select max(cast(goodsN as Int)) as b from table where 供应商ID = @supportor";
-------中间省略
SqlParameter parm7 = new SqlParameter("@supportor", SqlDbType.Int);
parm7.Value = (string)Application["ID"];
hh就不能通过text文本框显示了