J
Joe Bloggs
I am trying display the contents of a table in a web page, select
certain rows from that table and then display the fields that I have
selected (now table columns) as text in a Label object. Amazingly I have
managed to display the table - no problem, I can select rows - no
problem, BUT I can't work out how to display more than one of the fields
(now columns in the table in the web page). I can display one field OK,
but not more than one field and its driving me bonkers. All of my
confusion is related to how you reference a DataKeyField in a DataGrid.
The two fields that I am selecting are ID and a Customer taken from the
SQL
SELECT Field_ID as ID, Field_Customer as Customer FROM Table_Customer
I've worked out that the DataGrid DataKeys property (if it is a
property) controls which field is passed to the the instance of the
DataGrid so
<asp:datagrid id="DemoGrid" runat="server" DataKeyField="customer"
Font-Size="XX-Small">
and then
gridSelections.AppendFormat("{0} ",
DemoGrid.DataKeys[DemoGridItem.ItemIndex].ToString());
will result in the customer field being in the result
and if I change the DataKeyField to id then
<asp:datagrid id="DemoGrid" runat="server" DataKeyField="id"
Font-Size="XX-Small">
will result the id field being in the result of
gridSelections.AppendFormat("{0} ",
DemoGrid.DataKeys[DemoGridItem.ItemIndex].ToString());
Thing is I want both customer and id to be in the result.
There that is my problem (well the real problem is lack of knowledge of
DataGrids and C# in general - but thats my problem).
I hope the question makes sense and if I have offended anyone with the
question I apologize but suggest you try to take it easy.
Here's the complete c# code behind the scene and also the HTML code of
the web form.
Other than begging and pleading HELP , I would be very grateful if
someone could shine light upon the darkness of my ignorance.
WebForm1.aspx.cs
================
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.SqlClient;
using System.Text;
namespace WebApplication1
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DemoGrid;
protected System.Web.UI.WebControls.Label ResultsInfo;
protected System.Web.UI.WebControls.Button GetSelections;
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
//Create a SqlConnection object.
//Modify the connection string as necessary for your environment.
SqlConnection cn = new
SqlConnection("Server=MyServer;database=MyDatabase;UID=sa;PWD=MyPassword
");
SqlCommand cmd = new SqlCommand("SELECT Field_ID as ID, Field_Customer
as Customer FROM Table_Customer",cn);
cn.Open();
SqlDataReader reader = cmd.ExecuteReader();
DemoGrid.DataSource = reader;
DataBind();
reader.Close();
cn.Close();
}
}
#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.DemoGrid.SelectedIndexChanged += new
System.EventHandler(this.DemoGrid_SelectedIndexChanged);
this.GetSelections.Click += new
System.EventHandler(this.GetSelections_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void GetSelections_Click(object sender, System.EventArgs e)
{
int rowCount = 0;
StringBuilder gridSelections = new StringBuilder();
//Loop through each DataGridItem, and determine which CheckBox controls
//have been selected.
foreach(DataGridItem DemoGridItem in DemoGrid.Items)
{
CheckBox myCheckbox = (CheckBox)DemoGridItem.Cells[0].Controls[1];
if(myCheckbox.Checked == true)
{
rowCount++;
gridSelections.AppendFormat("{0} ",
DemoGrid.DataKeys[DemoGridItem.ItemIndex].ToString());
ListBox myListBox = (ListBox)DemoGridItem.Cells[1].Controls[1];
gridSelections.AppendFormat( " " +
myListBox.SelectedItem.Text.ToString()+ " <br>");
}
} gridSelections.Append("<hr>");
gridSelections.AppendFormat("Total number selected is: {0}",
rowCount.ToString());
ResultsInfo.Text = gridSelections.ToString();
}
private void DemoGrid_SelectedIndexChanged(object sender,
System.EventArgs e)
{
}
public SqlDataReader GetReportNames ()
{
//Polulates the list box for report names
SqlConnection conn = new SqlConnection("server=MyServer; uid=sa;
pwd=MyPassword; Database=MyDatabase");
String sqlConnection = "select Report, Name from TableReports";
SqlCommand sqlCommand = new SqlCommand(sqlConnection, conn);
conn.Open();
SqlDataReader sqlDataReader;
sqlDataReader = sqlCommand.ExecuteReader();
return sqlDataReader;
sqlDataReader.Close();
conn.Close();
}
}
}
HTML WebForm
============
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs"
AutoEventWireup="false" Inherits="WebApplication1.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="_JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5"
name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:label id="ResultsInfo" style="Z-INDEX: 103; LEFT: 472px;
POSITION: absolute; TOP: 112px"
runat="server" Width="304px" Height="112px"></asp:label>
<asp:datagrid id="DemoGrid" runat="server" DataKeyField="customer"
Font-Size="XX-Small">
<Columns>
<asp:TemplateColumn HeaderText="Run">
<ItemTemplate>
<asp:CheckBox ID="myCheckbox" Runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Report">
<ItemTemplate>
<asp:ListBox ID="myListbox" Rows="1" Width="150px"
SelectionMode="Single" Runat="server"
DataSource = "<%# GetReportNames() %>"
DataTextField="ReportName" DataValueField="Report" />
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid><asp:button id="GetSelections" style="Z-INDEX: 102;
LEFT: 472px; POSITION: absolute; TOP: 24px"
runat="server" Text="Build Request"
Width="152px"></asp:button></form>
</body>
</HTML>
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
certain rows from that table and then display the fields that I have
selected (now table columns) as text in a Label object. Amazingly I have
managed to display the table - no problem, I can select rows - no
problem, BUT I can't work out how to display more than one of the fields
(now columns in the table in the web page). I can display one field OK,
but not more than one field and its driving me bonkers. All of my
confusion is related to how you reference a DataKeyField in a DataGrid.
The two fields that I am selecting are ID and a Customer taken from the
SQL
SELECT Field_ID as ID, Field_Customer as Customer FROM Table_Customer
I've worked out that the DataGrid DataKeys property (if it is a
property) controls which field is passed to the the instance of the
DataGrid so
<asp:datagrid id="DemoGrid" runat="server" DataKeyField="customer"
Font-Size="XX-Small">
and then
gridSelections.AppendFormat("{0} ",
DemoGrid.DataKeys[DemoGridItem.ItemIndex].ToString());
will result in the customer field being in the result
and if I change the DataKeyField to id then
<asp:datagrid id="DemoGrid" runat="server" DataKeyField="id"
Font-Size="XX-Small">
will result the id field being in the result of
gridSelections.AppendFormat("{0} ",
DemoGrid.DataKeys[DemoGridItem.ItemIndex].ToString());
Thing is I want both customer and id to be in the result.
There that is my problem (well the real problem is lack of knowledge of
DataGrids and C# in general - but thats my problem).
I hope the question makes sense and if I have offended anyone with the
question I apologize but suggest you try to take it easy.
Here's the complete c# code behind the scene and also the HTML code of
the web form.
Other than begging and pleading HELP , I would be very grateful if
someone could shine light upon the darkness of my ignorance.
WebForm1.aspx.cs
================
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.SqlClient;
using System.Text;
namespace WebApplication1
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DemoGrid;
protected System.Web.UI.WebControls.Label ResultsInfo;
protected System.Web.UI.WebControls.Button GetSelections;
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
//Create a SqlConnection object.
//Modify the connection string as necessary for your environment.
SqlConnection cn = new
SqlConnection("Server=MyServer;database=MyDatabase;UID=sa;PWD=MyPassword
");
SqlCommand cmd = new SqlCommand("SELECT Field_ID as ID, Field_Customer
as Customer FROM Table_Customer",cn);
cn.Open();
SqlDataReader reader = cmd.ExecuteReader();
DemoGrid.DataSource = reader;
DataBind();
reader.Close();
cn.Close();
}
}
#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.DemoGrid.SelectedIndexChanged += new
System.EventHandler(this.DemoGrid_SelectedIndexChanged);
this.GetSelections.Click += new
System.EventHandler(this.GetSelections_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void GetSelections_Click(object sender, System.EventArgs e)
{
int rowCount = 0;
StringBuilder gridSelections = new StringBuilder();
//Loop through each DataGridItem, and determine which CheckBox controls
//have been selected.
foreach(DataGridItem DemoGridItem in DemoGrid.Items)
{
CheckBox myCheckbox = (CheckBox)DemoGridItem.Cells[0].Controls[1];
if(myCheckbox.Checked == true)
{
rowCount++;
gridSelections.AppendFormat("{0} ",
DemoGrid.DataKeys[DemoGridItem.ItemIndex].ToString());
ListBox myListBox = (ListBox)DemoGridItem.Cells[1].Controls[1];
gridSelections.AppendFormat( " " +
myListBox.SelectedItem.Text.ToString()+ " <br>");
}
} gridSelections.Append("<hr>");
gridSelections.AppendFormat("Total number selected is: {0}",
rowCount.ToString());
ResultsInfo.Text = gridSelections.ToString();
}
private void DemoGrid_SelectedIndexChanged(object sender,
System.EventArgs e)
{
}
public SqlDataReader GetReportNames ()
{
//Polulates the list box for report names
SqlConnection conn = new SqlConnection("server=MyServer; uid=sa;
pwd=MyPassword; Database=MyDatabase");
String sqlConnection = "select Report, Name from TableReports";
SqlCommand sqlCommand = new SqlCommand(sqlConnection, conn);
conn.Open();
SqlDataReader sqlDataReader;
sqlDataReader = sqlCommand.ExecuteReader();
return sqlDataReader;
sqlDataReader.Close();
conn.Close();
}
}
}
HTML WebForm
============
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs"
AutoEventWireup="false" Inherits="WebApplication1.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="_JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5"
name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:label id="ResultsInfo" style="Z-INDEX: 103; LEFT: 472px;
POSITION: absolute; TOP: 112px"
runat="server" Width="304px" Height="112px"></asp:label>
<asp:datagrid id="DemoGrid" runat="server" DataKeyField="customer"
Font-Size="XX-Small">
<Columns>
<asp:TemplateColumn HeaderText="Run">
<ItemTemplate>
<asp:CheckBox ID="myCheckbox" Runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Report">
<ItemTemplate>
<asp:ListBox ID="myListbox" Rows="1" Width="150px"
SelectionMode="Single" Runat="server"
DataSource = "<%# GetReportNames() %>"
DataTextField="ReportName" DataValueField="Report" />
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid><asp:button id="GetSelections" style="Z-INDEX: 102;
LEFT: 472px; POSITION: absolute; TOP: 24px"
runat="server" Text="Build Request"
Width="152px"></asp:button></form>
</body>
</HTML>
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!