C# Discussion Boards - CodeProject

15-Dec-15 5:07

What is wrong with this code that is not updating my datagrid and consequentetly the data base table? Thank you for any help.

using (OdbcConnection connection = CreateConnection())
{
  string CmdText = "update lojas set Bloqueado =@bloqueador, DataFim = @DataFim, Nome = @Nome where Id =@Id";

 OdbcCommand cm = new OdbcCommand(CmdText, connection);
 cm.CommandType = CommandType.Text;
 connection.Open();

 cm.Parameters.AddWithValue("@Id", grid_lic.CurrentRow.Cells[0].Value);
 cm.Parameters.AddWithValue("@bloqueador",grid_lic.CurrentRow.Cells[3].Value);
 cm.Parameters.AddWithValue("@DataFim",grid_lic.CurrentRow.Cells[4].Value);
cm.Parameters.AddWithValue("@Nome",grid_lic.CurrentRow.Cells[6].Value);

cm.ExecuteNonQuery();

CHill6015-Dec-15 5:13

CHill60

15-Dec-15 5:13

There is no code here to update the datagrid. You would need to refresh it after the database has been updated. E.g. set the datasource to null and then rebind it or use a BindingSource.

If the database is not being updated by this query then debug it to ensure the value for Id matches what you have in your data

Member 1144944715-Dec-15 23:06

15-Dec-15 23:06

When I change the data in the cells of the DataGridView, and I debug, the values that are shown are the new ones, but at the end the DataGridView is not updated. Can you please give an example of possible code to complete what I already have? Thanks.

CHill6015-Dec-15 23:31

CHill60

15-Dec-15 23:31

How do you populate the DataGridView? And how are you changing the data in the cells? By typing over what is there? What do you mean by "at the end" ... at the end of what?

Member 1144944715-Dec-15 23:46

15-Dec-15 23:46

By the end I mean after cliking in the button "upgrade" where this code is inserted. I change data by typing over what is in the cell.

I populate the datagrid this way:

 using (OdbcConnection connection = CreateConnection())
 {
OdbcCommand Command = new OdbcCommand("insert into lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) values (?, ?, ?, ?, ?, ?)", connection);

Command.CommandType = CommandType.Text;

Command.Parameters.AddWithValue("@N  IF", grid_lic.CurrentRow.Cells[1].Value);
Command.Parameters.AddWithValue("@Loja", grid_lic.CurrentRow.Cells[2].Value);
Command.Parameters.AddWithValue("@Bloqueado", grid_lic.CurrentRow.Cells[3].Value);
Command.Parameters.AddWithValue("@DataFim", grid_lic.CurrentRow.Cells[4].Value);
Command.Parameters.AddWithValue("@lastupdate", grid_lic.CurrentRow.Cells[5].Value);
Command.Parameters.AddWithValue("@Nome", grid_lic.CurrentRow.Cells[6].Value);
Command.ExecuteNonQuery();
}

CHill6016-Dec-15 0:21

CHill60

16-Dec-15 0:21

Ok - that code is not populating the datagrid it's updating the database - are you saying that the DataGrid is bound to the database?

You refer to this as a DataGrid - is this in an ASP page? In which case are you checking for PostBack?

Member 1144944716-Dec-15 0:25

how can i get Array sort index?

16-Dec-15 0:25

The datagrid is bound to the database. This is the connection command:

private static OdbcConnection CreateConnection()
{
return new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=192.168.19.78; database=licenciamento; uid=estagio; password=1234; option = 3 ");
}

It is not an ASP page, it is only windowsform.

smallkubi15-Dec-15 0:06

15-Dec-15 0:06

Hi, all friends:
i want to get a efficient function to sort array, and return a old array index .
For example: double[] a=[5,4,1,3,2];
how can i get b is [1,2,3,4,5],and index array c is [2,4,3,1,0]?
i want a efficent and quick method...

OriginalGriff15-Dec-15 1:09

OriginalGriff

15-Dec-15 1:09

There is no built in method that will do that for you - the index to the previous array is what causes the problem - and you can't "retrospectively" find it because in the event of duplicates, you don;t know which value to use.

What I would probably do is package the value you want to sort into a struct together with it's original index and sort that, using a comparator that looked only at the values.
The resulting sorted info would include the original array index, and it would be pretty trivial to split them back up if you needed to.

public struct sortable
   {
   double value;
   int index;
   }

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

harold aptroot15-Dec-15 1:49

harold aptroot

15-Dec-15 1:49

Array.Sort has an overload that takes and array of keys and an array of values. If you sort [0,1,2,3,4] with the keys [5,4,1,3,2], it will give you [2,4,3,1,0], as you wanted.

sandbox[^]

modified 15-Dec-15 7:54am.

smallkubi15-Dec-15 2:48

15-Dec-15 2:48

good idea,smart!!!
and i would to know how to generate array 0 to 100 , not use loop?

harold aptroot15-Dec-15 3:19

harold aptroot

15-Dec-15 3:19

Apart from typing it out manually? Just use a loop.

int[] index = new int[100];
for (int i = 0; i < index.Length; i++)
    index[i] = i;

inb4 Enumerable.Range(0, 100).ToArray() - oh sure, but that has the same loop, and also does a bunch of array allocations and copies. Sweeping a loop under the rug doesn't make it go away.

smallkubi15-Dec-15 4:16

15-Dec-15 4:16

OK,I SEE,thank you

how to improve paint() speed?

BillWoodruff15-Dec-15 4:52

BillWoodruff

15-Dec-15 4:52

A little Linq, perhaps:

int[] iary = new[] { 5, 4, 1, 3, 2 };
var sorted = iary.OrderBy(itm1 => itm1).ToArray();
var unsortedIndexes = sorted.Select(itm2 => Array.IndexOf(iary, itm2, 0)).ToArray();

Note that using 'OrderBy creates a copy of the Array.

>? sorted
{int[5]}
    [0]: 1
    [1]: 2
    [2]: 3
    [3]: 4
    [4]: 5

> ? unsortedIndexes
{int[5]}
    [0]: 2
    [1]: 4
    [2]: 3
    [3]: 1
    [4]: 0

> ? iary // after creating 'sorted using 'OrderBy
{int[5]}
    [0]: 5
    [1]: 4
    [2]: 1
    [3]: 3
    [4]: 2

«Tell me and I forget. Teach me and I remember. Involve me and I learn.» Benjamin Franklin

modified 15-Dec-15 11:23am.

smallkubi14-Dec-15 19:26

Re: how to improve paint() speed?

14-Dec-15 19:26

hi, i have a question.
When i use chart1.invalidate() to refresh chart, it had 3 ms cost betten call chart_paint(), Then i called chart_paint() manully on other thread, it cost less than 1ms,it can reach my requirement. But chart has no refresh, it can not clean up history paint.
So i want to know how to invalidate chart control ,but not to call paint aotumatic?

BillWoodruff14-Dec-15 21:44

BillWoodruff

14-Dec-15 21:44

Have you tried over-riding the Paint Event ?

«Tell me and I forget. Teach me and I remember. Involve me and I learn.» Benjamin Franklin

Re: how to improve paint() speed?

smallkubi15-Dec-15 0:03

c# problem with combobox in form opened in panel

15-Dec-15 0:03

how can i overriding the paint event? please help me a example

Member 1182236414-Dec-15 5:27

Re: c# problem with combobox in form opened in panel

14-Dec-15 5:27

I got problem with ComboBox in winforms c#. Comboboxes in main window works fine, but comboboxes in form that I open in panel on main window are broken. The wierd things starts to happen... I cant click it to type. I can only open list, select one and then type. Also i cant locate cursor in the middle of text because it highlight whole text. I post code with I open form in panel:

public void otworzOkno(Form _form)
{
    if (Application.OpenForms[_form.Name] != null)
    {
        Application.OpenForms[_form.Name].WindowState = FormWindowState.Normal;
        Application.OpenForms[_form.Name].BringToFront();
    }
    else
    {
        _form.TopLevel = false; 
        _form.AutoScroll = true;
        this.panel.Controls.Add(_form);
        _form.Show();
        _form.BringToFront();
    }      
}

Video that will explain problem: https://youtu.be/PrVxFWvhPyc

Simon_Whale14-Dec-15 5:37

Simon_Whale

14-Dec-15 5:37

how have you constructed the comboboxes?
do they have an assigned datasource?
do they share datasources?

how you are showing the way that you are opening the form that they are on doesn't show the problem it's on that form.

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: c# problem with combobox in form opened in panel

Member 1182236414-Dec-15 5:47

Re: c# problem with combobox in form opened in panel

14-Dec-15 5:47

The problem is that the form is opened in panel, because when i open the same form with the same settings in seperate window not in panel it works fine. I dont know why that happen

Simon_Whale14-Dec-15 5:51

Simon_Whale

14-Dec-15 5:51

as a Test I would change your code to this, I do something similar but I use a splitter container.

public void otworzOkno(Form _form)
{
    if (Application.OpenForms[_form.Name] != null)
    {
        Application.OpenForms[_form.Name].WindowState = FormWindowState.Normal;
        Application.OpenForms[_form.Name].BringToFront();
    }
    else
    {
        _form.TopLevel = false;
        _form.Parent = panel;
        _form.Show();
        _form.BringToFront();
    }      
}

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: c# problem with combobox in form opened in panel

Member 1182236414-Dec-15 5:56

Re: c# problem with combobox in form opened in panel

14-Dec-15 5:56

Still the same, even when I tried in SplitContainer ;/

Simon_Whale14-Dec-15 5:57

Simon_Whale

14-Dec-15 5:57

you then need to show how the combo's are generated and populated.

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: c# problem with combobox in form opened in panel

Member 1182236414-Dec-15 6:04