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

how to insert many rows in datagridview

Jignesh Trivedi

piya p

piya p

Jignesh Trivedi