public static int readCount(string Item_market, string Cat_big, string Cat_middle, string Cat_small, string Item_id, string u) { string q = @"select count(*) from dbo.Crwitem "; q += " where Item_market = '" + Item_market + "'"; q += " and Cat_big = '" + Cat_big + "'"; q += " and Cat_middle = '" + Cat_middle + "'"; q += " and Cat_small = '" + Cat_small + "'"; q += " and Item_id = '" + Item_id + "'"; Hel h = new Hel(); h.url = u; SqlCommand cmd = new SqlCommand(q); DataSet ds = h.ExecuteCommand(cmd); return(int.Parse(ds.Tables[0].Rows[0][0].ToString())); }
public static DataTable readData(string Item_market, string u) { DataTable dt = new DataTable(); string q = @"select * from dbo.Crwitem "; q += " where Item_market = '" + Item_market + "'"; //q += " and Cat_big = '" + Cat_big + "'"; //q += " and Cat_middle = '" + Cat_middle + "'"; //q += " and Cat_small = '" + Cat_small + "'"; //q += " and Item_id = '" + Item_id + "'"; Hel h = new Hel(); h.url = u; SqlCommand cmd = new SqlCommand(q); DataSet ds = h.ExecuteCommand(cmd); dt = ds.Tables[0]; return(dt); }