![]() ![]() INSERT INTO tblAudit (UserId, Type,Date,ByName,Note) VALUES ((SELECT UserId from inserted),0,GETDATE(). MessageBox.Show( " Successfully saved", " Fill Field", MessageBoxButton.OK, MessageBoxImage. Error converting data type varchar to numeric. ![]() private void btnSave_Click( object sender, RoutedEventArgs e) MessageBox.Show( " Successfully saved", " Fill Field", MessageBoxButton.OK, MessageBoxImage.Information) SqlCommand cmd = new SqlCommand("add_user_details'" + txtUserId.Text + "','" + cmboSelEmp.SelectedValuePath + "'," + // "'" + cmboSelEmp.Text+ "','" + cmboSelUser.SelectedValuePath+ "'," + // "'" + cmboSelUser.SelectedValuePath + "','" + txtUsername.Text + "','" + () + "'," + // "'" + cmboBranch.Text + "'", con) SqlCommand cmd = new SqlCommand( " add_user_details", conn) Ĭmd.CommandType = CommandType.StoredProcedure Ĭmd.Parameters.AddWithValue( " SqlDbType.Int).Value = string.IsNullOrWhiteSpace(txtUserId.Text) ? DBNull.Value : ( object)txtUserId.Text Ĭmd.Parameters.AddWithValue( " SqlDbType.VarChar).Value = string.IsNullOrWhiteSpace(cmboSelEmp.Text) ? DBNull.Value : ( object)cmboSelEmp.Text Ĭmd.Parameters.AddWithValue( " SqlDbType.VarChar).Value = string.IsNullOrWhiteSpace(cmboSelUser.Text) ? DBNull.Value : ( object)cmboSelUser.Text Ĭmd.Parameters.AddWithValue( " SqlDbType.VarChar).Value = string.IsNullOrWhiteSpace(txtUsername.Text) ? DBNull.Value : ( object)txtUsername.Text Ĭmd.Parameters.AddWithValue( " SqlDbType.VarChar).Value = string.IsNullOrWhiteSpace(txtPassword.Password) ? DBNull.Value : ( object)txtPassword.Password Ĭmd.Parameters.AddWithValue( " SqlDbType.VarChar).Value = string.IsNullOrWhiteSpace(cmboBranch.Text) ? DBNull.Value : ( object)cmboBranch.Text . 4echo Ableton AbstractFFTs Absynth accSone Adastra Adobe Audition Advantech AF AJAX Alienware Aurora R11 ALOT AlphaFold ALS ALSA alsa-oss ALSA Devel amd processor amqplib Anaconda ANSYS anti-aliasing antiX Apache Kafka apex apollo apulSoft ArcGIS archlinux ARDUINO arm64 Arturia ASIO ASoC ATG ATM ATTR AUR autodesk forge AUTODESK. SqlConnection conn = new SqlConnection(ConnectionString) Private void btnSave_Click( object sender, RoutedEventArgs e)
0 Comments
Leave a Reply. |