Re: problem in binded columns to DataGridView - C# Discussion Boards

problem in binded columns to DataGridView

Jassim Rahma29-Aug-08 22:16

29-Aug-08 22:16

I binding the following to a datagrid:

private void get_all_vehicles()

{

    dataVehicles.DataBindings.Clear();



    data_table = new DataTable();

    sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=rent_a_car_company;integrated security=true");

    // sql_connection = new SqlConnection(public_var.sql_connection);

    sql_command = new SqlCommand("sp_populate_all_vehicles", sql_connection);

    sql_command.CommandType = CommandType.StoredProcedure;

    sql_adapter = new SqlDataAdapter(sql_command);

    sql_adapter.Fill(data_table);

    dataVehicles.DataSource = data_table;



    dataVehicles.Columns["vehicle_id"].HeaderText = "ID";

    dataVehicles.Columns["vehicle_id"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    dataVehicles.Columns["vehicle_id"].Width = 160;

    dataVehicles.Columns["vehicle_id"].Visible = false;



    dataVehicles.Columns["vehicle_photo"].HeaderText = "Photo";

    dataVehicles.Columns["vehicle_photo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    dataVehicles.Columns["vehicle_photo"].Width = 160;

    // dataVehicles.Columns["vehicle_photo"].DataGridView.



    dataVehicles.Columns["vehicle_make"].HeaderText = "Vehicle";

    dataVehicles.Columns["vehicle_make"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    dataVehicles.Columns["vehicle_make"].Width = 160;





    dataVehicles.Columns["vehicle_number"].HeaderText = "Number#";

    dataVehicles.Columns["vehicle_number"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;

    dataVehicles.Columns["vehicle_number"].Width = 200;



    dataVehicles.Columns["category_name"].HeaderText = "Category";

    dataVehicles.Columns["category_name"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;

    dataVehicles.Columns["category_name"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;

    dataVehicles.Columns["category_name"].Width = 120;



    dataVehicles.Columns["vehicle_shift"].HeaderText = "Shift";

    dataVehicles.Columns["vehicle_shift"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;

    dataVehicles.Columns["vehicle_shift"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;

    dataVehicles.Columns["vehicle_shift"].Width = 120;



    dataVehicles.Columns["vehicle_rent_daily"].HeaderText = "Daily Rent";

    dataVehicles.Columns["vehicle_rent_daily"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;

    dataVehicles.Columns["vehicle_rent_daily"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;

    dataVehicles.Columns["vehicle_rent_daily"].DefaultCellStyle.Format = "#,###,###,##0.000";

    dataVehicles.Columns["vehicle_rent_daily"].Width = 120;



    sql_command.Dispose();

    sql_adapter.Dispose();

    sql_connection.Close();

}

also I am binding the following if the user clicked the vehicles out button:

private void get_vehicles_out()

{

    dataVehicles.DataBindings.Clear();



    data_table = new DataTable();

    sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=rent_a_car_company;integrated security=true");

    // sql_connection = new SqlConnection(public_var.sql_connection);

    sql_command = new SqlCommand("sp_populate_vehicles_out", sql_connection);

    sql_command.CommandType = CommandType.StoredProcedure;

    sql_adapter = new SqlDataAdapter(sql_command);

    sql_adapter.Fill(data_table);

    dataVehicles.DataSource = data_table;



    dataVehicles.Columns["vehicle_id"].HeaderText = "ID";

    dataVehicles.Columns["vehicle_id"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    dataVehicles.Columns["vehicle_id"].Width = 160;

    dataVehicles.Columns["vehicle_id"].Visible = false;



    dataVehicles.Columns["vehicle_photo"].HeaderText = "Photo";

    dataVehicles.Columns["vehicle_photo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    dataVehicles.Columns["vehicle_photo"].Width = 160;

    dataVehicles.Columns["vehicle_photo"].Visible = false;



    dataVehicles.Columns["out_category"].HeaderText = "Status";

    dataVehicles.Columns["out_category"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    dataVehicles.Columns["out_category"].Width = 160;



    dataVehicles.Columns["vehicle_make"].HeaderText = "Vehicle";

    dataVehicles.Columns["vehicle_make"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    dataVehicles.Columns["vehicle_make"].Width = 160;



    dataVehicles.Columns["vehicle_make"].HeaderText = "Vehicle";

    dataVehicles.Columns["vehicle_make"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    dataVehicles.Columns["vehicle_make"].Width = 160;



    dataVehicles.Columns["vehicle_number"].HeaderText = "Number#";

    dataVehicles.Columns["vehicle_number"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;

    dataVehicles.Columns["vehicle_number"].Width = 200;



    dataVehicles.Columns["category_name"].HeaderText = "Category";

    dataVehicles.Columns["category_name"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;

    dataVehicles.Columns["category_name"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;

    dataVehicles.Columns["category_name"].Width = 120;

    dataVehicles.Columns["category_name"].Visible = false;



    dataVehicles.Columns["vehicle_shift"].HeaderText = "Shift";

    dataVehicles.Columns["vehicle_shift"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;

    dataVehicles.Columns["vehicle_shift"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;

    dataVehicles.Columns["vehicle_shift"].Width = 120;

    // dataVehicles.Columns["category_name"].Visible = false;



    dataVehicles.Columns["vehicle_rent_daily"].HeaderText = "Daily Rent";

    dataVehicles.Columns["vehicle_rent_daily"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;

    dataVehicles.Columns["vehicle_rent_daily"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;

    dataVehicles.Columns["vehicle_rent_daily"].DefaultCellStyle.Format = "#,###,###,##0.000";

    dataVehicles.Columns["vehicle_rent_daily"].Width = 120;

    dataVehicles.Columns["vehicle_rent_daily"].Visible = false;



    sql_command.Dispose();

    sql_adapter.Dispose();

    sql_connection.Close();

}

and if you noticed, the only differnce is the column out_category which i am adding in the second code.

Now, the problem is: when the user clicks on the button displaying the first list then everything is fine but when the user clicks on the button invoking the second code it will just add the out_category column to the end which means it using the first codeand adding the out_category column when it should place the out_category column before the vehicle_make column.

so where is the problem?

Re: problem in binded columns to DataGridView

leppie29-Aug-08 22:51

leppie

29-Aug-08 22:51

You need to clear the columns too I think.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: problem in binded columns to DataGridView

Jassim Rahma29-Aug-08 22:53

Jassim Rahma

29-Aug-08 22:53

well, i only tried clearing the columns after facing this problem but it didn't solve it.

Re: problem in binded columns to DataGridView

Wendelius30-Aug-08 4:57

Wendelius

30-Aug-08 4:57

If I'm reading this correctly, you don't add columns on-the-fly, but use predefined columns and modify their properties (unless binding creates them). If that's the case, change the column order when adding columns to DataGridViewColumnCollection.

If the columns are added automatically by binding, change the order of columns in sp returning the result set or modify the order after population.

Hope this helps,

Mika

Re: problem in binded columns to DataGridView

Jassim Rahma30-Aug-08 8:22

Jassim Rahma

30-Aug-08 8:22

i hav already did that before posting this question.. here is my stored proceedure:

SELECT     vehicles.vehicle_id, vehicles.vehicle_photo,
out_category = CASE vehicles.out_category
WHEN 'S' THEN 'STAFF'
WHEN 'C' THEN 'CUSTOMER'
WHEN 'R' THEN 'SERVICE'
WHEN 'W' THEN 'WORKSHOP'
END
, vehicle_makes.vehicle_make + ' '  + vehicle_brands.vehicle_brand + ' ' + LTRIM(STR(vehicles.vehicle_year)) AS vehicle_make, registration_types.registration_type + ' ' + vehicles.vehicle_registration_number AS vehicle_number, vehicle_category.category_name, 
                      vehicle_shifts.vehicle_shift, vehicles.vehicle_rent_daily
FROM         vehicles INNER JOIN
                      branches ON vehicles.branch_id = branches.branch_id INNER JOIN
                      vehicle_category ON vehicles.vehicle_category = vehicle_category.category_id INNER JOIN
                      vehicle_makes ON vehicles.vehicle_make = vehicle_makes.vehicle_make_id INNER JOIN
                      vehicle_brands ON vehicles.vehicle_brand = vehicle_brands.vehicle_brand_id INNER JOIN
                      registration_types ON vehicles.vehicle_registration_type = registration_types.registration_type_id INNER JOIN
                      vehicle_shifts ON vehicles.vehicle_shift = vehicle_shifts.vehicle_shift_id
WHERE vehicles.is_vehicle_out = 'True'

Re: problem in binded columns to DataGridView

Wendelius30-Aug-08 8:31

Wendelius

30-Aug-08 8:31

Ok, but most important: Are the columns already defined for dataVehicles before setting the DataSource?

Re: problem in binded columns to DataGridView

Jassim Rahma30-Aug-08 8:36

Jassim Rahma

30-Aug-08 8:36

no.. it's auto defined

i am using the auto defined columns for long time but this is the first time i face such a problem.

Re: problem in binded columns to DataGridView

Wendelius30-Aug-08 8:48

Wendelius

30-Aug-08 8:48

Before setting the DataSource for dataVehicles, use the debugger and check that the data_table is holding columns in right order (the order you have defined in sp), just in case that they arrive correctly.

If that doesn't explain this, add following lines before setting datasource to test if any of them help:

...
sql_adapter.Fill(data_table);            
dataVehicles.DataSource = null;
dataVehicles.Columns.Clear();
dataVehicles.ResetBindings();
dataVehicles.DataSource = data_table;
...

Re: problem in binded columns to DataGridView

Jassim Rahma30-Aug-08 13:17

Jassim Rahma

30-Aug-08 13:17

checking the data_table shows that it's binding columns in the incorrect order agaist the order in the sp.

so i tried the code you mentioned and it worked fine.

thank you

Re: problem in binded columns to DataGridView

Wendelius30-Aug-08 21:12

Wendelius

30-Aug-08 21:12

You're welcome Smile | :)

Repository in sharepoint

manju#12329-Aug-08 19:23

manju#123

29-Aug-08 19:23

Hi all..
Can anyone brief me with some examples to crawl repository from sharepoint server..
As i am new to sharepoint and as well as c#...I dont have idea regarding what exactly is Repository in sharepoint server...can anyone provide me site.....

thank you...in advance..

manju

Hi..
I am Mnaju.I have Completed my B.E Computers Science.Lokking for a job.I am interested in VC++
manju

scroll bar

algates002729-Aug-08 18:59

algates0027

29-Aug-08 18:59

How can i get automatic scroll bar in this project.http://www.codeproject.com/KB/graphics/PanZoom2.aspx?msg=2672101#xx2672101xx

sorry for posting link in this.
Regards,
ALGATES

Re: scroll bar

algates002719-Oct-08 20:12

algates0027

19-Oct-08 20:12

Custom action not running during installation

tahir_makhdoom29-Aug-08 17:55

tahir_makhdoom

29-Aug-08 17:55

i have different web applications i merge them and add them in a setup project i also add some custom actions in the setup. i have build and install the setup. It is done succesfully but my custom action doesnot work. I have a dialogue box which i want to show during installation for database generation but it doesnot appear. What is the solution. I am using vs 2008-with c#

tahir

[Cross-Post] Re: Custom action not running during installation

Scott Dorman29-Aug-08 18:08

Scott Dorman

29-Aug-08 18:08

Don't cross post to multiple forums as it is considered rude. The people here answer questions on a volunteer basis and may not respond in a timeframe you desire or find acceptable, and posting to multiple forums will not help you receive an answer any faster.

Original post: http://www.codeproject.com/script/Forums/View.aspx?fid=3831&msg=2700975[^]

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Question about Interfaces

MarkB77729-Aug-08 17:07

MarkB777

29-Aug-08 17:07

Hi,

I'm having some trouble cleaning up an application that automates Excel. I end up with multiple instances of Excel open...

What I have is three classes...

An "excel" class (Holds the excel COM object etc)
A control panel (Allows user to navigate through excel records)
A display panel (Displays the excel records)

I pass the Excel object to the other two panels using an interface (IExcel).

The Excel object has a Dispose method, and it cleans itself up when the user is finished.

When I click the cancel button in the control panel, I dispose of the excel object, but the instance isn't closing... So I think I may be missing some basics...

If I pass an object as an interface to another object, and then dispose of the original object, does that clean up everything else (i.e the interfaces I passed)?

Mark Brock
"We're definitely not going to make a G or a PG version of this. It's not PillowfightCraft." -- Chris Metzen
Click here to view my blog

Re: Question about Interfaces

Scott Dorman29-Aug-08 17:57

Scott Dorman

29-Aug-08 17:57

Since you are using the old COM interfaces to access Excel there is probably an explicit Close (or something similar) on the object that you need to call. When dealing with the office COM objects, calling Dispose is no guarantee that the COM side of things is going to automatically do the right thing.

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Re: Question about Interfaces

MarkB77729-Aug-08 18:09

MarkB777

29-Aug-08 18:09

Hi Scott,

The dispose method is written by me, and contains all the explicit calls to close the Excel application correctly (assuming MSDN is correct).

Scott Dorman wrote:
Since you are using the old COM interfaces to access Excel

What do you mean? Is there a newer/better approach?

Cheers,

Mark.

Mark Brock
"We're definitely not going to make a G or a PG version of this. It's not PillowfightCraft." -- Chris Metzen
Click here to view my blog

Re: Question about Interfaces

Scott Dorman29-Aug-08 18:19

Scott Dorman

29-Aug-08 18:19

MarkBrock wrote:
What do you mean? Is there a newer/better approach?

Well, I'm assuming you aren't using the functionality from VSTO so that would probably be a good place to start.

MarkBrock wrote:
The dispose method is written by me, and contains all the explicit calls to close the Excel application correctly (assuming MSDN is correct).

So if I understand this correctly, your "excel" object is a custom class you wrote that wraps the COM object and it is this class that you are passing to the other objects/methods? How have you written the dispose method? Are you implementing the IDisposable interface and the Dispose pattern properly?

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Re: Question about Interfaces

MarkB77729-Aug-08 18:36

MarkB777

29-Aug-08 18:36

Hi,

Yes by Excel object is custom class that wraps the COM object, and contains all the methods for getting information from Excel.

I'm not implementing IDisposable, The IExcel interface declares the dispose method.

If I call dispose from the 'excel' object it cleans up fine, however if I call it from an IExcel instance then it is not.

My dispose procedure is implemented as below:

<br />
<br />
        public void Dispose()<br />
        {<br />
            try<br />
            {<br />
                    this.Cleanup(this.sheet);<br />
                    this.workBook.Close(false, null, null);<br />
                    this.Cleanup(this.workBook);<br />
                    this.application.Quit();<br />
                    this.Cleanup(this.application);<br />
            }<br />
            catch (Exception) { }<br />
        }<br />
<br />
        private void Cleanup(object o)<br />
        {<br />
            try<br />
            {<br />
                System.Runtime.InteropServices.Marshal.ReleaseComObject(o);<br />
            }<br />
            catch { }<br />
            finally<br />
            {<br />
                o = null;<br />
            }<br />
        }<br />

Cheers,

Mark Brock
"We're definitely not going to make a G or a PG version of this. It's not PillowfightCraft." -- Chris Metzen
Click here to view my blog

Re: Question about Interfaces

Scott Dorman29-Aug-08 19:15

Scott Dorman

29-Aug-08 19:15

Is the IExcel interface also something you created? You really should implement this using IDisposable as well. Take a look at this article[^] for more information.

I'm not sure why you are getting different behavior when calling this on the interface instance as that shouldn't cause any problems. Try changing your code to implement the dispose pattern and see if you get any better behavior. (Even if you don't, you will still be in a better position as you are working with the GC in a much better manner.)

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Moving from VSWD Express 2008 to VS2008, Namespace problem

Vodstok29-Aug-08 13:01

Vodstok

29-Aug-08 13:01

I just moved a project of mine from the Express edition of Web Developer 2008 to VS 2008, and i have an odd issue. I have a class that was previously that had no namespace before, as with several other classes in the project. Since adding them all to the project, I have added them all to the namespace of the project, we'll say MarvelUniverse for the purposes of the post. Now, every other class works just fine, but the class MarvelSQL is not showing up or available.

It is a public partial class generated with sqlmetal, but aside from that, it is identical to the other classes, and even the other public partial classes (including the page classes, like _Default, are visible...)

Any ideas? This has been driving me nuts...

______________________
Oh Hamburgers!

Pointer help

jacobjordan29-Aug-08 12:54

jacobjordan

29-Aug-08 12:54

Here's my problem. I have this line of code in an unsafe context:

TreeNode* Current = null;

it gives me an error that says "Cannot take the address of, get the size of, or declare a pointer to a managed type ("System.Windows.Forms.TreeNode")"
The C++ equivalent of that line would be

System::Windows::Forms::TreeNode *Current = 0;

and in C++, i can avoid that error by using the '^' operator like so

System::Windows::Forms::TreeNode^ *Current = 0;

however, i know little to nothing about C++, and i have no idea what the '^' operator does. If anyone knows a way to implement this in C#, please let me know.

void Play() { try { throw Ball(); } catch (Glove) { } finally { Play(); } }

"Failure is only the opportunity to begin again, this time more wisely."
"Don't ask for a light load, but rather ask for a strong back."

Re: Pointer help

Mark Salsbery29-Aug-08 14:03

Mark Salsbery

29-Aug-08 14:03

C++ won't help here.

You can't take the address of a managed object in either language.

In C++/CLI, ^ indicates a handle to a managed object. You can get the
address of the handle but not the address of the object.

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: Pointer help

Guffa30-Aug-08 0:08

Guffa

30-Aug-08 0:08

To get a pointer to an object on the heap, you have to fix in to a specific address so that the garbage collector is no longer allowed to move it around in memory:

fixed (TreeNode* Current = null) {
   // here you can use the pointer
}

Why do you need a pointer to a TreeNode anyway?

Despite everything, the person most likely to be fooling you next is yourself.

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