Id : <asp:TextBox id='TextBox1' style='Z-INDEX: 102; LEFT: 128px; POSITION: absolute; TOP: 32px' runat='server'></asp:TextBox>
Name : <asp:TextBox id='TextBox2' style='Z-INDEX: 103; LEFT: 128px; POSITION: absolute; TOP: 72px' runat='server'></asp:TextBox>
VB.NET
Dim cn As SqlConnection
Dim cmd As SqlCommand
Dim rdr As SqlDataReader
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
’ Put user code to initialize the page here
Try
cn = New SqlConnection('server=localhost;uid=sa;pwd=;database=northwind')
cmd = New SqlCommand('select * from Products where productid =1', cn)
cn.Open()
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
rdr.Read()
TextBox1.Text = rdr('ProductId').ToString()
TextBox2.Text = rdr('ProductName').ToString()
Catch ex As Exception
Response.Write(ex.Message.ToString())
Finally
rdr.Close()
cn.Close()
End Try
End Sub
C#
SqlConnection cn ;
SqlCommand cmd ;
SqlDataReader rdr ;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
try
{
cn = new SqlConnection('server=localhost;uid=sa;pwd=;database=northwind');
cmd = new SqlCommand( 'select * from Products where productid=1 ', cn);
cn.Open();
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection );
rdr.Read ();
TextBox1.Text =rdr['ProductId'].ToString ();
TextBox2.Text =rdr['ProductName'].ToString ();
}
catch (Exception ex)
{
Response.Write (ex.Message.ToString ());
}
finally
{
rdr.Close();
cn.Close();
}
}
Permalink