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();
                }
            }

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 WindowsFormsApplication7
{
    public partial class Form1 : Form
    {
        DateTime date1;
        public Form1()
        {
            InitializeComponent();
        }

        private void monthCalendar1_DateChanged(object sender, DateRangeEventArgs e)
        {
            date1 = Convert.ToDateTime(monthCalendar1.SelectionStart.ToString());
            label1.Text = Convert.ToString(date1);
            string constring = @"Data Source=";
            SqlConnection sqlconn = new SqlConnection(constring);
            SqlCommand sqlcomm = new SqlCommand("Проверка_Должников", sqlconn);
            sqlcomm.CommandType = System.Data.CommandType.StoredProcedure;
            sqlcomm.Parameters.Add("@date", System.Data.SqlDbType.DateTime).Value = date1;
            try
            {
                SqlDataAdapter sqladap = new SqlDataAdapter(sqlcomm);
                DataTable dtable = new DataTable();
                sqladap.Fill(dtable);
                BindingSource bso = new BindingSource();
                bso.DataSource = dtable;
                dataGridView1.DataSource = bso;
                sqladap.Update(dtable);
            }
            catch (Exception ex) { }
        }

        private void label1_Click(object sender, EventArgs e)
        {
           
        }
        
    }
}