Introduction: .NET Framework Data Providers This namespace contains the following important classes. Class Description SqlConnection It is used to create SQL Server connection. This class cannot be inherited. SqlCommand It is used to execute database queries. This class cannot be inherited. SqlDataAdapter It represents a set of data commands and a database connection that …
Connection to SQL Server: using System;using System.Data.SqlClient;namespace Practice{ class Program { static void Main(string[] args) { SqlConnection con = null; try { con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”); con.Open(); Console.WriteLine(“Connected”); } catch (Exception e) { Console.WriteLine(“OOPs, something went wrong.” + e); } finally { con.Close(); Console.WriteLine(“Connection closed”); } } }}
Create table in SQL server: using System;using System.Data.SqlClient;namespace Practice{ class Program { static void Main(string[] args) { SqlConnection con = null; try { con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”); con.Open(); Console.WriteLine(“Connected”); String query = “create table account(num int, name varchar(20), balance int)”; SqlCommand cm = new SqlCommand(query, con); cm.ExecuteNonQuery(); Console.WriteLine(“Table created Successfully”); } …
Insert record into table: using System;using System.Data.SqlClient;namespace Practice{ class Program { static void Main(string[] args) { SqlConnection con = null; try { con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”); con.Open(); Console.WriteLine(“Connected”); String query = “insert into account values(101, ‘Amar’, 5000)”; SqlCommand cm = new SqlCommand(query, con); cm.ExecuteNonQuery(); Console.WriteLine(“Record inserted Successfully”); } catch (Exception e) …
Display Details of all Records: using System;using System.Data.SqlClient;namespace Practice{ class Program { static void Main(string[] args) { SqlConnection con = null; try { con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”); con.Open(); Console.WriteLine(“Connected”); String query = “select * from account”; SqlCommand cm = new SqlCommand(query, con); SqlDataReader sdr = cm.ExecuteReader(); while (sdr.Read()) { Console.WriteLine(sdr[“num”] …
Delete Record in SQL Server Table: using System;using System.Data.SqlClient;namespace Practice{ class Program { static void Main(string[] args) { SqlConnection con = null; try { con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”); con.Open(); Console.WriteLine(“Connected”); String query = “delete from account where num=102”; SqlCommand cm = new SqlCommand(query, con); cm.ExecuteNonQuery(); Console.WriteLine(“Record Deleted Successfully”); } catch (Exception …
Read Details and Insert Record into SQL Server: using System;using System.Data.SqlClient;namespace ADO1{ internal class Program { static void Main(string[] args) { SqlConnection con = null; try { con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”); con.Open(); Console.WriteLine(“Connected to Database”); Console.WriteLine(“Enter student details : “); int num = Convert.ToInt32(Console.ReadLine()); String name = Console.ReadLine(); String query = …
ADO .Net – Dynamic Insertion of Record into SQL Server Read More »
using System;using System.Data.SqlClient;namespace ADO1{ internal class Program { static void Main(string[] args) { SqlConnection con = null; try { con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”); con.Open(); Console.WriteLine(“Connected to Database”); Console.WriteLine(“Enter student number to delete : “); int num = Convert.ToInt32(Console.ReadLine()); String query = “delete from student where num=@num”; SqlCommand cm = new SqlCommand(query, …
ADO .Net – Dynamic Record Deletion in SQL Server Read More »
using System;using System.Data.SqlClient;namespace ADO1{ internal class Program { static void Main(string[] args) { SqlConnection con = null; try { con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”); con.Open(); Console.WriteLine(“Connected to Database”); Console.WriteLine(“Enter student number to delete : “); int num = Convert.ToInt32(Console.ReadLine()); String query = “select * from student where num=@num”; SqlCommand cmd = …
Connection with using() block: using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); } Code Program: using System;using System.Data.SqlClient; namespace Practice{ class Program { static void Main(string[] args) { using(SqlConnection con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”)) { con.Open(); Console.WriteLine(“Connection Established Successfully”); } } }}