Visual J# .Net Form - SelectForm.jsl, Text Codes
 
 
 

       
      Return


    

 The codes  ..
    The Form -  SelectForm.jsl

Use  OleDbDataAdapterOleDbSelectCommand and  DataSet  software control
   
 
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();

}

}

 


 

      Return