Hirpara Jigs Blogs

Difference between Singleton Class and Static Class

2017-01-17T21:13:00.001-08:00

Static Class:

You cannot create the instance of static class.
Loaded automatically by the .NET Framework common language runtime (CLR) when the program or namespace containing the class is loaded.
We cannot inherit Static class to another Static class in C#.
We cannot pass the static class to method.

Singleton:

You can create one instance of the object and reuse it.
Singleton instance is created for the first time when the user requested.
Singleton class can have constructor.
You can create the object of singleton class and pass it to method.
We can dispose the objects of a singleton class but not of static class.

Dynamic columns width in RDLC

2016-12-07T03:19:00.001-08:00

I am trying to generate a RDLC report in ASP.NET where the columns of my Dataset will be dynamic and determined only at run time.

public DataTable GetTable(int type)
        {
            DataTable table = new DataTable();
            if (type == 1)
            {
                table.Columns.Add("Dosage", typeof(int));
                table.Columns.Add("Drug", typeof(string));
                table.Columns.Add("Patient", typeof(string));
                table.Columns.Add("Date", typeof(DateTime));
                table.Columns.Add("testColumn", typeof(DateTime));

                // Here we add five DataRows.
                table.Rows.Add(25, "Indocin", "Jignesh", DateTime.Now);
                table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);
                table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
                table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
                table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);
            }
            else
            {
                table.Columns.Add("Dosage", typeof(int));
                table.Columns.Add("Patient", typeof(string));
                table.Columns.Add("Date", typeof(DateTime));

                // Here we add five DataRows.
                table.Rows.Add(25, "Jignesh", DateTime.Now);
                table.Rows.Add(50, "Sam", DateTime.Now);
                table.Rows.Add(10, "Christoff", DateTime.Now);
                table.Rows.Add(21, "Janet", DateTime.Now);
                table.Rows.Add(100, "Melanie", DateTime.Now);
            }

            return table;
        }

public ActionResult GenerateReportList()
        {
            var reportDataSource = new List();
            var localReport = new LocalReport();
            var path = GeLocCommon.ReportCommonPath + GeLocCommon.RightsReport;
            path = Server.MapPath(path + GeLocCommon.M02_details);
            if (System.IO.File.Exists(path))
            {
                localReport.ReportPath = path;
            }
            else
            {
                return RedirectToAction("Index");
            }

            var data = GetTable(1);
            reportDataSource.Add(new ReportDataSource
            {
                Name = GeLocCommon.RightsDetailDataSet,
                Value = data
            });

            localReport = localReport.LocalizeReport();
            var totalWidth = (float)7.215;
            totalWidth = totalWidth / data.Columns.Count;
            var resizedcolumns = "< TablixColumns >";
            for (int i = 0; i < data.Columns.Count; i++)
            {
                resizedcolumns = resizedcolumns + "< TablixColumn > < Width>" + totalWidth + "in</ Width>< /TablixColumn >";
            }

            for (int i = data.Columns.Count; i < 5; i++)
            {
                resizedcolumns = resizedcolumns + "< TablixColumn >< Width >0.1in</ Width >< /TablixColumn >";
            }

            resizedcolumns = resizedcolumns + "< /TablixColumns >";
            resizedcolumns = resizedcolumns.ToString().Replace(",", ".");
            var rptxml = System.IO.File.ReadAllText(path);
            var start = rptxml.IndexOf("< TablixColumns >");
            var end = rptxml.IndexOf("< /TablixColumns >") + " < / TablixColumns >".Length;
            rptxml = rptxml.Substring(0, start) + resizedcolumns + rptxml.Substring(end);
            System.IO.TextReader tr = new System.IO.StringReader(rptxml);
            localReport.LoadReportDefinition(tr);
            tr.Close();
            var downloadedFileName = GeLocCommon.RightsReportTemplate + 1 + GeLocCommon.SeperatorDash + DateTime.Now.ToString(GeLocCommon.ReportGeneratedDateFormat) + GeLocCommon.SeperatorDot + "pdf";
            string mimeType;
            return File(localReport.GenerateReport(ExportDataType.Pdf.ToString(), reportDataSource, null, out mimeType, false), mimeType, downloadedFileName);
        }

Export to excel using jquery for JQgrid

2016-04-28T04:41:00.001-07:00

step 1 :create ExportGridToExcel.ashx for open file

public class ExportGridToExcel : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            string tabData = context.Request["excelData"];

            DataTable dt = ConvertCsvData(tabData);
            if (dt == null)
            {
                return;
            }
            string excelFilename = context.Request["filename"];
            if (File.Exists(excelFilename))
                File.Delete(excelFilename);

            string FileName = CreateExcel.CreateExcelDocument(dt, excelFilename, context.Response); ;
            string FilePath = "ExcelFiles//" + FileName;



            context.Response.Clear();
            context.Response.Buffer = true;

            context.Response.AddHeader("content-disposition", string.Format("attechment; filename={0}", FileName));
            string strFilePath = context.Request.PhysicalApplicationPath + FilePath;
            string strExtension = System.IO.Path.GetExtension(strFilePath);
            if (strExtension.Equals(".xls", StringComparison.InvariantCulture) || strExtension.Equals(".csv", StringComparison.InvariantCulture) || strExtension.Equals(".xlsx", StringComparison.InvariantCulture))
            {
                context.Response.ContentType = "application/ms-excel";
            }
            else if (strExtension.Equals(".pdf", StringComparison.InvariantCulture))
            {
                context.Response.ContentType = "application/pdf";
            }

            context.Response.WriteFile(strFilePath);
            context.Response.End();

        }

        private DataTable ConvertCsvData(string CSVdata)
        {
            // Convert a tab-separated set of data into a DataTable, ready for our C# CreateExcelFile libraries
            // to turn into an Excel file.
            //
            DataTable dt = new DataTable();
            try
            {
                System.Diagnostics.Trace.WriteLine(CSVdata);

                string[] Lines = CSVdata.Split(new char[] { '\r', '\n' });
                if (Lines == null)
                    return dt;
                if (Lines.GetLength(0) == 0)
                    return dt;

                string[] HeaderText = Lines[0].Split('\t');

                int numOfColumns = HeaderText.Count();

                foreach (string header in HeaderText)
                    dt.Columns.Add(header, typeof(string));

                DataRow Row;
                for (int i = 1; i < Lines.GetLength(0); i++)
                {
                    string[] Fields = Lines[i].Split('\t');
                    if (Fields.GetLength(0) == numOfColumns)
                    {
                        Row = dt.NewRow();
                        for (int f = 0; f < numOfColumns; f++)
                        {
                            if (Fields[f] == "0")
                                Row[f] = "";
                            else
                                Row[f] = Fields[f].Replace("null", "");

                            Row[f] = Row[f].ToString().Replace("", "");
                            Row[f] = Row[f].ToString().Replace("
", ",");
                        }
                        dt.Rows.Add(Row);
                    }
                }

                return dt;
            }
            catch (Exception ex)
            {
                System.Diagnostics.Trace.WriteLine("An exception occurred: " + ex.Message);
                return null;
            }
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }

   public class CreateExcel
    {
        ///

/// Create an Excel file, and write it out to a MemoryStream (rather than directly to a file)
///

        /// DataTable containing the data to be written to the Excel.
        /// The filename (without a path) to call the new Excel file.
        /// HttpResponse of the current page.
        /// True if it was created succesfully, otherwise false.
        public static string CreateExcelDocument(DataTable dt, string filename, System.Web.HttpResponse Response)
        {
            try
            {

               return CreateExcelDocumentAsStream(dt, filename, Response);

            }
            catch (Exception ex)
            {

                return "";
            }
        }

        ///

/// Create an Excel file, and write it out to a MemoryStream (rather than directly to a file)
///

        /// DataSet containing the data to be written to the Excel.
        /// The filename (without a path) to call the new Excel file.
        /// HttpResponse of the current page.
        /// Either a MemoryStream, or NULL if something goes wrong.
        public static string CreateExcelDocumentAsStream(DataTable dt, string filename, System.Web.HttpResponse Response)
        {
            try
            {
                Random rnd = new Random();
                string _strFile = DateTime.Now.ToString("ddMMyyyy") + "_" + rnd.Next(0, 9999) + ".xlsx";
                FileInfo newFile = new FileInfo(HttpContext.Current.Server.MapPath("~/ExcelFiles/" + _strFile));
                if (newFile.Exists)
                {
                    newFile.Delete(); // ensures we create a new workbook
                    newFile = new FileInfo(_strFile);
                }

                ExcelPackage xlPackage = new ExcelPackage(newFile);
                ExcelWorksheet xlWorkSheet = xlPackage.Workbook.Worksheets.Add("DefaultFormat");
                int _RowID = 1;
                xlWorkSheet.Cells.Style.Numberformat.Format = "@";
                xlWorkSheet.Cells.Style.Numberformat.Format = "General";
                int _Cell = 1;
                for (int i = 1; i <= dt.Columns.Count; i++)
                {
                    xlWorkSheet.Cells[_RowID, _Cell].Value = dt.Columns[i - 1].ToString();
                    xlWorkSheet.Cells[_RowID, _Cell].Style.WrapText = true;
                    xlWorkSheet.Cells[_RowID, _Cell].Style.Font.Bold = true;
                    xlWorkSheet.Cells[_RowID, _Cell].Style.Border.Top.Style = ExcelBorderStyle.Thin;
                    xlWorkSheet.Cells[_RowID, _Cell].Style.Border.Left.Style = ExcelBorderStyle.Thin;
                    xlWorkSheet.Cells[_RowID, _Cell].Style.Border.Right.Style = ExcelBorderStyle.Thin;
                    xlWorkSheet.Cells[_RowID, _Cell].Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
                    xlWorkSheet.Cells[_RowID, _Cell].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
                    xlWorkSheet.Cells[_RowID, _Cell].Style.VerticalAlignment = ExcelVerticalAlignment.Center;
                    xlWorkSheet.Cells[_RowID, _Cell].Style.Numberformat.Format = "@";
                    xlWorkSheet.Cells[_RowID, _Cell].Style.Numberformat.Format = "General";
                    _Cell++;

                }
                _RowID++;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                     _Cell = 1;
                    for (int ji = 0; ji < dt.Columns.Count; ji++)
                    {
                        xlWorkSheet.Cells[_RowID, _Cell].Value = Convert.ToString(dt.Rows[i][ji]);
                        xlWorkSheet.Cells[_RowID, _Cell].Style.Border.Top.Style = ExcelBorderStyle.Thin;
                        xlWorkSheet.Cells[_RowID, _Cell].Style.Border.Left.Style = ExcelBorderStyle.Thin;
                        xlWorkSheet.Cells[_RowID, _Cell].Style.Border.Right.Style = ExcelBorderStyle.Thin;
                        xlWorkSheet.Cells[_RowID, _Cell].Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
                        xlWorkSheet.Cells[_RowID, _Cell].Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
                        xlWorkSheet.Cells[_RowID, _Cell].Style.VerticalAlignment = ExcelVerticalAlignment.Center;
                        xlWorkSheet.Cells[_RowID, _Cell].Style.Numberformat.Format = "@";
                        xlWorkSheet.Cells[_RowID, _Cell].Style.Numberformat.Format = "General";
                        _Cell++;
                    }
                    _RowID++;
                }
                xlWorkSheet.Cells.AutoFitColumns();
                xlPackage.Save();
                xlPackage.Dispose();
                return _strFile;
            }
            catch (Exception ex)
            {

                return "";
            }
        }

    }

Step 2 Js file

function ExportJQGridDataToExcel(tableCtrl, excelFilename) {
    // Export the data from our jqGrid into a (real !) Excel .xlsx file.
    //
    // We'll build up a (very large?) tab-separated string containing the data to be exported, then POST them
    // off to a .ashx handler, which creates the Excel file.
    debugger
    var allJQGridData = $(tableCtrl).jqGrid('getGridParam', 'data');

    var jqgridRowIDs = $(tableCtrl).getDataIDs();                // Fetch the RowIDs for this grid
    var headerData = $(tableCtrl).getRowData(jqgridRowIDs[0]);   // Fetch the list of "name" values in our colModel

    // For each visible column in our jqGrid, fetch it's Name, and it's Header-Text value
    var columnNames = new Array();       // The "name" values from our jqGrid colModel
    var columnHeaders = new Array();     // The Header-Text, from the jqGrid "colNames" section
    var inx = 0;
    var allColumnNames = $(tableCtrl).jqGrid('getGridParam', 'colNames');

    for (var headerValue in headerData) {
        // If this column ISN'T hidden, and DOES have a column-name, then we'll export its data to Excel.
        var isColumnHidden = $(tableCtrl).jqGrid("getColProp", headerValue).hidden;
        if (!isColumnHidden && headerValue != null) {
            columnNames.push(headerValue);
            columnHeaders.push(allColumnNames[inx]);
        }
        inx++;
    }

    // We now need to build up a (potentially very long) tab-separated string containing all of the data (and a header row)
    // which we'll want to export to Excel.

    // First, let's append the header row...
    var excelData = '';
    for (var k = 0; k < columnNames.length; k++) {
        excelData += columnHeaders[k] + "\t";
    }
    excelData = removeLastChar(excelData) + "\r\n";

    // ..then each row of data to be exported.
    var cellValue = '';
    for (i = 0; i < allJQGridData.length; i++) {

        var data = allJQGridData[i];

        for (var j = 0; j < columnNames.length; j++) {

            // Fetch one jqGrid cell's data, but make sure it's a string
            cellValue = '' + data[columnNames[j]];

            if (cellValue == null)
                excelData += "\t";
            else {
                if (cellValue.indexOf("a href") > -1) {
                    // Some of my cells have a jqGrid cell with a formatter in them, making them hyperlinks.
                    // We don't want to export the " " tags to our Excel file, just the cell's text.
                    cellValue = $(cellValue).text();
                }
                // Make sure we are able to POST data containing apostrophes in it
                cellValue = cellValue.replace(/'/g, "'");

                excelData += cellValue + "\t";
            }
        }
        excelData = removeLastChar(excelData) + "\r\n";
    }
    // Now, we need to POST our Excel Data to our .ashx file *and* redirect to the .ashx file.
    postAndRedirect("../../Handlers/ExportGridToExcel.ashx?filename=" + excelFilename, { excelData: excelData });
}

function removeLastChar(str) {
    // Remove the last character from a string
    return str.substring(0, str.length - 1);
}

function postAndRedirect(url, postData) {
    // Redirect to a URL, and POST some data to it.
    // Taken from:
    // http://stackoverflow.com/questions/8389646/send-post-data-on-redirect-with-javascript-jquery
    //
    var postFormStr = "
";

    var formElement = $(postFormStr);

    $('body').append(formElement);
    $(formElement).submit();
}

step 3 Add js code in jqgriid

   $("#jqTable").navButtonAdd('#jqTablePager', {
        title: "Export to Excel",
        buttonicon: "ace-icon fa fa-file-excel-o",
        caption: "",
        onClickButton: function () {
            ExportJQGridDataToExcel("#jqTable", "ExcelName.xlsx");
        },
        position: "last"
    });
if data not display in excel please set below property in JqGrid
loadonce: true,

Thanks

Upload document using Ajax call

2016-04-25T04:23:00.002-07:00

submitHandler: function (form) {
                var $form = $("#frmQuestion"), formData = new FormData(), params = $form.serializeArray();
                $.each(params, function (i, val) {
                    formData.append(val.name, val.value);
                });

                var files = $("input[Type='file']");
                for (var i = 0; i < files.length; i++) {
                    formData.append(files[i].name, $('#' + files[i].id).get(0).files[0]);
                             }


                $.ajax({
                    url: '/Questions/SaveQuestion',
                    data: formData,
                    cache: false,
                    contentType: false,
                    processData: false,
                    type: 'POST',
                    mimeType: "multipart/form-data",
                    beforeSend: function () { ShowCustomLoading(true); },
                    complete: function () { ShowCustomLoading(false); },
                    success: function (datas) {

                        var data = JSON.parse(datas)
                        if (data.Key == true) {
                            new PNotify({
                                text: data.Value,
                                delay: 1500,
                                type: 'success'
                            });
                            $("#divlist").show();
                            $("#divAdd").hide();
                            $("#jqTable").trigger('reloadGrid');
                        }
                        else {
                            new PNotify({
                                text: data.Value,
                                delay: 1500,
                                type: 'error'
                            });
                        }
                    }
                });
            }

Exporting to Word, Excel ,pdf and CSV

2012-05-03T01:54:00.001-07:00

In this article, I will explain how to export GridView to Word, Excel, PDF and CSV formats.

Exporting to Word, Excel and CSV can be easily achieved using ASP.Net without any third party tools, but for exporting GridView to PDF I am using iTextSharp which is a free library for exporting html to PDF.

To start with I have a GridView in which I am showing Customers records from the NorthWind Database.

The HTML markup of the GridView is as shown below

<asp:GridView ID="GridView1" runat="server"

AutoGenerateColumns = "false" Font-Names = "Arial"

Font-Size = "11pt" AlternatingRowStyle-BackColor = "#C2D69B"

HeaderStyle-BackColor = "green" AllowPaging ="true"

OnPageIndexChanging = "OnPaging" >

<asp:BoundField ItemStyle-Width = "150px" DataField = "CustomerID"

HeaderText = "CustomerID" />

<asp:BoundField ItemStyle-Width = "150px" DataField = "City"

HeaderText = "City"/>

<asp:BoundField ItemStyle-Width = "150px" DataField = "Country"

HeaderText = "Country"/>

<asp:BoundField ItemStyle-Width = "150px" DataField = "PostalCode"

HeaderText = "PostalCode"/>

Columns>

asp:GridView>

In the figure below the GridView is shown with four buttons

1. Export To Word

2. Export To Excel

3. Export To PDF

4. Export To CSV

Export to Microsoft Word Format

protected void btnExportWord_Click(object sender, EventArgs e)

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.doc");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-word ";

StringWriter sw= new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;

GridView1.DataBind();

GridView1.RenderControl(hw);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

}

VB.Net

Protected Sub btnExportWord_Click(ByVal sender As Object,

ByVal e As EventArgs)

Response.Clear()

Response.Buffer = True

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.doc")

Response.Charset = ""

Response.ContentType = "application/vnd.ms-word "

Dim sw As New StringWriter()

Dim hw As New HtmlTextWriter(sw)

GridView1.AllowPaging = False

GridView1.DataBind()

GridView1.RenderControl(hw)

Response.Output.Write(sw.ToString())

Response.Flush()

Response.End()

End Sub

The above function renders the GridView contents as Microsoft Word format. You will notice I have disabled paging before exporting, so that all the pages are exported.

The Output Exported File

Export to Microsoft Excel Format

For exporting the document to Excel if you do it directly as done in case of word the row background color is applied throughout to all the columns in the Excel Sheet hence in order to avoid it. I have done a workaround below.

First I am changing the background color of each row back to white.

Then I am applying the background color to each individual cell rather than the whole row. Thus when you export now you will notice that the formatting is applied only to the GridView cells and not all

Also I am applying textmode style class to all cells and then adding the style CSS class to the GridView before rendering it, this ensures that all the contents of GridView are rendered as text.

protected void btnExportExcel_Click(object sender, EventArgs e)

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;

GridView1.DataBind();

//Change the Header Row back to white color

GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");

//Apply style to Individual Cells

GridView1.HeaderRow.Cells[0].Style.Add("background-color", "green");

GridView1.HeaderRow.Cells[1].Style.Add("background-color", "green");

GridView1.HeaderRow.Cells[2].Style.Add("background-color", "green");

GridView1.HeaderRow.Cells[3].Style.Add("background-color", "green");

for (int i = 0; i < GridView1.Rows.Count;i++ )

{

GridViewRow row = GridView1.Rows[i];

//Change Color back to white

row.BackColor = System.Drawing.Color.White;

//Apply text style to each Row

row.Attributes.Add("class", "textmode");

//Apply style to Individual Cells of Alternating Row

if (i % 2 != 0)

{

row.Cells[0].Style.Add("background-color", "#C2D69B");

row.Cells[1].Style.Add("background-color", "#C2D69B");

row.Cells[2].Style.Add("background-color", "#C2D69B");

row.Cells[3].Style.Add("background-color", "#C2D69B");

}

GridView1.RenderControl(hw);

//style to format numbers to string

string style = @"";

Response.Write(style);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

}

VB.Net

Protected Sub btnExportExcel_Click(ByVal sender As Object,

ByVal e As EventArgs)

Response.Clear()

Response.Buffer = True

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.xls")

Response.Charset = ""

Response.ContentType = "application/vnd.ms-excel"

Dim sw As New StringWriter()

Dim hw As New HtmlTextWriter(sw)

GridView1.AllowPaging = False

GridView1.DataBind()

'Change the Header Row back to white color

GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF")

'Apply style to Individual Cells

GridView1.HeaderRow.Cells(0).Style.Add("background-color", "green")

GridView1.HeaderRow.Cells(1).Style.Add("background-color", "green")

GridView1.HeaderRow.Cells(2).Style.Add("background-color", "green")

GridView1.HeaderRow.Cells(3).Style.Add("background-color", "green")

For i As Integer = 0 To GridView1.Rows.Count - 1

Dim row As GridViewRow = GridView1.Rows(i)

'Change Color back to white

row.BackColor = System.Drawing.Color.White

'Apply text style to each Row

row.Attributes.Add("class", "textmode")

'Apply style to Individual Cells of Alternating Row

If i Mod 2 <> 0 Then

row.Cells(0).Style.Add("background-color", "#C2D69B")

row.Cells(1).Style.Add("background-color", "#C2D69B")

row.Cells(2).Style.Add("background-color", "#C2D69B")

row.Cells(3).Style.Add("background-color", "#C2D69B")

End If

GridView1.RenderControl(hw)

'style to format numbers to string

Dim style As String = ""

Response.Write(style)

Response.Output.Write(sw.ToString())

Response.Flush()

Response.End()

End Sub

The Output Exported File

Export to Portable Document Format

For exporting the GridView to PDF I am using the iTextSharp Library. You will need to Add Reference for the iTextSharp Library in your Website.

Then import the following Namespaces

using iTextSharp.text;

using iTextSharp.text.pdf;

using iTextSharp.text.html;

using iTextSharp.text.html.simpleparser;

VB.Net

Imports iTextSharp.text

Imports iTextSharp.text.pdf

Imports iTextSharp.text.html

Imports iTextSharp.text.html.simpleparser

By default the iTextSharp Library does not support background color of table cells or table rows

Hence when you render it as PDF your GridView is rendered without any formatting.

Recently I read an article on hamang.net where the author has provided the snippet to modify the iTextSharp so that it exports the HTML with background color.

For this tutorial, I have already modified the iTextSharp Library DLL so that the GridView is rendered with all the background color used. You can refer the code for exporting GridView to PDF below

protected void btnExportPDF_Click(object sender, EventArgs e)

{

Response.ContentType = "application/pdf";

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.pdf");

Response.Cache.SetCacheability(HttpCacheability.NoCache);

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;

GridView1.DataBind();

GridView1.RenderControl(hw);

StringReader sr = new StringReader(sw.ToString());

Document pdfDoc = new Document(PageSize.A4, 10f,10f,10f,0f);

HTMLWorker htmlparser = new HTMLWorker(pdfDoc);

PdfWriter.GetInstance(pdfDoc, Response.OutputStream);

pdfDoc.Open();

htmlparser.Parse(sr);

pdfDoc.Close();

Response.Write(pdfDoc);

Response.End();

}

VB.Net

Protected Sub btnExportPDF_Click(ByVal sender As Object,

ByVal e As EventArgs)

Response.ContentType = "application/pdf"

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.pdf")

Response.Cache.SetCacheability(HttpCacheability.NoCache)

Dim sw As New StringWriter()

Dim hw As New HtmlTextWriter(sw)

GridView1.AllowPaging = False

GridView1.DataBind()

GridView1.RenderControl(hw)

Dim sr As New StringReader(sw.ToString())

Dim pdfDoc As New Document(PageSize.A4, 10.0F, 10.0F, 10.0F, 0.0F)

Dim htmlparser As New HTMLWorker(pdfDoc)

PdfWriter.GetInstance(pdfDoc, Response.OutputStream)

pdfDoc.Open()

htmlparser.Parse(sr)

pdfDoc.Close()

Response.Write(pdfDoc)

Response.End()

End Sub

The Output Exported File

Export to Text/CSV

Finally comes exporting GridView to CSV or Text File delimited by a separator like comma.

To export the GridView as CSV, I am running a two for loops. While looping through the GridView columns and appending comma after each column and while looping through rows appending new line character. Refer the code below.

protected void btnExportCSV_Click(object sender, EventArgs e)

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.csv");

Response.Charset = "";

Response.ContentType = "application/text";

GridView1.AllowPaging = false;

GridView1.DataBind();

StringBuilder sb = new StringBuilder();

for (int k = 0; k < GridView1.Columns.Count; k++)

{

//add separator

sb.Append(GridView1.Columns[k].HeaderText + ',');

}

//append new line

sb.Append("\r\n");

for (int i = 0; i < GridView1.Rows.Count; i++)

{

for (int k = 0; k < GridView1.Columns.Count; k++)

{

//add separator

sb.Append(GridView1.Rows[i].Cells[k].Text + ',');

}

//append new line

sb.Append("\r\n");

}

Response.Output.Write(sb.ToString());

Response.Flush();

Response.End();

}

VB.Net

Protected Sub btnExportCSV_Click(ByVal sender As Object,

ByVal e As EventArgs)

Response.Clear()

Response.Buffer = True

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.csv")

Response.Charset = ""

Response.ContentType = "application/text"

GridView1.AllowPaging = False

GridView1.DataBind()

Dim sb As New StringBuilder()

For k As Integer = 0 To GridView1.Columns.Count - 1

'add separator

sb.Append(GridView1.Columns(k).HeaderText + ","c)

'append new line

sb.Append(vbCr & vbLf)

For i As Integer = 0 To GridView1.Rows.Count - 1

For k As Integer = 0 To GridView1.Columns.Count - 1

'add separator

sb.Append(GridView1.Rows(i).Cells(k).Text + ","c)

'append new line

sb.Append(vbCr & vbLf)

Response.Output.Write(sb.ToString())

Response.Flush()

Response.End()

End Sub

The Output Exported File

When you run the application first time and click export you might receive the following error

To avoid the error you will need to add this event which ensures that the GridView is Rendered before exporting.

public override void VerifyRenderingInServerForm(Control control)

{

/* Verifies that the control is rendered */

}

VB.Net

Public Overloads Overrides Sub VerifyRenderingInServerForm

(ByVal control As Control)

' Verifies that the control is rendered

End Sub

Currenct Convertor( Number to Word) Asp.Net (C#)

2012-04-09T06:19:00.004-07:00

1) Indian Ruppess

public string NumberToWord(Int32 number)
{

if (number == 0) return "Zero";

//if (number == -2147483648) return "Minus Two Hundred and Fourteen Crore Seventy Four Lakh Eighty Three Thousand Six Hundred and Forty Eight";

int[] num = new int[4];
int first = 0;
int u, h, t;

System.Text.StringBuilder sb = new System.Text.StringBuilder();

if (number < 0)
{

sb.Append("Minus ");
number = -number;
}

string[] words0 = { "", "One ", "Two ", "Three ", "Four ", "Five ", "Six ", "Seven ", "Eight ", "Nine " };

string[] words = { "Ten ", "Eleven ", "Twelve ", "Thirteen ", "Fourteen ", "Fifteen ", "Sixteen ", "Seventeen ", "Eighteen ", "Nineteen " };

string[] words2 = { "Twenty ", "Thirty ", "Forty ", "Fifty ", "Sixty ", "Seventy ", "Eighty ", "Ninety " };

string[] words3 = { "Thousand ", "Lakh ", "Crore " };
// { "", "thousand", "million", "billion", "trillion", "quadrillion", "quintillion" };

num[0] = number % 1000; // units

num[1] = number / 1000;

num[2] = number / 100000;

num[1] = num[1] - 100 * num[2];// thousands

num[3] = number / 10000000; // crores

num[2] = num[2] - 100 * num[3]; // lakhs

for (int i = 3; i > 0; i--)
{
if (num[i] != 0)
{
first = i;
break;
}
}

for (int i = first; i >= 0; i--)
{

if (num[i] == 0) continue;

u = num[i] % 10; // ones

t = num[i] / 10;

h = num[i] / 100; // hundreds

t = t - 10 * h; // tens

if (h > 0) sb.Append(words0[h] + "Hundred ");

if (u > 0 || t > 0)
{

if (h > 0 || i == 0) sb.Append("and ");

if (t == 0)

sb.Append(words0[u]);

else if (t == 1)

sb.Append(words[u]);

else

sb.Append(words2[t - 2] + words0[u]);

}

if (i != 0) sb.Append(words3[i - 1]);

}

return sb.ToString().TrimEnd();

}

2) Dollar and Euro

public string NumberToWords(string rawnumber)
{
int inputNum = 0;
int dig1, dig2, dig3, level = 0, lasttwo, threeDigits;
string dollars, cents;
try
{
string[] Splits = new string[2];
Splits = rawnumber.Split('.'); //notice that it is ' and not "
inputNum = Convert.ToInt32(Splits[0]);
dollars = "";
cents = Splits[1];
if (cents.Length == 1)
{
cents += "0"; // 12.5 is twelve and 50/100, not twelve and 5/100
}
}
catch
{
cents = "00";
inputNum = Convert.ToInt32(rawnumber);
dollars = "";
}

string x = "";

//they had zero for ones and tens but that gave ninety zero for 90
string[] ones = { "", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen" };
string[] tens = { "", "Ten", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety" };
string[] thou = { "", "Thousand", "Million", "Billion", "Trillion", "Quadrillion", "Quintillion" };

bool isNegative = false;
if (inputNum < 0)
{
isNegative = true;
inputNum *= -1;
}
if (inputNum == 0)
{
//return "zero and " + cents + "/100";
return "zero";
}

string s = inputNum.ToString();

while (s.Length > 0)
{
//Get the three rightmost characters
x = (s.Length < 3) ? s : s.Substring(s.Length - 3, 3);

// Separate the three digits
threeDigits = int.Parse(x);
lasttwo = threeDigits % 100;
dig1 = threeDigits / 100;
dig2 = lasttwo / 10;
dig3 = (threeDigits % 10);

// append a "thousand" where appropriate
if (level > 0 && dig1 + dig2 + dig3 > 0)
{
dollars = thou[level] + " " + dollars;
dollars = dollars.Trim();
}

// check that the last two digits is not a zero
if (lasttwo > 0)
{
if (lasttwo < 20)
{
// if less than 20, use "ones" only
dollars = ones[lasttwo] + " " + dollars;
}
else
{
// otherwise, use both "tens" and "ones" array
dollars = tens[dig2] + " " + ones[dig3] + " " + dollars;
}
if (s.Length < 3)
{
if (isNegative) { dollars = "negative " + dollars; }
//return dollars + " and " + cents + "/100";
return dollars ;
}
}

// if a hundreds part is there, translate it
if (dig1 > 0)
{
dollars = ones[dig1] + " hundred " + dollars;
s = (s.Length - 3) > 0 ? s.Substring(0, s.Length - 3) : "";
level++;
}
else
{
if (s.Length > 3)
{
s = s.Substring(0, s.Length - 3);
level++;
}
}
}

if (isNegative) { dollars = "negative " + dollars; }
//return dollars + " and " + cents + "/100";
return dollars ;

}

Using Stored Procedure(Sql Server)

Create Procedure NumberToWord
@Number AS BIGINT
AS
BEGIN
DECLARE @Digits INT
SET @Digits = @Number
IF (LEN(@Digits) > 4)
BEGIN
RAISERROR ('PLEASE ENTER WITH IN 4 DIGIT NUMBERS',12,-1)
END
ELSE IF (LEN(@Digits) <= 4)
BEGIN
DECLARE @NumWords TABLE(Number INT, Ones VARCHAR(15), Tens VARCHAR(15), Hundreds VARCHAR(15), Thousands VARCHAR(15))
INSERT INTO @NumWords
SELECT 0,'','','','' UNION ALL
SELECT 1,'ONE','TEN','ONE HUNDRED','ONE THOUSAND' UNION ALL
SELECT 2,'TWO','TWENTY','TWO HUNDRED','TWO THOUSAND' UNION ALL
SELECT 3,'THREE','THIRTY','THREE HUNDRED','THREE THOUSAND' UNION ALL
SELECT 4,'FOUR','FORTY','FOUR HUNDRED','FOUR THOUSAND' UNION ALL
SELECT 5,'FIVE','FIFTY','FIVE HUNDRED','FIVE THOUSAND' UNION ALL
SELECT 6,'SIX','SIXTY','SIX HUNDRED','SIX THOUSAND' UNION ALL
SELECT 7,'SEVEN','SEVENTY','SEVEN HUNDRED','SEVEN THOUSAND' UNION ALL
SELECT 8,'EIGHT','EIGHTY','EIGHT HUNDRED','EIGHT THOUSAND' UNION ALL
SELECT 9,'NINE','NINETY','NINE HUNDRED','NINETHOUSAND' UNION ALL
SELECT 10,'NINETEEN','','','' UNION ALL
SELECT 11,'ELEVEN','','','' UNION ALL
SELECT 12,'TWELVE','','','' UNION ALL
SELECT 13,'THIRTEEN','','','' UNION ALL
SELECT 14,'FOURTEEN','','','' UNION ALL
SELECT 15,'FIFTEEN','','','' UNION ALL
SELECT 16,'SIXTEEN','','','' UNION ALL
SELECT 17,'SEVENTEEN','','','' UNION ALL
SELECT 18,'EIGHTEEN','','','' UNION ALL
SELECT 19,'NINETEEN','','',''
SELECT RTRIM(MAX(CASE WHEN NUMBER = SUBSTRING(REVERSE(@Digits),4,1) THEN THOUSANDS ELSE '' END)) --FROM @NumWords
+SPACE(2)+ LTRIM(MAX(CASE WHEN NUMBER = SUBSTRING(REVERSE(@Digits),3,1) THEN HUNDREDS ELSE '' END) )
+SPACE(2)+ MAX(CASE WHEN RIGHT(@Digits,2) NOT BETWEEN 11 AND 19 AND NUMBER = SUBSTRING(REVERSE(@Digits),2,1) THEN TENS ELSE '' END)
+SPACE(2)+ MAX(CASE WHEN RIGHT(@Digits,2) NOT BETWEEN 11 AND 19 AND NUMBER = RIGHT(@Digits,1) THEN ONES
WHEN RIGHT(@Digits,2) BETWEEN 11 AND 19 AND NUMBER = RIGHT(@Digits,2) THEN ONES ELSE '' END)
As "Number to Words"
FROM @NUMWORDS
END
END
--EXEC NumberToWord 2010

Displaying multiple records in one row

2011-11-25T01:04:00.001-08:00

I have a table with values as follows:

SQL> SELECT deptno, ename FROM emp ORDER BY deptno, ename;

DEPTNO ENAME

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

10 CLARK

10 KING

10 MILLER

20 ADAMS

20 FORD

20 JONES

20 SCOTT

20 SMITH

30 ALLEN

30 BLAKE

30 JAMES

30 MARTIN

30 TURNER

30 WARD

14 rows selected.

but I need them in the following less convenient format:

DEPTNO ENAME

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

10 CLARK, KING, MILLER

20 ADAMS, FORD, JONES, SCOTT, SMITH

30 ALLEN, BLAKE, JAMES, MARTIN, TURNER, WARD

The following example illustrates the technique using the SCOTT demo table "emp":²

SELECT deptno

, LTRIM(SYS_CONNECT_BY_PATH(ename,','))

FROM ( SELECT deptno, ename

, ROW_NUMBER() OVER (PARTITION BY deptno ORDER BY ename) -1 AS seq

FROM emp )

WHERE connect_by_isleaf = 1

CONNECT BY seq = PRIOR seq +1 AND deptno = PRIOR deptno

START WITH seq = 1;

DEPTNO CONCATENATED

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

10 CLARK,KING,MILLER

20 ADAMS,FORD,JONES,SCOTT,SMITH

30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD

3 rows selected.

Another approach involves harnessing the dark power of XML:³

SELECT deptno

, RTRIM

( xmlagg (xmlelement (c, ename || ',') order by ename).extract ('//text()')

, ',' ) AS concatenated

FROM emp

GROUP BY deptno;

DEPTNO CONCATENATED

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

10 CLARK,KING,MILLER

20 ADAMS,FORD,JONES,SCOTT,SMITH

30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD

3 rows selected.

Differnce between .NET FrameWork

2011-11-11T22:15:00.000-08:00

.NET FrameWork 2. 0 Features:

• Generics

• Anonymous methods

• Partial class

• Nullable type

• The new API gives a fine grain control on the behavior of the runtime with regards to multithreading, memory allocation, assembly loading and more

• Full 64-bit support for both the x64 and the IA64 hardware platforms

• New personalization features for ASP.NET, such as support for themes, skins and webparts.

• .NET Micro Framework

• Data Tables

.NET Framework 3.0 Features:

Also called WinFX,includes a new set of managed code APIs that are an integral part of Windows Vista and Windows Server 2008 operating systems and provides

• Windows Communication Foundation (WCF) – formerly called Indigo; a service-oriented messaging system which allows programs to interoperate locally or remotely similar to web services

• Windows Presentation Foundation (WPF) - formerly called Avalon; a new user interface subsystem and API based on XML and vector graphics, which uses 3D computer graphics hardware and Direct3D technologies.

• Windows Workflow Foundation (WF) allows for building of task automation and integrated transactions using workflows.

• Windows CardSpace, formerly called InfoCard; a software component which securely stores a person’s digital identities and provides a unified interface for choosing the identity for a particular transaction, such as logging in to a website

.NET Framework 3.5 Features:

• Language Integrated Query (LINQ) for SQL, XML, Dataset, Object

• Addin system

• p2p base class

• Active directory

• ASP.NET Ajax

• Anonymous types with static type inference

• Paging support for ADO.NET

• ADO.NET synchronization API to synchronize local caches and server side data stores

• Asynchronous network I/O API

• Support for HTTP pipelining and syndication feeds.

• New System.CodeDom namespace

.NET Framework 4.0 Features:

• Common Language Runtime (CLR) – The following sections describe new features in security, parallel computing, performance and diagnostics, dynamic language runtime, and other CLR-related technologies

• Base Class Libraries

• Networking – Enhancements have been made that affect how integrated Windows authentication is handled by the HttpWebRequest, HttpListener, SmtpClient, SslStream, NegotiateStream, and related classes in the System.Net and related namespaces

• Web – The following sections describe new features in ASP.NET core services, Web Forms, Dynamic Data, and Visual Web Developer.

• Client – The following sections describe new features in Windows Presentation Foundation (WPF) and Managed Extensibility Framework (MEF).

• Data

• Communications – Windows Communication Foundation (WCF) provides the new features and enhancements described in the following sections.

• Workflow – Windows Workflow Foundation (WF) in .NET Framework 4.0 changes several development paradigms from earlier versions. Workflows are now easier to create, execute, and maintain.

data layer

2011-05-15T21:02:00.001-07:00

public Boolean ExecuteS1p(DataBO dbo)

{

Boolean flag = false;

DataConnection DC = new DataConnection(ConnString);

try

{

DC.OpenConnection();

DC.BegingTran();

DC.AppCommand.CommandType = CommandType.StoredProcedure;

DC.AppCommand.CommandText = "Sp_AppUsere1";

DC.AppCommand.Parameters.AddWithValue("@ActionID", dbo.ActionID1 );

DC.AppCommand.Parameters.AddWithValue("@Aref", dbo.Aref);

DC.AppCommand.Parameters.AddWithValue("@UserID", dbo.USerID1 );

DC.AppCommand.Parameters.AddWithValue("@Password", dbo.Password);

DC.AppCommand.Parameters.AddWithValue("@FirstName", dbo.FirstName );

DC.AppCommand.Parameters.AddWithValue("@LastName", dbo.LastName );

DC.AppCommand.Parameters.AddWithValue("@ImageData",dbo.Imagedata);

DC.AppDataAdapter.SelectCommand = DC.AppCommand;

DC.AppDataAdapter.Fill(DC.AppDataSet);

DC.CommitTran();

flag = true;

}

catch

{

DC.RollBackTran();

throw;

}

finally

{

DC.closeConnction();

}

return flag;

}

Regural Expression

2011-05-15T20:50:00.000-07:00

Pincode:

"\d{5}

Fro Number Only:

"^[0-9]+$"

Fro Date :mm/dd/yyyy or mm.dd.yyyy or mm-dd-yyyy

"(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d"

how to stored Images

2011-05-15T20:49:00.001-07:00

stored

byte[] imageBytes =(byte[]) Session["imgData"];

display

imageBytes = ((byte[])Session["imgData"]);

Response.BinaryWrite(imageBytes);

Inline Editing

2011-05-15T20:40:00.001-07:00

protected void GVEmployee_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

GridViewRow row;

row = GVEmployee.Rows[e.RowIndex];

Label Emp_code = row.FindControl("lblEMP_Code") as Label;

DropDownList Dept_Code= row.FindControl("DDLemp_CODE") as DropDownList;

TextBox Emp_Name = row.FindControl("txtIEmpName") as TextBox;

TextBox Address = row.FindControl("txtIAddress") as TextBox;

FileUpload image = row.FindControl("fuIIMage") as FileUpload;

Textbox Doj = row.FindControl("txtIDOJ") as Textbox;

Textbox Bdate = row.FindControl("txtIBDate") as Textbox;

txtNumber Phone = row.FindControl("txtIPhonw") as txtNumber;

DropDownList Status = row.FindControl("ddlIStatus") as DropDownList;

DropDownList Gender = row.FindControl("ddlIGender") as DropDownList;

DropDownList exp = row.FindControl("ddlIExp") as DropDownList;

TextBox NoofExp = row.FindControl("txtINOExp") as TextBox;

bl.EMP_Code = Emp_code.Text;

bl.DEP_Code = Dept_Code.SelectedValue;

bl.EMP_Name = Emp_Name.Text;

if (image.HasFile)

{

byte[] imageData = File.ReadAllBytes(image.FileName);

bl.IMage = imageData;

}

bl.Address = Address.Text;

bl.Doj = Doj.EmpDate;

bl.Doj = Bdate.EmpDate;

bl.Phone = Phone.NUmber;

bl.Status = Status.SelectedValue;

bl.Gender = Gender.SelectedValue;

if (exp.SelectedValue == "1")

{

bl.Exp = true;

}

else

{

bl.Exp = false;

}

if (NoofExp.Text != "")

{

bl.NOofexp = Convert.ToInt16(NoofExp.Text);

}

bl.update();

GVEmployee.EditIndex = -1;

bind();

}

protected void GVEmployee_RowEditing(object sender, GridViewEditEventArgs e)

{

GVEmployee.EditIndex = e.NewEditIndex;

bind();

}

protected void GVEmployee_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GVEmployee.EditIndex = -1;

bind();

}

protected void GVEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GVEmployee.PageIndex = e.NewPageIndex;

bind();

}

protected void GVEmployee_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string emp_code;

emp_code = GVEmployee.DataKeys[e.RowIndex].Value.ToString();

bl.EMP_Code = emp_code;

bl.Delete();

int i = bl.RET;

if (i == 1)

{

System.Windows.Forms.MessageBox.Show("Record Delete Successfully!", "Alert", System.Windows.Forms.MessageBoxButtons.OK);

}

if (i == 0)

{

System.Windows.Forms.MessageBox.Show("Record Delete Failed!", "Alert", System.Windows.Forms.MessageBoxButtons.OK);

}

bind();

}

protected void btnInsert_Click(object sender, EventArgs e)

{

TextBox Emp_code = GVEmployee.FooterRow.FindControl("txtEmpCode") as TextBox;

DropDownList Dept_Code = GVEmployee.FooterRow.FindControl("DDLIemp_CODE") as DropDownList;

TextBox Emp_Name = GVEmployee.FooterRow.FindControl("txtEmpName") as TextBox;

TextBox Address = GVEmployee.FooterRow.FindControl("txtAddress") as TextBox;

FileUpload image = GVEmployee.FooterRow.FindControl("fuIMage") as FileUpload;

Textbox Doj = GVEmployee.FooterRow.FindControl("txtDOJ") as Textbox;

Textbox Bdate = GVEmployee.FooterRow.FindControl("txtBDate") as Textbox;

txtNumber Phone = GVEmployee.FooterRow.FindControl("txtPhone") as txtNumber;

DropDownList Status = GVEmployee.FooterRow.FindControl("ddlStatus") as DropDownList;

DropDownList Gender = GVEmployee.FooterRow.FindControl("ddlGender") as DropDownList;

DropDownList exp = GVEmployee.FooterRow.FindControl("ddlExp") as DropDownList;

TextBox NoofExp = GVEmployee.FooterRow.FindControl("txtNOExp") as TextBox;

bl.EMP_Code = Emp_code.Text;

bl.DEP_Code = Dept_Code.SelectedValue;

bl.EMP_Name = Emp_Name.Text;

if (image.HasFile)

{

image.SaveAs(Server.MapPath("~/" + image.FileName));

byte[] imageData = File.ReadAllBytes(Server.MapPath("~/" + image.FileName));

bl.IMage =imageData;

}

bl.Address = Address.Text;

bl.Doj = Doj.EmpDate;

//if (Bdate.EmpDate == "")

//{

//}

bl.Bod = Bdate.EmpDate;

//if (Phone.NUmber != "")

//{

//}

bl.Phone = Phone.NUmber;

bl.Status = Status.SelectedValue;

bl.Gender = Gender.SelectedValue;

if (exp.SelectedValue == "1")

{

bl.Exp = true;

}

else

{

bl.Exp = false;

}

if (NoofExp.Text != "")

{

bl.NOofexp = Convert.ToInt16(NoofExp.Text);

}

bl.Insert();

int i;

i = bl.RET;

if (i == 2)

{

System.Windows.Forms.MessageBox.Show("Emp_code Already Exist","Warning", System.Windows.Forms.MessageBoxButtons.OK);

}

if (i == 0)

{

System.Windows.Forms.MessageBox.Show("Record Insert Successfully!", "Alert", System.Windows.Forms.MessageBoxButtons.OK);

}

if (i == 1)

{

System.Windows.Forms.MessageBox.Show("Record Insert Failed!", "Alert", System.Windows.Forms.MessageBoxButtons.OK);

}

bind();

}

DataConnection

2011-05-15T20:38:00.000-07:00

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.SqlClient;

using System.Data;

///

/// Summary description for DataConnection

///

public class DataConnection

{

public string ConString = "Data Source=devsvr1;Initial Catalog=EMPDB;User ID=Sa;Password=Password00";

public SqlConnection AppConnection = new SqlConnection();

public SqlDataAdapter AppDataAdapter = new SqlDataAdapter();

public SqlCommand AppCommand = new SqlCommand();

public DataSet AppDataSet = new DataSet();

public SqlTransaction AppTran;

public DataConnection(string Constr)

{

ConString = Constr;

}

public void OpenConnection()

{

try

{

AppConnection.ConnectionString = ConString;

AppConnection.Open();

AppCommand.Connection = AppConnection;

}

catch (SqlException Ex)

{

throw;

}

public void BegingTran()

{

AppTran = AppConnection.BeginTransaction(IsolationLevel.ReadCommitted);

AppCommand.Transaction = AppTran;

}

public void RollBackTran()

{ AppTran.Rollback(); }

public void CommitTran()

{

AppTran.Commit();

}

public void closeConnction()

{

AppConnection.Close();

}

IP Voice Trading System

2010-05-27T23:54:00.001-07:00

How can banks and financial institutions address demand for increased competitiveness, productivity and scalability on the global trading floor?

With the current market volatility, financial institutions are facing greater challenges to reduce operational costs and boost productivity. While they prepare and position themselves for the economic upturn, trading activity continues as firms rebalance their portfolio to invest in the right asset class and hedge themselves against the market volatility, which results in an increased transaction volume.

For this reason, the investment on technology in the trading room has become even more critical for firms wanting to improve efficiency and develop a competitive edge. Specifically in the area of trading floor optimisation, firms are exploring ways to standardise existing technology for more effective trader communication and to expand globally or regionally with minimal increase in cost.

A new trend has emerged among firms as they shift away from proprietary TDM voice technology and start building voice platforms using more pervasive IP networking technology, which is the common infrastructure for most financial institutions.