how to solve this problem when occur during Compiling time
Data Access Layer (DAL)
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
public class AddDal
{
string constr = ConfigurationManager.ConnectionStrings["connection"].ToString();
SqlConnection con=new SqlConnection();
public AddDal()
{
}
public int Insert(int id , string name)
{
int i = 0;
con.ConnectionString = constr;
con.Open();
SqlCommand cmdinsert = new SqlCommand("insertConnection", con);
cmdinsert.CommandType = CommandType.StoredProcedure;
try
{
cmdinsert.Parameters.AddWithValue("@id", id);
cmdinsert.Parameters.AddWithValue("@nam", name);
return cmdinsert.ExecuteNonQuery();
}
catch
{throw;}
finally
{
cmdinsert.Dispose();
con.Close();
con.Dispose();
}}}
Business Access Layer (BAL)
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public class AddBal
{
public AddBal()
{ }
public int Insert(int id , string name)
{
AddDal aDal=new AddDal();
try
{ return aDal.Insert(id , name); }
catch
{ throw; }
finally
{ aDal=null; }
} }
0 comments:
Post a Comment