ASP.NET

DropdownList DataBinding

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2008

Posts: 324

Reputation: sonia sardana has a little shameless behaviour in the past

Solved Threads: 7

sonia sardana sonia sardana is offline

Offline

Posting Whiz

DropdownList DataBinding

-1

Oct 23rd, 2009

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
<connectionStrings>
    <add name="ConnectionString" connectionString="Data Source=(local);Initial catalog=sonia;User ID=sonia;Password=sonia;" providerName="System.Data.SqlClient"/>
  </connectionStrings>
<connectionStrings>
    <add name="ConnectionString" connectionString="Data Source=(local);Initial catalog=sonia;User ID=sonia;Password=sonia;" providerName="System.Data.SqlClient"/>
  </connectionStrings>

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
public partial class Frmgrid : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
    SqlDataAdapter da;
    DataSet ds;
 
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            da = new SqlDataAdapter("SELECT * FROM Products", conn);
            da.Fill(ds, "tb1");
            DropDownList1.DataSource = ds.Tables["tb1"];
            DropDownList1.DataBind();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message.ToString());
        }
    }        
}
public partial class Frmgrid : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
    SqlDataAdapter da;
    DataSet ds;

    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            da = new SqlDataAdapter("SELECT * FROM Products", conn);
            da.Fill(ds, "tb1");
            DropDownList1.DataSource = ds.Tables["tb1"];
            DropDownList1.DataBind();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message.ToString());
        }
    }        
}