using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
 
namespace WindowsFormsApplication3
{
    public partial class Form1 : Form
    {
        public String date;
        public Form1()
        {
            InitializeComponent();
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {    
 
        }
  
        private void monthCalendar1_DateChanged(object sender, DateRangeEventArgs e)
        {
             date = monthCalendar1.SelectionStart.ToShortDateString();
        }
 
        private void statusStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
 
        }

namespace WindowsFormsApplication3
{
    public partial class Form1 : Form
    {
        String connect = @"Data Source=AKRAVCHENKONB\saoreport;Initial Catalog=SAO1CDATA;Integrated Security=True";
        DateTime date;
        public Form1()
        {
            InitializeComponent();
        }


        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void monthCalendar1_DateChanged(object sender, DateRangeEventArgs e)
        {
            date = Convert.ToDateTime(monthCalendar1.SelectionStart.ToString());
           
            SqlConnection sqlCon = new SqlConnection(connect);
            sqlCon.Open();
            SqlCommand sqlCom = new SqlCommand("Проверка_Должников", sqlCon);
            SqlParameter par = sqlCom.Parameters.AddWithValue("@date", date);
            par.Value = date;
            sqlCom.ExecuteNonQuery();
            SqlDataAdapter sqlDA;
            sqlDA = new SqlDataAdapter(sqlCom);
            sqlCom.CommandType = CommandType.StoredProcedure;
          
            sqlCon.Close();

        }

        private void statusStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {

        }

    }
  }
   

 private void monthCalendar1_DateChanged(object sender, DateRangeEventArgs e)
        {
            date = Convert.ToDateTime(monthCalendar1.SelectionStart.ToString());

            using (SqlConnection connection = new SqlConnection(@"Data S"))
            {
                connection.Open();
                using (SqlCommand command = new SqlCommand("Проверка_Должников", connection))
                {
                    command.CommandType = System.Data.CommandType.StoredProcedure;
                    SqlParameter parameter = command.Parameters.AddWithValue("@date", System.Data.SqlDbType.DateTime); 
                    parameter.Value = date; 
                    command.ExecuteNonQuery();
                }
            }