ASP.NET

How to Insert HTML into database using C# and ASP.Net

3-Jan-14 15:26

hello amigos.
I have a Gridview and i want to connect to the my database (by wizard)and i want to enable Delete but GenerateInsertUpdateDelete option in the AdvancedSqlGenerationOption window is disabled.
who know why?

Member 102589521-Jan-14 23:03

Member 10258952

1-Jan-14 23:03

1] It's requirement of one of my project that i need to store a HTML Code which contains various controls in SQL Server Database and retrieve it as a HTML page,so that all controls on the page get rendered properly.

2] How to store Website Template in SQL Database

Re: How to Insert HTML into database using C# and ASP.Net

Keith Barrow2-Jan-14 0:25

Keith Barrow

2-Jan-14 0:25

It sounds like you are trying to write a CRM system, there are free ones available on the Internet, you might want to check these out as writing these is much harder than it looks on face-value.

To answer your question directly, you just store the HTML as you would any text. If you want to programatically add stuff into the template, you'll need to provide placeholders to insert into. e.g.

HTML

<html>
  <head>
    <title>
      The title of this page is {{title}}
    </title>
  <head>
</thml>

Then you just perform a text susbstition. You can put the results of this into an ASP.NET literal control (though the above template wouldn't be valid as the literal will be inside a form in which you'd be declaring a html document), or write to the repsonse stream

Note that you'll difficulty "injecting" ASP.NET controls to the form like this, though the HTML controls will be fine. You might want to look at ASP.NET MVC, if you have time, it is much more suited to this type of work.

PB 369,783 wrote:
I just find him very unlikeable, and I think the way he looks like a prettier version of his Mum is very disturbing.[^]

Re: How to Insert HTML into database using C# and ASP.Net

ZurdoDev3-Jan-14 3:34

ZurdoDev

3-Jan-14 3:34

There are only 10 types of people in the world, those who understand binary and those who don't.

i need to have basic codes to create a website

Sri Nithi1-Jan-14 19:05

Sri Nithi

1-Jan-14 19:05

I want some basic knowledge to create a website

Peter Leow1-Jan-14 19:21

Peter Leow

1-Jan-14 19:21

Learn from here: asp.net-tutorials[^]

I second this recommendation.

thatraja1-Jan-14 19:54

thatraja

1-Jan-14 19:54

Beginner's Walk - Web Development[^]

thatraja

Code converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

David C# Hobbyist.3-Jan-14 12:05

David C# Hobbyist.

3-Jan-14 12:05

Those articles helped me a couple of years ago.

David

ZurdoDev3-Jan-14 3:33

ZurdoDev

3-Jan-14 3:33

Then you came to the right place. There are many articles on this site that you can go through and even filter down to what you are specifically looking for. And if you get stuck on something specific you can ask in the QA section.

Good luck to you.

There are only 10 types of people in the world, those who understand binary and those who don't.

a problem with ScriptManagerProxy

Harikrishnanvr7-Jan-14 5:26

Harikrishnanvr

7-Jan-14 5:26

what sort of websites ?

Ya Rasoolallah1-Jan-14 11:31

1-Jan-14 11:31

hello
I have a problem.please help me.

my program works without ScriptManagerProxy correctly in the page of product.ascx but with it doesn't work! why?

the source of program is available in below:
example

Marco Bertschi1-Jan-14 12:24

Marco Bertschi

1-Jan-14 12:24

Please remember that we all do our work entirely voluntary, and most of us do not download zip-Files posted in a Forum because of the risk that it may include a virus.
If you post the code you are referring to (in the appropriate <pre> - tags) you are going to receive a broader feedback, and it is more likely that someone can help you with your issue.

Veni, vidi, caecus | Everything summarizes to Assembly code

Ya Rasoolallah1-Jan-14 12:40

1-Jan-14 12:40

OK!

the .aspx page

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>


<%@ Register src="admin/productions.ascx" tagname="Product" tagprefix="uc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        
        
    <uc1:Product ID="Product1" runat="server" />
    </div>
    
    </form>
</body>
</html>

the .ascx page

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="Productions.ascx.cs" Inherits="Admin_Productions" %>
<%@ Import Namespace="System.Data.SqlClient"%>
<%@ Import Namespace="System.Configuration"%>
<!--------------------------------------------------->
<asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server">
</asp:ScriptManagerProxy>



<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<!--------------------------------------------------->
<div align="center">
    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
        DataSourceID="SqlDataSource1" DataTextField="CategoryName" 
        DataValueField="CategoryID">
    </asp:DropDownList><br /><br />
    <!--------------------------------------------------->
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT * FROM [tbl_ProductCategory]"></asp:SqlDataSource>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
        AllowSorting="True" AutoGenerateColumns="False" BackColor="White" 
        BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" 
        DataKeyNames="ProductionID" DataSourceID="SqlDataSource2" >
              <EmptyDataTemplate>
              در این دسته بندی داده ای نیست
              </EmptyDataTemplate>
       
        <RowStyle BackColor="White" ForeColor="#003399" />
        <Columns>
            <asp:CommandField CancelText="انصراف" DeleteText="حذف" EditText="ویرایش" 
                HeaderText="عملیات" ShowDeleteButton="True" ShowEditButton="True" 
                UpdateText="بروز رسانی" />
            <asp:BoundField DataField="ProductionID" HeaderText="ای دی محصول" 
                InsertVisible="False" ReadOnly="True" SortExpression="ProductionID" />
                <asp:TemplateField HeaderText="ای دی دسته بندی محصول" 
                SortExpression="ProductionCategoryID">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" 
                            Text='<%# Bind("ProductionCategoryID") %>' Enabled="false"></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" 
                            Text='<%# Bind("ProductionCategoryID") %>'></asp:Label>
                    </ItemTemplate>
                    
            </asp:TemplateField>
                 
                               
            <asp:BoundField DataField="ProductionName" HeaderText="نام محصول" 
                SortExpression="ProductionName" />
            <asp:BoundField DataField="Cast" HeaderText="قیمت به تومان" 
                SortExpression="Cast" />
            <%--<asp:BoundField DataField="ImageFilm" HeaderText="عکس یا فیلم" 
                SortExpression="ImageFilm" />--%>
                
            <asp:TemplateField HeaderText="عکس یا فیلم" SortExpression="ImageFilm">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ImageFilm") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Image ID="Image1" runat="server" Height="75px" Width="75px" ImageUrl='<%# Bind("ImageFilm") %>'/>
                </ItemTemplate>
            </asp:TemplateField>
                
            <asp:BoundField DataField="Comments" HeaderText="توضیحات" 
                SortExpression="Comments" />
            <asp:BoundField DataField="Stock" HeaderText="موجودی" SortExpression="Stock" />
            
        </Columns>
        <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
        <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
        <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
        <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
    </asp:GridView>
    <br /><!--------------------------------------------------->
    <br />
    <div dir="rtl">
    <%--<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
        DataKeyNames="ProductionID" DataSourceID="SqlDataSource2" Height="50px" 
         Width="702px" oniteminserted="DetailsView1_ItemInserted" 
            oniteminserting="DetailsView1_ItemInserting">
         
        <Fields>
        
            <asp:BoundField DataField="ProductionID" HeaderText="آی دی محصول" 
                InsertVisible="False" ReadOnly="True" SortExpression="ProductionID" 
                Visible="False" />
                
            <asp:BoundField DataField="ProductionCategoryID" 
                HeaderText="آی دی دسته بندی محصول" SortExpression="ProductionCategoryID" />
                           
            <asp:BoundField DataField="ProductionName" HeaderText="نام محصول" 
                SortExpression="ProductionName" />
            <asp:BoundField DataField="Cast" HeaderText="قیمت به تومان" 
                SortExpression="Cast" />
                <asp:TemplateField HeaderText="عکس یا فیلم" SortExpression="ImageFilm">
                <ItemTemplate>
                <asp:FileUpload runat="server" ID="fileUp" />
                </ItemTemplate>
                </asp:TemplateField>
            <asp:BoundField DataField="Stock" HeaderText="موجودی" SortExpression="Stock" />
            <asp:CommandField CancelText="انصراف" InsertText="درج شود" NewText="درج" 
                ShowInsertButton="True" HeaderText="عملیات" />
            
        </Fields>
        
    </asp:DetailsView>
    --%>    <br />
        <table class="style1">
            <tr>
                <td>
                    <asp:Label ID="Label2" runat="server" Text="ای دی دسته بندی محصول"></asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" 
                        DataSourceID="SqlDataSource1" DataTextField="CategoryName" 
                        DataValueField="CategoryID">
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label3" runat="server" Text="نام محصول"></asp:Label>
                </td>
                <td>
                <asp:TextBox ID="txtProName" runat="server"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
                        ControlToValidate="txtProName" Display="Dynamic" 
                        ErrorMessage="نام محصول را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
                 </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label4" runat="server" Text="قیمت"></asp:Label>
                </td>
                <td>
                <asp:TextBox ID="txtCast" runat="server"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" 
                        ControlToValidate="txtCast" Display="Dynamic" 
                        ErrorMessage="قیمت را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label5" runat="server" Text="عکس یا فیلم"></asp:Label>
                </td>
                <td>
                    <asp:FileUpload ID="FileUpload1" runat="server" />
                 </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label6" runat="server" Text="توضیحات"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtComment" runat="server" TextMode="MultiLine"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" 
                        ControlToValidate="txtComment" Display="Dynamic" 
                        ErrorMessage="توضیحات را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
                 </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label7" runat="server" Text="موجودی"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtStock" runat="server"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" 
                        ControlToValidate="txtStock" Display="Dynamic" 
                        ErrorMessage="موجودی را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
                </td>
            </tr>
        </table>
        <br />
        <!---------------------->
       <%-- <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
        </asp:ToolkitScriptManager>
       --%>       
        <%--<asp:HtmlEditorExtender  ID="HtmlEditorExtender1" runat="server" TargetControlID="txtComment">
        </asp:HtmlEditorExtender>--%>
        <!------------------------------------------------------------------------>
        
        
        <asp:Button ID="btnAddProductions" runat="server" Text="اضافه کردن محصولات" 
            onclick="btnAddProductions_Click" />
        <!------------------------------------------------------------------------>
        <asp:Label ID="lblResult" runat="server" ForeColor="Red"></asp:Label>
        <br />
        <asp:ValidationSummary ID="ValidationSummary1" runat="server" />
    </div>
    </div>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConflictDetection="CompareAllValues" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        DeleteCommand="DELETE FROM [tbl_Production] WHERE [ProductionID] = @original_ProductionID AND [ProductionCategoryID] = @original_ProductionCategoryID AND [ProductionName] = @original_ProductionName AND [Cast] = @original_Cast AND [ImageFilm] = @original_ImageFilm AND [Comments] = @original_Comments AND [Stock] = @original_Stock" 
        InsertCommand="INSERT INTO [tbl_Production] ([ProductionCategoryID], [ProductionName], [Cast], [ImageFilm], [Comments], [Stock]) VALUES (@ProductionCategoryID, @ProductionName, <a href="/Members/cast">@Cast</a> @ImageFilm, @Comments, <a href="/Members/stock">@Stock</a>" 
        OldValuesParameterFormatString="original_{0}" 
        SelectCommand="SELECT * FROM [tbl_Production] WHERE ([ProductionCategoryID] = @ProductionCategoryID)" 
        UpdateCommand="UPDATE [tbl_Production] SET [ProductionCategoryID] = @ProductionCategoryID, [ProductionName] = @ProductionName, [Cast] = <a href="/Members/cast">@Cast</a> [ImageFilm] = @ImageFilm, [Comments] = @Comments, [Stock] = <a href="/Members/stock">@Stock</a>WHERE [ProductionID] = @original_ProductionID AND [ProductionCategoryID] = @original_ProductionCategoryID AND [ProductionName] = @original_ProductionName AND [Cast] = @original_Cast AND [ImageFilm] = @original_ImageFilm AND [Comments] = @original_Comments AND [Stock] = @original_Stock">
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList1" Name="ProductionCategoryID" 
                PropertyName="SelectedValue" Type="Int32" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="original_ProductionID" Type="Int32" />
            <asp:Parameter Name="original_ProductionCategoryID" Type="Int32" />
            <asp:Parameter Name="original_ProductionName" Type="String" />
            <asp:Parameter Name="original_Cast" Type="Decimal" />
            <asp:Parameter Name="original_ImageFilm" Type="String" />
            <asp:Parameter Name="original_Comments" Type="String" />
            <asp:Parameter Name="original_Stock" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="ProductionCategoryID" Type="Int32"/>
            <asp:Parameter Name="ProductionName" Type="String" />
            <asp:Parameter Name="Cast" Type="Decimal" />
            <asp:Parameter Name="ImageFilm" Type="String" />
            <asp:Parameter Name="Comments" Type="String" />
            <asp:Parameter Name="Stock" Type="Int32" />
            <asp:Parameter Name="original_ProductionID" Type="Int32" />
            <asp:Parameter Name="original_ProductionCategoryID" Type="Int32" />
            <asp:Parameter Name="original_ProductionName" Type="String" />
            <asp:Parameter Name="original_Cast" Type="Decimal" />
            <asp:Parameter Name="original_ImageFilm" Type="String" />
            <asp:Parameter Name="original_Comments" Type="String" />
            <asp:Parameter Name="original_Stock" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="ProductionCategoryID" Type="Int32" />
            <asp:Parameter Name="ProductionName" Type="String" Size="100"/>
            <asp:Parameter Name="Cast" Type="Decimal" />
            <asp:Parameter Name="ImageFilm" Type="String" Size="100"/>
            <asp:Parameter Name="Comments" Type="String" />
            <asp:Parameter Name="Stock" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    <!--------------------------------------------------->
</ContentTemplate>
</asp:UpdatePanel>
<!--------------------------------------------------->

the .ascx.cs page

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.IO;
public partial class Admin_Productions : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {

        

    }

    protected void btnAddProductions_Click(object sender, EventArgs e)
    {
        //-----------------------------------------------------------
        bool fileOK = false;

        string[] allow = { ".jpg", ".jpeg", ".gif", ".bmp", ".png" };
        string fileExtension = Path.GetExtension(FileUpload1.FileName).ToLower().Trim();
        if (FileUpload1.HasFile)
        {
            for (int i = 0; i < allow.Length; i++)
            {
                if (fileExtension == allow[i] && FileUpload1.FileBytes.Length < 1048576)
                {
                    fileOK = true;
                }
            }
        }
        //-----------------------------------------------------------
        if (fileOK==true)
        {
            //FileUpload1.SaveAs(Server.MapPath(Path.Combine("~/images/",FileUpload1.FileName));
            FileUpload1.PostedFile.SaveAs(Server.MapPath("~/images/"+FileUpload1.FileName));

            SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
            string query = "insert into tbl_production values (@proCatId,@proName,@proCast,@proPic,@proComment,@proStock)";
            SqlCommand cm = new SqlCommand(query, cn);
            cm.Parameters.AddWithValue("proCatId", DropDownList2.SelectedValue);
            cm.Parameters.AddWithValue("proName", txtProName.Text.Trim().ToLower());
            cm.Parameters.AddWithValue("proCast", txtCast.Text.Trim());
            cm.Parameters.AddWithValue("proPic", "~/images/"+FileUpload1.FileName.Trim().ToLower());
            cm.Parameters.AddWithValue("proComment", txtComment.Text);
            cm.Parameters.AddWithValue("proStock", txtStock.Text);
            cn.Open();
            cm.ExecuteNonQuery();
            lblResult.Text = "registered";
            cn.Close();
        }
        else
        {
            lblResult.Text = "incorrect";
        }
        //-----------------------------------------------------------

    }//btnAddProductions_Click
}

Richard MacCutchan1-Jan-14 22:28

Richard MacCutchan

1-Jan-14 22:28

If you are expecting people to help you with this then you need to explain exactly what the problem is and where in all that code it occurs. Just dumping your code and saying "it does not work" is not enough.

Veni, vidi, abiit domum

Ya Rasoolallah1-Jan-14 23:40

1-Jan-14 23:40

OK but i said that what problem is.
I have three page.
The default page and one user control and third ,code behind of the user control that i have put it in previous post.
My program work correctly without the ScriptManagerProxy (without Ajax) but with it doesn't work.(in the .ascx page).

<asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server">
</asp:ScriptManagerProxy>
 
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>

<%--------my code--------%>

</ContentTemplate>
</asp:UpdatePanel>

If i remove the Ajax tag that have put above,my program hasn't any problem BUT if put it ,doesn't work properly.
now do you help me? Rose | [Rose]

modified 2-Jan-14 5:59am.

Richard MacCutchan2-Jan-14 0:09

Richard MacCutchan

2-Jan-14 0:09

Sorry, I'm not an ASP expert. I was merely suggesting that you need to provide full details of your problem if you want people to help you. Don't assume that people can guess what you are doing.

Veni, vidi, abiit domum

Ya Rasoolallah2-Jan-14 1:48