how can check query is working is not in sp

Question

how can check query is working is not in sp. as like C# method of function to return value is true or false

Answer 1

code  to insert data  into table .program ask user to enter item name , id , price ,quantity .


public static void save(EntityPurchase epr)

        {

            OleDbDataAdapter da=new OleDbDataAdapter("Insert into shop values ('"+epr.Itemid+"','"+epr.Iname+"','"+epr.Quantity+"','"+epr.Price+"','"+epr.Curdate+"')",con);

            ds=new DataSet();

            da.Fill(ds,"temp");

        

        }


i have no idea about using sum clause n group by clause can you just explain it here ? any related links will be helpful

Answer 2

Could you show your code for adding 10 Car and trucks. Have you tried using sum clause and group by statement.