C# Tutorial - Insert Update Delete Filter data in DataGridView | FoxLearn

[@MauricioCaterino]

Excellent video. Look forward to see a video on master / detail with datagrid using dapper for CRUD operations, no data binding, no Entity Framework. A Northwind Order and Orders Detail will do just fine.

[@foxlearn]

OK. Thank you for your suggestion. I'll make as soon as possible !

[@RomuloMagalhaesAutoTOPO]

Very clear. No comments. Very useful for me.

[@ThaoMeoTV]

thank Lucy fox for your videos

[@LeadSoft_Placement_Academy]

Awesome work.... Learn alot from u r channel

[@foxlearn]

You're welcome. Thank you so much !

[@kenankayaci]

hi, i have implemented this example of yours for a table located on the sql remote server. Adding records to the table is running. Delete and update process do not work. What is the problem according to your opinion...

[@programmmerr]

Excellent video. Tyvm!

[@adamzbudniewek4704]

in the future of countinue Alturos - you can show how to learn machine to detect own picture for example detect logo fox learn on pictures :) Please thumbs up

[@foxlearn]

OK. Thank you for your suggestion. Let me try to research !

[@adamzbudniewek4704]

@@foxlearn Thank you so much. I'm waiting patient for this! :)

[@jasonkleinhanstechnologies685]

This is great, i have one concern, how do you add multiple checkboxes

[@alirezaabedi1885]

gooood

[@foxlearn]

Thank you so much !

[@yunisahmed4772]

thanks a lot, do you have lessons of sql server stored procedures how to use in C#

[@duyenle2507]

Thank you. But how can I update this gridcontrol in the database? I looking forward to hearing from you

[@charafeddine9220]

Hello Foxlearn, you are the best, How can i save changes in real database in SQL Server after each action (after each button click) please !!

[@saradibin6753]

very useful tutorial thanks

[@foxlearn]

Thank you !

[@hermenegildogppp9774]

Hello I would like to learn how to make a user access form. It registers the user name, the time of the start of the session, the time that the session ended, the day that was in the system, and the time that was left in the system. Example: Gpp user logged in at 10:30 am, finished at 8:21 pm the other day. On 10-10-2017, it stayed in the system for 34h51 C#-Windows form Application

[@foxlearn]

OK. Thank you for your suggestion ! I'll make the tutorial as soon as possible

[@aravindswamy4742]

My Visual Studios toolbox doesn't have"Navigation and layout' Category. How do you add it?

[@ahmedarslan8615]

Great tutorial thanks

[@foxlearn]

Thank you so much !

[@icucky878]

Can u do how to make an auto updater for your application in C# tutorial Please + and I love u so much fox learn I don't know why u are getting low views but u are the best fox learn 💗

[@foxlearn]

OK. Thank you for your suggestion !

[@MauricioCaterino]

If it is not too much to ask, I would like to see this video but doing a Master / Detail CRUD (Northwind Order and Order Detail). Using data binding and Entity Framework.

[@foxlearn]

OK. Thank you for your suggestion. I'll make as soon as possible !

[@BahawalTV]

Devex layout manager is a wonderful tool.

[@foxlearn]

Thank you !

[@nathankim7647]

thank you fox for your videos, why do you delete mainForm every time? is there a reason?

[@foxlearn]

Because we replaced it with devexpress form

[@mrkhuslen8402]

Thanks a lot

[@bestdynamicfitness]

Some time combobox data savechanges() not save. how to fix it ?

[@AK-Star007]

Thanx

[@kierabdul6173]

Can you use xampp mysql instead for database? Thank you. I will wait for the another version of this tutorial using xampp mysql

[@foxlearn]

Sorry, I'm not using php

[@YUSUFu5i]

Can vb.net datagridview be use like website table that use javascript that enable its row to be click and bring all information on that row to another page which in vb.net case is another form, then we can manipulate the data? Sorry if my question is somewhat confusing..

[@foxlearn]

Yes, you can get current object, then process on the current object

[@YUSUFu5i]

@@foxlearn thank dude..

[@SithuBoy]

Thankyou❕

[@foxlearn]

You're welcome. Thank you !

[@baraawaleed6753]

i wonder if you can help me with this how did you make the voice of the video .. and thank you in advance for all your effort

[@foxlearn]

You can use natural text to speech if you don't have a recording studio

[@baraawaleed6753]

@@foxlearn ok I will try it and give you a feedback about it ,thank you , you are the best

[@KarakalLatino]

Thank you very much, so can you do that with N-CAPAS with pre-designed Form DB and Form showing dataGrid in one form and the CRUD in child form....Please

[@foxlearn]

OK. Thank you for your suggestion. I'll make soon !

[@julsfadriquelan3230]

the add and delete button is not working

[@tariq4061]

I don't see fields like you do when you use binding datasource,it doesn't table columns ,Please help me out, thanks in advance!

[@foxlearn]

You should add a binding source to gridview control

[@tariq4061]

@@foxlearn ok thanks!Can i bind multiple tables with datalayoutcontrol?

[@hassan0sahara]

Excellent , please I Repeat my request to print items to more than one printer That Each item belong to category

[@foxlearn]

Can you describe more details. not clear your idea. Thank you !

[@hassan0sahara]

Fox Learn Sure If we have more than one category in database and more than one printer And we made settings during the printing The first category will print to the first printer and second category will be printing to the second printer... etc This is the idea Thanks I wish to make tutorial to this idea In the next video

[@dotsoftwareangola6658]

hello, how to check if customer id already exist in database ?

[@foxlearn]

you can use the sql query (select *from customer where customerId = @customerId)

[@massimopaone91]

Can I use Data Model Framework with MySQL ?

[@foxlearn]

Yes, I'll upload tutorial soon

[@arbertguanzon9391]

how did you use Databindings,datasource,datatables etc in your other video i tried what you did but its a null, :C

[@foxlearn]

OK. I'll make tutorial, hope help you solve your problem !

[@arbertguanzon9391]

okay your such a blessing on disguise :D

[@esabzayi]

not updating database?

[@foxlearn]

You should save data

[@HK--HK]

How can add LookupEdit to form

[@foxlearn]

OK. Thank you for your suggestion !

[@RafaelSousa-wn5gf]

Good tool. What is song in 14:04

[@foxlearn]

One fine day. thank you !

[@RafaelSousa-wn5gf]

@@foxlearn Sorry, I'm not able to find that song. Is there any way to send the link? I loved that sound to listen to the background.

[@foxlearn]

Go kzbin.infomusic, then filter One fine day

[@arbertguanzon9391]

id number does not allow nulls ... why ???

[@foxlearn]

Because the ID number is a primary key

[@arbertguanzon9391]

@@foxlearn then must be a primary key is a auto number ?? i must used ID number as a primary key with no auto number attributes. is it possible ?

[@foxlearn]

Yes, userid is a primarykey and you don't need to set auto number to userid

[@hajersassi2039]

@@arbertguanzon9391 if the primary key is an auto number the textedit must be readOnly or delete it from layout contorl

[@morsheddld]

Is DevExpress paid? is there any free version ?

[@foxlearn]

Paid

[@brijesh7040]

Is devexpress component free ?

[@MauricioCaterino]

It is not free. It has a suscripction cost. www.devexpress.com/buy/net/

[@foxlearn]

Not free, you should buy it

[@danielpais9317]

how can a I make the data from database on sql delete on datagrigview and on database also?

[@foxlearn]

Can you describe more details. thank you !

[@danielpais9317]

@@foxlearn I made a database in the application SQL, then I connected to visual studio. I dragged datagridview to the form and it shows the save delete buttons etc. I have no code on the delete button, it just deletes data at the moment only form datagridview and doesn't permanently delete from database I really need to know, and if you are not understanding me I wish I could tell you by prints, email pls isn't really important to me

[@danielpais9317]

The datagridview I dragged was not from tool box, was directly by the data source, I dragged de table to the form

[@dezzp8961]

hey sir can you make tutorial how to get member number from whatsapp group member

[@foxlearn]

Thank you for your suggestion !

[@ozgetoprak4546]

it does not update database

[@foxlearn]

Please check your code again. i think you miss something

[@esabzayi]

facing same issue have you solved it?

[@hajersassi2039]

i had the same problem and i was solved it by using the same dbcontext for all events , just instantiate a new dbcontext in the class not in every button clic event

[@adilkevin6220]

How to build online complier in asp.net or MVC?

[@foxlearn]

Thank you for your suggestion. Let me research !

[@adilkevin6220]

@@foxlearn Thanq for your reply M looking forward to see a video on it shortly