Getting Error while Updating.....
kindly help me to sort this issue.....
Object reference not set to an instance of an object.
Line 72: lblfirstname.Visible = false;
aspx page:
<table>
<tr style="height:30px">
<td></td>
</tr>
<tr>
<td>
<asp:Repeater ID="repeater1" runat="server" onitemcommand="RepterDetails3_ItemCommand">
<HeaderTemplate>
<table style="width:650px">
<tr style="background-color:#3b5998; color:White">
<td colspan="2" class="tourname_heading12" style="text-align:center">
<b>Admin Profile</b>
</td>
</tr>
<tr><td></td></tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<table style="width:650px" >
<tr>
<td style="width:150px"></td>
<td style="width:150px">
Firstname</td><td style="width:12px">:</td><td >
<%--<asp:Label ID="lbl_id" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "user_id")%>' Visible="false"></asp:Label>--%>
<asp:Label ID="lblfirstname" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "firstname")%>' Font-Bold="true"/>
<asp:TextBox ID="txtfirstname" runat="server" Width="490" Text='<%# DataBinder.Eval(Container.DataItem, "firstname")%>' Visible="false" class="feedback_textfield"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr >
<td colspan="1"> </td>
</tr>
<tr>
<td>
<table style=" width:650px" >
<tr>
<td style="width:150px"></td>
<td style="width:150px">
Lastname</td><td style="width:12px">:</td><td >
<asp:Label ID="lbllastname" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "lastname")%>' Font-Bold="true"/>
<asp:TextBox ID="txtlastname" runat="server" Width="490" Text='<%# DataBinder.Eval(Container.DataItem, "lastname")%>' Visible="false" class="feedback_textfield"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="1"> </td>
</tr>
<tr>
<td>
<table style="width:650px" >
<tr>
<td style="width:150px"></td>
<td style="width:150px">
Username</td><td style="width:12px">:</td><td style="text-align:left;margin-left:0" >
<asp:Label ID="lbluser" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "username")%>' Font-Bold="true" />
<asp:TextBox ID="txtuser" runat="server" Width="490" Text='<%# DataBinder.Eval(Container.DataItem, "username")%>' Visible="false" class="feedback_textfield"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="1"> </td>
</tr>
<tr>
<td>
<table style="width:650px" >
<tr>
<td style="width:150px"></td>
<td style="width:150px">
Email</td><td style="width:12px">:</td><td >
<asp:Label ID="lblemail" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "email")%>' Font-Bold="true"/>
<asp:TextBox ID="txtemail" runat="server" Width="490" Text='<%# DataBinder.Eval(Container.DataItem, "email")%>' Visible="false" class="feedback_textfield"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="1"> </td>
</tr>
<tr>
<td>
<table style=" width:650px" >
<tr>
<td style="width:150px"></td>
<td style="width:150px">
Gender</td><td style="width:12px">:</td><td >
<asp:Label ID="lblgender" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "gender")%>' Font-Bold="true"/>
<asp:TextBox ID="txtgender" runat="server" Width="490" Text='<%# DataBinder.Eval(Container.DataItem, "gender")%>' Visible="false" class="feedback_textfield"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="1"> </td>
</tr>
<tr>
<td>
<table style="width:650px" >
<tr>
<td style="width:150px"></td>
<td style="width:150px">
Date of Birth</td><td style="width:12px">:</td><td >
<asp:Label ID="lbldob" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "dob")%>' Font-Bold="true"/>
<asp:TextBox ID="txtdob" runat="server" Width="490" Text='<%# DataBinder.Eval(Container.DataItem, "dob")%>' Visible="false" class="feedback_textfield"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="1"> </td>
</tr>
<tr>
<td>
<table style=" width:650px" >
<tr>
<td style="width:150px"></td>
<td style="width:150px">
Phone No</td><td style="width:12px">:</td><td >
<asp:Label ID="lblphone" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "phoneno")%>' Font-Bold="true"/>
<asp:TextBox ID="txtphone" runat="server" Width="490" Text='<%# DataBinder.Eval(Container.DataItem, "phoneno")%>' Visible="false" class="feedback_textfield"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="1"> </td>
</tr>
<tr>
<td>
<table style=" width:650px" >
<tr>
<td style="width:150px"></td>
<td style="width:150px">
Address</td><td style="width:12px">:</td><td >
<asp:Label ID="lbladdress" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "address")%>' Font-Bold="true"/>
<asp:TextBox ID="txtaddress" runat="server" Height="73px" Width="490" TextMode="MultiLine" Text='<%# DataBinder.Eval(Container.DataItem, "address")%>' Visible="false" class="feedback_textfield"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</ItemTemplate>
<FooterTemplate>
<tr>
<td>
<table align="center"><tr><td>
<asp:LinkButton ID="lnkEdit" runat="server" CommandName="edit" Text="Edit" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "id") %>' CssClass="item_button">Edit</asp:LinkButton>
<asp:LinkButton Visible="false" ID="lnkUpdate" runat="server" CommandName="update" Text="Update" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "id") %>' CssClass="item_button">Update</asp:LinkButton>
<asp:LinkButton Visible="false" ID="lnkCancel" runat="server" CommandName="cancel" Text="Cancel" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "id") %>' CssClass="item_button">Cancel</asp:LinkButton>
</td>
</tr>
</table>
</td>
</tr>
</FooterTemplate>
</asp:Repeater>
</td>
</tr>
</table>
aspx.cs page
public partial class update_admin_profile : System.Web.UI.Page
{
string s1 = ConfigurationManager.ConnectionStrings["db"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindRepeater();
string s2 = Session["userid"].ToString();
}
}
private void BindRepeater()
{
string s2 = Session["userid"].ToString();
int i = Convert.ToInt32(s2);
SqlConnection SqlCnn = new SqlConnection(s1);
SqlCommand SqlCmd = new SqlCommand("select * from mla_registration where user_id='" + i + "'", SqlCnn);
SqlDataAdapter SqlAd1 = new SqlDataAdapter(SqlCmd);
DataSet ds = new DataSet();
SqlAd1.Fill(ds, "mla_registration");
repeater1.DataSource = ds;
repeater1.DataBind();
}
protected void RepterDetails3_ItemCommand(object source, RepeaterCommandEventArgs e)
{
LinkButton lnkUpdate = (LinkButton)e.Item.FindControl("lnkUpdate");
LinkButton lnkCancel = (LinkButton)e.Item.FindControl("lnkCancel");
LinkButton lnkEdit = (LinkButton)e.Item.FindControl("lnkEdit");
Label lbl_id = (Label)e.Item.FindControl("lbl_id");
Label lblfirstname = (Label)e.Item.FindControl("lblfirstname");
Label lbllastname = (Label)e.Item.FindControl("lbllastname");
Label lbluser = (Label)e.Item.FindControl("lbluser");
Label lblemail = (Label)e.Item.FindControl("lblemail");
Label lblgender = (Label)e.Item.FindControl("lblgender");
Label lbldob = (Label)e.Item.FindControl("lbldob");
Label lblphone = (Label)e.Item.FindControl("lblphone");
Label lbladdress = (Label)e.Item.FindControl("lbladdress");
TextBox txtfirstname = (TextBox)e.Item.FindControl("txtfirstname");
TextBox txtlastname = (TextBox)e.Item.FindControl("txtlastname");
TextBox txtuser = (TextBox)e.Item.FindControl("txtuser");
TextBox txtemail = (TextBox)e.Item.FindControl("txtemail");
TextBox txtgender = (TextBox)e.Item.FindControl("txtgender");
TextBox txtdob = (TextBox)e.Item.FindControl("txtdob");
TextBox txtphone = (TextBox)e.Item.FindControl("txtphone");
TextBox txtaddress = (TextBox)e.Item.FindControl("txtaddress");
if (e.CommandName == "edit")
{
lnkCancel.Visible = true;
lnkUpdate.Visible = true;
lnkEdit.Visible = false;
lblfirstname.Visible = false;
txtfirstname.Visible = true;
lbllastname.Visible = false;
txtlastname.Visible = true;
lbluser.Visible = false;
txtuser.Visible = true;
lblemail.Visible = false;
txtuser.Visible = true;
lblgender.Visible = false;
txtgender.Visible = true;
lbldob.Visible = false;
txtdob.Visible = true;
lblphone.Visible = false;
txtphone.Visible = true;
lbladdress.Visible = false;
txtaddress.Visible = true;
}
if (e.CommandName == "cancel")
{
BindRepeater();
}
if (e.CommandName == "update")
{
string s2 = Session["userid"].ToString();
int i = Convert.ToInt32(s2);
SqlConnection SqlCnn = new SqlConnection(s1);
SqlCommand SqlCmd = new SqlCommand("update mla_registration set firstname=@firstname,lastname=@lastname,username=@username,email=@email,gender=@gender,dob=@dob,phoneno=@phoneno,address=@address where user_id=@user_id", SqlCnn);
SqlCmd.Parameters.Add("@firstname", SqlDbType.VarChar).Value = txtfirstname.Text;
SqlCmd.Parameters.Add("@lastname", SqlDbType.VarChar).Value = txtlastname.Text;
SqlCmd.Parameters.Add("@username", SqlDbType.VarChar).Value = txtuser.Text;
SqlCmd.Parameters.Add("@email", SqlDbType.VarChar).Value = txtemail.Text;
SqlCmd.Parameters.Add("@gender", SqlDbType.VarChar).Value = txtgender.Text;
SqlCmd.Parameters.Add("@dob", SqlDbType.VarChar).Value = txtdob.Text;
SqlCmd.Parameters.Add("@phoneno", SqlDbType.VarChar).Value = txtphone.Text;
SqlCmd.Parameters.Add("@address", SqlDbType.VarChar).Value = txtaddress.Text;
SqlCmd.Parameters.Add("@user_id", SqlDbType.VarChar).Value = e.CommandArgument;
try
{
SqlCnn.Open();
SqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ex.Message.ToString();
}
finally
{
if (SqlCnn.State == ConnectionState.Open)
SqlCnn.Close();
}
BindRepeater();
}
}
kindly help me to sort this issue...
i have used session concept for viewing the details..
for viewing, no problem..
getting error while updating...