السلام عليكم
اريد حد يقول لي ما هو ال Exception في هذا الكود
public void insertsupplier(int code,int phone, string name, string address, string items, string rating, string facility, string note)
{
SqlConnection conn = new SqlConnection(@"Data Source=MAHMOUD-PC\SQLEXPRESS;Initial Catalog=Manage_Suppliers;User ID=sa;Password=sa");
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
String queryString = "INSERT INTO [supplier] VALUES (@code ,@phone ,@name ,@rating ,@facility ,@address ,@items ,@note )";
cmd.CommandText = queryString;
try
{
cmd.Connection = conn;
conn.Open();
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@code", code);
cmd.Parameters.AddWithValue("@phone", phone);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@rating", rating);
cmd.Parameters.AddWithValue("@facility", facility);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@items", items);
cmd.Parameters.AddWithValue("@note", note);
cmd.ExecuteNonQuery();
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
finally
{
cmd.Dispose();
conn.Close();
}
}يعطيني exception على هذا السطر ولا اعرف السبب ..
cmd.ExecuteNonQuery();
وهو
operand type clash : int is incompatible with text

