package
Select_Data_VJSNet;
import System.Drawing.*;
import System.Collections.*;
import System.ComponentModel.*;
import System.Windows.Forms.*;
import System.Data.*;
/**
* Summary description for Form1.
*/
public
class
SelectForm extends
System.Windows.Forms.Form
{
private
System.Windows.Forms.Button btnabout;
private
System.Windows.Forms.Button btnint;
private
System.Windows.Forms.Button btnexit;
private
System.Windows.Forms.Panel panel1;
private
System.Windows.Forms.ComboBox comboBox1;
private
System.Windows.Forms.Label label1;
private
System.Windows.Forms.ListBox listBox1;
private
System.Windows.Forms.Label label2;
private
System.Windows.Forms.Panel panel2;
private
System.Windows.Forms.PictureBox pictureBox1;
private
System.Windows.Forms.Label ltime;
private
System.Windows.Forms.Timer timer1;
private
System.Windows.Forms.ListView listView1;
private
System.Windows.Forms.Panel panel3;
private
System.Windows.Forms.TextBox editnarrative;
private
System.Windows.Forms.Label label6;
private
System.Windows.Forms.TextBox edittitle;
private
System.Windows.Forms.Label label5;
private
System.Windows.Forms.TextBox editcategory;
private
System.Windows.Forms.Label label4;
private
System.Windows.Forms.Label label3;
private
System.Windows.Forms.Label label7;
private
System.Windows.Forms.TextBox editbrand;
private
System.Windows.Forms.TextBox editproduct;
private
System.Windows.Forms.Label label8;
private
System.Data.OleDb.OleDbConnection oleDbConnection1;
private
System.ComponentModel.IContainer components;
// Variables
int vrow;
// Select command
System.Data.OleDb.OleDbCommand selectCMD ;
// Data adapter
System.Data.OleDb.OleDbDataAdapter bookDA =
new
System.Data.OleDb.OleDbDataAdapter();
// DataSet
System.Data.DataSet XMView2002DSet;
public SelectForm()
...
protected
void
Dispose(boolean
disposing) ...
Windows Form Designer generated
code |
public
static
void
main(String[] args)
{
Application.Run( new
SelectForm());
}
// Initial Load
private
void Form1_Load
(Object sender, System.EventArgs e)
{
// ComboBox ...
this.comboBox1.get_Items().Add("Select
...");
this.comboBox1.get_Items().Add("Brand");
this.comboBox1.get_Items().Add("Category");
this.comboBox1.get_Items().Add("Country");
this.comboBox1.get_Items().Add("Product");
this.comboBox1.set_SelectedIndex(0);
//LstView1, Header
Header_List();
}
// ListView1, Header
column
private
void Header_List()
{
int ColWith;
th = (this.listView1.get_Width()
/ 7) - 4;
// Column Header
this.listView1.get_Columns().Add("Brand",
ColWith, HorizontalAlignment.Center);
this.listView1.get_Columns().Add("Category",
ColWith, HorizontalAlignment.Left);
this.listView1.get_Columns().Add("Country",
ColWith, HorizontalAlignment.Left);
this.listView1.get_Columns().Add("Product",
ColWith, HorizontalAlignment.Left);
this.listView1.get_Columns().Add("Title",
2* ColWith, HorizontalAlignment.Left);
this.listView1.get_Columns().Add("Date",
ColWith, HorizontalAlignment.Center);
this.listView1.get_Columns().Add("",
0, HorizontalAlignment.Left);
}
// Time Value
private
void timer1_Tick
(Object sender, System.EventArgs e)
{
this.ltime.set_Text(System.DateTime.get_Now().ToLongTimeString());
}
// Select combobox item
private
void
comboBox1_SelectedIndexChanged (Object sender,
System.EventArgs e)
{
// Clear tne ListBox &
ListView
this.listBox1.get_Items().Clear();
this.listView1.Clear();
//LstView1, Header
Header_List();
// Allow the user to
edit item text.
this.listView1.set_LabelEdit(true);
// Allow the user to
rearrange columns.
this.listView1.set_AllowColumnReorder(true);
// Select the item and
subitems when selection is made.
this.listView1.set_FullRowSelect(true);
// Display grid lines.
this.listView1.set_GridLines(true);
/** ComboBox Control ...
Notes:
- Order by Brand Field
- Order by Product Field
- Order by Category Field
- Order by [Country 1] Field
**/
// Display Unique Values
if (this.comboBox1.get_SelectedItem().ToString()==
"Brand")
SetSelect1(1); //Order
by Brand Field 1
else
{
if (this.comboBox1.get_SelectedItem().ToString()==
"Category")
SetSelect1(3); //Order
by Category Field 3
else
{
if (this.comboBox1.get_SelectedItem().ToString()==
"Country")
SetSelect1(7); //Order
by Country Field 7
else
{
if (this.comboBox1.get_SelectedItem().ToString()==
"Product")
SetSelect1(2); //Order
by Product Field 2
}
}
}
}
// Display Unique Value
only, from the Brand, Categry, Country or Product fields
Values
private
void SetSelect1(int
Varfield)
{
int ii = 0;
String ListbSelect = "";
if (Varfield ==
1)
selectCMD = new
System.Data.OleDb.OleDbCommand("select
ID,Brand,Product,Category,Date,Title,
Narrative,[Country 1],Serial from SpotInfo order by
brand", this.oleDbConnection1);
else
{
if (Varfield ==
3)
selectCMD = new
System.Data.OleDb.OleDbCommand("select
ID,Brand,Product,Category,Date,Title,
Narrative,[Country 1],Serial from SpotInfo order by
Category", this.oleDbConnection1);
else
{
if (Varfield ==
7)
selectCMD = new
System.Data.OleDb.OleDbCommand("select
ID,Brand,Product,Category,Date,Title,
Narrative,[Country 1],Serial from SpotInfo order by
[Country 1]", this.oleDbConnection1);
else
{
if (Varfield ==
2)
selectCMD = new
System.Data.OleDb.OleDbCommand("select
ID,Brand,Product,Category,Date,Title
Narrative,[Country 1],Serial from SpotInfo order by
Product", this.oleDbConnection1);
}
}
}
selectCMD.set_Connection(this.oleDbConnection1);
bookDA.set_SelectCommand(selectCMD);
XMView2002DSet= new
System.Data.DataSet();
this.oleDbConnection1.Open();
bookDA.Fill(XMView2002DSet,"SpotInfo");
this.oleDbConnection1.Close();
for (vrow = 0;
vrow <= XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Count()
- 1; vrow++)
{
// Brand or Categry or
Country or Product fiels
if
(!XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrow).get_Item(Varfield).
ToString().equals(""))
{
if (ii == 0)
{
ListbSelect = XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrow).
get_Item(Varfield).ToString();
this.listBox1.get_Items().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().
get_Item(vrow).get_Item(Varfield).ToString());
ii = ii + 1;
}
else
{
if
(!XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrow).
get_Item(Varfield).ToString().equals(ListbSelect.ToString()))
{
ListbSelect = XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrow).
get_Item(Varfield).ToString();
this.listBox1.get_Items().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().
get_Item(vrow).get_Item(Varfield).ToString());
ii = ii + 1;
}
}
}
}
}
// Select ListBox item
private
void
listBox1_SelectedIndexChanged (Object sender,
System.EventArgs e)
{
ListViewItem item1;
boolean Flag1 =
false;
int jj = 0;
int vrecord = 0;
selectCMD = new
System.Data.OleDb.OleDbCommand("select
ID,Brand,Product,Category,Date,Title,
Narrative,[Country 1],Serial from SpotInfo order by date",
this.oleDbConnection1);
selectCMD.set_Connection(this.oleDbConnection1);
bookDA.set_SelectCommand(selectCMD);
XMView2002DSet= new
System.Data.DataSet();
this.oleDbConnection1.Open();
bookDA.Fill(XMView2002DSet,"SpotInfo");
this.oleDbConnection1.Close();
for (vrow = 0;
vrow <= XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Count()
- 1; vrow++)
{
// Brand
if
(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrow).get_Item(1).ToString().
Trim().Equals(this.listBox1.get_SelectedItem().ToString().trim()))
{
vrecord = vrow;
if (this.listView1.get_Items().get_Count()
> 0)
{
for (jj = 0; jj
<= this.listView1.get_Items().get_Count()
- 1; jj++)
{
if (this.listView1.get_Items().get_Item(jj).get_SubItems().get_Item(7).get_Text().ToString().
Trim().equals(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(8).ToString().Trim()))
Flag1 = true;
}
}
if (Flag1 ==
false)
{
// Add items to the
ListView1 Control
// Brand
item1 = new
ListViewItem(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(1).ToString(), 0);
// Category
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(3).ToString());
// Country
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(7).ToString());
// Product
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(2).ToString());
// Title
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(5).ToString());
// Date
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(4).ToString());
// Narrative
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(6).ToString());
// Serial
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(8).ToString());
//Add the items to the
ListView.
listView1.get_Items().AddRange(new
ListViewItem[]{item1});
}
} // if
else
{
// Category
if(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrow).get_Item(3).ToString().
Trim().Equals(this.listBox1.get_SelectedItem().ToString().trim()))
{
vrecord = vrow;
if (this.listView1.get_Items().get_Count()
> 0)
{
for (jj = 0; jj
<= this.listView1.get_Items().get_Count()
- 1; jj++)
{
if (this.listView1.get_Items().get_Item(jj).get_SubItems().get_Item(7).get_Text().ToString().Trim().
equals(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(8).ToString().Trim()))
Flag1 = true;
}
}
if (Flag1 ==
false)
{
// Add items to the
ListView1 Control
// Brand
item1 = new
ListViewItem(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(1).ToString(), 0);
// Category
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(3).ToString());
// Country
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(7).ToString());
// Product
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(2).ToString());
// Title
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(5).ToString());
// Date
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(4).toString());
// Narrative
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(6).ToString());
// Serial
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(8).ToString());
//Add the items to the
ListView.
listView1.get_Items().AddRange(new
ListViewItem[]{item1});
}
} // if
else
{
// Country
if
(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrow).get_Item(7).ToString().
Trim().Equals(this.listBox1.get_SelectedItem().ToString().trim()))
{
vrecord = vrow;
if (this.listView1.get_Items().get_Count()
> 0)
{
for (jj = 0; jj
<= this.listView1.get_Items().get_Count()
- 1; jj++)
{
if (this.listView1.get_Items().get_Item(jj).get_SubItems().get_Item(7).get_Text().ToString().Trim().
equals(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(8).ToString().Trim()))
Flag1 = true;
}
}
if (Flag1 ==
false)
{
// Add items to the
ListView1 Control
// Brand
item1 = new
ListViewItem(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(1).ToString(), 0);
// Category
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(3).ToString());
// Country
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(7).ToString());
// Product
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(2).ToString());
// Title
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(5).ToString());
// Date
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(4).ToString());
// Narrative
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(6).ToString());
// Serial
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).
get_Item(8).ToString());
//Add the items to the
ListView.
listView1.get_Items().AddRange(new
ListViewItem[]{item1});
}
} //if
else
{
// Product
if(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrow).get_Item(2).ToString().Trim().
Equals(this.listBox1.get_SelectedItem().ToString().trim()))
{
vrecord = vrow;
if (this.listView1.get_Items().get_Count()
> 0)
{
for (jj = 0; jj
<= this.listView1.get_Items().get_Count()
- 1; jj++)
{
if (this.listView1.get_Items().get_Item(jj).get_SubItems().get_Item(7).get_Text().ToString().Trim().
equals(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(8).ToString().Trim()))
Flag1 = true;
}
}
if (Flag1 ==
false)
{
// Add items to the
ListView1 Control
// Brand
item1 = new
ListViewItem(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(1).ToString(), 0);
// Category
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(3).ToString());
// Country
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(7).ToString());
// Product
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(2).ToString());
// Title
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(5).ToString());
// Date
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(4).ToString());
// Narrative
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(6).ToString());
// Serial
item1.get_SubItems().Add(XMView2002DSet.get_Tables().get_Item("SpotInfo").get_Rows().get_Item(vrecord
).get_Item(8).ToString());
//Add the items to the
ListView.
listView1.get_Items().AddRange(new
ListViewItem[]{item1});
}
} //if
}
}
}
} // for
} // fin
// Select ListView item
private
void listView1_Click
(Object sender, System.EventArgs e)
{
this.editbrand.set_Text(this.listView1.get_SelectedItems().get_Item(0).get_SubItems().get_Item(0).get_Text());
this.editcategory.set_Text(this.listView1.get_SelectedItems().get_Item(0).get_SubItems().get_Item(3).get_Text());
this.editproduct.set_Text(this.listView1.get_SelectedItems().get_Item(0).get_SubItems().get_Item(1).get_Text());
this.edittitle.set_Text(this.listView1.get_SelectedItems().get_Item(0).get_SubItems().get_Item(4).get_Text());
this.editnarrative.set_Text(this.listView1.get_SelectedItems().get_Item(0).get_SubItems().get_Item(6).get_Text());
}
private
void btnint_Click
(Object sender, System.EventArgs e)
{
IntroductoryForm fint =
new IntroductoryForm();
fint.Show();
}
private
void btnabout_Click
(Object sender, System.EventArgs e)
{
About fabout = new
About();
fabout.Show();
}
private
void btnexit_Click
(Object sender, System.EventArgs e)
{
Application.Exit();
}
}
|