با سلام
دستور درج کردن در جدول
SqlDataAdapter1.InsertCommand.Parameters.Clear();
SqlDataAdapter1.InsertCommand.Parameters.AddWithVa lue("@p", text1.text);
SqlDataAdapter1.InsertCommand.CommandText="insert into table1 values(@p)";
SqlConnection1.Open();
SqlDataAdapter1.InsertCommand.ExecuteNonQuery();
SqlConnection1.Close();
کد جستجو
SqlDataAdapter1.SelectCommand.Parameters.Clear();
SqlDataAdapter1.SelectCommand.Parameters.AddWithVa lue("@p",TextBox1.text);
SqlDataAdapter1.SelectCommand.CommandText="select * from table1 where @p=id";
SqlConnection1.Open();
SqlDataAdapter1.SelectCommand.ExecuteNonQuery();
SqlConnection1.Close();
کد حذف
SqlDataAdapter1.DeleteCommand.Parameters.Clear();
SqlDataAdapter1.DeleteCommand.Parameters.AddWithVa lue("@p",TextBox1.text);
SqlDataAdapter1.DeleteCommand.CommandText="delete from table1 where @p=id";
SqlConnection1.Open();
SqlDataAdapter1.DeleteCommand.ExecuteNonQuery();
SqlConnection1.Close();
کد بروز رسانی
SqlDataAdapter1.UpdateCommand.Parameters.Clear();
SqlDataAdapter1.UpdateCommand.Parameters.AddWithVa lue("@p1",TextBox1.text);
SqlDataAdapter1.UpdateCommand.Parameters.AddWithVa lue("@p2",TextBox2.text);
SqlDataAdapter1.UpdateCommand.CommandText = "update moshtary set name=@p1 where id=@p2";
SqlConnection1.Open();
SqlDataAdapter1.UpdateCommand.ExecuteNonQuery();
SqlConnection1.Close();
موفق باشی