Store procedure for desktop application

vikas kanani

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hemant Srivastava14y ago
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 Srivastava14y ago
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;
        }