1. A

    Question External table is not in the expected format

    I am trying to upload my excel 2013 file contents to sql server. Here is my code : try { string connectionString = @"data source=DELL\SQLEXPRESS01 ; initial catalog = amen; persist security info = True; Integrated Security = SSPI; "...
  2. R

    How to apply template on excel file exported using oledb ?

    Hi, I have exported data into excel file using oledb since I cannot use interop or any third party library. Here is my code ''' <summary> ''' Export datagridview's data contained in an data table to excel file ''' </summary> ''' <param...
  3. R

    Question Best Data Provider to use with all/almost all Database

    Hi All, I am starting to develop a new framework and need to know if there's any best or common used data provider that accept Oracle, Sql Server, Access, and another possible Database Client's. Is there any suggestion? ODBCConnection? OleDbConnection? SqlConnection? Tks and sorry the bad...
Top Bottom