OleDb til sql
Er der nogen der kan hjælpe mig med at få omskrevet nedestående kode til noget der bruge til en sql database??private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
string DbStr;
DbStr = Server.MapPath("db/db.mdb");
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+DbStr;
string strSQL = "Select * From db.tbl Where xx='"+Dropdownlist1.SelectedItem.Value+"';";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
objConnection.Open();
DropdownList1.DataSource = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
DropDownList1.DataTextField ="xx";
DropDownList1.DataValueField ="xx";
DropDownList1.DataBind();
}
