C#调用存储过程

create proc proc_test

@starttime datetime,

@endtime datetime

as

select * from OverTime where Date between @starttime and @endtime

go

 SqlConnection con = new SqlConnection("Data Source=FCSDL-DT-002\\SQLEXPRESS;Initial Catalog=Attence;Integrated Security=True");



            con.Open();



            DataSet ds = new DataSet();

            SqlCommand cmd = new SqlCommand("proc_test", con);



            cmd.CommandType = CommandType.StoredProcedure;

   



            //cmd.Parameters.Add("@Name", SqlDbType.NVarChar);

            //cmd.Parameters["@Name"].Value = "灰太郎";



            SqlParameter[] param = new SqlParameter[]

  {

  new SqlParameter("@starttime",SqlDbType.DateTime),

  new SqlParameter("@endtime",SqlDbType.DateTime)

  };



            param[0].Direction = ParameterDirection.Input;

            param[0].Value = Convert.ToDateTime("2011.5.12");

            param[1].Direction = ParameterDirection.Input;

            param[1].Value = Convert.ToDateTime("2011.6.28"); ;



            //cmd.Parameters.Add(param);



            cmd.Parameters.AddRange(param);



            SqlDataAdapter da = new SqlDataAdapter(cmd);



            da.SelectCommand.CommandTimeout = 720;



            ds.Clear();



            da.Fill(ds);



            DataTable dt = new DataTable();

            dt = ds.Tables[0];



            con.Close();





            dataGridView1.DataSource = dt;

this.GridView1.DataSource=ds.Tables[0].DefaultView;