Share ur Knowledge with others

Export SQl Data into PDF with image

Mon, 10 Oct 2011 19:40:00 +0000

Add Reference the ItextSharp.dll file for creating PDF File

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.pdf.events;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Web.UI.HtmlControls;
using System.Web.Security;
using iTextSharp.text.html;
using iTextSharp.text.html.simpleparser;

public partial class _Default : System.Web.UI.Page
{
    DataSet ds = new DataSet();
    DataTable dt = new DataTable();
    SqlConnection cn = new SqlConnection("Data Source=Servername;Initial Catalog=Databasename;Integrated security=True");
    protected void Page_Load(object sender, EventArgs e)
    {

        cn.Open();
        SqlCommand cd = new SqlCommand("select * from table_name", cn);

        SqlDataAdapter da = new SqlDataAdapter(cd);
        da.Fill(dt);
        //ExportDaataSetTopdf(ds."report");

        Document document = new Document(PageSize.A4, 50, 50, 150, 50);

        // Create a new PdfWrite object, writing the output to the file ~/PDFTemplate/Report.pdf
        FileStream output = new FileStream(Server.MapPath("~/PDFTemplate/Report.pdf"), FileMode.Create);
        PdfWriter writer = PdfWriter.GetInstance(document, output);

        // Open the Document for writing
        document.Open();
        iTextSharp.text.Image logo = iTextSharp.text.Image.GetInstance(Server.MapPath("~/logo.jpg"));
        logo.SetAbsolutePosition(350, 730);
        document.Add(logo);
        if (dt != null)
        {

            PdfPTable PdfTable = new PdfPTable(dt.Columns.Count);
            PdfPCell PdfPCell = null;

            for (int rows = 0; rows < dt.Rows.Count; rows++)
            {
                if (rows == 0)
                {
                    for (int column = 0; column < dt.Columns.Count; column++)
                    {
                        PdfPCell = new PdfPCell(new Phrase(dt.Columns[column].ColumnName.ToString()));
                        PdfTable.AddCell(PdfPCell);
                    }
                }
                for (int column = 0; column < dt.Columns.Count; column++)
                {
                    PdfPCell = new PdfPCell(new Phrase(dt.Rows[rows][column].ToString()));
                    PdfTable.AddCell(PdfPCell);
                }
            }

            // Finally Add pdf table to the PDF document
            document.Add(PdfTable);
        }
        document.Close();
        cn.Close();
    }
}

Export SQl Data Table into Excel,CSV with image Header

Mon, 10 Oct 2011 19:38:00 +0000

using System;

using System.Configuration;

using System.Security;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Text;

using System.Collections;

using System.IO;

using System.Data;

using System.Data.OleDb;

using System.Windows.Forms;

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

{

#region variable

SqlConnection connection = new SqlConnection("Data Source=servername;Initial Catalog=Databasename;Integrated Security=True");

public int j;

ArrayList list = new ArrayList();

public static int column_count = 65;

int column_total;

int k;

OleDbConnection MyConnection;

#endregion

/*------------- Insert Data into Excel -------------------------*/

public void insert_data()

{

MyConnection = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; Data Source='c://test.xls';Extended Properties=Excel 8.0;");

SqlCommand sql_cmd = new SqlCommand("select * from table_name",connection);

SqlDataReader dr = sql_cmd.ExecuteReader();

while (dr.Read())

{

string sno = dr["Sno"].ToString();

string name = dr["Name"].ToString();

string address = dr["Address"].ToString();

string grade = dr["Grade"].ToString();

string salary = dr["Salary"].ToString();

MyConnection.Open();

string sql = "insert into [Sheet1$] (Sno,Name,Address,Grade,Salary) values('"+sno+"','"+name+"','"+address+"','"+grade+"','"+salary+"')";

OleDbCommand cmd = new OleDbCommand(sql, MyConnection);

cmd.ExecuteNonQuery();

MyConnection.Close();

}

/*------------- End of Method -------------------------*/

/* This Method used to read column names from table*/

public void fetch_column_name()

{

connection.Open();

SqlCommand cmd = new SqlCommand("select column_name from information_schema.columns where table_name='table_name'", connection);

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())

{

list.Add(dr["column_name"]);

}

connection.Close();

}

public void insert_excel_image()

{

fetch_column_name();

Excel.Application app;

Excel.Workbook Excel_Book;

Excel.Worksheet Excel_sheet;

Excel.Range range;

object mis_value = System.Reflection.Missing.Value;

app = new Excel.ApplicationClass();

Excel_Book = app.Workbooks.Add(mis_value);

Excel_sheet = (Excel.Worksheet)Excel_Book.Worksheets.get_Item(1);

Excel_sheet.Shapes.AddPicture(Server.MapPath("logo.jpg"), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 50, 50, 100, 100);

column_total = column_count + list.Count;

/* --------------- Creating Header----------------------*/

for (column_count = 65; column_count <= column_total; column_count++)

{

char c = Convert.ToChar(column_count);

string s = c + "20";

range = Excel_sheet.get_Range(s, mis_value);

if (j < list.Count)

{

range.Value2 = list[j].ToString();

j++;

}

/* ----------------- End of Header -------------------------*/

/*-----------------------------------------------------------*/

DataTable dt = new DataTable();

//insert_excel_image();

connection.Open();

SqlCommand cmd = new SqlCommand("select * from table_name", connection);

SqlDataAdapter dr = new SqlDataAdapter(cmd);

dr.Fill(dt);

/*------------------------------------------------------------*/

/*-------------------- Insert Image into Excel-----------------------*/

Excel_Book.SaveAs("C:/test.xls", Excel.XlFileFormat.xlWorkbookNormal, mis_value, mis_value, mis_value, mis_value, Excel.XlSaveAsAccessMode.xlExclusive, mis_value, mis_value, mis_value, mis_value, mis_value);

Excel_Book.Close(true, mis_value, mis_value);

app.Quit();

insert_data();

/*-------------------- End of Process -----------------------*/

}

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button2_Click1(object sender, EventArgs e)

{

insert_excel_image(); //Using to insert data into Excel.

}

Tue, 04 Oct 2011 19:28:00 +0000

Add image in Excel sheet using c#

Excel.Application app;
        Excel.Workbook Excel_Book;
        Excel.Worksheet Excel_sheet;
        object mis_value = System.Reflection.Missing.Value;
        app=new Excel.ApplicationClass();
        Excel_Book = app.Workbooks.Add(mis_value);
        Excel_sheet = (Excel.Worksheet)Excel_Book.Worksheets.get_Item(1);
        Excel_sheet.Shapes.AddPicture(Server.MapPath("1.bmp"), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 50, 50, 300, 500);
        Excel_Book.SaveAs("test.xls", Excel.XlFileFormat.xlWorkbookNormal, mis_value, mis_value, mis_value, mis_value, Excel.XlSaveAsAccessMode.xlExclusive, mis_value, mis_value, mis_value, mis_value, mis_value);
        Excel_Book.Close(true, mis_value , mis_value );
        app.Quit();

Coding For Insert,Update,Delete,select from Sql Server table using Linq to Sql

Tue, 04 Oct 2011 14:47:00 +0000

Steps for add sql Table into the project before going for Code

1. Add LinQ to Sql classes file into the project file.
2.select the design page, and drag the tables from the DataBase Explorer Window to the design page.If you place more than one table with the relationship,the page will automatically show the relationship diagram of the selected table.

Note:

"    DataClassesDataContext " is the name of LinQ to Sql classes file.

/* Insert data into sql server table using Linq to SQl */

        DataClassesDataContext insert_content = new DataClassesDataContext();
        test Insert_data = new test();
        Insert_data.num = int.Parse(TextBox1.Text);
        Insert_data.test_name = TextBox2.Text.ToString();
        insert_content.tests.InsertOnSubmit(Insert_data);
        insert_content.SubmitChanges();

/*-------------------- End Here --------------------------*/

/* Update data into Table using Linq to sql */

        DataClassesDataContext Update_table = new DataClassesDataContext();
        string num = TextBox1.Text;
        test Update = (from Up_data in Update_table.tests
                      where Up_data.num == int.Parse(num)
                      select Up_data).Single();
        Update.test_name = TextBox2.Text.ToString();
        Update_table.SubmitChanges();

/*-------------------- End Here --------------------------*/

/* Delete data from Sql server table using Linq to Sql */

        DataClassesDataContext context = new DataClassesDataContext();
        string num = null;
        num = TextBox1.Text.ToString();
        test delete_data = (from test_data in context.tests
                                    where test_data.num == int.Parse(num)
                                     select test_data).Single();
        context.tests.DeleteOnSubmit(delete_data);
        context.SubmitChanges();

/*-------------------- End Here --------------------------*/

/* Select data from sql server using Linq to Sql*/

        DataClassesDataContext context = new DataClassesDataContext();

            var name = from name_values in context.tests where
name_values.test_name.Contains(TextBox1.Text.ToString())
                              select name_values;
            GridView2.DataSource = name;
            GridView2.DataBind();

/*-------------------- End Here --------------------------*/

Query for selecting first 3 rows from the table

Tue, 05 Jul 2011 17:13:00 +0000

set rowcount 3
delete fromexcel
set rowcount 0
select * from excel

The above query retrieve and show first 3 rows of records from the table,The set rowcount=0 stop the process suddenly and help to show only 3 rows.

store procedure for searching particlaur table all the table have a access rights from the SQL Server

Mon, 25 Apr 2011 21:37:00 +0000

create Procedure Sp_CTSI_internal
@start_date nvarchar(50),
@end_date nvarchar(50)
as
declare @count_database int
declare @inc_count int
declare @name_database nvarchar(4000)
declare @sql_query nvarchar(4000)
declare @table_name nvarchar(4000)
declare @report_path nvarchar(4000)
declare @get_query nvarchar(4000)
declare @query nvarchar(4000)
--declaration end

EXEC('Create table internal_ctsi_result(Custno nvarchar(100),Total_Count int,Database_Name nvarchar(1000))')
--initialize the value for the varibales
set @inc_count=5
set @table_name='[master].[CTSI\Vijay].internal_ctsi_result'
select @count_database=count(dbid) from sql4.master.dbo.sysdatabases

--End of Initialization

while(@inc_count<=@count_database)
begin
select @name_database=name from sql4.master.dbo.sysdatabases where dbid=@inc_count and ISNULL(HAS_DBACCESS ([Name]),0)=1 order by [Name]
if exists(select top 1 name from sql4.master.dbo.sysdatabases where dbid=@inc_count and ISNULL(HAS_DBACCESS ([Name]),0)=1 order by [Name])
begin

--begin exec
exec('
declare @sql nvarchar(4000)
declare @sql_query nvarchar(4000)
use '+@name_database+'
if exists(select TOP 1 table_name from information_schema.tables where table_catalog='''+@name_database+''' and table_name=''shipment'' and table_type=''base table'')
begin
--print ''tables Exists in the Database :''+'''+@name_database +'''
if exists(select top 1 column_name from information_schema.columns where table_catalog='''+@name_database+''' and table_name=''shipment'' and column_name=''entdate'')
begin
set @sql=''insert into '+@table_name+'(Custno,Total_Count,Database_Name) select custno,count(*)as Total_count,'''''+@name_database+''''' from sql4.'+@name_database+'.dbo.shipment where entdate between ''''1/1/2010'''' and ''''12/31/2010'''' group by custno''
exec(@sql)
print @sql
end
end
')
--end exec

end
set @inc_count=@inc_count+1
end
exec('use master')
--Export report ot Excel
--set @get_query='select * into sql4.[MASTER].[CTSI\Vijay].temp# from [master].[CTSI\Vijay].internal_ctsi_result'
set @query='select * from SQL4.[MASTER].[CTSI\Vijay].internal_ctsi_result'
exec(@query)
drop table [master].[CTSI\Vijay].internal_ctsi_result
go

Run the Procedure
exec sql4.[master].[CTSI\Vijay].Sp_CTSI_internal '1/1/2010','12/31/2010'

Storing image into database and retrieve from database and display in web form image control

Thu, 10 Feb 2011 09:01:00 +0000

code for Aspx.cs Page

protected void btnSubmit_Click(object sender, EventArgs e)

{

try

{

//typecasete imageupload control in a varaiable

FileUpload img = (FileUpload)imgUpload;

Byte[] imgByte = null;

if (img.HasFile && img.PostedFile != null)

{

//To create a PostedFile

HttpPostedFile File = imgUpload.PostedFile;

//Create byte Array with file len

imgByte = new Byte[File.ContentLength];

//force the control to load data in array

File.InputStream.Read(imgByte, 0, File.ContentLength);

}

// Insert the employee name and image into db

connection.Open();

string sql = "INSERT INTO image_test(image_name,image_source) VALUES(@image_name, @image_source)";

SqlCommand cmd = new SqlCommand(sql, connection);

cmd.Parameters.AddWithValue("@image_name", imgUpload.PostedFile.FileName.ToString() );

cmd.Parameters.AddWithValue("@image_source", imgByte);

cmd.ExecuteNonQuery();

connection.Close();

}

catch

{ lblResult.Text = "There was an error"; }

}

protected void Button1_Click(object sender, EventArgs e)

{

// For reading image from database and display in a image control in web form.

Image1.ImageUrl = "~/image.ashx?image_name=" + txt_imageshow.Text.Trim();

}

Next step add ashx extension file with following instruction:

click project > Add New Item > Generic Handler > image.ashx

then write the code in the form.

public void ProcessRequest(HttpContext context)
{

            string image_name = null;
            if (context.Request.QueryString["image_name"] != null)
               image_name = Convert.ToString(context.Request.QueryString["image_name"]);
            else
                throw new ArgumentException("No parameter specified");

            context.Response.ContentType = "image/jpeg";
            Stream strm = ShowEmpImage(image_name);
            byte[] buffer = new byte[strm.Length];
            int byteSeq = strm.Read(buffer, 0, Convert.ToInt32(strm.Length));

            while (byteSeq > 0)
            {
                context.Response.OutputStream.Write(buffer, 0, byteSeq);
                byteSeq = strm.Read(buffer, 0, 4096);
            }
           // context.Response.ContentType = "text/plain";
           // context.Response.Write("Hello World");
        }
        public Stream ShowEmpImage(string image_name)
        {

            string sql = "SELECT image_source FROM image_test WHERE image_name = @name";
            SqlCommand cmd = new SqlCommand(sql, connection);
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("@name", image_name);
            connection.Open();
            object img = cmd.ExecuteScalar();
            try
            {
                return new MemoryStream((byte[])img);
            }
            catch
            {
                return null;
            }
            finally
            {
                connection.Close();
            }
        }

Code for Run a DOS command from c#.net

Fri, 07 Jan 2011 09:00:00 +0000

FileInfo f = new FileInfo(TextBox1.Text.ToString());

if (f.Exists)

{

Response.Write("file exists");

}

else

{

string command = "copy " + Server.MapPath("template\\canada.xls") + " " + TextBox1.Text.ToString() + "";

System.Diagnostics.ProcessStartInfo procStartInfo =

new System.Diagnostics.ProcessStartInfo("cmd", "/c " + command);

// The following commands are needed to redirect the standard output.

// This means that it will be redirected to the Process.StandardOutput StreamReader.

procStartInfo.RedirectStandardOutput = true;

procStartInfo.UseShellExecute = false;

// Do not create the black window.

procStartInfo.CreateNoWindow = true;

// Now we create a process, assign its ProcessStartInfo and start it

System.Diagnostics.Process proc = new System.Diagnostics.Process();

proc.StartInfo = procStartInfo;

proc.Start();

// Get the output into a string

string result = proc.StandardOutput.ReadToEnd();

// Display the command output.

Response.Write(result);

}

}

catch (Exception objException)

{

// Log the exception

}

Code Example for abstract and interface

Wed, 15 Dec 2010 07:48:00 +0000

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;

namespace ConsoleApplication3
{
   abstract class test
    {
        abstract public void print();
        public int y; //can initialise fields
    }

     class Program:test

    {
         //abstract class
        public override void print()
        {
            x = 10;
            Console.WriteLine("Abstract : test value :"+y.ToString());
        }
         //end of abstract
        public int x;
     }
     interface test_interface
     {
        void test();
         // int x; it gives the error as Error    "Interfaces cannot contain fields"
     }
     class tt:Program,test_interface //inherit base class and interface
    {
        //interface
        public void test()
        {

            Console.WriteLine("interface value");
        }
        //end
     }


    class main_class
    {
        static void Main(string[] args)
        {

            Program pp = new Program();//create instance for base class for abstract only;
            tt te=new tt(); //for both abstract and derived class
            te.print();//abstract
            te.test();//interface

            pp.print();//

            pp.x = 100;
            Console.WriteLine(pp.x);
            test_interface ttt = (test_interface)te;//type casting into interface type
            ttt.test();
        }
    }
}

code for creating sql server table as a xml file

Wed, 24 Nov 2010 09:34:00 +0000

DataTable data_table = new DataTable();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select * from test_table", connection);
da.Fill(ds);
ds.WriteXml(@"c:\output2.xml", XmlWriteMode.IgnoreSchema);
connection.Close();

Read XML file data

XmlTextReader xml_reader = new XmlTextReader(@"c:\output1.xml");
        XmlDocument xml_doc = new XmlDocument();
        xml_doc.Load(xml_reader);
        XmlNode select_node = xml_doc.SelectSingleNode("NewDataSet");
        node_list = xml_doc.GetElementsByTagName("Table");

        for (i = 0; i < node_list.Count; i++)
        {
            for (j = 0; j < node_list[i].ChildNodes.Count; j++)
            {
                     Response.Write(node_list[i].ChildNodes[j].InnerText);
            }
}

code for zip and unzip the file using c#

Wed, 24 Nov 2010 09:33:00 +0000

using System.IO.Compression;
using System.IO;

Zip the File

FileStream sourceFile = File.OpenRead(@"C:\output1.xml");
        FileStream destFile = File.Create(@"C:\sample.zip");

        GZipStream compStream = new GZipStream(destFile, CompressionMode.Compress);

        try
        {
            int theByte = sourceFile.ReadByte();
            while (theByte != -1)
            {
                compStream.WriteByte((byte)theByte);
                theByte = sourceFile.ReadByte();
            }
        }
        finally
        {
            compStream.Dispose();
        }

UnZip the File

string srcFile = @"C:\sample.zip";
        string dstFile = @"C:\file_xml1.xml";

        FileStream file_stream_in = null;
        FileStream file_stream_out = null;
        GZipStream zip = null;
        const int bufferSize = 4096;
        byte[] buffer = new byte[bufferSize];
        int count = 0;

        try
        {

            file_stream_in = new FileStream(srcFile, FileMode.Open, FileAccess.Read, FileShare.Read);
            file_stream_out = new FileStream(dstFile, FileMode.Create, FileAccess.Write, FileShare.None);
            zip = new GZipStream(file_stream_in , CompressionMode.Decompress, true);
            while (true)
            {
                count = zip.Read(buffer, 0, bufferSize);
                if (count != 0)
                {
                    file_stream_out.Write(buffer, 0, count);
                }
                if (count != bufferSize)
                {

                    break;
                }
            }
        }
        catch (Exception ex)
        {

            System.Diagnostics.Debug.Assert(false, ex.ToString());
        }

code for using Jquery in asp.net

Fri, 15 Oct 2010 05:51:00 +0000

protected override void Render(HtmlTextWriter writer)
    {
        this.Page.ClientScript.RegisterClientScriptInclude("jQuery", "http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js");
        this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "startup", "");
        base.Render(writer);
    }

Jquery

   function test_alert()     {     $("#sample").animate({width: "70%",opacity: "0.4",marginLeft: "0.6in",fontSize: "3em",      borderWidth: "10px"}, 1500 );     //alert('Proceed to hide the message');     $("#sample").hide(3000,function () {     $(this).show(5000, function () {     $(this).slideUp(10000,function() {     $(this).slideDown(1000);        });     });     });     });     }     function helloWorld()     {         $("#sample").append("Hello World!!");          $("#sample").click(test_alert);          $("#sample").removeClass("bgcolor").addClass("newcolor");          $("#p:first").fadeTo("slow",0.33);             }

copying text file values as a database column values

Thu, 30 Sep 2010 09:10:00 +0000

Step 1 : create a table name as login...

Step 2 :

BULK INSERT login FROM 'c:\test_sql.txt' WITH
(
FIELDTERMINATOR = ',',--Data format in text file is username,password in a row.it is used to trminate the symbol comma and assume as a 2 column values

ROWTERMINATOR = '\n' ) --for next line
GO

--Showing the Result
SELECT *
FROM login
GO

Stored procedure for finding number days in month

Wed, 22 Sep 2010 07:53:00 +0000

Finding number of days in a month

alter procedure no_of_days as
Declare @no_of_days int
Declare @prev_month varchar(100)
Declare @current_month varchar(100)
Declare @file_duration varchar(100)
DECLARE @returnDate INT
declare @days int

SET @returnDate = CASE WHEN MONTH(getdate())
IN (1, 3, 5, 7, 8, 10, 12) THEN 31
WHEN MONTH(getdate()) IN (4, 6, 9, 11) THEN 30
ELSE CASE WHEN (YEAR(getdate()) % 4 = 0
AND
YEAR(getdate()) % 100 != 0)
OR
(YEAR(getdate()) % 400 = 0)
THEN 29
ELSE 28 END
END

Get previous month name and current month name

set @no_of_days=@returnDate
set @prev_month=(Select Datename(mm, GetDate()-@no_of_days))
set @current_month=(Select Datename(mm, GetDate()))
set @file_duration=@prev_month+'-'+@current_month

Code for Copying Sql Table data into Excel file

Mon, 13 Sep 2010 08:01:00 +0000

Step 1:

Before run this procedure u have to create a excel template file with the relevant column name of the table.

Step 2:

Create PROCEDURE SP_Sql_Excel @File_Name as varchar(50) = ''
AS
BEGIN
    SET NOCOUNT ON

    DECLARE @Dos_Command varchar(1000)
    DECLARE @reportname varchar(500)
    DECLARE @Oledb_provider varchar(100)
    DECLARE @Excel_String varchar(100)

--    New File Name to be created
    IF @File_Name = ''
        Select @reportname = 'C:\temp\Excel\Template1.xls'
    ELSE
        Select @reportname = 'C:\temp\Excel\' + @File_Name + '.xls'

--    FileCopy command string formation
    SELECT @Dos_Command = 'Copy C:\temp\Excel\Template1.xls ' + @reportname

--    Execute Dos Copy command
    EXEC MASTER..XP_CMDSHELL @Dos_Command, NO_OUTPUT

--    Mentioning the OLEDB povider and excel destination filename
    set @Oledb_provider = 'Microsoft.Jet.OLEDB.4.0'
    set @Excel_String = 'Excel 8.0;Database=' + @reportname

--    Executing the OPENROWSET Command for copying the sql data contents to Excel sheet.
exec('insert into OPENrowset (''' + @Oledb_provider + ''',''' + @Excel_String + ''',''SELECT username,password FROM [Sheet1$]'') select username,password from login')

SET NOCOUNT OFF
END

Step 3:

Run the Procedure

Exec SP_Sql_Excel 'filename'

Connecting Remote computer via code

Tue, 03 Aug 2010 08:47:00 +0000

private connection_status;
private IPAddress ip_address;
    private TcpClient tcp_server;

ip_address = IPAddress.Parse (TextBox1.Text);
        tcp_server = new TcpClient();
        tcp_server.Connect(ip_address, port number);
        connection_status = true;
        if (connection_status)
        {
            Response.Write("connected");
        }
        else
        {
            Response.Write ("Not connected");
        }

Creating Dll Manually

Mon, 02 Aug 2010 07:24:00 +0000

Below image is show the steps to create dll file manually from web service files.

Code for Download a file from a folder

Thu, 17 Jun 2010 09:02:00 +0000

string[] filepath = Directory.GetFiles(Server.MapPath("~\\upload files"));
            foreach (string fileName in filepath)
            {
                string filename_read = Path.GetFileNameWithoutExtension(fileName);
                if (hidden_tar_file.Value == filename_read)
                {
                    System.IO.FileInfo file = new System.IO.FileInfo(fileName);
                    if (file.Exists)
                    {
                        Response.Clear();
                        Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
                        Response.AddHeader("Content-Length", file.Length.ToString());
                        Response.ContentType = "application/octet-stream";
                        Response.WriteFile(file.FullName);
                        Response.End();
                    }
                }

            }

coding for connectoin remote desktop using c#

Tue, 11 May 2010 13:28:00 +0000

Process process_conectoin = new Process();
string exe = Environment.ExpandEnvironmentVariables(@"%SystemRoot%\system32\mstsc.exe");
if (exe != null)
{
process_conectoin.StartInfo.FileName = exe;
process_conectoin.StartInfo.Arguments = "/v " + "192.168.1.2"; // ip or name of computer to connect
process_conectoin.Start();
}

This is another way to run Remote desktop using c#.net

Steps for creating .RDP File for running remote connection from ur code.

step 1: Enter machine name,user name,password,domain name and check save password then click saveas button to save the RDP file in ur root folder.

Step 2:the write the code given below.

using System.Diagnostics;

Process.Start(Server.MapPath("Filename.rdp"));

Adding css effect to gridview while you mouse over and out from gridview

Mon, 26 Apr 2010 10:57:00 +0000

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes["onmouseover"] = "this.className='PostingPanelTableGrids';"
e.Row.Attributes["onmouseout"] = "this.className='PostingPanelTableGrid';";
}

Coding for checking status of ip with ping statment in asp.net with c#

Thu, 01 Apr 2010 09:14:00 +0000

string server_ip = "127.0.0.1";//address to verify, like 127.0.0.1
Ping _objPing = new Ping();
PingReply reply_ping;
reply_ping = p.Send(server_ip);
int ping_success = 0, ping_insuccess = 0;
for (int i = 0; i < 25; i++)
{
reply_ping = _objPing.Send(server_ip);
if (reply_ping.Address.ToString() == server_ip)
ping_success++;
else
ping_insuccess++;
Console.WriteLine("Pack. sent");
}
Console.WriteLine("sent = 4, recived = {0}, lost = {1}", ping_success, ping_insuccess);
Console.ReadKey();

Coding for show child gridview in gridview row

Wed, 31 Mar 2010 08:38:00 +0000

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow row = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
Button b1 = (Button)row.FindControl("Button1");
GridView g1 = (GridView)row.FindControl("GridView2");
if (b1.Text == "Show")
{
g1.Visible = true;
b1.Text = "hide";
}
else if (b1.Text == "hide")
{
g1.Visible = false;
b1.Text = "show";
}
}

upload and download file from sqlserver

Fri, 19 Feb 2010 05:41:00 +0000

Creating sqlserver table

create table (id int,content_type varcahr(50),filename varcahr(50),filecontent varbinary(8000))

Code for c#.net

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;

public partial class filestore : System.Web.UI.Page
{
SqlConnection ObjSQlConnectionString = new SqlConnection("Data source=server_name;Initial Catalog=table_name;User Id=userid;Pwd=password");

protected void btn_upload_file_Click(object sender, EventArgs e)
{

string upload_path_name = upload.PostedFile.FileName.ToString();
string upload_file_name = Path.GetFileName(upload_path_name);
FileStream Upload_filestream = new FileStream(upload_path_name, FileMode.Open, FileAccess.Read);
BinaryReader upload_binaryreader = new BinaryReader(Upload_filestream);
Byte[] byte_data = upload_binaryreader.ReadBytes ((Int32)Upload_filestream.Length);
upload_binaryreader.Close();
Upload_filestream.Close();

if (upload.PostedFile.ContentType == "application/vnd.ms-excel")
{
//upload file in a seperate folder
upload.SaveAs("C:\\Inetpub\\wwwroot\\tools_test\\excel files\\"+upload_file_name);
}

Response.Write(byte_data.Length);

//insert data in sqlserver table

string insert_query = "insert into filestroage(content_type,filename,filecontent)values(@content_type,@filename,@filecontent)";

SqlCommand sql_command = new SqlCommand(insert_query, ObjSQlConnectionString);

sql_command.CommandType = CommandType.Text;

sql_command.Parameters.Add("@content_type", SqlDbType.VarChar).Value = upload.PostedFile.ContentType.ToString();
sql_command.Parameters.Add("@filename", SqlDbType.VarChar).Value = upload_file_name;
sql_command.Parameters.Add("@filecontent", SqlDbType.Binary).Value = byte_data;

ObjSQlConnectionString.Open();

sql_command.ExecuteNonQuery();

ObjSQlConnectionString.Close();

}

//Read files data from table
protected void Button1_Click(object sender, EventArgs e)
{
string strQuery = "select content_type,filename,filecontent from filestroage where id=@id";

SqlCommand sql_command = new SqlCommand(strQuery);

sql_command.Parameters.Add("@id", SqlDbType.Int).Value = 2;

DataTable data_table_query = GetData_table(sql_command);

if (data_table_query != null)
{
file_download (data_table_query);
}
}

private DataTable GetData_table(SqlCommand sql_command)
{
DataTable data_table = new DataTable();

SqlDataAdapter sql_adapter = new SqlDataAdapter();

sql_command.CommandType = CommandType.Text;

sql_command.Connection = ObjSQlConnectionString;

try
{
ObjSQlConnectionString.Open();

sql_adapter.SelectCommand = sql_command;

sql_adapter.Fill(data_table );

return data_table;

}

catch
{

return null;

}

finally
{

ObjSQlConnectionString.Close();

sql_adapter.Dispose();

ObjSQlConnectionString.Dispose();

}

}

//Download read data in their own file format
private void file_download(DataTable data_table_rows)
{

Byte[] data_bytes = (Byte[])data_table_rows.Rows[0]["filecontent"];

Response.Buffer = true;

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = data_table_rows.Rows[0]["content_type"].ToString();

Response.AddHeader("content-disposition", "attachment;filename="+ data_table_rows .Rows[0]["filename"].ToString());

Response.BinaryWrite(data_bytes);

Response.Flush();

Response.End();
}
}

Playing with simple Interface Concept

Tue, 16 Feb 2010 07:09:00 +0000

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ConsoleApplication1
{
class Program:interface_first ,interface_second
{

public static void Main()
{
Console.WriteLine("INTERFACE TEST\n");

//call by class objects.
Program call_interface_first = new Program();
call_interface_first.method_for_interface("Invoke first interface method using object of first class");
call_interface_first.methos_for_second_interface("Invoke second interface method using object of first class\n");

second_calss call_interface_second = new second_calss();
call_interface_second.method_for_interface("Invoke first interface method using object of second class\n");

interface_first first_interface_call = call_interface_first;
first_interface_call.method_for_interface("Call the first interface using interface object with assing class objects");
interface_second second_interface_call = call_interface_first;
second_interface_call.methos_for_second_interface("Call the second interface using interface object with assing class objects\n");

//call by same interface objects.
interface_first call_using_interface_refference = new Program();
call_using_interface_refference.method_for_interface("call first interface using the same interface reference");
interface_first call_using_interface_refference1 = new second_calss();
call_using_interface_refference1.method_for_interface("call second interface using the same interface reference\n");

//call by interface array with same reference.
interface_first[] array_interface = { new Program(), new second_calss() };
for (int i = 0; i <= 1; i++)
{
array_interface[i].method_for_interface("Invoke interface methods from class in array format :" + i);

}

}

public string method_for_interface(string i)
{

Console.WriteLine(i.ToString());
return i;
}
public string methos_for_second_interface(string s)
{
Console.WriteLine(s.ToString());
return s;
}

}

interface interface_first
{
//void interface_method_first();
string method_for_interface(string i);

}
interface interface_second
{
string methos_for_second_interface(string s);
}

//second class for accessing Interface
class second_calss : interface_first
{
public string method_for_interface(string s)
{
Console.WriteLine(s.ToString());
return s;
}
}
}

Code for sending sms from C# using way2sms api

Fri, 29 Jan 2010 07:00:00 +0000

Before Write a code use the steps given below

1. Add Web References to your page.
In that web references page just type this "http://www.spiritssoft.com/webservice/sendway2sms.asmx" in url optoin and click go

After Added that

2. use the name space Using com.spiritssoft.www

3. create a object for sending a sms
SendWay2Sms Objsms_send = new SendWay2Sms();

4.write the code given below here

Note: If you send to a single number just write the code what given here.If you want to send more than one person use comma(,) to seperate the numbers.

For sending one number:

String Strsms_result=Objsms_send.sendSmsSpiritsSoft("UserName", "Password", "Number", "message");

For sending more than numbers:

String Strsms_result=Objsms_send.sendSmsSpiritsSoft("UserName", "Password", "Number 1,Number 2,Number 3", "message");