|
con el sql buildes de web matrix hago un select pasandole el parametro de
?UserID=1
[code]
Function MyQueryMethod(ByVal userID As Integer) As System.Data.DataSet
Dim connectionString As String = "server='cyberideas'; trusted_connection=true; database='compurest'"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT [cas].[UserID], [cas].[e-mail], [cas].[visto] FROM [cas] WHERE ([cas].[Use"& _
"rID] = @UserID)"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dbParam_userID As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_userID.ParameterName = "@UserID"
dbParam_userID.Value = userID
dbParam_userID.DbType = System.Data.DbType.Int32
dbCommand.Parameters.Add(dbParam_userID)
Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
[code]
ejecuto el query
MyUpdateMethod(1)
como leo los valores de los otros campos del select
|