What's wrong in my code.<BR>I want to select "Description"(Column came) from the database and put into textbox.<BR><BR>The code as following<BR><BR><%@Import Namespace="System.Data.SqlClient"%><BR><%@ Import Namespace="System.Data" %><BR><%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="testBox.WebForm1"%><BR><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><BR><HTML><BR> <!--HEAD><BR> <title></title--><BR> <script language="vb" runat="server"> <BR>sub Page_Load(obj as Object, e as EventArgs)<BR> Dim myReader as SqlDataReader<BR> Dim mySqlConnection as SqlConnection<BR> Dim mySqlCommand as SqlCommand<BR><BR> mySqlConnection = new SqlConnection("server=(local)NetSDK;database=Northwind")<BR> mySqlCommand = new SqlCommand("select Description from Categories where CategoryID=1", mySqlConnection)<BR><BR> <BR> myReader = mySqlCommand.ExecuteReader()<BR> <BR> TextBox1.Text=myReader("Description")<BR> <BR>end sub<BR> </script><BR> <!--meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0"><BR> <meta name="CODE_LANGUAGE" content="Visual Basic 7.0"><BR> <meta name="vs_defaultClientScript" content="JavaScript"><BR> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"><BR> </HEAD--><BR> <body MS_POSITIONING="GridLayout"><BR> <form id="Form1" method="post" runat="server"><BR> <asp:TextBox id="TextBox1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" runat="server"></asp:TextBox><BR> <asp:Label id="Label1" style="Z-INDEX: 102; LEFT: 9px; POSITION: absolute; TOP: 57px" runat="server">Label</asp:Label><BR> </form><BR> </body><BR></HTML><BR>I believe you need to have a Read() before you can access the contents of the Reader. So...<BR><BR>myReader = mySqlCommand.ExecuteReader()<BR>myReader.Read()<BR>TextBox1.Text=myReader("Description")Thanks so much.<BR><BR>Catherine
Put the value into the Textbox
- Thread starter Qccsfmhq
- Start date