Good Day Priyadarshini.Thokala
my UI code
<asp:DataList ID="dl_profile" runat="server"
oncancelcommand="dl_profile_CancelCommand"
oneditcommand="dl_profile_EditCommand"
onupdatecommand="dl_profile_UpdateCommand"
DataKeyField="pk_registeration_id" onitemcommand="dl_profile_ItemCommand">
<HeaderTemplate><table width="408" border="0" cellspacing="0" cellpadding="0" class="formstyle"></HeaderTemplate>
<ItemTemplate>
<tr>
<td width="82" height="25"> Name :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><%#Eval("registeration_name")%></td>
</tr>
<tr>
<td height="25"> Email :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><%#Eval("registeration_email")%></td>
</tr>
<tr>
<td height="25"> DOB :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><%#Eval("registeration_datefbirth")%></td>
</tr>
<tr>
<td height="25"> Profession :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><%#Eval("registeration_profession")%></td>
</tr>
<tr>
<td height="25"> City :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><%#Eval("cityname")%>
<%----%>
</td>
</tr>
<tr>
<td height="18"></td>
<td colspan="3">
</td>
</tr>
<tr>
<td> </td>
<td >
<asp:ImageButton ID="imgbtn_edit" runat="server" ImageUrl="../images/editprofile.jpg" width="65px" height="18px" CommandName="edit" />
<asp:ImageButton ID="imgbtn_ok" runat="server" ImageUrl="../images/send.jpg" width="65px" height="18px" border="0" CommandName="ok" /></td>
<td > </td>
<td ></td>
</tr>
</ItemTemplate>
<EditItemTemplate>
<tr>
<td width="82" height="25"> Name :</td>
<td colspan="3" style=" border-removeddotted 1px #999999">
<asp:TextBox ID="txt_name" runat="server" MaxLength="35" Text='<%#Eval("registeration_name")%>'></asp:TextBox></td>
</tr>
<tr>
<td height="25"> Email :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><asp:TextBox ID="txt_email" MaxLength="100" runat="server" Text='<%#Eval("registeration_email")%>'></asp:TextBox></td>
</tr>
<tr>
<td height="25"> DOB :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><asp:TextBox ID="txt_dob" MaxLength="10" runat="server" Text='<%#Eval("registeration_datefbirth")%>'></asp:TextBox>
<asp:ImageButton ID="imgbtn_calender" runat="server" ImageUrl="../images/cal.gif" />
<cc1:CalendarExtender ID="CalendarExtender1" runat="server" PopupButtonID="imgbtn_calender" TargetControlID="txt_dob" Format="dd/MM/yyyy" >
</cc1:CalendarExtender>
</td>
</tr>
<tr>
<td height="25"> Profession :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><asp:TextBox ID="TextBox1" MaxLength="100" runat="server" Text='<%#Eval("registeration_profession")%>'></asp:TextBox></td>
</tr>
<tr>
<td height="25"> City :</td>
<td colspan="3" style=" border-removeddotted 1px #999999"><%----%>
<asp:DropDownList ID="ddlcity" runat="server" AppendDataBoundItems="True"><asp:ListItem Value="" Text="" /></asp:DropDownList>
</td>
</tr>
<tr>
<td height="28"> Image :</td>
<td colspan="3">
<asp:FileUpload ID="FileUpload1" runat="server" /></td>
</tr>
<tr>
<td height="10"></td>
<td colspan="3">
</td>
</tr>
<tr>
<td> </td>
<td>
<asp:ImageButton ID="imgbtn_update" runat="server" ImageUrl="~/images/update.jpg" width="65" height="18" CommandName="update" />
<asp:ImageButton ID="imgbtn_cancel" runat="server" ImageUrl="~/images/Cancel.jpg" width="65" height="18" CommandName="cancel" />
</td>
<td > </td>
<td ></td>
</tr>
</EditItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:DataList>
Code behind File's Code is
protected void dl_profile_EditCommand(object source, DataListCommandEventArgs e)
{
dl_profile.EditItemIndex = e.Item.ItemIndex;
objProp.Action = "1";
binddata();
bindImage();
}
public void bindImage()
{
int result = 0;
objProp.Dataset = blogic.Fetch_registration(ref result, objProp);
dl_profile_img.DataSource = objProp.Dataset;
dl_profile_img.DataBind();
}
public void binddata()
{
int result = 0;
objProp.Dataset = blogic.Fetch_registration(ref result, objProp);
dl_profile.DataSource = objProp.Dataset;
dl_profile.DataBind();
}
protected void dl_profile_ItemDataBound1(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.EditItem)
{
DropDownList ddl = e.Item.FindControl("ddlcity") as DropDownList;
if (ddl != null)
{
lstitem.Clear();
lstitem = blogic.Citydata(objProp);
blogic.fills((DropDownList)e.Item.FindControl("ddlcity"), lstitem);
}
}
}
Class code
public void fills(DropDownList dp, List<ListItem> lstitem)
{
try
{
for (int i = 0; i < lstitem.Count; i++)
{
ListItem li = new ListItem();
li.Text = lstitem[i].Text.ToString();
li.Value = lstitem[i].Value.ToString();
dp.Items.Add(li);
}
}
catch (Exception ex)
{ }
}
public List<ListItem> Citydata(Property objProp)
{
objProp.City = "";
if (objProp.City != "")
objProp.Query = "select a.pk_cityid,a.cityname,b.registeration_city from city a inner join registration b on b.registeration_city = a.pk_cityid where a.registeration_userid='" + objProp.Userid + "'";
else
objProp.Query = "select * from city";
objProp.Reader = DataLayer.ExecuteReader(objProp.Connection, CommandType.Text, objProp.Query);
ListItem li = new ListItem();
li.Attributes.Clear();
li.Text = "Select";
li.Value = "-1";
lstitem.Add(li);
while (objProp.Reader.Read())
{
li = new ListItem();
li.Text = objProp.Reader["cityname"].ToString();
li.Value = objProp.Reader["pk_cityid"].ToString();
lstitem.Add(li);
}
objProp.Reader.Close();
return lstitem;
}
public DataSet Fetch_registration(ref int result, Property objProp)
{ try
{
if (objProp.Action == "1")
{
objProp.Query = "SELECT reg.pk_registeration_id,reg.registeration_userid,reg.registeration_name,reg.registeration_email,reg.registeration_datefbirth,reg.registeration_uimage,reg.registeration_profession FROM registeration AS reg INNER JOIN city AS ct ON ct.pk_cityid = reg.registeration_city WHERE reg.registeration_userid='" + objProp.Userid + "' ";
}
else { objProp.Query = "SELECT reg.pk_registeration_id,reg.registeration_userid,reg.registeration_name,reg.registeration_email,reg.registeration_datefbirth,reg.registeration_uimage,ct.cityname,reg.registeration_profession FROM registeration AS reg INNER JOIN city AS ct ON ct.pk_cityid = reg.registeration_city WHERE reg.registeration_userid='" + objProp.Userid + "' "; }
objProp.Dataset = DataLayer.ExecuteDataset(objProp.Connection, CommandType.Text, objProp.Query);
}
catch (Exception ex)
{ }
return objProp.Dataset;
}
There are 2 tables
1 have value of cityid,stateid and city name <-table name city
2 have value of profile details like city,proffession,etc.. <-table name registration
It's working nice...