473,326 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Data grid display - how to restrict columns?

Hello,

I'm new to .net development and I'm trying to develop a simple application
that acts as a front end to a MS Access DB.

The problem I have is that I am creating datasources via the
oleDbDataAdapter generation wizard. The table I'm trying to create a entry
form has 2 string fields and a uniqueID field (which is an AutoNumber field
in the db). When I connect the datasource to a dataGrid I see all the fields
but wish to only see the 2 string fields (ie I dont want to see the uniqueID
number which is maintained by the db automatically). When I use the wizard
to create the oleDbDataAdapter it will not let me create sql
update/delete/inserts etc without the uniqueID.

Can someone please offer any suggestions?

Thanks in advance....
Nov 22 '05 #1
1 1183
Chris,

For that are the datagridcolumnstyle 's

http://msdn.microsoft.com/library/de...classtopic.asp

Although this is a common question, did you know that there are as well
special language groups as example,
microsoft.public.dotnet.languages.vb

They are as well for the other languages.

Cor
"Chris" <Ch***@discussions.microsoft.com>
Hello,

I'm new to .net development and I'm trying to develop a simple application
that acts as a front end to a MS Access DB.

The problem I have is that I am creating datasources via the
oleDbDataAdapter generation wizard. The table I'm trying to create a entry
form has 2 string fields and a uniqueID field (which is an AutoNumber field in the db). When I connect the datasource to a dataGrid I see all the fields but wish to only see the 2 string fields (ie I dont want to see the uniqueID number which is maintained by the db automatically). When I use the wizard to create the oleDbDataAdapter it will not let me create sql
update/delete/inserts etc without the uniqueID.

Can someone please offer any suggestions?

Thanks in advance....

Nov 22 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jordan O'Hare | last post by:
Hello Everyone, I am after some help with the following: I have a windows application that contains a list box and two data grids. All three controls are binded to a dataset that contains...
6
by: Hutty | last post by:
I've looked around and have yet to find anything that would answer my question regarding formating a column in a datagrid. My grid looks like this as far as data" AMHQCON|51300.01|-3147 The...
2
by: pmud | last post by:
Hi, I am exporting data from an EDITABLE DATA GRID EXCEL. But the 1st column in data grid is Edit Column. I want to display all columns in Excel except for the Edit column. The following...
3
by: pmud | last post by:
Hi, I have a web page (asp.net, code:c#). I havean html table with text boxes. Based on the user input , records are displayed in the data grid below it. Now the datagrid has a large no. of...
7
by: What-a-Tool | last post by:
Have an Access table loaded into a DataTable that was created at run time, and am displaying these contents in a data grid. Me.dgGames.DataSource = Me.DsGameInfo.Tables("Games") I would like to...
4
by: Mike | last post by:
I encountered this problem for the first time today while trying to add some columns to a query from a linked DBASEIII file. The new columns that I added on the design grid do not show up on the...
2
by: schaapiee | last post by:
Is there a way to define how long the data columns are, display wise on the Form? Whether I am using a boolean field (checkbox) or a string field (text url) each displays with the same size. I...
9
by: trint | last post by:
How can I retrieve all of the data from a datagridview? Any help is appreciated. Thanks, Trint
4
by: =?Utf-8?B?UmludSBHb3BhbGFrcmlzaG5hIFBpbGxhaQ==?= | last post by:
Hi All, I have an application that fetch data thru a store proc and display in a datagrid, but after successful execution of proc the data grid is not visible.Please go thru the following code...
3
by: veenna | last post by:
How can i refresh datagrid in vb.net. I want to display color in one cell in grid but when it loads first time it is working here is my code Public Class Dialog_Colorazione Const YEAR_START...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.