Question

asp.net前台页面上放2个textbox和一个button 点击button

textbox信息保存到数据库里面
如何写 高手帮下忙
写的详细一点 最好把代码写出来 我新手 理论上都理解就是不
会写

Answer 1

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
}
//先要引用using System.Data; using System.Data.SqlClient;（不然SqlConnection和SqlCommand无效）
/*
* 配置文件 Web.config
<configuration>
<connectionStrings>
<add name="sqlConn" connectionString="server=.;database=BaiDuDB;pwd=svse;uid=sa;"/>
</connectionStrings>
* </configuration>
*/
private SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConn"].ToString());
private SqlCommand cmd = null;
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txtName.Text.Trim();
string desc = this.txtDesc.Text.Trim();
string XS = this.txtXS.Text.Trim();
string strsql = string.Format("insert into ShuJu values('{0}','{1}')", name, desc);
EditSql(strsql);
}
//单向 增 删 改
public bool EditSql(string strsql)
{
cmd = new SqlCommand(strsql, conn);
try
{
conn.Open();
return cmd.ExecuteNonQuery() == 1;
}
catch
{
return false;
}
finally
{
conn.Close();
}
}
}

Answer 2

在button的点击事件里面写
然后获取textbox的信息
写入拼接SQL语句
连接数据库执行SQL语句
OK了

Answer 3

把插入sql的语句写到 button事件里边

Answer 4

string sql="insert into table('"textbox.text"')";
在button事件里面写就可以了