Click here to Skip to main content
15,884,835 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Hi
I use one drop downlist box(user id) and two textbox(First Name and Last Name).

And I Select Userid And Then bind the data To First Name And Last Name Using Sql server.

Thanking You.
Posted
Comments
Rajesh Anuhya 6-Jan-12 7:42am    
No effort

1 solution

Hi Arun,


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class Default3 : System.Web.UI.Page
{
    string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    string str;
    SqlCommand com;
    protected void Page_Load(object sender, EventArgs e)
    {
        DropDownList1.AutoPostBack = true;
        SqlConnection con = new SqlConnection(strConnString);

        if (!IsPostBack)
        {
            DropDownList1.Items.Add("Choose userid");
            con.Open();
            str = "select * from Contacts";
            com = new SqlCommand(str, con);
            SqlDataReader reader = com.ExecuteReader();
            while (reader.Read())
            {
                DropDownList1.Items.Add(reader["userid"].ToString());
            }
            reader.Close();
            con.Close();
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(strConnString);
        con.Open();
        str = "select * from Contacts where userid='" + DropDownList1.SelectedItem.Text + "'";
        com = new SqlCommand(str, con);
        SqlDataReader reader = com.ExecuteReader();
        while (reader.Read())
        {
            TextBox1.Text=reader["Fname"].ToString();
            TextBox2.Text = reader["Lname"].ToString(); 
        }
        reader.Close();
        con.Close();
    }
}
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900