Live Chat Icon For mobile
Live Chat Icon

How to display data in Textboxes using DataReader

Platform: ASP.NET| Category: TextBox

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();
	}
}

Share with