Datagrid code not working!!

Angelina

Hi,

Im trying to format my datagrid via some code to make one
column readonly while the other can be edited.
I also tried to change the column header. The problem is
that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

Nov 22 '05 #1

Subscribe Post Reply

1551

Rob Oldfield

I'm no expert, but I think the mapping name for the grid needs to be same as
the table that the data is coming from. Try changing to...

TSEquip.MappingName = "Equipment_Details"
--
For real reply address, lose the cash
www.realuk.co.uk
"Angelina" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

Hi,

Im trying to format my datagrid via some code to make one
column readonly while the other can be edited.
I also tried to change the column header. The problem is
that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

Nov 22 '05 #2

Rob Oldfield

Hi,

Im trying to format my datagrid via some code to make one
column readonly while the other can be edited.
I also tried to change the column header. The problem is
that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

Nov 22 '05 #3

Angelina

Hi Rob,

Thx for your input. I just tried this but i still cant
see any of the formatting i am coding in the datagrid at
runtime!! :o(

Does anyone have any other suggestions?

-----Original Message-----
I'm no expert, but I think the mapping name for the grid needs to be same asthe table that the data is coming from. Try changing to...
TSEquip.MappingName = "Equipment_Details"
--
For real reply address, lose the cash
www.realuk.co.uk
"Angelina" <an*******@discussions.microsoft.com> wrote in messagenews:1d****************************@phx.gbl...
Hi,

Im trying to format my datagrid via some code to make one column readonly while the other can be edited.
I also tried to change the column header. The problem is that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

.

Nov 22 '05 #4

Angelina

Hi Rob,

Thx for your input. I just tried this but i still cant
see any of the formatting i am coding in the datagrid at
runtime!! :o(

Does anyone have any other suggestions?

-----Original Message-----
I'm no expert, but I think the mapping name for the grid needs to be same asthe table that the data is coming from. Try changing to...
TSEquip.MappingName = "Equipment_Details"
--
For real reply address, lose the cash
www.realuk.co.uk
"Angelina" <an*******@discussions.microsoft.com> wrote in messagenews:1d****************************@phx.gbl...
Hi,

Im trying to format my datagrid via some code to make one column readonly while the other can be edited.
I also tried to change the column header. The problem is that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

.

Nov 22 '05 #5

Tim Anderson

"Angelina" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

Here is my code. Can anyone please offer me some help? da.Fill(ds)
When you fill the dataset give it a tablename:

da.Fill(ds,"mytable")
TSEquip.MappingName = "Equipment"

Use the name here:
TsEquip.MappingName="mytable"

Tim
Investigating dotnet: http://www.itwriting.com/dotnet1.php

Nov 22 '05 #6

Tim Anderson

"Angelina" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

Here is my code. Can anyone please offer me some help? da.Fill(ds)
When you fill the dataset give it a tablename:

da.Fill(ds,"mytable")
TSEquip.MappingName = "Equipment"

Use the name here:
TsEquip.MappingName="mytable"

Tim
Investigating dotnet: http://www.itwriting.com/dotnet1.php

Nov 22 '05 #7

Similar topics

Datagrid code not working!!

by: Angelina | last post by:

Hi, Im trying to format my datagrid via some code to make one column readonly while the other can be edited. I also tried to change the column header. The problem is that the code does not seem...

.NET Framework

Paging in a datagrid not working

by: J. Muenchbourg | last post by:

I'm trying to use paging in a datagrid, but I can't get past the "cannot compute Count for a data source that does not implement ICollection" application error, as it does not point to a line in...

.NET Framework

hiding columns in datagrid not working

by: klynn | last post by:

I queried a series of fields from a database and passed into a datatable. Then bound this to a datagrid. I need to hide 2 of the colums. This doesnt seem to be working the standard way. (with...

ASP.NET

insert in DataGrid not working

by: tshad | last post by:

I can't seem to get insert into a DataGrid to work. I am using an example from the net and made changes to work on my computer. The grid comes up fine. The edit boxes in the footer are there. ...

ASP.NET

In-place Updating in Datagrid not working

by: A P | last post by:

Hi! I have created a sample datagrid that can update data on a database. Please help me solve the problem, I have attached both aspx and code behind (aspx.vb): ______________________ ...

ASP.NET

Datareader binding to datagrid not working

by: tshad | last post by:

I am using VS 2003 and trying to build a standalone application. I have been writing all my asp.net work using DW and am just now trying to build a application that will read some of the tables I...

Visual Basic .NET

ASP.Net Datagrid Not Working Properly

by: mh | last post by:

I have a datagrid on an aspx page that correctly shows my data using the following code: <form id="Form1" method="post" runat="server"> <asp:datagrid id="DataGrid1" style="Z-INDEX: 101; LEFT:...

C# / C Sharp

code working in internet explorer but not in mozilla

by: suneel271 | last post by:

code working in internet explorer but not in mozilla and iam getting erroe like window.event has no properties and here is the code <%@ page language="java" contentType="text/html;...

Javascript

asp code working in firefox and ie7 but not working in ie6

by: kepskp | last post by:

i just write code for select option in combo box which i m select but when i press search button and then click on back button then there in no option selected. and that same code working in ie7 and...

Javascript

linkbutton inside datagrid not working C#

by: daJunkCollector | last post by:

What I am doing here should be obvious. I have a datagrid that displays data properly. I want to create a linkbutton within each row of the datagrid that toggles a label control in the same row...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice