CREATE PROCEDURE [dbo].[USP_REQUEST_INSERT]
(
@XML_INFO NVARCHAR(MAX) = NULL
)
AS
BEGIN
SET NOCOUNT ON
BEGIN TRY
BEGIN TRANSACTION -- Start the transaction
---------------------------
DECLARE @REQUEST_XML INT
EXEC SP_XML_PREPAREDOCUMENT @REQUEST_XML OUTPUT, @XML_INFO
--1.------INSERT TO T_PROCUREMENT_HEADER--------
INSERT INTO T_EP_PROCUREMENT_HEADER(DOCNUM, IOR_NO, COST_CENTER, SIF_ENTITY_CODE, ESTABLISHMENT_ID, PURPOSE,CURRENCY,TOTAL_AMOUNT,TAX_AMOUNT,GROSS_AMOUNT, STATUS,APP_LEVEL, ENTERED_DATE, ENTERED_BY,REMARKS)
SELECT DOCNUM, IOR_NO, COST_CENTER,SIF_ENTITY_CODE, ESTABLISHMENT_ID, PURPOSE,CURRENCY,TOTAL_AMOUNT,TAX_AMOUNT,GROSS_AMOUNT,STATUS,
APP_LEVEL, getdate(), ENTERED_BY ,REMARKS
FROM OPENXML (@REQUEST_XML , '/EPROC/HEADER' , 1)
WITH
(
DOCNUM VARCHAR(22)'DOCNUM/text()' ,
IOR_NO VARCHAR(22)'IOR_NO/text()' ,
COST_CENTER VARCHAR(10)'COST_CENTER/text()' ,
SIF_ENTITY_CODE VARCHAR(10)'SIF_ENTITY_CODE/text()' ,
ESTABLISHMENT_ID VARCHAR(10)'ESTABLISHMENT_ID/text()' ,
PURPOSE VARCHAR(250)'PURPOSE/text()' ,
CURRENCY VARCHAR(10)'CURRENCY/text()' ,
TOTAL_AMOUNT VARCHAR(10)'TOTAL_AMOUNT/text()' ,
STATUS VARCHAR(15)'STATUS/text()' ,
APP_LEVEL VARCHAR(100)'APP_LEVEL/text()' ,
TAX_AMOUNT VARCHAR(10)'TAX_AMOUNT/text()' ,
GROSS_AMOUNT VARCHAR(10)'GROSS_AMOUNT/text()' ,
ENTERED_BY VARCHAR(10)'ENTERED_BY/text()' ,
REMARKS VARCHAR(250)'REMARKS/text()'
)
--2.-------------Insert to T_PROCUREMENT_DETAILS --------------
INSERT INTO T_EP_PROCUREMENT_DETAILS (DOCNUM,LINE_ITEM,TYPE,DESCRIPTION,EXP_CATEGORY,UOM,QUANTITY,UNIT_PRIZE,NET_AMOUNT)
SELECT DOCNUM, LINE_ITEM,TYPE,DESCRIPTION, EXP_CATEGORY, UOM, QUANTITY, UNIT_PRIZE,NET_AMOUNT
FROM
openxml(@REQUEST_XML, '/EPROC/DETAILS', 1) WITH
(
DOCNUM VARCHAR(10) 'DOCNUM /text()',
LINE_ITEM VARCHAR(9) 'LINE_ITEM /text()',
DESCRIPTION VARCHAR(150) 'DESCRIPTION /text()',
TYPE VARCHAR(10)'TYPE/text()' ,
EXP_CATEGORY VARCHAR(10)'EXP_CATEGORY/text()' ,
UOM VARCHAR(10) 'UOM /text()',
QUANTITY VARCHAR(15) 'QUANTITY/text()',
UNIT_PRIZE VARCHAR(15) 'UNIT_PRIZE/text()',
NET_AMOUNT VARCHAR(9) 'NET_AMOUNT/text()')
SELECT 'SUCCESS' AS OUTPUT
-- If we reach here , success!
COMMIT
END TRY
--END TRY--------------------------------------------------------------
BEGIN CATCH
-- Whoops , there was an error
IF @@TRANCOUNT > 0
ROLLBACK
-- Raise an error with the details of the exception
DECLARE @ErrMsg nvarchar(4000) , @ErrSeverity int
SELECT @ErrMsg = error_message()
, @ErrSeverity = error_severity()
RAISERROR(@ErrMsg , @ErrSeverity , 1)
END CATCH
SET NOCOUNT OFF
END
Thursday, 13 March 2014
Saturday, 8 March 2014
Linq Program
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
::LINQ PROGRAM::
Asp.Cs page (Linq Insert,Delete,Update)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
getdetails();
}
//Select Query
private void getdetails()
{
DataClassesDataContext cons = new DataClassesDataContext();
var cust = from custom in cons.customer_Headers
select new
{
custom.CustomerId,
custom.CustomerCode
};
gvlist.DataSource = cust;
gvlist.DataBind();
}
//Insert Query
protected void btnclick_Click(object sender, EventArgs e)
{
DataClassesDataContext cons = new DataClassesDataContext();
customer_Header sam = new customer_Header
{
CustomerCode = Convert.ToInt32(txtcustcode.Text),
CustomerId = txtcustid.Text
};
cons.customer_Headers.InsertOnSubmit(sam);
cons.SubmitChanges();
getdetails();
}
//Delete Query
protected void BtnDelete_Click(object sender, EventArgs e)
{
DataClassesDataContext cons = new DataClassesDataContext();
Int32 str = Convert.ToInt32(txtcustcode.Text);
customer_Header custs = (from cuss in cons.customer_Headers
where cuss.CustomerCode == (str)
select cuss).Single();
cons.customer_Headers.DeleteOnSubmit(custs);
cons.SubmitChanges();
getdetails();
}
//Update Query
protected void btnUpdate_Click(object sender, EventArgs e)
{
DataClassesDataContext cons = new DataClassesDataContext();
Int32 strs = Convert.ToInt32(txtcustcode.Text);
customer_Header custUp = (from cus in cons.customer_Headers where cus.CustomerCode == (strs) select cus).SingleOrDefault();
custUp.CustomerId = txtcustid.Text;
cons.SubmitChanges();
getdetails();
}
}
Wednesday, 5 March 2014
Connection String:
/b>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
namespace TierLayer
{
public class Connection
{
public static string StrConnSql;//For Sql
public SqlConnection GetConnection()
{
StrConnSql = ConfigurationManager.ConnectionStrings["Con"].ToString();
SqlConnection Connection = new SqlConnection(StrConnSql);
return Connection;
}
}
}
DAL
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace TierLayer
{
public class DataAccessLayer
{
Connection con = new Connection();
public int Insertdate(BusinessProperties Bp)
{
int rows = 0;
SqlConnection conn = new SqlConnection();
conn = con.GetConnection();
SqlCommand cmd = new SqlCommand("tire_demo", conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
if (cmd.Connection.State == ConnectionState.Closed)
{
cmd.Connection.Open();
}
cmd.Parameters.AddWithValue("@Names", Bp.Name);
cmd.Parameters.AddWithValue("@Mobileno", Bp.Mobileno);
rows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
rows = 0;
throw ex;
}
finally
{
if (cmd.Connection.State == ConnectionState.Open)
{
cmd.Connection.Close();
}
}
return rows;
}
}
}
BLL
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.IO;
namespace TierLayer
{
public class BusineeLogic
{
public int Insertdate1(BusinessProperties Bp)
{
DataAccessLayer DL = new DataAccessLayer();
try
{
return DL.Insertdate(Bp);
}
catch (Exception ex)
{
throw ex;
}
}
}
}
BEL
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace TierLayer
{
public class BusinessProperties
{
private string name;
public string Name
{
get { return name; }
set { name = value; }
}
private string mobileno;
public string Mobileno
{
get { return mobileno; }
set { mobileno = value; }
}
}
}
User Access Layer
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using TierLayer;
namespace _3tier_Arch
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnenter_Click(object sender, EventArgs e)
{
int rowss = 0;
BusinessProperties Bp = new BusinessProperties();
Bp.Name = txtname.Text;
Bp.Mobileno = txtmobile.Text;
BusineeLogic Bl = new BusineeLogic();
rowss= Bl.Insertdate1(Bp);
if (rowss.ToString()=="1")
{
ScriptManager.RegisterStartupScript(btnenter, btnenter.GetType(), "msg", "javascript:alert('Saved Successfully');", true);
}
}
}
}
User Access Layer
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="_3tier_Arch._Default" %>
3tier
Wednesday, 26 February 2014
Excel Column Name Change
private Table ExportAllData()
{
Table table = new Table();
TableRow row = null;
//DTVendorDetails = RPT_VITS_VendorDetails(Decrypt(Request.QueryString["Division"].ToString(), strSecurityCode), lblCompanyCode.Text.Trim(), Decrypt(Request.QueryString["Plant"].ToString(), strSecurityCode), txtVendorName.Text.Trim(), txtLogFrom.Text.Trim(), txtLogTo.Text.Trim(), txtBarCode.Text.Trim(), txtVendorNameUnknown.Text.Trim(), txtUser.Text.Trim(), txtPDOCNO.Text.Trim(), string.Empty, txtInvoiceNo.Text.Trim(), ddlStatus.SelectedValue.Trim());
string[] VendorCode = { string.Empty };
string[] companycode = lblCompanyCode.Text.Trim().Split('-');
string selVal = string.Empty;
for (int j = 0; j < cblCustomerList.Items.Count; j++)
{
if (cblCustomerList.Items[j].Selected)
{
selVal = selVal + "," + cblCustomerList.Items[j].Value.Trim();
}
}
if (txtVendorName.Text.Length > 0)
{
VendorCode = txtVendorName.Text.Trim().Split('-');
}
//if (txtUser.Text.Length > 0)
//{
// string[] sponsor = txtUser.Text.Trim().Split('-');
// DTVendorDetails = RPT_VITS_VendorDetails(Decrypt(Request.QueryString["Division"].ToString(), strSecurityCode), companycode[0].Trim(), Decrypt(Request.QueryString["Plant"].ToString(), strSecurityCode), VendorCode[0].ToString().Trim(), txtLogFrom.Text.Trim(), txtLogTo.Text.Trim(), txtBarCode.Text.Trim(), txtVendorNameUnknown.Text.Trim(), sponsor[0].ToString().Trim(), txtPDOCNO.Text.Trim(), string.Empty, txtInvoiceNo.Text.Trim(), selVal.Trim(), hdnLevel1.Value.Trim(), hdnLevel2.Value.Trim(), hdnLevel3.Value.Trim());
//}
//else
//{
// DTVendorDetails = RPT_VITS_VendorDetails(Decrypt(Request.QueryString["Division"].ToString(), strSecurityCode), companycode[0].Trim(), Decrypt(Request.QueryString["Plant"].ToString(), strSecurityCode), VendorCode[0].ToString().Trim(), txtLogFrom.Text.Trim(), txtLogTo.Text.Trim(), txtBarCode.Text.Trim(), txtVendorNameUnknown.Text.Trim(), txtUser.Text.Trim(), txtPDOCNO.Text.Trim(), string.Empty, txtInvoiceNo.Text.Trim(), selVal.Trim(), hdnLevel1.Value.Trim(), hdnLevel2.Value.Trim(), hdnLevel3.Value.Trim());
//}
objBll.Division = Decrypt(Request.QueryString["Division"].ToString(), strSecurityCode);
objBll.Company = companycode[0].Trim();
objBll.Plant = Decrypt(Request.QueryString["Plant"].ToString(), strSecurityCode);
objBll.Vendor_Code = VendorCode[0].ToString().Trim();
objBll.Log_From = txtLogFrom.Text.Trim();
objBll.Log_To = txtLogTo.Text.Trim();
objBll.Srlno = txtBarCode.Text.Trim();
objBll.Vendor_Name = txtVendorNameUnknown.Text.Trim();
objBll.User = txtUser.Text.Trim();
objBll.Pdno = txtPDOCNO.Text.Trim();
objBll.Invoice_No = txtInvoiceNo.Text.Trim();
objBll.Approved_By = "";
objBll.App_Status = selVal.Trim();
objBll.LevelCode1 = hdnLevel1.Value.Trim();
objBll.LevelCode2 = hdnLevel2.Value.Trim();
objBll.LevelCode3 = hdnLevel3.Value.Trim();
objBll.SGID = Session["SG_ID"].ToString();
DTVendorDetails = objBll.RPT_VITS_VendorDetails(objBll);
// Remove unwanted columns
DTVendorDetails.Columns.Remove("UNAME");
DTVendorDetails.Columns.Remove("SGTXT_VEN");
DTVendorDetails.Columns.Remove("BEWTP");
DTVendorDetails.Columns.Remove("XBLNR");
DTVendorDetails.Columns.Remove("APDSTAT");
DTVendorDetails.Columns.Remove("BILLTRACK");
DTVendorDetails.Columns.Remove("ZSABE");
DTVendorDetails.Columns.Remove("CHECT");
DTVendorDetails.Columns.Remove("EXPN");
DTVendorDetails.Columns.Remove("FNAME");
DTVendorDetails.Columns.Remove("URL");
DTVendorDetails.Columns.Remove("BUDAT");
DTVendorDetails.Columns.Remove("LOC");
DTVendorDetails.Columns.Remove("ROW_ID");
DTVendorDetails.Columns.Remove("SERVICE_ENTRY_DT");
DTVendorDetails.Columns.Remove("MYINFO_APPROVAL_DATE");
DTVendorDetails.Columns.Remove("PAYMENT_DATE");
DTVendorDetails.Columns.Remove("ITAD_INDEXNO");
DTVendorDetails.Columns.Remove("AUGDT");
DTVendorDetails.Columns.Remove("DELFLG");
DTVendorDetails.Columns.Remove("EXKEY");
//Add the Headers
row = new TableRow();
for (int j = 0; j < DTVendorDetails.Columns.Count; j++)
{
TableHeaderCell headerCell = new TableHeaderCell();
switch (DTVendorDetails.Columns[j].ColumnName)
{
case "MANDT":
headerCell.Text = "Division";
break;
case "BUKRS":
headerCell.Text = "Company Code";
break;
case "LOGSRL":
headerCell.Text = "Login Number";
break;
case "LIFNR":
headerCell.Text = "Vendor code";
break;
case "BELNR":
headerCell.Text = "Invoice Number";
break;
case "INVOICE_STATUS":
headerCell.Text = "Invoice Status";
break;
case "INVOICE_DESC":
headerCell.Text = "Material/Service";
break;
case "LOGDATE":
headerCell.Text = "Login Date";
break;
case "APNAM":
headerCell.Text = "User";
break;
case "CGRYFLG":
headerCell.Text = "Invoice Category";
break;
case "EBELN":
headerCell.Text = "Purchase Order";
break;
case "BELNR1":
headerCell.Text = "Invoice Number";
break;
case "DUEDAT":
headerCell.Text = "Due date";
break;
case "GTOTAL":
headerCell.Text = "Exces Duty";
break;
case "WODOC":
headerCell.Text = "Processing Document";
break;
case "INVDT":
headerCell.Text = "Invoice Date";
break;
case "LIFRE":
headerCell.Text = "Invoicing Party";
break;
case "TOTAL":
headerCell.Text = "Invoice Amount";
break;
case "GTOTAL1":
headerCell.Text = "Grand Total";
break;
case "WMWST":
headerCell.Text = "Service Tax";
break;
case "REMARKS":
headerCell.Text = "Remarks";
break;
case "BDC_FLG":
headerCell.Text = "Processing Invoice Status";
break;
case "AUGBL":
headerCell.Text = "Clearing Document";
break;
case "VENDET":
headerCell.Text = "Vendor Deatails";
break;
case "EXCEPTIONS":
headerCell.Text = "Exception";
break;
case "LOC":
headerCell.Text = "Location";
break;
case "BUDAT1":
headerCell.Text = "Logged Date";
break;
case "VENDORNAME":
headerCell.Text = "Vendor Name";
break;
case "INVPARTYNAME":
headerCell.Text = "Invoice Party Name";
break;
case "STATUS":
headerCell.Text = "Status";
break;
case "UTR_NO":
headerCell.Text = "UTR Number";
break;
case "UTR_DATE":
headerCell.Text = "UTR Date";
break;
}
headerCell.BackColor = System.Drawing.Color.FromName("#FFDD6F");
headerCell.ForeColor = System.Drawing.Color.FromName("#795E00");
row.Cells.Add(headerCell);
}
table.Rows.Add(row);
//Add the Column values
for (int i = 0; i < DTVendorDetails.Rows.Count; i++)
{
row = new TableRow();
for (int j = 0; j < DTVendorDetails.Columns.Count; j++)
{
TableCell cell = new TableCell();
cell.Text = DTVendorDetails.Rows[i][j].ToString();
row.Cells.Add(cell);
}
// Add the TableRow to the Table
table.Rows.Add(row);
}
return table;
}
Row DataBound Control
public void gvVendorDetails_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HiddenField hdnFlag = e.Row.FindControl("hdnFlag") as HiddenField;
HiddenField hdnAUGBL = e.Row.FindControl("hdnAugBl") as HiddenField;
HiddenField hdnAPDSTAT = e.Row.FindControl("hdnAPDSTAT") as HiddenField;
//Invoice Status
HiddenField hdnInv_Status = e.Row.FindControl("hdnInv_Status") as HiddenField;
//LinkButton lnkBarCode = e.Row.FindControl("lnkBarCode") as LinkButton;
Label lnkBarCode = e.Row.FindControl("lnkBarCode") as Label;
HiddenField hdnEXKEY = e.Row.FindControl("hdnExkey") as HiddenField;
Label lblEXKEY = e.Row.FindControl("lblPending") as Label;
// Commented by Jagan on 20121120
//Label lblWODOC = e.Row.FindControl("lblDocNo") as Label;
//Label lblAUGBL = e.Row.FindControl("lblClearing") as Label;
HiddenField hdnDelFlags = e.Row.FindControl("hdnDelFlag") as HiddenField;
HiddenField hdnProcessDoc = e.Row.FindControl("hdnProcessDoc") as HiddenField;
HiddenField hdnUrl = e.Row.FindControl("hdnUrl") as HiddenField;
HiddenField hdnVendorCode = e.Row.FindControl("hdnVendorCode") as HiddenField;
HiddenField hdnVendorDetails = e.Row.FindControl("hdnVendorDetails") as HiddenField;
HiddenField hdnVendorName = e.Row.FindControl("hdnVendorName") as HiddenField;
ImageButton imgbtnShowInvoice = e.Row.FindControl("imgbtnShowInvoice") as ImageButton;
ImageButton imgbtnShowPrevApproval = e.Row.FindControl("imgbtnShowPrevApproval") as ImageButton;
Label lblCategory = e.Row.FindControl("lblCategory") as Label;
string Path = string.Concat(hdnBarCode.Value.Trim(), hdnUrl.Value);
lnkBarCode.Attributes.Add("onclick", "return false;");
imgbtnShowInvoice.Attributes.Add("onclick", "return ShowInvoiceImage('" + Path + "','" + lnkBarCode.Text + "');");
imgbtnShowPrevApproval.Visible = false;
if (DTBarCode.Rows.Count > 0)
{
DataView dv = new DataView(DTBarCode);
dv.RowFilter = "ITAH_LOGSRLNO ='" + lnkBarCode.Text.Trim() + "'";
if (dv.Count > 0)
{
imgbtnShowPrevApproval.Visible = true;
}
else
{
imgbtnShowPrevApproval.Visible = false;
}
}
imgbtnShowPrevApproval.Attributes.Add("onclick", "return showPreviousApprovals('" + Encrypt(lnkBarCode.Text.Trim(), strSecurityCode) + "')");
Image imgStatus = e.Row.FindControl("imgStatus") as Image;
string VendorCode = hdnVendorCode.Value.Trim();
//DataRowView drv = (DataRowView)e.Row.DataItem;
if (tmpCategoryName != VendorCode)
{
tmpCategoryName = VendorCode;
// Get a reference to the current row's Parent, which is the Gridview (which happens to be a table)
Table tbl = e.Row.Parent as Table;
if (tbl != null)
{
GridViewRow row = new GridViewRow(-1, -1, DataControlRowType.DataRow, DataControlRowState.Normal);
TableCell cell = new TableCell();
// Span the row across all of the columns in the Gridview
cell.ColumnSpan = this.gvVendorDetails.Columns.Count;
cell.Width = Unit.Percentage(100);
cell.Height = Unit.Percentage(100);
cell.Style.Add("font-weight", "bold");
cell.Style.Add("background-color", "#DDFFDD");
cell.Style.Add("color", "#006C00");
HtmlGenericControl span = new HtmlGenericControl("span");
if (hdnVendorDetails.Value.Trim().Length > 0)
{
span.InnerHtml = hdnVendorCode.Value.Trim() + " - " + hdnVendorDetails.Value.Trim();
}
else
{
span.InnerHtml = hdnVendorCode.Value.Trim() + " - " + hdnVendorName.Value.Trim();
}
cell.Controls.Add(span);
row.Cells.Add(cell);
tbl.Rows.AddAt(tbl.Rows.Count - 1, row);
}
}
if (hdnInv_Status.Value.Trim().ToUpper().Equals("INVOICE RECEIVED."))
{
imgStatus.ImageUrl = "Images/invoice_receive.png";
imgStatus.ToolTip = "Invoice Received.";
}
else if (hdnInv_Status.Value.Trim().ToUpper().Equals("PENDING FOR USER/SPONSOR APPROVAL."))
{
imgStatus.ImageUrl = "Images/user-sponsor.png";
imgStatus.ToolTip = "Pending for User/Sponsor Approval.";
}
else if (hdnInv_Status.Value.Trim().ToUpper().Equals("PENDING FOR CLARIFICATION."))
{
imgStatus.ImageUrl = "Images/user-reject.png";
imgStatus.ToolTip = "Pending for Clarification.";
}
else if (hdnInv_Status.Value.Trim().ToUpper().Equals("WAITING FOR INVOICE PROCESSING."))
{
imgStatus.ImageUrl = "Images/Pending-Process.png";
imgStatus.ToolTip = "Waiting for Invoice Processing.";
}
else if (hdnInv_Status.Value.Trim().ToUpper().Equals("INVOICE PROCESSED, WAITING FOR PAYMENT."))
{
imgStatus.ImageUrl = "Images/Process-Completes.png";
imgStatus.ToolTip = "Invoice Processed, Waiting for Payment.";
}
else if (hdnInv_Status.Value.Trim().ToUpper().Equals("INVOICE PAID."))
{
imgStatus.ImageUrl = "Images/paid.png";
imgStatus.ToolTip = "Invoice Paid.";
}
else if (hdnInv_Status.Value.Trim().ToUpper().Equals("INVOICE PROCESSED, NOT DUE FOR PAYMENT."))
{
imgStatus.ImageUrl = "Images/clock_red.png";
imgStatus.ToolTip = "Invoice Processed, Not Due for Payment.";
}
else if (hdnInv_Status.Value.Trim().ToUpper().Equals("INVOICE REJECTED BY SGGI."))
{
imgStatus.ImageUrl = "Images/invoice-delete.png";
imgStatus.ToolTip = "Invoice Rejected By SGGI.";
}
else
{
imgStatus.ImageUrl = "Images/empty.png";
imgStatus.ToolTip = "";
}
if (hdnDelFlags.Value.Trim().ToString().Equals("X"))
{
imgStatus.ImageUrl = "Images/invoice-delete.png";
imgStatus.ToolTip = "Invoice Delete.";
}
e.Row.Cells[8].Attributes.Add("style", "cursor:hand");
e.Row.Cells[8].Attributes.Add("onclick", "return ShowImageDescription()");
}
}
Excel Download Option
public override void VerifyRenderingInServerForm(Control control)
{
return;
}
// Upload grid to excel
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Traceinvoicestatus.xls");
string style = @"