How to Search data into SQL Server in C# ADO.net using connected class Part-04
In this I have shown how to Search data into SQL Server in C# ADO.net using connected class We have to follow the steps mentioned below: 1. Create database: See part 01 (If Required) 2. Design an user interface: : See part 01 (If Required) , you can do it in your own way 3. Add connection to Database in Visual Studio for more privilege like – connection string creation, visualization of SQL Server database field structure 4. Add required namespace like System.Data and System.Data.SqlClient 5. Create SQL Connection For Search 6. Build SQL Command for Search 7. Search Value with ID 8. Put the value in SQLDataReader by Executereader method 9. Using read method put the value into textbox using getvalue method 10. Show message in level 11. In else part clear all text box 12. Close the connection We all know Ado.net uses for connecting database and application, but there is two type of classes that can be used to connect with database 1. Connected class 2. Disconnected class From connected classes we are mainly use: Sqlcommand : It is used to buid the SQL command SqlDataReader : It used to read all the data from database table ExecuteScaler : It is used to one singular value from database ExecuteReader: It is used to read at data and return as a DataReader object ExecuteNonquery: It is used to do insert update delete data in SQL Server table DataAdapater: It is used to connect class and disconnected class From disconnected classes we are mainly use: Datatable:Datatable is the collection of DataColumn, Datarow and various Relation and their constraint DataColumn: It is the component of Datatable, create column object structure for data DataRow: It another the component of Datatable, create row object structure for data Dataset: Dataset is the conllection of DataTable There are some common classes from System.data namespace classes for acces data sources SqlConnection : SQL connection is used to build the physical connection to application and SQL Server Connection.Open(); It is used for opening connection Connection.Close(); It is used for closing connection DataSource(); It is used to define dataSource Databind(); To find the code I have written in this video, join to our facebook group by clicking following link: https://www.facebook.com/groups/ITSolution365/permalink/2722734931102060/ You can also like to our facebook Page to get all video code clicking on following link: https://www.facebook.com/permalink.php?story_fbid=587403468394958&id=562632724205366 You can follow us on twitter clicking on following link: https://twitter.com/ITSolut62078624 We will create thousands of video related with information technology from our practical experience and those are used in our daily work and development. Stay with us. Do like, share and comments and subscribe to my channel and click on bell button to get notification when new video uploaded. You may suggest me to make new video with new topic. My Channel Subscription link: https://www.youtube.com/channel/UCoARYODbMPNO26wMpPE0R6g?sub_confirmation=1 Thanks again
In this I have shown how to Search data into SQL Server in C# ADO.net using connected class We have to follow the steps mentioned below: 1. Create database: See part 01 (If Required) 2. Design an user interface: : See part 01 (If Required) , you can do it in your own way 3. Add connection to Database in Visual Studio for more privilege like – connection string creation, visualization of SQL Server database field structure 4. Add required namespace like System.Data and System.Data.SqlClient 5. Create SQL Connection For Search 6. Build SQL Command for Search 7. Search Value with ID 8. Put the value in SQLDataReader by Executereader method 9. Using read method put the value into textbox using getvalue method 10. Show message in level 11. In else part clear all text box 12. Close the connection We all know Ado.net uses for connecting database and application, but there is two type of classes that can be used to connect with database 1. Connected class 2. Disconnected class From connected classes we are mainly use: Sqlcommand : It is used to buid the SQL command SqlDataReader : It used to read all the data from database table ExecuteScaler : It is used to one singular value from database ExecuteReader: It is used to read at data and return as a DataReader object ExecuteNonquery: It is used to do insert update delete data in SQL Server table DataAdapater: It is used to connect class and disconnected class From disconnected classes we are mainly use: Datatable:Datatable is the collection of DataColumn, Datarow and various Relation and their constraint DataColumn: It is the component of Datatable, create column object structure for data DataRow: It another the component of Datatable, create row object structure for data Dataset: Dataset is the conllection of DataTable There are some common classes from System.data namespace classes for acces data sources SqlConnection : SQL connection is used to build the physical connection to application and SQL Server Connection.Open(); It is used for opening connection Connection.Close(); It is used for closing connection DataSource(); It is used to define dataSource Databind(); To find the code I have written in this video, join to our facebook group by clicking following link: https://www.facebook.com/groups/ITSolution365/permalink/2722734931102060/ You can also like to our facebook Page to get all video code clicking on following link: https://www.facebook.com/permalink.php?story_fbid=587403468394958&id=562632724205366 You can follow us on twitter clicking on following link: https://twitter.com/ITSolut62078624 We will create thousands of video related with information technology from our practical experience and those are used in our daily work and development. Stay with us. Do like, share and comments and subscribe to my channel and click on bell button to get notification when new video uploaded. You may suggest me to make new video with new topic. My Channel Subscription link: https://www.youtube.com/channel/UCoARYODbMPNO26wMpPE0R6g?sub_confirmation=1 Thanks again