C#, ASP.Net, SQL Server Development

HOW TO CHECK USER DISCONNECTION IN VISUAL WEB GUI

2011-10-15T02:40:00.001-07:00

In a Visual Web GUI application sometimes it is required to know, if user connected or not.

Disconnection can be occurred due to several reasons i.e.

1. Enters another URL and navigates away.

2. Closes the browser window.

3. Refreshes the page. ( Sessions reset sometimes)

Following code snippet will show you the event that can be implemented to check such behaviours:

using System;

using Gizmox.WebGUI.Forms;

namespace Test

{

public partial class Index : Form

{

public Index()

{

InitializeComponent();

//This event is used for checking disconnection

Application.ThreadSuspend += new EventHandler(Application_ThreadSuspend);

}

void Application_ThreadSuspend(object sender, EventArgs e)

{

// TODO: Add Code to do the tasks after disconnection

}

HOW TO SEND A CRYSTAL REPORT DOCUMENT AS PDF DOCUMENT VIA EMAIL

2010-07-24T04:52:00.000-07:00

This code snippet describes how to send Crystal Reports via Email Programmatically

using System;

using System.Net;

using System.Net.Mail;

using System.Windows.Forms;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.Shared;

namespace CSharpDeveloper.Core

{

public class CrystalReportHelperClass

{

public void SendEmail(string emailId, string subject, string body, ReportDocument rpt, string fileName)

{

try

{

MailMessage mm = new MailMessage();

mm.From = new MailAddress("xyz@example.com", "From Name");

mm.To.Add(new MailAddress(emailId, "To Name"));

mm.Subject = subject;

mm.Body = body;

mm.Attachments.Add(

new Attachment(rpt.ExportToStream(ExportFormatType.PortableDocFormat), fileName)

);

SmtpClient sc = new SmtpClient("smtp.example.com");

sc.Credentials = new NetworkCredential("xyz@example.com", "********");

sc.Send(mm);

MessageBox.Show("Email successfully sent to " + emailId);

}

catch (Exception e)

{

if (

MessageBox.Show("Unable to send email to "

+ emailId + " due to following error:\n\n"

+ e.Message, "Email send error"

, MessageBoxButtons.RetryCancel, MessageBoxIcon.Error)

== DialogResult.Retry

)

{

this.SendEmail(emailId, subject, body, rpt, fileName);

}

HOW TO SHOW A CRYSTAL REPORT WITHOUT USING ODBC DATA SOURCE

2010-07-24T04:26:00.000-07:00

* This code demonstrates how to show a crystal report without using odbc data source.

* It requires connection string to display report.

* Crystal report should be made using OLE-DB Data provider.

* Drag the crystal report viewer on form and you may set its dock property to fill.

using System;

using System.Data.SqlClient;

using System.Windows.Forms;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.Shared;

namespace CSharpDeveloper.Core

{

public partial class FrmReportView : Form

{

public FrmReportView()

{

InitializeComponent();

this.crystalReportViewer1.ReportSource = null;

}

public FrmReportView(

ParameterFields rptParams, ReportDocument rpt, string connectionString)

: this()

{

try

{

this.Text = rpt.FileName;

if (rptParams != null)

{

this.crystalReportViewer1.ParameterFieldInfo = rptParams;

}

//Load report from its location

rpt.Load(rpt.FileName);

//Set report on report viewer

this.crystalReportViewer1.ReportSource = rpt;

SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder(connectionString);

rpt.SetDatabaseLogon(

sb.UserID, sb.Password, sb.DataSource, sb.InitialCatalog, true);

//Extract connection info from connection string

ConnectionInfo ci = new ConnectionInfo();

ci.ServerName = sb.DataSource;

ci.DatabaseName = sb.InitialCatalog;

ci.UserID = sb.UserID;

ci.Password = sb.Password;

//Create TableLogOnInfo object and set connection info

TableLogOnInfo tli = new TableLogOnInfo();

tli.ConnectionInfo = ci;

//Apply log on info to each table of report

foreach (Table table in rpt.Database.Tables)

{

table.ApplyLogOnInfo(tli);

}

catch (Exception e)

{

MessageBox.Show(e.Message);

}

HOW TO CALL A STORED PROCEDURE USING ENTITY SPACES ESUTILITY CLASS

2010-07-23T23:55:00.000-07:00

Following code sample demonstrated how to call a stored procedure using entity spaces esUtility class, return output parameters from it and display those output parameters in a message box.

Simple stored procedure:

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

ALTER PROCEDURE spTest

@p1 int = 0,

@p2 int = 0 OUTPUT

BEGIN

SET NOCOUNT ON;

SET @p2 = @p1 * 10000;

END

Simple function in c#:

private void SPTest()

{

try

{

esUtility es = new esUtility();

//No need to use @ sign

esParameter p1 = new esParameter("p1", 25, esParameterDirection.Input, DbType.Int32, 0);

esParameter p2 = new esParameter("p2", esParameterDirection.Output, DbType.Int32, 0);

esParameters parameters = new esParameters();

parameters.Add(p1);

parameters.Add(p2);

es.ExecuteNonQuery(EntitySpaces.Interfaces.esQueryType.StoredProcedure, "spTest", parameters);

MessageBox.Show(p2.Value.ToString());

}

catch (Exception e)

{

MessageBox.Show(e.Message);

}