Displaying data from database in textboxes.

[Schapopa]

Hello,

I have form where I want to display data from one record. So I created
stored procedure with parameter and I populated some dropdown boxes
with data, and now I would like to display that record in the
textboxes and combo boxes.
So I have data conection, data adapter and query with parameter.
How do I bind this to textboxes and dropdown boxes.
textbox.text = ?? I guess what I cannot find is how to point to
specific field in the dataset.
Below is piece of code that I am using for dataadapter and dataset:

conn.Open()

Dim daCategory As New SqlDataAdapter("sp_task", conn)
daCategory.SelectCommand.CommandType =
CommandType.StoredProcedure

Dim IDtask As New SqlParameter("@IDTask",
System.Data.SqlDbType.NVarChar)
IDtask.Direction = ParameterDirection.Input
IDtask.Value = Request.QueryString("IDTAsk")
daCategory.SelectCommand.Parameters.Add(IDtask)

Dim dsZadanie As New DataSet
daCategory.Fill(dsTask, "Task")

Thank's
Arek

[GrantMagic]

If you are only returning one value from a query, its best to use the
DataReader.
So, say you stored proc returns a single valu, you can use the datareader as
follows:

Dim ObjCmd as New OleDbCommand("sp_task", conn)
ObjCmd.CommandType = CommandType.StoredProcedure
Dim IDtask As New SqlParameter("@IDTask",
System.Data.SqlDbType.NVarChar)
IDtask.Direction = ParameterDirection.Input
IDtask.Value = Request.QueryString("IDTAsk")
ObjCmd.Paramters.Add(IDtask)

conn.Open()
Dim dr as OleDbDataReader = ObjCmd.ExecuteReader()
if dr.Read() then
textbox.text = Convert.ToString(dr[0])
end if
connClose()


"Schapopa" <ar**********@hotmail.com> wrote in message
news:f3**************************@posting.google.c om...

Hello,

I have form where I want to display data from one record. So I created
stored procedure with parameter and I populated some dropdown boxes
with data, and now I would like to display that record in the
textboxes and combo boxes.
So I have data conection, data adapter and query with parameter.
How do I bind this to textboxes and dropdown boxes.
textbox.text = ?? I guess what I cannot find is how to point to
specific field in the dataset.
Below is piece of code that I am using for dataadapter and dataset:

conn.Open()

Dim daCategory As New SqlDataAdapter("sp_task", conn)
daCategory.SelectCommand.CommandType =
CommandType.StoredProcedure

Dim IDtask As New SqlParameter("@IDTask",
System.Data.SqlDbType.NVarChar)
IDtask.Direction = ParameterDirection.Input
IDtask.Value = Request.QueryString("IDTAsk")
daCategory.SelectCommand.Parameters.Add(IDtask)

Dim dsZadanie As New DataSet
daCategory.Fill(dsTask, "Task")

Thank's
Arek

[S. Justin Gengo]

ExecuteScalar would be even faster.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"GrantMagic" <gr***@magicalia.com> wrote in message
news:OL**************@TK2MSFTNGP15.phx.gbl...

If you are only returning one value from a query, its best to use the
DataReader.
So, say you stored proc returns a single valu, you can use the datareader
as follows:

Dim ObjCmd as New OleDbCommand("sp_task", conn)
ObjCmd.CommandType = CommandType.StoredProcedure
Dim IDtask As New SqlParameter("@IDTask",
System.Data.SqlDbType.NVarChar)
IDtask.Direction = ParameterDirection.Input
IDtask.Value = Request.QueryString("IDTAsk")
ObjCmd.Paramters.Add(IDtask)

conn.Open()
Dim dr as OleDbDataReader = ObjCmd.ExecuteReader()
if dr.Read() then
textbox.text = Convert.ToString(dr[0])
end if
connClose()


"Schapopa" <ar**********@hotmail.com> wrote in message
news:f3**************************@posting.google.c om...

Hello,

I have form where I want to display data from one record. So I created
stored procedure with parameter and I populated some dropdown boxes
with data, and now I would like to display that record in the
textboxes and combo boxes.
So I have data conection, data adapter and query with parameter.
How do I bind this to textboxes and dropdown boxes.
textbox.text = ?? I guess what I cannot find is how to point to
specific field in the dataset.
Below is piece of code that I am using for dataadapter and dataset:

conn.Open()

Dim daCategory As New SqlDataAdapter("sp_task", conn)
daCategory.SelectCommand.CommandType =
CommandType.StoredProcedure

Dim IDtask As New SqlParameter("@IDTask",
System.Data.SqlDbType.NVarChar)
IDtask.Direction = ParameterDirection.Input
IDtask.Value = Request.QueryString("IDTAsk")
daCategory.SelectCommand.Parameters.Add(IDtask)

Dim dsZadanie As New DataSet
daCategory.Fill(dsTask, "Task")

Thank's
Arek

[Arek Lubinski]

Thank you for your help,
So I am using datareader and it works very good.
I started to use dataset but really there is no need for that.
Regards
Arek


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!