sample update query in vb.net
-
can anyone help me to write a sample update query to update some text and interger fields in my database..i am using sql server 2000... please send me a sample one that works.. so i can test it and modify it to use in my project...thanks.. having problem writing mine..
Nab
-
can anyone help me to write a sample update query to update some text and interger fields in my database..i am using sql server 2000... please send me a sample one that works.. so i can test it and modify it to use in my project...thanks.. having problem writing mine..
Nab
Why dont you post what you have so far and we can point you in the correct direction.
CleAkO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) -
Why dont you post what you have so far and we can point you in the correct direction.
CleAkO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)its generated by webmatrix.. but its just not updating a field that is already in the table which has a string value...don't know why.. Dim queryString As String = "UPDATE [R_Application] SET [Fname]=@Fname, [Mname]=@Mname, [Lname]=@Lname WHERE (" & _ "[R_Application].[AppId] = @AppId)" if the field was null then it works..but if some value exist..it doesn't update...
Nab
-
its generated by webmatrix.. but its just not updating a field that is already in the table which has a string value...don't know why.. Dim queryString As String = "UPDATE [R_Application] SET [Fname]=@Fname, [Mname]=@Mname, [Lname]=@Lname WHERE (" & _ "[R_Application].[AppId] = @AppId)" if the field was null then it works..but if some value exist..it doesn't update...
Nab
Is this the same query it always uses?
CleAkO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) -
its generated by webmatrix.. but its just not updating a field that is already in the table which has a string value...don't know why.. Dim queryString As String = "UPDATE [R_Application] SET [Fname]=@Fname, [Mname]=@Mname, [Lname]=@Lname WHERE (" & _ "[R_Application].[AppId] = @AppId)" if the field was null then it works..but if some value exist..it doesn't update...
Nab
You have to show more of your code. What you describe doesn't make sense if one only looks at the SQL query. An update query doesn't care if the value in the field is null or not, it updates the field in either case.
--- single minded; short sighted; long gone;
-
Is this the same query it always uses?
CleAkO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)yes same query..what wrong with it?... just do one and send it to me..let me try it
Nab
-
You have to show more of your code. What you describe doesn't make sense if one only looks at the SQL query. An update query doesn't care if the value in the field is null or not, it updates the field in either case.
--- single minded; short sighted; long gone;
Ok..this is the exact query i am using.... Function testUpdate(ByVal appId As Integer, ByVal fname As String, ByVal lname As String) As Integer Dim connectionString As String = "server='(local)'; trusted_connection=true; database='TESTDBfhms'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim queryString As String = "UPDATE [R_Application] SET [Fname]=@Fname, [Lname]=@Lname WHERE ([R_Application]."& _ "[AppId] = @AppId)" Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.CommandText = queryString dbCommand.Connection = dbConnection Dim dbParam_appId As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_appId.ParameterName = "@AppId" dbParam_appId.Value = appId dbParam_appId.DbType = System.Data.DbType.Int32 dbCommand.Parameters.Add(dbParam_appId) Dim dbParam_fname As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_fname.ParameterName = "@Fname" dbParam_fname.Value = fname dbParam_fname.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_fname) Dim dbParam_lname As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_lname.ParameterName = "@Lname" dbParam_lname.Value = lname dbParam_lname.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_lname) Dim rowsAffected As Integer = 0 dbConnection.Open Try rowsAffected = dbCommand.ExecuteNonQuery Finally dbConnection.Close End Try Return rowsAffected End Function
Nab
-
Ok..this is the exact query i am using.... Function testUpdate(ByVal appId As Integer, ByVal fname As String, ByVal lname As String) As Integer Dim connectionString As String = "server='(local)'; trusted_connection=true; database='TESTDBfhms'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim queryString As String = "UPDATE [R_Application] SET [Fname]=@Fname, [Lname]=@Lname WHERE ([R_Application]."& _ "[AppId] = @AppId)" Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.CommandText = queryString dbCommand.Connection = dbConnection Dim dbParam_appId As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_appId.ParameterName = "@AppId" dbParam_appId.Value = appId dbParam_appId.DbType = System.Data.DbType.Int32 dbCommand.Parameters.Add(dbParam_appId) Dim dbParam_fname As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_fname.ParameterName = "@Fname" dbParam_fname.Value = fname dbParam_fname.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_fname) Dim dbParam_lname As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_lname.ParameterName = "@Lname" dbParam_lname.Value = lname dbParam_lname.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_lname) Dim rowsAffected As Integer = 0 dbConnection.Open Try rowsAffected = dbCommand.ExecuteNonQuery Finally dbConnection.Close End Try Return rowsAffected End Function
Nab