C# Tutorial - Import data from Excel to SQL Server | FoxLearn

thanks your explanation is very helpful

Hi, ¿How I can do this, but having more excel sheets in the excel file, and each sheet have to import to a table in SQL?, thx

Can anyone please where is this variable declared customerBindingSource customerBindingSource.DataSource = list;

beware Dapper Plus is not free !!!! they will expired with in one month after use this library

Its faster to just save the Excel file as CSV and in SQL Server: rightclick database > Tasks > Import Flat File > done!

how about the updating the table by importing the new and updated csv file ?
do you have any tutorial on that ? thanks for the reponse

how do i add csv file ?

Hi, I have tried this it is taking more time to execute dB.BulkInsert line , not stopping . Can you help me

please , i want this project

Thank uuuuu soooooo Muchhh !!!!!! u save my life !! :))))

What if we have to insert an integer in one of the columns? We can't use .toString for those.

Awesome Video Thank you so much

can you make a delete button that delete the imported file in the databse

Excellent ! Thank you very much for this video.

Thank youuuuuuuuuuuu very very much!!!!!!!!!!!!!!!!!!!!!!!!!!!

thank you for this! very clear tutorial :)

What about if i have a foreign key because i create a two different data gridview eith different items but have a foreign key

how to mapping sheet column and class variable means any one choose and map both column before show on datagrid just like sql import wizard

Nice tuto ❤ But, DAPPER PLUS is not free. Isn't it?

Please can you share de code, i facing trouble on ready object, the method "AsDataSet". I want see the import part. I already was i your web page i saw the code but the import part is cutted.

how to do this with phpmyadmin database?

Thank You !!

can I also apply for xamarin forms?

it ignores russian characrters. how to handle that please help m,e

Alguien que haga el mismo video y lo traduzca?

an error occured while retrieving the InformationSchemaTable information. See the inner exception for details.

i get this error when i click the import button at the end. i checked every code and any detail may help online but stucked. i need some help.

Have a problem with binding source to datagridview in 13.18 seconds you clicked on datagrid view datasource selecting dropdown and selecting “other data sources”. But in my case it wouldn't appear.what should i do to add it?

"An error occurred while retrieving the InformationShemaTable information. See the inner exception for details." This is the I have when I click import to database please some help me out

Hello Sir, I am using visual studio 2015 and sql server 2019. I tried to connect it to visual studio 2015 and it worked. However, when I try to open new query in visual studio from sql server 2019 connection, "an incompatible sql version was detected" window pops out. Is it true that both of them are incompatible? Thanks. It also appears when i try to right click the table inside it when i try to show table data.

How to map the column name with space. For example if the column name is First name in SQL than how can we map in c# code

Hi ! Thanks for you Tutorrial. This is really awesome...

Hello and thank you for this tutorial, it has been very helpful. I was wondering if you have an example on the same example, but with some validation to avoid duplicate entries. Thank you very much for your work.

What i say about you...Previous Comments will say all and Your the Best FoxLearn.

What shoudl I put to the tableCollection If I want all sheets to be uploaded?

thank you, can't thank u enough <3

Hi. My DataGridView can not pick up Class Customer after I create it on visual Studio

HI! Thanks for your tutorial, it's very nice! Could you help me, since I'm from Access and I'm a beginner in C #? I made this project, but instead of using the mdf database I'm using dataset (in my case called "Database"). My excel file has 2 columns (IDComuni and Comune), and in the Dataset I created the "Comuni" table with 2 fields (IDComuni "int32" and Comune). Now the problem is to load this data from the Datagridviewer to the table.

// --- DapperPlusManager.Entity <Comuni> () .Table ("Comuni");
             using (IDbConnection db = new SqlConnection ("? ....?"))
                          {
              db.BulkInsert (list); - //

How can I modify this syntax so that it can load everything in the "Comuni" table? Thank you!

how to add validation if all the imported data already exists in the database ?

I use visual studio 2010 so i can not add z. Dapper plus like this video. So how can i do this without z. Dapper plus, i want to import excel file to sql server. Fox Learn help me please!

DapperPlusManager.Entity<accounts>().Table("Account"); what is this line doing ?

any solution for Import data from Excel to phpmyadmin

whats the difference between Dapper ORM and Z.Dapper please

sir why Filemode and File access are error in mine??

Thank you, Thank you, Thank you, Can not thank you enough.