Dev Dot Net World

What are the main components of WCF ?

2010-08-10T23:48:00.000-07:00

Dev Palmistry

What are the main components of WCF ?

The main components of WCF are

1. Service class
2. Hosting environment
3. End point

What was the code name for WCF ?

2010-08-10T23:47:00.000-07:00

Dev Palmistry

What was the code name for WCF ?

The code name of WCF was Indigo .

WCF is a unification of .NET framework communication technologies which unites the following technologies:-

NET remoting
MSMQ
Web services
COM+

What are various ways of hosting WCF Services ?

2010-08-10T23:46:00.000-07:00

What are various ways of hosting WCF Services?

There are three major ways of hosting a WCF services

• Self-hosting the service in his own application domain. This we have already covered in the first section. The service comes in to existence when you create the object of Service Host class and the service closes when you call the Close of the Service Host class.

• Host in application domain or process provided by IIS Server.

• Host in Application domain and process provided by WAS (Windows Activation Service) Server.

What is the difference WCF and Web services ?

2010-08-10T23:45:00.000-07:00

What is the difference WCF and Web services ?

Web services can only be invoked by HTTP (traditional webservice with .asmx). While WCF Service or a WCF component can be invoked by any protocol (like http, tcp etc.) and any transport type.

Second web services are not flexible. However, WCF Services are flexible. If you make a new version of the service then you need to just expose a new end. Therefore, services are agile and which is a very practical approach looking at the current business trends.

We develop WCF as contracts, interface, operations, and data contracts. As the developer we are more focused on the business logic services and need not worry about channel stack. WCF is a unified programming API for any kind of services so we create the service and use configuration information to set up the communication mechanism like HTTP/TCP/MSMQ etc

What is three major points in WCF ?

2010-08-10T23:44:00.002-07:00

What is three major points in WCF ?

We Should remember ABC.

Address --- Specifies the location of the service which will be like http://Myserver/MyService.Clients will use this location to communicate with our service.

Binding --- Specifies how the two paries will communicate in term of transport and encoding and protocols

Contract --- Specifies the interface between client and the server.It's a simple interface with some attribute.

What are the various ways of hosting a WCF service ?

2010-08-10T23:44:00.001-07:00

What are the various ways of hosting a WCF service ?

Self hosting the service in his own application domain. This we have already covered in the first section. The service comes in to existence when you create the object of ServiceHost class and the service closes when you call the Close of the ServiceHost class.
Host in application domain or process provided by IIS Server.
Host in Application domain and process provided by WAS (Windows Activation Service) Server.

Difference between WCF and Web services ?

2010-08-10T23:42:00.000-07:00

Difference between WCF and Web services ?

Web Services

1.It Can be accessed only over HTTP
2.It works in stateless environment

WCF

WCF is flexible because its services can be hosted in different types of applications. The following lists several common scenarios for hosting WCF services:
IIS
WAS
Self-hosting
Managed Windows Service

What is WCF ?

2010-08-10T23:29:00.000-07:00

What is WCF?

Answer :

Windows Communication Foundation (WCF) is an SDK for developing and deploying services on Windows. WCF provides a runtime environment for services, enabling you to expose CLR types as services, and to consume other services as CLR types.

WCF is part of .NET 3.0 and requires .NET 2.0, so it can only run on systems that support it.

WCF is Microsoft’s unified programming model for building service-oriented applications with managed code. It extends the .NET Framework to enable developers to build secure and reliable transacted Web services that integrate across platforms and interoperate with existing investments.

WCF ---Windows communication foundation is a feature in .NET 3.5 framework.

As we have the webservice in the earlier versions, we have in addition WCF in 3.5.

The main advantage with WCF is
1) you can create one service that can be binded with multiple protocols, like HTTP, TCP,SecureHTTP.

so if you want to connect with HTTP you can use the endpoint http, and so on.

Here we have the concept 'ABC'
that is Address, Binding and Contract.
Here we create more than one endpoint with different bindings.
And you can use one of the binding well suited for your application.
For windows you can TCP, and for web based you can use HTTP or secure HTTP.

Windows Communication Foundation (WCF) is a framework for building service-oriented applications. Using WCF, you can send data as asynchronous messages from one service endpoint to another. A service endpoint can be part of a continuously available service hosted by IIS, or it can be a service hosted in an application. An endpoint can be a client of a service that requests data from a service endpoint. The messages can be as simple as a single character or word sent as XML, or as complex as a stream of binary data. A few sample scenarios include:

* A secure service to process business transactions.

* A service that supplies current data to others, such as a traffic report or other monitoring service.

* A chat service that allows two people to communicate or exchange data in real time.

* A dashboard application that polls one or more services for data and presents it in a logical presentation.

* Exposing a workflow implemented using Windows Workflow Foundation as a WCF service.

* A Silverlight application to poll a service for the latest data feeds.

While creating such applications was possible prior to the existence of WCF, WCF makes the development of endpoints easier than ever. In summary, WCF is designed to offer a manageable approach to creating Web services and Web service clients.

2010-06-30T07:32:00.000-07:00

OutPut Stored Procedure !!

2009-11-20T21:43:00.000-08:00

CREATE procedure guest_regi
@memname varchar(50),
@mememail varchar(50),
@memphone varchar(50),
@memregtype varchar(50),
@memactive int,
@gid int output
as
insert into tblmemregistration
(
memname,
mememail,
memphone,
memregtype,
memactive
)

values
(
@memname,
@mememail,
@memphone,
@memregtype,
@memactive
)

select @gid=@@IDENTITY

GO

GridView !!

2009-11-17T22:11:00.000-08:00

asp:GridView ID="GDcomp" runat="server" border="0" cellpadding="5" cellspacing="1" bgcolor="#ffffff" AutoGenerateColumns="false" AllowPaging="true" Width="100%" OnRowDataBound="GDcomp_RowDataBound" OnPageIndexChanging="GDcomp_PageIndexChanging" PageSize="10" AllowSorting="True" OnSorting="GDcomp_Sorting" ForeColor="Black">
Columns>

asp:TemplateField HeaderText="S. No.">
ItemTemplate>
<%#(GDcomp.PageIndex * 10) + Container.DisplayIndex + 1%>
/ItemTemplate>
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="6%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="6%" />
/asp:TemplateField >
asp:TemplateField HeaderText="Company Name" SortExpression="comp_name">

ItemTemplate>
a href="CompanyDetail.aspx?id=<%# DataBinder.Eval(Container, "DataItem.comp_id") %> " class="black"><%# DataBinder.Eval(Container, "DataItem.comp_name") %>
/ItemTemplate>
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="12%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="12%" />
/asp:TemplateField>

asp:BoundField DataField="comp_contact_person" HeaderText="Contact Person" SortExpression="comp_contact_person">
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="12%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="12%" />
/asp:BoundField>
asp:BoundField DataField="country_name" HeaderText="Country" SortExpression="country_name">
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="8%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="8%" />
asp:BoundField DataField="comp_state" HeaderText="State" SortExpression="comp_state">
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="10%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="10%" />
/asp:BoundField>
asp:BoundField DataField="comp_city" HeaderText="City" SortExpression="comp_city">
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="9%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="8%" />
/asp:BoundField>
asp:TemplateField HeaderText="Edit" >
itemtemplate>
a href="CompanyMaster.aspx?action=edit&ID=<%# DataBinder.Eval(Container, "DataItem.comp_id") %>" class="black">
/itemtemplate>
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="6%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="6%" />
/asp:TemplateField>
asp:BoundField DataField="comp_active" HeaderText="Status" >
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="6%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="6%" />
/asp:BoundField>
asp:TemplateField HeaderText="Delete">
itemtemplate>

/itemtemplate>
ItemStyle BackColor="#F4F0E1" HorizontalAlign="Center" Width="6%" />
HeaderStyle BackColor="#D3CCB5" HorizontalAlign="Center" Width="6%" />
/asp:TemplateField>
asp:TemplateField Visible="False" HeaderText="ad">
itemtemplate>
asp:Label ID="lblid" Text='<%#DataBinder.Eval(Container.DataItem,"comp_id")%>' runat="server">

/itemtemplate>
/asp:TemplateField>
/Columns>
PagerStyle BackColor="#BDB391" HorizontalAlign="Center" />
/asp:GridView>

PaymentReceivedDetails !!

2009-11-17T22:07:00.000-08:00

public partial class paymentreceiveddetail : System.Web.UI.Page
{
string Printbody;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.QueryString.HasKeys())
{
BtnSubmit.Visible = false;
FillPaymentRecDetail();
}
else
{
BtnExToPDF.Visible = false;
BtnEmail.Visible = false;
BtnCopy.Visible = false;
BtnPrint.Visible = false;
PaymentDetail();
}
}
}

//Code for Fill payment Received detail //
private void FillPaymentRecDetail()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
conn.Open();
string id = Request.QueryString["id"].ToString();
string str = "select * from viewPaymentReceived where pr_id=@Payid ";
SqlCommand com = new SqlCommand(str, conn);

SqlParameter PayID = new SqlParameter("@Payid", SqlDbType.Int, 4);
PayID.Value = Request.QueryString["id"];
com.Parameters.Add(PayID);

SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
lblSupplierName.Text = dr["cust_name"].ToString();

lblInvoiceNo.Text = dr["invoice_no"].ToString();
//foreach (ListItem list in lblInvoiceNo.Text)
//{
// lblInvoiceNo.Text = list.Text + "," + lblInvoiceNo.Text;
//}

lblDate.Text = dr["progDate"].ToString();
lblMode.Text = dr["pmode_name"].ToString();
lblcurrency1.Text = dr["pr_currency"].ToString();
lblAmount.Text = dr["pr_amount"].ToString();
lblBankName.Text = dr["bank_name"].ToString();
lblMICRCode.Text = dr["pr_bank_micr"].ToString();
lblBankBranch.Text = dr["pr_bank_branch"].ToString();
lblInstrumentNo.Text = dr["pr_instrument_no"].ToString();
lblInstrumentDate.Text = dr["progDateInstrument"].ToString();
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}
}
}

//*Code for *//
private void PaymentDetail()
{
using (SqlConnection PaymentConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
PaymentConn.Open();
if (Page.PreviousPage != null)
{

// TextBox _tbxMktFundRs = ((TextBox)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("tbxMktFundRs"));

DropDownList DDLSupplierName = (DropDownList)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("DDLSupplierName");
lblSupplierName.Text = DDLSupplierName.SelectedItem.Text;
Session["SupplierId"] = DDLSupplierName.SelectedValue.ToString();
// ListBox _ltboxInvoiceNo = (ListBox)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("ltboxInvoiceNo");
// lblInvoiceNo.Text = _ltboxInvoiceNo.SelectedItem.Text;

CheckBoxList chkboxlistInvoice = (CheckBoxList)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("chkboxlistInvoice");

foreach (ListItem list in chkboxlistInvoice.Items)
{
if (list.Selected)
{
lblInvoiceNo.Text = list.Text + "," + lblInvoiceNo.Text;
}
}

if (lblInvoiceNo.Text != "")
{
lblInvoiceNo.Text = lblInvoiceNo.Text.Substring(0, lblInvoiceNo.Text.Length - 1);
}

//lblInvoiceNo.Text = chkboxlistInvoice.SelectedItem.Text;

TextBox Date = (TextBox)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("txtDate");
lblDate.Text = Date.Text;
DropDownList Mode = (DropDownList)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("DDLMode");
lblMode.Text = Mode.SelectedItem.Text;
Session["ModeId"] = Mode.SelectedValue.ToString();
TextBox Amount = (TextBox)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("txtAmount");
lblAmount.Text = Amount.Text;
Session["Amount"] = Amount.Text;
Label Currency = (Label)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("lblcurrency");
lblcurrency1.Text = Currency.Text;

DropDownList BankName = (DropDownList)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("DDLBankName");
lblBankName.Text = BankName.SelectedItem.Text;
Session["BankId"] = BankName.SelectedValue.ToString();
TextBox MICRCode = (TextBox)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("txtMICRCode");
lblMICRCode.Text = MICRCode.Text;
TextBox BankBranch = (TextBox)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("txtBankBranch");
lblBankBranch.Text = BankBranch.Text;
TextBox InstrumentNo = (TextBox)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("txtInstrumentNo");
lblInstrumentNo.Text = InstrumentNo.Text;
TextBox InstrumentDate = (TextBox)PreviousPage.Master.FindControl("ContentPlaceHolder1").FindControl("txtInstrumentDate");
lblInstrumentDate.Text = InstrumentDate.Text;
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
PaymentConn.Close();
}

}
}
protected void BtnCopy_click(object sender, EventArgs e)
{
string id=Request.QueryString["id"].ToString();
Response.Redirect("addpaymentreceived.aspx?action=Copy&ID=" + id + "");
}

private string MakePageBody(string action)
{
if (action == "Print")
{
Printbody = " " + " " +

"" + " " +
"" + " " +
"" + " " +
"";

}
else if (action == "Email")
{
Printbody = "

Payment sent details

" + " " +

"

" + " " +

"" + " " +
"" + " " +
"" + " " +
"";

}
Printbody = Printbody + " " + " " +
" " + " " +
"" + " " +
"

Payment sent details

" + " " +

"

" + " " +
" " + " " +
" " + " " +
" " + " " +

" " + " " +
" " + " " +
" " + " " +
" " + " " +

" " + " " +
"" + " " +
" " + " " +
"" + " " +

"" + " " +
"" + " " +
" " + " " +
"" + " " +

"" + " " +
" " + " " +
" " + " " +
" " + " " +

" " + " " +
"" + " " +
" " + " " +
"" + " " +

"" + " " +
"" + " " +
" " + " " +
"" + " " +

"" + " " +
"" + " " +
" " + " " +
"" + " " +

" " + " " +
" " + " " +
" " + " " +
" " + " " +

" " + " " +
"" + " " +
" " + " " +
"" + " " +

" " + " " +
"" + " " +
" " + " " +
" " + " " +
" " + " " +
" " + " " +
"

Supplier Name:	" + lblSupplierName.Text + "
Invoice No. :	" + lblInvoiceNo.Text + "
Date:	" + lblDate.Text + "
Mode:	" + lblMode.Text + "
Amount:	" + lblAmount.Text + "
Bank Name:	" + lblBankName.Text + "
MICR Code:	" + lblMICRCode.Text + "
Bank Branch:	" + lblBankBranch.Text + "
Instrument No.:	" + lblInstrumentNo.Text + "
Instrument Date:	" + lblInstrumentDate.Text + "
	" + " " + " " + " " + "

";
return Printbody;
}
protected void BtnPrint_click(object sender, EventArgs e)
{
Session["PrintBody"] = MakePageBody("Print");
//Response.Redirect("Print.aspx");
Response.Write("");
}
protected void BtnEmail_click(object sender, EventArgs e)
{
Session["EmailBody"] = MakePageBody("Email");
Response.Redirect("SendEmail.aspx?Page=PaymnetReceived&ID=" + Request.QueryString["id"] + "");
}
protected void BtnBack_click(object sender, EventArgs e)
{
if (Request.QueryString.HasKeys())
{
Response.Redirect("viewpaymentreceived.aspx");
}
else
{
//Response.Redirect( "Back to previous page" );

Response.Redirect("addpaymentreceived.aspx");
}
}
protected void BtnExToPDF_click(object sender, EventArgs e)
{

}
protected void BtnSubmit_click(object sender, EventArgs e)
{
insertPaymentSent();
UpdateCustomerMaster();
UpdateRecInvoiceMaster();
Response.Redirect("viewpaymentreceived.aspx");
}

//Code for Update tblSupplierMaster //
private void UpdateCustomerMaster()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
if (conn.State == ConnectionState.Closed) conn.Open();

//where pm_id=@Payid
// string id = Request.QueryString["id"].ToString();
string str = "update tblCustomerMaster set cust_payment_due=cust_payment_due-" + Session["Amount"] + " where cust_id=" + Session["SupplierId"] + " ";
SqlCommand com = new SqlCommand(str, conn);
com.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}
}
}

//*Code for Insert the forms values into the Table*//
private void insertPaymentSent()
{
using (SqlConnection PaymentConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
PaymentConn.Open();
SqlCommand PaymantCom = new SqlCommand("insert_tblPaymentReceived", PaymentConn);
PaymantCom.CommandType = CommandType.StoredProcedure;
PaymantCom.Parameters.Add(new SqlParameter("@cust_id", Session["SupplierId"].ToString()));
PaymantCom.Parameters.Add(new SqlParameter("@invoice_no", lblInvoiceNo.Text));
string StrDate = lblDate.Text.Substring(3, 2) + "/" + lblDate.Text.Substring(0, 2) + "/" + lblDate.Text.Substring(6, 4);
PaymantCom.Parameters.Add(new SqlParameter("@pr_date", StrDate.ToString()));
PaymantCom.Parameters.Add(new SqlParameter("@pmode_id", Session["ModeId"].ToString()));
PaymantCom.Parameters.Add(new SqlParameter("@pr_amount", lblAmount.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pr_currency", lblcurrency1.Text));

PaymantCom.Parameters.Add(new SqlParameter("@bank_id", Session["BankId"].ToString()));
PaymantCom.Parameters.Add(new SqlParameter("@pr_bank_micr", lblMICRCode.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pr_instrument_no", lblInstrumentNo.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pr_bank_branch", lblBankBranch.Text));
string StrInstrDate = lblInstrumentDate.Text.Substring(3, 2) + "/" + lblInstrumentDate.Text.Substring(0, 2) + "/" + lblInstrumentDate.Text.Substring(6, 4);
PaymantCom.Parameters.Add(new SqlParameter("@pr_instrument_date", StrInstrDate.ToString()));

string ModeRealisation = Session["ModeRealisation"].ToString();
if (ModeRealisation == "Auto")
{
PaymantCom.Parameters.Add(new SqlParameter("@pr_cheque_status", "Realised"));
}
else if (ModeRealisation == "Manual")
{
PaymantCom.Parameters.Add(new SqlParameter("@pr_cheque_status", "UnRealised"));
}

//PaymantCom.Parameters.Add(new SqlParameter("@pr_cheque_status", "Yes"));
PaymantCom.Parameters.Add(new SqlParameter("@pr_created_by", int.Parse(Session["EmpID"].ToString())));
PaymantCom.Parameters.Add(new SqlParameter("@pr_delete", "No"));

//PaymantCom.Parameters.Add(new SqlParameter("@pm_active", "Yes"));

// PaymantCom.Parameters.Add(new SqlParameter("@pm_instrument_date", txtInstrumentDate.Text));
PaymantCom.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
PaymentConn.Close();
}

}

}
private void UpdateRecInvoiceMaster()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
if (conn.State == ConnectionState.Closed) conn.Open();

//where pm_id=@Payid
string strInvoice = lblInvoiceNo.Text;
ArrayList arrInvoice = new ArrayList();
string[] strInvoiceName = strInvoice.Split(',');
if (strInvoiceName.Length > 0)
{
for (int i = 0; i < strInvoiceName.Length; i++)
{
//arrInvoice.Add(strInvoiceName[i].ToString());
//Response.Write(strInvoiceName[i].ToString()+ "---");
string str = "update tblInvoiceMaster set inv_paid='Yes' where inv_no='" + strInvoiceName[i].ToString() + "' ";
SqlCommand com = new SqlCommand(str, conn);
com.ExecuteNonQuery();
}
}

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}
}
}
}

Login !!

2009-11-16T22:56:00.001-08:00

using rangtarang.Connection;

public partial class adminindex : System.Web.UI.Page
{
GetConnection objCon = new GetConnection();
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
txtuser.Focus();
}

}
protected void imgbtn_Click(object sender, ImageClickEventArgs e)
{
Login();
}

private void Login()
{
try
{
if (objCon.sqlConn.State == ConnectionState.Closed)
{
objCon.OpenConnection();
}

SqlCommand sqlquery = new SqlCommand("select * from tblAdmin where login_id='" + txtuser.Text + "' And login_pwd='" + txtpwd.Text + "' And login_active=1", objCon.sqlConn);
SqlDataReader loginReader = sqlquery.ExecuteReader();
if (loginReader.HasRows)
{
loginReader.Read();
if (loginReader["login_id"].ToString() == txtuser.Text && loginReader["login_pwd"].ToString() == txtpwd.Text)
{
lblerror.Visible = false;
Session["LoginId"] = loginReader["login_id"].ToString();
Session["AdminId"] = loginReader["login_pwd"].ToString();
Session["adminVALIDUSER"] = "true";
Session["AdminName"] = loginReader["admin_name"].ToString();
Session.Timeout = 30;
Response.Redirect("adminHome.aspx");
}
}
else
{
lblerror.Visible = true;
lblerror.ForeColor = System.Drawing.Color.Red;
lblerror.Text = "Invalid login-id or password !";
}
}
catch (Exception ex)
{
lblerror.Visible = true;
lblerror.ForeColor = System.Drawing.Color.Red;
lblerror.Text = "Error:" + ex.Message;
}
}
}

Master_Login !!

2009-11-16T22:55:00.001-08:00

public partial class MasterPage : System.Web.UI.MasterPage
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["adminVALIDUSER"] == null)
{
Response.Redirect("adminindex.aspx");
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Response.Buffer = true;
Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d);
Response.Expires = -1500;
Response.CacheControl = "no-cache";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetAllowResponseInBrowserHistory(false);

Session.Abandon();

Session["AdminId"] = null;
Session["LoginId"] = null;
Session["adminVALIDUSER"] = null;
Session["AdminName"] = null;
Response.Redirect("adminindex.aspx");

}
}

WebConfig !!

2009-11-16T22:53:00.000-08:00

appSettings>

add key="rangadmin" value="server=devesh;database=RAngTarang;Integrated Security=SSPI"/>
add key="VideoPath" value="videouploads">
/appSettings>

EditCompany !!

2009-11-16T22:52:00.000-08:00

public partial class EditCompany : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
selectCompDetails();
insertContPerDetail();
//addCountry();
}
private void selectCompDetails()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
conn.Open();
string id=Request.QueryString["id"].ToString();
string str = "select * from tblCompanyMaster where comp_id="+id+"";
SqlCommand com = new SqlCommand(str,conn);
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
txtCompName.Text = dr["comp_name"].ToString();
txtaddr1.Text = dr["comp_addr1"].ToString();
txtaddr2.Text = dr["comp_addr2"].ToString();
txtPin.Text = dr["comp_city"].ToString();
DDState.SelectedItem.Text =dr["comp_state"].ToString();
DDCountry.SelectedIndex = DDCountry.Items.IndexOf(DDCountry.Items.FindByValue(dr["comp_country"].ToString()));
txtPin.Text = dr["comp_pin"].ToString();
txtCompPhone.Text = dr["comp_phone"].ToString();
txtCompMobile.Text = dr["comp_mobile"].ToString();
txtCompFax.Text = dr["comp_fax"].ToString();
txtCompEmail.Text = dr["comp_email"].ToString();
txtWebsit.Text = dr["comp_website"].ToString();
txtVatNo.Text = dr["comp_vat_no"].ToString();
txtTin_CstNo.Text = dr["comp_tin_cst_no"].ToString();
}

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}

}

}
private void insertContPerDetail()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
conn.Open();

string str = "select * from tblEmployeeMaster where emp_id=" + DDName.SelectedValue.ToString() + "";
SqlCommand insertCom = new SqlCommand(str, conn);
SqlDataReader dr = insertCom.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
txtContPersName.Text = dr["emp_name"].ToString();
txtDesi.Text = dr["emp_designation"].ToString();
txtCPPhone.Text = dr["emp_phone"].ToString(); ;
txtCPMobile.Text = dr["emp_mobile"].ToString(); ;
txtCPFax.Text = dr["emp_fax"].ToString(); ;
txtCPEmail.Text = dr["emp_email"].ToString(); ;

}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}
}

}
private void addCountry()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
DDCountry.Items.Clear();
conn.Open();
string str = "select country_name,country_id from tblCountryMaster";
ListItem Locat;
SqlCommand insertCom = new SqlCommand(str, conn);
SqlDataReader userReader = insertCom.ExecuteReader();
if (userReader.HasRows)
{
while (userReader.Read())
{
ListItem insert;
insert = new ListItem(userReader["country_name"].ToString(), userReader["country_id"].ToString());
DDCountry.Items.Add(insert);

}
}

Locat = new ListItem("Select--------------------->");
DDCountry.Items.Insert(0, Locat);
userReader.Close();

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}

}

}
protected void tbSubmit_Click(object sender, EventArgs e)
{

}
}

AddPaymentSent !!

2009-11-16T22:49:00.000-08:00

public partial class AddPaymentsSent : System.Web.UI.Page
{
ListItem lstInvoice;
IDLDPLMain objIDLDPLMain = new IDLDPLMain();
DynMenu objDynMenu = new DynMenu();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
txtDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
if (Request.QueryString.HasKeys())
{
if (Request.QueryString["Action"] == "Edit")
{
lblPaymentSent.Text = "edit payment sent ";
objIDLDPLMain.AddlogDetails("Edit Payment Sent", Request.Url.ToString());
btnSubmit.Visible = false;
btnSubmit.Text = "Save";
SupplierName();
ModeName();
BankName();
// SelectInvoiceNoForEdit();
FillPaymentDetail();
// SelectInvoiceNoForEdit();

}
else if (Request.QueryString["action"] == "Copy")
{
lblPaymentSent.Text = "copy payment sent ";
objIDLDPLMain.AddlogDetails("Copy Payment Sent", Request.Url.ToString());
BtnSave.Visible = false;
SupplierName();
ModeName();
BankName();
FillPaymentDetail();
}
}
else
{
if (!Page.IsPostBack)
{
if (objDynMenu.PermissionOk("add", "Accounts", "Payment Sent") == "Yes")
{
objIDLDPLMain.AddlogDetails("New Payment Sent", Request.Url.ToString());
BtnSave.Visible = false;
SupplierName();
ModeName();
BankName();
}
else
{
Response.Redirect("adminhome.aspx");
}
}
}
}
}

//Code for Filling The Page For Edit and copy//
private void FillPaymentDetail()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
conn.Open();
string id = Request.QueryString["id"].ToString();
string str = "select * from viewPaymentMade where pm_id="+id+"";
//string str = "select * from viewPaymentMade where supl_id=@Payid ";
SqlCommand com = new SqlCommand(str, conn);
//DataSet ds=new DataSet();
//SqlParameter PAYID = new SqlParameter("@Payid", SqlDbType.Int, 4);
//PAYID.Value = Request.QueryString["id"];
//com.Parameters.Add(PAYID);

SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
DDLSupplierName.SelectedIndex = DDLSupplierName.Items.IndexOf(DDLSupplierName.Items.FindByText(dr["supl_name"].ToString()));
Session["Supl_id"] = dr["supl_id"].ToString();
// SelectInvoiceNoForEdit();
Session["InvoiceNo"] = dr["supl_invoice_no"].ToString();
DisplayInvoice(dr["supl_invoice_no"].ToString());
chkboxlistInvoice.SelectedValue = dr["supl_invoice_no"].ToString();
Session["InvoiceId"] = dr["supl_invoice_no"].ToString();
//ltboxInvoiceNo.Text = dr["supl_invoice_no"].ToString();
txtDate.Text = dr["progDate"].ToString();
DDLMode.SelectedIndex = DDLMode.Items.IndexOf(DDLMode.Items.FindByValue(dr["pmode_id"].ToString()));
DDLMode.SelectedValue = dr["pmode_id"].ToString();

Session["ChequeStatus"] = dr["pm_cheque_status"].ToString();

txtAmount.Text = dr["pm_amount"].ToString();
lblCurrency.Text = dr["pm_currency"].ToString();
// DDLBankName.SelectedIndex = DDLBankName.Items.IndexOf(DDLBankName.Items.FindByValue(dr["bank_id"].ToString()));
DDLBankName.SelectedValue = dr["bank_id"].ToString();
txtMICRCode.Text = dr["pm_bank_micr"].ToString();
txtBankBranch.Text = dr["pm_bank_branch"].ToString();
txtInstrumentNo.Text = dr["pm_instrument_no"].ToString();
txtInstrumentDate.Text = dr["progDateInstrument"].ToString();
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}
}
}
//*Code for Filling Supplier DropDown List with Suppliers Name*//

private ArrayList GetInvoiceNo(string strInvoice)
{
ArrayList arrInvoice = new ArrayList();
string[] strInvoiceName = strInvoice.Split(',');

if (strInvoiceName.Length > 0)
{
for (int i = 0; i < strInvoiceName.Length; i++)
{
arrInvoice.Add(strInvoiceName[i].ToString());
}
}
return arrInvoice;
}

private void DisplayInvoice(string strInvoice)
{

chkboxlistInvoice.DataSource = GetInvoiceNo(strInvoice);
chkboxlistInvoice.DataBind();
CheckAll();

}

private void CheckAll()
{
foreach (ListItem list in chkboxlistInvoice.Items)
{
list.Selected = true;
}
}

private void SupplierName()
{
using (SqlConnection SuppConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
DDLSupplierName.Items.Clear();
SuppConn.Open();
string suppstr = "select supl_id,supl_name from tblSupplierMaster where supl_active='Yes' and supl_delete='No'";
SqlCommand SuppCom = new SqlCommand(suppstr, SuppConn);
SqlDataReader SuppDR = SuppCom.ExecuteReader();
if (SuppDR.HasRows)
{
ListItem insertSuppName;
while (SuppDR.Read())
{
insertSuppName = new ListItem(SuppDR["supl_name"].ToString(), SuppDR["supl_id"].ToString());
DDLSupplierName.Items.Add(insertSuppName);
}
insertSuppName = new ListItem("Select--------------------->");
DDLSupplierName.Items.Insert(0, insertSuppName);
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
SuppConn.Close();
}
}
}

//*Code for Filling Bank DropDown List with Bank Name*//
private void BankName()
{
using (SqlConnection SuppConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
DDLBankName.Items.Clear();
SuppConn.Open();
string suppstr = "select bank_id,bank_name from tblBankMaster where bank_active='Yes' and bank_delete='No'";
SqlCommand SuppCom = new SqlCommand(suppstr, SuppConn);
SqlDataReader SuppDR = SuppCom.ExecuteReader();
if (SuppDR.HasRows)
{
ListItem insertSuppName;
while (SuppDR.Read())
{
insertSuppName = new ListItem(SuppDR["bank_name"].ToString(), SuppDR["bank_id"].ToString());
DDLBankName.Items.Add(insertSuppName);
}
insertSuppName = new ListItem("Select--------------------->");
DDLBankName.Items.Insert(0, insertSuppName);
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
SuppConn.Close();
}
}
}

//*Code for Filling Mode DropDown List with Mode Name*//
private void ModeName()
{
using (SqlConnection SuppConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
DDLMode.Items.Clear();
SuppConn.Open();
string suppstr = "select pmode_id,pmode_name from tblPaymentMode where pmode_active='Yes' and pmode_delete='No'";
SqlCommand SuppCom = new SqlCommand(suppstr, SuppConn);
SqlDataReader SuppDR = SuppCom.ExecuteReader();
if (SuppDR.HasRows)
{
ListItem insertSuppName;
while (SuppDR.Read())
{
insertSuppName = new ListItem(SuppDR["pmode_name"].ToString(), SuppDR["pmode_id"].ToString());
DDLMode.Items.Add(insertSuppName);
}
insertSuppName = new ListItem("Select--------------------->");
DDLMode.Items.Insert(0, insertSuppName);
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
SuppConn.Close();
}
}
}
//*Code for Gating the Currency Name *//
private void CurrencyName()
{
using (SqlConnection SuppConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
// DDLBankName.Items.Clear();
//DDLMode.Items.Clear();
SuppConn.Open();
//where supl_active='Yes' and supl_delete='No'
if (DDLSupplierName.SelectedValue.ToString() != "Select--------------------->")
{
string suppstr = "select * from viewSupplierCurrencyForPaySent where supl_id=" + DDLSupplierName.SelectedValue.ToString() + "";

SqlCommand SuppCom = new SqlCommand(suppstr, SuppConn);
SqlDataReader SuppDR = SuppCom.ExecuteReader();
if (SuppDR.HasRows)
{

while (SuppDR.Read())
{
lblCurrency.Text = SuppDR["currency_name"].ToString();
Session["CurrencyId"] = SuppDR["currency_id"].ToString();
}

}
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
SuppConn.Close();
}
}
}
//*Code for Insert the Forms values into the Table*//
private void insertPaymentSent()
{
using (SqlConnection PaymentConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
PaymentConn.Open();
SqlCommand PaymantCom = new SqlCommand("insert_tblPaymentMade", PaymentConn);
PaymantCom.CommandType = CommandType.StoredProcedure;
PaymantCom.Parameters.Add(new SqlParameter("@supl_id", DDLSupplierName.SelectedValue.ToString()));
//PaymantCom.Parameters.Add(new SqlParameter("@supl_invoice_no", ltboxInvoiceNo.Text));
string StrDate = txtDate.Text.Substring(3, 2) + "/" + txtDate.Text.Substring(0, 2) + "/" + txtDate.Text.Substring(6, 4);
PaymantCom.Parameters.Add(new SqlParameter("@pm_date", StrDate.ToString()));
PaymantCom.Parameters.Add(new SqlParameter("@pmode_id", DDLMode.SelectedValue ));
PaymantCom.Parameters.Add(new SqlParameter("@pm_amount", txtAmount.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pm_currency", lblCurrency.Text));
PaymantCom.Parameters.Add(new SqlParameter("@bank_id", DDLBankName.SelectedValue.ToString()));
PaymantCom.Parameters.Add(new SqlParameter("@pm_bank_micr", txtMICRCode.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pm_instrument_no", txtInstrumentNo.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pm_bank_branch", txtBankBranch.Text));
string StrInstrDate = txtDate.Text.Substring(3, 2) + "/" + txtDate.Text.Substring(0, 2) + "/" + txtDate.Text.Substring(6, 4);
PaymantCom.Parameters.Add(new SqlParameter("@pm_instrument_date", StrInstrDate.ToString()));

PaymantCom.Parameters.Add(new SqlParameter("@pm_cheque_status","Unrealised"));
PaymantCom.Parameters.Add(new SqlParameter("@pm_created_by", 2));
PaymantCom.Parameters.Add(new SqlParameter("@pm_active", "Yes"));
PaymantCom.Parameters.Add(new SqlParameter("@pm_delete", "No"));
// PaymantCom.Parameters.Add(new SqlParameter("@pm_instrument_date", txtInstrumentDate.Text));
PaymantCom.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
PaymentConn.Close();
}
}
}

protected void btnCancel_click(object sender, EventArgs e)
{
if (Request.QueryString.HasKeys())
{
Response.Redirect("viewpaymentsent.aspx");
}
else
{
Response.Redirect("adminhome.aspx");
}
}
protected void btnSubmit_click(object sender, EventArgs e)
{

//insertPaymentSent();
//Response.Redirect("paymentsentdetail.aspx");
}

//*Code for update the paymentsent*//
private void UpdatePaymentSent()
{
string InvoiceEdit=String.Empty;
using (SqlConnection PaymentConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
PaymentConn.Open();
SqlCommand PaymantCom = new SqlCommand("update_tblPaymentMade", PaymentConn);
PaymantCom.CommandType = CommandType.StoredProcedure;
PaymantCom.Parameters.Add(new SqlParameter("@pm_id", Request.QueryString["id"]));
PaymantCom.Parameters.Add(new SqlParameter("@supl_id", DDLSupplierName.SelectedValue.ToString()));
string InvoiceNo = Session["InvoiceId"].ToString();
foreach (ListItem list in chkboxlistInvoice.Items)
{

InvoiceEdit = list.Text + "," + InvoiceEdit.ToString();
}
InvoiceEdit = InvoiceEdit.ToString().Substring(0, InvoiceEdit.ToString().Length-1);

//Session["InvoiceNo"] = Session["InvoiceNo"].ToString().Substring(0,Session["InvoiceNo"].ToString().Length-1);
PaymantCom.Parameters.Add(new SqlParameter("@supl_invoice_no", InvoiceEdit));

string StrDate = txtDate.Text.Substring(3, 2) + "/" + txtDate.Text.Substring(0, 2) + "/" + txtDate.Text.Substring(6, 4);
PaymantCom.Parameters.Add(new SqlParameter("@pm_date", StrDate.ToString()));
PaymantCom.Parameters.Add(new SqlParameter("@pmode_id", DDLMode.SelectedValue));
PaymantCom.Parameters.Add(new SqlParameter("@pm_amount", txtAmount.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pm_currency", lblCurrency.Text));
PaymantCom.Parameters.Add(new SqlParameter("@bank_id", DDLBankName.SelectedValue.ToString()));
PaymantCom.Parameters.Add(new SqlParameter("@pm_bank_micr", txtMICRCode.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pm_instrument_no", txtInstrumentNo.Text));
PaymantCom.Parameters.Add(new SqlParameter("@pm_bank_branch", txtBankBranch.Text));
string StrInstrDate = txtDate.Text.Substring(3, 2) + "/" + txtDate.Text.Substring(0, 2) + "/" + txtDate.Text.Substring(6, 4);
PaymantCom.Parameters.Add(new SqlParameter("@pm_instrument_date", StrInstrDate.ToString()));

//Session["ModeRealisatin"]=DDLMode.SelectedValue;

//if (DDLMode.SelectedIndex <=0 )
//{
// PaymantCom.Parameters.Add(new SqlParameter("@pm_cheque_status",DDLMode.SelectedValue));
//}
// string ModeRealisation = Session["ModeRealisation"].ToString();
if (Session["ModeRealisation"] == null)
{
PaymantCom.Parameters.Add(new SqlParameter("@pm_cheque_status", Session["ChequeStatus"].ToString()));
}
else
{
string ModeRealisation = Session["ModeRealisation"].ToString();
if (ModeRealisation == "Auto")
{
PaymantCom.Parameters.Add(new SqlParameter("@pm_cheque_status", "Realised"));
}
else if (ModeRealisation == "Manual")
{
PaymantCom.Parameters.Add(new SqlParameter("@pm_cheque_status", "UnRealised"));
}
}
// PaymantCom.Parameters.Add(new SqlParameter("@pm_cheque_status", "Yes"));
PaymantCom.Parameters.Add(new SqlParameter("@pm_edit_by", 2));
PaymantCom.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
PaymentConn.Close();
}
}

}
protected void DDLBankName_SelectedIndexChanged(object sender, EventArgs e)
{
BankMICRCode();
}
//*Code for Get the Bank's MICR*//
private void BankMICRCode()
{
using (SqlConnection BankMICRConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{

BankMICRConn.Open();
txtMICRCode.Text = "";
if (DDLBankName.SelectedValue.ToString() != "Select--------------------->")
{
string BankMICRstr = "select bank_micr from tblBankMaster where bank_id=" + DDLBankName.SelectedValue.ToString() + " and bank_active='Yes' and bank_delete='No'";
SqlCommand BankMICRCom = new SqlCommand(BankMICRstr, BankMICRConn);
SqlDataReader BankMICRDR = BankMICRCom.ExecuteReader();
if (BankMICRDR.HasRows)
{
BankMICRDR.Read();
txtMICRCode.Text = BankMICRDR["bank_micr"].ToString();
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
BankMICRConn.Close();
}
}
}
protected void DDLSupplierName_SelectedIndexChanged(object sender, EventArgs e)
{
SelectInvoiceNo();
CurrencyName();
}

//*Code for Get the Inventory No*//
private void SelectInvoiceNo()
{
using (SqlConnection BankMICRConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{

chkboxlistInvoice.Items.Clear();
if (DDLSupplierName.SelectedValue.ToString() != "Select--------------------->")
{
BankMICRConn.Open();
string BankMICRstr = "select rinv_no,supl_id from tblRecInvoice where rinv_paid='No' and supl_id=" + DDLSupplierName.SelectedValue.ToString() + " ";
SqlCommand BankMICRCom = new SqlCommand(BankMICRstr, BankMICRConn);
SqlDataReader BankMICRDR = BankMICRCom.ExecuteReader();
if (BankMICRDR.HasRows)
{
ListItem insertSuppName;
while (BankMICRDR.Read())
{
insertSuppName = new ListItem(BankMICRDR["rinv_no"].ToString(), BankMICRDR["supl_id"].ToString());
chkboxlistInvoice.Items.Add(insertSuppName);
}
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
BankMICRConn.Close();
}
}
}

//*Code for Get the Inventory No for Edit*//
private void SelectInvoiceNoForEdit()
{
using (SqlConnection BankMICRConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
chkboxlistInvoice.Items.Clear();

BankMICRConn.Open();
string BankMICRstr = "select rinv_no,supl_id from tblRecInvoice where supl_id=" + Session["Supl_id"].ToString() + " ";
SqlCommand BankMICRCom = new SqlCommand(BankMICRstr, BankMICRConn);
SqlDataReader BankMICRDR = BankMICRCom.ExecuteReader();
if (BankMICRDR.HasRows)
{
ListItem insertSuppName;
while (BankMICRDR.Read())
{
insertSuppName = new ListItem(BankMICRDR["rinv_no"].ToString(), BankMICRDR["supl_id"].ToString());
//ltboxInvoiceNo.Items.Add(insertSuppName);
chkboxlistInvoice.Items.Add(insertSuppName);
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
BankMICRConn.Close();
}
}
}
protected void BtnSave_click(object sender, EventArgs e)
{
UpdatePaymentSent();
Response.Redirect("viewpaymentsent.aspx");
}
protected void DDLMode_SelectedIndexChanged(object sender, EventArgs e)
{
ModeRealisation();
}
//*Code for Gating the ModeRealisation Name *//
private void ModeRealisation()
{
using (SqlConnection SuppConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
SuppConn.Open();
//where supl_active='Yes' and supl_delete='No' tblPaymentMode ,pmode_realisation
if (DDLMode.SelectedValue.ToString() != "Select--------------------->")
{
string suppstr = "select * from tblPaymentMode where pmode_id=" + DDLMode.SelectedValue.ToString() + "";
SqlCommand SuppCom = new SqlCommand(suppstr, SuppConn);
SqlDataReader SuppDR = SuppCom.ExecuteReader();
if (SuppDR.HasRows)
{
SuppDR.Read();
Session["ModeRealisation"] = SuppDR["pmode_realisation"].ToString();
}
}

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
SuppConn.Close();
}
}
}

//*Code for Deleting record for Edit *//
private void DeleteRecForEditInvoiceNo()
{
using (SqlConnection SuppConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{

SuppConn.Open();
//where supl_active='Yes' and supl_delete='No' tblPaymentMode ,pmode_realisation
string suppstr = "Delete tblPaymentMade where pm_id="+Request.QueryString["id"]+"";
SqlCommand SuppCom = new SqlCommand(suppstr, SuppConn);
SuppCom.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
SuppConn.Close();
}
}
}

}

ViewPaymentSent !!

2009-11-16T22:47:00.000-08:00

public partial class viewpaymentsent : System.Web.UI.Page
{
private const string ASCENDING = " ASC";
private const string DESCENDING = " DESC";
string _Strfill;
IDLDPLMain objIDLDPLMain = new IDLDPLMain();
string strPayOperation = String.Empty;
string strPayApprove = String.Empty;
DynMenu objDynMenu = new DynMenu();

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
objIDLDPLMain.AddlogDetails("View Payment Sent", Request.Url.ToString());
fillviewPayment();
}

}
//*Code for Fill The GridView*//
private void fillviewPayment()
{
using (SqlConnection ViewPayconn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
ViewPayconn.Open();
string viewpaymentstr;
if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
viewpaymentstr = "select * from viewPaymentMadeNew where pm_delete='No' order by pm_id desc";
}
else
{
viewpaymentstr = "select * from viewPaymentMade where pm_delete='No' AND (loc_id = " + Session["loglocid"] + ") order by pm_id desc";
}
SqlDataAdapter viewPayDA = new SqlDataAdapter(viewpaymentstr, ViewPayconn);
DataSet ds = new DataSet();
viewPayDA.Fill(ds,"tmptable");

if (ds.Tables["tmptable"].Rows.Count == 0)
{
gviewPaymentSent.Visible = false;
hidetr.Visible = true;
EmptyMsg.Visible = true;
}
else
{
gviewPaymentSent.Visible = true;
EmptyMsg.Visible = false;
hidetr.Visible = false;
gviewPaymentSent.DataSource = ds;
gviewPaymentSent.DataBind();
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
ViewPayconn.Close();
}
}
}

//*Below 4 function ( code ) are used for Sorting*//
private void SortGridView(string sortExpression, string direction)
{
// You can cache the DataTable for improving performance
DataTable dt = GetData().Tables[0];
DataView dv = new DataView(dt);

dv.Sort = sortExpression + direction;

gviewPaymentSent.DataSource = dv;
gviewPaymentSent.DataBind();

}
private DataSet GetData()
{

SqlConnection StWConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]);

//SqlDataAdapter ad = new SqlDataAdapter("SELECT * from emplistview where emp_delete='No' order by emp_id desc", StWConn);
SqlDataAdapter ad;

if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
ad = new SqlDataAdapter("select * from viewPaymentMadeNew where pm_delete='No' order by pm_id desc", StWConn);
}
else
{
ad = new SqlDataAdapter("select * from viewPaymentMade where pm_delete='No' AND (loc_id = " + Session["loglocid"] + ") order by pm_id desc", StWConn);
}
DataSet ds = new DataSet();

ad.Fill(ds);

return ds;

}
public SortDirection GridViewSortDirection
{
get
{
if (ViewState["sortDirection"] == null)
ViewState["sortDirection"] = SortDirection.Ascending;
else
ViewState["sortDirection"] = SortDirection.Descending;
return (SortDirection)ViewState["sortDirection"];
}
set { ViewState["sortDirection"] = value; }
}
protected void gviewPaymentSent_Sorting(object sender, GridViewSortEventArgs e)
{
{
string sortExpression = e.SortExpression;

if (GridViewSortDirection == SortDirection.Ascending)
{
GridViewSortDirection = SortDirection.Descending;
SortGridView(sortExpression, DESCENDING);
}
else
{
GridViewSortDirection = SortDirection.Ascending;
SortGridView(sortExpression, ASCENDING);
ViewState["sortDirection"] = null;
}
}
}
protected void gviewPaymentSent_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gviewPaymentSent.PageIndex = e.NewPageIndex;
fillviewPayment();
}
protected void gviewPaymentSent_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Separator)
{
Label lblstatus = (Label)e.Row.Cells[9].FindControl("lblActive");
Label lblid = (Label)e.Row.Cells[9].FindControl("lblID");
Label lblDel = (Label)e.Row.Cells[9].FindControl("lblDel");

string status = lblstatus.Text.ToString();
string id = lblid.Text.ToString();

// Realised
// UnRealised

strPayOperation = objDynMenu.GetPermission("Accounts", "Payment Sent");

//////////////////////////Begin Approval Permission//////////////////////////////
if (strPayOperation.Length.ToString() != "0")
{
strPayOperation = strPayOperation.ToString().Substring(0, strPayOperation.Length - 1);
ArrayList myList = new ArrayList();
char[] sep ={ ',' };

string[] values = strPayOperation.Split(sep);

int i;
for (i = 0; i < values.Length; i++)
{
myList.Add(values[i]);
if (values[i].ToString().ToLower() == "approve")
{
strPayApprove = "approve";
break;
}
}
}

if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
if (status.ToString() == "Realised")
{
e.Row.Cells[7].Text = "";
}
else
{
e.Row.Cells[7].Text = "";
}
}
else if (strPayApprove.ToString() == "approve")
{
if (status.ToString() == "Realised")
{
e.Row.Cells[7].Text = "";
}
else
{
e.Row.Cells[7].Text = "";
}
}
else
{
if (status.ToString() == "Realised")
{
e.Row.Cells[7].Text = "";
}
else
{
e.Row.Cells[7].Text = "";
}
}
//////////////////////////End Approval Permission//////////////////////////////

////////////////Begin Delete Permissions////////////////////////
if (strPayOperation.Length.ToString() != "0")
{
strPayOperation = strPayOperation.ToString().Substring(0, strPayOperation.Length - 1);
ArrayList myList = new ArrayList();
char[] sep ={ ',' };
string[] values = strPayOperation.Split(sep);
int i;
for (i = 0; i < values.Length; i++)
{
myList.Add(values[i]);
if (values[i].ToString().ToLower() == "Delete")
{
lblDel.Text="";
break;
}
else if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
lblDel.Text = "";
}
else
{
lblDel.Text = "";
}
}
}
else if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
lblDel.Text = "";
}
else
{
lblDel.Text = "";
}
/////////////////End Delete Permissions///////////////////////
}
}
protected void BtnSubmit_click(object sender, EventArgs e)
{
Search();
}

//* Code for Search*//
private void Search()
{
using (SqlConnection ViewPayconn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
ViewPayconn.Open();
if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
_Strfill = "select * from viewPaymentMadeNew ";
}
else
{
_Strfill = "select * from viewPaymentMade ";
}
string serkey;
serkey = txtSearch.Text;
if (txtSearch.Text != "")
{
if (DDLSearch.SelectedValue != "Select")
{
if (DDLSearch.SelectedValue == "Supplier Name")
{
// _Strfill = _Strfill + " where supl_name like '%" + serkey.ToString() + "%'";
if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
_Strfill = _Strfill + " where supl_name = '" + serkey.ToString() + "'";
}
else
{
_Strfill = _Strfill + " where supl_name = '" + serkey.ToString() + "' AND (loc_id = " + Session["loglocid"] + ")";
}
}
else if (DDLSearch.SelectedValue == "Date")
{
if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
_Strfill = _Strfill + " where progDate='" + serkey.ToString() + "'";
}
else
{
_Strfill = _Strfill + " where progDate='" + serkey.ToString() + "' AND (loc_id = " + Session["loglocid"] + ")";
}
}
else if (DDLSearch.SelectedValue == "Mode")
{
if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
_Strfill = _Strfill + " where pmode_name='" + serkey.ToString() + "'";
}
else
{
_Strfill = _Strfill + " where pmode_name='" + serkey.ToString() + "' AND (loc_id = " + Session["loglocid"] + ")";
}
}
else if (DDLSearch.SelectedValue == "Currency")
{
if (Session["logLevelName"].ToString().Trim().ToLower() == "admin")
{
_Strfill = _Strfill + " where pm_Currency='" + serkey.ToString() + "'";
}
else
{
_Strfill = _Strfill + " where pm_Currency='" + serkey.ToString() + "' AND (loc_id = " + Session["loglocid"] + ")";
}
}

}
}
// _Strfill = _Strfill + " order by pm_id desc";
PopulateSearchGrid(_Strfill);

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
ViewPayconn.Close();
}
}
}

public void PopulateSearchGrid(string StrKey)
{
try
{
using (SqlConnection IDLDPLConn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
IDLDPLConn.Open();
SqlDataAdapter IDLDPLda = new SqlDataAdapter(StrKey.ToString(), IDLDPLConn);
DataSet IDLDPLds = new DataSet();
IDLDPLda.Fill(IDLDPLds,"Temp");
if (IDLDPLds.Tables["Temp"].Rows.Count == 0)
{
gviewPaymentSent.Visible = false;
hidetr.Visible = true;
EmptyMsg.Visible = true;
}
else
{
gviewPaymentSent.Visible = true;
EmptyMsg.Visible = false;
hidetr.Visible = false;
gviewPaymentSent.DataSource = IDLDPLds;
gviewPaymentSent.DataBind();
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
}

}

AddLocation !!

2009-11-16T22:42:00.000-08:00

protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.HasKeys())
{
if (Request.QueryString["action"].ToString() == "edit")
{
if (!Page.IsPostBack)
{
lblLocation.Text = "Edit Location";
btnSubmit.Text = "Save";
addLocType();
addCompName();
addCountry();
FillLocationDetail();

}
}
else if (Request.QueryString["action"].ToString() == "copy")
{
if (!Page.IsPostBack)
{
lblLocation.Text = "Copy Location";
btnSubmit.Text = "Save";
addLocType();
addCompName();
addCountry();
FillLocationDetail();
//addCountry();
}

}
}
else
{
if (!Page.IsPostBack)
{
addLocType();
addCompName();
addCountry();
}
}
}

######################################

// Add Company Location Type

private void addLocType()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
DDCountry.Items.Clear();
conn.Open();
string str = "select loc_type_name,loc_type_id from tblLocationType where loc_type_active='Yes' and loc_type_delete='No'";
ListItem Locat;
SqlCommand insertCom = new SqlCommand(str, conn);
SqlDataReader userReader = insertCom.ExecuteReader();
if (userReader.HasRows)
{
while (userReader.Read())
{
ListItem insert;
insert = new ListItem(userReader["loc_type_name"].ToString(), userReader["loc_type_id"].ToString());
DDLocation.Items.Add(insert);

}
}

Locat = new ListItem("Select--------------------->");
DDLocation.Items.Insert(0, Locat);
userReader.Close();

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}

}

}

##########################################

// Add Company Name

private void addCompName()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
DDCountry.Items.Clear();
conn.Open();
string str = "select comp_name,comp_id from tblCompanyMaster where comp_active='Yes' and comp_delete='No'";
ListItem Locat;
SqlCommand insertCom = new SqlCommand(str, conn);
SqlDataReader userReader = insertCom.ExecuteReader();
if (userReader.HasRows)
{
while (userReader.Read())
{
ListItem insert;
insert = new ListItem(userReader["comp_name"].ToString(), userReader["comp_id"].ToString());
DDCompName.Items.Add(insert);

}
}

Locat = new ListItem("Select--------------------->");
DDCompName.Items.Insert(0, Locat);
userReader.Close();

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}

}

}

#######################################

// Add Country
private void addCountry()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
DDCountry.Items.Clear();
conn.Open();
string str = "select country_name,country_id from tblCountryMaster where country_active='Yes'and country_delete='No'";
ListItem Locat;
SqlCommand insertCom = new SqlCommand(str, conn);
SqlDataReader userReader = insertCom.ExecuteReader();
if (userReader.HasRows)
{
while (userReader.Read())
{
ListItem insert;
insert = new ListItem(userReader["country_name"].ToString(), userReader["country_id"].ToString());
DDCountry.Items.Add(insert);

}
}

Locat = new ListItem("Select--------------------->");
DDCountry.Items.Insert(0, Locat);
userReader.Close();

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}

}

}

###################################################

// Add Company Location
private void LocationAdd()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
conn.Open();
SqlCommand comLocation = new SqlCommand("insert_tblLocationMaster", conn);
comLocation.CommandType = CommandType.StoredProcedure;
comLocation.Parameters.Add(new SqlParameter("@comp_id", DDCompName.SelectedValue.ToString()));
comLocation.Parameters.Add(new SqlParameter("@loc_type_id", DDLocation.SelectedValue.ToString()));
comLocation.Parameters.Add(new SqlParameter("@loc_name", txtLocName.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_contect_person", txtContPerson.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_addr1", txtaddr1.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_addr2", txtaddr2.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_city", txtcity.Text));

if (DDState.SelectedItem.Text == "Others")
{
comLocation.Parameters.Add(new SqlParameter("@loc_state", txtother.Text));
}
else
{
comLocation.Parameters.Add(new SqlParameter("@loc_state", DDState.SelectedItem.Text));
}

// comLocation.Parameters.Add(new SqlParameter("@loc_state", DDState.SelectedItem.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_country", DDCountry.SelectedValue.ToString()));
comLocation.Parameters.Add(new SqlParameter("@loc_pin", txtpin.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_phone", txtphone.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_mobile", txtmobile.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_fax", txtfax.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_email", txtemail.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_active", "Yes"));
comLocation.Parameters.Add(new SqlParameter("@loc_delete", "No"));
comLocation.Parameters.Add(new SqlParameter("@loc_add_by", int.Parse(Session["EmpID"].ToString())));
//comLocation.Parameters.Add(new SqlParameter("@loc_add_date", "No"));

comLocation.ExecuteNonQuery();

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{

}

}

}
private void FillLocationDetail()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
conn.Open();

string id = Request.QueryString["id"].ToString();
// string str = "select * from tblLocationMaster ";
string str = "select * from viewLocationDetail where loc_id=@Locid";

SqlCommand com = new SqlCommand(str, conn);
SqlParameter LOCID = new SqlParameter("@Locid", SqlDbType.Int, 4);
LOCID.Value = Request.QueryString["id"];
com.Parameters.Add(LOCID);
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
DDCompName.SelectedIndex = DDCompName.Items.IndexOf(DDCompName.Items.FindByValue(dr["comp_id"].ToString()));
DDLocation.SelectedIndex = DDLocation.Items.IndexOf(DDLocation.Items.FindByValue(dr["loc_type_id"].ToString()));
txtLocName.Text = dr["loc_name"].ToString();
ViewState["locName"] = dr["loc_name"].ToString();

txtContPerson.Text = dr["loc_contect_person"].ToString();
txtaddr1.Text = dr["loc_addr1"].ToString();
txtaddr2.Text = dr["loc_addr2"].ToString();
txtcity.Text = dr["loc_city"].ToString();
// DDState.SelectedItem.Text = dr["loc_state"].ToString();
DDCountry.SelectedIndex = DDCountry.Items.IndexOf(DDCountry.Items.FindByValue(dr["loc_country"].ToString()));
if (DDCountry.SelectedIndex > 0)
{
DDState.SelectedIndex = DDState.Items.IndexOf(DDState.Items.FindByText(dr["loc_state"].ToString()));
if (DDState.SelectedIndex <= 0)
{

txtother.Visible = true;
txtother.Text = dr["loc_state"].ToString();
DDState.SelectedIndex = DDState.Items.Count - 1;

}
}
else
{
txtother.Visible = false;

}
txtpin.Text = dr["loc_pin"].ToString();
txtphone.Text = dr["loc_phone"].ToString();
txtmobile.Text = dr["loc_mobile"].ToString();
txtfax.Text = dr["loc_fax"].ToString();
txtemail.Text = dr["loc_email"].ToString();

}

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
conn.Close();
}

}

}
/*This code is used for update the LocationDetail*/
private void UpdateLocationDetail()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{
try
{
conn.Open();
SqlCommand comLocation = new SqlCommand("update_tblLocationMaster1", conn);
comLocation.CommandType = CommandType.StoredProcedure;
string id = Request.QueryString["id"].ToString();
comLocation.Parameters.Add(new SqlParameter("@loc_id", id));
comLocation.Parameters.Add(new SqlParameter("@comp_id", DDCompName.SelectedValue.ToString()));
comLocation.Parameters.Add(new SqlParameter("@loc_type_id", DDLocation.SelectedValue.ToString()));
comLocation.Parameters.Add(new SqlParameter("@loc_name", txtLocName.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_contect_person", txtContPerson.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_addr1", txtaddr1.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_addr2", txtaddr2.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_city", txtcity.Text));

if (DDState.SelectedItem.Text == "Others")
{
comLocation.Parameters.Add(new SqlParameter("@loc_state", txtother.Text));
}
else
{
comLocation.Parameters.Add(new SqlParameter("@loc_state", DDState.SelectedItem.Text));
}

// comLocation.Parameters.Add(new SqlParameter("@loc_state", DDState.SelectedItem.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_country", DDCountry.SelectedValue.ToString()));
comLocation.Parameters.Add(new SqlParameter("@loc_pin", txtpin.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_phone", txtphone.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_mobile", txtmobile.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_fax", txtfax.Text));
comLocation.Parameters.Add(new SqlParameter("@loc_email", txtemail.Text));

comLocation.Parameters.Add(new SqlParameter("@loc_edit_by", int.Parse(Session["EmpID"].ToString())));

comLocation.ExecuteNonQuery();

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{

}

}

}

protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Request.QueryString.HasKeys())
{
if (Request.QueryString["action"].ToString() == "edit")
{
UpdateLocationDetail();
Response.Redirect("viewlocation.aspx");
}
else if (Request.QueryString["action"].ToString() == "copy")
{
checkLocationStauts();

}
}
else
{
checkLocationStauts();
//LocationAdd();
//Response.Redirect("viewlocation.aspx");

}
}
public void checkLocationStauts()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conIDLDPL"]))
{

try
{
lblmsg.Text = "";
conn.Open();
// string str = "select * from tblLocationMaster where loc_name='" + ViewState["locName"] + "'";
string str = "select * from tblLocationMaster where loc_name='" + txtLocName.Text + "'";
SqlCommand chkCom = new SqlCommand(str,conn);
SqlDataReader dr = chkCom.ExecuteReader();
if (dr.HasRows)
{

dr.Read();
lblmsg.Text="Location name already exists!";
}
else
{
LocationAdd();
Response.Redirect("viewlocation.aspx",false);
//checkLocationStauts();
}
}
catch (Exception ex)
{
Response.Redirect(ex.Message.ToString());
}
finally
{
conn.Close();
}
}

}
protected void btCancle_Click(object sender, EventArgs e)
{
if (Request.QueryString.HasKeys())
{
Response.Redirect("viewlocation.aspx");
}
else
{
Response.Redirect("adminhome.aspx");
}
}
protected void DDState_SelectedIndexChanged(object sender, EventArgs e)
{
if (DDState.SelectedItem.Text == "Others")
{

txtother.Visible = true;
}
else
{
txtother.Visible = false;
}

}
protected void DDCountry_SelectedIndexChanged(object sender, EventArgs e)
{
if (DDCountry.SelectedItem.Text != "India")
{
DDState.SelectedValue = "Others";
txtother.Visible = true;
// lblStar.Visible = true;
this.txtother.Focus();
}
else
{
txtother.Visible = false;
DDState.SelectedValue = DDState.SelectedValue.ToString();
// DDState.SelectedIndex = 0;
// lblStar.Visible = false;

}
}

Reapeter Fill !!

2009-11-16T22:01:00.000-08:00

private void fillGridView()
{

string FileDirectory = Server.MapPath("Database/admin.mdb");
OleDbConnection ocon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileDirectory.ToString() + "");

try
{
ocon.Open();
string str = "SELECT Project_master.Project_name,Project_master.Project_id, Project_master.Project_total_hours, Project_master.Project_start_date, Project_master.Project_end_date, User_master.User_name" + " " +
"FROM Project_master INNER JOIN User_master ON Project_master.User_id = User_master.User_id";

//string str = "SELECT Project_assignment.ProjAssig_opening_hours, Project_assignment.ProiAssig_Allolet_hours, Project_assignment.ProjAssig_status, Project_master.Project_name, Project_master.Project_total_hours, Project_master.Project_start_date, Project_master.Project_end_date, User_master.User_name" + " " +
//"FROM Project_assignment INNER JOIN (Project_master INNER JOIN User_master ON Project_master.User_id = User_master.User_id) ON Project_assignment.Project_id = Project_master.Project_id";
//String str = "select *,User_name from Project_master inner join User_Master on Project_master.User_id=User_Master.User_id order by Project_master.Project_end_date desc";
OleDbDataAdapter osap = new OleDbDataAdapter(str, ocon);

DataSet ds = new DataSet();
osap.Fill(ds, "temp");
GVProjectReports.DataSource = ds;
GVProjectReports.DataBind();

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}

}

private DataSet FillRepeater(string pid)
{

string FileDirectory = Server.MapPath("Database/admin.mdb");
DataSet ds = new DataSet();
OleDbConnection ocon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileDirectory.ToString() + "");

try
{
ocon.Open();
string str = "SELECT User_master.User_name,ProjAssig_opening_hours,ProiAssig_Allolet_hours " + " " +
"FROM Project_assignment INNER JOIN User_master ON User_master.User_id = Project_assignment.User_id where Project_assignment.Project_id="+ pid +" ";

OleDbDataAdapter osap = new OleDbDataAdapter(str, ocon);

osap.Fill(ds, "temp");

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}

return ds;

}

protected void GVProjectReports_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Separator)
{

Repeater rep = (Repeater)e.Row.FindControl("ProReport");
Label pid=(Label)e.Row.FindControl("projectID");
Label lblTotHr = (Label)e.Row.FindControl("lblTotHr");
Label _lblRemaingHr = (Label)e.Row.FindControl("lblRemaingHr");

rep.DataSource = FillRepeater(pid.Text);
rep.DataBind();
int totalHr = 0;
foreach (RepeaterItem repe in rep.Items)
{
Label lblopenAllocated = (Label)repe.FindControl("lblopenHr");
totalHr = totalHr + Convert.ToInt32(lblopenAllocated.Text);
}

_lblRemaingHr.Text =Convert.ToString((Convert.ToInt32(lblTotHr.Text) - totalHr));

}
}

Update !!

2009-11-16T21:55:00.001-08:00

private void updatecom()
{
//using (SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["MyCartConnKEy"]))
//{
string FileDirectory = Server.MapPath("Database/admin.mdb");
OleDbConnection ocon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileDirectory.ToString() + "");
//OleDbConnection ocon = new OleDbConnection();
try
{
string status = Request.QueryString["setStatus"].ToString();
string id = Request.QueryString["um_id"].ToString();
ocon.Open();
string str = "update Project_master set Project_status='" + status + "' where Project_id=" + id + "";
// SqlCommand updatecom = new SqlCommand(str, scon);
OleDbCommand ocom = new OleDbCommand(str, ocon);
ocom.ExecuteNonQuery();
Response.Redirect("ViewProject.aspx");

}
catch (OleDbException ex)
{
Response.Write(ex.Message.ToString());

}
finally
{
ocon.Close();

}

//}

}

RowDataBound_ FillGrid !!

2009-11-16T21:52:00.000-08:00

protected void GridDisplayCat_RowDataBound(object sender, GridViewRowEventArgs e)
{
{
if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Separator)
{

//Label lbldate = (Label)e.Row.Cells[1].FindControl("lbldate");
// DateTime dt = Convert.ToDateTime(lbldate.Text);
// lbldate.Text = dt.ToString("dd/MM/yyyy");

// Label lblEdate = (Label)e.Row.Cells[1].FindControl("lblEdate");
// DateTime dt1 = Convert.ToDateTime(lblEdate.Text);
// lblEdate.Text = dt1.ToString("dd/MM/yyyy");

Label lblstatus = (Label)e.Row.Cells[1].FindControl("lblstatus");
Label lblid = (Label)e.Row.Cells[2].FindControl("lblid");
string status = lblstatus.Text.ToString();
string id = lblid.Text.ToString();
if (status.ToString() == "Yes")
{
e.Row.Cells[1].Text = "";
}
else
{
e.Row.Cells[1].Text = "";
}

}
}

}

Fill Grid !!

2009-11-16T21:51:00.001-08:00

private void fillGrid()
{
string FileDirectory = Server.MapPath("Database/admin.mdb");
OleDbConnection ocon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileDirectory.ToString() + "");
//OleDbConnection ocon = new OleDbConnection();
try
{
ocon.Open();
string str = "select *,User_name from (Project_master inner join User_Master on Project_master.User_id=User_Master.User_id ) "+" " +
" inner join Client_master on Project_master.Client_id=Client_master.Client_id order by Project_id desc";
// String str = "select *,User_name from Project_master inner join User_Master on Project_master.User_id=User_Master.User_id order by Project_id desc";
OleDbDataAdapter osap = new OleDbDataAdapter(str, ocon);

DataSet ds = new DataSet();
osap.Fill(ds, "temp");
GridDisplayCat.DataSource = ds;
GridDisplayCat.DataBind();

}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}

}

Edit Procedure !!

2009-11-16T21:50:00.001-08:00

CREATE Procedure EditCat
(
@catname Varchar(100),
@catid int
)
AS
update tblMainCat set
Cat_Name=@catname
where cat_id=@catid

GO

UpdateProcedure !!

2009-11-16T21:49:00.001-08:00

CREATE Procedure UpdateProcedure
(
@firstname varchar(50),
@lastname varchar(50),
@address Varchar(100),
@city Varchar(50),
@state Varchar(50),
@pincode Varchar(20),
@EmailId Varchar(80),
@customerid int
)
AS
Update Registration set
customesr_firstname=@firstname,
customers_lastname= @lastname,
customers_address=@address,
customers_city= @city,
customers_state=@state,
customers_zipcode= @pincode ,
customers_email_address= @EmailId
where customers_id=@customerid

GO

UpdateProductProcedure !!

2009-11-16T21:48:00.001-08:00

CREATE Procedure UpdateProductProcedure
(
@ProductName varchar(50),
@ProductPrice varchar(50),
@ProductDescription Varchar(100),
@Productid int

)
AS
update tblProduct_Master set

Product_Name=@ProductName,
Product_Price=@ProductPrice,
Product_desc=@ProductDescription
where Product_id=@Productid
GO

Insert Procedure !!

2009-11-16T21:46:00.000-08:00

/*
Procedure Name :invoiceInsert
Description : This Procedure is Inserting the Invoice details
Created By: Chandrashekhar Dhingra
Creation Date :25/03/2008
*/

CREATE PROCEDURE invoiceInsert
(
@comdName varchar(50),
@vatD3 varchar(50),
@buyName varchar(50),
@bAddress varchar(500),
@bCity varchar(50),
@bState varchar(50),
@bPincode varchar(20),
@bCountry varchar(50),
@bEcc varchar(50),
@bTin varchar(50),
@conName varchar(50),
@cAddress varchar(500),
@cCity varchar(50),
@cState varchar(50),
@cPincode varchar(50),
@cCountry varchar(50),
@cEcc varchar(50),
@cTin varchar(50),
@ordNo varchar(50),
@ordDate datetime,
@confNo varchar(50),
@conDate datetime,
@rlNo varchar(50),
@rlDate datetime,
@destination varchar(50),
@transport varchar(50),
@transMode varchar(50),
@transTerms varchar(50),
@eCess float,
@tolPac varchar (50),
@she float,
@vat float,
@freight float,
@id int output
)
AS
insert into tblInvoiceDisplay
(
invoice_exComdName,
invoice_vatD3,
invoice_buyName,
invoice_bAddress,
invoice_bCity,
invoice_bState,
invoice_bPincode,
invoice_bCountry,
invoice_bEcc,
invoice_bTin,
invoice_conName,
invoice_cAddress,
invoice_cCity,
invoice_cState,
invoice_cPincode,
invoice_cCountry,
invoice_cEcc,
invoice_cTin,
invoice_ordNo,
invoice_ordDate,
invoice_confNo,
invoice_conDate,
invoice_rlNo,
invoice_rlDate,
invoice_dest,
invoice_transport,
invoice_transMode,
invoice_transTerms,
invoice_eCess,
invoice_tolpacl,
invoice_she,
invoiceAddVar,
invoice_freight
)
Values
(

@comdName,
@vatD3,
@buyName,
@bAddress,
@bCity,
@bState,
@bPincode,
@bCountry,
@bEcc,
@bTin,
@conName,
@cAddress,
@cCity,
@cState,
@cPincode,
@cCountry,
@cEcc,
@cTin,
@ordNo,
@ordDate,
@confNo,
@conDate,
@rlNo,
@rlDate,
@destination,
@transport,
@transMode,
@transTerms,
@eCess,
@tolPac,
@she,
@vat,
@freight
)
Select @id=Max(invoice_id) from tblInvoiceDisplay
GO

Insert Procedure !!

2009-11-16T21:44:00.000-08:00

/*
Procedure Name :customerInsert
Description : This Procedure is Inserting the Customer details
Created By: Chandrashekhar Dhingra
Creation Date :24/03/2008
*/

CREATE PROCEDURE customerInsert
(
@custName varchar(100),
@custAdd varchar(500),
@custCity varchar(100),
@custState varchar(100),
@custPin varchar(20),
@custCountry varchar(100),
@custEcc varchar(50),
@custTin varchar(50),
@custID varchar(50),
@regDate datetime,
@active varchar(3),
@delete varchar(3)
)
AS
insert into tblCustomerMaster
(

cust_name,
cust_address,
cust_city,
cust_state,
cust_pin,
cust_country,
cust_eccNo,
cust_tinNo,
custom_id,
cust_regDate,
cust_active,
cust_delete
)
values
(
@custName,
@custAdd,
@custCity,
@custState,
@custPin,
@custCountry,
@custEcc,
@custTin,
@custID,
getdate(),
'Yes',
'No'
)
GO

GridView's RowCommand !!

2009-11-11T23:47:00.000-08:00

Protected void GVMyProdct_RowCommand (object sender, GridViewCommandEventArgs e )
{

GridViewRow Row = (GridViewRow)(Button)e.CommandSource).NamingContainer;
Label lblPrice=(Label)row.FindControl("lblPrice");
if (e.CommandName=="AddCart")
{

}
}

# Command Name is the property of which is inside the

Inside the 's has the properties :

Text = "Add to cart";
Command Name = "AddCart";
Command Argument = '<%#DataBinder.Eval(Containe.DataItem,"Product_id")%>'

How to use for looping in Asp.Net !!

2009-11-11T22:54:00.000-08:00

for(int i=0;i{
bool chK((CheckBox)GVMyCart.Row[i]
fndControl("ChkPro")).Checked;

string temid=((Lable)GVMyCart.Row[i];
findControl("lblid").Text;
if (Chk==true)
{
Delete(temid);
BindView();
}
}

How to use Delete Function in Asp.Net !!

2009-11-11T22:48:00.000-08:00

Protected void MyCart()
{
string temid=lblid.Text;
Delete(temid);
}

Private void Delete(txtI)
{
scon.open();
string str="Delete from TblMycart where MyCart_id="+txtI+"";

}

How to Use Functions in Asp.net !!

2009-11-11T22:29:00.000-08:00

Protected void MyCart()
{
string txtqty=txtCartQty.Text;
string temid=lblid.text;
decimal t;

t=Convert.ToDecimal(tprice.Tostring()* Convert.Tostring.ToDecimal(txtqty.Tostring());

update(txtqty, t.ToString(),temid )

/* update function is called in MyCart Function , and txtqty are actual parameters*/

}

/* update function are Defined here */

private void update(string txtQ, string txtP, string textT)// thies ar formal parametes

{

ccon.open();
string str= "update tblMyCart set
MyCart_Qty='"+txtQ+"', MyCart_Price='"+txtP+"'where MyCart_id="+id+";
";

}

Count the row In DataGrid or GridView !!

2009-11-11T22:24:00.000-08:00

this.GVMyCount.Rows.Count;

this is used to count the No. of Items (Rows) in the GridView.

Validation is not working in the Page !!

2009-11-11T22:07:00.000-08:00

When validation is not working or not being fire , then where we use (Page.IsValid)? Use it at the Button for which you are using.

Use this when validation is not working on the page -

if (Page.IsValid)
{

}

On the Button_Submit.

When we have used validation on the page and validation is not working on Button click. Then use use Page.Isvalid on the Buttion Click.. Like that..

Protected void btnSubmit_Click(Object sender, EventArgs e)

{

if(Page.IsValid)
{

}

}

Date Time

2009-11-11T21:56:00.000-08:00

# Date should always present in the user part in the dd/mm/yyyy formate.

# Date should always saved or inserted in the Database MM/dd/yyyy formate.

# Date is always present in the presentation form as - dd/mm/yyyy. So we have to convert it accordingly.

Different Date Time Formate !!

2009-11-11T21:52:00.000-08:00

lblDate.Text=DateTime.Today.TolongDateString();

This will show the Formate of Date time like that : Sunday, August 02, 2008

Inset Date Through Query !!

2009-11-11T21:49:00.000-08:00

string str = "insert into Registration (cust_id, cust_name, cust_date)

vaues ('"+txtname.Text+"','"+DateTime.Today.Date.Tostring()+"')"

AddNews.aspx !!

2009-11-11T21:28:00.000-08:00

Relation Between Insert Procedura and Page ;

Sql cmd =new SqlCommand ("insNews", Sqlcon)
Sqlcmd.CommandType=CommandType.StoreProcedure;
Sqlcmd.Parameters.AddWithVales("@headline",txtHeadline.Text);

string strtxtdate=txtDate.Text.Substring(3,2)+ "/" + txtDate.Text.Substring(0,2)+ "/" + txtDate.Text.Substring(6,4);

Sqlcmd.Parameters.Addwithvalue("@date",strtxtdate.ToString());

Sqlcmd.Parameters.Addwithvale("@active","");
Sqlcmd.Parameters.Addwithvalue("@delete","");

strImage=System.IO.Path.GetFileName(uploadImage.Post.PostedFile.fileName);

string savelocation= server.Mathpath("upload")+ "\" strImage;

uploadImage.Postfile.SaveAs(Savelocation);

Sqlcmd.Paremeters.Addwithvales("@image", stringImage.Tostring());

Insert Procedure !!

2009-11-11T21:22:00.000-08:00

CREATE PROCEDURE insNews
(
@headline varchar (50),
@date datetime,
@active varchar(3),
@delete varchar (3),
@image varchar (50),

)

as

inseart into tblNewsMaster

(
nm_headline,
nm_date,
nm_activce,
nm_delete,
image
)

values

(
@headline,
@date,
'Yes'
'No'
@Image

)

Go

Update Procedure !!

2009-11-11T21:12:00.000-08:00

CREATE PROCEDURE adminprojectupdate
(
@code varchar (50),
@startdate datetime,
@enddate datetime,
@amount varchar(50),
@title varchar (50),
@client varchar (200),
@des varchar (200),
pid int

)
as
update tblprojectmaster

pr_code=@code,
pr_startDate=@startDate,
pr_endDate=@amont,
pr_title=@title,
pr_client=@client,
pr_desc=@desc;

where pr_id=@pid

Go

Converting int to Floating !!

2009-11-11T21:04:00.000-08:00

float Total = float.Parse(session["total.Tostring()"])

What is the difference between int.parse() and convert.int32()

2009-08-25T22:55:00.000-07:00

If we want to convert a string value (Lets say we have a string “23”) to integer we have 2 options. One is to use the Int.Parse method and other is to use the Convert.ToInt32.

The real query with every one was what is the difference between the two. The answer is null handling. The difference between the 2 is the manner in which null is handled. If you pass a null value to convert.ToInt32 method it will return back 0. But the same is not true with Int.Parse. If we pass null to Int.Parse method it will throw an ArgumentNullException exception.

Although Convert.ToInt32 method does not throw an exception but it can have a big drawbacks. If you use it on a query string value(where u are also expecting the value 0) then the Convert.ToInt32 might cause programmatic error.

######################################################################################

The difference lies in the way both handles NULL value.

When encountered a NULL Value, Convert.ToInt32 returns a value 0. On other hand,Parse is more sensitive and expects a valid value. So it would throw an exception when you pass in a NULL.

string stringInt = "01234";

int iParse = int.Parse(stringInt);

int iConvert = Convert.ToInt32(stringInt);

##################################################################################3

string MyString = "12345";
int MyInt = int.Parse(MyString);
MyInt++;
Console.WriteLine(MyInt);
// The result is "12346".

#################################################################################
int.Parse for Integer Conversion in C#
--------------------------------------

1. Using int.Parse

First, here we see the int.Parse method. int.Parse is the simplest method, and is also the author's favorite for many situations. It throws exceptions on invalid input, which can be slow if they are common. It is does not contain any internal null checks.

=== Example program that uses int.Parse (C#) ===

using System;

class Program
{
static void Main()
{
// Convert string to number.
string text = "500";
int num = int.Parse(text);
Console.WriteLine(num);
}
}

=== Output of the program ===

500

2. Using Convert.ToInt32

Third, we look at the Convert.ToInt32 method. Convert.ToInt32, along with its siblings Convert.ToInt16 and Convert.ToInt64, is actually a static wrapper method for the int.Parse method. It can be slower than int.Parse if the surrounding code is equivalent.

=== Example program that uses Convert.ToInt32 (C#) ===

using System;

class Program
{
static void Main()
{
// Convert 'text' string to an integer with Convert.ToInt32.
string text = "500";
int num = Convert.ToInt32(text);
Console.WriteLine(num);
}
}

=== Output of the program ===

500

3. Which method should I use?

The it's recommendation is to use int.Parse when your input will be valid, as it makes for simpler calling code. It isn't always perfect, but it is a winner. On the other hand, use int.TryParse when you will be dealing with corrupt data.

Good Website : http://dotnetperls.com/datetime-1

What is ItemCommand ?

2009-08-14T07:59:00.000-07:00

Dev Palmistry

DataGrid.ItemCommand Event

System.Web.UI.WebControls Namespace DataGrid Class

Occurs when a button within a DataGrid control is clicked.

[ VB ]
Public Event ItemCommand As DataGridCommandEventHandler

[ C# ]
public event DataGridCommandEventHandler ItemCommand;

[ C++ ]
public: __event DataGridCommandEventHandler* ItemCommand;

In [ JScript ], you can handle the events defined by a class, but you cannot define your own.
Remarks

The ItemCommand event is raised whenever any button associated with an item in the DataGrid is clicked. This provides for programmatically determining which specific command button is clicked and take appropriate action. This event is commonly used to handle button controls with a given CommandName value in the DataGrid control.
Event Data

Information related to the ItemCommand event is passed via a DataGridCommandEventArgs object to the method assigned to handle the event. The following DataGridCommandEventArgs properties provide information specific to this event.
Property Description
CommandSource Gets the source of the command.
Item Gets the DataGridItem associated with the event.

What is the namespace of StringBuilder ?

2009-08-14T07:51:00.000-07:00

The System.Text is the namespace are used in StringBuilder

The System.Text.StringBuilder class can be used when you want to modify a string without creating a new object. For example, using the StringBuilder class can boost performance when concatenating many strings together in a loop.

You can create a new instance of the StringBuilder object by initializing your variable with one of the overloaded constructor methods, as illustrated in the following code example.

[ C# ]
StringBuilder myStringBuilder = new StringBuilder ( "Hello World!" );

Setting and Retrieving the Connection String Using Web.Cofig !!

2009-08-14T07:08:00.000-07:00

In Connecting to a Database, we have shown the essential steps to establish and open a connection to a data source from within a Web Forms page. In this application, we use a slightly different approach of storing the connection string in the application configuration file ( web.config ), thereby making the connection string globally available to any page in the application. This technique is basically implemented as follows.

In the web.config file for the application, include the following:

configuration>
appsettings>
add key="myDbConn" value="server=servername; uid=userid; pwd=password; database=dbname">
/add>
/appsettings>

changing the values ( shown in italics ) to correspond to your settings.

Then on each page that you need to initialize a connection, use:

SqlConnection myConn = new SqlConnection
( ConfigurationSettings.AppSettings [ "myDbConn" ] );

N-Tier Architecture !!

2009-08-03T02:01:00.001-07:00

Dev Palmistry

3-Tier Architecture in ASP.NET with C#

3-Tier architecture is a very well know buzz word in the world of software development whether it web based or desktop based. In this article I am going to show how to design a web application based on 3-tier architecture.

Introduction

3-Tier architecture generally contains UI or Presentation Layer, Business Access Layer (BAL) or Business Logic Layer and Data Access Layer (DAL).

Presentation Layer (UI)
Presentation layer cotains pages like .aspx or windows form where data is presented to the user or input is taken from the user.

Business Access Layer (BAL) or Business Logic Layer
BAL contains business logic, validations or calculations related with the data, if needed. I will call it Business Access Layer in my demo.

Data Access Layer (DAL)
DAL contains methods that helps business layer to connect the data and perform required action, might be returning data or manipulating data (insert, update, delete etc). For this demo application, I have taken a very simple example. I am assuming that I have to play with record of persons (FirstName, LastName, Age) and I will refer only these data through out this article.

Designing 3-Tier Architecture

For the ease of understanding, I have created BAL, DAL into the App_Code folder. In real scenario, you should create separate projects for BAL, DAL (as Class Library) and UI (as Web project) and reference your BAL into UI.

Data Access Layer
Lets proceed with desiging 3-Tier architecture. To do that lets proceed with DAL, BAL and then UI. Add a class named by right clicking App_Code folder. (In my case I have a 3-Tier folder inside App_Code folder, you can directly add inside App_Code or you can create a separate project for DAL and add reference of this project into your BAL.) and copy-paste folowing code (Your can overwrite your default written code for the class file by pasting this code). Here, I have assumed that you will create the respective stored procedure yourself into the database or you may download attachment from http://www.dotnetfunda.com/articles/article18.aspx article and look for App_Data folder for complete database structure and stored procedure for this article.

Data Access Layer (DAL)

Code for Data Access Layer

In the above code, I have a member variable called connStr that is getting database connection string from my web.config file that is being used through out the class. I have separate method for inserting, deleting, updating records into database and loading records from database. I am not goint into details of how I am connecting database and manipulating the data just to make this tutorials short.

Business Access Layer (BAL)

Now, create a class named PersonBAL3 into App_Code folder by right clicking it and write respective methods for calling Insert, Delete, Update and Load methods of Data Access Layer class file (PersonDAL3) (In my case I have a 3-Tier folder inside App_Code folder, you can directly add inside App_Code or you can create a separate project for BAL and add reference of this project into your Presentation Layer). As we don't have any business logic here so simply instantiate the PersonDAL3 class of DAL and call methods. Below is the code for BAL (Your can overwrite your default written code for the class file by pasting this code).

Till now we haev our Business Access Layer and Database Access Layer ready. Now we have to write our Presentation Layer that will use our Business Access Layer methods. Lets create a form that will have three textboxes for FirstName, LastName and Age.

Presentation Layer

Create an Insert.aspx page (make is as Startup page) and copy paste following code to bring the insert form something like displaying in the picture.
Code for Insert Record form

Add Records
First Name:		Display="dynamic">
Last Name:		Display="dynamic">
Age:		Display="dynamic"> Operator="DataTypeCheck" Type="Integer">

Now, lets write method that will fire when Submit button will be clicked on the from.
Code for AddRecords method

protected void AddRecords(object sender, EventArgs e)

{

//Lets validate the page first

if (!Page.IsValid)

return;

int intResult = 0;

// Page is valid, lets go ahead and insert records

// Instantiate BAL object

PersonBAL3 pBAL = new PersonBAL3();

// Instantiate the object we have to deal with

string firstName = txtFirstName.Text;

string lastName = txtLastName.Text;

int age = Int32.Parse(txtAge.Text);

try

{

intResult = pBAL.Insert(firstName, lastName, age);

if (intResult > 0)

lblMessage.Text = "New record inserted successfully.";

else

lblMessage.Text = "FirstName ["+ txtFirstName.Text +"] alredy exists, try another name";

}

catch (Exception ee)

{

lblMessage.Text = ee.Message.ToString();

}

finally

{

pBAL = null;

}

}

In the above code, first I am validating the page by using Page.IsValid method just to check if correct data has been entered. Then I have instantiated PersonBAL3 and calling Insert method of it (pBAL.Insert) by passing firstName, lastName, age as parameter.

Dispalying Records into GridView

Create a .aspx file called List.aspx and create a GridView something like displayed into the picture. To list the record into GridView that will also enable us to Edit, Delete record, copy paste following code.

Code for GridView

DataKeyNames="PersonID" AutoGenerateEditButton="True" AutoGenerateColumns="False"

OnRowEditing="EditRecord" OnRowUpdating="UpdateRecord" OnRowCancelingEdit="CancelRecord"

OnRowDeleting="DeleteRecord" PageSize="5" >

<%# Eval("FirstName") %>

asp:TextBox ID="txtFName" runat="Server" Text='<%# Eval("FirstName") %>'>

<%# Eval("LastName") %>

asp:TextBox ID="txtLName" runat="Server" Text='<%# Eval("LastName") %>'>

<%# Eval("Age") %>

asp:TextBox ID="txtAge" runat="Server" Text='<%# Eval("Age") %>'>

Code to Load records and Displaying Records into GridView

private DataTable BindGrid()

{

PersonBAL3 p = new PersonBAL3();

try

{

DataTable dTable = p.Load();

GridView1.DataSource = dTable;

GridView1.DataBind();

}

catch (Exception ee)

{

lblMessage.Text = ee.Message.ToString();

}

finally

{

p = null;

}

return dTable;

}

In the above method I am instantiating PersonBAL3 class and calling Load method to get the record into DataTable and binding it into GridView.

Code to Delete Records

protected void DeleteRecord(object sender, GridViewDeleteEventArgs e)

{

int personID = Int32.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());

// instantiate BAL

PersonBAL3 pBAL = new PersonBAL3();

try

{

pBAL.Delete(personID);

lblMessage.Text = "Record Deleted Successfully.";

}

catch (Exception ee)

{

lblMessage.Text = ee.Message.ToString();

}

finally

{

pBAL = null;

}

GridView1.EditIndex = -1;

// Refresh the list

BindGrid();

}

Above method will fire when Delete link will be clicked on the GridView. In the above code, I am instantiating PersonBAL3 and calling Delete method by passing personID as parameter so that select reocrds will be deleted from datbase.

Above method will fire when Update link will be clicked for a particular row of the GridView in edit mode. In the above method, I am instantiating PersonBAL3 and calling the Update method by p[assing required parameters.

Now we have all set to go, now just run your project and try inserting records. You can also navigate to another page your created (list.aspx) and try updating, deleting records.

Conclusion

By using 3-Tier architecture in your project you can achive

1. Seperation - the functionality is seperated from the data access and presentation so that it is more maintainable
2. Independence - layers are established so that if one is modified (to some extent) it will not affect other layers.
3. Reusability - As the layers are seperated, it can exist as a module that can be reused by other application by referencing it.

Hope this article helped you understanding 3-Tier architecture and desiging it.

Thanks and Happy Coding !!!

N-Tier Architecture !!

2009-08-03T01:14:00.000-07:00

Dev Palmistry

What is n-Tier Architecture?

This is a very important topic to consider when developing an application. Many elements need to be considered when deciding on the architecture of the application, such as performance, scalability and future development issues. When you are deciding on which architecture to use, first decide on which of the three aforementioned elements you think is most valuable -- as some choices you make will impact on others. For example, some choices that boost performance will impact on the scalability or future development of your design, etc.

Here we will talk generally about what n-Tier architecture is, and then we will have a look at different n-Tier architectures you can use to develop ASP.NET applications and issues that arise relating to performance, scalability and future development issues for each one.

Firstly, what is n-Tier architecture? N-Tier architecture refers to the architecture of an application that has at least 3 "logical" layers -- or parts -- that are separate. Each layer interacts with only the layer directly below, and has specific function that it is responsible for.

Why use n-Tier architecture? Because each layer can be located on physically different servers with only minor code changes, hence they scale out and handle more server load. Also, what each layer does internally is completely hidden to other layers and this makes it possible to change or update one layer without recompiling or modifying other layers.

This is a very powerful feature of n-Tier architecture, as additional features or change to a layer can be done without redeploying the whole application. For example, by separating data access code from the business logic code, when the database servers change you only needs to change the data access code. Because business logic code stays the same, the business logic code does not need to be modified or recompiled.

[Note] tier and layer mean the same thing [End Note]

An n-Tier application usually has three tiers, and they are called the presentation tier, the business tier and the data tier. Let's have a look at what each tier is responsible for.

Presentation Layer
Presentation Layer is the layer responsible for displaying user interface and "driving" that interface using business tier classes and objects. In ASP.NET it includes ASPX pages, user controls, server controls and sometimes security related classes and objects.

Business Tier
Business Tier is the layer responsible for accessing the data tier to retrieve, modify and delete data to and from the data tier and send the results to the presentation tier. This layer is also responsible for processing the data retrieved and sent to the presentation layer.

In ASP.NET it includes using SqlClient or OleDb objects to retrieve, update and delete data from SQL Server or Access databases, and also passing the data retrieved to the presentation layer in a DataReader or DataSet object, or a custom collection object. It might also include the sending of just an integer, but the integer would have been calculated using the data in the data tier such as the number of records a table has.

BLL and DAL
Often this layer is divided into two sub layers: the Business Logic Layer (BLL), and the Data Access Layers (DAL). Business Logic Layers are above Data Access Layers, meaning BLL uses DAL classes and objects. DAL is responsible for accessing data and forwarding it to BLL.

In ASP.NET it might be using SqlClient or OleDb to retrieve the data and sending it to BLL in the form of a DataSet or DataReader. BLL is responsible for preparing or processing the data retrieved and sends it to the presentation layer. In ASP.NET it might be using the DataSet and DataReader objects to fill up a custom collection or process it to come up with a value, and then sending it to Presentation Layer. BLL sometimes works as just transparent layer. For example, if you want to pass a DataSet or DataReader object directly to the presentation layer.

Data Tier
Data tier is the database or the source of the data itself. Often in .NET it's an SQL Server or Access database, however it's not limited to just those. It could also be Oracle, mySQL or even XML. In this article we will focus on SQL Server, as it has been proven to be the fastest database within a .NET Application.

Logical Layers vs. Physical Layers (Distributed)
Logical Layers and Physical Layers are the ones that confuse people. Firstly, a logical layer means that layers are separate in terms of assembly or sets of classes, but are still hosted on the same server. Physical layer means that those assemblies or sets of classes are hosted on different servers with some additional code to handle the communication between the layers. E.g. remoting and web services.

Deciding to separate the layers physically or not is very important. It really depends on the load your application expects to get. I think it's worth mentioning some of the facts that might affect your decision.

Please DO note that separating the layers physically WILL slow your application down due to the delay in communicating between the servers throughout the network, so if you are using the physical layer approach, make sure the performance gain is worth the performance loss from this.

Hopefully you would have designed your application using the n-Tier approach. If this is the case, then note that you can separate the layers in the future.

Cost for deploying and maintaining physically separated applications is much greater. First of all, you will need more servers. You also need network hardware connecting them. At this point, deploying the application becomes more complex too! So decide if these things will be worth it or not.

Another fact that might affect your decision is how each of the tiers in the application are going to be used. You will probably want to host a tier on a separate server if more than 1 service is dependent on it, e.g. You might want to host business logic somewhere else if you have multiple presentation layers for different clients. You might also want a separate SQL server if you have other applications using the same data.

#####################################################################################

3-Tier Architecture

As the 3-Tier Architecture is the most commonly used architecture in the world, I will start my blogging on this topic.

I have noticed in the past 6 years of writing software that many developers ignore this software engineering paradigm for many reasons. Some include ...

*
Return on Investment
*
Software Lifecycle Turnaround time
*
Knowledgeable Resources
*
and the list goes on

I will discuss in more details of these reasons in another blog entry so back to the topic of 3-Tier architecture.

A 3-Tier architecture uses the Divide and Conquer strategy and is broken down into 3 logical layers.

*
Presentation Layer (PL)
*
Business Logic Layer (BLL)
*
Data Access Layer (DAL)

Ideally, each layer specializes in one or a handful of functionalities that service the upper layer. Each of the three layers should be designed so that the layer above it does not need to understand nor know the implementation details of any of the layers below it. This is accomplished by providing well defined interfaces that the above layers use. The advantage of "Programming to the Interface" is that, you can change the implementation details and still have the application work as defined. One caveat is that, if the interfaces change, then it will take more effort and time to update the layer above it. Therefore, when designing an application, its important to define the interfaces properly.

Here is an example:

public interface IDatasource
{
Customer GetCustomer(int id)
}

public TextDataSource : IDataSource
{
public Customer GetCustomer(int id)
{
// reads data from a text file
}
}

public SQLDataSource : IDataSource
{
public Customer GetCustomer(int id)
{
// uses ADO.NET to read data from a SQL Server database
}
}

public class MyProgram
{
public static void Main(string[] args)
{
// the DataSourceFactory will create a data source depending on some settings
// and return the appropriate implementation of the data source
IDataSource ds = DataSourceFactory.GetInstance().GetDataSource();
Console.WriteLine(ds.GetCustomer(15).FirstName)
}
}

As you can see from the example, MyProgram does not need to know which datasource it is querying. All it needs to know is the interface it must use to retrieve a customer record. If we have numerous implementations then by changing only the configurations which are declarative and available outside of the compiled code, we can change the datasource the application should use to retrieve data without changing the application logic itself.

Now lets see how we can use the "Programming to the Interface" paradigm to create a 3-Tier architecture.

The Presentation Layer is responsible for rendering the data retrieved by the BLL (with the help of the DAL). The only logic that is necessary in this layer is how to manipulate the data and display it to the user in an easy to consume manner. Along with rendering the content, it should be responsible for rudimentary data validation such as missing fields, regular expression matching for emails and other content, numeric validation, range validations, etc.

In .NET, there are a slew of UI specific controls that one may use to render the data. Some controls include the DataList, DataGrid, Label, TextBox and of course custom controls for the advanced developers. There are also pre-built validation controls that are bundled with the .NET framework. I'll post some links later with examples of how to use these controls soon.

Depending on the application you are building, the presentation layer may be one or more of the following types of applications: web, windows, windows service, smart client or console. By properly defining the responsibilities of each layer, the only logic that is necessary for developers to write is the presentation layer. Since retrieving a customer record is the same throughout the application (through the BLL) you can abstract out all the details hence simplifying your software.

On the same note, your application may also expose Web services and Remoting services so it is essential to centralize the code. Otherwise the logic for retrieving a customer (which may include security authorization and authentication, data validation, pre-processing and post-processing) will need to be duplicated in many places. Code duplication may seem like a viable solution at the early stages of the software lifecycle, but it is extremely hard to maintain such pieces of software.

The Business Logic Layer is like your kernel for your application. It should be the component that performs all the business logic for your application. This ranges from validations, running business logic, running application processes such as sending emails and retrieving and persisting data using the Data Access Layer.

Although, validations were performed on the presentation layer, it is imperative that you revalidate the data because browsers could have been spoofed or older browsers might have completely ignored some of the validations or the developers working on the presentation layer did not validate the data properly.

Depending on the complexity of your application, businesses logic code may not reside on the same server or in a centralized location so there are advanced means of executing such logic remotely. With .NET this process has been extremely simplified and available to you within a few clicks of your mouse. One of which is .NET Remoting which is an advanced topic that I'll opt out for now. And the other is the buzz word that many have heard; Web Services.

Both writing and using a Web Service is once again simplified by Microsoft. Visual Studio 2003 and 2005 will be able to download the WSDL and generate the proxies for you so you can invoke the functions as you may within business object in your application. If you don't have Visual Studio, then you may use the "wsdl.exe" utility that is bundled with .NET Framework on the command prompt.

If you have business logic on legacy systems that were built with Microsoft Technologies such as COM+ that can not be rewritten for what ever reason, not to worry. You can use COM+ wrappers provided by the .NET Framework to communicate with the legacy systems.

The Data Access Layer is responsible for accessing and manipulating data from data sources such as SQL Server, Microsoft Access, Oracle, MySQL, etc. Many applications on the Internet today rely heavily on data found in many databases and it is important to centralize the access to this data. Some reasons are ...

*
Security
*
Code Maintenance and Resue
*
Scalability

Databases contain confidential information about people and it is not necessary for everyone in your organizational hierarchy to have access to such data. For example, credit card information stored on Amazon.com shouldn't be available for an entry level employee working in a warehouse. By centralizing the access the database, we are able to authenticate and authorize the users requesting data and manipulating the data.

Since our economy is constantly in a flux, it is never safe to assume that once you have created your data model, it will not change for a decade. In fact, that data model may change tomorrow, a week from now or in an year, but it will change and as software architects, it is our responsibility to foresee such events and design systems that will be able to change with time. If the code isn't centralized, a database change as simple as adding a new column may result in days of changes to many systems, regression testing and deployment of many applications. Is this really necessary?

By creating simple reusable components, developers are able to abstract out all of the details of creating connections, handling errors, invoking appropriate stored procedures or executing Transact-SQL or SQL/PL code, retrieving the data, closing the connection away from the Business Logic Layer.

Typical code (using ADO.NET) to retrieve a customer record may look as the following:

SqlConnection connection = null;

try
{
connection = new SqlConnection(mySqlConnection);
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM Customers WHERE CustomerID = " + cid
return CustomerFactory.GetInstance().GetCustomer(cmd.ExecuteReader());
}
catch (Exception e)
{
Console.WriteLine("Exception :: " + e.Message);
}
finally
{
if (connection != null && connection.State != ConnectionState.Closed)
connection.Close();
}

So what's the big deal about writing a few lines of code? Well, imagine repeating these lines in 5 different places and 2 weeks later, making a change and remembering all the pieces of code to change. Compared to this solution, I suggest the following:

Customer customer = CustomerDAO.GetInstance().GetCustomer(customerID);

Where the ADO.NET code is abstracted away by the GetCustomer(int) function and now making a change to the function will take minutes and the change will affect all pieces of code that depends on retrieving customer records. The above examples use Design Patterns, more specifically the Factory Pattern and the Singleton Pattern and you may further read about them at your leisure.

Scalability is huge to enterprise level applications that require time crucial data. It’s beyond the scope of this article so I will leave it out for the time being.

##################################################################################

Executing Managed Code !!

2009-06-16T07:37:00.000-07:00

Dev Palmistry

Assemblies provide a way to package modules containing MSIL and metadata into units for deployment. The goal of writing code is not to package and deploy it, however; it's to run it. The final section of this chapter looks at the most important aspects of running managed code.
Assemblies are loaded into memory only when needed

Loading Assemblies
When an application built using the .NET Framework is executed, the assemblies that make up that application must be found and loaded into memory. Assemblies aren't loaded until they're needed, so if an application never calls any methods in a particular assembly, that assembly won't be loaded. (In fact, it need not even be present on the machine where the application is running.) Before any code in an assembly can be loaded, however, it must be found. How is this done?

The answer is not simple. In fact, the process the CLR uses to find assemblies is too complex to describe completely here. The broad outlines of the process are fairly straightforward, however. First, the CLR determines what version of a particular assembly it's looking for. By default, it will look only for the exact version specified for this assembly in the manifest of the assembly from which the call originated. This default can be changed by settings in various configuration files, so the CLR examines these files before it commences its search.

The CLR follows well-defined but involved rules to locate an assembly
Once it has determined exactly which version it needs, the CLR checks whether the desired assembly is already loaded. If it is, the search is over; this loaded version will be used. If the desired assembly is not already loaded, the CLR will begin searching in various places to find it. The first place the CLR looks is usually the global assembly cache (GAC), a special directory intended to hold assemblies that are used by more than one application. Installing assemblies in this global assembly cache requires a process slightly more complex than just copying the assembly, and the cache can contain only assemblies with strong names.

The CLR looks first in the global assembly cache
If the assembly it's hunting for isn't in the global assembly cache, the CLR continues its search by checking for a codebase element in one of the configuration files for this application. If one is found, the CLR looks in the location this element specifies, such as a directory, for the desired assembly. Finding the right assembly in this location means the search is over, and this assembly will be loaded and used. Even if the location pointed to by a codebase element does not contain the desired assembly, however, the search is nevertheless over. A codebase element is meant to specify exactly where the assembly can be found. If the assembly is not at that location, something has gone wrong, the CLR gives up, and the attempt to load the new assembly fails.

The CLR can next look in the location referenced by a codebase element
If there is no codebase element, however, the CLR will begin its last-ditch search for the desired assembly, a process called probing, in what's known as the application base. This can be either the root directory in which the application is installed or a URL, perhaps on some other machine. (It's worth pointing out that the CLR does not assume that all necessary assemblies for an application are installed on the same machine; they can also be located and installed across an internal network or the Internet.) If the elusive assembly isn't found here, the CLR continues searching in several other directories based on the name of the assembly, its culture, and more.

If no codebase element exists, the CLR searches in other places

Despite the apparent complexity of this process, this description is not complete. There are other alternatives and even more options. For developers working with the .NET Framework, it's probably worth spending some time understanding this process in detail. Putting in the effort up front is likely to save time later when applications don't behave as expected.

Compiling MSIL
A compiler that produces managed code always generates MSIL. Yet MSIL can't be executed by any real processor. Before it can be run, MSIL code must be compiled yet again into native code that targets the processor on which it will execute. Two options exist for doing this: MSIL code can be compiled one method at a time during execution, or it can be compiled into native code all at once before an assembly is executed. This section describes both of these approaches.

JIT Compilation
The most common way to compile MSIL into native code is to let the CLR load an assembly and then compile each method the first time that method is invoked. Because each method is compiled only when it's first called, the process is called just-in-time (JIT) compilation.
MSIL code is typically JIT compiled before it's executed

What is the Page Life Time in Asp.Net ?

2009-06-16T06:54:00.000-07:00

Understanding Page Life Time:

The first time that an Asp.Net web form page is executed, the code contained with the page (any codebehind class module associated with the page ) is complied into a class that inherits from the Page base class ( actually, the code-behing class inherits from the Page class and then the .aspx file inherits from code-behind class via the Inherits attributes of the @ Page directive ).

The following illustration show the relationship between the Page, its code-behind class (if any) and the complied assembly. Once complied, the class is executed, the resulting Html is rendered to the browser, and the class removed from hte memory.

What is Localhost ?

2009-06-16T06:53:00.000-07:00

Localhost:

Local host is an alias for the address 127.0.0.1, an addrss that always indicate local computer.

This is the address that a computer can use to refer to itself .

For Exp: When testing a web application on the same computer as the server. You can use the address:

http:// 127.0.0.1
http:// localhost

What is Webservices ?

2009-06-16T06:52:00.000-07:00

Dev Palmistry

Web Services:

Web services are stored on server and delivered to user over internet. A web application is usually a three- tier sturcture, comprising a User Services Tier (allowing user to access application), a Business Service tier(allowing user to carry out complex activites) and Data Services tier (which allows data storage and ritrival)

What is Reflaction ?

2009-06-16T06:50:00.000-07:00

Refelection :

List of class name , method anme

# Refelection is way through which we can identify metadata about assembly runtime.

Exp : We have a .net Assembly file (.dll file ), which cosists of two class definition and 10 method Names. We can get information about classes and methods names through reflaction.

Few Exp Of Reflaction :

# Loading Assembly file

Assembly assem= Assembly.LoadForm(SAssemblyFileName)

# Get the List of Class Name

Type[]types=assem.GetTypes();

------------------------------------------------------------------------

Refliction:

It extend the benifits of maetadata by allowing the developers to ispect and use it at run time.

# For exp: It dynamically detemined all the classes contained in a given assembly and invoke their methos.

# Reflaction Provides objects that encapsulate assemblies, methods and types

# System.Reflaction namespace contain classes that can be used to introgate the types for module/ assemly.

# All .NeT compliers produce metadata about the types defined in the modules they produce. This metadata is package along with the module (modules in the terms are packaged together assemblies) can be accessed by the machinism called reflection.

# You can use reflaction to dynamically create an instance of a type , bind the type to an existing object, or get the type from an existing object.

How to Write Cover Letter-2 !!

2009-06-15T05:59:00.000-07:00

Devesh Mishra
dev.net9@gmail.com
South Ex, India

Cell: 9911360392
___________________________________________________
Date: Jun 15, 2009

Human Resource Manager
Software Developmentl Pvt. Ltd.
TChetu India, Noida
India

Dear Sir,
I am writing to express my interest in the .NET Programmers post for your organization as mentioned in the national daily 'Times of India' on Jun 10, 2009, and have enclosed my resume for your consideration.

I am a computer engineer with much enthusiasm and experience in developing software systems. I have the experience of leading, organizing and successfully accomplishing software projects with rich set of feature and functionality. Especially, I have been successful in bending abstract system requirements into real software solutions having high security and performance. I have listed below my strengths that will help you learn my background in software development.

# Excellent ability in analyzing requirements and bending them into real software solutions
# Quick in learning and adopting new technology and smart in best utilizing resources
# Speedy in making development strategy and fast in developing solutions
# Strong command over team management and leadership
# Strong power in delivering complex task and getting with long and tedious working environment

With strong communication, team cooperation and programming capability, I am confident I can be a valuable asset in both software development teams and promotion.

I would welcome the opportunity to interview with your selection team and look forward to hearing from you in the near future. Thank you for your time and consideration.

Sincerely,

Devesh Kr. Mishra
Software Engineer,
Arete Consultants Pvt Ltd.
New Delhi-110 002.India

How to Write Cover Letter-1 !!

2009-06-15T05:56:00.000-07:00

Dear Sir/Madam,

As you can see from my CV, my career in software development is quite
extensive. I have a very good reputation in my field and have an
excellent rapport with my colleagues.

My objective is to establish a time when we can meet to discuss how my
talent, professionalism and enthusiasm will add value to your company.
I look forward to speaking with you soon.

Current ctc: 2.4 lacs per annum
Expected ctc: 3.0 lacs per annum
Total IT exp:2 years
Relevant exp: 2 years
DOB: 14 Feb 1983
Notice Period: 15 working days
Current Location: Delhi
Reason for change:Career growth
Education: MCA

--
With best regards

Devesh Kr. Mishra
Software Engineer,
Arete Consultants Pvt Ltd.
New Delhi-110 002.India

Short Answer .NET Interview Questions !!

2009-06-10T05:49:00.000-07:00

Q1. Explain the differences between Server-side and Client-side code?
Ans. Server side code will execute at server (where the website is hosted) end, & all the business logic will execute at server end where as client side code will execute at client side (usually written in javascript, vbscript, jscript) at browser end.

Q2. What type of code (server or client) is found in a Code-Behind class?
Ans. Server side code.

Q3. How to make sure that value is entered in an asp:Textbox control?
Ans. Use a RequiredFieldValidator control.

Q4. Which property of a validation control is used to associate it with a server control on that page?
Ans. ControlToValidate property.

Q5. How would you implement inheritance using VB.NET & C#?
Ans. C# Derived Class : Baseclass
VB.NEt : Derived Class Inherits Baseclass

Q6. Which method is invoked on the DataAdapter control to load the generated dataset with data?
Ans. Fill() method.

Q7. What method is used to explicitly kill a user's session?
Ans. Session.Abandon()

Q8. What property within the asp:gridview control is changed to bind columns manually?
Ans. Autogenerated columns is set to false

Q9. Which method is used to redirect the user to another page without performing a round trip to the client?
Ans. Server.Transfer method.

Q10. How do we use different versions of private assemblies in same application without re-build?
Ans.Inside the Assemblyinfo.cs or Assemblyinfo.vb file, we need to specify assembly version.
assembly: AssemblyVersion

Q11. Is it possible to debug java-script in .NET IDE? If yes, how?
Ans. Yes, simply write "debugger" statement at the point where the breakpoint needs to be set within the javascript code and also enable javascript debugging in the browser property settings.

Q12. How many ways can we maintain the state of a page?
Ans. 1. Client Side - Query string, hidden variables, viewstate, cookies
2. Server side - application , cache, context, session, database

Q13. What is the use of a multicast delegate?
Ans. A multicast delegate may be used to call more than one method.

Q14. What is the use of a private constructor?
Ans. A private constructor may be used to prevent the creation of an instance for a class.

Q15. What is the use of Singleton pattern?
Ans. A Singleton pattern .is used to make sure that only one instance of a class exists.

Q16. When do we use a DOM parser and when do we use a SAX parser?
Ans. The DOM Approach is useful for small documents in which the program needs to process a large portion of the document whereas the SAX approach is useful for large documents in which the program only needs to process a small portion of the document.

Q17. Will the finally block be executed if an exception has not occurred?
Ans.Yes it will execute.

Q18. What is a Dataset?
Ans. A dataset is an in memory database kindof object that can hold database information in a disconnected environment.

Q19. Is XML a case-sensitive markup language?
Ans. Yes.

Q20. What is an .ashx file?
Ans. It is a web handler file that produces output to be consumed by an xml consumer client (rather than a browser).

Q21. What is encapsulation?
Ans. Encapsulation is the OOPs concept of binding the attributes and behaviors in a class, hiding the implementation of the class and exposing the functionality.

Q22. What is Overloading?
Ans. When we add a new method with the same name in a same/derived class but with different number/types of parameters, the concept is called overluoad and this ultimately implements Polymorphism.

Q23. What is Overriding?
Ans. When we need to provide different implementation in a child class than the one provided by base class, we define the same method with same signatures in the child class and this is called overriding.

Q24. What is a Delegate?
Ans. A delegate is a strongly typed function pointer object that encapsulates a reference to a method, and so the function that needs to be invoked may be called at runtime.

Q25. Is String a Reference Type or Value Type in .NET?
Ans. String is a Reference Type object.

Q26. What is a Satellite Assembly?
Ans. Satellite assemblies contain resource files corresponding to a locale (Culture + Language) and these assemblies are used in deploying an application globally for different languages.

Q27. What are the different types of assemblies and what is their use?
Ans. Private, Public(also called shared) and Satellite Assemblies.

Q28. Are MSIL and CIL the same thing?
Ans. Yes, CIL is the new name for MSIL.

Q29. What is the base class of all web forms?
Ans. System.Web.UI.Page

Q30. How to add a client side event to a server control?
Ans. Example... BtnSubmit.Attributes.Add("onclick","javascript:fnSomeFunctionInJavascript()");

Q31. How to register a client side script from code-behind?
Ans. Use the Page.RegisterClientScriptBlock method in the server side code to register the script that may be built using a StringBuilder.

Q32. Can a single .NET DLL contain multiple classes?
Ans. Yes, a single .NET DLL may contain any number of classes within it.

Q33. What is DLL Hell?
Ans. DLL Hell is the name given to the problem of old unmanaged DLL's due to which there was a possibility of version conflict among the DLLs.

Q34. can we put a break statement in a finally block?
Ans. The finally block cannot have the break, continue, return and goto statements.

Q35. What is a CompositeControl in .NET?
Ans. CompositeControl is an abstract class in .NET that is inherited by those web controls that contain child controls within them.

Q36. Which control in asp.net is used to display data from an xml file and then displayed using XSLT?
Ans. Use the asp:Xml control and set its DocumentSource property for associating an xml file, and set its TransformSource property to set the xml control's xsl file for the XSLT transformation.

Q37. Can we run ASP.NET 1.1 application and ASP.NET 2.0 application on the same computer?
Ans. Yes, though changes in the IIS in the properties for the site have to be made during deployment of each.

Q38. What are the new features in .NET 2.0?
Ans. Plenty of new controls, Generics, anonymous methods, partial classes, iterators, property visibility (separate visibility for get and set) and static classes.

Q39. Can we pop a MessageBox in a web application?
Ans. Yes, though this is done clientside using an alert, prompt or confirm or by opening a new web page that looks like a messagebox.

Q40. What is managed data?
Ans. The data for which the memory management is taken care by .Net runtimeâ€™s garbage collector, and this includes tasks for allocation de-allocation.

Q41. How to instruct the garbage collector to collect unreferenced data?
Ans. We may call the garbage collector to collect unreferenced data by executing the System.GC.Collect() method.

Q42. How can we set the Focus on a control in ASP.NET?
Ans. txtBox123.Focus(); OR Page.SetFocus(NameOfControl);

Q43. What are Partial Classes in Asp.Net 2.0?
Ans. In .NET 2.0, a class definition may be split into multiple physical files but partial classes do not make any difference to the compiler as during compile time, the compiler groups all the partial classes and treats them as a single class.

Q44. How to set the default button on a Web Form?
Ans.

Q45.Can we force the garbage collector to run?
Ans. Yes, using the System.GC.Collect(), the garbage collector is forced to run in case required to do so.

Q46. What is Boxing and Unboxing?
Ans. Boxing is the process where any value type can be implicitly converted to a reference type object while Unboxing is the opposite of boxing process where the reference type is converted to a value type.

Q47. What is Code Access security? What is CAS in .NET?
Ans. CAS is the feature of the .NET security model that determines whether an application or a piece of code is permitted to run and decide the resources it can use while running.

Q48. What is Multi-tasking?
Ans. It is a feature of operating systems through which multiple programs may run on the operating system at the same time, just like a scenario where a Notepad, a Calculator and the Control Panel are open at the same time.

Q49. What is Multi-threading?
Ans. When an application performs different tasks at the same time, the application is said to exhibit multithreading as several threads of a process are running.2

Q50. What is a Thread?
Ans. A thread is an activity started by a process and its the basic unit to which an operating system allocates processor resources.

Q51. What does AddressOf in VB.NET operator do?
Ans. The AddressOf operator is used in VB.NET to create a delegate object to a method in order to point to it.

Q52. How to refer to the current thread of a method in .NET?
Ans. In order to refer to the current thread in .NET, the Thread.CurrentThread method can be used. It is a public static property.

Q53. How to pause the execution of a thread in .NET?
Ans. The thread execution can be paused by invoking the Thread.Sleep(IntegerValue) method where IntegerValue is an integer that determines the milliseconds time frame for which the thread in context has to sleep.

Q54. How can we force a thread to sleep for an infinite period?
Ans. Call the Thread.Interupt() method.

Q55. What is Suspend and Resume in .NET Threading?
Ans. Just like a song may be paused and played using a music player, a thread may be paused using Thread.Suspend method and may be started again using the Thread.Resume method. Note that sleep method immediately forces the thread to sleep whereas the suspend method waits for the thread to be in a persistable position before pausing its activity.

Q56. How can we prevent a deadlock in .Net threading?
Ans. Using methods like Monitoring, Interlocked classes, Wait handles, Event raising from between threads, using the ThreadState property.

Q57. What is Ajax?
Ans. Asyncronous Javascript and XML - Ajax is a combination of client side technologies that sets up asynchronous communication between the user interface and the web server so that partial page rendering occur instead of complete page postbacks.

Q58. What is XmlHttpRequest in Ajax?
Ans. It is an object in Javascript that allows the browser to communicate to a web server asynchronously without making a postback.

Q59. What are the different modes of storing an ASP.NET session?
Ans. InProc (the session state is stored in the memory space of the Aspnet_wp.exe process but the session information is lost when IIS reboots), StateServer (the Session state is serialized and stored in a separate process call Viewstate is an object in .NET that automatically persists control setting values across the multiple requests for the same page and it is internally maintained as a hidden field on the web page though its hashed for security reasons.

Q60. What is a delegate in .NET?
Ans. A delegate in .NET is a class that can have a reference to a method, and this class has a signature that can refer only those methods that have a signature which complies with the class.

Q61. Is a delegate a type-safe functions pointer?
Ans. Yes

Q62. What is the return type of an event in .NET?
Ans. There is No return type of an event in .NET.

Q63. Is it possible to specify an access specifier to an event in .NET?
Ans. Yes, though they are public by default.

Q64. Is it possible to create a shared event in .NET?
Ans. Yes, but shared events may only be raised by shared methods.

Q65. How to prevent overriding of a class in .NET?
Ans. Use the keyword NotOverridable in VB.NET and sealed in C#.

Q66. How to prevent inheritance of a class in .NET?
Ans. Use the keyword NotInheritable in VB.NET and sealed in C#.

Q67. What is the purpose of the MustInherit keyword in VB.NET?
Ans. MustInherit keyword in VB.NET is used to create an abstract class.

Q68. What is the access modifier of a member function of in an Interface created in .NET?
Ans. It is always public, we cant use any other modifier other than the public modifier for the member functions of an Interface.

Q69. What does the virtual keyword in C# mean?
Ans. The virtual keyword signifies that the method and property may be overridden.

Q70. How to create a new unique ID for a control?
Ans. ControlName.ID = "ControlName" + Guid.NewGuid().ToString(); //Make use of the Guid class

Q71A. What is a HashTable in .NET?
Ans. A Hashtable is an object that implements the IDictionary interface, and can be used to store key value pairs. The key may be used as the index to access the values for that index.

Q71B. What is an ArrayList in .NET?
Ans. Arraylist object is used to store a list of values in the form of a list, such that the size of the arraylist can be increased and decreased dynamically, and moreover, it may hold items of different types. Items in an arraylist may be accessed using an index.

Q72. What is the value of the first item in an Enum? 0 or 1?
Ans. 0

Q73. Can we achieve operator overloading in VB.NET?
Ans. Yes, it is supported in the .NET 2.0 version, the "operator" keyword is used.

Q74. What is the use of Finalize method in .NET?
Ans. .NET Garbage collector performs all the clean up activity of the managed objects, and so the finalize method is usually used to free up the unmanaged objects like File objects, Windows API objects, Database connection objects, COM objects etc.

Q75. How do you save all the data in a dataset in .NET?
Ans. Use the AcceptChanges method which commits all the changes made to the dataset since last time Acceptchanges was performed.

Q76. Is there a way to suppress the finalize process inside the garbage collector forcibly in .NET?
Ans. Use the GC.SuppressFinalize() method.

Q77. What is the use of the dispose() method in .NET?
Ans. The Dispose method in .NET belongs to IDisposable interface and it is best used to release unmanaged objects like File objects, Windows API objects, Database connection objects, COM objects etc from the memory. Its performance is better than the finalize() method.

Q78. Is it possible to have have different access modifiers on the get and set methods of a property in .NET?
Ans. No we can not have different modifiers of a common property, which means that if the access modifier of a property's get method is protected, and it must be protected for the set method as well.

Q79. In .NET, is it possible for two catch blocks to be executed in one go?
Ans. This is NOT possible because once the correct catch block is executed then the code flow goes to the finally block.

Q80. Is there any difference between System.String and System.StringBuilder classes?
Ans. System.String is immutable by nature whereas System.StringBuilder can have a mutable string in which plenty of processes may be performed.

Q81. What technique is used to figure out that the page request is a postback?
Ans. The IsPostBack property of the page object may be used to check whether the page request is a postback or not. IsPostBack property is of the type Boolean.

Q82. Which event of the ASP.NET page life cycle completely loads all the controls on the web page?
Ans. The Page_load event of the ASP.NET page life cycle assures that all controls are completely loaded. Even though the controls are also accessible in Page_Init event but here, the viewstate is incomplete.

Q83. How is ViewState information persisted across postbacks in an ASP.NET webpage?
Ans. Using HTML Hidden Fields, ASP.NET creates a hidden field with an ID="__VIEWSTATE" and the value of the page's viewstate is encoded (hashed) for security.

Q84. What is the ValidationSummary control in ASP.NET used for?
Ans. The ValidationSummary control in ASP.NET displays summary of all the current validation errors.

Q85. What is AutoPostBack feature in ASP.NET?
Ans. In case it is required for a server side control to postback when any of its event is triggered, then the AutoPostBack property of this control is set to true.

Q86. What is the difference between Web.config and Machine.Config in .NET?
Ans. Web.config file is used to make the settings to a web application, whereas Machine.config file is used to make settings to all ASP.NET applications on a server(the server machine).

Q87. What is the difference between a session object and an application object?
Ans. A session object can persist information between HTTP requests for a particular user, whereas an application object can be used globally for all the users.

Q88. Which control has a faster performance, Repeater or Datalist?
Ans. Repeater.

Q89. Which control has a faster performance, Datagrid or Datalist?
Ans. Datalist.

Q90. How to we add customized columns in a Gridview in ASP.NET?
Ans. Make use of the TemplateField column.

Q91. Is it possible to stop the clientside validation of an entire page?
Ans. Set Page.Validate = false;

Q92. Is it possible to disable client side script in validators?
Ans. Yes. simply EnableClientScript = false.

Q93. How do we enable tracing in .NET applications?
Ans. <%@ Page Trace="true" %>

Q94. How to kill a user session in ASP.NET?
Ans. Use the Session.abandon() method.

Q95. Is it possible to perform forms authentication with cookies disabled on a browser?
Ans. Yes, it is possible.

Q96. What are the steps to use a checkbox in a gridview?
Ans.
OnCheckedChanged="Check_Clicked">

Q97. What are design patterns in .NET?
Ans. A Design pattern is a repeatitive solution to a repeatitive problem in the design of a software architecture.

Q98. What is difference between dataset and datareader in ADO.NET?
Ans. A DataReader provides a forward-only and read-only access to data, while the DataSet object can carry more than one table and at the same time hold the relationships between the tables. Also note that a DataReader is used in a connected architecture whereas a Dataset is used in a disconnected architecture.

Q99. Can connection strings be stored in web.config?
Ans. Yes, in fact this is the best place to store the connection string information.

Q100. Whats the difference between web.config and app.config?
Ans. Web.config is used for web based asp.net applications whereas app.config is used for windows based applications.

What does the virtual keyword in C# mean?

2009-06-10T05:48:00.000-07:00

Que. What does the virtual keyword in C# mean?
Ans. The virtual keyword signifies that the method and property may be overridden.

Que. What is the access modifier of a member function of in an Interface created in .NET?

2009-06-10T05:47:00.000-07:00

Que. What is the access modifier of a member function of in an Interface created in .NET?
Ans. It is always public, we cant use any other modifier other than the public modifier for the member functions of an Interface.

How to prevent inheritance of a class in .NET?

2009-06-10T05:46:00.000-07:00

Que. How to prevent inheritance of a class in .NET?
Ans. Use the keyword NotInheritable in VB.NET and sealed in C#.

Que. How to prevent overriding of a class in .NET?

2009-06-10T05:45:00.000-07:00

Que. How to prevent overriding of a class in .NET?
Ans. Use the keyword NotOverridable in VB.NET and sealed in C#.

Is it possible to create a shared event in .NET?

2009-06-10T05:44:00.000-07:00

Que. Is it possible to create a shared event in .NET?
Ans. Yes, but shared events may only be raised by shared methods.

Is it possible to specify an access specifier to an event in .NET?

2009-06-10T05:43:00.001-07:00

Que. Is it possible to specify an access specifier to an event in .NET?
Ans. Yes, though they are public by default.

What is the return type of an event in .NET?

2009-06-10T05:41:00.000-07:00

Que. What is the return type of an event in .NET?
Ans. There is No return type of an event in .NET.

Is a delegate a type-safe functions pointer?

2009-06-10T05:39:00.000-07:00

Que. Is a delegate a type-safe functions pointer?
Ans. Yes

What is the difference between a session object and an application object?

2009-06-10T05:38:00.000-07:00

Que. What is the difference between a session object and an application object?
Ans. A session object can persist information between HTTP requests for a particular user, whereas an application object can be used globally for all the users.

Which control has a faster performance, Repeater or Datalist?

2009-06-10T05:37:00.000-07:00

Que. Which control has a faster performance, Repeater or Datalist?
Ans. Repeater.

Which control has a faster performance, Datagrid or Datalist?

2009-06-10T05:34:00.000-07:00

Que. Which control has a faster performance, Datagrid or Datalist?
Ans. Datalist.

Is it possible to perform forms authentication with cookies disabled on a browser?

2009-06-10T05:33:00.000-07:00

Que. Is it possible to perform forms authentication with cookies disabled on a browser?
Ans. Yes, it is possible.

What are the steps to use a checkbox in a gridview?

2009-06-10T05:31:00.000-07:00

Que. What are the steps to use a checkbox in a gridview?
Ans.
OnCheckedChanged="Check_Clicked">

How do we enable tracing in .NET applications?

2009-06-10T05:29:00.002-07:00

Que. How do we enable tracing in .NET applications?
Ans. <%@ Page Trace="true" %>

Is it possible to disable client side script in validators?

2009-06-10T05:29:00.001-07:00

Que. Is it possible to disable client side script in validators?
Ans. Yes. simply EnableClientScript = false.

How to we add customized columns in a Gridview in ASP.NET?

2009-06-10T05:28:00.000-07:00

Que. How to we add customized columns in a Gridview in ASP.NET?
Ans. Make use of the TemplateField column.

Is it possible to stop the clientside validation of an entire page?

2009-06-10T05:27:00.000-07:00

Que. Is it possible to stop the clientside validation of an entire page?
Ans. Set Page.Validate = false;

Why we use Autogenerated columns?

2009-06-10T05:24:00.000-07:00

Que. What property within the asp:gridview control is changed to bind columns manually?
Ans. Autogenerated columns is set to false

What method is used to explicitly kill a user's session?

2009-06-10T05:23:00.000-07:00

Que. What method is used to explicitly kill a user's session?
Ans. Session.Abandon()

Is XML a case-sensitive markup language?

2009-06-10T05:21:00.000-07:00

Que. Is XML a case-sensitive markup language?
Ans. Yes.

What is the base class of all web forms?

2009-06-10T05:19:00.000-07:00

Dev Palmistry

Que. What is the base class of all web forms?
Ans. System.Web.UI.Page

What is managed data?

2009-06-10T05:18:00.000-07:00

Que. What is managed data?
Ans. The data for which the memory management is taken care by .Net runtimeâ€™s garbage collector, and this includes tasks for allocation de-allocation.

What are the new features in .NET 2.0?

2009-06-10T05:16:00.002-07:00

Que. What are the new features in .NET 2.0?
Ans. Plenty of new controls,
Generics,
anonymous methods,
partial classes,
iterators,
property visibility (separate visibility for get and set) and static classes.

Can we run ASP.NET 1.1 application and ASP.NET 2.0 application on the same computer?

2009-06-10T05:16:00.001-07:00

Que. Can we run ASP.NET 1.1 application and ASP.NET 2.0 application on the same computer?
Ans. Yes, though changes in the IIS in the properties for the site have to be made during deployment of each.

Is String a Reference Type or Value Type in .NET?

2009-06-10T05:13:00.000-07:00

Que. Is String a Reference Type or Value Type in .NET?
Ans. String is a Reference Type object.

Are MSIL and CIL the same thing?

2009-06-10T05:10:00.000-07:00

Dev Palmistry

Que. Are MSIL and CIL the same thing?
Ans. Yes, CIL is the new name for MSIL.

How to Describe Project !!

2009-06-10T04:51:00.000-07:00

PROJECT SUMMARY

1. IDLDPL (Indian Digital Life Style Distributors Pvt. Ltd.)
(Current Running Project)

Employer: Arete Consultants pvt ltd.

Profile: Software Developer

Duration: Sep ’08 to till date

Responsibilities: Involved in coding, Writing Stored Procedures, Views, Database Developing.

My Modules: Master, Stock Transfer, Stock Return and Other. And Whole User Part.

Environment: Windows XP SP2, Visual Studio 2005 Dot Net Framework: 2.0

DataBase: Microsoft SQL Server 2000.

Team Members: 5
Role: Design and Coding with Database.

Tools: C#.NET, Java Script, Ajax.

Project Description:

IDLDPL systems are fully integrated solutions, developed on 3 tier architecture. They provide a backbone foundation system that provides most of the day-to-day business transactions. They are designed to deliver a seamless integration of information and knowledge. These systems are very powerful tools that can provide significant benefit to any distributed departments.
In addition, these fully integrated systems establish a foundation platform for delivering Web-based services and transactions, providing additional value to the organization and its customers.

IDLDPL contains the following modules:-?

Masters – First interface for add Employer, Customer, Supplier, Products etc as well as all the dropdown down values like Bank name, Brand Name etc.

Sale – Generate Order Form, Order Purchasing Form, and Invoice all with Edit, View Copy and Detail Facilities.

Purchase – Generate Purchase Order, Receive Invoice all with Edit, View Copy and Detail Facilities.

Stock Transfer – Generate Stock Transfer Request, Edit, And View Than Dispatch. As well as Received Request with Data Base Update.

Stock Return – Generate Stock Return to Supplier and From Customer with same Process as like Stock Transfer.

Payment – Used For All Payment Sent and Received Purpose.

Other – Containing the Other Forms like Job, News, and Products Offers etc…

Difference between Abstract Class and Interface ?

2009-05-29T19:59:00.000-07:00

Dev Palmistry

Abstract Class:

# IS-A relationship.
# e.g. Student IS A Person, Employee IS A Person.
# cannot be instantiated.
# normally used for framework-type library classes: providing default behavior for some of its class members, but forcing the developer to implement

others.
# It has to be inherited for use .
# You need to INHERIT to use an abstract class.
# Attempting to instantiate an object of an abstract class retults in a compilation error
# Any Class with abstract method or property in it must be declared abstract
# Abstract will allow you to set the access specifier. Ex:- (private,public, protected, internal).
# Abstract will allow you to implement the body in abstract methods.
# Situation where functionality may add/remove "Abstract Class" is best solution.
# Eg. Creating Base Classes,Creating Base for your project where functionality may be added or remove or can be override if needed.Mostly common task are

move to base class and if required than can be overrided.

# in Abstract class you can Declare the Constructors,fields,methods,indexes,destructors etc

# practical example for abstract class:

we can use account class in bank as abstract class.inreality

there will be no account we can use .but only sbaccount and current account will be exist.so we can use account class as abstract

class and we can inherits this class in sbaccount class,current account class

# Example:
pulic Abstract Class A
{
public void Hi();

public void Hello()
{
Console.WriteLine("hello method");
}

}
public Class B
{
public overid void Hi()
{
Console.WriteLine("hi method");
}

2. Abstract Class: Allows common functionality to be shared across similar objects

Of course, don't use an abstract class in cases where functionality doesn't need to be shared.

Interface:

# CAN-DO relationship.
# e.g. Student CAN enrol, Student CAN submit assignment.
# cannot be instantiated.
# group of related methods with empty bodies .
# You need to IMPLEMENT to use an interface.

# The implementation of an interface is left completely to the developer.
# Interfaces can contain only the signature of a method but no body.
# Interfaces are used to declaring functionality.
# By default all interface methods are public.
# Situation where we have fix requirement "Interface" is best solution.
# Eg. Plugin .Where Pluging can be loaded dynamically and executes its functionality.
Thus that Plugin must follow or implement certain functionality.
# In class you can implement the interface method, but can’t implement the body in Interface method.
# in interface you can not Declare the Constructors,fields,methods,indexes,destructors
# Examples:'
//mutltiple inhiritance
Interface IA
{
void cat();
void Dog();
}
Interface IB
{
void door();
void tyres();
}
public class C:IA,IB
{
public void cat()
{
Console.WriteLine("hello cat method");
}
public void dog()
{
Console.WriteLine("hello dog method");
}
public void door()
{
Console.WriteLine("hello door method");
}
public void tyres()
{
Console.WriteLine("hello tyres method");
}
}

Exp : 1. Interfaces are useful when you do not want classes to inherit from unrelated classes just to get the required functionality. For example, let bird

be a class with a method fly(). It will be ridiculous for an aeroplane to inherit from bird class just because it has the fly() method. Rather the fly()

method should be defined as an interface and both bird and aeroplane should implement that interface.

Exp 2. Hi what suits my case !! Say a real estate builder is constructing an apartment with many flats.All the rooms in the flats have the same design,except

the bedroom. The bedroom design is left for the ppl who would own the flats i.e; the bedRooms can be of different designs for different flats.
I can achieve this through an abstract class like below:

public abstract class Flat
{
//some properties

public void livingRoom(){
//some code
}

public void kitchen(){
//some code
}

public abstract void bedRoom();

}

An implementation class would be as follows:

public class Flat101 extends Flat
{
public void bedRoom() {
System.out.println("This flat has a customized bedroom");
}

}

# Interface is without implementation, just interface or virtual methods.

# As per my understanding, it is can-do or is-do relationship. Like, from .NET framework, there are many interface like IComparer, ISortable etc. So, it is

something like, classes derived from the interface CAN-DO these things.

Defference :

# A class can inherit one or more interfaces, but only one abstract class.

# An abstract class can have abstract members as well non abstract members. But in an interface all the members are implicitly abstract and all the members

of the interface must override to its derived class.

# The members of the interface are public with no implementation. Abstract classes can have protected parts, static methods, etc.

# Interface are similar to abstraction classes.However , interfaces represent the higest level of abstraction in Object- oriented programming.This is because

all the methods in an interface are abstract and do not have implementation.In contrast ,the abstract classes might contain a method that has a body.

# 1).Interface have only signature. whereas Abstract class have signature and definition both r allow. 2). Interface have not allow modifier access. whereas

Abstract class are allowed modifier access. 3).Thurogh the Interface we can create the Multiple Inheritance whereas Abstract class are not allow the Multiple

Inheritance. 4).Interface is slower compare Abstract class.

# An abstract class may contain complete or incomplete methods. Interfaces can contain only the signature of a method but no body. Thus an abstract class can

implement methods but an interface can not implement methods. · An abstract class can contain fields, constructors, or destructors and implement properties.

An interface can not contain fields, constructors, or destructors and it has only the property's signature but no implementation. · An abstract class cannot

support multiple inheritance, but an interface can support multiple inheritance. Thus a class may inherit several interfaces but only one abstract class. · A

class implementing an interface has to implement all the methods of the interface, but the same is not required in the case of an abstract Class. · Various

access modifiers such as abstract, protected, internal, public, virtual, etc. are useful in abstract Classes but not in interfaces.

# Interface:- 1. Interfaces are used to declaring functionality. 2. By default all interface methods are public. 3. In class you can implement the interface

method, but can’t implement the body in Interface method. Abstract:- 1. Abstract will allow you to set the access specifier. Ex:- (private,public, protected,

internal). 2. Abstract will allow you to implement the body in abstract methods. 3. You can inherit the abstract methods in classes

# • Abstract Class
Cannot be instantiated.
Must be inherited and its methods should be overridden.
It have some concreate methods.
Access modifiers allowed.

• Interface
Have definition of a method not implementation. (implement through class)
Multiple inheritance possible through Interface only
Only Public Access modifier only allowed. Defaultly Public
No need of virtual overridden.
It’s used for to define a set of properties, methods and events.

# Following are the difference between abstract and interface,

1>Abstract class having method declaration as well as method method definition whereas interface having method declaration only.

2>Abstract class are known as partial abstract class whereas interface is known as fully abstract class.

3>Abstract class features we have to inherit to the child class whereas interface features we have to implement in the child classes.

4>Abstract class support access specifiers whereas interface doesn't support access specifiers.

5>Abstract class have normal variable as well as constant variable whereas interface have only constant variables.(Discuss it)

6>We can write constructor in abstract class whereas we can't write constructor in interface.

# Interfaces are similar to abstract classes.However,interface represent the highest level of abstraction in object-oriented programming.This is because all

the methods in an interface are abstract and do not have implementation.In contrast,the abstract classes that are created using Abstract keyword might

contain a method that has a body.

# Abstract Class vs. Interface
· An abstract class may contain complete or incomplete methods. Interfaces can contain only the signature of a method but no body. Thus an abstract

class can implement methods but an interface can not implement methods.

· An abstract class can contain fields, constructors, or destructors and implement properties. An interface can not contain fields, constructors, or

destructors and it has only the property's signature but no implementation.

· An abstract class cannot support multiple inheritance, but an interface can support multiple inheritance. Thus a class may inherit several

interfaces but only one abstract class.

· A class implementing an interface has to implement all the methods of the interface, but the same is not required in the case of an abstract Class.

· Various access modifiers such as abstract, protected, internal, public, virtual, etc. are useful in abstract Classes but not in interfaces.

· Abstract classes are faster than interfaces.

What is WSDL ?

2009-05-29T06:56:00.000-07:00

Dev Palmistry

Que: What is WSDL ?
Answer: WSDL stands for Web Services Description Language, a standard by web services can tell clients what messages it accepts and which results it will return. It provides you information on the classes and methods that are supported by a particular web services.

What is UDDI ?

2009-05-29T06:51:00.001-07:00

Que : What is UDDI ?
Ans: UDDI is Universal Description, Discovery and Integration Language. UDDI allow you to find web services by connecting to a directory. It is a directory that can be used to publish and discover public web services.

How to prevent a button from validation it’s form?

2009-05-29T06:44:00.000-07:00

Que: How to prevent a button from validation it’s form?
Answer: Set the Causevalidation property of the button control to false . This is useful while user presses reset button.

Explain Unmanaged Environment From Dot Net Framework.

2009-05-29T06:42:00.001-07:00

Que: Explain Unmanaged Environment From Dot Net Framework.
Answer : Code that does not operate within the CLR is called unmanaged code. Unmanaged code does not get benefits offered by CLR including garbage collection, memory management, security, etc. Exp. COM component are unmanaged code.

Explain Managed Environment From Dot Net Framework .

2009-05-29T06:39:00.001-07:00

Que: Explain Managed Environment From Dot Net Framework .
Answer : Code that operates within the CLR is called managed code. Managed code benefits form the services that the CLR offers, including garbage collection, memory management, security etc.

When during the page process cycle is viewing available?

2009-05-29T06:38:00.001-07:00

Que: When during the page process cycle is viewing available?
Answer : After the init() and before the Page_Load(), or OnLoad() for control.

What is the .resx file ?

2009-05-29T06:37:00.001-07:00

Que : What is the .resx file ?
Answer: The .resx resource file format consists of XML entities, which specify objects and string inside XML tags.

What is Event Bubbling ?

2009-05-29T06:35:00.000-07:00

Dev Palmistry

Que: What is Event Bubbling?
Answer: Server control like Data Grid, Datalist, Repeator can have other child controls inside them. Exp Datagrid can have conbo box inside datagrid.Thise child control do not raise there event by themselves , rather they pass the event to the container parent (which can be a daragrid, datalist, repeater) , which passes to the page as “Itemcommand “ event. As the child control send there event to parent this is termed as event Bubbling.

What is WebServices ?

2009-05-29T06:33:00.000-07:00

Que: What is Web Services ?
Answer : Web Services is an application that is designed to interact directly with other application over Internet.

Web Services is : Platform Independent, Language Independent and Protocol Independent.

Web Services communicate by standard web protocol and data format such as HTTP, XML and SOAP.

Example of Web Services: Whether Report Services, Stock Quote and News Headlines.

Difference between Trace and Debug Class !

2009-04-14T05:26:00.000-07:00

Dev Palmistry

Trace and Debug classes :

Fortunately, you do not have to step through an application line by line to figure out what is happening.

The Systems.Diagnostics namespace includes Trace and Debug classes.

These two classes (which are essentially identical) include a number of static methods that can be used to cause your code to gather information about code-execution paths, code coverage, and even performance profiling. Both classes also provide an Assert method that checks for a condition and displays a message if the condition is false.

Tracing : Tracing is actually the process of collecting information about the program's execution.

Debug : Debugging is the process of finding & fixing errors in our program.

What’s the difference between the Debug class and Trace class?

Documentation looks the same. Use Debug class for debug builds, use Trace class for both debug and release builds.

----------------------------------------------------------------------------------------
Please Give a Glance......
dev-palmestry.blogspot.com/
of this blog.
----------------------------------------------------------------------------------------

Join-Cross join

2009-02-23T21:26:00.000-08:00

A join is a query that combines rows from two or more tables, views, or materialized views.
Most join queries contain WHERE clause conditions that compare two columns, each from a different table. Such a condition is called a join condition.
CROSS JOIN (Cartesian product) is the simplest join.
We can start with the simplest possible join -- the "cross join" (or Cartesian product). If we have two database tables consisting of information about CDs and musical artists:

A join simply multiplies the two tables together into a new virtual table. There are four members of the Artists table and seven members in the CDs table which will result in 28 (!) rows in the result. You can try this using the following syntax,
SELECT * FROM Artists, CDs
and you should see a result that looks like the following table:

This table is typically filtered using the WHERE clause, for example

SELECT * FROM Artists, CDs WHERE Artists.ArtistID=CDs.ArtistID

Some Practical .Net Soultions !!

2009-02-19T05:11:00.000-08:00

Que : How To Convet Uppercase later ?

Ans : Select UPPER (dir_name) as name from tbldirectots.
The out put will come like DENESH KUMAR, VIJAY SHUKLA

Que . How to get the image on the user page by DataReader ?

Ans : TitleImage.Imageurl=folderpath + dirv["au_page_image"].ToString() ;
Note : 1 . For getting the folderpath we use this code on .cs page public string folderpath =
ConfigurationManager.AppSettings["folserpath"].ToString () ;
2. This key is defined in the Web.Config file like that -
<>
< key="folderpath" value="upload/">
3. Upload is the folder where the image is stored .
4. ImageUrl is like txt for text box of Image .Like txtname.text .

Que : How to show the Image on the User Page by GridView ?
Ans : By This Code
'/> Note : 1. In The Upload folder , image is stored there .Image has two things one Image and
second its name (boy.jpg)
2. Image Name like (boy.jpg) is saved in database's field like (dir_image) .
Mistake : One mistake when i was using DataReader .
Ans : 1. In the DataReader while loop are used . i don't know foreach loop can be used or
not , but when i was using it was not working .I was using foreach loop in DataReader and it
was not working ,it takes of time but did't work and ultimately i used while loop and i got
my task .
2. Sql DataReader DerDr=DirCom.ExecuteReader() ;
if (DerDr.HasRows)
{ while(DerDr.Read())
DirName=DirName + "" + DerDr["dir_name"].ToString() +" "
1:
}

Que : What syntax is used for Back Button ?
Ans : < href="javascript:history.back(-1);"> Back

Que : A Query for select the fixed character ?
Ans : string str = "select top 4*,substring (pr_title,1,100) as detail from tblProjectMaster
where pr_active='yes'and pr_delete='No' order by pr_iddesc" .

Que : What is the Syntax for Back link and Forword link ?
Ans : Syntax for Back link and Forword link :
< href="javascript: history .go (-1)">
< href="javascript: history .back(-1)">

Que : What is the code for OnImage Click ?
Ans : < width="100" class="hometxt">
< href="'Upload/<%">' rel="lightbox > <
img src='Upload/<% Databinder.Eval(Container,"DataItem.image") %>' style=""bordercolor=""
width="" hight="" border="" />
On putting mouse over image this link will appear -
http://localhost:1713/smi/upload/sunset.jpj .

Description of Project !!

2009-02-19T04:56:00.000-08:00

Take an example of Project and we will discuss that how can you describe a project, there is an project SMI, and it is its URL...
http://www.smigroup.com.au/

Description of Project : SMI Project Description

SMI project has module 2 module : First is User and Second is Admin .
Here first i am explaing about User Part :
user part has the following module :
1. Home
2.About Us
3.Leadership
4.SMI Project Sulutions
5.SMI Building Services
6.SMI Fire Services
7.News & Events
8.Careers
9.Contact Us
Module 2 : In this module we explane what we are and which types of services we are providing .
Module 3 : In This module we explain the we are leader in this fiels to provies services, by giveing any person or company status. That we are the leader in this field.
Module 4 : SMI Project Solution has there part :
1.Project Solutions Profile
2.Project Gallery
3.Key People
1 . Project Solution Profile :
SMI Project Solutions provides the following construction contracting and professional management services: Fitout and refurbishmentConstructionLump sum contractingBuilding and Fire ServicesDesign and constructProject and construction managementProgram and cost management
This page show two thigs : Know about our KEY PEOPLE and second is Latest Projects .

In This page the 4 latest project has been shown with Project Code and Title . You can say this page is a like a listing of project and by this you can see aal the project by clicking show all link . And it ypu want to see the detail of the project just clik the image or link to see the detail of the project . In the project detail you can see 1. Project Code , 2.Duration (Starting Date and Ending date),3.Project Value (In Ruppes or $) , 4.Client (Client Name) , 5.Description . In The Description part there are some more information is being provided like - 1.Client Detail, 2.Architect, 3.Project Description , 4.Form of Contract Used ,5.Additional Information (With Project Detail there is also some image has been shown )
2 . Project Gallery : In the projct Gallery, you can see the - 1.Project Image , 2. Project Code , 3.Starting Date and Ending Date , 4.and Title of Project are shown as listing with 5 or 6 records and there is paging is being used .And link has been given to see the Detail in the Image and Title both .
If you want to see the Detailof the Project ,click the Image and see the Details. Details have the folloeing headlines - 1.Project Code ,2.Duration , 3.Project Value , 4.Title , 5.Client, 6. Description
. Description has folloeing headlines - 1.Client details , 2.Architect ,3.Project Description ,4.Project Description ,5.Additional Information (In additional information it explane about the project and some image of projects )
3.Key People : In this section 1.Team Leader/Director, 2.Project Manager ,3.Construction Manager, 4.Site Manager's Details are given With Their Photos.

Module 5 : SMI Building Services mdoule has simlarly three parts like the SMI Project Solution has
1.Building Services Profile
2.Project Gallery
3.Key People

Module 6 : Similarly SMI Fire Services has .

Module 7 : In The News and Events Module : The listing of New and Events are being shown in the form of Image , Title , Little Description and Date . Paging is also used in this page because the listings are shown in the 5 or 6 records.And if user wants to know about the Details the News and Events click the Title link and see the Details of the News. News and Events are shown in the following headlines - 1. Title , 2. Image ,3. Details itc.
Module 8 : In this module , this module look like that ;
We are expanding our team resulting in exciting opportunities in all areas of our business.
Our team consists of skilled, innovative and passionate people with unique ideas and approaches. We seek challenges, assume leadership, and continuously exceed goals. In return, we share in generous rewards and have the opportunity to be involved in some of the most exciting projects.
Please forward your CV via the contacts below.
E-mail: reception@smigroup.com.au or Postal Address: SMI Careers20 Challis StreetDICKSON ACT 2602
Current Openings : By clicking this link we can find the vacanicies for different post with description . Any condidate who are interested can fill the form or apply for the specific post .

Module 9 : In this module we will get the information about the Company and maps, like that :
SMI FITOUT PTY LIMITED ABN: 91 115 312 546
Canberra
T : (02) 6230 6995F : (02) 6262 9945E : reception@smigroup.com.au
Office Address20 Challis StreetDICKSON ACT 2602
Postal AddressPO Box 409DICKSON ACT 2602
View Larger Map

Server Contrl's ID Property !!

2009-02-19T04:49:00.000-08:00

Que : What is the ID of ASP.NET server controls ? And why it is used ?

Ans : By ID property of the server control, we can uniquely identify the control.We can not have the two server contros on the same wev forms with same ID. The ID of server control is used as a reference in the c# source code behind file .cs file.
For your control's ID name use some meaning full nameing covention so that your code become more readable and easier to understand.It is very difficult to debug and maintain a program where the control names are TextBox1, Button1, and so forth.
So there are some prefixes appended with meaningful name for server control.
txt = TextBox (e.g. txtLastname)btn = Button (e.g. btnSavedata)ddl = DropDownList (e.g. ddlAccounts)chk = CheckBox (e.g. chkAdmin)rb = RadioButton (e.g. rbSpringsemester)

Event Handler Method !!

2009-02-19T04:38:00.000-08:00

Que : What is Event Handler Method ?

Ans : An event handler method is a special type of Method in an ASP.NET web page that defines the actions that will occur when a particular event occurs.

Example : Take an examle of event handler method, first take an event : click event. We saw that if you are int the Design view for a wev form and you double click on a Buttion control, Visual Web Developer or Visual Studio will automatically generate an event handler Method called Buttion_Click.Basically an empty method is generated and Visual Web Developer or Visual Studio lets you put what ever code you want into that event handler.

Que : What is the meaning the event driven model ?

Ans : ASP.NET uses an event driven programming model.This means that in order for code to run, an event must occur that triggers or tells ASP.NET to run an event handler Method.

Que : What is the naming convention of Event Handler Method ?

Ans : Notice the naming convention that Visual Web Developer when it generates the event handler Method. The first part of the name is the ID for the server control: Button1. The second part of the name an underscore appended with the event type: Click. This convention helps you as the developer know when that Method will be called by ASP.NET. In this case, the click event fires when a user single clicks on the Button control.

Code for Approve or Unapprove(Status) in the View Page

2009-01-19T21:07:00.000-08:00

Dev Palmistry

Code for Approve or Unapprove (Change the Status) in the View page .

1. In the GridView first we find DataRowBound

protected void GridDisplayCat_RowDataBound(object sender, GridViewRowEventArgs e)
{
{
if (e.Row.RowType == DataControlRowType.DataRow e.Row.RowType == DataControlRowType.Separator)
{

Label lblstatus = (Label)e.Row.Cells[1].FindControl("lblstatus");
Label lblid = (Label)e.Row.Cells[2].FindControl("lblid");
string status = lblstatus.Text.ToString();
string id = lblid.Text.ToString();
if (status.ToString() == "Yes")
{
e.Row.Cells[1].Text = "(a href=\"ProjectStatus.aspx?setStatus=No&um_id=" + id + "\")(font color=\"#008000\" face=\"Verdana\" size=\"2\")(img src=\"images/approved.gif\" border=\"0\" alt=\"Click here to Close\")(/font)(/a)";
}
else
{
e.Row.Cells[1].Text = "(a href=\"ProjectStatus.aspx?setStatus=Yes&um_id=" + id + "\")(font color=\"#CC3300\" face=\"Verdana\" )(img align=\"absmiddle\" src=\"images/unapprove.gif\" border=\"0\" alt=\"Click here to Open\")(/font)(/a)";
}
}
}
}

2. In the ProjectStatus.aspx.cs page , we use this page just use the Update the Status and after that page also Response.redirect to the View page....

string status = Request.QueryString["setStatus"].ToString();
string id = Request.QueryString["um_id"].ToString();
ocon.Open();
string str = "update Project_master set Project_status='" + status + "' where Project_id=" + id + "";
// SqlCommand updatecom = new SqlCommand(str, scon);
OleDbCommand ocom = new OleDbCommand(str, ocon);
ocom.ExecuteNonQuery();
Response.Redirect("ViewProject.aspx");

Code for Microsoft Access Database Connection

2009-01-19T20:56:00.000-08:00

Use this code for MS Access Database connectivity....

1. using System.Data.OleDb;

2. string FileDirectory = Server.MapPath("Database/admin.mdb");
OleDbConnection ocon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileDirectory.ToString() + "");

OleDbDataAdapter osap = new OleDbDataAdapter(str, ocon);

DataSet ds = new DataSet();
osap.Fill(ds, "temp");
GVProjectReports.DataSource = ds;
GVProjectReports.DataBind();