csharp

Display text in DataGridView when there are no rows

noreply@blogger.com (csharp) — Wed, 02 Dec 2015 14:23:00 +0000

Display text in DataGridView when there are no rows

   
if (dt.Rows.Count > 0)
                {
                    grid1.DataSource = dt;
                    grid1.DataBind();
                }
                else
                {
                    dt.Rows.Add(dt.NewRow());
                    grid1.DataSource = dt;
                    grid1.DataBind();
                    int totalcolums = grid1.Rows[0].Cells.Count;
                    grid1.Rows[0].Cells.Clear();
                    grid1.Rows[0].Cells.Add(new TableCell());
                    grid1.Rows[0].Cells[0].ColumnSpan = totalcolums;
                    grid1.Rows[0].Cells[0].Text = "No Data Found";
                }

Reading Excel files from C# OR How to read data from excel file using c#

noreply@blogger.com (csharp) — Tue, 01 Dec 2015 17:54:00 +0000

Reading Excel files from C# OR How to read data from excel file using c#

The following C# source code using Microsoft Excel 12.0 Object Library for reading an Excel file.

 namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Excel.Application xlApp ;
            Excel.Workbook xlWorkBook ;
            Excel.Worksheet xlWorkSheet ;
            Excel.Range range ;

            string str;
            int rCnt = 0;
            int cCnt = 0;

            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Open("sourcecodemaster.xls", 0, true, 5, "", "", true, 

Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            range = xlWorkSheet.UsedRange;

            for (rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
            {
                for (cCnt = 1; cCnt <= range.Columns.Count; cCnt++)
                {
                    str = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value2 ;
                    MessageBox.Show(str);
                }
            }

            xlWorkBook.Close(true, null, null);
            xlApp.Quit();

            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);
        }

        private void releaseObject(object obj)
        {
            try
            {
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
                obj = null;
            }
            catch (Exception ex)
            {
                obj = null;
                MessageBox.Show("Unable to release the Object " + ex.ToString());
            }
            finally
            {
                GC.Collect();
            }
        } 

    }
}

Converting a string to byte-array without using an encoding (byte-by-byte)

noreply@blogger.com (csharp) — Tue, 01 Dec 2015 17:51:00 +0000

Converting a string to byte-array without using an encoding (byte-by-byte)

 static byte[] GetBytes(string str)
{
    byte[] bytes = new byte[str.Length * sizeof(char)];
    System.Buffer.BlockCopy(str.ToCharArray(), 0, bytes, 0, bytes.Length);
    return bytes;
}

 static string GetString(byte[] bytes)
{
    char[] chars = new char[bytes.Length / sizeof(char)];
    System.Buffer.BlockCopy(bytes, 0, chars, 0, bytes.Length);
    return new string(chars);
}

How do you convert Byte Array to Hexadecimal String, and vice versa

noreply@blogger.com (csharp) — Tue, 01 Dec 2015 17:49:00 +0000

How do you convert Byte Array to Hexadecimal String, and vice versa

 public static string ByteArrayToString(byte[] ba)
{
  StringBuilder hex = new StringBuilder(ba.Length * 2);
  foreach (byte b in ba)
    hex.AppendFormat("{0:x2}", b);
  return hex.ToString();
}

public static string ByteArrayToString(byte[] ba)
{
  string hex = BitConverter.ToString(ba);
  return hex.Replace("-","");
}

  public static byte[] StringToByteArray(String hex)
{
  int NumberChars = hex.Length;
  byte[] bytes = new byte[NumberChars / 2];
  for (int i = 0; i < NumberChars; i += 2)
    bytes[i / 2] = Convert.ToByte(hex.Substring(i, 2), 16);
  return bytes;
}

Create Excel (.XLS and .XLSX) file from C#

noreply@blogger.com (csharp) — Tue, 01 Dec 2015 17:42:00 +0000

Create Excel (.XLS and .XLSX) file from C#

You can use a library called ExcelLibrary.
It's very simple, small and easy to use. you can use DataSets and DataTables to easily work with Excel data.Here is an example taking data from a database and creating a workbook from it. Note that the ExcelLibrary code is the single line at the bottom:

   
//Create the dataset and table
DataSet ds = new DataSet("NewDataSet");
DataTable dt = new DataTable("NewDataTable");

//Set the locale for each
ds.Locale = System.Threading.Thread.CurrentThread.CurrentCulture;
dt.Locale = System.Threading.Thread.CurrentThread.CurrentCulture;

//Open a DB connection (example OleDB)
OleDbConnection con = new OleDbConnection(dbConnectionString);
con.Open();

//Create a query and fill the data table with the data from the DB
string sql = "SELECT Whatever FROM MyDBTable;";
OleDbCommand cmd = new OleDbCommand(sql, con);
OleDbDataAdapter adptr = new OleDbDataAdapter();

adptr.SelectCommand = cmd;
adptr.Fill(dt);
con.Close();

//Add the table to the data set
ds.Tables.Add(dt);

//Here's the easy part. Create the Excel worksheet from the data set
ExcelLibrary.DataSetHelper.CreateWorkbook("sourcecodemaster.xls", ds);

Microsoft Excel 12.0

using System;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel; 

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

            if (xlApp == null)
            {
                MessageBox.Show("Excel is not properly installed!!");
                return;
            }


            Excel.Workbook xlWorkBook;
            Excel.Worksheet xlWorkSheet;
            object misValue = System.Reflection.Missing.Value;

            xlWorkBook = xlApp.Workbooks.Add(misValue);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
            xlWorkSheet.Cells[1, 1] = "Sheet 1 content";

            xlWorkBook.SaveAs("C:\\sourcecodemaster.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
            xlWorkBook.Close(true, misValue, misValue);
            xlApp.Quit();

            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);

            MessageBox.Show("Excel file created , you can find the file d:\\sourcecodemaster.xls");
        }

        private void releaseObject(object obj)
        {
            try
            {
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
                obj = null;
            }
            catch (Exception ex)
            {
                obj = null;
                MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
            }
            finally
            {
                GC.Collect();
            }
        }

    }
}

Connection String

noreply@blogger.com (csharp) — Mon, 30 Nov 2015 08:55:00 +0000

connection string in c#

You can connect your C# application to data in a SQL Server database using the .NET Framework Data Provider for SQL Server. The first step in a C# application is to create an instance of the Server object and to establish its connection to an instance of Microsoft SQL Server.
The SqlConnection Object is Handling the part of physical communication between the C# application and the SQL Server Database . An instance of the SqlConnection class in C# is supported the Data Provider for SQL Server Database. The SqlConnection instance takes Connection String as argument and pass the value to the Constructor statement.

connetionString="Data Source=ServerName; Initial Catalog=DatabaseName;User ID=UserName;Password=Password"

If you have a named instance of SQL Server, you'll need to add that as well.

 "Server=localhost\sqlexpress"

Connect via an IP address

connetionString="Data Source=IP_ADDRESS,PORT; Network Library=DBMSSOCN;Initial Catalog=DatabaseName; User ID=UserName;Password=Password"

Trusted Connection from a CE device ( 1433 is the default port SQL )

 connetionString="Data Source=ServerName; Initial Catalog=DatabaseName;Integrated Security=SSPI; User ID=myDomain\UserName;Password=Password;

Connecting to SQL Server using windows authentication

 "Server= localhost; Database= employeedetails; Integrated Security=SSPI;"

c# calculator program source code

noreply@blogger.com (csharp) — Sat, 28 Nov 2015 11:47:00 +0000

c# calculator program source code

Today I am going to show you how to build a Calculator. It is recommended that you get the visual studio environment. if you don't understand the code don't be afraid to ask questions by leaving a comment below.

using System;
using System.Windows.Forms;
 
namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        float num1, ans;
        int count;
 
        private void btnC_Click_1(object sender, EventArgs e)
        {
            textBox1.Clear();
            count = 0; 
        }
 
        private void btnCE_Click(object sender, EventArgs e)
        {
            
            if (num1==0 && textBox1.TextLength>0)
            { 
                num1 = 0; textBox1.Clear();  
            }
            else if (num1 > 0 && textBox1.TextLength > 0)
            { 
                textBox1.Clear();
            }
        
        }
 
        private void btnback_Click(object sender, EventArgs e)
        {
           
            int lenght = textBox1.TextLength-1;
            string text = textBox1.Text;  
            textBox1.Clear();
            for (int i = 0; i < lenght; i++)
                textBox1.Text = textBox1.Text + text[i]; 
        
        }
 
        private void btnminus_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "")
            {
                num1 = float.Parse(textBox1.Text);
                textBox1.Clear();
                textBox1.Focus();
                count = 1;
            }
        }
 
        private void btnone_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 1;
        }
 
        private void bttntwo_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 2;
        }
 
        private void btnthree_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 3;
        }
 
        private void btnplus_Click(object sender, EventArgs e)
        {
            num1 = float.Parse(textBox1.Text);
            textBox1.Clear();
            textBox1.Focus();
            count = 2;
        }
 
        private void btnfour_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 4;
        }
 
        private void btnfive_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 5;
        }
 
        private void btnsix_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 6;
        }
 
        private void btnmultiply_Click(object sender, EventArgs e)
        {
            num1 = float.Parse(textBox1.Text);
            textBox1.Clear();
            textBox1.Focus();
            count = 3;
        }
 
        private void btnseven_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 7;
        }
 
        private void btneight_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 8;
        }
 
        private void btnnine_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 9;
        }
 
        private void btndivide_Click(object sender, EventArgs e)
        {
            num1 = float.Parse(textBox1.Text);
            textBox1.Clear();
            textBox1.Focus();
            count = 4; 
        }
 
        private void btnzero_Click(object sender, EventArgs e)
        {
            textBox1.Text = textBox1.Text + 0;
        }
 
        private void btnperiod_Click(object sender, EventArgs e)
        {
            int c = textBox1.TextLength;
            int flag = 0;
            string text = textBox1.Text;
            for (int i = 0; i < c; i++)
            { 
                if (text[i].ToString() == ".") 
                { 
                    flag = 1; break; 
                } 
                else 
                { 
                    flag = 0; 
                } 
            }
            if (flag == 0)
            { 
                textBox1.Text = textBox1.Text + "."; 
            }
        }
 
        private void btnequal_Click(object sender, EventArgs e)
        {
            compute(count);
        }
 
        public void compute(int count)
        {
            switch (count)
            {
                case 1:
                    ans = num1 - float.Parse(textBox1.Text);
                    textBox1.Text = ans.ToString();
                    break;
                case 2:
                    ans = num1 + float.Parse(textBox1.Text);
                    textBox1.Text = ans.ToString();
                    break;
                case 3:
                    ans = num1 * float.Parse(textBox1.Text);
                    textBox1.Text = ans.ToString();
                    break;
                case 4:
                    ans = num1 / float.Parse(textBox1.Text);
                    textBox1.Text = ans.ToString();
                    break;
                default:
                    break;
            }
        }
       
     }
}

How to create a Messagebox with “Yes”, “No” choices and a DialogResult in C#?

noreply@blogger.com (csharp) — Mon, 11 Aug 2014 06:25:00 +0000

DialogResult dialogResult = MessageBox.Show("Type Your Message", "Message Box Title", MessageBoxButtons.YesNo);
if(dialogResult == DialogResult.Yes)
{
    //Yes Result
}
else if (dialogResult == DialogResult.No)
{
    //No Result
}

DataGridView Read Only Columns and Rows

noreply@blogger.com (csharp) — Thu, 03 Jul 2014 14:47:00 +0000

DataGridView Read Only Columns and Rows

The DataGridView control for displaying and editing tabular data. The ReadOnly property indicates whether the data displayed by the cell can be edited or not. You can set ReadOnly Property in three levels. You can make entire dataGridView or entire column or entire row as ReadOnly .

dataGridView.ReadOnly = true;

dataGridView.Rows[0].ReadOnly = true;

dataGridView.Columns[0].ReadOnly = true;

 private void button1_Click(object sender, EventArgs e)
        {
            dataGridView1.ColumnCount = 3;
            dataGridView1.Columns[0].Name = "Product ID";
            dataGridView1.Columns[1].Name = "Product Name";
            dataGridView1.Columns[2].Name = "Product Price";

            string[] row = new string[] { "1", "Product 1", "1000" };
            dataGridView1.Rows.Add(row);
            row = new string[] { "2", "Product 2", "2000" };
            dataGridView1.Rows.Add(row);
            row = new string[] { "3", "Product 3", "3000" };
            dataGridView1.Rows.Add(row);
            row = new string[] { "4", "Product 4", "4000" };
            dataGridView1.Rows.Add(row);

            dataGridView1.Rows[1].ReadOnly = true;
        }

C# DataGridView Binding - SQL Server dataset

noreply@blogger.com (csharp) — Thu, 03 Jul 2014 14:43:00 +0000

C# DataGridView Binding - SQL Server dataset

The following C# program shows bind a SQL Server dataset to a DataGridView.

 private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";
            string sql = "SELECT * FROM Authors";
            SqlConnection connection = new SqlConnection(connectionString);
            SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
            DataSet ds = new DataSet();
            connection.Open();
            dataadapter.Fill(ds, "Authors_table");
            connection.Close();
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "Authors_table";
        }

noreply@blogger.com (csharp) — Thu, 03 Jul 2014 14:38:00 +0000

C# Crystal Reports Export to Pdf

You have to include two line in your C# Source Code.

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

 try
            {
                ExportOptions CrExportOptions ;
                DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
                PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
                CrDiskFileDestinationOptions.DiskFileName = "D:\\csharp.pdf";
                CrExportOptions = cryRpt.ExportOptions;
                {
                    CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
                    CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
                    CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
                    CrExportOptions.FormatOptions = CrFormatTypeOptions;
                }
                cryRpt.Export();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

The Crystal Reports file path in your C# project files location, there you can see CrystalReport1.rpt . So give the full path name of Crystal Reports file like D:\projects\crystalreports\CrystalReport1.rpt When you run this program you will get the PDF file in your computer's D Drive

How to use C# string Clone

noreply@blogger.com (csharp) — Thu, 03 Jul 2014 14:34:00 +0000

How to use C# string Clone

Clone() method creates and returns a copy of string object. The CSharp string Clone() method returns a reference to this instance of string.

using System;
using System.Windows.Forms;
namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            {
                string str = "Mahesh";
                string clonedString = null;
                clonedString = (String)str.Clone();
                MessageBox.Show (clonedString);
            }
        }
    }
}

noreply@blogger.com (csharp) — Sat, 28 Jun 2014 14:28:00 +0000

Top Web Development Blogs

A creative web development strategy for your website will improve your online presence and increase the amount of quality content your website provides. Your website should be easy to navigate, fully functional, and interesting to those who visit it. There are many blogs about web development and design on the Internet to give you tips and ideas on how to create a dynamic website but there are some blogs that stand out from the rest.
UX BOOTH
The UX stands for user experience and this blog is created by and for experienced web designers. There is also a host of guest authors that contribute to the site and allows visitors to subscribe to a specific topic and make their own contributions.
WEB DESIGNER WALL
This site is run by and experienced web designer and illustrator who uses this blog to teach others about web design. There are tutorials, ideas, and opportunities for guest bloggers available on Web Designer Wall.
LINE25
Line25 is a combination of tutorials, articles, and examples of well-designed websites that visitors can view and be motivated by. You can receive email updates and new content from Line25 by signing up for them on the site.
SMASHING MAGAZINE
There is an excellent collection of blogs on Smashing Magazine that covers topics like coding, design, and graphics. This site also features a job board for developers and designers to find employment.
BLOGFREAKZ
Blogfreakz is a well-rounded site for designers and developers with a lot of free content like icons and fonts you can use on your own site. They also accept new writers to come and write about development and related topics.
LOGOFURY
LogoFury is a design source for new logo designs and ideas that visitors can use for inspiration. You can also get them to design a logo for you to use on your site.
DESIGNERFIX
This site is made up of self-described “design junkies” and has a lot of great content. Designerfix has everything from free giveaways, to their artist of the day and deals on content.
NETTUTS+
Nettuts+ is a good-looking site that gives web developers and designers tools for improving their sites by using better technologies and designs. They focus on apps and the technical aspects of sites like HTML and Javascript.
TREEHOUSE
Treehouse has a large team of teachers and designers that focus on the educational side of web design and development. They provide quizzes and instructional videos on a variety of topics so visitors can take advantage of detailed lessons that apply to their own sites.
WEBAPPERS
This blog is great for finding open source resources that you can add to your site’s design like stock photos, icons, and Javascript plugins. They pick the best resources that are available on the Internet and offer them in one place so you do not have to search around.

How to send email with attachment from C#

noreply@blogger.com (csharp) — Sat, 28 Jun 2014 13:29:00 +0000

The System.Net classes uses to communicate with other applications by using the HTTP, TCP, UDP, Socket etc. In the previous program we saw how to SMTP email from C# describes how to send an email with text body . Here we are sending an email with an attachment.

System.Net.Mail.Attachment attachment;
attachment = new System.Net.Mail.Attachment("your attachment file");
mail.Attachments.Add(attachment);

The Gmail SMTP server name is smtp.gmail.com and the port using send mail is 587 . Here using NetworkCredential for password based authentication.
SmtpServer.Credentials = new System.Net.NetworkCredential("username", "password");

using System;
using System.Windows.Forms;
using System.Net.Mail;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                MailMessage mail = new MailMessage();
                SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
                mail.From = new MailAddress("your_email_address@gmail.com");
                mail.To.Add("to_address");
                mail.Subject = "Test Mail - 1";
                mail.Body = "mail with attachment";

                System.Net.Mail.Attachment attachment;
                attachment = new System.Net.Mail.Attachment("your attachment file");
                mail.Attachments.Add(attachment);

                SmtpServer.Port = 587;
                SmtpServer.Credentials = new System.Net.NetworkCredential("username", "password");
                SmtpServer.EnableSsl = true;

                SmtpServer.Send(mail);
                MessageBox.Show("mail Send");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
    }
}

C# DataGridView Printing

noreply@blogger.com (csharp) — Sat, 28 Jun 2014 12:24:00 +0000

Add PrintDocument object to the project and handle the PrintPage event which is called every time a new page is to be printed. Here in the PrintPage event we create a Bitmap Object and draw the DataGridView to the Bitmap Object. In order to run this C# project you have to drag two buttons ,one for load data and one for print command, and drag a PrintDocument control on your form . The following picture shows how to drag PrintDocument Object to your project.

<?php
using System;

using System.Data;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.Drawing;



namespace WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }



        private void button1_Click(object sender, EventArgs e)

        {

            string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";

            string sql = "SELECT * FROM NAME";

            SqlConnection connection = new SqlConnection(connectionString);

            SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);

            DataSet ds = new DataSet();

            connection.Open();

            dataadapter.Fill(ds, "NAME");

            connection.Close();

            dataGridView1.DataSource = ds;

            dataGridView1.DataMember = "NAME";



        }



        private void button2_Click(object sender, EventArgs e)

        {

            printDocumentS.Print();

        }



        private void printDocumentS_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)

        {

            Bitmap bm = new Bitmap(this.dataGridView1.Width, this.dataGridView1.Height);

            dataGridView1.DrawToBitmap(bm, new Rectangle(0, 0, this.dataGridView1.Width, this.dataGridView1.Height));

            e.Graphics.DrawImage(bm, 0, 0);

        }

 

    }

}

C# DataGridView Export to Excel

noreply@blogger.com (csharp) — Sat, 28 Jun 2014 12:14:00 +0000

The DataGridView control is designed to be a complete solution for displaying tabular data with Windows Forms. The DataGridView control is highly configurable and extensible, and it provides many properties, methods, and events to customize its appearance and behavior. The following C# source code shows how to Export the content of a datagridview to an Excel file.

<?php
using System;

using System.Data;

using System.Windows.Forms;

using System.Data.SqlClient;

using Excel = Microsoft.Office.Interop.Excel;



namespace WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }


        private void button1_Click(object sender, EventArgs e)

        {

            string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";

            string sql = "SELECT * FROM Authors";

            SqlConnection connection = new SqlConnection(connectionString);

            SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);

            DataSet ds = new DataSet();

            connection.Open();

            dataadapter.Fill(ds, "Authors_table");

            connection.Close();

            dataGridView1.DataSource = ds;

            dataGridView1.DataMember = "Authors_table";

        }


        private void button2_Click(object sender, EventArgs e)

        {

            Excel.Application xlApp;

            Excel.Workbook xlWorkBook;

            Excel.Worksheet xlWorkSheet;

            object misValue = System.Reflection.Missing.Value;



            Int16 i, j;



            xlApp = new Excel.ApplicationClass();

            xlWorkBook = xlApp.Workbooks.Add(misValue);



            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);



            for (i = 0; i <= dataGridView1.RowCount - 2; i++)

            {

                for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)

                {

                    xlWorkSheet.Cells[i + 1, j + 1] = dataGridView1[j, i].Value.ToString();

                }

            }


            xlWorkBook.SaveAs(@"c:\csharp.net-informations.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

            xlWorkBook.Close(true, misValue, misValue);

            xlApp.Quit();


            releaseObject(xlWorkSheet);

            releaseObject(xlWorkBook);

            releaseObject(xlApp);

        }


        private void releaseObject(object obj)

        {

            try

            {

                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);

                obj = null;

            }

            catch (Exception ex)

            {

                obj = null;

                MessageBox.Show("Exception Occured while releasing object " + ex.ToString());

            }

            finally

            {

                GC.Collect();

            }

        }

    }

}

how to get the list of all printers in computer - C# Winform

noreply@blogger.com (csharp) — Fri, 27 Jun 2014 04:36:00 +0000

how to get the list of all printers in computer - C# Winform

<?php
foreach (string printer in System.Drawing.Printing.PrinterSettings.InstalledPrinters)

        {

            MessageBox.Show(printer);

        }

Best way to implement keyboard shortcuts in a Windows Forms application?

noreply@blogger.com (csharp) — Fri, 27 Jun 2014 02:32:00 +0000

I'm looking for a best way to implement common Windows keyboard shortcuts (for example Ctrl+F, Ctrl+N) in my Windows Forms application in C#.

You probably forget to set the form's KeyPreview property to True. Overriding the ProcessCmdKey() method is the generic solution:

protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if (keyData == (Keys.Control | Keys.F)) {
MessageBox.Show("What the Ctrl+F?");
return true;
}
return base.ProcessCmdKey(ref msg, keyData);
}

How do I make a textbox that only accepts numbers?

noreply@blogger.com (csharp) — Fri, 27 Jun 2014 02:27:00 +0000

Handle the appropriate keyboard events to prevent anything but numeric input. I've had success with this two event handlers on a standard TextBox:

<?php
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)

{

    if (!char.IsControl(e.KeyChar) 

        && !char.IsDigit(e.KeyChar) 

        && e.KeyChar != '.')

    {

        e.Handled = true;

    }


    // only allow one decimal point

    if (e.KeyChar == '.' 

        && (sender as TextBox).Text.IndexOf('.') > -1)

    {

        e.Handled = true;

    }

}

combobox Autocomplete

noreply@blogger.com (csharp) — Wed, 25 Jun 2014 16:43:00 +0000

Since you've declared CustomSource for auto completion, you should provide that source:


private void frmInvoice_Load(object sender, EventArgs e)    
  
{

    comboBox1.AutoCompleteMode=AutoCompleteMode.Append;

    comboBox1.AutoCompleteSource = AutoCompleteSource.CustomSource; 

    AutoCompleteStringCollection data = new AutoCompleteStringCollection();

    // Put here the auto completions' e.g. 

    data.Add("My String 1");

    data.Add("Autocompletion 2");

    data.Add("Some stuff");

    comboBox1.AutoCompleteCustomSource = data;

}

or use this

private void LoadStuffNames()

{


    try

    {

            string Query = "select stuff_name from dbo.stuff";

            string[] names = GetColumnData_FromDB(Query);


            comboName.AutoCompleteMode = AutoCompleteMode.Suggest;

            comboName.AutoCompleteSource = AutoCompleteSource.CustomSource;

            AutoCompleteStringCollection x = new AutoCompleteStringCollection();

            if (names != null && names.Length > 0)

                foreach (string s in names)

                    x.Add(s);


            comboName.AutoCompleteCustomSource = x;

    }

    catch (Exception ex)

    {

    }

    finally

    {

    }


}

Auto increment primary key in SQL Server Management Studio

noreply@blogger.com (csharp) — Wed, 25 Jun 2014 16:32:00 +0000

Make sure that the Key column's datatype is int and then setting identity manually, as image show

8 Websites Every Microsoft .NET Developer Should Know About

noreply@blogger.com (csharp) — Wed, 22 Jan 2014 02:08:00 +0000

There are currently millions of developers worldwide that are using Microsoft.NET technologies. If you are one of them or want to become one, then each of the websites I am about to list should be in your list of favorites, your list of bookmarks, or just written down on a piece of paper (yeah right, as if a .NET developer would use a pen and paper).

codeproject

MSDN

aspnet.4guysfromrolla

dnnsoftware

stackoverflow

New Google Sheets: faster, more powerful, and works offline

noreply@blogger.com (csharp) — Wed, 22 Jan 2014 01:41:00 +0000

Whether you’re crunching big data or tracking your family budget, you don’t want to waste time waiting for files to load or re-doing edits that were lost because your Internet connection dropped. You can now get more done by switching to the new version of Google Sheets. It’s faster, supports larger spreadsheets, has a number of new features, and works offline.

C# - Read a nvarchar (dd/MM/yyyy) into a dateTimePicker

noreply@blogger.com (csharp) — Sat, 07 Dec 2013 04:14:00 +0000

dateTimePicker.Value = DateTime.Parse(reader["Date"].ToString());

Pass value from one form to another form in c#

noreply@blogger.com (csharp) — Fri, 06 Dec 2013 16:31:00 +0000

Pass value from one form to another form in c#


 pass id from one form to another from in C#.


In Form1

private void ShowForm2()
{
    string value = TheTextBox.Text;
    Form2 newForm = new Form2();
    newForm.TheValue = value;
    newForm.ShowDialog();
}
In Form2

private string _theValue;
public string TheValue 
{ 
    get
    {
        return _theValue;
    }
    set
    {
        _theValue = value; 
        // do something with _theValue so that it
        // appears in the UI

    }
}