SqlConnection myCon = new SqlConnection(WebConfigurationManager.ConnectionStrings["cs_dd"].ConnectionString);
string Constring = Convert.ToString(myCon.ConnectionString);
string sql = "Select * from businessact where businessactivity like '" + DropDownList1.SelectedValue +"%'";
SqlDataSource mySqlDs = new SqlDataSource(Constring, sql);
ddBA.DataSource = mySqlDs;
ddBA.DataTextField = "businessactivity";
ddBA.DataValueField = "ID";
ddBA.DataBind();
|
|