HOW TO IMPORT EXCEL FILE TO DATAGRIDVIEW AND SAVE TO DATABASE USING C#

HOW TO IMPORT EXCEL FILE TO DATAGRIDVIEW AND SAVE TO DATABASE USING C#

Programming Language: C#
Database: MSSql Server

#KapeCoder

[talhach]

This is very very informative video krep it upp
Thanks

[emirmustafaakdemir]

Can someone help me!

I need to use comboBox for finding the folder from file paths and textBox to find the file and when i select an item in comboBox it leads a file, when I text something in the textBox program should look the folder comboBox have chosen and then open the file as the same name with textBox. like each comboBox is gonna have their own path and lead the textBox to search for a file and then when i click the button it needs to be seen in the dataGridView? it is really complicated but i am new at c# don't know what to do

[Techtutorialtips]

Sir gumawa ka naman ng video kung paano mag import ng excel file na may Image hindi lang data lang ang laman tapos i display nya sa Datagridview, sir kung meron ka pahingi po ng source code send nyo lang sa gmail ko sir

[jayrgallego]

Can we database Excel without transfer to Datagrid View ? and search value then put to Textbox ?

[MonsourOrbinoMonch]

Error CS1061 'object' does not contain a definition for 'Text' and no accessible extension method 'Text' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?)

Sir, Paano kya ito?

[garudakurt]

Sir pa request! Paano mag access ng xampp mysql database into mutilple pc using lan connection. Tas ehh install yong desktop app na ginawa!

[leonroutzounis]

Nice tutorial. I get an error message.
Error CS1061 'Application' does not contain a definition for 'UsedRange' and no accessible extension method 'UsedRange' accepting a first argument of type 'Application' could be found (are you missing a using directive or an assembly reference?)

How can I fix that?

[catherineabella]

gumagana sya sakin pero once na save na yung data, lumilipat lang lahat sa 1st coumn. paano po ba yun?

[jhongesell]

where is the source code of this project?, any repository please?

[cristianlegaspi]

nice, pano po kung mag duplicate yong record? how to fix?

[noelfernandez]

dgvEmployees.Rows.Add(i, xlRange.Cells[xlRow, 1].Text

error on this line ser.
Error CS1061 'object' does not contain a definition for 'Text' and no accessible extension method 'Text' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?)

[leonroutzounis]

The same thing is happening with xlWorkSheet.Close();

[AlkapOmar]

"dgvSSEN.Rows.Add(i, xlRange.Cells[xlRow, 2].Text, xlRange.Cells[xlRow, 3].Text, xlRange.Cells[xlRow, 4].Text"


the code above. how can i do it without copy/paste the code until [xlRow, 30]? can you help me? how to use for loop