How to Make Dll File
In this article we will learn how to make dll file
Open Visual Studio
*File>New>Project > Visual c#> Class Library
If System.configuration is not added, it will get error in web application
using System;
namespace nsemployees
}
*File>New>Project > Visual c#> Class Library
* Class library- for all dll files
*Project>Add references> Assembles> Enable System.configuration
If System.configuration is not added, it will get error in web application
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace nsemployees
{
public interface intemp
{
Int32 empno { get; set; }
String ename { get; set; }
String eadd { get; set; }
Int32 esal { get; set; }
}
public class clsempprp : intemp
{
private Int32 prvempno, prvesal;
private String prvename, prveadd;
public int empno
{
get
{
return prvempno;
}
set
{
prvempno = value;
}
}
public string ename
{
get
{
return prvename;
}
set
{
prvename = value;
}
}
public string eadd
{
get
{
return prveadd;
}
set
{
prveadd = value;
}
}
public int esal
{
get
{
return prvesal;
}
set
{
prvesal = value;
}
}
}
public abstract class clscon
{
protected SqlConnection con = new SqlConnection();
public clscon()
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["ps"].ConnectionString;
}
}
public class clsemp : clscon
{
public void Save_Rec(clsempprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("insemp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@eno", p.empno);
cmd.Parameters.AddWithValue("@en", p.ename);
cmd.Parameters.AddWithValue("@ed", p.eadd);
cmd.Parameters.AddWithValue("@es", p.esal);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void Update_Rec(clsempprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("updemp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@eno", p.empno);
cmd.Parameters.AddWithValue("@en", p.ename);
cmd.Parameters.AddWithValue("@ed", p.eadd);
cmd.Parameters.AddWithValue("@es", p.esal);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void Delete_Rec(clsempprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("delemp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@eno", p.empno);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public List<clsempprp> Disp_Rec()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("dispemp", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
List<clsempprp> obj = new List<clsempprp>();
while (dr.Read())
{
clsempprp k = new clsempprp();
k.empno = Convert.ToInt32(dr[0]);
k.ename = dr[1].ToString();
k.eadd = dr[2].ToString();
k.esal = Convert.ToInt32(dr[3]);
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return obj;
}
public List<clsempprp> Find_Rec(Int32 eno)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("findemp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@eno", eno);
SqlDataReader dr = cmd.ExecuteReader();
List<clsempprp> obj = new List<clsempprp>();
if (dr.HasRows)
{
dr.Read();
clsempprp k = new clsempprp();
k.empno = Convert.ToInt32(dr[0]);
k.ename = dr[1].ToString();
k.eadd = dr[2].ToString();
k.esal = Convert.ToInt32(dr[3]);
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return obj;
}
}
}
|
In above , we will interface , property classes, abstract class and then main class
#If you want to make dll file
Click on Build > Build Solution
Click on Build > Build Solution
No comments:
Post a Comment