مشاهده نسخه کامل
: adameh_bahal
03-02-2010, 10:31
من وقتی میخام از Insert استفاده کنم این ارور رو میده :
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = (@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Paaygaah Daade\WarehouseProduct.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlCommand MySqlCommand = new SqlCommand();
MySqlCommand.Connection = MyConnection;
MySqlCommand.CommandText = "insert into FixPersonelInfo values (@pid,@pname,@unit,@unit_price) ;
MyConnection.Open();
MySqlCommand.ExecuteNonQuery();
Connection.Close();
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = (@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Paaygaah Daade\WarehouseProduct.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlCommand MySqlCommand = new SqlCommand();
MySqlCommand.Connection = MyConnection;
MySqlCommand.CommandText = "insert into FixPersonelInfo values (@pid,@pname,@unit,@unit_price) ;
MyConnection.Open();
MySqlCommand.ExecuteNonQuery();
Connection.Close();