how to insert many rows in datagridview

firas shaar

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

R J12y ago
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;
}

}
0
R J12y ago
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?
0
firas shaar12y ago
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
0
R J12y ago
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
0