Store procedure for desktop application

Question

ALTER procedure [dbo].[one_mnth_ago]
as

DECLARE @StartDate DATETIME, @EndDate DATETIME
SET @StartDate = dateadd(mm, 0, getdate())
SET @StartDate = dateadd(dd, datepart(dd, getdate())*0, @StartDate)
SET @EndDate = dateadd(mm, 1, @StartDate)

begin

SELECT *
FROM installation
WHERE warranty_expry_date BETWEEN @StartDate AND @EndDate
end

how to run this procedure in desktop application.and retrieve data in gridview

Hemant Srivastava · Answer

To bind this result into data grid, you need to just bind the data table as a data source of your datagridView control. DataTable dt = new DataTable(); dt = GetDataFromDatabase(); dataGrid1.DataSource = dt; Please make it as an accepeted answer, if it helps you .

Hemant Srivastava · Answer

Here is the code that gets the data from database using store proc "one_mnth_ago", that stores the retrieved data in a data table: public DataTable GetDataFromDatabase() { DataTable dt = new DataTable(); string passingParameter1 = string.Empty; try { using (SqlConnection oSqlConnection = new SqlConnection(sLocalCenterDbConnectionString)) { oSqlConnection.Open(); using (SqlCommand oSqlCommand = new SqlCommand("one_mnth_ago", oSqlConnection)) { using (DataSet ds = new DataSet()) { using (SqlDataAdapter sqlAdapter = new SqlDataAdapter(oSqlCommand)) { sqlAdapter.Fill(ds); } int iCount = ds.Tables[0].Rows.Count; if (iCount > 0) { dt = ds.Tables[0]; } } } oSqlConnection.Close(); } } catch (Exception Ex) { throw Ex; } return dt; }

Store procedure for desktop application

Answers (2)