No video :(

VB.NET And SQL - Datagridview Search Data Using Visual Basic .Net [ with source code ]

Подписаться 121 тыс.

Просмотров 205 тыс.

50% 1

Search Data In SQL And Display On DataGridView In VB Net
Source Code: 1bestcsharp.blogspot.com/2016/...
----------------- Check out my VB.Net Projects! -------------------
▶ Inventory Management System - bit.ly/Vbnet_Inventory_System
▶ Students Information System - bit.ly/2MsvUp7
▶ Contacts Management System - bit.ly/2GzxnGQ
▶ Hotel Management System - bit.ly/VbnetHotelSystem
▶ Real Estate Management System - bit.ly/VBNet_RealEstate
▶ Library Management System - bit.ly/3A7hrXE
▶ All My Programming Projects Here - bit.ly/2HrU8hK
▶ My Source Code Store Here - bit.ly/2OsC0TU
---------------------------------- VB.NET PRODUCTS -----------------------------------
▶ Get VB.NET Projects Bundle - bit.ly/VBNetProjectsBundle
▶ Take VB.Net Course - bit.ly/2wnNiVt
--------------------------------------------------------------------------------------------------------
Programming Projects:
1bestcsharp.blogspot.com/p/pro...
visit our blog 1bestcsharp.blogspot.com/
instagram: / 1bestcsharpblog
facebook: / 1bestcsharp
twitter: / 1bestcsharp_
subscribe: goo.gl/nRjPKk
C# And Java Programming Books
1bestcsharp.blogspot.com/2015/...
In This VB.NET Tutorial We Will See How To Search Records From SqlServer Database On Button Click Event
And Text Changed Event With Microsoft SQL DataBase Using Visual Basic .NET Programming Language.
subscribe for more tutorials
VB.NET And SQL Server Database Tutorials:
Connect SqlServer Database With Vb.net
• VB.NET And SQL Server ...
Select And Display Data From SQL Server Database Using Vbnet
• VB.NET And SQL Server ...
Insert Data Into SQLServer Database Using VB NET
• VB.NET And SQL Server ...
Update Data In Database Using Vbnet
• VB.NET And SQL Server ...
Delete Data From SQL Server Database Using Visual Basic .NET
• VB.NET And SQL Server ...
Search Values From SQL Server Database And Set It Into TextBox In Visual Basic .NET
• VB.NET - How To Search...
Populate ComboBox From SQL Values In VbNet
• VB.NET - How To Popula...
SQL Server Records Navigation Using Visual Basic.Net
• VB.NET And SQL Databas...
Datagridview Search Data Using VB.Net
• VB.NET And SQL - Datag...
Insert Update Delete
• VB.NET And SQL - How T...
Login Form With SQL Database
• VB.NET - How To Create...
VB NET Using SQL Stored Procedures
• VB.NET - Using SQL St...
Insert Image Into SQL DataBase
Part 1: • VB.Net - Insert Image ...
Part 2: • VB.Net - Insert Image ...
Retrieve Image From SQL DataBase In Visual Basic.net
• VB.Net - How To Retrie...
Retrieve Images From SQL DataBase Into DataGridView In VB.net
• VB.Net - Retrieve Imag...

Опубликовано:

8 сен 2016

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 64

@Moses2212 5 лет назад

This is the tutorial that i’ve been looking for couple days, thank you so much

@MoeBhelil 5 лет назад

man, i can't thank you enough, i've been looking for a tut to make it for 4 hours your's was the simplest and easiest to understand. thank you!

@meowowz 3 года назад

An old video but definitely helped me a lot! Thanks!

@AlisaScarlet 6 лет назад

Thank you! it worked for me although it doesn't have narration .. like ! (y)

@official_jsem4 Год назад

thank you very much for this man. It has really helped me here today and am really grateful for that. 🙏🙏🙏

@TakshvysDad 4 года назад

Thanks man. It helps

@mich.k8242 6 лет назад

Mine didn't work. It underlined fill and says 'overload resolution failed because no accessible 'fill' accepts this number of arguments'. It highlighted adapter.Fill() and said 'An unhanded exception of type 'System.InvalidOperationException' occurred in System.Data.dll. Additional information: The SelectCommand property has not been initialised before calling 'Fill' ''

@teegee4964 5 лет назад

THANKYOU!!

@Erick-ks5ee 4 года назад

Thanks man you are a genius

@vule562 7 лет назад

Can you make a new video how search date range with parameters using Store Procedure. Thanks for your great Tutorials It is very easy to follow even if there is no voice

@danielromero3806 3 года назад

Good morning, could you tell me that I should change to be used with an access database, I really appreciate it

@jayraldtajale8121 5 лет назад

Many thanks bro

@tejanaiduchintha7288 5 лет назад

Do I have to make any changes if I am using the sql server authentication other than the Windows authentication plz help

@johnnyIIdelatorre 2 года назад

thanks it works perfectly

@Demoned001 5 лет назад

Thanks!!

@jasonpeterson7986 Год назад

Nice! Thank you!☺

@nicador100 3 года назад

Thanks very much !!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@og_hannarosary 7 лет назад

DO you have another one (I mean this one) in Class and Forms? Lang: VB.net

@nicador100 3 года назад

Thanks very much !

@chillspyderz 7 лет назад

'SELECT * From Users WHERE CONCAT(fname, lname, age) like '%F%' equivalent code for access database coz i'm using access database as back end and not SQL. thanks

@aquillahdarkova7904 4 года назад

'CONCAT' is not a recognized built-in function name.

@misterjack347 4 года назад

thnx helped alot

@jinkaiser7645 6 лет назад

i'ts running but when i'm searching the other data is not disappearing but instead it's multiplying,, pls help

@Tactical_Style1994 5 лет назад

Love This

@erolmanlapaz 7 лет назад

is this sql injection free? is this parameterized??

@_yamid Год назад

Buen tutorial

@neraazzura6903 4 года назад

hallo , hello, I'm nera from indonesia. I can't understand the code (SELECT * From Users Where CONCAT.) can you help me explain again

@shawnbarbat7417 5 лет назад

is datagridviw1 correct?

@abdulaahimahamuudabdirahma7796 3 года назад

Bro can you tell me the meaning of CONTAC in your project.

@esraaalbdery3567 5 лет назад

شكراً

@juliusalbano2439 7 лет назад

Sir. Can you include also how to save the datagridview into sql...... datagridview does not have any binding source...... It would be a big help to my project as i am new to programming... thanks in advance

@atdastunisie 7 лет назад

Private Sub DataGridView1_CellClick(sender As Object, e As DataGridViewCellEventArgs) Dim index As Integer index = e.RowIndex Dim selectedRow As DataGridViewRow selectedRow = DataGridView2.Rows(index) Dim ID as Integer = selectedRow.Cells(0).Value.ToString Dim fname as String = selectedRow.Cells(1).Value.ToString Dim lname As String= selectedRow.Cells(2).Value.ToString Dim username as String = selectedRow.Cells(3).Value.ToString Dim password as String= selectedRow.Cells(4).Value.ToString >> then you Open connection addFunction(ID ,fname ,lname ,username ,password ) >>then you close connection End Sub

@alguzman6437 7 лет назад

HELLO WHERE DID YOU GET THAT CONCAT? users is your table name right? then concat is? 'SELECT * From Users WHERE CONCAT(fname, lname, age) like '%F%'

@1BestCsharpblog 7 лет назад

"CONCAT" takes 2 variable or more as arguments and concatenates them into a single string

@gurekodok 4 года назад

Thanks brüda

@gurekodok 4 года назад

You saved my day

@a.c6761 6 лет назад

CONCAT is not recognize in sql server 2008 what should i do??

@a.c6761 6 лет назад

please

@1BestCsharpblog 6 лет назад

i think CONCAT doesn't exist in 2008 try using +

@naimulislamrayan2447 4 года назад

what is concat?? 5:49

@ryokohonda4619 7 лет назад

Help, mine still have doesn't run even if there are no errors

@ryokohonda4619 7 лет назад

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: 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)

@martinpereira7000 4 года назад

BASED

@tejanaiduchintha7288 5 лет назад

I am getting an error which is error BC30451: 'connection' is not declared. What should I do Please help

@1BestCsharpblog 5 лет назад

you need to declare the connection variable first

@lloydsantos3537 7 лет назад

'CONCAT' is not a recognized built-in function name. How can i fix this sir?

@markchristianrubio4199 5 лет назад

Same

@markchristianrubio4199 5 лет назад

Pls reply co'z i need it :

@markchristianrubio4199 5 лет назад

My teacher run my code then put an apostrophe to searchbar, then after it says error ( he knew what will happen, he did it on purpose) please help me to restrict apostrophes

@hahuhuta800 5 лет назад

if (searchbar.txt = ";") { Msgbox("Error") }

@Ganzoi Год назад

what is the CONCAT?

@1BestCsharpblog Год назад

"The CONCAT() function adds two or more expressions together" - w3schools

@ryokohonda4619 7 лет назад

What is CONCAT?

@christianvicdechavez4920 7 лет назад

concatination

@mohammedmigbel4517 3 года назад

doesnt work

@hagnanbrandson1997 5 лет назад

Very nice video!!! Please could you give your email so that I can ask you some question?Thank you

@skykid1075 5 месяцев назад

I don't understand nothing

@jokoppl5883 5 лет назад

table ??

@1BestCsharpblog 5 лет назад

can youexplain your question ?

@jokoppl5883 5 лет назад

@@1BestCsharpblog Where does the table come from?

@1BestCsharpblog 5 лет назад

it's the name of the datatable => 4:04

@jokoppl5883 5 лет назад

@@1BestCsharpblog ok thanks

@vinjhuntan6062 4 года назад

hi guys

@raphsanchez95 2 года назад

Hi, I'm doing an experiment on a lottery 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?