Create PROCEDURE SPtblStatus
@Month varchar(50) =null
AS
BEGIN
select * from Codeproject.tblStatus where Status='Paid' and Month=@Month
select * from Codeproject.tblStatus where Status='UnPaid' and Month=@Month
END
GO
This stored procedure returns two results. get those into application.
DataSet ds = new DataSet();
using (var con = new SqlConnection("Data Source=DESKTOP-0V1BRD9;Initial Catalog=StackOverflow;Persist Security Info=True;User ID=sa;Password=sa_123+"))
using (var cmd = new SqlCommand("SPtblStatus", con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter("@Month", "Feb");
cmd.Parameters.Add(param);
da.Fill(ds);
}
if (ds.Tables.Count > 0)
{
dataGridView1.DataSource = ds.Tables[0];
dataGridView2.DataSource = ds.Tables[1];
}