Dynamic DataGrid Problem

D

Dave Bailey

I am trying to dynamically build a DataGrid dynamically.
The code runs OK but the DataGrid is never built and
displayed. Can someone look at the following code and see
if they can determine what I am missing.

Thanks,

Dave

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Configuration;




namespace Type3CTracking
{
/// <summary>
/// Summary description for detailsForm.
/// </summary>
public class workorderDetailsForm :
System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label
workorderLabel;
protected System.Web.UI.WebControls.Label
mrLabel;
protected
System.Web.UI.WebControls.TextBox mrText;
protected System.Web.UI.WebControls.Label
prLabel;
protected
System.Web.UI.WebControls.TextBox prText;
protected System.Web.UI.WebControls.Label
poLabel;
protected
System.Web.UI.WebControls.TextBox poText;
protected
System.Web.UI.WebControls.TextBox workorderText;
protected System.Web.UI.WebControls.Label
wonumLabel;
protected
System.Data.OleDb.OleDbDataAdapter oda;
protected
System.Data.OleDb.OleDbConnection dataConnection;
protected System.Data.OleDb.OleDbCommand
dataCommand;
protected
System.Data.OleDb.OleDbDataReader dataReader;
protected System.Data.DataSet ds = new
DataSet();
public DataGrid workorder = new DataGrid();


private void Page_Load(object sender,
System.EventArgs e)
{


string workorder = Request
["Workorder"];
workorderText.Text = workorder;

string mr = Request["MR"];
mrText.Text = mr;

string pr = Request["PR"];
prText.Text = pr;

string po = Request["PO"];
poText.Text = po;

CreateDataSource();


}




#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required
by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support -
do not modify
/// the contents of this method with the
code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new
System.EventHandler(this.Page_Load);

}
#endregion




private void CreateDataSource()
{
string connStr
= "Provider=\"MSDAORA.1\";User ID=DB1;Data
Source=DEMO;Password=XXXXXXXX";
string strSelect = "Select Wonum
from Workorder where Wonum =" + "'" + workorderText.Text
+ "'";

oda = new OleDbDataAdapter
(strSelect, connStr);
ds = new DataSet();

oda.Fill(ds);
ds.Tables[0].TableName
= "Workorder";

//make the DataGrid
workorder = new DataGrid();
workorder.CellPadding = 2;
workorder.CellSpacing = 0;
workorder.Width = 550;
workorder.BorderWidth = 1;
workorder.BorderColor =
Color.Black;
workorder.AutoGenerateColumns =
false;
workorder.ForeColor = Color.Black;
workorder.Font.Size = 8;
workorder.Font.Name = "Arial";

//sets the HeaderStyle
workorder.HeaderStyle.BackColor =
Color.Gold;
workorder.HeaderStyle.ForeColor =
Color.Black;
workorder.HeaderStyle.Font.Name
= "Arial";
workorder.HeaderStyle.Font.Size =
9;

workorder.HeaderStyle.HorizontalAlign =
HorizontalAlign.Center;

//sets alternating style

workorder.AlternatingItemStyle.BackColor =
Color.Silver;

workorder.AlternatingItemStyle.ForeColor =
Color.Black;

//sets the itemstyle

workorder.ItemStyle.HorizontalAlign =
HorizontalAlign.Left;

//create the bound columns
BoundColumn Wonum = new BoundColumn
();

Wonum.HeaderText = "Wonum";
Wonum.DataField = "Wonum";

//add bound columns to datagrid
workorder.Columns.AddAt(0, Wonum);

//bind the DataDrid
workorder.DataSource = ds.Tables
["Workorder"];
workorder.DataBind();

}


}
}
 
J

Jerry Negrelli

Are you sure that you've defined a client-side
<asp:DataGrid /> tag with ID="workorder" (case-sensitive)?

Because you have the "= new DataGrid()" statement in your
page initialization, the code-behind will execute
properly. I'll bet if you remove that statement and just
keep the "protected DataGrid workorder;" part, you'll get
an "object reference not set to an instance of an object"
error, which often means you haven't correctly defined a
client-side component.

Jerry Negrelli
Senior Software Engineer
Data Scientific Corporation

-----Original Message-----
I am trying to dynamically build a DataGrid dynamically.
The code runs OK but the DataGrid is never built and
displayed. Can someone look at the following code and see
if they can determine what I am missing.

Thanks,

Dave

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Configuration;




namespace Type3CTracking
{
/// <summary>
/// Summary description for detailsForm.
/// </summary>
public class workorderDetailsForm :
System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label
workorderLabel;
protected System.Web.UI.WebControls.Label
mrLabel;
protected
System.Web.UI.WebControls.TextBox mrText;
protected System.Web.UI.WebControls.Label
prLabel;
protected
System.Web.UI.WebControls.TextBox prText;
protected System.Web.UI.WebControls.Label
poLabel;
protected
System.Web.UI.WebControls.TextBox poText;
protected
System.Web.UI.WebControls.TextBox workorderText;
protected System.Web.UI.WebControls.Label
wonumLabel;
protected
System.Data.OleDb.OleDbDataAdapter oda;
protected
System.Data.OleDb.OleDbConnection dataConnection;
protected System.Data.OleDb.OleDbCommand
dataCommand;
protected
System.Data.OleDb.OleDbDataReader dataReader;
protected System.Data.DataSet ds = new
DataSet();
public DataGrid workorder = new DataGrid ();


private void Page_Load(object sender,
System.EventArgs e)
{


string workorder = Request
["Workorder"];
workorderText.Text = workorder;

string mr = Request["MR"];
mrText.Text = mr;

string pr = Request["PR"];
prText.Text = pr;

string po = Request["PO"];
poText.Text = po;

CreateDataSource();


}




#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required
by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support -
Click to expand...
do not modify
/// the contents of this method with the
code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new
System.EventHandler(this.Page_Load);

}
#endregion




private void CreateDataSource()
{
string connStr
= "Provider=\"MSDAORA.1\";User ID=DB1;Data
Source=DEMO;Password=XXXXXXXX";
string strSelect = "Select Wonum
from Workorder where Wonum =" + "'" + workorderText.Text
+ "'";

oda = new OleDbDataAdapter
(strSelect, connStr);
ds = new DataSet();

oda.Fill(ds);
ds.Tables[0].TableName
= "Workorder";

//make the DataGrid
workorder = new DataGrid();
workorder.CellPadding = 2;
workorder.CellSpacing = 0;
workorder.Width = 550;
workorder.BorderWidth = 1;
workorder.BorderColor =
Color.Black;
workorder.AutoGenerateColumns =
false;
workorder.ForeColor = Color.Black;
workorder.Font.Size = 8;
workorder.Font.Name = "Arial";

//sets the HeaderStyle
workorder.HeaderStyle.BackColor =
Color.Gold;
workorder.HeaderStyle.ForeColor =
Color.Black;
workorder.HeaderStyle.Font.Name
= "Arial";
workorder.HeaderStyle.Font.Size =
9;

workorder.HeaderStyle.HorizontalAlign =
HorizontalAlign.Center;

//sets alternating style

workorder.AlternatingItemStyle.BackColor =
Color.Silver;

workorder.AlternatingItemStyle.ForeColor =
Color.Black;

//sets the itemstyle

workorder.ItemStyle.HorizontalAlign =
HorizontalAlign.Left;

//create the bound columns
BoundColumn Wonum = new BoundColumn
();

Wonum.HeaderText = "Wonum";
Wonum.DataField = "Wonum";

//add bound columns to datagrid
workorder.Columns.AddAt(0, Wonum);

//bind the DataDrid
workorder.DataSource = ds.Tables
["Workorder"];
workorder.DataBind();

}


}
}
.
Click to expand...
 
G

Guest

Thanks for the suggestion., I dsid figure this out it
required:

this.Controls.Add(MakeWorkorderGrid());

in the PageLoad method.

Thanks,

Dave

-----Original Message-----
Are you sure that you've defined a client-side
<asp:DataGrid /> tag with ID="workorder" (case-sensitive)?

Because you have the "= new DataGrid()" statement in your
page initialization, the code-behind will execute
properly. I'll bet if you remove that statement and just
keep the "protected DataGrid workorder;" part, you'll get
an "object reference not set to an instance of an object"
error, which often means you haven't correctly defined a
client-side component.

Jerry Negrelli
Senior Software Engineer
Data Scientific Corporation

-----Original Message-----
I am trying to dynamically build a DataGrid dynamically.
The code runs OK but the DataGrid is never built and
displayed. Can someone look at the following code and see
if they can determine what I am missing.

Thanks,

Dave

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Configuration;




namespace Type3CTracking
{
/// <summary>
/// Summary description for detailsForm.
/// </summary>
public class workorderDetailsForm :
System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label
workorderLabel;
protected System.Web.UI.WebControls.Label
mrLabel;
protected
System.Web.UI.WebControls.TextBox mrText;
protected System.Web.UI.WebControls.Label
prLabel;
protected
System.Web.UI.WebControls.TextBox prText;
protected System.Web.UI.WebControls.Label
poLabel;
protected
System.Web.UI.WebControls.TextBox poText;
protected
System.Web.UI.WebControls.TextBox workorderText;
protected System.Web.UI.WebControls.Label
wonumLabel;
protected
System.Data.OleDb.OleDbDataAdapter oda;
protected
System.Data.OleDb.OleDbConnection dataConnection;
protected System.Data.OleDb.OleDbCommand
dataCommand;
protected
System.Data.OleDb.OleDbDataReader dataReader;
protected System.Data.DataSet ds = new
DataSet();
public DataGrid workorder = new DataGrid ();


private void Page_Load(object sender,
System.EventArgs e)
{


string workorder = Request
["Workorder"];
workorderText.Text = workorder;

string mr = Request["MR"];
mrText.Text = mr;

string pr = Request["PR"];
prText.Text = pr;

string po = Request["PO"];
poText.Text = po;

CreateDataSource();


}




#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required
by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support -
Click to expand...
do not modify
/// the contents of this method with the
code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new
System.EventHandler(this.Page_Load);

}
#endregion




private void CreateDataSource()
{
string connStr
= "Provider=\"MSDAORA.1\";User ID=DB1;Data
Source=DEMO;Password=XXXXXXXX";
string strSelect = "Select Wonum
from Workorder where Wonum =" + "'" + workorderText.Text
+ "'";

oda = new OleDbDataAdapter
(strSelect, connStr);
ds = new DataSet();

oda.Fill(ds);
ds.Tables[0].TableName
= "Workorder";

//make the DataGrid
workorder = new DataGrid();
workorder.CellPadding = 2;
workorder.CellSpacing = 0;
workorder.Width = 550;
workorder.BorderWidth = 1;
workorder.BorderColor =
Color.Black;
workorder.AutoGenerateColumns =
false;
workorder.ForeColor = Color.Black;
workorder.Font.Size = 8;
workorder.Font.Name = "Arial";

//sets the HeaderStyle
workorder.HeaderStyle.BackColor =
Color.Gold;
workorder.HeaderStyle.ForeColor =
Color.Black;
workorder.HeaderStyle.Font.Name
= "Arial";
workorder.HeaderStyle.Font.Size =
9;

workorder.HeaderStyle.HorizontalAlign =
HorizontalAlign.Center;

//sets alternating style

workorder.AlternatingItemStyle.BackColor =
Color.Silver;

workorder.AlternatingItemStyle.ForeColor =
Color.Black;

//sets the itemstyle

workorder.ItemStyle.HorizontalAlign =
HorizontalAlign.Left;

//create the bound columns
BoundColumn Wonum = new BoundColumn
();

Wonum.HeaderText = "Wonum";
Wonum.DataField = "Wonum";

//add bound columns to datagrid
workorder.Columns.AddAt(0, Wonum);

//bind the DataDrid
workorder.DataSource = ds.Tables
["Workorder"];
workorder.DataBind();

}


}
}
.
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO Error 3
WebForm DropDownList never changes! Do I have to implement Event Handler? 1
Help! Stupid C# Problem 5
The type or namespace name 'UpdateProduct' could not be found (are you missing a 7
I know, I know; but... 13
quick issue 8
DataGrid disappears 4
I'm a newbie...and stuck on System.NullReferenceException error - please help! 3

Top