public void Listar()
{
SqlDataAdapter d = new SqlDataAdapter("select Marca from Marcas", con);
DataTable data = new DataTable();
d.Fill(data);
D1.DataTextField = "Marca";
D1.DataValueField = "Marca";
D1.DataSource = data;
D1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from Product";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
D1.DataSource = dt;
D1.DataBind();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("yeni3.aspx");
}
else
{
id = Request.QueryString["id"].ToString();
baglan.baglan.Open();
SqlCommand cmd = new SqlCommand("Select * from urun where id='" + id + "'", baglan.baglan);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
D1.DataSource = dt;
D1.DataBind();
baglan.baglan.Close();
}
}