在datalist中保存项目 [英] Save item in datalist

问题描述

我有一个包含数据列表的aspx代码，在其中我有一个名为txtComment的文本框。如何保存在文本框中输入的值。请帮我解决这个问题。





我需要将其保存在数据库中。 />

I have an aspx code contains data list and inside it I have a textbox named "txtComment". How will I save value entered in textbox. Please help me to solve this.


I need to save it in database .

<asp:DataList ID="dtaLst" runat="server"

        ondatabinding="DataList1_DataBinding">

           <asp:GridView runat="server" ID="grdPrevComment" AutoGenerateColumns="false" BorderStyle="Solid"

                                            BorderColor="Red" OnRowDataBound="grdPrevComment_DataBound" Width="100%">


                                                <asp:TemplateField HeaderText="Comment">

                                                        <asp:Label runat="server" ID="lblCostElement" Text='<%# Eval("COC") %>' />

                                                    <HeaderStyle HorizontalAlign="Left" />



                                                 <asp:TemplateField HeaderText="Commented by">

                                                        <asp:Label runat="server" ID="lblCostElement" Text='<%# Eval("Name") %>' />

                                                    <HeaderStyle HorizontalAlign="Left" />

           <br />
          <div class="tablecoloumn_20L">
                        <asp:Label ID="lblComment" runat="server" Text="Comment" ViewStateMode="Disabled" CssClass="lable"/>
                    </div>
                    <div class="tablecoloumn_80R">
                        <asp:TextBox ID="txtComment" runat="server" TextMode="MultiLine"

                            CssClass="textarea_m" Width="503px" Height="81px"

                        onkeypress="return ImposeMaxLength(event,this,5000);"  MaxLength="5000"

                        onkeyup ="return LimitLength(this,5000);"

                            ondblclick="this.focus();this.select()" onfocus="SelectAll(this.id);"

                            TabIndex="3" />
                    </div>
          <%-- <asp:LinkButton ID="lnkSubmit" runat="server" onclick="lnkSubmit_Click">Submit--%>
          <asp:LinkButton ID="lnkBtnSubmit" ValidationGroup="requied" onkeyup="Button_SpaceBar(event,this)" CssClass="saveButton" Text="Submit"

                             runat="server" TabIndex="4" OnClick="lnkBtnSubmit_Click" >

这个是我的aspx代码。

This is my aspx code.

推荐答案

嗨...

看到这个用name和imgurl保存数据库中的图像。

在.aspx

Hi...
See this to save images in database with name and imgurl.
In .aspx

<<asp:fileupload id="imgful" runat="server" height="25px" style="font-weight: 700" xmlns:asp="#unknown" />
<asp:button id=""btnimg"" runat=""server"" text=""SaveProduct"" onclick=""btnimg_Click"<br" mode="hold" xmlns:asp="#unknown" />            ForeColor="DeepPink" style="font-weight: 700" Width="99px" Height="28px"/>

在aspx.cs中：

In aspx.cs:

//Get Filename from fileupload control
                string filename = Path.GetFileName(imgful.PostedFile.FileName);
                //Save images into Images folder
                imgful.SaveAs(Server.MapPath("~/Images/" + filename));
cmd = new MySqlCommand("Insert into Items(ProductName,ImageUrl,Cost,DateTime) values(@ImageName,@ImagePath,'" + txtcost.Text + "','" + dt + "')", con);

                        //Passing parameters to query
                        cmd.Parameters.AddWithValue("@ImageName", filename);
                        cmd.Parameters.AddWithValue("@ImagePath", "~/Images/" + filename);
                        con.Open();
                        cmd.ExecuteNonQuery();
                        //Close dbconnection
                        con.Close();

看到这是用于在datalist中显示图像。

在aspx中：

See this is for display images in datalist.
In aspx:

<asp:DataList ID="DataList1" runat="server" Height="82px"

        ItemStyle-HorizontalAlign="Center" RepeatColumns="3" Width="180px" EnableViewState="true">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
        <ItemTemplate>
        <asp:Image ID="img1" ImageUrl='<%# Bind("Name", "~/Images/{0}") %>' Width="250" Height="180" runat="server" />
        <asp:HyperLink ID="HyperLink1" Text='<%# Bind("Name") %>' NavigateUrl='<%# Bind("Name", "~/Images/{0}") %>' runat="server"/>
            </ItemTemplate>
    </asp:DataList>

在aspx.cs中：

In aspx.cs:

DirectoryInfo dir = new DirectoryInfo(MapPath("Images"));
            FileInfo[] files = dir.GetFiles();
            ArrayList listitems = new ArrayList();
            foreach (FileInfo info in files)
            {
               listitems.Add(info);
            }
            // bind images on conditional
            adsource = new PagedDataSource();
            adsource.DataSource = listitems;
            // display no of images
            adsource.PageSize = 5;
            adsource.AllowPaging = true;
            
            DataList1.DataSource = adsource;
            DataList1.DataBind();

Thnak u。

Thnak u.

这篇关于在datalist中保存项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！