Постинг
10.05.2016 15:44 -
net
Автор: sparty
Категория: Рецепти
Прочетен: 319 Коментари: 0 Гласове:
Последна промяна: 10.05.2016 15:45
Прочетен: 319 Коментари: 0 Гласове:
0
Последна промяна: 10.05.2016 15:45
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlDataAdapter prodAdapter = new SqlDataAdapter("SELECT * FROM products", SqlProducts.ConnectionString); //SqlProducts - DataSourceID - properties na dropdown
DataSet ds = new DataSet();
prodAdapter.Fill(ds, "products"); //
foreach (DataRow r in ds.Tables[0].Rows)
if (r[0].ToString() == DropDownList1.SelectedValue) //
{
TextBox1.Text = r[2].ToString();
break;
}
}
protected void Button1_Click(object sender, EventArgs e) //dobavi
{
SqlDataAdapter prodAdapter = new SqlDataAdapter("SELECT * FROM products", SqlProducts.ConnectionString);
DataSet ds = new DataSet();
prodAdapter.Fill(ds, "products");
SqlCommandBuilder sqlCb = new SqlCommandBuilder(prodAdapter); //
DataRow r = ds.Tables[0].NewRow(); ///
r[1] = TextBox2.Text;
r[2] = TextBox3.Text;
ds.Tables[0].Rows.Add(r); ///
prodAdapter.Update(ds, "products"); //////
DropDownList1.DataBind();
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e) //iztrii
{
SqlConnection scon = new SqlConnection(SqlProducts.ConnectionString);//
scon.Open(); //
SqlCommand cmd = new SqlCommand("DELETE FROM products WHERE productid=" + DropDownList1.SelectedValue, scon); ///
cmd.ExecuteNonQuery();
scon.Close();
GridView1.DataBind();
}
Няма коментари