problem in binded columns to DataGridView - C# Discussion Boards

Re: invoices .. print to specefic Point or RDLC?

29-Aug-08 22:18

I have a pre-printed invoices on dot matrix and i want to print the customers' invoices on it...

which method is best? printing to specefic point or use RDLC?

Naji El Kotob26-Oct-09 4:03

Naji El Kotob

26-Oct-09 4:03

Hi,

You don't need a complicated algo. here, RDLC is more than enough.

good luck,

NajiCo http://www.InsideVB.NET[^]

It's nice 2b important, but it's more important 2b nice...
http://www.facebook.com/group.php?gid=5932660937[^]

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?

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)

Jassim Rahma29-Aug-08 22:53

29-Aug-08 22:53

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

Wendelius30-Aug-08 4:57

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

Jassim Rahma30-Aug-08 8:22

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'

Wendelius30-Aug-08 8:31

30-Aug-08 8:31

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

Jassim Rahma30-Aug-08 8:36

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.

Wendelius30-Aug-08 8:48

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;
...

Jassim Rahma30-Aug-08 13:17

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

Wendelius30-Aug-08 21:12