Format cell standard in Excel with c#


i have excel file enter in database. need read cells. problem type standard in excel. how convert standard type string when reading excel file using c#?

enter image description here

my code:

using (oledbconnection conn = new oledbconnection(sbconnection.tostring()))  {      var dt = new datatable();        string query = string.format("select  * [{0}]", sheetname);      conn.open();        oledbdataadapter adapter = new oledbdataadapter(query, conn);      adapter.fill(dt);        try      {          using (sqlconnection con = new sqlconnection(consstring))          {              con.open();                for (int = 2; < dt.rows.count; i++)              {                  for (int j = 1; j < dt.columns.count; j += 4)                  {                      try                      {                          string sourcestring = dt.rows[0][j].tostring();                            messagebox.show(sourcestring);                      }                  }             }          }      }  }

after compiling code :

enter image description here

perhaps should use dt.rows[i][j] instead of dt.rows[0][j].



Visual Studio Languages  ,  .NET Framework  >  Visual C#



Comments

Post a Comment

Popular posts from this blog

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

hi , background: for our customer, having a  2 biztalk , 1 sql setup of environment. [biztalk server 2013 azure vms provisioned azure gallery, sql server 2012 azure vm ]. in current configuration, there no high availability or disaster recovery plan set. want implement dr , possibly ha configuration on these servers. i have few questions regarding same. please let me know thoughts on same. currently writing log files (log shipping files) mounted/attached drive same sql server. how move these log files across secondary site since shared storage not supported. in case of sql server crash, losing log files since reside on same server. please share options on how can move these periodically between datacenters. for hosts pop3, ftp need host clustering (which requires biztalk machines present on windows cluster traditionally), please let know how achieve in azure scenario thanks , regards, ujjwal devarapalli -ujjwal you can refer article, issue azure vm lo...
Read more

wcf-sql adapter bug for operation on same table

hi experts, first of explain u module.. 1.) inserting xml files in sql 2008 using wcf-sql adapter through an orchestration.. 2.)am retrieving records same table using wcf-sql adapter. here polling records directly admin console... my problem ,for first time records inserted , second time they going dehydrated stage... when disable receivelocation(polling table), records being  inserting without dehydration..after r&d come know problem exists because, am inserting & retreiving data same table..i think locking database at polling time.what solution this? can 1 faced same problem?is wcf-sql bug?is there solution to overcome problem?needed urgently pls based on scenario you've described, dirty reads out (since want update on records retrieved).   so you've got options here if looking configuration based solution .   if data you’re polling on can near real time, can set polling interval in 8-10 minute rang...
Read more

Error connecting to Azure Blob using Shared Access signature

msg 105019, level 16, state 1, line 100 external table access failed due internal error: 'java exception raised on call hdfsbridge_connect. java exception message: parameters provided connect azure storage account not valid.: error [parameters provided connect azure storage account not valid.] occurred while accessing external file.' create database scoped credential azurestoragecredential identity = 'shared access signature', secret = 'abcdexxxxxxxxxxxxxxxxxxxxxxxxx'; create external data source myazurestorage1 ( type = hadoop, location = 'wasb://container@mydwblob.blob.core.windows.net/', credential = azurestoragecredential ); create external table dbo.myexternaltable( vendorid varchar(50) null, ) ( location='/2016/', data_source = myazurestorage1, file_format = myfileformat,reject_type = value,reject_value = 1000 myfileformat,reject_type =...
Read more