今天的成果~~！

using System;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

namespace school.SQLData
{
 /// <summary>
 /// 针对测试员数据的操作
 /// </summary>
 public class testerDB
 {

  SqlConnection examConnection;
  SqlCommand examCommand;
  public testerDB()
  {
 
  }

/// <summary>
/// 把测试员的表单写进数据库
/// </summary>
/// <returns></returns>
  public int DataInsert(String name,String dengj,String gongz,String juz,String tongx,String youb,String lianx,String shouj,String email)
  {
   examConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
   examCommand = new SqlCommand("append_tester",examConnection);
   examCommand.CommandType = CommandType.StoredProcedure;

   // 写进参数
   
   SqlParameter parameterCategory1 = new SqlParameter("@name", SqlDbType.Char,10);
   parameterCategory1.Value = name;
   examCommand.Parameters.Add(parameterCategory1);

   SqlParameter parameterCategory2 = new SqlParameter("@dengji", SqlDbType.Char,10);
   parameterCategory2.Value = dengj;
   examCommand.Parameters.Add(parameterCategory2);

   SqlParameter parameterCategory3 = new SqlParameter("@gongzuo_dangwei", SqlDbType.Char,100);
   parameterCategory3.Value = gongz;
   examCommand.Parameters.Add(parameterCategory3);

   SqlParameter parameterCategory4 = new SqlParameter("@juzhudi", SqlDbType.Char,100);
   parameterCategory4.Value = juz;
   examCommand.Parameters.Add(parameterCategory4);

   SqlParameter parameterCategory5 = new SqlParameter("@tongxin_dizhi", SqlDbType.Char,100);
   parameterCategory5.Value = tongx;
   examCommand.Parameters.Add(parameterCategory5);

   SqlParameter parameterCategory6 = new SqlParameter("@youbian", SqlDbType.Char,6);
   parameterCategory6.Value = youb;
   examCommand.Parameters.Add(parameterCategory6);

   SqlParameter parameterCategory7 = new SqlParameter("@lianxi_dianhua", SqlDbType.Char,20);
   parameterCategory7.Value = lianx;
   examCommand.Parameters.Add(parameterCategory7);

   SqlParameter parameterCategory8 = new SqlParameter("@shouji_haoma", SqlDbType.Char,15);
   parameterCategory8.Value = shouj;
   examCommand.Parameters.Add(parameterCategory8);

   SqlParameter parameterCategory9 = new SqlParameter("@email", SqlDbType.Char,30);
   parameterCategory9.Value = email;
   examCommand.Parameters.Add(parameterCategory9);
   
   try
   {
    examConnection.Open();
    examCommand.ExecuteNonQuery();
    examConnection.Close();
   }
   catch
   {
    return(0);
   }           
         return(1);
  }
/// <summary>
///  从测试员数据库里删除数据
/// </summary>
/// <returns></returns>
  public int DataDelete(int id)
  {
   examConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
   examCommand = new SqlCommand("delete_tester",examConnection);
   examCommand.CommandType = CommandType.StoredProcedure;

   SqlParameter parameterCategory0 = new SqlParameter("@id", SqlDbType.Int);
   parameterCategory0.Value = id;
   examCommand.Parameters.Add(parameterCategory0);

   try
   {
    examConnection.Open();
    examCommand.ExecuteNonQuery();
    examConnection.Close();
   }
   catch
   {
    return(0);
   }           
   return(1);
  }
/// <summary>
/// 更新数据库
/// </summary>
/// <returns></returns>
  public int DataUpdata(int id,String name,String dengj,String gongz,String juz,String tongx,String youb,String lianx,String shouj,String email)
  {
   examConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
   examCommand = new SqlCommand("update_tester",examConnection);
   examCommand.CommandType = CommandType.StoredProcedure;

   // 写进参数
   SqlParameter parameterCategory0 = new SqlParameter("@id", SqlDbType.Int);
   parameterCategory0.Value = id;
   examCommand.Parameters.Add(parameterCategory0);

   SqlParameter parameterCategory1 = new SqlParameter("@name", SqlDbType.Char,10);
   parameterCategory1.Value = name;
   examCommand.Parameters.Add(parameterCategory1);

   SqlParameter parameterCategory2 = new SqlParameter("@dengji", SqlDbType.Char,10);
   parameterCategory2.Value = dengj;
   examCommand.Parameters.Add(parameterCategory2);

   SqlParameter parameterCategory3 = new SqlParameter("@gongzuo_dangwei", SqlDbType.Char,100);
   parameterCategory3.Value = gongz;
   examCommand.Parameters.Add(parameterCategory3);

   SqlParameter parameterCategory4 = new SqlParameter("@juzhudi", SqlDbType.Char,100);
   parameterCategory4.Value = juz;
   examCommand.Parameters.Add(parameterCategory4);

   SqlParameter parameterCategory5 = new SqlParameter("@tongxin_dizhi", SqlDbType.Char,100);
   parameterCategory5.Value = tongx;
   examCommand.Parameters.Add(parameterCategory5);

   SqlParameter parameterCategory6 = new SqlParameter("@youbian", SqlDbType.Char,6);
   parameterCategory6.Value = youb;
   examCommand.Parameters.Add(parameterCategory6);

   SqlParameter parameterCategory7 = new SqlParameter("@lianxi_dianhua", SqlDbType.Char,20);
   parameterCategory7.Value = lianx;
   examCommand.Parameters.Add(parameterCategory7);

   SqlParameter parameterCategory8 = new SqlParameter("@shouji_haoma", SqlDbType.Char,15);
   parameterCategory8.Value = shouj;
   examCommand.Parameters.Add(parameterCategory8);

   SqlParameter parameterCategory9 = new SqlParameter("@email", SqlDbType.Char,30);
   parameterCategory9.Value = email;
   examCommand.Parameters.Add(parameterCategory9);
   
   try
   {
    examConnection.Open();
    examCommand.ExecuteNonQuery();
    examConnection.Close();
   }
   catch
   {
    return(0);
   }           
   return(1);
  }
/// <summary>
/// 读取数据库里
/// </summary>
/// <returns></returns>
  public SqlDataReader DataRead()
  {
   SqlDataReader examDataReader;
   examConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
   examCommand = new SqlCommand("select_tester",examConnection);
   examCommand.CommandType = CommandType.StoredProcedure;
   examConnection.Open();
   examDataReader = examCommand.ExecuteReader(CommandBehavior.CloseConnection);
               
   return examDataReader;
  }

 }
}