[align=left]DataSet dataSet = new DataSet();
con.Open();
SqlCommand com = new SqlCommand("pages", con);
com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@view", SqlDbType.Int, 10);
com.Parameters.Add("@page", SqlDbType.Int, 3); SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.SelectCommand = com;
dataadapter.Fill(dataSet);[/align]
con.Open();
SqlCommand com = new SqlCommand("pages", con);
com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@view", SqlDbType.Int, 10);
com.Parameters.Add("@page", SqlDbType.Int, 3); SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.SelectCommand = com;
dataadapter.Fill(dataSet);[/align]
com.Parameters["@view"].Value = txtViewe.Text;//txtViewe.Text就是你传入的值