i used asp.net = DetailsView1,DropDownList1,Entities DataBase
in asp.net
<asp:dropdownlist id="DropDownList1" runat="server" datatextfield="Name" datavaluefield="UserName" xmlns:asp="#unknown"></asp:dropdownlist><br />
in c# code for DropDownList1:
if (!IsPostBack)
{
try
{
{
using (DBNezamEntities db = new DBNezamEntities())
{
var Query = from ro in db.Profiles.AsEnumerable()
select new
{
UserName = ro.User.UserName,
Name = getpro(ro.User.UserName)
};
var Query2 = from val in Query
orderby val.Name ascending
select val;
DropDownList1.DataSource = Query2;
DropDownList1.DataBind();
}
}
}
catch (Exception)
{
throw;
}
}
for save data in database:
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
e.Values["UserName"] = DropDownList1.SelectedValue.ToString();
}