Hello Sir, I tried following your method and it fail if you leave any of the text boxes empty while inputing the data because you havent put any protector on the boxes. I will be thankful if you can help in this case.
To do it. Purchase a domain and hosting with supporting SQL Server. Create a database in hosting. Put the connection string on web.config file, then upload the application into httpdocs. browse your domain. thsnks.
Hi bro I am new to WPF and .net I need your help how to contact you if u please help me because it explanation very clearly and understand clearly please help bro.
Please see the code sample. Dim connect As New SqlConnection("Data Source=ROWSHAN-PC\ROWSHAN_PC;Initial Catalog=CRUDTutorial_DB;User ID=sa;Password=row@129") Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim productid As Integer = txtproductID.Text Dim itemname As String = txtitemname.Text Dim specification As String = txtspecification.Text Dim unit As String = Dropunit.SelectedValue Dim color As String = Radiocolor.SelectedValue Dim insertdate As DateTime = txtdate.Text Dim opening As Double = txtopeningqty.Text Dim status As String = "" If Checkregular.Checked = True Then status = "Regular" Else status = "Irregular" End If connect.Open() Dim command As New SqlCommand("Insert into ProductInfo_Tab values ('" & productid & "','" & itemname & "','" & specification & "','" & unit & "','" & color & "','" & insertdate & "','" & opening & "','" & status & "')", connect) command.ExecuteNonQuery() MsgBox("Successfully Inserted", MsgBoxStyle.Information, "Message") connect.Close() ListProduct() End Sub
You have to type all the data again to update a record (24:55)? No real-life application would have an update function like that. There should be an "Edit" button next to each record. Clicking it should bring up the form with existing data already filled in, letting the user make changes where needed -- not retype everything, are you kidding me? But of course you can't do that, because the Gridview control doesn't let you access each row's data. The Gridview control is garbage here, and you are better off with a plain HTML table that gives you greater control. That's something ASP classic can do. Same with the delete function -- the user shouldn't have to type anything to delete a record.
You are really great. Pleased to see your comment. Yes, I will follow your suggestion. Actually, I prepared this tutorial focusing the user permission. But your suggestion is best. Thanks.
Quite resourceful video but please i request you to stop using accent.There's no shame in using indian accent for english.Otherwise the video is really very good and well explained
@@ProgrammingGeek Sir I'm having difficulty in my project, it's a web app in visual basic,But i face problem when i do crud operation, Can you do for a single one,i will carry on further, please..
@@ProgrammingGeek I tried but failed to do crud,I can do in mvc but this is little different, I will send you the app,you look at it plz.. And do it for a single form,i will carry out further. .
Good question. You should add Ajax toolkit extender to get extender. Visit This link ruclips.net/video/O6qEbEG1adE/видео.html Download Ajax tool kit .dll from below link. drive.google.com/file/d/1w7GQvkTxNZdOOTqqZfMe_V3Y1lzYq9Jh/view?usp=sharing
Please see the code sample Dim connect As New SqlConnection("Data Source=ROWSHAN-PC\ROWSHAN_PC;Initial Catalog=CRUDTutorial_DB;User ID=sa;Password=row@129") Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim productid As Integer = txtproductID.Text Dim itemname As String = txtitemname.Text Dim specification As String = txtspecification.Text Dim unit As String = Dropunit.SelectedValue Dim color As String = Radiocolor.SelectedValue Dim insertdate As DateTime = txtdate.Text Dim opening As Double = txtopeningqty.Text Dim status As String = "" If Checkregular.Checked = True Then status = "Regular" Else status = "Irregular" End If connect.Open() Dim command As New SqlCommand("Insert into ProductInfo_Tab values ('" & productid & "','" & itemname & "','" & specification & "','" & unit & "','" & color & "','" & insertdate & "','" & opening & "','" & status & "')", connect) command.ExecuteNonQuery() MsgBox("Successfully Inserted", MsgBoxStyle.Information, "Message") connect.Close() ListProduct() End Sub
Awesome video this most important for learning.
So kinds you. Please keep in touch!!!
It's very helpful tutorial for me. I have got much help from programminggeek. Thanks 😊😊☺️
Thanks for your comment.
Very simple and very helpful, thnx a lot.
Thanks for your comment. Please keep in touch!
Thank you for creating these videos.
My pleasure! Please keep connected!
Thank you for this beautiful explanation. I am grateful
Thanks for this excellent comment. I am pleased to see your comment
Extremely helpful tutorial. Thanks for uploading.
شكرا جزيلا شرح ممتع .
Thanks for your comments. Please keep in touch!!🌹
Specially thanks for this video.
You are very kind. Thanks.
Great tutorial ever seen. Thanks 😊
nyc explanation
Thanks for sharing. You are very kind. Please keep in touch!!!
Hello Sir, I tried following your method and it fail if you leave any of the text boxes empty while inputing the data because you havent put any protector on the boxes. I will be thankful if you can help in this case.
Hi, can you make a tutorial for uploading file into SQL Server? It would me really helping me a lot! Btw your tutor is awesome, thanks!
Can you post a video on how to make it work online. It will be of great help.
To do it. Purchase a domain and hosting with supporting SQL Server. Create a database in hosting. Put the connection string on web.config file, then upload the application into httpdocs. browse your domain. thsnks.
@@ProgrammingGeek thanks a lot! Keep up your good work.
Very nice
Thanks. Please keep in touch!
Nice
Thank you. Please keep in touch.
nice job
Thanks for the visit
Cool
Love your comment. Thanks
thanks sir.......
Most welcome🍁. Keep connected please.
thank you
How Do I insert Table in Visual Studio 2022 ??? I couldn't find the table button on the menu
Hi bro I am new to WPF and .net I need your help how to contact you if u please help me because it explanation very clearly and understand clearly please help bro.
How can I help you?
Can you share with me the code repository?
Please see the code sample.
Dim connect As New SqlConnection("Data Source=ROWSHAN-PC\ROWSHAN_PC;Initial Catalog=CRUDTutorial_DB;User ID=sa;Password=row@129")
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim productid As Integer = txtproductID.Text
Dim itemname As String = txtitemname.Text
Dim specification As String = txtspecification.Text
Dim unit As String = Dropunit.SelectedValue
Dim color As String = Radiocolor.SelectedValue
Dim insertdate As DateTime = txtdate.Text
Dim opening As Double = txtopeningqty.Text
Dim status As String = ""
If Checkregular.Checked = True Then
status = "Regular"
Else
status = "Irregular"
End If
connect.Open()
Dim command As New SqlCommand("Insert into ProductInfo_Tab values ('" & productid & "','" & itemname & "','" & specification & "','" & unit & "','" & color & "','" & insertdate & "','" & opening & "','" & status & "')", connect)
command.ExecuteNonQuery()
MsgBox("Successfully Inserted", MsgBoxStyle.Information, "Message")
connect.Close()
ListProduct()
End Sub
You have to type all the data again to update a record (24:55)? No real-life application would have an update function like that. There should be an "Edit" button next to each record. Clicking it should bring up the form with existing data already filled in, letting the user make changes where needed -- not retype everything, are you kidding me? But of course you can't do that, because the Gridview control doesn't let you access each row's data. The Gridview control is garbage here, and you are better off with a plain HTML table that gives you greater control. That's something ASP classic can do. Same with the delete function -- the user shouldn't have to type anything to delete a record.
You are really great. Pleased to see your comment. Yes, I will follow your suggestion. Actually, I prepared this tutorial focusing the user permission. But your suggestion is best. Thanks.
Quite resourceful video but please i request you to stop using accent.There's no shame in using
indian accent for english.Otherwise the video is really very good and well explained
Thanks for your suggestion.
my xampp not appearing on db lists
More video this related
Thanks for your comment. I will do. Please keep connect.
Is there a guide on how to download this sql?
Visit this link to download and install SQL ruclips.net/video/kJRmhLOwNvY/видео.html
how to use extender link is where
Please try and let us know.
can i do this example with visual studio 2012 or 2013
Sure, You can do this example in VS 08- VS17. Thanks.
@@ProgrammingGeek thanks a lot
Sir i need a littlw help regarding crud operation in my app,it's a little difficult, Can you help me plz..
tell me what difficulty you have faced? i will try to help.
@@ProgrammingGeek Sir I'm having difficulty in my project, it's a web app in visual basic,But i face problem when i do crud operation, Can you do for a single one,i will carry on further, please..
@@abid_khan143 Would you please tell me what problem you just faced. send me the error message so that i can understand about the problem. Thanks
@@ProgrammingGeek I tried but failed to do crud,I can do in mvc but this is little different, I will send you the app,you look at it plz..
And do it for a single form,i will carry out further. .
@@ProgrammingGeek please share your email.
i do not get option for extender in insert dat text box. please explain
Good question. You should add Ajax toolkit extender to get extender. Visit This link ruclips.net/video/O6qEbEG1adE/видео.html
Download Ajax tool kit .dll from below link.
drive.google.com/file/d/1w7GQvkTxNZdOOTqqZfMe_V3Y1lzYq9Jh/view?usp=sharing
Thank you very much
1000000000000000000000000000000 thanks
please can you give me .aspx source code in comment ?
To get the code go to the description box.
Source code please😅❤
Please see the code sample
Dim connect As New SqlConnection("Data Source=ROWSHAN-PC\ROWSHAN_PC;Initial Catalog=CRUDTutorial_DB;User ID=sa;Password=row@129")
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim productid As Integer = txtproductID.Text
Dim itemname As String = txtitemname.Text
Dim specification As String = txtspecification.Text
Dim unit As String = Dropunit.SelectedValue
Dim color As String = Radiocolor.SelectedValue
Dim insertdate As DateTime = txtdate.Text
Dim opening As Double = txtopeningqty.Text
Dim status As String = ""
If Checkregular.Checked = True Then
status = "Regular"
Else
status = "Irregular"
End If
connect.Open()
Dim command As New SqlCommand("Insert into ProductInfo_Tab values ('" & productid & "','" & itemname & "','" & specification & "','" & unit & "','" & color & "','" & insertdate & "','" & opening & "','" & status & "')", connect)
command.ExecuteNonQuery()
MsgBox("Successfully Inserted", MsgBoxStyle.Information, "Message")
connect.Close()
ListProduct()
End Sub
Ok yuoe
Thanks for your comment.
CAN YOU MAKE SMALL WEBSITE USING ASP.NET WITH VB LANGUAGE
Ok, I will