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

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

Delete multiple site collections using SharePoint Power Shell Script

This script will delete site collections from the SharePoint server completely. But we need to provide the site collection names to the Power Shell Script as a ";" separated values. Power Shell Script: Ex: $SiteCollection =  "http://SP-S2010/sites/TeamSite1;http://SP-S2010/sites/TeamSite2"  $SiteCollection = "http://SP-S2010/sites/TeamSite1;http://SP-S2010/sites/TeamSite2"  $SiteArray = $SiteCollection.Split(";") foreach($Site in $SiteArray)  {       Remove-SPSite –Identity $Site –GradualDelete –Confirm:$False }
Read more

Managed Metadata Configuration and Association

Image
Introduction Managed Metadata is a hierarchical collection of terms that can be associated with items in SharePoint 2010. We can use Central Administration website to manage these terms. This is a new feature in SharePoint 2010. Example : You have a document library to upload articles.  For each item you can specify a column metadata of category like C#, ASP.NET etc. The Purpose So you might be wondering that there exist list columns for the same purpose.  Following are some advantages provided by Managed Metadata: Term Sets can be shared across a site collection or globally Searching using Metadata gives more relevant result Some Concepts inside Managed Metadata Term : A term is keyword that can be associated with a SharePoint item. Term Set : A term set is a group of terms.  You can restrict that a particular item should contain a term from a particular term set.  For example: setting the category of an article item from term set [C#, ASP.N...
Read more