Get data from Sql Stored Procedure to grid view control using c#


1. Create stored procedure in sql server with select query (with or with out input parameters).
2. Create windows application or web application in VS 2010.

private void btnGetData_Click(object sender, EventArgs e)
        {
            dataGridView1.DataSource = GetData();
          

        }


public static SqlConnection NewConnection()
        {
            string ConnectionString = @"server=*****; uid=***; pwd=****;                  database=*****;";
            return new SqlConnection(ConnectionString);
        }


public static DataTable ExecuteCommand(SqlCommand cmd)
        {
            try
            {
                var da = new SqlDataAdapter(cmd);
                var dt = new DataTable();
                da.Fill(dt);
                return dt;
            }
            catch (SqlException ex)
            {
                throw new Exception(ex.Message);
            }
        }


public DataTable GetData()
        {
         
            try
            {
                SqlConnection con = NewConnection();
                string CommandText = "sp_EmployeeProcedure";
                SqlCommand cmd = new SqlCommand(CommandText, con) 
                { CommandType = CommandType.StoredProcedure };
                var myCi = new CultureInfo("en-US");
//if your procedure has any input parameters use this commented code.                
//cmd.Parameters.Add("@processType", SqlDbType.VarChar).Value = processType;               
                return ExecuteCommand(cmd);

            }
            catch (Exception ex)
            {
                ex.Message.ToString();

                return null;
            }
        }




!!!Please give your comments back on this.

Comments

Post a Comment

Popular posts from this blog

Sending email using Powershell script

Image
 Below is a script that can be used to send email using Powershell. If ((Get-PSSnapIn -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null )   { Add-PSSnapIn -Name Microsoft.SharePoint.PowerShell } $currentDate = Get-Date -Format g $HeaderOne $HeaderTwo $HeaderThree $HeaderFour $Outputreport = "<HTML><TITLE> Test E-Mail notification </TITLE> <head> <style>body {font-family: Calibri;font-size: 14px;}table {border-collapse: collapse;}table, th, td {border: 1px solid black;font-family: Calibri,Verdana;font-size: 14px;}th {background-color: #4CAF50;color:white;}</style></head>                      <BODY>                                           <H2> Test E-Mail notification on $($currentDate) CET </H2>  ...
Read more

Convert List Collection to DataTable using C#

public System.Data.DataTable ConvertToDataTable<T>(IList<T> data)         {             PropertyDescriptorCollection properties =                TypeDescriptor.GetProperties(typeof(T));             System.Data.DataTable table = new System.Data.DataTable();             foreach (PropertyDescriptor prop in properties)                 table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);             foreach (T item in data)             {                 DataRow row = table.NewRow();                 foreach (PropertyDescriptor prop in properties)                ...
Read more

Difference Between Site Template and Site Definition

Difference Between Site Template and Site Definition Before going into direct comparison, let me define both: Site Templates  : Are  snapshots of  sites at a point in time. When a user customizes a site from the UI or SPD, the custom template consists of the difference between the original state of the site (determined by its definition) and the state of the site or list when the custom template is generated. Custom templates remain tied to a particular site definition (for example, the site definition for SharePoint Web sites or Meeting Workspace Web sites), so that if the site definition is not present or is changed, the custom template cannot work. Site Definitions  : As the name implies, A Site definition is "core definition of a site”. Each site definition emerges through a combination of files that are placed in the 12 hive of WFE during installation of SharePoint. Site definition files include .xml, .aspx, .ascx, and .master page files, as well as docum...
Read more