Why records are not updating by this coading

Question

1.00/5 (2 votes)

See more:

Why Syntax error is giveing and also data is not going to table.?

My coading is given below

C#

<head>
</head>
<body>
<form  runat="server">
<table><tr>
                            <td>Applicant Name :-<asp:TextBox ID="txtName" runat="server"/>
                          </td>
                          <td width="1%"> </td>
                          <td width="12%"><span class="style1">Father Name:-</span></td>
                          <td width="35%"><label>
                            <asp:TextBox ID="txtFather" runat="server"/>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Date of Birth:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtDOB" runat="server"/>
                          </label></td>
                          <td> </td>
                          <td><span class="style1">Place of Birth:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtPOB" runat="server"/>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Residence Address:-</span></td>
                          <td><label>
                            <textarea id="txtAdd"  runat="server"></textarea>
                          </label></td>
                          <td> </td>
                          <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td width="30%"><span class="style1">City:-</span></td>
                                <td width="70%"><label>
                                  <asp:TextBox ID="txtCity" runat="server"/>
                                </label></td>
                              </tr>
                              <tr>
                                <td height="2" colspan="2"><img src="images/blank.gif" width="1" height="1" /></td>
                              </tr>
                              <tr>
                                <td><span class="style1">State:-</span></td>
                                <td><label>
                                  <asp:TextBox ID="txtState" runat="server"/>
                                </label></td>
                              </tr>
                          </table></td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Mobile No:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtMob" runat="server"/>
                          </label></td>
                          <td> </td>
                          <td><span class="style1">Pin Code:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtPCode" runat="server"/>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Nominee's Name:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtNominee" runat="server"/>
                          </label></td>
                          <td> </td>
                          <td><span class="style1">Relationship:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtRelation" runat="server"/>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">PAN No.:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtPAN" runat="server"/>
                          </label></td>
                          <td> </td>
                          <td colspan="2"> </td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Upload your Photo:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtPhoto" runat="server"/>
                          </label></td>
                          <td colspan="3"><label></label>                            <input name="file" type="file" id="File1" text="Upload Photo"  runat="server" /></td>
                          </tr>
                        <tr>
                          <td height="15" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td colspan="5"><span class="style9">Bank Details</span></td>
                        </tr>
                        <tr>
                          <td height="5" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Bank Name:-</span></td>
                          <td><span class="style1">
                            <label>
                            <asp:TextBox ID="txtBank" runat="server"/>                            </label>
                          </span></td>
                          <td><span class="style3"></span></td>
                          <td><span class="style1">Branch:-</span></td>
                          <td><span class="style1">
                            <label>
                            <asp:TextBox ID="txtBranch" runat="server"/>                            </label>
                          </span></td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Account No.:-</span></td>
                          <td><span class="style1">
                            <label>
                            <asp:TextBox ID="txtAccount" runat="server"/>                            </label>
                          </span></td>
                          <td><span class="style3"></span></td>
                          <td><span class="style1">Account Type:-</span></td>
                          <td><span class="style1">
                            <label><asp:DropDownList ID="ddAccType" runat="server">
                            <asp:ListItem>Current</asp:ListItem>
                            <asp:ListItem>Saving</asp:ListItem>
                            </asp:DropDownList>
                            </label>
                          </span></td>
                        </tr>
                        <tr>
                          <td height="15" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td colspan="5"><span class="style9">Necessary Details</span></td>
                        </tr>
                        <tr>
                          <td height="5" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Introduced by:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtIntro" runat="server"/>
                          </label></td>
                          <td> </td>
                          <td><span class="style1">Code No.:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtCodno" runat="server"/>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Date of Issue:-</span></td>
                          <td><label>
                            <asp:TextBox ID="txtDOI" runat="server"/>
                          </label></td>
                          <td> </td>
                          <td><span class="style1">Referance No:-</span></td>
                          <td><asp:TextBox ID="txtRefNo" runat="server"/></td>
                        </tr>
                        <tr>
                          <td height="2" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                        </tr>
                        <tr>
                          <td><span class="style1">Agent Code:-</span></td>
                          <td colspan="4"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr>
                              <td width="26%"><label>
                                <asp:TextBox ID="txtACode" runat="server"/>
                              </label></td>
                              <td width="4%"> </td>
                              <td width="18%"><span class="style1">Agent Points:-</span></td>
                              <td width="52%"><label>
                                <asp:TextBox ID="txtPoints" runat="server"/>
                              </label></td>
                            </tr>
                          </table></td>
                        </tr>
                        <tr>
                          <td height="4" colspan="5"><img src="images/blank.gif" width="1" height="1" /></td>
                          </tr>
                        <tr>
                          <td> </td>
                          <td colspan="4"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr>
                              <td width="12%"><label>
                                <asp:Button ID="b1" Text="Submit" OnClick="submit" runat="server"/>
                              </label></td>
                              <td width="12%"><label>
                                <asp:Button ID="b2" Text="Search" OnClick="srch" runat="server"/>
                              </label></td>
                              <td width="13%"><label>
                                <asp:Button ID="b3" Text="Delete" runat="server" OnClick="del"/>
                              </label></td>
                              <td width="13%"><label>
                                <asp:Button ID="b4" Text="Logout" runat="server"/>
                              </label></td><td></td>
                              <td width="50%"><label>
                                                             </label></td>
                            </tr>
                          </table></td>
                        </tr>
                        <tr>
                          <td> </td>
                          <td colspan="4"><asp:Placeholder ID="ph1" runat="server"/></td>
                        </tr>
                      </table>
                                        
                    </form></body>
</html>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<%@Page Language="C#" Debug="true" %>
<script  runat="server">

OleDbConnection con;
OleDbCommand com;
OleDbDataAdapter da;
DataSet ds;

void page_Load(Object sender,EventArgs e)
{
string refno = Request.QueryString["REFNO"];
con=new OleDbConnection();
con.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/Kamnagroup.mdb") + "";
con.Open();
ds=new DataSet();
string sql="select * from joining";
da=new OleDbDataAdapter(sql,con);
da.Fill(ds,"joining");

int r=0;
DataRow []rs;
rs=ds.Tables["joining"].Select("refno='" + refno + "'");
r=rs.Length;
if(r>0)
{
DataRow dr;
dr=rs[0];
txtName.Text=dr["aname"].ToString();
txtFather.Text=dr["fathname"].ToString();
txtDOB.Text=dr["dob"].ToString();
txtPOB.Text=dr["pob"].ToString();
txtAdd.Value=dr["add1"].ToString();
txtMob.Text=dr["mob"].ToString();
txtCity.Text=dr["city"].ToString();
txtState.Text=dr["state"].ToString();
txtPCode.Text=dr["pcode"].ToString();
txtPAN.Text=dr["panno"].ToString();
txtNominee.Text=dr["nominee"].ToString();
txtRelation.Text=dr["relation"].ToString();
txtPhoto.Text=dr["photo"].ToString();
txtBank.Text=dr["bank"].ToString();
txtBranch.Text=dr["branch"].ToString();
txtAccount.Text=dr["account"].ToString();
//ddAccType.SelectedItem.Text=dr["acctype"].ToString();
txtIntro.Text=dr["intby"].ToString();
txtCodno.Text=dr["codno"].ToString();
txtDOI.Text=dr["DOI"].ToString();
txtRefNo.Text=dr["refno"].ToString();
}
con.Close();
}
void del(Object Sender, EventArgs e)
{
con.Open();
ds=new DataSet();
string sql="select * from joining";
da=new OleDbDataAdapter(sql,con);
da.Fill(ds,"joining");

int r=0;
DataRow []rs;
rs=ds.Tables["joining"].Select("agent='" + txtACode.Text.Trim() + "'");
r=rs.Length;

if(r>0)
{
DataRow dr;
dr=rs[0];
com=con.CreateCommand();
com.CommandText="delete * from joining where agent='" + txtACode.Text.Trim() + "'";
}
else
{
com.ExecuteNonQuery();
System.Web.UI.WebControls.Label lbl1=new System.Web.UI.WebControls.Label();
lbl1.ForeColor=System.Drawing.Color.Yellow;
lbl1.BackColor=System.Drawing.Color.Blue;
lbl1.Text="Please Enter a valid Agent code to delete";
ph1.Controls.Add(lbl1);
}
try
{
com.ExecuteNonQuery();
System.Web.UI.WebControls.Label lbl1=new System.Web.UI.WebControls.Label();
lbl1.ForeColor=System.Drawing.Color.Blue;
lbl1.BackColor=System.Drawing.Color.Yellow;
lbl1.Text="Record DELETED";
ph1.Controls.Add(lbl1);
}
catch(Exception ex)
{
}
con.Close();
}
void srch(Object sender,EventArgs e)
{
con.Open();
ds=new DataSet();
string sql="select * from joining";
da=new OleDbDataAdapter(sql,con);
da.Fill(ds,"joining");

int r=0;
DataRow []rs;
rs=ds.Tables["joining"].Select("agent='" + txtACode.Text.Trim() + "'");
r=rs.Length;
if(txtACode.Text=="")
{
System.Web.UI.WebControls.Label lbl1=new System.Web.UI.WebControls.Label();
lbl1.ForeColor=System.Drawing.Color.Yellow;
lbl1.BackColor=System.Drawing.Color.Blue;
lbl1.Text="Please enter a Agent Code to search";
ph1.Controls.Add(lbl1);
}
else if(r>0)
{
DataRow dr;
dr=rs[0];
txtName.Text=dr["aname"].ToString();
txtFather.Text=dr["fathname"].ToString();
txtDOB.Text=dr["dob"].ToString();
txtPOB.Text=dr["pob"].ToString();
txtAdd.Value=dr["add1"].ToString();
txtMob.Text=dr["mob"].ToString();
txtCity.Text=dr["city"].ToString();
txtState.Text=dr["state"].ToString();
txtPCode.Text=dr["pcode"].ToString();
txtPAN.Text=dr["panno"].ToString();
txtNominee.Text=dr["nominee"].ToString();
txtRelation.Text=dr["relation"].ToString();
txtPhoto.Text=dr["photo"].ToString();
txtBank.Text=dr["bank"].ToString();
txtBranch.Text=dr["branch"].ToString();
txtAccount.Text=dr["account"].ToString();
ddAccType.SelectedItem.Text=dr["acctype"].ToString();
txtIntro.Text=dr["intby"].ToString();
txtCodno.Text=dr["codno"].ToString();
txtDOI.Text=dr["DOI"].ToString();
txtRefNo.Text=dr["refno"].ToString();
}
else
{
com.ExecuteNonQuery();
System.Web.UI.WebControls.Label lbl1=new System.Web.UI.WebControls.Label();
lbl1.ForeColor=System.Drawing.Color.Yellow;
lbl1.BackColor=System.Drawing.Color.Blue;
lbl1.Text="Record does not Exist";
ph1.Controls.Add(lbl1);

}
con.Close();
}
void submit(Object s, EventArgs e)
{
con.Open();
com=con.CreateCommand();
if(con!=null)
 {
com.CommandText="UPDATE joining SET aname = '" + txtName.Text.Trim() + "' where refno='" + txtRefNo.Text.Trim() + "'";
try{
com.ExecuteNonQuery();
System.Web.UI.WebControls.Label lbl1=new System.Web.UI.WebControls.Label();
lbl1.ForeColor=System.Drawing.Color.Yellow;
lbl1.BackColor=System.Drawing.Color.Blue;
lbl1.Text="Your record UPDATED sucessfully";
ph1.Controls.Add(lbl1);
}
catch(Exception ex)
{
Response.Write(ex.Message);
}}
con.Close();
}
</script>

Posted 19-Jan-12 21:22pm

Janardan Pandey

Updated 19-Jan-12 21:30pm

Anuja Pawar Indore

v2

Add a Solution

Comments

Anuja Pawar Indore 20-Jan-12 3:30am

Added pre tag

Prerak Patel 20-Jan-12 3:33am

What is the error? and post only relevant code in question.

OriginalGriff 20-Jan-12 3:42am

That is called a code dump, and it is considered rude.
If you want help, help us to help you. We do not want to wade through all that to try and work out which line as the syntax error, nor to work out why (if it didn't have the syntax error) it doesn't do what you want.
Instead, post only the relevant code fragment - the offending line plus a few above and below, with some indication of the line that errors, and exactly what the error message is.
Use the "Improve question" widget to edit your question and provide better information.

Varun Sareen 2-Feb-12 0:24am

Please show us the line in which the error is coming. The whole lot of code is liek you are frustrated with the code you write and you want us to orrect it fully. This is really rude.

Improve the question

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)