Data Is Not Saving In Database When I Will Entered Second Time?

Question

3.43/5 (3 votes)

See more:

when will entered second time, I click save button Data is not saving in database.
The main functionality is first Time .After click Save button ..All fields are Cleared.

Data i not Saving database

C#

int id = 0;
if (FileTextAddsUpload.HasFile)
{
   string FileName = Path.GetFileName(FileTextAddsUpload.PostedFile.FileName);
   string exten = Path.GetExtension(FileName);
   if (exten == ".png" || exten == ".PNG" || exten == ".jpg" || exten == ".JPG" || exten == ".jpeg" || exten == ".JPEG" || exten == ".gif" || exten == ".GIF")
   {
      FileTextAddsUpload.SaveAs(Server.MapPath("~/Images/" + FileName));
      con.Open();
      id++;
      SqlCommand cmd = new SqlCommand("InsertTextAdd_SP", con);
      cmd.CommandType = CommandType.StoredProcedure;
      cmd.Parameters.AddWithValue("@TextAddImagePath", "~/Images/" + FileName);
      cmd.Parameters.AddWithValue("@MaxCharLength", txtEnterChar.Text);
      cmd.Parameters.AddWithValue("@Price", id);
      cmd.ExecuteNonQuery();
      con.Close();
      Imagetextadd.Visible = true;
      FileTextAddsUpload.ID = FileTextAddsUpload.FileName;

   }
   ClearControls();
}

Unnecesary code block removed
Tabulation reduced

Posted 14-Mar-14 21:21pm

Sai Prasad anumolu

Updated 15-Mar-14 3:58am

Nelek

v4

Add a Solution

Comments

JoCodes 15-Mar-14 3:25am

Can see a ClearControl method which obviously should be clearing your input control data. Make the question clear.

Sai Prasad anumolu 15-Mar-14 3:27am

After Saving Fields are clearing ...Sir

Tom Marvolo Riddle 15-Mar-14 3:29am

do you don't want to clear after insert?

Tom Marvolo Riddle 15-Mar-14 3:28am

Not clear.Improve your question

Sai Prasad anumolu 15-Mar-14 3:28am

After Saving Fields are clearing ...Sir

private void ClearControls()
{
txtEnterChar.Text = "";
FileTextAddsUpload.ID = "";
}

Tom Marvolo Riddle 15-Mar-14 3:30am

Remove this and let me know

ClearControls();

Sai Prasad anumolu 15-Mar-14 3:33am

Functionality ..Is When i entered data after click save button all fields are cleared

Tom Marvolo Riddle 15-Mar-14 3:34am

do you want to clear after insert?

Sai Prasad anumolu 15-Mar-14 3:38am

After insert i cleared ..But i need Another Time Data entered Click Save button data is not saving in database jas

Tom Marvolo Riddle 15-Mar-14 3:40am

so you want to save two times after that you have to clear the text field.am i right?

Sai Prasad anumolu 15-Mar-14 3:49am

Yes...1st time i entered Details Click Save Button ..Data is saving in database ..After Fileds are cleared

and ..2nd time i entered Details Click Save Button ..Data is not saving in database ..After Fileds are cleared

Tom Marvolo Riddle 15-Mar-14 3:55am

Hi sai,when fields get cleared then how can u insert?

Sai Prasad anumolu 15-Mar-14 4:20am

Sir Send me U r Email Id I will send Code..To u r email

Siva Hyderabad 15-Mar-14 5:03am

i think ,you are taken primary key column in your table ,that why it's not entered..and after exection of your procedure ,you are calling the ClearControls() method..that's why it cleared.....

Sai Prasad anumolu 15-Mar-14 5:05am

Clear means add another record ..And Send me u r email ID i will send Code

Sai Prasad anumolu 15-Mar-14 5:32am

Open Word Document and Send me..........

Sai Prasad anumolu 15-Mar-14 5:40am

Anna Sended ...

Sai Prasad anumolu 15-Mar-14 5:58am

Sended 2 emails

Siva Hyderabad 20-Mar-14 7:01am

public static void FillDataset(SqlConnection connection, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames);
public static void FillDataset(SqlConnection connection, string spName, DataSet dataSet, string[] tableNames, params object[] parameterValues);
public static void FillDataset(SqlTransaction transaction, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames);
public static void FillDataset(SqlTransaction transaction, string spName, DataSet dataSet, string[] tableNames, params object[] parameterValues);
public static void FillDataset(string connectionString, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames);
public static void FillDataset(string connectionString, string spName, DataSet dataSet, string[] tableNames, params object[] parameterValues);
public static void FillDataset(SqlConnection connection, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters);
public static void FillDataset(SqlTransaction transaction, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters);
public static void FillDataset(string connectionString, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters);
public static void UpdateDataset(SqlCommand insertCommand, SqlCommand deleteCommand, SqlCommand updateCommand, DataSet dataSet, string tableName);

Siva Hyderabad 20-Mar-14 9:53am

Siva Hyderabad 22-Mar-14 3:30am

2 solutions

Add a Solution

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)

Raajkumar.b · Accepted Answer · 2014-03-14T21:48:00

initially declare like this
static int count=0;
in btn_click()
{
  
  if(count!=1)
{
          int id int id = 0;
          if (FileTextAddsUpload.HasFile)
          {
              string FileName = Path.GetFileName(FileTextAddsUpload.PostedFile.FileName);
              string exten = Path.GetExtension(FileName);
              if (exten == ".png" || exten == ".PNG" || exten == ".jpg" || exten == ".JPG" || exten == ".jpeg" || exten == ".JPEG" || exten == ".gif" || exten == ".GIF")
              {
                  FileTextAddsUpload.SaveAs(Server.MapPath("~/Images/" + FileName));
                  con.Open();
                  id++;
                  SqlCommand cmd = new SqlCommand("InsertTextAdd_SP", con);
                  cmd.CommandType = CommandType.StoredProcedure;
                  cmd.Parameters.AddWithValue("@TextAddImagePath", "~/Images/" + FileName);
                  cmd.Parameters.AddWithValue("@MaxCharLength", txtEnterChar.Text);
                  cmd.Parameters.AddWithValue("@Price", id);
                  cmd.ExecuteNonQuery();
                  con.Close();
                  Imagetextadd.Visible = true;
                  FileTextAddsUpload.ID = FileTextAddsUpload.FileName;
                 count++;
                 ClearControls();
 
              }

              }
          }
        else
         {
          // here display messge like data is saved already
          
          }


}
}

Siva Hyderabad · Accepted Answer · 2014-03-15T02:32:00

C#

protected void btnSave_Click(object sender, EventArgs e)
       {
           int id = 0;
           //ClearControls();

           string filepath = FileTextAddsUpload.PostedFile.FileName;
           string filename = Path.GetFileName(filepath);
           string ext = Path.GetExtension(filename);
           string filename1 = Path.GetFileName(FileTextAddsUpload.PostedFile.FileName);
           string dir = @"D:\RetailAgreement\";  // folder locations
           if (!Directory.Exists(dir))
           {
               Directory.CreateDirectory(dir);
               FileTextAddsUpload.SaveAs(dir + filename1);
           }
           else
           {
               FileTextAddsUpload.SaveAs(dir + filename1);
           }
           if (ext == ".png" || ext == ".PNG" || ext == ".jpg" || ext == ".JPG" || ext == ".jpeg" || ext == ".JPEG" || ext == ".gif" || ext == ".GIF")
           {
               con.Open();
               id++;
               SqlCommand cmd = new SqlCommand("InsertTextAdd_SP", con);
               cmd.CommandType = CommandType.StoredProcedure;
               cmd.Parameters.AddWithValue("@TextAddImagePath", "~/Images/" + filename);
               cmd.Parameters.AddWithValue("@MaxCharLength", txtEnterChar.Text);
               cmd.Parameters.AddWithValue("@Price", id);
               cmd.ExecuteNonQuery();
               con.Close();
              // Imagetextadd.Visible = true;
              // FileTextAddsUpload.ID = FileTextAddsUpload.FileName;
               ClearControls();
           }


           else
           {
               ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "Message", "alert('Data is not saved in Database,please debug once prasad')", true);

           }

       }


       protected void btnClearEdits_Click(object sender, EventArgs e)
       {
           txtEnterChar.Text = "";
           FileTextAddsUpload.ID = "";
       }


       private void ClearControls()
       {
           txtEnterChar.Text = "";
           FileTextAddsUpload.Attributes.Clear();
       }

copy body tag in your source page

XML

<body>
    <form id="form1" runat="server">
    <div id="wrapper">
        <div id="TextAdd" class="Border" runat="server">
            <h5>
                Text Ads (Image Formats: Jpeg, Png, Gif) ($1/Text Ad or any equivalent currency)
            </h5>
            <div style="clear: both;">
            </div>
            <%--<asp:FileUpload ID="FileTextAddsUpload" runat="server" CssClass="fileUpload" />--%>
            <asp:FileUpload ID="FileTextAddsUpload" runat="server" Width="210px" CssClass="fileUpload" />
            <%--<asp:Image ID="Imagetextadd" CssClass="ImageTextId" runat="server" />--%>
            <div>
                <asp:TextBox ID="txtEnterChar" TextMode="MultiLine" placeholder="Enter Text to display (Max Character Length - 160)"
                    MaxLength="160" CssClass="txtMaxChar" runat="server" />
            </div>
            <div style="clear: both; padding-top: 12px;">
            </div>
            <div>
                <asp:Button ID="btnSave" Text="Save" Visible="true" OnClick="btnSave_Click" CssClass="btnCommon"
                    runat="server" />
                <asp:Button ID="btnClearEdits" Visible="true" OnClick="btnClearEdits_Click" Text="Clear Fields"
                    CssClass="btnCommon" runat="server" />
            </div>
            <%--<div>
                    <asp:GridView ID="GridTextAdds" CssClass="Gridview" AutoGenerateColumns="false" DataKeyNames="AddId" OnRowEditing="GridTextAdds_RowEditing" OnRowUpdating="GridTextAdds_RowUpdating" OnRowDeleting="GridTextAdds_RowDeleting" OnRowCancelingEdit="GridTextAdds_RowCancelingEdit" runat="server">
                        <Columns>

                            <asp:TemplateField HeaderText="AddID">
                                <EditItemTemplate>
                                    <asp:Label ID="lblTextAddID" runat="server" Text='<%#Eval("AddId") %>' />
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblItemAddID" runat="server" Text='<%#Eval("AddId") %>' />
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Images">
                                <EditItemTemplate>
                                    <asp:FileUpload ID="FileTextAddsNewUpload" FileName='<%# Bind("ImgSaveImage")%>' runat="server" CssClass="fileUpload" onchange="UploadImage1(this)" />
                                    <asp:Image ID="ImgSaveImage" runat="server" ImageUrl='<%#Eval("TextAddImagePath") %>' CssClass="ImageTextGrid" />
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Image ID="ImgSaveImage" runat="server" ImageUrl='<%#Eval("TextAddImagePath") %>' CssClass="ImageTextGrid" />
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Decsription">
                                <EditItemTemplate>
                                    <asp:TextBox ID="txtEnterChar" Text='<%#Eval("MaxCharLength") %>' TextMode="MultiLine" placeholder="Enter Text to display (Max Character Length - 160)" MaxLength="160" CssClass="txtMaxChar" runat="server" />
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="lblEnterChar" runat="server" Text='<%#Eval("MaxCharLength") %>' />
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField>
                                <EditItemTemplate>
                                    <asp:ImageButton ID="ImgTextAddUpdate" CommandName="Update" runat="server" ImageUrl="~/Images/update.png" ToolTip="Update" />
                                    <asp:ImageButton ID="ImgTextAddCancel" CommandName="Cancel" runat="server" ImageUrl="~/Images/cancel.png" ToolTip="Cancel" />
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:ImageButton ID="ImgTextAddEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/edit.png" ToolTip="Update" />
                                    <asp:ImageButton ID="ImgTextAddDelete" CommandName="Delete" runat="server" ImageUrl="~/Images/Delete.png" ToolTip="Cancel" />
                                    <asp:Button ID="btnTextAddDuplicate" Text="Duplicate" Visible="true" CssClass="btnCommon" runat="server" />
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                    </asp:GridView>

                </div>--%>
        </div>
    </div>
    </form>
</body>

Data Is Not Saving In Database When I Will Entered Second Time?

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0