Comments by Armel_Djient (Top 25 by date)

this is in the same class, how to do if i want to get that static datatable in other winform for example

thanks for ur reply. after reading MVC seems to be intersting

i got your point and i think youu are right. Subdivise my app in 3 layers(presentation, business logic and data access layer) will be benefict for me.
thanks for ur reply

according to you, how can manage the access to my database such that my winform app will not go down?
note: i have mysql phpmyadmin

connection pooling is only for Sql server. I use mysql phpmyadmin

no error is generated. i said the setup i created does not run in other computers

i observed something, when i execute my winform in VS 2012, my assembies are not present in bin folder, do you think it can be the problem when i generate the exe setup?

yah i did, but still error

in the database the date is stored in format of DATETIME.(eg: 2015-11-16 10:45:48)
now through a sql command i fetched only the time from this datetime, ie 10:45:48
which represents the date_to_be compared or the time_to_be_compared

As you can imagine i have more than one row in my database. that's why i fetched them and put in the datatable.

In your source code u know in advance what is date_to_be_compared that's why you wrote
DateTime date_to_be_compared = DateTime.ParseExact("12 Aug 2014 13:45:22", "dd MMM yyyy HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);

if i modified your code and write something like that, i will get error
foreach (DataRow items in dchild.Rows)
{
DateTime date_to_be_compared = DateTime.ParseExact(items["time_created"], "dd MMM yyyy HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);
}

where items["time_created"] represents for example the first row's value 10:45:48

thanks for your reply. the problem in your source code is :
DateTime date_to_be_compared = DateTime.ParseExact("12 Aug 2014 13:45:22", "dd MMM yyyy HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);

the date_to_be_compared that you parse is static "12 Aug 2014 13:45:22" .
But mine is not.
in my source code, the date_to_be_compared is fetched from the datatable in this format "hh:mm"

because i want to fetch only the time from DateTime. Is there another way to fetch only time without converting the DateTime values to string?

i got how this command works.
INSERT INTO table_listnames (name, address, tele)
represents the columns where the data will be inserted
SELECT * FROM (SELECT 'name1', 'add', '022') AS tmp
traduces the values to be inserted in the columns(name, address, tele) mentionned above
WHERE NOT EXISTS
to checks if the record already exists or not

Thank you very much for your reply

the dchild datatable is already populated from a database. Now i am trying to insert datatable contents into another database table

fisrt of all i am very grateful for ur reply. u can't imagine how useful are ur explanation. Between the 2 approaches given by u i prefer the first one. i found it simple.

thanks you for your reply. it helped me a lot.

yes. in fact i put the datagridview and added 2 columns(RED and GREEN) graphically. and programmatically in my code i want to add a cell to a specific column and insert the society according to the condition defined above

this one
this.dataGridView1.Rows[cell_green].Cells[0].Value = society_name;

after debugging i have this message:< Index was out of range. Must be non-negative and less than the size of the collection.>

what i have tried does not work