protected void btnUruAra_Click(object sender, EventArgs e){string connectionString1 = ConfigurationManager.ConnectionStrings["caglayanCS"].ConnectionString;if (tbUrunAra.Text != string.Empty)using (SqlConnection connection1 = new SqlConnection(connectionString1))using (SqlCommand command1 = new SqlCommand("SELECT * FROM urunTablosu WHERE urunadi like'%" + tbUrunAra.Text + "%' ", connection1)){connection1.Open();/* using (SqlDataReader dr = command1.ExecuteReader(CommandBehavior.CloseConnection)){*/SqlDataAdapter da = new SqlDataAdapter(command1);DataSet ds = new DataSet();da.Fill(ds);DataList1.DataSource = ds;DataList1.DataBind();// }connection1.Close();}}
ASP.Net Datalist Veri Arama
Kaydol:
Kayıtlar (Atom)
Hiç yorum yok:
Yorum Gönder