sending parameters to Stored Procedure from Form

hey guys..i am trying to add records to my db...i created stored procedure and it works...but although it can add the datas it show message box and failed because of the if situation i think..but i didnt understand where is my mistake
try
{
con = new SqlConnection("data source=Erdinc;initial catalog=deneme;integrated security=true");
cmd = new SqlCommand("sp_TablolaraEkle", con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@marka_ad", System.Data.SqlDbType.NVarChar, 50).Value = textBox1.Text;
cmd.Parameters.Add("@model_ad", System.Data.SqlDbType.NVarChar, 50).Value = textBox2.Text;
int rows = cmd.ExecuteNonQuery();
if (rows == 1)
MessageBox.Show("Succeed", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Information);
else
MessageBox.Show("Failed", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
con.Close();
}

2 Replies

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

Erdinc Kolukisa16y ago
hey friend..thanks for the reply..i found my mistake.. i made the if condition wrong...when i changed it as (rows != 0) then it worked...
0
Rakesh Jha16y ago
i had checked your code. Everythings working fine, but actually i change only one line change instead of your connection string
con = new SqlConnection("data source=Erdinc;initial catalog=deneme;integrated security=true");
i put my below connection string
con = new SqlConnection("server=servername; database=dbname; user id=username; password=password");

0