我第二次进入数据库时​​数据不会保存？ [英] Data Is Not Saving In Database When I Will Entered Second Time?

问题描述

第二次进入时，我点击保存按钮数据不保存在数据库中。

主要功能是第一次。单击保存按钮。所有字段都清除。



数据i不保存数据库

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

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

推荐答案

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
          
          }


}
}

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

<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 /文字广告或任何等效货币）
< / h5 >
< div style = clear：both; >
< / div >
<％ - < asp：FileUpload ID = FileTextAddsUpload runat = server CssClass = fileUpload /> - ％>
< asp：FileUpload ID = FileTextAddsUpload runat = server 宽度 = 210px CssClass = fileUpload / >
<％ - < asp：图片ID = Imagetextadd CssClass = ImageTextId runat = server / > - ％>
< div >
< asp：TextBox ID = txtEnterChar TextMode < span class =code-keyword> = MultiLine 占位符 = 输入要显示的文本（最大字符长度 - 160）

< span class =code-attribute> MaxLength = 160 CssClass = txtMaxChar runat = server < span class =code-keyword> / >
< / div >
< div style = clear：both; padding-top：12px; >
< / div >
< < span class =code-leadattribute> div >
< asp：按钮 ID = btnSave 文字 = 保存 可见 = true OnClick = btnSave_Click CssClass = btnCommon

runat = server / < span class =code-keyword>>
< asp：Button ID = btnClearEdits 可见 = true OnClick = btnClearEdits_Click < span class =code-attribute>文本 = 清除字段

< span class =code-attribute> CssClass = btnCommon runat = 服务器 / >
< / 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 = 服务器 >
< Columns>

< asp：TemplateField HeaderText = AddID >
< EditItemTemplate>
< asp：标签ID = lblTextAddID runat = server Text = ' <％＃Eval（AddId）％>' />
< / EditItemTemplate >
< ItemTemplate >
< asp：Label ID = lblItemAddID runat = server 文本 =' <％ #Eval（ AddId）％> ' / >
< / ItemTemplate >
< / asp：TemplateField >

< asp：TemplateField HeaderText = 图像 >
< 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 >
< < span class =code-leadattribute> ItemTemplate >
< asp：图像 ID = ImgSaveImage runat = server ImageUrl =' <％ #Eval（ TextAddImagePath）< span class =code-pagedirective>％> ' CssClass = ImageTextGrid / >
< / ItemTemplate >
< < span class =code-leadattribute> / asp：TemplateFie ld >

< asp：TemplateField HeaderText = Decsription >
< EditItemTemplate >
< asp：TextBox ID = txtEnterChar 文本 =' <％ #Eval（ MaxCharLength）％> ' TextMode = MultiLine 占位符 = 输入要显示的文本（最大字符长度 - 160） MaxLength = 160 CssClass = txtMaxChar runat = serv呃 / >
< / EditItemTemplate >
< ItemTemplate >
< asp：Label ID = lblEnterChar runat = server 文本 =' <％ #Eval（ MaxCharLength）％> ' / >
< / ItemTemplate >
</asp:TemplateField>
$b $b <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>

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>

这篇关于我第二次进入数据库时​​数据不会保存？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！