First we need to add below namespace for DataTable.
using System.Data;
After we can declare datatable shown below.
DataTable
dtVerifyMobileNo = new DataTable();
Below method is useful for Add columns
to the data table.
void CreateDynamicTableForEmpty()
{
dtVerifyMobileNo.Columns.Add("cons_ref");
dtVerifyMobileNo.Columns.Add("mobile");
dtVerifyMobileNo.Columns.Add("name");
}
Below condition is useful for
bind data to data table. First we need to declare a Data row for bind data to
Datatable.
if (dtXL.Rows[j]["MOBILE"].ToString().Trim().Length == 0)
{
DataRow drMobile = dtVerifyMobileNo.NewRow();
drMobile["cons_ref"] = dtXL.Rows[j]["CONS_REF"].ToString().Trim();
drMobile["mobile"] =
dtXL.Rows[j]["MOBILE"].ToString().Trim();
drMobile["name"] = dtXL.Rows[j]["NAME"].ToString().Trim();
dtVerifyMobileNo.Rows.Add(drMobile);
}
No comments:
Post a Comment