python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
count number of column in datatable c#

count number of column in datatable c#


DataTable Sheets = connectionString.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

foreach (DataRow dr in Sheets.Rows)
{
    string sheetStr = dr[2].ToString().Replace("'", "");

    OleDbDataAdapter dataAdapter = new OleDbDataAdapter("select * from [" + sheetStr + "]", connectionString);

    var ds = new DataSet();
    dataAdapter.Fill(ds, "DataTable");
    DataTable data = ds.Tables["DataTable"];

    if (ds.Tables["DataTable"].Rows.Count > 0)
    {
        GetSetUploadExcelData(uploadExl, data, CompanyID, TenantID);
    }

}
ANIL SINGH

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions