The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
COURSE of the MONTH
9 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Get value into textbox from sproc
Posted on 2013-07-01
I am executing a stored procedure in which the dataset that is returned is only 1 row/column. I want to put that value into a textbox. The textbox does not have data binding. How do I get that value into it?
Private Sub GetCostCenter()
Dim myCommand5 As New SqlCommand("Manager_Select_CostCenter", connection)
myCommand5.CommandType = CommandType.StoredProcedure
Dim myDA5 As New SqlDataAdapter
myDA5.SelectCommand = myCommand5
Dim dsCostCenter As New DataSet
myDA5.Fill(dsCostCenter)
txtCostCenter.Text = dsCostCenter `???
End Sub
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
as long as it returns a string
myDA5.Fill(dsCostCenter)
txtCostCenter.Text = dsCostCenter
or even
txtCostCenter.Text= myDA5.Fill(dsCostCenter)
myDA5.Fill(dsCostCenter)
txtCostCenter.Text = dsCostCenter
or even
txtCostCenter.Text= myDA5.Fill(dsCostCenter)
Active 4 days ago
You do not need SqlDataAdapter a reader will do the job just fine and quicker:
Private Sub GetCostCenter()
Dim myCommand5 As New SqlCommand("Manager_Select_CostCenter", connection)
myCommand5.CommandType = CommandType.StoredProcedure
myCommand5.Parameters.Add("@costcentre", SqlDbType.VarChar)
myCommand5.Parameters("@costcentre").Direction = ParameterDirection.Output
Dim sqlReader As SqlDataReader = myCommand5..ExecuteReader()
sqlReader.Close()
txtCostCenter.Text = myCommand5.Parameters("@costcentre").Value)
End Sub
>You do not need SqlDataAdapter a reader will do the job just fine and quicker
You do not need a reader either. A single value can be retrieved using ExecuteScalar method
You do not need a reader either. A single value can be retrieved using ExecuteScalar method
Private Sub GetCostCenter()
Dim myCommand5 As New SqlCommand("Manager_Select_CostCenter", connection)
myCommand5.CommandType = CommandType.StoredProcedure
txtCostCenter.Text = myCommand5.ExecuteScalar()
End Sub
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties. A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex.
A simple solution to parsing a customized CSV fi…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month9 days, 2 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.