|
-
Jan 14th, 2007, 11:36 PM
#1
Thread Starter
Junior Member
placed the result into textbox
i use visual studio, n microsoft sql server, so my connection to database is like below:
Dim sqlCon As SqlConnction=New SqlConnection()
Dim myDataAdapter As SqlDataAdapter
Dim DS DataSet
SqlConn.ConnectionString="Data Source =NORA; Initial Catalog=Account; UserId=sa; Password=password;"
sqlConn.Open()
Dim queryString As String=SELECT nama FROM pelajar WHERE ......
MyDataAdapter=New SqlDataAdapter(queryString,sqlConn)
sqlConn.close()
my answer is, i want the result from database example (nama) is assign into one variable like (Dim name As String), and i want the value of name is placed into textbox.
so can all of u show me how to write the code to generate it,..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|