UC知道高手救命!C#代码看得懂的进
来源：百度知道 编辑：UC知道 时间：2024/06/06 20:30:57
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridViewBind();
}
}
public void GridViewBind()
{
SqlConnection cn = new SqlConnection("Server=localhost;Integrated Security=SSPI;DataBase=fangdawei");
SqlCommand cmd = new SqlCommand("select * from tb_Member", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new Data
1.这个不用这么写，如下：
public void GridViewBind()
{
SqlConnection cn = new SqlConnection("Server=localhost;Integrated Security=SSPI;DataBase=fangdawei");
String sql="select * from tb_Member";
SqlDataAdapter da = new SqlDataAdapter(sql,cn);
DataSet ds = new DataSet();
da.Fill(ds, "tb_Member");
this.GridView1.DataSource = ds.Tables[0].DefaultView;
this.GridView1.DataBind();
}
2.button的click:
protected void Button1_Click(object sender, EventArgs e)
{
String sql="insert into tb_Member(用户ID,姓名，性别，籍贯) values(@用户ID,@姓名，@性别，@籍贯)";
SqlConnection cn=new SqlConnection(ConnectionString);
SqlCommand cmd=new SqlCommand(sql,cn);
cmd.Parameters.Add("@用户ID",TextBox1.Text );
cmd.Parameters.Add("@姓名",TextBox2.Text );
cmd.Parameters.Add("@性别",TextBox3.Text )