how to import datagridview to datatable in c#
public DataTable GetDataTable()
{
DataTable dtLocalC = new DataTable();
dtLocalC.Columns.Add("splr_Slno");
dtLocalC.Columns.Add("splr_Cntctnm");
dtLocalC.Columns.Add("splr_Cntctdesig");
dtLocalC.Columns.Add("splr_Cntctmoblno");
dtLocalC.Columns.Add("splr_Cntctemail");
DataRow drLocal = null;
foreach (DataGridViewRow dr in dgvSpplrfrm.Rows)
{
drLocal = dtLocalC.NewRow();
drLocal["splr_Slno"] = dr.Cells["splr_Slno"].Value;
drLocal["splr_Cntctnm"] = dr.Cells["splr_Cntctnm"].Value;
drLocal["splr_Cntctdesig"] = dr.Cells["splr_Cntctdesig"].Value;
drLocal["splr_Cntctmoblno"] = dr.Cells["splr_Cntctmoblno"].Value;
drLocal["splr_Cntctemail"] = dr.Cells["splr_Cntctemail"].Value;
dtLocalC.Rows.Add(drLocal);
}
return dtLocalC;
}
Also in C#:
- Check object is in layermask unity
- bool toggle unity c#
- wait without pause anything else unity
- How to solve error in ExecuteNonQuery() in asp.net
- C# check many strings quickly
- devexpress objectspace to session
- if statement conditions c#
- how to run csharp in visual studio code
- c# object clone
- ubuntu: how to open the terminal from c#
- csharp first element of array
- c# program exit
- asp.net mvc return file
- 2d movement unity
- c# string remove special characters
- oracle c# parameters wont work
- ihttpactionresult to object c#
- c# remove from list in foreach
- get normal from 3 points
- unity lerp
- c# string code ascii
- send type as argument c#
- C# Into To Tring Debug.Log
- how to add movement in unity