Saving data in localDB

Hi!

I am facing a problem saving data in a local sql server 2008 database, in fact when I save everything is fine but as soon as I consult the database data there is nothing in it, someone could one help me please, here are my codes

Ma connexion string

class connexion
{
public static string getconnexion()
{
return "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True";
}
}

Class To Add Client:

{
SqlConnection con = new SqlConnection(connexion.getconnexion());
con.Open();
SqlCommand cmd1 = new SqlCommand("Insert into client(num_passport,nom,adresse,phone) values(@num_passport,@nom,@adresse,@phone)", con);
// cmd1.CommandType = System.Data.CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@num_passport", num_passport);
cmd1.Parameters.AddWithValue("@nom", nom);
cmd1.Parameters.AddWithValue("@adresse", adresse);
cmd1.Parameters.AddWithValue("@phone", phone);
cmd1.ExecuteNonQuery();

Button Add event:

private void button1_Click(object sender, EventArgs e)
{
SaisieClient st = new SaisieClient();
st.Num_passport = idclt.Text;
st.Nom = clt.Text;
st.Adresse = adres.Text;
st.Phone = Int32.Parse(phone.Text).ToString();
st.Saisie();

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Varun Setia6y ago
Accepted answer
Please mark it as solved :)
Sofari Agali6y ago
thank you, it worked I replaced with the real path to the database
Varun Setia6y ago
Check Database.mdf file in that path. The data might be saving in some other location.
Sofari Agali6y ago
it shows that the data has been recorded but if I consult the table I cannot find any record
Varun Setia6y ago
Hi, what is the output of ExecuteNonQuery