Thanks, it works

Is there a way to do it? IE: 30000 I want it to be 30 000

i did searched but i got results that were irrelevant. thanks anyway

How do I do that? Did some google search but couldnt find any good result

-I have verified it, everything is correct -Its tested and it is successfully connected -I have tried that Its just weird, i can create this odbc connection without any problems. but connecting with it just dont work i have gotten it to work in other places, but its this place i cant get it to work

I have a problem with connecting to a sql server with ODBC source. I can create this source without any problems in administration tools -> ODBC sources. But when I try to connect to the SQL server I get an error saying that the ODBC source name doesnt exist. I have tried to connect directly to server via Excel import data and it works well, but with ODBC source I get this error. Someone with any idea of the problem

Since comma is a delimiter in sql queries, are there any way that let me insert a float that has a comma as decimalsign for example the table is: testtable col1 varchar(20); col2 float; insert into testtable ("blah", 2,2) this of course wouldnt work since 2,2 acts as two values not as one the european computers have comma set in the regional settings. so this could be problematic unless i change the decimal to a dot.

Thanks a lot and thanks for your time. I appreciate this

it feels like im getting annoying now group by statement might work if i have an aggregate statement somewhere, now there isnt i cant do the group by i am trying distinct now, but i get incorrect syntax SELECT g.Maximum, distinct posnumber from out_pumptable, (SELECT MAX(flow_lpm) as Maximum, posnumber FROM out_pumptable GROUP BY posnumber)g WHERE flow_lpm = g.Maximum this is actual code, posnumber is project

top 1 seems not be working good for this I get this result, (partially), from the query you gave me

3320,9 P110101
3320,9 P110101
3220 P110102
3220 P110102
529,14 P110301
3706,2 P111501

P110102 got two rows, how do i get one of it only?

its working :D , just one more thing >.<<br mode="hold" /> some rows in col1 has same value, is it possible to just have one of the values, just take from one row?

It still doesnt work. It says an aggregate cant be in WHERE clause An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference. Tried with Having and it gives a lot other errors

it looks good, but the column project you have after group by isnt used anywhere. is it something missing before group by? never mind about that. I have tried the query and it results a little too much. it seems it loops for each max value and result for all row

Here is the table

Project col1 col2 col3 col4
A 151,46 80 0,29 2
A 529,14 83 0,29 1
B 3391,3 80 0 2
B 3706,2 75 0,06 1
C 8685,3 78 2,41 1
C 9005,2 71 0 2

How do I get the max value for col1 for each project and its other values? ie. project a's max value is 529,14. its others value is 80, 0.29 and 2

Project col1 col2 col3 col4
A 529,14 83 0,29 1
B 3706,2 75 0,06 1
C 9005,2 71 0 2

I have this query, but it results everything, not only the max value for each project

select project, max(col1), col2, col3, col4 from out_pumptable group by project, col2, col3, col4

How do I get which column is clicked when I click on the column header? I know how to get the column name with this code

lstListViewColumns[1].Text;

But how do I get the name of the columnheader I clicked?

Thanks. It works now :D Only thing that the combobox doesnt update directly sometimes. But thats another problem

Thanks for the information I have tried this code, but when I build it I get this error the private method I have assigned with. I thnk I have done something wrong It says "Method name expected" This is the code I used for form 1

    private void btnNewPost\_Click(object sender, EventArgs e)
    {
        Forms.frmAddCategory addcats = new frmAddCategory();
        addcats.Refresher += new Forms.frmAddCategory.refreshcat(this.comboRefresh("newPost"));
        addcats.ShowDialog();
    }

comboRefresh(string blah)
{
//code to refresh the combobox
}

and this is for the form 2

public partial class frmAddCategory : Form
{
    //Delegate
    public delegate void refreshcat();
    public refreshcat Refresher;

    private void frmAddCategory\_FormClosed(object sender, FormClosedEventArgs e)
    {
        Refresher();
    }

How does it work? I am not familiar with delegates >.< Could you provide me some code examples, please?

Im not a VB coder, but I guess I use their method or something like that Anyway. It looks like it pass a value to a variable to the first form, which isnt what I wanted to do. I wanted to call a method. But maybe a similiar way to do like you stated above. Can you show me some sample code to call a method (function, procedure, whatever :P)

Hello again I have two forms, one being opened by another. What I want to do is that the second form that is opened by the first one is when it is closing, I want it to run a method in first form. The code I used is something like this. private void frmAddCategory_FormClosed(object sender, FormClosedEventArgs e) { frmCore core = new frmCore(); core.comboRefresh("newPost"); //frmStart start = (frmStart)this.Owner; } It doesnt work. I checked with debug and it seems to run, but nothing seems to happens to the first form. Its a dropdownlist that has items in it, the second form adds new items to it in a database. the method that is called is taking data from a database and updates the dropdownlist with the new items.