I really like the part that you are explaining to your viewers what a specific code is for and what does it do. I've watched many tutorials related to c# and database but yours are more helpful. Others were just doing the code without explaining what's happening with the code. Thanks for that.
You are really great as well as your comment. Today I am feeling lucky to see your comments. Please keep pray for me to do more better and keep in touch. Thanks. 🌷🌹🌹🌷
THANK YOU VERY MUCH SIR. I WAS TROUBLED BECAUSE MY DATAGRIDVIEW WONT DISPLAY EVEN CHATGPT WONT GIVE ME A CONCRETE CODE. BUT YOURS WAS SPOT ON SO THANKSS
O problema nesse codigo que voce nao fez foi criar o codigo de nao ter o mesmo ID de produto quando voce tenta fazer o mesmo ID do produto ele retorna um error this line -> cmd.ExecuteNonQuery(); you can try make two produtct with same PRODUCT ID will get error why say exist on DB
@@ProgrammingGeek And what if i want to add something like when you click a element in the table below i would like the boxes to fill with its name and other properties.
Check record whether the record exist or not in database before performing insert and update operation. Just watch this tutorial ua-cam.com/video/svPQ1Ze6uTs/v-deo.html
Hi i have this error message, do you know what it means? "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated"
Hi, I'm doing an experiment on a lottary table which contains a "date" (column1) the "wheel" (column 2) and the other 5 columns with numbers, which would be the draws. I can't search for 5 numbers chosen by me in no particular order. For example: The numbers to look for are: 22 34 67 87 90, in the search if there is such an extraction, it finds it only in order or in sequence as I write it, while my goal would be that the 5 numbers can be found even if in different positions, for example 22 not as first extract but second or third, fourth and finally fifth, so for all the others, since the combinations are different and the numbers can come out on different columns. How to do?
In my point of view you can do it by using an array and a for loop then load data into datatable. 1 put the no into array. 2. search number in for loop using array list. during search load data into datable then load datatable into your expected control like gridview. Thanks
when i follow in this video at the first time i got error index of lenght ok. i try again i got error in window machine in region and language am not change in the correct way must to change Buddhist calendar to Christian era if you are a asian machine if you change you got output the same video. i thank you a lot for this video.
Nice question. First of all don't use primary key in ID column. you can use Unique Key, If you want to put ID manually you can put after delete. If want to insert automatically use MAX +1 function. Thanks.
@@ProgrammingGeek actually It's a bad idea about putting primary key on a column. How about when two clients are trying to insert a new row at the same time. Thanks for clarification
@@hatsu1101 In this case don't use textbox for ID. after inserting a record user can see the ID of this record. Add a where clause to get the record with name and one more field so that you can get the inserted record. by following it, no problem occurred if 100 clients try to insert same time. If you have better solution can inform me please.
@@ProgrammingGeek dont use SqlConnection inside Events form, create a new project and create Entity class for properties, another class call DbProvider with SqlConnection and SqlCommand
@@zerohf1 You are right bro. Some of viewers watch specific portion of video. So if he see only update or delete he may miss and failed to reach result. But i will remember your suggestion for next tutorial. Many many thanks.
@@ProgrammingGeek Dear bro: we could get a main concept of CRUD in c#, the other initiative is up to viewers : keep continue your roadmap ignore the meaningless feedbacks. WE LOVE YOU!
thank you so much sir. the error handling method is awesome. pls upload more videos.
Thanks for your comment. Ok I will upload more helpful video. Please keep in touch!
I really like the part that you are explaining to your viewers what a specific code is for and what does it do. I've watched many tutorials related to c# and database but yours are more helpful. Others were just doing the code without explaining what's happening with the code. Thanks for that.
You are really great as well as your comment. Today I am feeling lucky to see your comments. Please keep pray for me to do more better and keep in touch. Thanks. 🌷🌹🌹🌷
simplified and best so far on youtube
You are very kind. Thanks for your comment. Please keep connected.
Awesome go ahead and post more C# videos...
Thanks for your comment. I will try my level best to do better. Please keep connected.
thank for your teaching
Thanks for your comment. Keep learning!
Thank you so much 27 min video but i worked 6 hours
Glad it helped🌹
I have tried enough and finally got such helpful tutorial. thanks sir. please upload datagridview selected event tutorial.
I will upload very soon
Nice tutorial. Thanks 😊 carry on
You are very kind. thanks
Nice tutorial sir. Love from Sri lanka
Thanks bro. I love all of my fan. Please keep in touch
This is complete tutorial. Any body can learn crud operation from this tutorial. Thanks for this tutorial. Please make tutorial from begin to end.
Thanks for your response.
Thanks for this complete tutorial.
thankk youuu🤩
Pleased to see your comment. Please keep connected.
Wow! super awesome tutorial thanks
Thanks for your comments. Please keep in touch ☺️
Awesome go ahead. Create more tutorial.
I will try my best
Very Nice. Big like
Thanks for your heart touching comment. Please keep connected
Bro this is very Helpful thank u very Much❤❤❤❤🎉🎉
Thanks for your comment. You are very king. Please keep connected!!!
Thank you so much for your tutorial sir
You are very kind. Thanks you too for your valuable comment. Please press bell icon to be connected with me.
@@ProgrammingGeek i have done it sir
@@maulanamalikibrahim1680 Pleased to see it.
Nice Tutorial. thanks sir.
great tutorial
Glad you think so! Please keep connected.
Thanks a lot bro it's helped a lot to learn
Glad it helped
Awesome tutorial. thanks for good description with annotation.
Glad it was helpful! Keep in touch
Very nice tutorial ever seen. Please upload a tutorial using linq.
As soon as possible i will upload that tutorial. thanks.
outstanding. thanks sir. very nice intro.
Thank uuu soo much Sir😎❤I did it!!!!
Great 👍 Please keep connected.
Thank you sir! It helps me a lot .
Thanks for your comment bro.
Thank You So Much
You're most welcome
Beat video I've ever seen on CRUD👌👌👌
Thanks for your comments 😃😃. You are very kind.
THANK YOU VERY MUCH SIR. I WAS TROUBLED BECAUSE MY DATAGRIDVIEW WONT DISPLAY EVEN CHATGPT WONT GIVE ME A CONCRETE CODE. BUT YOURS WAS SPOT ON SO THANKSS
You are very kind. Thanks for your comment. Please keep in touch!!!🌹
thank you so much
You're welcome! Please keep connected.🌷🌷🌷
Super tutorial
Thanks for your comment.
Pls make every video with error ... Its very important for beginner... I will never forgot bcz of this ... It feels like im doing it .. 😊
Thanks for your comment. I will make each tutorial including bug fixing.
Nice sir.
Keep watching
thanks sir. please upload datagridview selected event tutorial.
Already uploaded
Its helped me a lot.
wow thanks
Most welcome!! Please keep connected
Very helpful
Thanks for your valuable comment. Please keep in touch!
Very good tutorials. Please upload CRUD projects with Foreign Table relations
Thanks for your comment. I will
Hello Sir, do you have written tutorial/blog for these videos? Thank you very much.
Not yet
Bro, you have just saved my back. That is information what you need here, whithout some another stuff.
Glad to hear it!
Hi sir I need your help please 🙏
There are errors in
Command.ExecuteNonQuery
How can I fix it 🙏🙏🙏
write the code properly. check the statement in SQL. Hope you will be succeeded.
are the sample projects anywhere I can access
yes. but it should be in same network.
Great Tutorial thank you. My datagrid only loads after insert and not on load. any ideas?
call the method in page load event.
O problema nesse codigo que voce nao fez foi criar o codigo de nao ter o mesmo ID de produto quando voce tenta fazer o mesmo ID do produto ele retorna um error this line -> cmd.ExecuteNonQuery(); you can try make two produtct with same PRODUCT ID will get error why say exist on DB
Product id is primary key. can't insert duplicate value in primary key/unique key column.
ummaaaahhh
Thanks for your comment. Ummaaahhh. Keep connected.
how do i make the boxes clear after i insert or delete an item
very easy. just put textbox1.clear(). or textbox1.text="";
@@ProgrammingGeek Thanks a lot , been a huge help.
@@ProgrammingGeek And what if i want to add something like when you click a element in the table below i would like the boxes to fill with its name and other properties.
When i update the rows, the DataGridview displays duplication rows, how can I rectify the issue
Check record whether the record exist or not in database before performing insert and update operation. Just watch this tutorial ua-cam.com/video/svPQ1Ze6uTs/v-deo.html
Hi i have this error message, do you know what it means?
"The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated"
Check your datatype. Make sure that it is datetime. thanks
Hi, I'm doing an experiment on a lottary table which contains a "date" (column1) the "wheel" (column 2) and the other 5 columns with numbers, which would be the draws. I can't search for 5 numbers chosen by me in no particular order. For example:
The numbers to look for are:
22 34 67 87 90, in the search if there is such an extraction, it finds it only in order or in sequence as I write it, while my goal would be that the 5 numbers can be found even if in different positions, for example 22 not as first extract but second or third, fourth and finally fifth, so for all the others, since the combinations are different and the numbers can come out on different columns. How to do?
In my point of view you can do it by using an array and a for loop then load data into datatable. 1 put the no into array. 2. search number in for loop using array list. during search load data into datable then load datatable into your expected control like gridview. Thanks
when i follow in this video at the first time i got error index of lenght ok. i try again i got error in window machine in region and language am not change in the correct way must to change Buddhist calendar to Christian era if you are a asian machine if you change you got output the same video. i thank you a lot for this video.
You are very kind. Pleased to see your comment. It will be helped to the viewers. Thanks
ples help me i have error
command.ExecuteNonQuery();
whay
How to re-assign ID after delete?
Nice question. First of all don't use primary key in ID column. you can use Unique Key, If you want to put ID manually you can put after delete. If want to insert automatically use MAX +1 function. Thanks.
@@ProgrammingGeek actually It's a bad idea about putting primary key on a column. How about when two clients are trying to insert a new row at the same time. Thanks for clarification
@@hatsu1101 In this case don't use textbox for ID. after inserting a record user can see the ID of this record. Add a where clause to get the record with name and one more field so that you can get the inserted record. by following it, no problem occurred if 100 clients try to insert same time. If you have better solution can inform me please.
i love you
Love you too my friend
I did the exact code as you. But for me, the gridview doesn't update everytime I click the button, it inserts only after I close and start again
Call the method in button load event to load record during button click. Thanks
my data grid view isnt function
Please check again. I have checked Its working well. Thanks for your comment.
sir i have error here where is text book i cant solve it T_T
This is text box. you can get it in ToolBox.
@@ProgrammingGeek bro in inser clickbox code problem I had error can I email you?
winforms...
it so horrorly...
use WPF please
OK I will
why don't use interface ??
bro can you give me the source codes.?
simply you can give me the codes with paste in on here. Thanks XD
Source code available in the description box.
The way you explain should be changed, it's not clear . ... Remaining all its good
Thanks for your suggestion.
this code is a very bad practices..
Thanks for your comment. Would you please suggest us good practices!!!!
@@ProgrammingGeek dont use SqlConnection inside Events form, create a new project and create Entity class for properties, another class call DbProvider with SqlConnection and SqlCommand
@@zerohf1 You are right bro. Some of viewers watch specific portion of video. So if he see only update or delete he may miss and failed to reach result. But i will remember your suggestion for next tutorial. Many many thanks.
@@ProgrammingGeek Dear bro:
we could get a main concept of CRUD in c#, the other initiative is up to viewers : keep continue your roadmap ignore the meaningless feedbacks. WE LOVE YOU!