DataSet dataSet = null;
            string sql = string.Format("SELECT * FROM KPP WHERE id = @ID AND date >= @startdate and date <= @enddate");
            SqlConnection conn = new SqlConnection("Data Source = localhost; Initial Catalog = portal; Integrated Security = SSPI");
            conn.Open();
            using (SqlCommand cmd = new SqlCommand(sql, conn))
            {
                SqlParameter param = new SqlParameter();
                param.ParameterName = "@ID";
                param.SqlDbType = SqlDbType.VarChar;
                param.Value = txtID.Text;
                param.Size = 40;
                cmd.Parameters.Add(param);

                param = new SqlParameter();
                param.ParameterName = "@startdate";
                param.Value = Convert.ToDateTime(startdatetimepicker.SelectedDate.Date);
                param.SqlDbType = SqlDbType.DateTime;
                cmd.Parameters.Add(param);

                param = new SqlParameter();
                param.ParameterName = "@enddate";
                param.Value = Convert.ToDateTime(enddatetimepicker.SelectedDate.Date);
                param.SqlDbType = SqlDbType.DateTime;
                cmd.Parameters.Add(param);


            }

                try
                {
[color=red]                    conn.Open();
                    SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
                    dataSet = new DataSet("root");
                    adapter.Fill(dataSet, "KPP");[/color]
                }
                catch (SqlException x)
                {
                    messages.Text += x.Message;
                }
                catch (Exception x)
                {
                    messages.Text += x.Message;
                }


                //Bind Data
                try
                {
[color=red]                    grid.DataSource = dataSet;
                    grid.DataMember = "KPP";
                    grid.DataBind();[/color]
                }
                catch (Exception x)
                {
                    messages.Text += x.Message;
                }
            }

        protected void Search_Click(object sender, EventArgs e)
        {
            DataSet dataSet = null;
            SqlConnection conn = new SqlConnection("Data Source = localhost; Initial Catalog = portal; Integrated Security = SSPI");
            using (SqlCommand cmd = new SqlCommand("Procedure(@ID, @Date, @Road)", conn))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "Procedure";
                cmd.Connection = conn;
                conn.Open();
                SqlParameter param = new SqlParameter();
                param.ParameterName = "@ID";
                param.SqlDbType = SqlDbType.Char;
                param.Value = txtID.Text;
                param.Size = 40;
                param.Direction = ParameterDirection.Input;
                cmd.Parameters.Add(param);

                param = new SqlParameter();
                param.ParameterName = "@startdate";
                param.Value = Convert.ToDateTime(startdatetimepicker.SelectedDate.Date);
                param.SqlDbType = SqlDbType.DateTime;
                param.Direction = ParameterDirection.Input;
                cmd.Parameters.Add(param);

                param = new SqlParameter();
                param.ParameterName = "@enddate";
                param.Value = Convert.ToDateTime(enddatetimepicker.SelectedDate.Date);
                param.SqlDbType = SqlDbType.DateTime;
                param.Direction = ParameterDirection.Input;
                cmd.Parameters.Add(param);

                try
                {
                    SqlDataAdapter adapter = new SqlDataAdapter();
                    adapter.SelectCommand = cmd;
                    dataSet = new DataSet("root");
                    adapter.Fill(dataSet, "KPP");
                }
                catch (SqlException x)
                {
                    messages.Text += x.Message;
                }
                catch (Exception x)
                {
                    messages.Text += x.Message;
                }

                //Bind Data
                try
                {
                    grid.DataSource = dataSet;
                    grid.DataMember = "KPP";
                    grid.DataBind();
                }
                catch (Exception x)
                {
                    messages.Text += x.Message;
                }
                conn.Close();
            }
        }