Search results for query: *

When using oledb for your connection, you have to indicate using a parameter in the statement by putting an "?". Don't give the parameter a name in the statement. cmd.Parameters.Add("@Membership No", Me.txtUser.text) cmd.CommandType = CommandType.Text cmd.CommandText = "Select * from Members...

Do you mean that you don't want to use the wizards for making the connection, the dataapdapter and the dataset? Because it's fairly easy to code them yourself...

A possibility to go through your datarows: Dim con As New SqlConnection(<connectionstring>) Dim myDapt As New SqlDataAdapter Dim mySet As New DataSet Dim cmdSelect As New SqlCommand Dim bm As BindingManagerBase With myDapt .SelectCommand = cmdSelect End With With cmdSelect .CommandType =...

Hi, Is there anyone who knows how to do a replace (Replace(string, string)) on a databasefield in crystal reports when the report is being made? The databasefield contains a string value that needs to be replaced by another value of a databasefield depending on which fields are queried...