In which object
or data type i've to take the result of
the query,and then what value of that
object(data type) i've to assign to the
textbox.text.
pls send code for that in asp.net.

abhinavjain

__________________
abhinavjain

most types you could view in textbox, what is the actual problems

Ahmed Ali
Software Developer

actual probleam is that ,i want to display the result of a select
query,from which i retrive 5-7 columns of a particular record, in the
textbox.
i have a basic idea for this
textbox.text=datatableobject.rows[0].column[..].tostring().
so what's the meaning of "datatableobject".

abhinavjain

abhinav,
for executing your query,do these steps....
1-first you should connect to your datasource(use SqlConnection objects).
2-make a new SqlCommand object and assign it your select query.(yourCommand.CommandText="select ....";)
3-make a new SqlDataAdapter object(new SqlDataAdapter(yourSqlCommandobject)).
4-make a DataSet object.
5-fill your dataset object through your SqlDataAdapter object(adapter.Fill(ds))
here you don't need again connect to your datasource,dataset object preserves your datasource in memory.
6-access the column you want in your DataSet and assign it to your textbox like something you know
textbox.text=DataSet.Tables[0].rows[number of row][number of column].tostring().(numberofcolumn is 5-7 according to your question)
****here DataSet.Tables[0] is equal to your DataTable object*****(it was the answer of your question)
DataSet object consists of DataTable objects,and also DataTable objects Consists of DataRow and DataColumn objects.....
Hope it was sufficient.

--------------------------------------------
Mehdi.

I was write this code, but it gives error
"Invalid attempt to read when no data is present."

Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim conn As SqlConnection
        Dim sqlcommand1 As SqlCommand
        Dim ds As New DataSet()
        conn = New SqlConnection("Server=cabin30;uid=sa;pwd=;database =tms")
        conn.Open()
        sqlcommand1 = New SqlCommand("select top 1 Stu_Name from Stu_Info", conn)
        Dim adopter As New SqlDataAdapter(sqlcommand1)
        adopter.Fill(ds)
        TextBox1.Text = ds.Tables(0).Rows(0).Item("Stu_Name")
                conn.Close()
    End Sub

so what's the problem now.

abhinavjain

There is something wrong with your datasource.
No problem in your code.

--------------------------------------------
Mehdi.

why dont u use DataBinding if u have DataSet?!

Always:),
Hovik Melkomian.