Hi, Sir i am getting an error while binding gridview which i have to send mail and insert into database at the same time data is being inserted in database but it gives error of 'Object reference not set to an instance of an object. ' and mail is not sent i am attacting the code for the same any help would we appreciated Thanks in advance
i am getting error at this line 'Label lblid = (Label)row.FindControl("ID");'
its says Object reference not set to an instance of an object.
protected void btnSubmit_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("Insert into tblBecomeAdvisor (Name,Contact,Email,Status) values('" + txtName.Text + "','" + txtxContact.Text + "','" + txtEmail.Text + "','1')", con);
cmd.ExecuteNonQuery();
con.Close();
txtEmail.Text = "";
txtName.Text = "";
txtxContact.Text = "";
GridViewRow row = ((Button)sender).NamingContainer as GridViewRow;
Label lblid = (Label)row.FindControl("ID");
Label lbladvisorcode = (Label)row.FindControl("AdvisorCode");
Label lblname = (Label)row.FindControl("lblname");
Label lblContactno = (Label)row.FindControl("lblContactno");
Label lblEmail = (Label)row.FindControl("lblEmail");
Label lbllstatus = (Label)row.FindControl("lbllstatus");
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("AdvisorCode", typeof(string));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("UserName", typeof(string));
dt.Columns.Add("Password", typeof(string));
dt.Columns.Add("Status", typeof(string));
DataRow dr = dt.NewRow();
dr["ID"] = Convert.ToInt32(lblid.Text);
dr["AdvisorCode"] = (lbladvisorcode.Text);
dr["Name"] = (lblname.Text);
dr["UserName"] = (lblEmail.Text);
dr["Password"] = Convert.ToDouble(lblContactno.Text);
//dt.Rows.Add(dr);
dr["Status"] = Convert.ToBoolean(lbllstatus.Text);
dt.Rows.Add(dr);
SendEmail(dt);
string ss = "update tblBecomeAdvisor set Status= '1' where ID=" + lblid.Text + "";
SqlDataReader dr1 = DB.GetRS(ss) as SqlDataReader;
if (!IsPostBack)
{
Advisorbind();
}
}
<center>
<asp:GridView ID="GridView2" Style="font-size: 9pt;" runat="server"
AutoGenerateColumns="False"
BackColor="White" BorderColor="#3A3A3A" BorderStyle="Double" BorderWidth="0px"
CellPadding="3" GridLines="Vertical" Width="100%" HeaderStyle-CssClass="GridHeader" >
<HeaderStyle HorizontalAlign="Center" />
<RowStyle HorizontalAlign="Center" />
<AlternatingRowStyle BackColor="#DCDCDC" CssClass="footable" />
<Columns>
<asp:TemplateField Visible="false" HeaderText="ID" >
<ItemTemplate>
<asp:Label ID="Id" runat="server" Text='<%# Eval("ID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField Visible="false" HeaderText="AdvisorCode">
<ItemTemplate>
<asp:Label ID="AdvisorCode" runat="server" Text='<%# Eval("AdvisorCode") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="lblname" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ContactNo">
<ItemTemplate>
<asp:Label ID="lblContactno" runat="server" Text='<%# Eval("Contact") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Email">
<ItemTemplate>
<asp:Label ID="lblEmail" runat="server" Text='<%# Eval("Email") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Status" Visible="false">
<ItemTemplate>
<asp:Label ID="lbllstatus" runat="server" Text='<%# Eval("Status") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Approve">
<ItemTemplate>
<%-- <asp:Label ID="lbllclick" runat="server"></asp:Label>--%>
<asp:Button ID="lbllclick" runat="server" OnClick="Onclick_Approve" Text="Approve" CssClass="btn btn-success btn-sm btn-line" Width="100%"/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Reject">
<ItemTemplate>
<%-- <asp:Label ID="lbllreject" runat="server"></asp:Label>--%>
<asp:Button ID="lbllreject" runat="server" Text="Reject" CssClass="btn btn-danger btn-sm btn-line" OnClick="OnClick_Reject" Width="100%" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#0000A9" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#000065" />
</asp:GridView>
</center>