ExecuteNonQuery not working in C# – SQL Server
DB name = NikAfzarDB TB name = ClientTB string connectionString = “Data Source=.;Initial Catalog=NikAfzarDB,Integrated Security=true”; SqlConnection Connection = new SqlConnection(connectionString); try { string query = “INSERT INTO ClientTB (CID, CFileNumber, CName, CFamily, CPhoneNumber, CJobeName, CCharacter) VALUES (@ID, @FileNumber, @Name, @Family, @PhoneNumber, @JobeName, @Character)”; SqlCommand Command = new SqlCommand(query, Connection); Command.Parameters.AddWithValue(“@ID”, id); Command.Parameters.AddWithValue(“@FileNumber”, fileNumber); Command.Parameters.AddWithValue(“@Name”, name); […]
ExecutNonQuery not working in C# – sql server
DB name = NikAfzarDB TB name = ClientTB string connectionString = “Data Source=.;Initial Catalog=NikAfzarDB,Integrated Security=true”; SqlConnection Connection = new SqlConnection(connectionString); try { string query = “INSERT INTO ClientTB (CID,CFileNumber,CName,CFamily,CPhoneNumber,CJobeName,CCharacter) VALUES (@ID,@FileNumber,@Name,@Family,@PhoneNumber,@JobeName,@Character)”; SqlCommand Command = new SqlCommand(query, Connection); Command.Parameters.AddWithValue(“@ID”, id); Command.Parameters.AddWithValue(“@FileNumber”, fileNumber); Command.Parameters.AddWithValue(“@Name”, name); Command.Parameters.AddWithValue(“@Family”, family); Command.Parameters.AddWithValue(“@PhoneNumber”, phoneNumber); Command.Parameters.AddWithValue(“@JobeName”, jobName); Command.Parameters.AddWithValue(“@Character”, character); Connection.Open(); Command.ExecuteNonQuery(); return true; […]
I have a SQL query, but it does not return any value even though I have data in the database
I created a SQL query and it should update the database after the payment is made, but when I hit the save button, nothing happens, I don’t even get an error.