For Programmers: Free Programming Magazines  


Home > Archive > Visual Studio > December 2004 > Bind an Editbox to a a Dataset









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Bind an Editbox to a a Dataset
Mark A. Deal

2004-12-20, 3:57 am

Can anybody tell me how to bind a text box to a SQL Server dataset? What is
the next line?

Dim conStatewide As SqlClient.SqlConnection
Dim MyDataAdapter As SqlClient.SqlDataAdapter
Dim MyDataSet As DataSet
MyDataSet = New DataSet
conStatewide = New
SqlClient.SqlConnection(" Server=myserver;UID=sa;PWD=secret;DataBa
se=Test")
MyDataAdapter = New SqlClient.SqlDataAdapter("SELECT * FROM PROPERTY WHERE
PropertyID = '1'", conStatewide)MyDataAdapter.Fill(MyDataSet, "Property")

MytextBox.Text = MyDataSet??????????????????

--
Mark A. Deal
Document & Data Solutions, LLC
http://www.docsol.com
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com