Dot Net Arcane: C#

Showing posts with label C#. Show all posts

Monday, 5 March 2012

SQL Connection

Connected Procedure : -

SqlConnection con = new SqlConnection("Pass the Connection String here");

SqlCommand com = new SqlCommand("select * from table3", con);

con.Open();

SqlDataReader dr = com.ExecuteReader();

GridView1.DataSource = dr;

GridView1.DataBind();

con.Close();

How to Send a Mail in Asp Dot Net

public partial class mailer : System.Web.UI.Page
{
MailMessage mailmsg;
SqlConnection con;
SqlCommand cmd;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["admin"] == null)
{
Response.Redirect("index.aspx");
}
//if (Request.QueryString["id"] != null)
//{
// txtToAddress.Text = Request.QueryString["id"];
//}
if(!IsPostBack)
{
String user = Session["admin"].ToString();
con = new SqlConnection(ConfigurationManager.ConnectionStrings["name"].ConnectionString);
con.Open();
cmd = new SqlCommand("select email from registration where username='" + user + "'",con );
SqlDataReader dr = cmd.ExecuteReader();
if(dr.Read())
{
txtFromAddress.Text = dr.GetString(0);
}
dr.Close();
}
}
protected void btnSendmail_Click(object sender, ImageClickEventArgs e)
{
try
{
String to = txtToAddress.Text;
String from = txtFromAddress.Text;
String cc = txtCCAddress.Text;
String bcc = txtBCC.Text;
String subject = txtSubject.Text;
String body = txtMessage.Text;
mailmsg = new MailMessage();
mailmsg.From =new MailAddress( from );
mailmsg.To.Add ( new MailAddress(to));
if ((cc != null) && (cc != string.Empty))
{
mailmsg.CC.Add(new MailAddress(cc));
}
if ((bcc != null) && (bcc != string.Empty))
{
mailmsg.Bcc.Add(new MailAddress(bcc));
}
mailmsg.Subject = subject;
mailmsg.Body = body;
if (fileAttachment.HasFile)
{
mailmsg.Attachments.Add(new Attachment(fileAttachment.PostedFile.FileName));
}
// Set the format of the mail message body as HTML
mailmsg.IsBodyHtml = true;
// Set the priority of the mail message to normal
mailmsg.Priority = MailPriority.Normal;
SmtpClient smtpclient = new SmtpClient();
smtpclient.Host = ConfigurationManager.AppSettings["hostname"];
smtpclient.Send(mailmsg);
}
catch (Exception ex)
{
lblmsg.Text = "Your mail has been sent..";
}
}
}

How to get IP address by Hostname from Domain name Server in C#

This code is in c# to retrieve IP address corresponding to any hostname from Domain name server

string hostname = http://www.dotnetspider.com/;

IPAddress[] addresslist = Dns.GetHostAddresses(hostname);

foreach (IPAddress theaddress in addresslist)

{

Response.Write(theaddress.ToString());

Response.Write("NewLine");

}

in the second response we have a line brake. age is not visible so i am placing "NewLine" there.

don't forget to use

using System.Net;

How To Use Image Map Control In Dot Net

ImageMap.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ImageMap.aspx.cs" Inherits="ImageMap" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>asp.net ImageMap: how to use</title>

</head>

<body>

<div>

<h2 style="color:Red">ImageMap</h2>

<asp:Label

ID="Label1"

runat="server"

Font-Size="Medium"

ForeColor="DodgerBlue"

</asp:Label>

<br />

<asp:ImageMap

ID="ImageMap1"

runat="server"

ImageUrl="~/Images/Doll.gif"

HotSpotMode="PostBack"

OnClick="ImageMap1_Click"

<asp:RectangleHotSpot

Top="0"

Bottom="360"

Left="0"

Right="180"

AlternateText="Green Doll"

PostBackValue="Green Doll"

<asp:RectangleHotSpot

Top="0"

Bottom="360"

Left="181"

Right="360"

AlternateText="Pink Doll"

PostBackValue="Pink Doll"

</asp:ImageMap>

</div>

</form>

</body>

</html>

ImageMap.aspx.cs

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 System.Xml.Linq;

public partial class ImageMap : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if(!Page.IsPostBack)

{

Label1.Text = "Click any doll!";

ImageMap1.BorderWidth = 3;

ImageMap1.BorderStyle = BorderStyle.Double;

ImageMap1.BorderColor = System.Drawing.Color.Crimson;

}

protected void ImageMap1_Click(object sender, ImageMapEventArgs e)

{

Label1.Text = "You ckecked: " + e.PostBackValue;

}

How to Compress the File using Dot Net Application

we are going to discuss about how to compress the file using asp.net application , ie: for compression there are some third party tools like CSharpZip (not sue about the name of the tools..) ,gzip, etc..

Asp.net has inbuilt with Compression ie: derive from the Class
using System.IO.Compression;
There are two compression derived from this namespace.
1) Gzipstream
2) Deflate stream
Deflate seems to be must faster than the Gzipstream but Deflate doesn't uncompress other formats , but Gzipstream decompress the other files like winzip, winrar .
Now we are going to see Gzipstream it has a class which contains filename and compression mode , Compression mode has two values Compress and Decompress.
Button_ClickEvent

CompressFile(Server.MapPath("~/Decompressed/FindEmai_onTextfile.txt"),;

Server.MapPath("~/Decompressed/FindEmai_onTextfile.zip"));

Here you have to give two parameter first one is Sourcefilename to be compressed , second is path where you have to place the compressed file. it will check if the file exists the compressed file has been placed there, else it will create on the fly.
Method definition

public static void CompressFile(string sourceFileName, string destinationFileName)

 FileStream outStream;

 FileStream inStream;

 //Check if the source file exist.

 if (File.Exists(sourceFileName))

 //Read teh input file

 //Check if the destination file exist else create once

 outStream = File.Open(destinationFileName, FileMode.OpenOrCreate);

 GZipStream zipStream = new GZipStream(outStream, CompressionMode.Compress);

 //Now create a byte array to hold the contents of the file

 byte[] fileContents = new byte[inStream.Length];

 //Read the contents to this byte array

 inStream.Read(fileContents, 0, fileContents.Length);

 zipStream.Write(fileContents, 0, fileContents.Length);

 //Now close all the streams.

 zipStream.Close();

 inStream.Close();

 outStream.Close();

How To Decompress File Using Dot Net Application

In previous post we seen how to compress the file this will helpful when the file is large you can
compress the file.

Now we will see how to Decompress the file
Button_Click event.

DecompressFile(Server.MapPath("~/Decompressed/FindEmai_onTextfile.zip"),Server.MapPath("~/Decompressed/FindEmai_onTextfile.txt"));

Here i just swap the filename so it may confuse so use some different path(Folder) or filename

Decompress Method

    public static void DecompressFile(string

    sourceFileName, string destinationFileName)

    FileStream outStream;

    FileStream inStream;

    //Check if the source file exist.

    if (File.Exists(sourceFileName))

    //Read teh input file

    inStream = File.OpenRead(sourceFileName);

    //Check if the destination file exist else create once

    outStream = File.Open(destinationFileName,

    FileMode.OpenOrCreate);

    //Now create a byte array to hold the contents of the

    file

    //Now increase the filecontent size more since the

    compressed file

    //size will always be less then the actuak file.

    byte[] fileContents = new byte[(inStream.Length *

    100)];

    //Read the file and decompress

    GZipStream zipStream = new GZipStream(inStream,

    CompressionMode.Decompress, false);

    //Read the contents to this byte array

    int totalBytesRead = zipStream.Read(fileContents, 0,

    fileContents.Length);

    outStream.Write(fileContents, 0, totalBytesRead);

    //Now close all the streams.

    zipStream.Close();

    inStream.Close();

    outStream.Close();