how to insert many rows in datagridview

Question

I have two tables
first is called employees table and the other one is worktimes table
employee_id column is primary key in employees table and foreign key in worktimes table
when button_click event
everyday I want to insert all employees names cloumn in employees table
to worktimes table programtically in datagridview
I have 80 employee name

R J · Answer

I think you wanted to bind the data at once on ADD button click i have written sample code for you. this is console program. Understand this and try use in your code. public class Program { ////// Call the similar code on add button click. public static void Main(string[] args) { var employees = GetEmployees().AsEnumerable(); var worktimes = GetWorkTimes().AsEnumerable(); var result = from employee in employees join workTime in worktimes on employee[EmpId] equals workTime[EmpId] select new { EmpId = employee[EmpId] StartTime = workTime[starttime] EndTime = workTime[endtime]}; //// Bind the result set to DatagridView } public static DataTable GetEmployees() { ////// this is dummy data but get the data from DB. DataTable dt = new DataTable(); dt.Columns.Add(EmpId typeof(int)); dt.Columns.Add(EmpName typeof(string)); dt.Rows.Add(11 Empl1); dt.Rows.Add(22 Empl2); dt.Rows.Add(33 Empl3); return dt; } public static DataTable GetWorkTimes() { ////// this is dummy data but get the data from DB. DataTable dt = new DataTable(); dt.Columns.Add(TimeRowId typeof(int)); dt.Columns.Add(EmpId typeof(int)); dt.Columns.Add(starttime typeof(DateTime)); dt.Columns.Add(endtime typeof(DateTime)); dt.Rows.Add(1 11 DateTime.Today DateTime.Today.AddHours(8)); dt.Rows.Add(2 11 DateTime.Today DateTime.Today.AddHours(8)); dt.Rows.Add(3 21 DateTime.Today DateTime.Today.AddHours(8)); dt.Rows.Add(3 22 DateTime.Today DateTime.Today.AddHours(8)); return dt; } }

R J · Answer

On Add button click... - You want all the 80 employees to be added to datagridview at once from code? Or you need editable datagridview to manually enter Employee Id and work times?

firas shaar · Answer

datagridview is three columns employee_id column is primary key in employees table and foreign key in worktimes table start job time column in worktimes table end job time column in worktimes table button_click event is add button I want to add all employees names in employess column in datagridview and I want to add 8 Am at start job time column and 18 pm in end job time column everyday when button_click I have 80 employees therefore must add 80 rows in datagridview everyday every row consist from employee name and 8am and 18 pm

R J · Answer

Do you need to display two datagridviews in Window Form? Also I do not understand what is your requirement on insertion of employees on daily basis that too only names. What is the button click event Is the button for EDIT or ADD ? Do you add/edit work items too? can you try with hierarchical datagridviews. ? Can you please explain your requirement a bit better way to understand how your view would look like. thnx