asp.net中的网站设计 [英] web site designing in asp.net

问题描述

Helloo ..



我想将表格中的数据插入数据库。我正在使用< asp：Formparameter>插入。但我知道formparameter不支持验证。那我现在该怎么办。请帮帮我......



这里是代码....

Helloo..

I want to insert data from a form to a database.I am using <asp:Formparameter> to insert. but i came to know that formparameter does not support validation.so what can i do now.Please help me out...

here is the code....

protected void btn_click(object sender, EventArgs e)
   {
       if (Page.IsValid)
       {

           srcusers.Insert();
           confirmmsg.Text = "Data Inserted";
       }
       else
       {
           confirmmsg.Text = "Fill carefully";
       }

   }

HTML：

HTML:

<asp:DetailsView ID="DetailsView1" DataSourceID="srcusers"

               EmptyDataText="No Records present" AllowPaging="true"

              runat="server" Height="50px" Width="125px">
              </asp:DetailsView>

            <asp:SqlDataSource ID="srcusers"

             ConnectionString="<%$ ConnectionStrings:userdatabase %>"

             SelectCommand="SELECT * FROM Curr_Projects"

             InsertCommand="INSERT into Curr_Projects (Portcode,Portname,Proj_Id,Proj_Name,Description,Dateofissue,TargetToachieve,Estimatedcost)
                     VALUES (@Portcode,@Portname,@Proj_Id,@Proj_Name,@Description,@Dateofissue,@TargetToachieve,@Estimatedcost)"

                     runat="server">
                     <InsertParameters>
                        <asp:FormParameter Name="portcode" FormField="tpc" />
                        <asp:FormParameter Name="portname" FormField="tpn" />
                        <asp:FormParameter Name="Proj_id" FormField="tprojno"/>
                        <asp:FormParameter Name="Proj_Name" FormField="tprname" />
                        <asp:FormParameter Name="Description" FormField="tprdesc" />
                        <asp:FormParameter Name="dateofissue" FormField="tdateiss" Type="DateTime" />
                        <asp:FormParameter Name="TargetToachieve" FormField="ttg" />
                        <asp:FormParameter Name="Estimatedcost" FormField="test" />
                     </InsertParameters>
            </asp:SqlDataSource>

推荐答案

ConnectionStrings：userdatabase ％>

< span class =code-attribute> SelectCommand = SELECT * FROM Curr_Projects

InsertCommand = INSERT到Curr_Projects（Portcode，Portname，Proj_Id，Proj_Name，Descr iption，Dateofissue，TargetToachieve，Estimatedcost）
VALUES（@ Portcode，@ Portname，@ Proj_Id，@ Proj_Name，@ Description，@ Dateofissue，@ TargetToachieve，@ Estimatedcost）

< span class =code-attribute> runat = server >
< InsertParameters >
< ; asp：FormParameter 名称 = portcode FormField = tpc / >
< asp：FormParameter 名称 = portname FormField = tpn / >
< asp：FormParameter 名称 = Proj_id FormField = tprojno / >
< asp：FormParameter 名称 = Proj_Name FormField = tprname / >
< asp：FormParameter 名称 = 描述 FormField = tprdesc / >
< asp：FormParameter 名称 = dateofissue FormField = tdateiss 类型 = DateTime / >
< asp：FormParameter 名称 = TargetToachieve FormField = ttg / >
< asp：FormParameter 名称 = Estimatedcost FormField = test / >
< / Inse rtParameters >
< / asp：SqlDataSource >

ConnectionStrings:userdatabase %>" SelectCommand="SELECT * FROM Curr_Projects" InsertCommand="INSERT into Curr_Projects (Portcode,Portname,Proj_Id,Proj_Name,Description,Dateofissue,TargetToachieve,Estimatedcost) VALUES (@Portcode,@Portname,@Proj_Id,@Proj_Name,@Description,@Dateofissue,@TargetToachieve,@Estimatedcost)" runat="server"> <InsertParameters> <asp:FormParameter Name="portcode" FormField="tpc" /> <asp:FormParameter Name="portname" FormField="tpn" /> <asp:FormParameter Name="Proj_id" FormField="tprojno"/> <asp:FormParameter Name="Proj_Name" FormField="tprname" /> <asp:FormParameter Name="Description" FormField="tprdesc" /> <asp:FormParameter Name="dateofissue" FormField="tdateiss" Type="DateTime" /> <asp:FormParameter Name="TargetToachieve" FormField="ttg" /> <asp:FormParameter Name="Estimatedcost" FormField="test" /> </InsertParameters> </asp:SqlDataSource>

这篇关于asp.net中的网站设计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！