using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Reflection;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace WindowsApplication3
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class FrmPractice : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Button btn_Click;
private System.Windows.Forms.DataGrid da_SpecificRecords;
private System.Data.DataTable dtSecondGrid = new System.Data.DataTable();
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null;
private System.Windows.Forms.Button btn_Exit;
public FrmPractice()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.btn_Click = new System.Windows.Forms.Button();
this.da_SpecificRecords = new System.Windows.Forms.DataGrid();
this.btn_Exit = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.da_SpecificRecords)).BeginInit();
this.SuspendLayout();
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(32, 48);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(440, 152);
this.dataGrid1.TabIndex = 0;
this.dataGrid1.DoubleClick += new System.EventHandler(this.dataGrid1_DoubleClick);
this.dataGrid1.Navigate += new System.Windows.Forms.NavigateEventHandler(this.dataGrid1_Navigate);
//
// btn_Click
//
this.btn_Click.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(192)), ((System.Byte)(128)));
this.btn_Click.Location = new System.Drawing.Point(48, 224);
this.btn_Click.Name = "btn_Click";
this.btn_Click.Size = new System.Drawing.Size(96, 23);
this.btn_Click.TabIndex = 1;
this.btn_Click.Text = "Show Records";
this.btn_Click.Click += new System.EventHandler(this.btn_Click_Click);
//
// da_SpecificRecords
//
this.da_SpecificRecords.AllowDrop = true;
this.da_SpecificRecords.DataMember = "";
this.da_SpecificRecords.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.da_SpecificRecords.Location = new System.Drawing.Point(32, 288);
this.da_SpecificRecords.Name = "da_SpecificRecords";
this.da_SpecificRecords.Size = new System.Drawing.Size(440, 128);
this.da_SpecificRecords.TabIndex = 2;
//
// btn_Exit
//
this.btn_Exit.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(192)), ((System.Byte)(128)));
this.btn_Exit.Location = new System.Drawing.Point(376, 224);
this.btn_Exit.Name = "btn_Exit";
this.btn_Exit.Size = new System.Drawing.Size(96, 23);
this.btn_Exit.TabIndex = 3;
this.btn_Exit.Text = "Exit";
this.btn_Exit.Click += new System.EventHandler(this.btn_Exit_Click);
//
// FrmPractice
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(128)), ((System.Byte)(128)));
this.ClientSize = new System.Drawing.Size(504, 510);
this.Controls.Add(this.btn_Exit);
this.Controls.Add(this.da_SpecificRecords);
this.Controls.Add(this.btn_Click);
this.Controls.Add(this.dataGrid1);
this.Name = "FrmPractice";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Practice";
this.Load += new System.EventHandler(this.FrmPractice_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.da_SpecificRecords)).EndInit();
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new FrmPractice());
}
private void btn_Click_Click(object sender, System.EventArgs e)
{
SqlConnection oConn = new SqlConnection("Server=CTX91;uid=sa;pwd=sa;Database=Northwind");
string sql = "select * from Customers";
SqlDataAdapter DA = new SqlDataAdapter(sql,oConn);
DataSet DS = new DataSet();
DA.Fill(DS,"Customers");
dataGrid1.DataSource = DS.Tables["Customers"].DefaultView;
}
private void dataGrid1_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
{
}
private void dataGrid1_DoubleClick(object sender, System.EventArgs e)
{
try
{
string str = "";
str = dataGrid1[dataGrid1.CurrentRowIndex,0].ToString();
SqlConnection oConn = new SqlConnection("Server=CTX91;uid=sa;pwd=sa;Database=Northwind");
oConn.Open();
string sql = "select * from Customers where CustomerID = '" + str + "'";
SqlDataAdapter DA = new SqlDataAdapter(sql,oConn);
DataSet DS = new DataSet();
DA.Fill(DS,"Customers");
if(dtSecondGrid.Rows.Count<=0)
{
dtSecondGrid = DS.Tables[0];
}
else
{
foreach(DataRow myRow in DS.Tables[0].Rows)
{
dtSecondGrid.ImportRow(myRow);
break;
}
}
da_SpecificRecords.DataSource = dtSecondGrid;
}
catch(System.Exception E)
{
MessageBox.Show(E.Message.ToString());
}
}
private void FrmPractice_Load(object sender, System.EventArgs e)
{
}
private void btn_Exit_Click(object sender, System.EventArgs e)
{
Application.Exit();
}
}