priyadharshan sekar

NA
23
28.5k

Getting Error: object reference not set to an instance of an

May 5 2014 9:56 AM

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>

<tr>

<td>

<asp:Repeater ID="repeater1" runat="server" onitemcommand="RepterDetails3_ItemCommand">

<b>Admin Profile</b>

</td>

</tr>

</table>

</HeaderTemplate>

<tr>

<td>

<tr>

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 >

</tr>

<tr>

<td>

<tr>

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>

</tr>

<tr>

<td>

<tr>

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>

</tr>

<tr>

<td>

<tr>

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>

</tr>

<tr>

<td>

<tr>

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>

</tr>

<tr>

<td>

<tr>

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>

</tr>

<tr>

<td>

<tr>

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>

</tr>

<tr>

<td>

<tr>

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>

</tr>

</ItemTemplate>

<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...

Answers (1)

how to write code in c# for generate xml

Passing value from code behind to .ascx file