Serverfault

http://serverfault.com

Date Select On Show DataGridView

  string constring = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=bar_db;Integrated Security=True";
            SqlConnection con = new SqlConnection(constring);
            DateTime dt = new DateTime();
            dt = Convert.ToDateTime(dateTimePicker1.Value.ToShortDateString());
            SqlCommand cmd = new SqlCommand();
            string sqlqry = "select mbrchrg AS MemberCharge,costumechrg AS CostumerCharge,Date from swimpool where Date = '" + dt + "'";
            dataGridView1.DataSource = "";
            cmd.CommandText = sqlqry;
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.SelectCommand = cmd;
            DataSet ds = new DataSet();
            da.Fill(ds, "swimpool");
            dataGridView1.DataSource = ds.Tables["swimpool"].DefaultView;




-------------------------------------------------------------------------
namespace HotelManagement
{
    public partial class User_Record : Form
    {
        Dbclass db = new Dbclass();
        string common;
        public User_Record()
        {
            InitializeComponent();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void User_Record_Load(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();

            string str = "select Addmminisator,User_Id,User_Type,User_Name,User_Password from user_master";
            dt = db.FindFun(str);
            grduser_record.DataSource  = dt;
            totalrecord.Text = Convert.ToInt32(grduser_record.Rows.Count - 1).ToString();

        }

        private void btnpreview_Click(object sender, EventArgs e)
        {
            Crstluser_master use = new Crstluser_master();
            Frmviewr view = new Frmviewr();
            DataTable dt = new DataTable();
            string str = " Select * from user_Master";
            dt = db.FindFun(str);

            use.SetDataSource(dt);
            view.crstlviewer.ReportSource = use;
            view.Show();
        }
    }
}

Freelancer

www.freelancer.com
www.getacoder.com

Datagridview Data Print

/ dataGridView1 is the DataGridView to print 
GridPrintDocument doc = new GridPrintDocument(this.dataGridView1, 
                        this.dataGridView1.Font, true); 

doc.DocumentName = "Preview Test"; 
doc.DefaultPageSettings.Landscape = true; 
doc.DefaultPageSettings.PrinterSettings.FromPage = 1; 
doc.DefaultPageSettings.PrinterSettings.ToPage = 3;

PrintPreviewDialog printPreviewDialog = new PrintPreviewDialog(); 
printPreviewDialog.ClientSize = new Size(400, 300); 
printPreviewDialog.Location = new Point(29, 29); 
printPreviewDialog.Name = "Print Preview Dialog"; 
printPreviewDialog.UseAntiAlias = true; 
printPreviewDialog.Document = doc; 
printPreviewDialog.ShowDialog(); 
doc.Dispose(); 
doc = null;

Static DroupDownList Us In DataGridView

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.OleDb;
using System.Data.SqlClient;
namespace Bar_nd_Hotel
{
   
    public partial class SearchAll : Form
    {
        DAL obj = new DAL();
        DataTable dt = new DataTable();
        public SearchAll()
        {
            InitializeComponent();
        }

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

        private void btnsearch_Click(object sender, EventArgs e)
        {
            string constring = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=bar_db;Integrated Security=True";
            SqlConnection con = new SqlConnection(constring);



            string selectval = Cmboselectitem.SelectedItem.ToString();

            if (selectval == "Staff Details")
            {
                //string qry = "";
                SqlCommand cmd = new SqlCommand();
                string sqlqry = "Select * from crtstaff ";
                if (txtname.Text != "")
                {
                    sqlqry += "where stfname = '" + txtname.Text + "' ";
                }
                else if (txtpost.Text != "")
                {
                    sqlqry += "where post = '" + txtpost.Text + "' ";
                }
                else if (txtsalary.Text != "")
                {
                    sqlqry += "where salary='" + txtsalary.Text + "'";
                }
                else if (txtmobileno.Text != "")
                {
                    sqlqry += "where mobile_no='" + txtmobileno.Text + "'";
                }
                else if (dateTimePicker1.Value.ToShortDateString() != "")
                {
                    sqlqry += "where Date between '" + dateTimePicker1.Value.ToShortDateString() + "' and '" + dateTimePicker2.Value.ToShortDateString() + "'";
                }

                Searchgrid.DataSource = "";
                cmd.CommandText = sqlqry;
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.SelectCommand = cmd;
                DataSet ds = new DataSet();
                da.Fill(ds, "crtstaff");

                Searchgrid.DataSource = ds.Tables["crtstaff"].DefaultView;


            }




            if (selectval == "Salary Details")
            {
                string sqlry = "Select * from salarystatus ";
                if (txtname.Text != "")
                {
                    sqlry += "where stfname = '" + txtname.Text + "' ";
                }
                else if (txtworkdays.Text != "")
                {
                    sqlry += "where workdays ='" + txtworkdays.Text + "' ";
                }
                else if (chkdueamount.Checked == true)
                {
                    sqlry += "where dueamt != '' and dueamt != '0'";
                }
                else if (chkpaidamount.Checked == true)
                {
                    sqlry += "where paidamt !='' and paidamt != '0'";
                }
                else if (chkabsent.Checked == true)
                {
                    sqlry += "where absent !='' and absent != '0'";
                }
                else if (chkdayshift.Checked == true)
                {
                    sqlry += "where dayshift !='' and dayshift != '0'";
                }
                else if (chknight.Checked == true)
                {
                    sqlry += "where nightshift !='' and nightshift != '0'";
                }
                else if (dateTimePicker1.Value.ToShortDateString() != "")
                {
                    sqlry += "where Date between '" + dateTimePicker1.Value.ToShortDateString() + "' and '" + dateTimePicker2.Value.ToShortDateString() + "'";
                }
                SqlCommand cmd = new SqlCommand();
                Searchgrid.DataSource = "";
                cmd.CommandText = sqlry;
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.SelectCommand = cmd;
                DataSet ds = new DataSet();
                da.Fill(ds, "salarystatus");

                Searchgrid.DataSource = ds.Tables["salarystatus"].DefaultView;

            }
         


        }
     

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

    
       
    }
}