Click here to Skip to main content
15,881,803 members
Home / Discussions / C#
   

C#

 
GeneralRe: Is there a better way to call Same Methods on different objects ? Pin
Emanuele Bonin26-Dec-15 5:28
Emanuele Bonin26-Dec-15 5:28 
GeneralRe: Is there a better way to call Same Methods on different objects ? Pin
Gerry Schmitz26-Dec-15 7:43
mveGerry Schmitz26-Dec-15 7:43 
GeneralRe: Is there a better way to call Same Methods on different objects ? Pin
Emanuele Bonin26-Dec-15 8:40
Emanuele Bonin26-Dec-15 8:40 
GeneralRe: Is there a better way to call Same Methods on different objects ? Pin
Gerry Schmitz26-Dec-15 16:16
mveGerry Schmitz26-Dec-15 16:16 
QuestionFill DataGrid ODBC Postgres Pin
Andre Dieme22-Dec-15 23:04
Andre Dieme22-Dec-15 23:04 
AnswerRe: Fill DataGrid ODBC Postgres Pin
Eddy Vluggen23-Dec-15 1:51
professionalEddy Vluggen23-Dec-15 1:51 
AnswerRe: Fill DataGrid ODBC Postgres Pin
Mycroft Holmes23-Dec-15 11:53
professionalMycroft Holmes23-Dec-15 11:53 
GeneralRe: Fill DataGrid ODBC Postgres Pin
Andre Dieme25-Dec-15 10:31
Andre Dieme25-Dec-15 10:31 
Thank you for your answers. I think so too. I tried a bit and found a solution which needs 1.5 seconds.

C#
DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            // Specify connection options and open an connection
            NpgsqlConnection conn = new NpgsqlConnection("Server=localhost;User Id=xxx;" +
                                    "Password=xxx;Database=xxx;");


            conn.Open();

            string query = "SELECT xxxx";
            //// Define a query
            NpgsqlCommand cmd = new NpgsqlCommand(query, conn);

            //// Execute a query
            NpgsqlDataReader dr = cmd.ExecuteReader();


            //// Read all rows and output the first column in each row
            while (dr.Read())
                data.Add(new Lagerteile() { ID = (int)dr["ID"], Kunde = dr["Name"].ToString(), Liefertermin = (DateTime)dr["Liefertermin"], WANr = dr["WaNr"].ToString(), Name = dr["Bezeichnung"].ToString(), Pos = dr["Pos"].ToString(), Stk = (int)dr["Stk"] });



            conn.Close();

          dg123.DataContext = data;


It seems to be very long because you could not work in that time. Is there a possibility to fill it in the background that you get a result directly ?

How can I refresh the DataGrid ? The problem is that for example an other client changed the database.

modified 26-Dec-15 10:43am.

QuestionWhy i can't change my startup Form in VS2013. Pin
Kashaf Murtaza22-Dec-15 22:18
Kashaf Murtaza22-Dec-15 22:18 
AnswerRe: Why i can't change my startup Form in VS2013. Pin
Pete O'Hanlon22-Dec-15 23:35
mvePete O'Hanlon22-Dec-15 23:35 
AnswerRe: Why i can't change my startup Form in VS2013. Pin
OriginalGriff22-Dec-15 23:37
mveOriginalGriff22-Dec-15 23:37 
AnswerRe: Why i can't change my startup Form in VS2013. Pin
John Torjo28-Dec-15 0:14
professionalJohn Torjo28-Dec-15 0:14 
Questioncompression Pin
jackie.398121-Dec-15 9:18
jackie.398121-Dec-15 9:18 
AnswerRe: compression Pin
Kevin Marois21-Dec-15 9:28
professionalKevin Marois21-Dec-15 9:28 
GeneralRe: compression Pin
jackie.398121-Dec-15 9:31
jackie.398121-Dec-15 9:31 
GeneralRe: compression Pin
Richard Andrew x6421-Dec-15 10:26
professionalRichard Andrew x6421-Dec-15 10:26 
AnswerRe: compression Pin
Dave Kreskowiak21-Dec-15 11:05
mveDave Kreskowiak21-Dec-15 11:05 
GeneralRe: compression Pin
jackie.398121-Dec-15 11:09
jackie.398121-Dec-15 11:09 
AnswerRe: compression Pin
Rob Philpott21-Dec-15 11:16
Rob Philpott21-Dec-15 11:16 
GeneralRe: compression Pin
jackie.398121-Dec-15 11:19
jackie.398121-Dec-15 11:19 
GeneralRe: compression Pin
Rob Philpott21-Dec-15 11:28
Rob Philpott21-Dec-15 11:28 
GeneralRe: compression Pin
jackie.398121-Dec-15 11:33
jackie.398121-Dec-15 11:33 
GeneralRe: compression Pin
Richard MacCutchan21-Dec-15 20:37
mveRichard MacCutchan21-Dec-15 20:37 
GeneralRe: compression Pin
jackie.398122-Dec-15 3:33
jackie.398122-Dec-15 3:33 
GeneralRe: compression Pin
Richard MacCutchan22-Dec-15 3:34
mveRichard MacCutchan22-Dec-15 3:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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