No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
This is writen using vb.net and sqlCe. I'm interested how this could be written in SQL server 2008 and vb.net. Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable) |
|
Public Function getSelc() Dim com As New SqlCommand Sqlcon.Close() Sqlcon.Open() Try com = New SqlCommand("EXECUTE regionSelect '" & txtID.EditValue & "','" & txtRegion.EditValue & "','" & _ txtShortN.EditValue & "','" & txtStatus.EditValue & "'", Sqlcon) objDA.SelectCommand = com objDA.Fill(objDSs) '=> could not find stored procedure ( 'but I have it … |
|
0 down vote favorite I have a problem, what i want is when the user enters data in the textbox, it needs to compare the entered textbox value like ,,name, with value ,,name,, in dataset. If name exists, It should enter the value in textbox. If not, it should pop … |
|
I would like to know which way querying is a better, safer, more efficient. And whether there are some major differences. Sending two examples of code. Would I need something to add, modify or delete. Feel free to express your opinion. Try con.Close() con.Open() Dim sqlQuery As String = "INSERT … |
|
Hello. I recently begun using vb.net. I am creating a form application using Visual Studio Express VB 2008 and SQL server 2008. I have two forms. When the program start is not showing me any form. What is to be done that I could use two forms as one program. … |
|
What according to you is the simplest and best way to send your QUERY??? |