Category Archives: Software Development

19.11.17 Videos:
Relationships:
Inheritance, Association, Aggregation and Composition
These are except that inheritance
From the slide:
Association:
Relation between students and teacher. Both are independent.
Manager has a swipe card to enter the company premises Association
Inheritance:
A manager is a type of Employee. Employee is a parent of manager
Aggregation:
These kind of relationship is called Aggregations. It represents a Has-A relationship.
public class Manager{
//aggregation relation
public List<Worker> workers=new List<Worker>();
//here worker is the child object and manager is the parent object

}

public class Worker{

public string WorkerName=” “;

Worker object=new Objects;

}
Composition(Death Relationships)

StringBuilder:

It is very useful while string can make complexity in heap but StringBuilder helps to reduce it by modifed string.

System.Text.StringBuilder class can be used and it comes from System.Text namespace

StringBuilder is mutable
StringBuilder performs faster than string when appending multiple string values

StringBuilder sb=new StringBuilder();

Use append method to add or append strings with StringBuilder
Use ToString() method to get the string from StringBuilder

Relationships Code and Videos:

Manager( is a )type of employee(Employee is a parent of Manager) – Inheritance
Manager ( has a ) swipe card to enter company premises – Association
He has many workers under him. – Aggregation relationship
His salary depend on project success. – Composition
Project success depends on a manager. –

I have completed the program may be I need to do it / practice it letter with heart. 🙂

Leave a comment

Posted in LICT

C# IEnumerable vs IEnumerator

Posted on January 9, 2018 | Leave a comment

When we work with Collections in C# we need to iterate the items of collections. One way fo doing is this foreach loop.

The class should implenet IEnumerable interface. The IEnumerable interface also inehirts from IEnumerator interface/

codes:

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace IEnumerableandIEnumerator
{
    class Player
    {
        public string Name { get; set; }
        public int Age { get; set; }

        public Player(string name, int age)
        {
            Name = name;
            Age = age;
        }
    }

    class Team:IEnumerable
    {
       private Player[] playerArray=new Player[4]; //aggregated class

        public Team()
        {
            playerArray[0] = new Player("Virat", 28);
            playerArray[1] = new Player("Dhoni", 35);
            playerArray[2] = new Player("Rohit", 29);
            playerArray[3]= new Player("Yuvraj",34);
        }

        public IEnumerator GetEnumerator()
        {
            return playerArray.GetEnumerator();
        }
    }

    class Program
    {

        static void Main(string[] args)
        {
            
            //string[] PlayerArray = {"Virat", "Rohit", "Dhoni"};
            //foreach (var items in PlayerArray)
            //{
            //    Console.WriteLine("Player is {0}",items);
            //}
            Team obj=new Team();

            foreach (Player iteemPlayer in obj)
            {
                Console.WriteLine("Name is {0} and Age is {1}",iteemPlayer.Name,iteemPlayer.Age);
            }
            Console.ReadLine();
        }
    }
}

using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace IEnumerableandIEnumerator

{

class Player

{

public string Name { get; set; }

public int Age { get; set; }

public Player(string name, int age)

{

Name = name;

Age = age;

}

class Team:IEnumerable

{

private Player[] playerArray=new Player[4]; //aggregated class

public Team()

{

playerArray[0] = new Player("Virat", 28);

playerArray[1] = new Player("Dhoni", 35);

playerArray[2] = new Player("Rohit", 29);

playerArray[3]= new Player("Yuvraj",34);

}

public IEnumerator GetEnumerator()

{

return playerArray.GetEnumerator();

}

class Program

{

static void Main(string[] args)

{

//string[] PlayerArray = {"Virat", "Rohit", "Dhoni"};

//foreach (var items in PlayerArray)

//{

// Console.WriteLine("Player is {0}",items);

//}

Team obj=new Team();

foreach (Player iteemPlayer in obj)

{

Console.WriteLine("Name is {0} and Age is {1}",iteemPlayer.Name,iteemPlayer.Age);

}

Console.ReadLine();

}

Leave a comment

Posted in .NET

LICT .NET Training | Kamal Protap Sir | Part 5

Posted on January 7, 2018 | Leave a comment

16/11/2017 vids

ExtensionMethod
Object Initializer
CollectionInitializer
QueryExpression
– It contains three clauses
from, where, orderby
Linq
IEnumerable

Diffrenet Datasource:
Array, Database, XML,LIST/Collection also datasource, File Concept also data source
Data we can able to store in known as data source
Data source: Where the data is available

using System;
using System.Collections.Generic;
using System.Linq;

namespace linqSample
{
    class Program
    {
        static void Main(string[] args)
        {
            int[] num=new int[5]{45, 78,45,34,2};
            IEnumerable<int> res=from N in num
                                 where N>40
                                 orderby N
                                 select N;

            foreach (var item in res)
            {
                Console.WriteLine(res);
            }

            Console.ReadKey();
        }
    }
}

using System;

using System.Collections.Generic;

using System.Linq;

namespace linqSample

{

class Program

{

static void Main(string[] args)

{

int[] num=new int[5]{45, 78,45,34,2};

IEnumerable<int> res=from N in num

where N>40

orderby N

select N;

foreach (var item in res)

{

Console.WriteLine(res);

}

Console.ReadKey();

}

Linq-Language Integrated Query
What is strongly typed ?

Strongly typed means:
Which show error immediately at a time of declaration that is called strongly typed. It is also called compile time error.

Weakly typed means:
Which show error in runtime is called weakly typed like delegate.It is also known as loosely type.

Intellisense and Strongly typed is supproted in LINQ concept.

LINQ enabled data sources is very very important for interview:
LINQ to Objects : It means with array, arralist, etc.
LINQ to Datasets: It’s connected with ADO.NET
LINQ to SQL: It’s connected to SQL
LINQ to Entities: It’s connected to other data base like oracle or mysql
LINQ to XML: It’s connected to XML files

IQueryable
Where IQueryable is inherited from IEnumerable
IEnumerable

There are two expression in LINQ QueryExpression and methodExpression

Differed Execution:

using System;
using System.Collections.Generic;
using System.Linq;

namespace linqSample
{
    class Program
    {
        static void Main(string[] args)
        {
            int[] num=new int[5]{45,78,45,34,2};
            IEnumerable<int> res=from N in num
                                 where N>40
                                 orderby N descending 
                                 select N;

            foreach (var item in res)
            {
                Console.WriteLine(item);
            }

            Console.ReadKey();
        }
    }
}

using System;

using System.Collections.Generic;

using System.Linq;

namespace linqSample

{

class Program

{

static void Main(string[] args)

{

int[] num=new int[5]{45,78,45,34,2};

IEnumerable<int> res=from N in num

where N>40

orderby N descending

select N;

foreach (var item in res)

{

Console.WriteLine(item);

}

Console.ReadKey();

}

Forced Execution:

using System;
using System.Collections.Generic;
using System.Linq;

namespace linqSample
{
    class Program
    {
        static void Main(string[] args)
        {
            int[] num=new int[5]{45,78,45,34,2};
            IEnumerable<int> res=(from N in num
                                 where N>40
                                 orderby N descending 
                                 select N).ToArray();

            foreach (var item in res)
            {
                Console.WriteLine(item);
            }

            Console.ReadKey();
        }
    }
}

using System;

using System.Collections.Generic;

using System.Linq;

namespace linqSample

{

class Program

{

static void Main(string[] args)

{

int[] num=new int[5]{45,78,45,34,2};

IEnumerable<int> res=(from N in num

where N>40

orderby N descending

select N).ToArray();

foreach (var item in res)

{

Console.WriteLine(item);

}

Console.ReadKey();

}

Immediate:

Leave a comment

Posted in LICT

LICT .NET Training | Kamal Protap Sir | Part 4

Posted on January 2, 2018 | Leave a comment

MVC Part:

Controller getting input.

ApplicationManagement video was so important

In Controller Folder HomeController.Cs is a controller which is controlling all the things

here is the code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace MVC.Controllers
{
    public class HomeController : Controller
    {
        public string Index() //we can override the abstract class ActionResult is an Abstract class
        {
            return "hi welcome";
        }

        public ActionResult About()
        {
            ViewBag.Message = "Your application description page.";

            return View();
        }
}
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace MVC.Controllers

{

public class HomeController : Controller

{

public string Index() //we can override the abstract class ActionResult is an Abstract class

{

return "hi welcome";

}

public ActionResult About()

{

ViewBag.Message = "Your application description page.";

return View();

}

App_Start Folder:

RouteConfig.cs file we will find that

using System.Web;

namespace MVC
{

public class RouteConfig{

public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathinfo}");

routes.MapRoute(
name:"Default",
url: "{controller}/{action}/{id}",
defaults:new{controller="Home",action="Index",id=UrlParameter.Optional
);
}
}
}

using System.Web;

namespace MVC

{

public class RouteConfig{

public static void RegisterRoutes(RouteCollection routes)

{

routes.IgnoreRoute("{resource}.axd/{*pathinfo}");

routes.MapRoute(

name:"Default",

url: "{controller}/{action}/{id}",

defaults:new{controller="Home",action="Index",id=UrlParameter.Optional

);

}

Views/Home/About
Views/Home/Contact

How to communicate with Controller and View:
ViewData and ViewBag passing the data from a controller to view

Interview questions:
ViewData: ViewData is dictionary of objects that is dervied from ViewData dictionary class and is accessible using string as keys.

ViewBag: viewBag is dynamic property. That take advantages of dynamic features.

both does not provide any compile time error.

In model we need to write the business logic.

In View we can show the actual things what we want to show:

View->Details.cshtml

@model MVC.Models.Employee
@{
    ViewBag.Title = "Details";
}

<h2>Employee Details</h2>
<table style="font-family: Arial">
    <tr>
        <td>
            <b>Employee Id:</b>
        </td>
        <td>
            @Model.EmployeeId
        </td>
    </tr>
    <tr>
        <td>
            <b>Employee Name:</b>
        </td>
        <td>
            @Model.Name
        </td>
    </tr>
    <tr>
        <td>
            
        </td>
    </tr>
     
</table>

@model MVC.Models.Employee

ViewBag.Title = "Details";

}

<h2>Employee Details</h2>

<tr>

<td>

<b>Employee Id:</b>

</td>

<td>

@Model.EmployeeId

</td>

</tr>

<tr>

<td>

<b>Employee Name:</b>

</td>

<td>

@Model.Name

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

Employee.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MVC.Models
{
    public class Employee
    {
        public int EmployeeId { get; set; }
        public string Name { get; set; }
        public string Gender { get; set; }
        public string City { get; set; }
    }
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

namespace MVC.Models

{

public class Employee

{

public int EmployeeId { get; set; }

public string Name { get; set; }

public string Gender { get; set; }

public string City { get; set; }

}

EmployeeController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MVC.Models;

namespace MVC.Controllers
{
    public class EmployeeController:Controller
    {
        public ActionResult Details()
        {
            Employee emp=new Employee()
            {
                EmployeeId=1,
                Name="Kamal"
                Gender="Male",
                City="Chennai"
            };
            return View(emp);
        }


    }
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using MVC.Models;

namespace MVC.Controllers

{

public class EmployeeController:Controller

{

public ActionResult Details()

{

Employee emp=new Employee()

{

EmployeeId=1,

Name="Kamal"

Gender="Male",

City="Chennai"

};

return View(emp);

}

Leave a comment

Posted in LICT

LICT .NET Training | Kamal Protap Sir | Part 3

Posted on December 27, 2017 | Leave a comment

09/11/2017 vids

Property:

using System;

namespace LinqOperators
{
    class Student
    {
        private int Sid;
        private string sname;


        public int StudentID
        {
            get { return Sid; }
            set { Sid = value; }
        }

        //public void Display()
        //{
        //    Console.WriteLine(Sid);
        //}

        public string StudentName
        {
            get { return sname;  }
            set { sname = value;  }
        }
    }

    class Program
    {
        static void Main(string[] args)
        {
            Student obj=new Student();
            obj.StudentID = 10;
            obj.StudentName = "Zaki";
            Console.WriteLine(obj.StudentName);
            Console.WriteLine(obj.StudentID);
            //obj.Display();
            Console.ReadKey();
        }
    }
}

using System;

namespace LinqOperators

{

class Student

{

private int Sid;

private string sname;

public int StudentID

{

get { return Sid; }

set { Sid = value; }

}

//public void Display()

//{

// Console.WriteLine(Sid);

//}

public string StudentName

{

get { return sname; }

set { sname = value; }

}

class Program

{

static void Main(string[] args)

{

Student obj=new Student();

obj.StudentID = 10;

obj.StudentName = "Zaki";

Console.WriteLine(obj.StudentName);

Console.WriteLine(obj.StudentID);

//obj.Display();

Console.ReadKey();

}

Automatic Property:

//auto implemented property

using System;

namespace LinqOperators
{
    class Student
    {
        public int Sid { private get; set; }
        public string Sname { get; set; }


       
    }

    class Program
    {
        static void Main(string[] args)
        {
            
            Student obj=new Student();
            obj.Sid = 10;
            obj.Sname = "Zaki";
            Console.WriteLine(obj.Sid+" "+obj.Sname);
            Console.ReadKey();
        }
    }
}

//auto implemented property

using System;

namespace LinqOperators

{

class Student

{

public int Sid { private get; set; }

public string Sname { get; set; }

}

class Program

{

static void Main(string[] args)

{

Student obj=new Student();

obj.Sid = 10;

obj.Sname = "Zaki";

Console.WriteLine(obj.Sid+" "+obj.Sname);

Console.ReadKey();

}

Delegates:

using System;

namespace Delegates
{
    delegate int Caluclation(int Fnum, int Snum);

    class Delegates
    {
        public static int Add(int Firstnum, int Secondnum)
        {
            return Firstnum + Secondnum;
        }

        public static int Sub(int Firstnum, int Secondnum)
        {
            return Firstnum - Secondnum;
        }

        public static string Display(string Sname)
        {
            return Sname;
        }

        public static void Main(string[] args)
        {
            Caluclation calc = Add;
            Console.WriteLine(calc.Invoke(3, 4));
            calc = Sub;
            Console.WriteLine(calc.Invoke(10, 5));

            Console.ReadKey();
        }
    }
}

using System;

namespace Delegates

{

delegate int Caluclation(int Fnum, int Snum);

class Delegates

{

public static int Add(int Firstnum, int Secondnum)

{

return Firstnum + Secondnum;

}

public static int Sub(int Firstnum, int Secondnum)

{

return Firstnum - Secondnum;

}

public static string Display(string Sname)

{

return Sname;

}

public static void Main(string[] args)

{

Caluclation calc = Add;

Console.WriteLine(calc.Invoke(3, 4));

calc = Sub;

Console.WriteLine(calc.Invoke(10, 5));

Console.ReadKey();

}

Lambda Expression with FUNC:

using System;


namespace LamdawithDelegates
{
    delegate int MyDelegatesss(int firstNum, int secondNum);

    class Program
    {
        public static int Add(int firstNum, int secondNum)
        {
            return firstNum + secondNum;
        }
        static void Main(string[] args)
        {
            MyDelegatesss calc = Add;
            Console.WriteLine(calc.Invoke(5,4));
            Console.ReadKey();

        }
    }
}

using System;

namespace LamdawithDelegates

{

delegate int MyDelegatesss(int firstNum, int secondNum);

class Program

{

public static int Add(int firstNum, int secondNum)

{

return firstNum + secondNum;

}

static void Main(string[] args)

{

MyDelegatesss calc = Add;

Console.WriteLine(calc.Invoke(5,4));

Console.ReadKey();

}

Some logics:

//delegate example

delegate int MyDelegate(int firstNumber, int secondNumber);
MyDelegate myDelegate=(firstNumber,secondNumber)=>firstNumber+secondNumber
int result=myDelegate(3,4);
Console.WriteLine(result);

//delegate example

delegate int MyDelegate(int firstNumber, int secondNumber);

MyDelegate myDelegate=(firstNumber,secondNumber)=>firstNumber+secondNumber

int result=myDelegate(3,4);

Console.WriteLine(result);

Lambda using Function:

//lambda using FUNC
Func<int, int , int> funcdel=(a,b)=>{return a*b};
int Result=funcdel(30,20);
Console.WriteLine(Result);

//lambda using FUNC

Func<int, int , int> funcdel=(a,b)=>{return a*b};

int Result=funcdel(30,20);

Console.WriteLine(Result);

Multicast Delegates:

A delegate instance holding the multiple method at a time is multicast delegate.
But the rule is that all the method must be altered because all method in a single instance they remain present. Multiple reference method at a time.

using System;

namespace MulticastDelegates
{
    public delegate void MultiDelegate(int a, int b);

    public class SampleClass
    {
        public static void Add(int x, int y)
        {
            Console.WriteLine("Addition value:"+(x+y));

        }

        public static void Sub(int x, int y)
        {
            Console.WriteLine("Subtraction Value:"+(x-y)); 
        }

        public static void Mul(int x, int y)
        {
            Console.WriteLine("Mutiplication Value:"+(x*y));
        }

    }

    class Program
    {
        static void Main(string[] args)
        {
            MultiDelegate del = SampleClass.Add;
            del += SampleClass.Sub;
            del += SampleClass.Mul;
            del(10, 5);
            Console.WriteLine();
            del -= SampleClass.Mul;
            del -= SampleClass.Sub;
            del(10, 5);
            Console.ReadKey();
        }
    }
}

using System;

namespace MulticastDelegates

{

public delegate void MultiDelegate(int a, int b);

public class SampleClass

{

public static void Add(int x, int y)

{

Console.WriteLine("Addition value:"+(x+y));

}

public static void Sub(int x, int y)

{

Console.WriteLine("Subtraction Value:"+(x-y));

}

public static void Mul(int x, int y)

{

Console.WriteLine("Mutiplication Value:"+(x*y));

}

class Program

{

static void Main(string[] args)

{

MultiDelegate del = SampleClass.Add;

del += SampleClass.Sub;

del += SampleClass.Mul;

del(10, 5);

Console.WriteLine();

del -= SampleClass.Mul;

del -= SampleClass.Sub;

del(10, 5);

Console.ReadKey();

}

Anonymous Method:
Unnamed function. In the bracket we are writing the logic. Unnamed method we are writing the logic. Unanmed method.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace AnonynemousMethod
{
    public delegate double Areapointer(int r);
    class Program
    {
        static void Main(string[] args)
        {
            Areapointer point=new Areapointer(
                delegate(int r)
                {
                    return 3.14 * r * r;
                }
                );

            double area = point(20);

            Console.WriteLine(area);

            Console.ReadKey();
        }
    }
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AnonynemousMethod

{

public delegate double Areapointer(int r);

class Program

{

static void Main(string[] args)

{

Areapointer point=new Areapointer(

delegate(int r)

{

return 3.14 * r * r;

}

);

double area = point(20);

Console.WriteLine(area);

Console.ReadKey();

}

The same AnonymousMethod work can be done in a single line with this lambda operation:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace AnonynemousMethod
{
    public delegate double Areapointer(int r);
    class Program
    {
        static void Main(string[] args)
        {
            Areapointer point = r => 3.14 * r * r;

            double area = point(20);

            Console.WriteLine(area);

            Console.ReadKey();
        }
    }
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AnonynemousMethod

{

public delegate double Areapointer(int r);

class Program

{

static void Main(string[] args)

{

Areapointer point = r => 3.14 * r * r;

double area = point(20);

Console.WriteLine(area);

Console.ReadKey();

}

=> This is known as goes to operator and it is similar to AnonymousMethod()

Linq also using lambda not only Delegate

Func:

Func is a readymade function where the first data type is for input and the second one is for output. It does not need any delegate to declare.

using System;

namespace FuncwithLambda
{
    class Program
    {
        static void Main(string[] args)
        {
            Func<double, double> area = r => 3.14 * r * r;
            double result = area(20);
            Console.WriteLine(result);
            Console.ReadKey();
        }
    }
}

using System;

namespace FuncwithLambda

{

class Program

{

static void Main(string[] args)

{

Func<double, double> area = r => 3.14 * r * r;

double result = area(20);

Console.WriteLine(result);

Console.ReadKey();

}

Action:
Action does not support any return type:

using System;


namespace Action
{
    class Program
    {
        static void Main(string[] args)
        {
            Action<String> area = sttr => Console.WriteLine(sttr);
            area("zaki");

        }
    }
}

using System;

namespace Action

{

class Program

{

static void Main(string[] args)

{

Action<String> area = sttr => Console.WriteLine(sttr);

area("zaki");

}

Leave a comment

Posted in .NET, LICT

DataReader and DataAdapter and DataSet

Posted on December 23, 2017 | Leave a comment

Difference Between DataReader and DataAdapter and DataSet:

Datareader: Datareader will be the best choice where we need to show the data to the user which requires no manipulation.

DataAdapter: DataAdapter read data from the database and is used to bind the data to the DataSet because DataAdapter working as a bridge between DataSet and the DataBase.

DataSet: DataSet is best suited where there is possibility of manipulation on the data.

Working in a Connected And Disconnected Environment: Part 1

In this article you will learn about the Connected And Disconnected Environment in ADO.NET.

www.c-sharpcorner.com

Leave a comment

Posted in ASP.NET

LICT .NET Training | Kamal Protap Sir | Part 2

Posted on December 19, 2017 | Leave a comment

07.11.17 Vids
DataAdapater vs DataReader:

SqlDataReader row by row executes from the table

ExecuteReader() always executes the query to the data reader object.

Using data reader:

using System;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Data;


namespace WindowsFormsApp1
{
    public partial class DataAdaptervsDatareader : Form
    {
        public DataAdaptervsDatareader()
        {
            InitializeComponent();
        }

        private void DataAdaptervsDatareader_Load(object sender, EventArgs e)
        {
            string ConString = "Server=ZAKIHP-PC\\ZAKISQL;Database=PracticeByMe;Trusted_Connection=Yes";
            SqlConnection conn = new SqlConnection(ConString);
            string querystring = "select * from tbl_ProductInfo";
            conn.Open();
            SqlCommand cmd=new SqlCommand(querystring,conn);
            SqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                MessageBox.Show("Name: " + reader["name"] + "Price: "+ reader["price"]+"Dates: " + reader["dates"]);
                //MessageBox.Show(reader[0] + reader[1] + reader[2]);
            }
            conn.Close();

        }
    }
}

using System;

using System.Data.SqlClient;

using System.Windows.Forms;

using System.Data;

namespace WindowsFormsApp1

{

public partial class DataAdaptervsDatareader : Form

{

public DataAdaptervsDatareader()

{

InitializeComponent();

}

private void DataAdaptervsDatareader_Load(object sender, EventArgs e)

{

string ConString = "Server=ZAKIHP-PC\\ZAKISQL;Database=PracticeByMe;Trusted_Connection=Yes";

SqlConnection conn = new SqlConnection(ConString);

string querystring = "select * from tbl_ProductInfo";

conn.Open();

SqlCommand cmd=new SqlCommand(querystring,conn);

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

MessageBox.Show("Name: " + reader["name"] + "Price: "+ reader["price"]+"Dates: " + reader["dates"]);

//MessageBox.Show(reader[0] + reader[1] + reader[2]);

}

conn.Close();

}

Using data adapter:

Difference between DataReader and DataAdapter:

c# – SqlDataAdapter vs SqlDataReader – Stack Overflow

stackoverflow.com

Using data adapter:
First we call data adapter then data set

  SqlDataAdapter Da = new SqlDataAdapter(cmd);
  DataSet ds=new DataSet();

1 2	SqlDataAdapter Da = new SqlDataAdapter(cmd); DataSet ds=new DataSet();

DataSet is a disconnected architecture
DataReader is a connected architecture

DataRow()

With DataAdapter:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace ADONETPRGS
{
    public partial class Dataadaptervsdatareader : Form
    {
        public Dataadaptervsdatareader()
        {
            InitializeComponent();
        }

        private void Dataadaptervsdatareader_Load(object sender, EventArgs e)
        {
            string ConString = "Data Source=DESKTOP-0MSCGUP;Initial Catalog=Lict_Dotnet;User ID=sa;Password=sa123";
            SqlConnection con = new SqlConnection(ConString);
            string querystring = "Select * from tbl_Product";
            con.Open();
            SqlCommand cmd = new SqlCommand(querystring, con);

            SqlDataAdapter Da = new SqlDataAdapter(cmd);
            
            DataSet Ds = new DataSet();
            Da.Fill(Ds);
            //SqlDataReader reader = cmd.ExecuteReader();
            // con.Close();
            foreach (DataRow Objrow in Ds.Tables[0].Rows)
            {
                MessageBox.Show("Name:" + Objrow["Name"] + " " + "Price:" + Objrow["Price"]);
            }


            //while (reader.Read())
            //{
            //    MessageBox.Show(reader["Name"] + " : " + reader["Price"]);
            //}
            // con.Close();

        }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace ADONETPRGS

{

public partial class Dataadaptervsdatareader : Form

{

public Dataadaptervsdatareader()

{

InitializeComponent();

}

private void Dataadaptervsdatareader_Load(object sender, EventArgs e)

{

string ConString = "Data Source=DESKTOP-0MSCGUP;Initial Catalog=Lict_Dotnet;User ID=sa;Password=sa123";

SqlConnection con = new SqlConnection(ConString);

string querystring = "Select * from tbl_Product";

con.Open();

SqlCommand cmd = new SqlCommand(querystring, con);

SqlDataAdapter Da = new SqlDataAdapter(cmd);

DataSet Ds = new DataSet();

Da.Fill(Ds);

//SqlDataReader reader = cmd.ExecuteReader();

// con.Close();

foreach (DataRow Objrow in Ds.Tables[0].Rows)

{

MessageBox.Show("Name:" + Objrow["Name"] + " " + "Price:" + Objrow["Price"]);

}

//while (reader.Read())

//{

// MessageBox.Show(reader["Name"] + " : " + reader["Price"]);

//}

// con.Close();

}

Whole datagridview has been binded with the data.

Stored procedure in Our Application:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApp1
{
    public partial class Storedprocedure : Form
    {
        public Storedprocedure()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection connection;
            SqlDataAdapter adapter;

            DataSet ds=new DataSet();
            int i = 0;
            string connectionString = "Server=ZAKIHP-PC\\ZAKISQL;Database=PracticeByMe;Trusted_Connection=Yes";
            connection = new SqlConnection(connectionString);
            SqlCommand cmd=new SqlCommand("SelectProduct", connection);
            cmd.CommandType = CommandType.StoredProcedure;
 
            adapter =new SqlDataAdapter(cmd);
            adapter.Fill(ds);

           for (i=0;i<=ds.Tables[0].Rows.Count-1;i++)
           {
               MessageBox.Show(ds.Tables[0].Rows[i][0].ToString() + " " + ds.Tables[0].Rows[i][1].ToString());
           }
        }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WindowsFormsApp1

{

public partial class Storedprocedure : Form

{

public Storedprocedure()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

SqlConnection connection;

SqlDataAdapter adapter;

DataSet ds=new DataSet();

int i = 0;

string connectionString = "Server=ZAKIHP-PC\\ZAKISQL;Database=PracticeByMe;Trusted_Connection=Yes";

connection = new SqlConnection(connectionString);

SqlCommand cmd=new SqlCommand("SelectProduct", connection);

cmd.CommandType = CommandType.StoredProcedure;

adapter =new SqlDataAdapter(cmd);

adapter.Fill(ds);

for (i=0;i<=ds.Tables[0].Rows.Count-1;i++)

{

MessageBox.Show(ds.Tables[0].Rows[i][0].ToString() + " " + ds.Tables[0].Rows[i][1].ToString());

}

Leave a comment

Posted in LICT

Tagged Leveraging ICT

SqlConnection in ADO.NET

Posted on December 17, 2017 | Leave a comment

Leave a comment

Posted in ADO.NET

LICT Training Vids Summary

Posted on December 14, 2017 | Leave a comment

10.12.17: (This is one of the important videos)
AuthenticateLogic is very very important for project works: also the store procedure here is important

</authentication>

<authorization>
<deny users=”?”> //if it is * it means that it is open for all but ? sign means it is only for requested users
</authorization>

What is difference between connection string and appSettings ?

</connectionStrings>

LinqToSql Class

12.12.17: (This is one of the important videos)

For project works

Leave a comment

Posted in ASP.NET, LICT

Stored Procedures

Posted on December 14, 2017 | Leave a comment

Leave a comment

Posted in Database, LICT, MSSQL, Stored Procedures

LICT .NET Training | Kamal Protap Sir

Posted on December 12, 2017 | Leave a comment

DDL – Data definition Language(Which deals with database schemas and descriptions that how the data should reside in database) – create,alter,drop, truncate, comment
DML – Data manipulation language(Modify, Update, Delete data in database) – select, insert, update, delete
DCL – Data Control Language(Regarding the rights of the database) grant,revoke

31-10-17 vids

SQL Query

Use PracticeByMe

select * from dbo.tbl_empdtls

--group by
select Department, Count(*) as 'Number of Employees'
from tbl_empdtls
group by Department

select Gender, count(*) as Gender
from tbl_empdtls
group by Gender

select Department,Gender, Count(*) as 'Number of Employees'
from tbl_empdtls
group by Department, Gender
order by 2 ASC --'1' it means the first column in the select statement Department 

--important query
--How many Employees who is hired in each year
select YEAR(HireDate) as HireYear,count(*) as 'Number of Employee'
from tbl_empdtls
group by year(HireDate)
order by count(*) desc


--select min sal,max sal, avg sal in each department
select JobTitle, min(Salary) as 'MinSalary', max(Salary) as 'Maximum', avg(Salary) as 'AverageSalary'
from tbl_empdtls
group by JobTitle
order by MinSalary

Use PracticeByMe

select * from dbo.tbl_empdtls

--group by

select Department, Count(*) as 'Number of Employees'

from tbl_empdtls

group by Department

select Gender, count(*) as Gender

from tbl_empdtls

group by Gender

select Department,Gender, Count(*) as 'Number of Employees'

from tbl_empdtls

group by Department, Gender

order by 2 ASC --'1' it means the first column in the select statement Department

--important query

--How many Employees who is hired in each year

select YEAR(HireDate) as HireYear,count(*) as 'Number of Employee'

from tbl_empdtls

group by year(HireDate)

order by count(*) desc

--select min sal,max sal, avg sal in each department

select JobTitle, min(Salary) as 'MinSalary', max(Salary) as 'Maximum', avg(Salary) as 'AverageSalary'

from tbl_empdtls

group by JobTitle

order by MinSalary

SQL Aggregate functions, slides presentation – w3resource

SQL Aggregate functions, slides presentation: This presentation describes SQL Aggregate function covering SQL COUNT(), SUM(), MAX(), MIN(), AVG) functions with examples.

www.w3resource.com

SubQuery:

A query within another query is called subquery or nested query . Inner Query, Outer query is in subquery.

Sub Query are two types they are, co-related sub query and non co-related subquery. They works for both DDL and DML statements
Co-related means relationship/dependent on
Non co-related means independent

There are two queries in sub query. You will see group by, order by is single type query but in sub query it needs multiple query

Non co related: They are two types,
Inner query: It will first execute. It will return some result. Independently it will execute.
Outer Query: Based on the inner query result now outer query will execute. The whole process is known as non co-related

--who is getting the minimum salary in the table
select * from tbl_empdtls
where salary = 
(select min(salary) from tbl_empdtls)

--who is getting the minimum salary in the table

select * from tbl_empdtls

where salary =

(select min(salary) from tbl_empdtls)

--select subquery
select * 
	from customers
	where ID IN(select ID
				FROM CUSTOMERS
				WHERE salary>25000)

--select subquery

select *

from customers

where ID IN(select ID

FROM CUSTOMERS

WHERE salary>25000)

= for comapring single value
IN for comparing multiple value

--insert subquery
create table customers_backup(ID int primary key,name varchar(20),age int,salary numeric(9,2), address varchar(20));

insert into Customers_backup
select * from customers
where ID in(select ID	
		from CUSTOMERS);

select * from customers_backup

--insert subquery

create table customers_backup(ID int primary key,name varchar(20),age int,salary numeric(9,2), address varchar(20));

insert into Customers_backup

select * from customers

where ID in(select ID

from CUSTOMERS);

select * from customers_backup

--update sub query
update customers
SET SALARY=SALARY*0.25
WHERE AGE IN(select age
			from customers_backup
			where age>23)

--update sub query

update customers

SET SALARY=SALARY*0.25

WHERE AGE IN(select age

from customers_backup

where age>23)

--delete subquery
delete from customers 
where AGE IN(select AGE 
			from customers_backup
			where age>=25)

--delete subquery

delete from customers

where AGE IN(select AGE

from customers_backup

where age>=25)

--select the details of the product not yet sale at least once
--non co related
select id ,name,[Description]
from tbl_products where id not in(select distinct ProductId from tbl_ProductSales)

--subquery and join is same
select p.Id,p.Name,p.[Description] from tbl_products p
left join tbl_ProductSales ps on p.Id=ps.ProductId
where ps.ProductId is null

--select the details of the product not yet sale at least once

--non co related

select id ,name,[Description]

from tbl_products where id not in(select distinct ProductId from tbl_ProductSales)

--subquery and join is same

select p.Id,p.Name,p.[Description] from tbl_products p

left join tbl_ProductSales ps on p.Id=ps.ProductId

where ps.ProductId is null

Co-related: It is dependent query. Inner query can’t execute independently. Inner query depends on outer query. Without returning row from the outer query inner can’t execute. In co-related sub query. All execute first.

--co related
select name,
(select sum(quantity) from tbl_ProductSales where ProductId=tbl_Products.Id) as QuantitySold
from tbl_products

--co related

select name,

(select sum(quantity) from tbl_ProductSales where ProductId=tbl_Products.Id) as QuantitySold

from tbl_products

02.11.17 Vids
Store Procedure:

MS SQL Server store procedure is used to save time write the same code again and again for storing in database and also get the rquired output by passing parameters.

Syntax:

Following the basic syntax of stored procedure creation.

create procedure <procedure name>
AS
BEGIN
<SQL STATEMENT>
END
Go

create procedure <procedure name>

BEGIN

END

Lots of parameters used in stored procedure:

IN paramater is a paramater whose values are passed inside of the procedure
OUT paramater is a paramater whose value is pass outside the parameter
OUT parameter return some value
IN does not return any value
create procedure

create proc GetStudentNamesInOutVariable
(
@studentid INT,
@studentname varchar(200) OUT,
@studentEmail varchar(200) OUT
)
AS
SELECT @studentname=FName+' '+LName,
@studentEmail=Email FROM Students_INFO WHERE StudID=@studentid

create proc GetStudentNamesInOutVariable

(

@studentid INT,

@studentname varchar(200) OUT,

@studentEmail varchar(200) OUT

)

SELECT @studentname=FName+' '+LName,

@studentEmail=Email FROM Students_INFO WHERE StudID=@studentid

Executing the stored procedure:

--Execute the procedure
DECLARE @studentname VARCHAR(20)
DECLARE @studEmail VARCHAR(20)
EXEC GetStudentNamesInOutVariable 1, @studentname OUTPUT, @studEmail OUTPUT
SELECT @studentname as StudentName,
       @studEmail as StudentEmail

--Execute the procedure

DECLARE @studentname VARCHAR(20)

DECLARE @studEmail VARCHAR(20)

EXEC GetStudentNamesInOutVariable 1, @studentname OUTPUT, @studEmail OUTPUT

SELECT @studentname as StudentName,

@studEmail as StudentEmail

Here are the store procedure example basic in my blog

http://zakilive.com/2017/12/14/stored-procedures/

Creating View:
View is something where other developers can’t find details. But they can make query with the name when they need it.

View helps to show the particular data for the

create view VW_Select
as
select Department,Gender from tbl_empdtls

select * from tbl_empdtls

create view VW_Select

select Department,Gender from tbl_empdtls

select * from tbl_empdtls

UPDATE with view

update VW_Select set Gender='female' where Department='cse'
select * from VW_Select

1 2	update VW_Select set Gender='female' where Department='cse' select * from VW_Select

--condition in view
alter view view_department
AS
SELECT Department
from tbl_empdtls
where Department='cse'

select * from view_department

--condition in view

alter view view_department

SELECT Department

from tbl_empdtls

where Department='cse'

select * from view_department

View don’t support order by in that case we need top keyword in view:

create view VW_OrderbyFname
as
select top 2* from tbl_empdtls order by Fname

select * from dbo.tbl_empdtls

create view VW_OrderbyFname

select top 2* from tbl_empdtls order by Fname

select * from dbo.tbl_empdtls

05.11.2017 vids

ADO.NET is a set of classes that allows you to connect and work with data sources like databases,excel file, access file, xml file,my sql, and notepad.

To connect your application with different data sources of database you need to know the right data provider. There are sevral data providers in ADO.NET that connects with different types of sources.

There are 4 core components of .NET data providers that is used to connect,access and retrieve data from the database.

Connection- This component is used for connecting to the database. The base class is DbConnection
Command: This component executes SQL query against the data source. The base class is DbCommand.
DataReader-It reads data from data source. It accesses data read only and forward only. The base class is DbDataReader.
DataAdapter-It invokes dataset and resolves updates with the data source. The base class is DbDataAdapater

Pass value with parameters:

using System;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsFormsApp1
{
    public partial class datesetProgs : Form
    {
        public datesetProgs()
        {
            InitializeComponent();
        }

        private void datesetProgs_Load(object sender, EventArgs e)
        {

        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {

        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
            textDate.Text = dateTimePicker1.Text;
            dateTimePicker1.Visible = false;
        }

        private void btnSubmit_Click(object sender, EventArgs e)
        {
            string ConString = "Server=ZAKIHP-PC\\ZAKISQL;Database=PracticeByMe;Trusted_Connection=Yes";
            SqlConnection conn = new SqlConnection(ConString);
            //string query = "INSERT into tbl_ProductInfo(Name,Price,Dates) values('"+textBox1.Text+"','"+textBox2.Text+"','"+textDate.Text+"')";
           string query = "INSERT into tbl_ProductInfo(Name,Price,Dates) values(@Names,@Price,@Dates)";

            SqlCommand cmd = new SqlCommand(query, conn);

            //pass value to parameters
            cmd.Parameters.AddWithValue("@Name", textBox1.Text);
            cmd.Parameters.AddWithValue("@Price", textBox2.Text);
            cmd.Parameters.AddWithValue("@Dates", textDate.Text);


            try
            {
                conn.Open();
                int result = cmd.ExecuteNonQuery();
                MessageBox.Show(result + " Records inserted successfully!");
                Clear();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error generated details:" + ex.ToString());
            }
            finally
            {
                conn.Close();
            }
            dateTimePicker1.Visible = true;



        }

        public void Clear()
        {
            textBox1.Text = "";
            textBox2.Text = "";
            textDate.Text = "";
        }
    }
}

using System;

using System.Data.SqlClient;

using System.Windows.Forms;

namespace WindowsFormsApp1

{

public partial class datesetProgs : Form

{

public datesetProgs()

{

InitializeComponent();

}

private void datesetProgs_Load(object sender, EventArgs e)

{

}

private void textBox1_TextChanged(object sender, EventArgs e)

{

}

private void label1_Click(object sender, EventArgs e)

{

}

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)

{

textDate.Text = dateTimePicker1.Text;

dateTimePicker1.Visible = false;

}

private void btnSubmit_Click(object sender, EventArgs e)

{

string ConString = "Server=ZAKIHP-PC\\ZAKISQL;Database=PracticeByMe;Trusted_Connection=Yes";

SqlConnection conn = new SqlConnection(ConString);

//string query = "INSERT into tbl_ProductInfo(Name,Price,Dates) values('"+textBox1.Text+"','"+textBox2.Text+"','"+textDate.Text+"')";

string query = "INSERT into tbl_ProductInfo(Name,Price,Dates) values(@Names,@Price,@Dates)";

SqlCommand cmd = new SqlCommand(query, conn);

//pass value to parameters

cmd.Parameters.AddWithValue("@Name", textBox1.Text);

cmd.Parameters.AddWithValue("@Price", textBox2.Text);

cmd.Parameters.AddWithValue("@Dates", textDate.Text);

try

{

conn.Open();

int result = cmd.ExecuteNonQuery();

MessageBox.Show(result + " Records inserted successfully!");

Clear();

}

catch (Exception ex)

{

MessageBox.Show("Error generated details:" + ex.ToString());

}

finally

{

conn.Close();

}

dateTimePicker1.Visible = true;

}

public void Clear()

{

textBox1.Text = "";

textBox2.Text = "";

textDate.Text = "";

}

Leave a comment

Posted in LICT, MSSQL

Extension Methods in C# 3.0

Posted on November 20, 2017 | Leave a comment

program.cs

using System;

namespace Extension
{
 

    class DekhiKiObostha
    {
        public void Test1()
        {
            Console.WriteLine("Method-1");
        }

        public void Test2()
        {
            Console.WriteLine("Method-2");
        }
        public void KiObostha()
        {
            Console.WriteLine("Hello Vai Koi Jaben ?");
        }
      
       
    }
}

using System;

namespace Extension

{

class DekhiKiObostha

{

public void Test1()

{

Console.WriteLine("Method-1");

}

public void Test2()

{

Console.WriteLine("Method-2");

}

public void KiObostha()

{

Console.WriteLine("Hello Vai Koi Jaben ?");

}

StaticClass.cs

using System;

namespace Extension
{
    static class StaticClass
    {
        public static void Test3(this DekhiKiObostha s,int i)
        {
            Console.WriteLine("Method-3 :"+i);
        }


    }


    static class DclassTest
    {
        public static void TestDekhi(this DekhiKiObostha zaDekhiKiObostha,int o)
        {
            Console.WriteLine("Dlclass Test eta ="+o);
        }
    }
}

using System;

namespace Extension

{

static class StaticClass

{

public static void Test3(this DekhiKiObostha s,int i)

{

Console.WriteLine("Method-3 :"+i);

}

static class DclassTest

{

public static void TestDekhi(this DekhiKiObostha zaDekhiKiObostha,int o)

{

Console.WriteLine("Dlclass Test eta ="+o);

}

TestExtensionMethods.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Extension
{
    class TestDekhi
    {
          static void Main()
        {

            DekhiKiObostha dd = new DekhiKiObostha();

            dd.Test1();
            dd.Test2();
            dd.Test3(10);
            dd.KiObostha();
            dd.TestDekhi(8);
            Console.ReadKey();
        }
       
    }
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Extension

{

class TestDekhi

{

static void Main()

{

DekhiKiObostha dd = new DekhiKiObostha();

dd.Test1();

dd.Test2();

dd.Test3(10);

dd.KiObostha();

dd.TestDekhi(8);

Console.ReadKey();

}

output:

Method-1
Method-2
Method-3 :10
Hello Vai Koi Jaben ?
Dlclass Test eta =8

Method-1

Method-2

Method-3 :10

Hello Vai Koi Jaben ?

Dlclass Test eta =8

Leave a comment

Posted in .NET, C#

Category Archives: Software Development

Design Pattern:Cohesion in Java

Github in Ubuntu

Cyclometic Complexity

LICT .NET Training | Kamal Protap Sir | Part 6

C# IEnumerable vs IEnumerator

LICT .NET Training | Kamal Protap Sir | Part 5

LICT .NET Training | Kamal Protap Sir | Part 4

LICT .NET Training | Kamal Protap Sir | Part 3

DataReader and DataAdapter and DataSet

LICT .NET Training | Kamal Protap Sir | Part 2

SqlConnection in ADO.NET

LICT Training Vids Summary

Stored Procedures

LICT .NET Training | Kamal Protap Sir

Extension Methods in C# 3.0

Random Quote

Random Quotes

Categories

Recent Comments

About Me & MyBlog

Caution and Tips:

My Facebook

Recent Posts

Archives

Category Archives: Software Development

Random Quote

Random Quotes

Categories

Recent Comments

About Me & MyBlog

Caution and Tips:

My Facebook

Recent Posts

Tags

Archives