SQLHelper类:using System.Data.SqlClient;
using System.Configuration;
using System;
using System.Text;
namespace 尝试封装
{
class SQLHelper
{
public static int ExecuteNonQuery(string sql, params SqlParameter[] paramters)
{
String connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in paramters)
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteNonQuery();
}
} }
}
}FORM1后台代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace 尝试封装
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
String name = this.textBox1.Text;
String age = this.textBox2.Text;
SQLHelper.ExecuteNonQuery("Insert into T_Persons(Name,Age) values(@Name,@Age) WHERE Name=name,Age=age"); //这里如何让他获得用户输入的数据,就是textBox1和2的数据,并把它更新到数据库?
}
}
}
using System.Configuration;
using System;
using System.Text;
namespace 尝试封装
{
class SQLHelper
{
public static int ExecuteNonQuery(string sql, params SqlParameter[] paramters)
{
String connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in paramters)
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteNonQuery();
}
} }
}
}FORM1后台代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace 尝试封装
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
String name = this.textBox1.Text;
String age = this.textBox2.Text;
SQLHelper.ExecuteNonQuery("Insert into T_Persons(Name,Age) values(@Name,@Age) WHERE Name=name,Age=age"); //这里如何让他获得用户输入的数据,就是textBox1和2的数据,并把它更新到数据库?
}
}
}
解决方案 »
- 如何刷新页面后,自动拉到条到某个锚点
- jquery到这里来问问。再次加载时不读取url
- 如何在IE中设置不显示网页上的Flash(不使用IE拦截插件)?
- 如何用代码设置datagrid中一列中的Text值?
- 关于ORM。。送分了。
- 请问高手!怎么样通过TextBox里面的内容查找SQL表,来取得表里面的行号?
- 请问大家,那有像www.51job.com那样的首页,比51更好的,更漂亮的界面??
- 关于一个想法,因为没有做过,希望大家能给些例子帮忙,或者指导啦
- 问个狂简单的问题!
- ASP代码的自动生成系统
- vs2005/2008引用更新不及时问题
- session怎么去保存页面,并保证页面的样式不会发生变化
string strUpdate = "Update Authors set phone=@phone Where au_fname=@firstname and au_lname=@lastname";
SqlCommand cmdUpdate = new SqlCommand(strUpdate,conPubs);
cmdUpdate.Parameters.Add( "@phone", txtPhone.Text );
cmdUpdate.Parameters.Add( "@firstname", txtFirstName.Text );
cmdUpdate.Parameters.Add( "@lastname", txtLastName.Text );
conPubs.Open();
intUpdateCount = cmdUpdate.ExecuteNonQuery();
conPubs.Close();
lblResults.Text = intUpdateCount + " records updated!";SqlConnection conPubs = new SqlConnection(@"Server=localhost;UID=sa;PWD=secret;Database=Pubs");
SqlCommand cmdInsert = new SqlCommand("InsertProducts",conPubs);
cmdInsert.CommandType=CommandType.StoredProcedure;
cmdInsert.Parameters.Add( "@ProductName", "Milk" );
cmdInsert.Parameters.Add( "@UnitPrice", 12.45 );
conPubs.Open();
cmdInsert.ExecuteNonQuery();
conPubs.Close();
Response.Write("New Product Added!")
SqlParameter sp_name= new SqlParameter("@Name", SqlDbType.VarChar,20);
sp_name.Value=name@Name和SQL语句里参数对应,主要是SqlParameter这个类使用。