I have to retrieve the value from the DB & display on the textboxes which are in Default2.aspx based on the value entered in the textbox which is in Default.aspx.
For that I have given the coding in Default.aspx as
Expand|Select|Wrap|Line Numbers
- <form id="form1" runat="server" method="post" action="Default2.aspx">
- <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
- <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Button" />
Expand|Select|Wrap|Line Numbers
- <form id="form1" runat="server" method="get" action="Default.aspx">
- <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
- <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
- <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
- <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
Expand|Select|Wrap|Line Numbers
- Imports System.Data.SqlClient
- Imports System.Data
- Partial Class Default2
- Inherits System.Web.UI.Page
- Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
- Dim con As New SqlConnection("user id=sa;password=cast;database=sjc;server=AURORA-SERVER")
- con.Open()
- Dim sql As String = "select * from ITEMS where ID='" & Request.Form("a") & "'"
- Dim cmd As New SqlCommand(sql, con)
- Dim dr1 As SqlDataReader
- dr1 = cmd.ExecuteReader()
- While (dr1.Read())
- TextBox1.Text = dr1.GetValue(2).ToString()
- TextBox2.Text = dr1.GetValue(3).ToString()
- TextBox3.Text = dr1.GetValue(7).ToString()
- TextBox4.Text = dr1.GetValue(5).ToString()
- End While
- End Sub
- End Class