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;
}
catch
{
return false;
}
finally
{
Connection.Close();
}
New contributor
Reza Taherian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2