string selectcom1=select sum(Inv),StaffNumber, DATEPART(year,Date) from Grawu where datepart(YEAR,[Date])='2015' group by StaffNumber, DATEPART(YEAR,[Date]) SqlCommand comm1 = new SqlCommand(selectcom1, connection); comm1.CommandType = CommandType.StoredProcedure; comm1.Parameters.AddWithValue("@year", cmbyear.SelectedItem); SqlDataReader dr1 = comm1.ExecuteReader(); if (dr1.Read()) { year = dr1["year"].ToString(); Messagebox.Show("Anwer"+ dr1["inv"].ToString()); }
string selectcom1=@"select sum(Inv),StaffNumber, DATEPART(year,Date) from Grawu where datepart(YEAR,[Date])='2015'group by StaffNumber, DATEPART(YEAR,[Date])";
string selectcom1=@"select sum(Inv) As SumOfInv, StaffNumber, YEAR([Date]) AS Year FROM Grawu WHERE YEAR([Date])=@year GROUP BY StaffNumber, YEAR([Date])";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)