C# Tutorial - Insert Update Delete View data from database using ADO.Net | FoxLearn

[@Andrew-xb8hl]

Hi Fox Learn, at the 9:00 mark how did you alter the procedure without saving the changes to your table, you got a error saying you could not save the changed table but the altered procedure still executed, when i executed mine i got a error "Birthday column could not be found". i did change it in options to save modified tables but i didn't see you do it ?

[@horaciocolinagalvan633]

Fox learn, I need help in this part "using (var db = Db.FromConfig("cn"))", "Db doesn´t have a definition for 'FromConfig'

[@SaluranSains]

What will happen if you try using (var db = DbFactory.FromConfig("cn")) for me it work

[@sangeeth2250]

Did you get the answer??

[@sreekuttanm8034]

in second new query on 9:00 min , which is used to update the column...,, i can't execute it, that keeps showing error "'''''''' Msg 207, Level 16, State 1, Procedure sp_Students_update, Line 13 [Batch Start Line 0] Invalid column name 'Students'. "'''' i did exactly what you did in this video.. Please tell me why this happening

[@danyboucher5320]

Thanks. Your tutorial was exactly what I needed.

[@foxlearn]

You're welcome. Thank you !

[@marclukombo2]

Thank you very much for the tutorials of the developed applications of Window form. Couldn't you publish the codes.

[@GantugsSuhkbaatar]

System.Data.SqlClient.SqlException: 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)'

[@chitoreyquinto]

I tried this tutorial and its great. I also encountered problem with NuGet package of ADO because its targeted higher .net framework and i just change my target to what it should be. The only problem that I cannot solve using the latest version of VS2017 with latest dotNet framework is the metrotextbox and the metrogrid.. it shows in your video, that when you type something in metrotextbox the content of the selected grid changes also. Which in my test it wasn't.. Can you enlighten me how do you manage to link the metro textbox to the metrogrid it wasn't working in my side.

[@chitoreyquinto]

oh sorry i got it the metrobox itself has binding source thanks.... great video

[@chitoreyquinto]

i already found the problem i forgot to bind the data of textbox to the binding source... great tutorial

[@trandominhkhoi]

'Db' does not contain a definition for 'FromConfig'? Help Me. Many Thank

[@sangeeth2250]

Did you get the answer???

[@federicopurisima5432]

Hi Fox Learn. would you please tell me about this error. Exception thrown: 'System.ArgumentException' in mscorlib.dll An unhandled exception of type 'System.ArgumentException' occurred in mscorlib.dll Keyword not supported: 'catalog'.

[@rjfbrito]

Hi, i installed MSV2016 with framework 4.6.2. How can i work around to get it working with 4.5.2 ? Severity Code Description Project File Line Suppression State Warning The primary reference "Net.Code.ADONet, Version=1.0.0.0, Culture=neutral, processorArchitecture=MSIL" could not be resolved because it was built against the ".NETFramework,Version=v4.6.2" framework. This is a higher version than the currently targeted framework ".NETFramework,Version=v4.5.2". CRUD Thanks!!

[@arbertguanzon9391]

just set-up the framework from lower versions before you started.. if you already started a project go to solution view click the main solution and find properties then change the framework you want..

[@thanhtan1205]

Can you do this project but for WPF - Data Binding?

[@arbertguanzon9391]

what if i don't want to change the auto increment on the ID ? which is a primary key ?

[@arbertguanzon9391]

using (var db = db.FromConfig("cn")) i got error on this one :D hahaha sorry for bothering but i found your tutorial more interesting then :D

[@foxlearn]

If you don't want to use auto increment you should enter a value for your ID, because your ID is a primary key. 'cn' is a connection string name, you should create a connection string in the app.config file. Thank you !

[@arbertguanzon9391]

@@foxlearn can you send me some connection string for non increment primary key ??

[@foxlearn]

Connection string don't change, just set primary key is not auto increment

[@l3ecauseOfYou]

what happened about Fox Learn? Why you stop to updated tutorial?

[@foxlearn]

I'll update more tutorials as soon as possible. Thank you so much

[@l3ecauseOfYou]

Thank you too.

[@nawintalari3412]

i cant see the control metrogrid in my toolbox and i can get metrotoggle,label etc

[@japhethjay4880]

I don't have the metro toolbox icons, what can i do to make it work, i did restart it, restart the system but yet they did not appear, any ideas

[@imadouguahi9455]

you should add it

[@artandpaintingofficial]

Fox learn please make tutroial adding records from gridview to database as many rows

[@foxlearn]

OK. Thank you for your suggestion

[@MHQ.87]

Nice

[@foxlearn]

Thank you

[@MHQ.87]

Welcome

[@abdullahtanveer5901]

sir please make a video on how to connect fingerprint scanner to the C# form and get the image of fingerprint. please...

[@foxlearn]

OK. Thank you for your suggestion. :( i haven't got device to make demo

[@makay9674]

Ah yes quality "sam onella academy" music

[@arbertguanzon9391]

how did you do that >>??

[@foxlearn]

What do you mean? can you describe more details. thank you !

[@arbertguanzon9391]

@@foxlearn right now Im a student who wants to create a CRUD which is for my fellow student also.. stdutent information that able to store Final grades of the a student from 1rst-year till last.. im getting head aches :C

[@adrianocarvalho5830]

303/5000 I want to make a desktop application, which can be installed on the touch screen, where the administrator can drag photo from one section to another, everything on the dashboard, at the same time controls each employee's time in a certain section to work, thanks for the help, I want to do in C # with database.

[@sikandarmehmood9281]

@fox learn i think u should give real world application Concepts rather than just every time save,update,search.....

[@foxlearn]

OK. Thank you for your suggestion

[@damianandrzejczyk773]

My friend I have that error System.InvalidOperationException: "The objects added to the BindingSource list must be of the same type."

[@damianandrzejczyk773]

here : studentBindingSource.Add(new Student());

[@himanshugoyal3862]

Same problem with me Damian.

[@fpv_am]

19:27

[@Diskretisierung]

I added Miss Vicars

[@brainbytes1202]

WHERE DO YOU FIND THIS using Net.Code.ADONet;?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?

[@secretluver]

That Text-to-Speech grill sounds like such a babe

[@foxlearn]

Thank you !

[@Prashanth_Vlogs2213]

Can you send me code

[@ruellacaba9664]

please send me source code asap

[@le-manu298]

Why make it so long and hard to follows :) I can complete the whole project within 10 minutes. There are so many steps you can skip and use the query builder to write it instead.