Hi Thuyai,
Check this example. Now please take its reference and correct your code.
Here i have used dynamic datatable to populate the record. You need to replace the datatable binding code from database.
HTML
<asp:ScriptManager runat="server" ID='sm1' EnablePartialRendering="false">
</asp:ScriptManager>
<asp:UpdatePanel runat="server" ID='up1'>
<ContentTemplate>
<asp:MultiView ID="mvPeview" runat="server" ActiveViewIndex="0" EnableTheming="True">
<asp:View ID="vwSubmit" runat="server">
Select Customer Name
<asp:DropDownList ID="lstFullName" runat="server" AutoPostBack="true" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<br />
Name:
<asp:TextBox ID="txtName" runat="server" ReadOnly="true"></asp:TextBox>
<br />
Department:
<asp:TextBox ID="txtDepartment" runat="server" OnTextChanged="UpdateCustomerList"
AutoPostBack="true"></asp:TextBox>
<br />
Phone:
<asp:TextBox ID="txtPhone" runat="server" OnTextChanged="UpdateCustomerList" AutoPostBack="true"></asp:TextBox>
<br />
Email:
<asp:TextBox ID="txtEmail" runat="server" OnTextChanged="UpdateCustomerList" AutoPostBack="true"></asp:TextBox>
<br />
Order:
<asp:TextBox ID="txtOrder" runat="server" OnTextChanged="UpdateCustomerList" AutoPostBack="true"></asp:TextBox>
Count:
<asp:TextBox ID="txtCount" runat="server" OnTextChanged="UpdateCustomerList" AutoPostBack="true"></asp:TextBox>
<br />
<hr />
Name:
<asp:Label ID="lblName" runat="server"></asp:Label>
<br />
<asp:Label ID="lblDepartment" runat="server"></asp:Label>
<br />
<asp:Label ID="lblEmail" runat="server"></asp:Label>
<br />
<asp:Label ID="lblPhone" runat="server"></asp:Label></span>
<br />
<asp:Label ID="lblOrder" runat="server"></asp:Label>
and
<asp:Label ID="lblCount" runat="server"></asp:Label>
<br />
</asp:View>
<asp:View ID="vwResult" runat="server">
</asp:View>
</asp:MultiView>
</ContentTemplate>
</asp:UpdatePanel>
Namespaces
C#
using System.Data;
VB.Bet
Imports System.Data
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lstFullName.Items.Add(new ListItem("Select CustDisplayname", ""));
lstFullName.AppendDataBoundItems = true;
DataTable dt = GetCustomerContactList();
lstFullName.DataSource = dt;
lstFullName.DataTextField = "CustDisplayname";
lstFullName.DataValueField = "CustDisplayname";
lstFullName.DataBind();
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = GetCustomerContactList().Select("CustDisplayname='" + lstFullName.SelectedItem.Value + "'").CopyToDataTable();
txtName.Text = dt.Rows[0]["CustDisplayname"].ToString();
txtDepartment.Text = dt.Rows[0]["dept_list"].ToString();
txtEmail.Text = dt.Rows[0]["email"].ToString();
txtPhone.Text = dt.Rows[0]["telNumber"].ToString();
txtOrder.Text = dt.Rows[0]["numberOrder"].ToString();
txtCount.Text = dt.Rows[0]["Count"].ToString();
lblName.Text = dt.Rows[0]["CustDisplayname"].ToString();
lblDepartment.Text = dt.Rows[0]["dept_list"].ToString();
lblEmail.Text = dt.Rows[0]["email"].ToString();
lblPhone.Text = dt.Rows[0]["telNumber"].ToString();
lblOrder.Text = dt.Rows[0]["numberOrder"].ToString();
lblCount.Text = dt.Rows[0]["Count"].ToString();
}
protected void UpdateCustomerList(object sender, EventArgs e)
{
string department = txtDepartment.Text.Trim();
string email = txtEmail.Text.Trim();
string phone = txtPhone.Text.Trim();
string order = txtOrder.Text.Trim();
string count = txtCount.Text.Trim();
DataTable dtCustomer = Session["CustomerList"] as DataTable;
foreach (DataRow dr in dtCustomer.Rows)
{
if (dr["CustDisplayname"].ToString() == lstFullName.SelectedItem.Value)
{
dr["dept_list"] = department;
dr["email"] = email;
dr["telNumber"] = phone;
dr["numberOrder"] = order;
dr["Count"] = count;
}
}
Session["CustomerList"] = dtCustomer;
DataTable dt = (Session["CustomerList"] as DataTable).Select("CustDisplayname='" + lstFullName.SelectedItem.Value + "'").CopyToDataTable();
lblName.Text = dt.Rows[0]["CustDisplayname"].ToString();
lblDepartment.Text = dt.Rows[0]["dept_list"].ToString();
lblEmail.Text = dt.Rows[0]["email"].ToString();
lblPhone.Text = dt.Rows[0]["telNumber"].ToString();
lblOrder.Text = dt.Rows[0]["numberOrder"].ToString();
lblCount.Text = dt.Rows[0]["Count"].ToString();
}
private DataTable GetCustomerContactList()
{
DataTable dt;
if (Session["CustomerList"] == null)
{
dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] {
new DataColumn("CustDisplayname", typeof(string)),
new DataColumn("dept_list", typeof(string)),
new DataColumn("email", typeof(string)),
new DataColumn("telNumber", typeof(Int64)),
new DataColumn("numberOrder", typeof(int)),
new DataColumn("Count", typeof(int)) });
dt.Rows.Add("John Hammond", "Computer", "test@test.com", 1111, 1001, 8);
dt.Rows.Add("Mudassar Khan", "IT", "test@test.com", 2222, 1002, 5);
dt.Rows.Add("Suzanne Mathews", "IT", "test@test.com", 3333, 1003, 10);
dt.Rows.Add("Robert Schidner", "Computer", "test@test.com", 4444, 1004, 2);
Session["CustomerList"] = dt;
}
else
{
dt = Session["CustomerList"] as DataTable;
}
return dt;
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not IsPostBack Then
lstFullName.Items.Add(New ListItem("Select CustDisplayname", ""))
lstFullName.AppendDataBoundItems = True
Dim dt As DataTable = GetCustomerContactList()
lstFullName.DataSource = dt
lstFullName.DataTextField = "CustDisplayname"
lstFullName.DataValueField = "CustDisplayname"
lstFullName.DataBind()
End If
End Sub
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
Dim dt As DataTable = GetCustomerContactList().Select("CustDisplayname='" & lstFullName.SelectedItem.Value & "'").CopyToDataTable()
txtName.Text = dt.Rows(0)("CustDisplayname").ToString()
txtDepartment.Text = dt.Rows(0)("dept_list").ToString()
txtEmail.Text = dt.Rows(0)("email").ToString()
txtPhone.Text = dt.Rows(0)("telNumber").ToString()
txtOrder.Text = dt.Rows(0)("numberOrder").ToString()
txtCount.Text = dt.Rows(0)("Count").ToString()
lblName.Text = dt.Rows(0)("CustDisplayname").ToString()
lblDepartment.Text = dt.Rows(0)("dept_list").ToString()
lblEmail.Text = dt.Rows(0)("email").ToString()
lblPhone.Text = dt.Rows(0)("telNumber").ToString()
lblOrder.Text = dt.Rows(0)("numberOrder").ToString()
lblCount.Text = dt.Rows(0)("Count").ToString()
End Sub
Protected Sub UpdateCustomerList(ByVal sender As Object, ByVal e As EventArgs)
Dim department As String = txtDepartment.Text.Trim()
Dim email As String = txtEmail.Text.Trim()
Dim phone As String = txtPhone.Text.Trim()
Dim order As String = txtOrder.Text.Trim()
Dim count As String = txtCount.Text.Trim()
Dim dtCustomer As DataTable = TryCast(Session("CustomerList"), DataTable)
For Each dr As DataRow In dtCustomer.Rows
If dr("CustDisplayname").ToString() = lstFullName.SelectedItem.Value Then
dr("dept_list") = department
dr("email") = email
dr("telNumber") = phone
dr("numberOrder") = order
dr("Count") = count
End If
Next
Session("CustomerList") = dtCustomer
Dim dt As DataTable = (TryCast(Session("CustomerList"), DataTable)) _
.Select("CustDisplayname='" & lstFullName.SelectedItem.Value & "'").CopyToDataTable()
lblName.Text = dt.Rows(0)("CustDisplayname").ToString()
lblDepartment.Text = dt.Rows(0)("dept_list").ToString()
lblEmail.Text = dt.Rows(0)("email").ToString()
lblPhone.Text = dt.Rows(0)("telNumber").ToString()
lblOrder.Text = dt.Rows(0)("numberOrder").ToString()
lblCount.Text = dt.Rows(0)("Count").ToString()
End Sub
Private Function GetCustomerContactList() As DataTable
Dim dt As DataTable
If Session("CustomerList") Is Nothing Then
dt = New DataTable()
dt.Columns.AddRange(New DataColumn() {New DataColumn("CustDisplayname", GetType(String)),
New DataColumn("dept_list", GetType(String)),
New DataColumn("email", GetType(String)),
New DataColumn("telNumber", GetType(Int64)),
New DataColumn("numberOrder", GetType(Integer)),
New DataColumn("Count", GetType(Integer))})
dt.Rows.Add("John Hammond", "Computer", "test@test.com", 1111, 1001, 8)
dt.Rows.Add("Mudassar Khan", "IT", "test@test.com", 2222, 1002, 5)
dt.Rows.Add("Suzanne Mathews", "IT", "test@test.com", 3333, 1003, 10)
dt.Rows.Add("Robert Schidner", "Computer", "test@test.com", 4444, 1004, 2)
Session("CustomerList") = dt
Else
dt = TryCast(Session("CustomerList"), DataTable)
End If
Return dt
End Function
Screenshot
