ado.net连接SQL数据库

【核心代码】

using System;
using System.Collections;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        updateData();
    }

    private void updateData()
    {
        string Con = ConfigurationManager.ConnectionStrings["itNews"].ConnectionString;
        SqlConnection Myconn = new SqlConnection(Con);
        Myconn.Open();

        string SQLStr = "update tUser set myPass='1111'";
        SqlCommand cmd = new SqlCommand(SQLStr, Myconn);
        cmd.ExecuteNonQuery();

    }

    public void UpdateDataWithProcNoParameter(string ProcName)
    {
        string Con = ConfigurationManager.ConnectionStrings["itNews"].ConnectionString;
        SqlConnection Myconn = new SqlConnection(Con);
        Myconn.Open();

        SqlCommand cmd = new SqlCommand(ProcName, Myconn);
        cmd.CommandType = CommandType.StoredProcedure;//表明Cmd对象要执行的命令是存储过程（存储过程名）
        cmd.ExecuteNonQuery();
        Myconn.Close();
    }

    public void UpdateDataWithProc(string SQLStr, ref SqlParameter[] myParam)
    {
        string Con = ConfigurationManager.ConnectionStrings["itNews"].ConnectionString;
        SqlConnection Myconn = new SqlConnection(Con);
        Myconn.Open();

        SqlCommand cmd = new SqlCommand(SQLStr, Myconn);
        cmd.CommandType = CommandType.StoredProcedure;//表明Cmd对象要执行的命令是存储过程（存储过程名）

        int i;
        if ((myParam == null) == false)
        {
        for (i = 0; i <= myParam.Length - 1; i  )
            {
                cmd.Parameters.Add(myParam[i]);
            }
        }
        cmd.ExecuteNonQuery();
        Myconn.Close();
    }


    private void ReadData()
    {
        string Con = ConfigurationManager.ConnectionStrings["itNews"].ConnectionString;
        SqlConnection Myconn = new SqlConnection(Con);
        Myconn.Open();

        string SQLStr = "select * from tUser";
        SqlCommand cmd = new SqlCommand(SQLStr, Myconn);

        DataTable tb = new DataTable();

        SqlDataReader myReader = cmd.ExecuteReader();

        tb = ReaderToTable(myReader);

        GridView1.DataSource = tb;
        GridView1.DataBind();

    }

    private DataTable ReaderToTable(SqlDataReader reader)
    {
        DataTable newTable = new DataTable();//实例化一个空白的DataTable->newTable
        DataColumn col = null;//设置一个空的DataColumn->col
        DataRow row = null;//设置一个空的DataRow->row

        //以下代码生成DataTable的数据列的定义
        int i = 0;
        for (i = 0; i <= reader.FieldCount - 1; i  )//reader.FieldCount：读取到的数据表有多少列，索引从0开始
        {
            col = new DataColumn();//设置col为新的DataColumn对象
            col.ColumnName = reader.GetName(i);//设置col的列名
            col.DataType = reader.GetFieldType(i);//设置col的数据类型
            newTable.Columns.Add(col);//将当前列添加到DataTable->newTable中
        }

        //以下代码从reader中读取数据到DataTable->newTable中
        while (reader.Read())//Read()方法获得一整条记录（将指针指向当前行），如果没有获得记录则返回false，获得则返回Object类型数据
        {
            row = newTable.NewRow();
            for (i = 0; i <= reader.FieldCount - 1; i  )
            {
                row[i] = reader[i];
            }
            newTable.Rows.Add(row);
        }
        return newTable;
    }


    protected void Button1_Click(object sender, EventArgs e)
    {
        ReadData();
    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        //SqlParameter[] myP = { };
        //UpdateDataWithProc("updatePassword", ref myP);
        UpdateDataWithProcNoParameter("updatePassword");
        Button2.Text = "已通过存储过程更新密码";
 
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        SqlParameter[] myP = { new SqlParameter("@myID", SqlDbType.BigInt), new SqlParameter("@myPass", SqlDbType.VarChar) };
        myP[0].Value = 2;
        myP[1].Value = "HengHengHaHei";
        UpdateDataWithProc("userUpdate", ref myP);
        Button3.Text = "已通过存储过程更新密码";
    }
}