public static SqlConnection creatString()//创建连接字符串
    {
        string mystring = "Data Source=5FAF81B03F644F7\\FGFDS;Initial Catalog=wujilin;User ID=sa;Password=222222";

        SqlConnection myconnection = new SqlConnection(mystring);

        return myconnection;
   }

    public static DataSet givemessage()//无参数　返回一个集合
    {
        DataSet ds = new DataSet();
        SqlConnection myconnecting =DB.creatString();
        SqlDataAdapter sdr = new SqlDataAdapter("givemessage", myconnecting);
        sdr.SelectCommand.CommandType = CommandType.StoredProcedure;
        sdr.Fill(ds);

        return ds;
    }
    public static DataSet givemessage1(string a)//带输入参数 返回序列集合
    {
        SqlParameter workParam1 = new SqlParameter("@password", SqlDbType.NChar);
        workParam1.Direction = ParameterDirection.Input;
        workParam1.Value = a;

        SqlDataAdapter sdr = new SqlDataAdapter();
        sdr.SelectCommand = new SqlCommand();

        sdr.SelectCommand.Connection = DB.creatString();
        sdr.SelectCommand.CommandText = "messagexyz";
        sdr.SelectCommand.CommandType = CommandType.StoredProcedure;
        sdr.SelectCommand.Parameters.Add(workParam1);

        DataSet ds = new DataSet();
        sdr.Fill(ds);
        return ds;
    }

    public static string singerValue(string m)//返回一个值
    {
        SqlConnection conn = DB.creatString();
        SqlCommand mycommand = new SqlCommand("number", conn);
        mycommand.CommandType = CommandType.StoredProcedure;

        SqlParameter workParam;          //输入参数
        workParam = new SqlParameter("@password", SqlDbType.NChar);
        workParam.Direction = ParameterDirection.Input;
        workParam.Value = m;
        mycommand.Parameters.Add(workParam);

        workParam = new SqlParameter("@ItemCount", SqlDbType.Int);//输出参数
        workParam.Direction = ParameterDirection.Output;
        mycommand.Parameters.Add(workParam);

        conn.Open();
        mycommand.ExecuteNonQuery();
        conn.Close();

        return mycommand.Parameters["@ItemCount"].Value.ToString();
    }
}
 

dataset 与XML

 protected void Button3_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        SqlConnection conn = DB.creatString();
        SqlDataAdapter sdr = new SqlDataAdapter("select * from test", conn);
        sdr.Fill(ds);
        ds.WriteXml(Server.MapPath("test.xml")); //将数据写入xml文件
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("test.xml"));//从xml文件中读取数据
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
    }