package
web_VJnet;
import
System.Collections.*;
import
System.ComponentModel.*;
import
System.Data.*;
import
System.Drawing.*;
import
System.Web.*;
import
System.Web.SessionState.*;
import
System.Web.UI.*;
import
System.Web.UI.WebControls.*;
import
System.Web.UI.HtmlControls.*;
/**
* Summary description for Dataweb_book.
*/
public
class
Dataweb_book extends
System.Web.UI.Page
{
protected
System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
protected
System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
protected
System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
protected
System.Data.OleDb.OleDbConnection oleDbConnection1;
protected
System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
protected
web_VJnet.Dataweb_bookdset objDataweb_bookdset;
protected
System.Web.UI.WebControls.DataGrid masterDataGrid;
protected
System.Web.UI.WebControls.HyperLink HyperLink2;
protected
System.Web.UI.WebControls.LinkButton LinkButton3;
protected
System.Web.UI.WebControls.Label Label1;
protected
System.Web.UI.WebControls.Label lbnavigation;
protected
System.Web.UI.WebControls.LinkButton LinkButton4;
protected
System.Web.UI.WebControls.LinkButton LinkButton5;
protected
System.Web.UI.WebControls.LinkButton LinkButton6;
protected
System.Web.UI.WebControls.LinkButton LinkButton7;
protected
System.Web.UI.WebControls.LinkButton LinkButton8;
protected
System.Web.UI.WebControls.LinkButton LinkButton9;
protected
System.Web.UI.WebControls.LinkButton LinkButton10;
protected
System.Web.UI.WebControls.LinkButton LinkButton2;
protected
System.Web.UI.WebControls.Panel Panel1;
protected
System.Web.UI.WebControls.LinkButton LinkButton1;
protected
System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
//variable
int
vpagecount;
private
void
Page_Load(Object sender, System.EventArgs e)
{
// Put user code
to initialize the page here
if (get_Session().get_Item("mydatset")
== null)
{
try
{
this.LoadDataSet();
this.masterDataGrid.set_SelectedIndex(-1);
this.masterDataGrid.DataBind();
}
catch
(System.Exception eLoad)
{
this.get_Response().Write(eLoad.get_Message());
}
//!!
get_Session().get_Item("mydatset").equals(this.objDataweb_bookdset);
// Enable paging.
masterDataGrid.set_AllowPaging(true );
masterDataGrid.set_PageSize(5);
if
(!get_Page().get_IsPostBack())
{
masterDataGrid.set_DataSource( this.objDataweb_bookdset);
masterDataGrid.DataBind();
//Show the 10
first Page numbers
sub_showpagenumbers();
LinkButton1_Click(sender, e);
}
}
else
{
this.objDataweb_bookdset.equals(((web_VJnet.
Dataweb_bookdset)(get_Session().get_Item("mydatset"))));
}
}
Wwb Form
Designer generated code |
public void LoadDataSet () throws
System.Exception
{
// Create a new
dataset to hold the records returned from the call to
FillDataSet.
// A temporary
dataset is used because filling the existing dataset would
// require the
databindings to be rebound.
web_VJnet.Dataweb_bookdset objDataSetTemp;
objDataSetTemp =
new web_VJnet.Dataweb_bookdset();
try
{
// Attempt to
fill the temporary dataset.
this.FillDataSet(objDataSetTemp);
}
catch
(System.Exception eFillDataSet)
{
// Add your error
handling code here.
throw
eFillDataSet;
}
try
{
// Empty the old
records from the dataset.
objDataweb_bookdset.Clear();
// Merge the
records into the main dataset.
objDataweb_bookdset.Merge(objDataSetTemp);
}
catch
(System.Exception eLoadMerge)
{
// Add your error
handling code here.
throw
eLoadMerge;
}
}
public
void
FillDataSet (web_VJnet.Dataweb_bookdset dataSet)
throws
System.Exception
{
// Turn off
constraint checking before the dataset is filled.
// This allows
the adapters to fill the dataset without concern
// for
dependencies between the tables.
dataSet.set_EnforceConstraints( false);
try
{
// Open the
connection.
this.oleDbConnection1.Open();
// Attempt to
fill the dataset through the OleDbDataAdapter1.
this.oleDbDataAdapter1.Fill(dataSet);
}
catch
(System.Exception fillException)
{
// Add your error
handling code here.
throw
fillException;
}
finally
{
// Turn
constraint checking back on.
dataSet.set_EnforceConstraints( true);
// Close the
connection whether or not the exception was thrown.
this.oleDbConnection1.Close();
}
}
//Show the 10 first Page numbers
public void
sub_showpagenumbers()
{
int
i;
vpagecount =
this.masterDataGrid.get_PageCount();
if
(vpagecount <= 10)
{
for
(i = 0 ; i <= 10; i++)
{
switch(i)
{
case
1:
if
((i <= vpagecount) && (i == 1))
{
this.LinkButton1.set_Visible(true);
}
else
{
this.LinkButton1.set_Visible(false);
}
break;
case
2:
if
((i <= vpagecount) && (i == 2))
{
this.LinkButton2.set_Visible(true);
}
else
{
this.LinkButton2.set_Visible(false);
}
break;
case
3:
if
((i <= vpagecount) && (i == 3))
{
this.LinkButton3.set_Visible(true);
}
else
{
this.LinkButton3.set_Visible(false);
}
break;
case
4:
if
((i <= vpagecount) && (i == 4))
{
this.LinkButton4.set_Visible(true);
}
else
{
this.LinkButton4.set_Visible(false);
}
break;
case
5:
if
((i <= vpagecount) && (i == 5))
{
this.LinkButton5.set_Visible(true);
}
else
{
this.LinkButton5.set_Visible(false);
}
break;
case
6:
if
((i <= vpagecount) && (i == 6))
{
this.LinkButton6.set_Visible(true);
}
else
{
this.LinkButton6.set_Visible(false);
}
break;
case
7:
if
((i <= vpagecount) && (i == 7))
{
this.LinkButton7.set_Visible(true);
}
else
{
this.LinkButton7.set_Visible(false);
}
break;
case
8:
if
((i <= vpagecount) && (i == 8))
{
this.LinkButton8.set_Visible(true);
}
else
{
this.LinkButton8.set_Visible(false);
}
break;
case
9:
if
((i <= vpagecount) && (i == 9))
{
this.LinkButton9.set_Visible(true);
}
else
{
this.LinkButton9.set_Visible(false);
}
break;
case
10:
if
((i <= vpagecount) && (i == 10))
{
this.LinkButton10.set_Visible(true);
}
else
{
this.LinkButton10.set_Visible(false);
}
break;
}
}
}
}
//
***************************** Edit, Update, Cancel
private void
masterDataGrid_EditCommand(Object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.masterDataGrid.set_EditItemIndex(e.get_Item().get_ItemIndex());
this.masterDataGrid.DataBind();
}
private void
masterDataGrid_CancelCommand(Object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.masterDataGrid.set_EditItemIndex(-1);
this.masterDataGrid.DataBind();
}
private void
masterDataGrid_UpdateCommand(Object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
String vfirstname;
String vfathername;
String vname;
String vcountry;
String vcity;
// Gets the value
of the key field of the row being updated
String key =
masterDataGrid.get_DataKeys().get_Item(e.get_Item().get_ItemIndex()).ToString();
// Gets get the
value of the controls (textboxes) that the user
// updated. The
DataGrid columns are exposed as the Cells collection.
// Each cell has
a collection of controls. In this case, there is only one
// control in
each cell -- a TextBox control. To get its value,
// you copy the
TextBox to a local instance (which requires casting)
// and extract
its Text property.
//
// The first
column -- Cells(0) -- contains the Update and Cancel
buttons.
System.Web.UI.WebControls.TextBox tb;
// Gets the value
the TextBox control in the 2nd column
tb = ((System.Web.UI.WebControls.TextBox)(e.get_Item().get_Cells().get_Item(1).get_Controls().get_Item(0)));
vfirstname = tb.get_Text();
// Gets the value
the TextBox control in the 3th column
tb = ((System.Web.UI.WebControls.TextBox)(e.get_Item().get_Cells().get_Item(2).get_Controls().get_Item(0)));
vfathername =
tb.get_Text();
// Gets the value
the TextBox control in the 4th column
tb = ((System.Web.UI.WebControls.TextBox)(e.get_Item().get_Cells().get_Item(3).get_Controls().get_Item(0)));
vname = tb.get_Text();
// Gets the value
the TextBox control in the 5th column
tb = ((System.Web.UI.WebControls.TextBox)(e.get_Item().get_Cells().get_Item(4).get_Controls().get_Item(0)));
vcountry = tb.get_Text();
// Gets the value
the TextBox control in the 6th column
tb = ((System.Web.UI.WebControls.TextBox)(e.get_Item().get_Cells().get_Item(5).get_Controls().get_Item(0)));
vcity = tb.get_Text();
// Finds the row
in the dataset table that matches the
// one the user
updated in the grid. This example uses a
// special Find
method defined for the typed dataset, which
// returns a
reference to the row.
Dataweb_bookdset.booknoteRow r;
r =
objDataweb_bookdset.get_booknote().FindBybookid(System.Convert.ToInt16(key));
// Updates the
dataset table.
r.set_first_name(vfirstname);
r.set_father_name(vfathername);
r.set_name(vname);
r.set_country(vcountry);
r.set_city(vcity);
// Calls a OLE
statement to update the database from the dataset
this.oleDbDataAdapter1.Update(objDataweb_bookdset,
"booknote");
this.oleDbDataAdapter1.set_UpdateCommand(this.oleDbUpdateCommand1);
// Takes the
DataGrid row out of editing mode
masterDataGrid.set_EditItemIndex(-1);
// Refreshes the
grid
masterDataGrid.DataBind();
}
//
******************** Navigation, page numbers
private void
LinkButton1_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton1.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton1.get_Text());
LinkButton1.set_Enabled( false);
}
//Page numbers
navigation, load page
private void
sub_oppagenumbers( String vcpage)
{
vpagecount =
this.masterDataGrid.get_PageCount();
this.lbnavigation.set_Text("
Page Numbers operation - page size = 5 records .........
Page : " + System.Convert.ToString(vcpage) + " of " +
System.Convert.ToString(vpagecount));
if (
LinkButton1.get_Visible() == true)
LinkButton1.set_Enabled( true);
if (
LinkButton2.get_Visible() == true)
LinkButton2.set_Enabled( true);
if (
LinkButton3.get_Visible() == true)
LinkButton3.set_Enabled( true);
if (
LinkButton4.get_Visible() == true)
LinkButton4.set_Enabled( true);
if (
LinkButton5.get_Visible() == true)
LinkButton5.set_Enabled( true);
if (
LinkButton6.get_Visible() == true)
LinkButton6.set_Enabled( true);
if (
LinkButton7.get_Visible() == true)
LinkButton7.set_Enabled( true);
if (
LinkButton8.get_Visible() == true)
LinkButton8.set_Enabled( true);
if (
LinkButton9.get_Visible() == true)
LinkButton9.set_Enabled( true);
if (
LinkButton10.get_Visible() == true)
LinkButton10.set_Enabled( true);
// Takes the
DataGrid row out of editing mode
masterDataGrid.set_EditItemIndex(-1);
masterDataGrid.set_DataSource( this.objDataweb_bookdset);
masterDataGrid.DataBind();
}
private void
LinkButton2_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton2.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton2.get_Text());
LinkButton2.set_Enabled( false);
}
private void
LinkButton3_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton3.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton3.get_Text());
LinkButton3.set_Enabled( false);
}
private void
LinkButton4_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton4.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton4.get_Text());
LinkButton4.set_Enabled( false);
}
private void
LinkButton5_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton5.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton5.get_Text());
LinkButton5.set_Enabled( false);
}
private void
LinkButton6_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton6.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton6.get_Text());
LinkButton6.set_Enabled( false);
}
private void
LinkButton7_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton7.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton7.get_Text());
LinkButton7.set_Enabled( false);
}
private void
LinkButton8_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton8.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton8.get_Text());
LinkButton8.set_Enabled( false);
}
private void
LinkButton9_Click(Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton9.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton9.get_Text());
LinkButton9.set_Enabled( false);
}
private void
LinkButton10_Click (Object sender, System.EventArgs e)
{
masterDataGrid.set_CurrentPageIndex(System.Convert.ToInt16(LinkButton10.get_Text())
- 1);
//Page numbers
navigation, load page
sub_oppagenumbers(LinkButton10.get_Text());
LinkButton10.set_Enabled( false);
}
}
|