ASP - Read Long Column data from sql in ASP

I have created one table in which contains Document column with Long data type.i have copied the data  with 60 lines and done insertion also.now, how do i read data from that table in asp or asp.net?..

hi,

here is C# the code to retrive the data from the table and show it in asp.net  Text control looks like label control

Dataset ds = new Dataset();

//fill your  dataset wiht the requried details

txtDetails.Text = ds.Tables[0].Rows[0]["Column Name"].ToString();

and in desing  time set the text box as below

<asp:TextBox runat="server" ID="txtDet" TextMode="MultiLine" Wrap="true" Width="150px" ReadOnly = "true"

BorderStyle="none" BorderWidth="0" Rows="5" ></asp:TextBox>

the above will show your data in textbox, but it looks like label control.

Dim cn As New SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings.Item("DataBaseConnection").ConnectionString)

Dim cn As New SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings.Item("DataBaseConnection").ConnectionString)

Dim cn As New SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings.Item("DataBaseConnection").ConnectionString)

refer it....

Dim command As SqlCommand = New SqlCommand( _
          "SELECT * FROM Employees", connection)
        connection.Open()

        Dim reader As SqlDataReader = command.ExecuteReader()

        Do While reader.HasRows
            Console.WriteLine(vbTab & reader.GetName(0) _
              & vbTab & reader.GetName(1))

            Do While reader.Read()
                Console.WriteLine(vbTab & reader.GetInt32(0) _
                  & vbTab & reader.GetString(1)_

                  & vbTab & reader.GetDouble(2))
            Loop

            reader.NextResult()
        Loop

Thanks for your response. But i am going to use long data in asp and asp.net.how i do it in ASP

Hello Lalitha Kumaran

Fillout the dataset using dataadapter .
then take one string object and assign the desired value to the string Now You can use this with any of your controllike textbox etc. But textbox should be multiline

dataset ds=new dataset();
// Data filling Operations comes here
string str= ds.Tables[0].Rows[0]["Column Name"].ToString();
// assign this string to any cntrl you want.
Dataset Filling Logic
 

Dim cn As New SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings.Item("DataBaseConnection").ConnectionString)

Happy Coding takecare

Hi,

I am not much familiar with ASP. After you have get the data from database just bind it with the Text area control...

below is the format for the text area control...

You can read directly into any variable in ASP...

check here how to conenct to database from ASP and read data from table...

http://www.haneng.com/Lessons_17.asp

http://www.4guysfromrolla.com/webtech/042599-1.shtml

Check this article which explains how to read clob types in .net

You can use GetOracleLob method of  OracleDataReader class obejct...

http://www.codeproject.com/KB/database/C__and_Oracle.aspx