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

 

[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

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

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