Re: Yet more data grid issues - C# Discussion Boards

Getting all the table names from 'mdb' file...

Pranoti14-Jun-02 4:09

14-Jun-02 4:09

Hello Friends,

I am using following code to get the information about the table in access database :

string con = "Provider=Microsoft.JET.OLEDB.4.0;data source=C:\\Documents and Settings\\Kalpesh\\My Documents\\trialdb.mdb";
String query = "Select * from Emp";//'Emp' is tablename

DataTable accessDataTable = new DataTable();

OleDbConnection dbConn = new OleDbConnection(con);
conn.Open();

OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(query, dbConn);
adapter.Fill(accessDataTable);

foreach(DataColumn dataColumn in accessDataTable.Columns)
{
columnHeaderValues.Add(dataColumn.Caption);
}

Actually, I want to get names of all tables present in access database.So, that I can get the information
of tables dynamically.

Anyone knows the solution??

Thanks in advance.

Pranoti

Re: Getting all the table names from 'mdb' file...

leppie14-Jun-02 5:56

leppie

14-Jun-02 5:56

Have a look on MSDN for SQLTables.

Quote:

"Summary

SQLTables returns the list of table, catalog, or schema names, and table types, stored in a specific data source. The driver returns the information as a result set.

"

Re: Getting all the table names from 'mdb' file...

paulb16-Jun-02 14:11

paulb

16-Jun-02 14:11

What you want is the tables schema rowset...

<br />
OleDbConnection conn = new OleDbConnection();<br />
<br />
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; ...etc. ";<br />
conn.Open();<br />
<br />
// Do not get linked or system tables.<br />
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,<br />
 new object[] {null, null, null, "TABLE"});<br />
<br />
foreach (DataRow table in schemaTable.Rows)<br />
{<br />
 // table["TABLE_NAME"].ToString() is your table name<br />
}<br />
conn.Close();<br />

Re: Getting all the table names from 'mdb' file...

Pranoti16-Jun-02 23:39

Pranoti

16-Jun-02 23:39

Thank you very much for your help.

'OleDbSchemaGuid.Tables' contains both tables as well as views of the database, but with the way suggested by you we can get only tables.
I've tried for getting View, with the second argument of GetOleDbSchemaTable like this...new object[] {null, null, null, "VIEW"}. It is working perfectly.

But for that I'll have to repeat the call twice, onc for table and another one for view. Is there any way to get both tables as well views in one call.

Thanks.

Pranoti

Yet more data grid issues

///Ansch13-Jun-02 14:44

///Ansch

13-Jun-02 14:44

Hi, I've got a bit of a problem with using a data grid in a window application. The application crash if I try to double click on the resize row height cursor. ie. When my cursor is in between two row headers and the cursor becomes the resize cursor. Usually, when you double click in between columns, it automatically resize the columns. However, when I try to do the same with the rows, it crashes with this error message: "Fatal system error has occured. Index was out of range. Must be non-negitive and less than the size of the collection. Parameter name: startIndex, mscorlib"

Is there anyway I can disable the feature of allowing the user to resize the rows??

Thanks in advance.

Re: Yet more data grid issues

Rocky Moore13-Jun-02 18:49

Rocky Moore

13-Jun-02 18:49

Have you tried overriding the OnResize?

Rocky Moore

Re: Yet more data grid issues

leppie13-Jun-02 23:46

leppie

13-Jun-02 23:46

Hi
OnResize would be related to the Datagrid control itself.

Rather try overriding OnPreferredRowHeightChanged in the DataGridTableStyle class. Like:

<br />
   myGrid.Font = new System.Drawing.Font<br />
      ("Microsoft Sans Serif",<br />
      15, System.Drawing.FontStyle.Regular);<br />
   myGrid.PreferredRowHeight = myGrid.Font.Height;<br />

Re: Yet more data grid issues

Domenic Denicola16-Jun-02 8:35

Domenic Denicola

16-Jun-02 8:35

Wow, happens on my DataGrids too! Must be a bug in the MS code... no? In any case, exceptions should not reach the user like that!

-Domenic Denicola- [CPUA 0x1337]
MadHamster Creations

"I was born human. But this was an accident of fate - a condition merely of time and place. I believe it's something we have the power to change..."

Another DataGrid question

J. Ehrnström13-Jun-02 12:33

J. Ehrnström

13-Jun-02 12:33

I have a problem getting my column headers correctly aligned in my datagrid. I've got a total of six columns and in most of them the column header text is right next to the column border with no margin/padding at all. In a couple of the columns the alignment seems to work though, but I haven't been able to any difference that should matter.

Here's a small portion of the code, taken from the InitializeComponent method:

this.dataGridTextBoxColumn5.Alignment = System.Windows.Forms.HorizontalAlignment.Right;
this.dataGridWaterColumn.Format = "p1";
this.dataGridWaterColumn.FormatInfo = null;
this.dataGridWaterColumn.HeaderText = "Percent";
this.dataGridWaterColumn.MappingName = "Percent";
this.dataGridWaterColumn.Width = 80;

The data is correctly aligned, it's just the header text that is misaligned. How come? The problem is the same whether I choose left, right or center alignment.

Flicker Free Listview

Brandon Parker13-Jun-02 7:13

Brandon Parker

13-Jun-02 7:13

Can someone help me with a flicker free listview. I have tried setting the control styles but that doesnt seem to work. And when i set the control style UserPaint to true only the columns of the listview are painted. I guess this is because we are then responsible for all the painting. However, I dont want to go through all of that. Does someone know of another way to do this.

Re: Flicker Free Listview

leppie13-Jun-02 21:06

leppie

13-Jun-02 21:06

I had a similar problem a while back. Make sure that:

1. the control dont get invalidated after adding each item

2. you are not adding new items using AddRange()
within a loop.

Hope this helps

Re: Flicker Free Listview

Brandon Parker14-Jun-02 4:05

Brandon Parker

14-Jun-02 4:05

So should i be using the style controls?

Free Windows Form Designer

Gavin Jerman13-Jun-02 6:19

Gavin Jerman

13-Jun-02 6:19

I can't afford a copy of Visual Studio .NET for home use, so I'm trying to learn C# and .NET the cheap (hard) way i.e. the .NET SDK, a text editor and the command prompt. What I'd like to write are some Windows Forms applications, but I can't stand the thought of having to write the form layout by hand. Does anyone know of a free form designer that I can download and use with C#?

Gavin

Re: Free Windows Form Designer

leppie13-Jun-02 9:53

leppie

13-Jun-02 9:53

Now if someone would just write a flash to usercontrol converter that would be nice Smile | :)

or even better, the other way around, so we can get rid of those lame default web controls Smile | :)

Re: Free Windows Form Designer

Rickard Andersson²⁰13-Jun-02 12:11

Rickard Andersson²⁰

13-Jun-02 12:11

The Visual Studio .NET Academic version is not so much expensive (did I spell it right?).
About $120.

I've bought that!

Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C# and C++!

Using context menu item in main menu?

Martin Haesemeyer13-Jun-02 4:48

Martin Haesemeyer

13-Jun-02 4:48

Hello!
Is it possible to reuse context menu items in the main menu(maybe from the designer,too) Confused | :confused:

? Or do I have to declare two menu items for duplicate commands and enable/disable them seperately for the same reasons WTF | :WTF:

(because something like CloneMenu would only clone the current property values me thinks)?
Cheers
and TIA
Martin

"Situation normal - all fu***d up"
Illuminatus!

C# Controls - 3 questions

Maciej Pirog13-Jun-02 4:02

Maciej Pirog

13-Jun-02 4:02

Hi there! I've got 3 questions about programming C# controls:

1. How can I bind my own property to one of the categories that are displayed in the Properties window (like 'Behaviour' ora 'Apperance')? Can I make my own cathegory? Confused | :confused:

2. I would like the control to know, if it's in a Design mode or in a running app. User has to add all data to my control dynamicly and I want control to display some example while being in Design mode (sth. like TreeView in Win32 API in Resource Editor). How can I implement thing like that? Confused | :confused:

3. How can I change the control's icon that is displayed in the Toolbox? Confused | :confused:

Please! Help me!

MP
Maciej Pirog

Re: C# Controls - 3 questions

Russell Morris13-Jun-02 4:40

Russell Morris

13-Jun-02 4:40

Maciej Pirog wrote:
1. How can I bind my own property to one of the categories that are displayed in the Properties window (like 'Behaviour' ora 'Apperance')? Can I make my own cathegory?

Use the 'CategoryAttribute' on one of your control's properties

Maciej Pirog wrote:
2. I would like the control to know, if it's in a Design mode

Take a look at the Control.DesignMode property

Maciej Pirog wrote:
How can I change the control's icon that is displayed in the Toolbox?

Embed a bitmap in your assembly named the same as your control's fully qualified typename (plus .bmp). So if your control's full name is MyNamespace.MyControl, 'embed as resources' a 16x16 bitmap in your project named 'MyNamespace.MyControl.bmp'. Recompile, and studio should use that bitmap on the toolbox.

Check out the code for PropertyTree for an example of embedding Toolbox bitmaps in a control assembly.

--
Russell Morris

"WOW! Chocolate - half price!" - Homer Simpson, while in the land of chocolate.

Re: C# Controls - 3 questions

Maciej Pirog13-Jun-02 8:17

Maciej Pirog

13-Jun-02 8:17

Thanks! Tht's what I needed! Smile | :)

MP
Maciej Pirog

web forms sending parameters

sharon13-Jun-02 2:25

sharon

13-Jun-02 2:25

I have a webForm,Iwant that when the user click a button the page will change and I want to send this new page parameter (int id , string or anything else),
how can I do it? I move to the next page by:
Response.Redirect(...)

thank you very much, sharon

Re: web forms sending parameters

Rama Krishna Vavilala13-Jun-02 7:05

Rama Krishna Vavilala

13-Jun-02 7:05

Look at the following link from MSDN

Clickety

Object Role Modeling

gicio13-Jun-02 1:07

gicio

13-Jun-02 1:07

I have seen the newest .NET show on the web recently and it introduced the ORM (Object Role Modeling). I think that this is a very good approach in order to build Object Orientated Models. Is there some kind of possibility to generate C# code stubs out of the ORMs yet. I think that this is the very missing stone in the whole idea. If we think further the information stored within the ORM would allow generating some kind of a Ralational-Object Mapper code including simple SQL. So if you changed your ER Model or add some new “Facts” you would just generate your ALTER-nation statements for the DB and generate new C# classes including the update of the Relational - Object mapping. Don’t you thing that this is actually the future of how applications will be created?

So long

Pawel

Re: Object Role Modeling

gicio14-Jun-02 3:10

gicio

14-Jun-02 3:10

is it something like ObjectSpaces?

Pawel

Customizing DataGrid

J. Ehrnström12-Jun-02 16:45

J. Ehrnström

12-Jun-02 16:45

I have created a DataGrid and bound it to a DataSet thus populating it with my data. I have also managed to format the columns the way I want them.
Now I just wonder if there is any way I could get rid of the first column, the one before my DataSet data. I don't know what it is called, but it is where the selection arrow is displayed, and also the plus sign if I have a relation in my DataSet.

Any advice would be much appreciated. I have been looking for a method or property in the DataGrid class to disable this feature, but I have not been successful so far.

Re: Customizing DataGrid

Rocky Moore12-Jun-02 19:49

Rocky Moore

12-Jun-02 19:49

Have you tried setting the RowHeadersVisible = false ?

If you would like to get rid of the row with the '*' on it where it adds new rows, you can use:

dataGrid1.DataSource = myDataSet.theTable.DefaultView;
((DataView)dataGrid1.DataSource).AllowNew = false;

Where dataGrid = your grid, myDataSet = your dataset, theTable = the table you wish to show.

Oh yeah, if you want to get rid of the blank area at the top of the grid that would be the "CaptionVisible" property on the Grid, just set it false.

Rocky Moore

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.