Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Monday, 23 September 2013

GET VALUE FROM A STORED PROCEDURE


In web config :
Data source--DatabaseServerName
Initial Catalog--Database Name


<connectionStrings>
   
   <add name="ConnectionStringdb" connectionString="Data Source=ANURAG-PC\SQLEXPRESS;Initial Catalog=anurag;Integrated Security=True;" providerName="System.Data.SqlClient" />
   
 </connectionStrings>


==============================================









==============================================

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.IO;
using System.Data;
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!((Page)System.Web.HttpContext.Current.CurrentHandler).IsPostBack)
        {

            string strcon = ConfigurationManager.ConnectionStrings["ConnectionStringdb"].ConnectionString;
            SqlConnection con = new SqlConnection(strcon);
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            con.Open();
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection = con;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "dis";

                // Define the data adapter and fill the dataset 
                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    da.Fill(dt);
                }
            }
            GridView1.DataSource = dt.DefaultView;
            GridView1.DataBind();       
        }
    }
       
        
        
}














No comments:

Post a Comment