ASP.net使用表单将数据插入到一个SQL Server表 [英] ASP.net using a form to insert data into an sql server table

问题描述

喜
在PHP我会做一个表格来让说process.php页面，并在页面我想借此岗位价值和使用的mysql_query会做插入的动作。
现在我失去了，我想创建一个由和使用Visual Studio 2010做一个inserstion在ASP.net与SQL Server 2008。

Hi in php i would do a form with an action to lets say a process.php page and in that page i would take the post values and using a mysql_query would do an insertion. now i am lost ,i am trying to create a from and do an inserstion in ASP.net with sql server 2008 using visual studio 2010.

我已经定义在App_Data文件夹中的SQL数据库。
basicly我需要什么（除非有一个更好的方法）是：

i have defined a sql db in the App_Data folder. basicly what i need (unless there is a better way) is:

1. 如何得到这个职位的值。


2. 如何将它们插入到数据库中。

感谢。

推荐答案

有吨样品code网上至于如何做到这一点。

There are tons of sample code online as to how to do this.

下面是如何做到这一点只是一个例子：
<一href=\"http://geekswithblogs.net/dotNETvinz/archive/2009/04/30/creating-a-simple-registration-form-in-asp.net.aspx\" rel=\"nofollow\">http://geekswithblogs.net/dotNETvinz/archive/2009/04/30/creating-a-simple-registration-form-in-asp.net.aspx

Here is just one example of how to do this: http://geekswithblogs.net/dotNETvinz/archive/2009/04/30/creating-a-simple-registration-form-in-asp.net.aspx

定义了以下标签之间的文本框：

you define the text boxes between the following tag:

<form id="form1" runat="server"> 

您创建文本框，并定义它们=服务器，像这样：

you create your textboxes and define them to runat="server" like so:

<asp:TextBox ID="TxtName" runat="server"></asp:TextBox>

定义一个按钮来处理你的逻辑，像这样（注意的onclick ）

<asp:Button ID="Button1" runat="server" Text="Save" onclick="Button1_Click" />

在code的后面，可以定义你想要的服务器做的，如果用户定义了一个名为方法点击按钮

in the code behind, you define what you want the server to do if the user clicks on the button by defining a method named

protected void Button1_Click(object sender, EventArgs e)

或者你可以只需双击在设计视图中的按钮。

or you could just double click the button in the design view.

下面是code的一个非常快速的样品插入在按钮单击事件表（codebehind）

Here is a very quick sample of code to insert into a table in the button click event (codebehind)

protected void Button1_Click(object sender, EventArgs e)
{
   string name = TxtName.Text; // Scrub user data

   string connString = ConfigurationManager.ConnectionStrings["yourconnstringInWebConfig"].ConnectionString;
   SqlConnection conn = null;
   try
   {
          conn = new SqlConnection(connString);
          conn.Open();

          using(SqlCommand cmd = new SqlCommand())
          {
                 cmd.Conn = conn;
                 cmd.CommandType = CommandType.Text;
                 cmd.CommandText = "INSERT INTO dummyTable(name) Values (@var)";
                 cmd.Parameters.AddWithValue("@var", name);
                 int rowsAffected = cmd.ExecuteNonQuery();
                 if(rowsAffected ==1)
                 {
                        //Success notification
                 }
                 else
                 {
                        //Error notification
                 }
          }
   }
   catch(Exception ex)
   {
          //log error 
          //display friendly error to user
   }
   finally
   {
          if(conn!=null)
          {
                 //cleanup connection i.e close 
          }
   }
}

这篇关于ASP.net使用表单将数据插入到一个SQL Server表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！