Programming Language Lovers

Free ASP.NET MVC project to learn for beginners

2015-09-01T18:24:00.001-07:00

Free ASP.NET MVC project to learn for beginners.

Download Learn And Share.

Download files from given link below.

https://onedrive.live.com/?cid=3d35297f653c11f2&id=3D35297F653C11F2%21190&ithint=folder,7z&authkey=!AIAUCC0SmdoCxDM

Please read the documents and then you can run the project on your system.

How to remove the .aspx from ASP.NET url's ? How to cut the URL's in short form

2014-03-15T13:33:00.000-07:00

Solution:-

Just put this piece of code in the Web Config file and be happy !!!!!!

<system.webServer>
<rewrite>
<rules>
<rule name="RewriteASPX">
<match url="(.*)" />
<conditions logicalGrouping="MatchAll">
<add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
<add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
</conditions>
<action type="Rewrite" url="{R:1}.aspx" />
</rule>
</rules>
</rewrite>
</system.webServer>

And just the page name in the link as it is for Example see this:-

<a href="Index.aspx">Sign in</a> 1.Don't use this

<a href="Index">Sign in</a> 1.Use this

Thanks ..:)

The type or namespace name 'Linq' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

2014-03-15T13:28:00.000-07:00

Problem in Web Config File :-

The type or namespace name 'Linq' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

Solution:-

Put this piece of code in the Configuration file and it will be solved..

<compilation debug="false">
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Web.Extensions.Design, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
</assemblies>
</compilation>

FreeProgrammingChapters Lucknow

2013-10-12T13:01:00.002-07:00

FreeProgrammingChapters Lucknow

https://www.facebook.com/groups/FreeProgrammingChapters/

Join us if you want to learn something new with us.

Contact us as:-

anuragsarkar19@gmail.com or Join our Facebook Group.

Sending Mail from Website Using PHP & HTML

2013-10-12T12:43:00.001-07:00

Here is the HTML Page Code:-

You can change the design of the HTML page since i am not providing you the CSS code of my page so you need to redisgn it.

<!DOCTYPE html>
<html lang="en">
    <head>
        <title></title>
          <link rel="stylesheet" href="css/reset.css" type="text/css" media="all">

<body>

<div class="" >
                                    <form name="contact" method="post" action="sendmail.php" id="form1" style="float:left; padding:0px" >
                                    <h2>Book a Room</h2>
                                        <fieldset>
                                            <div class="row">
                                                <input type="text" class="input" name="name">
                                                Your Name:

                                            </div>
                                            <div class="row">
                                                <input type="text" class="input" name="email">
                                                E-Mail Address:
                                            </div>
                                            <div class="row">
                                                <input type="text" class="input" name="telephone">
                                                Contact No.:
                                            </div>
                                            <div class="row">
                                                <input type="text" name="SelectedDate1" class="input" id="SelectedDate" readonly onClick="GetDate(this);" />
                                                Check In:
                                            </div>
                                            <div class="row">
                                                <input type="text" name="SelectedDate2" class="input" id="Text1" readonly onClick="GetDate(this);" />
                                                Check Out:
                                            </div>
                                            <div class="row">
                                                <input type="text" class="input" name="Place">
                                                Pick Up/Drop:
                                            </div>
                                            <div class="row_textarea">
                                                Additional Comments:
                                                <textarea cols="1" rows="1" name="comments"></textarea>
                                            </div>
                                            <div class="wrapper">
                                                <a href="#" class="button1" onClick="document.getElementById('form1').submit()">Send</a>
                                                <a href="#" class="button1" onClick="document.getElementById('form1').reset()">Clear</a>
                                            </div>
                                        </fieldset>
                                    </form>
                                                                    </div>
</form>

PHP Code:-

<?php
if(isset($_POST['email'])) {

    // EDIT THE 2 LINES BELOW AS REQUIRED
    $email_to = "hotelflightpath@gmail.com";
    $email_subject = "Booking Received";


    function died($error) {
        // your error code can go here
        echo "We are very sorry, but there were error(s) found with the form you submitted. ";
        echo "These errors appear below.<br /><br />";
        echo $error."<br /><br />";
        echo "Please go back and fix these errors.<br /><br />";
        die();
    }

    // validation expected data exists
    if(!isset($_POST['name']) ||
        !isset($_POST['email']) ||
        !isset($_POST['telephone']) ||
        !isset($_POST['comments'])) {
        died('We are sorry, but there appears to be a problem with the form you submitted.');
    }

    $name = $_POST['name']; // required
    $email_from = $_POST['email']; // required
    $telephone = $_POST['telephone']; // not required
    $comments = $_POST['comments']; // required
    $checkin=$_POST['SelectedDate1'];// required
    $checkout=$_POST['SelectedDate2'];// required
    $Place=$_POST['Place'];// required

    $error_message = "";
    $email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/';
if(!preg_match($email_exp,$email_from)) {
    $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
}
    $string_exp = "/^[A-Za-z .'-]+$/";
if(!preg_match($string_exp,$name)) {
    $error_message .= 'The First Name you entered does not appear to be valid.<br />';
}
   if(strlen($comments) < 2) {
    $error_message .= 'The Comments you entered do not appear to be valid.<br />';
}
if(strlen($error_message) > 0) {
    died($error_message);
}
    $email_message = "Form details below.\n\n";

    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }

    $email_message .= "First Name: ".clean_string($name)."\n";
    $email_message .= "Email: ".clean_string($email_from)."\n";
    $email_message .= "Telephone: ".clean_string($telephone)."\n";
    $email_message .= "Comments: ".clean_string($comments)."\n";
    $body="Mail Send";
    $msg='Name:-'. $_POST['name']."\n"
    .'Email:-'. $_POST['email']."\n"
    .'Contact No:-'.$_POST['telephone']."\n"
    .'Check In:-'.$_POST['SelectedDate1']."\n"
    .'Check Out:-'.$_POST['SelectedDate2']."\n"
    .'Place:-'.$_POST['Place']."\n"
    .'cOMMENTS:-'.$_POST['comments'];
    mail($email_to,$email_subject,$msg);

echo '<span style="color:#FFFFFF">Your E-mail has been sent !Thank you for contacting us. We will be in touch with you very soon.</span>';
   ?>

<?php
}
?>
This is the PHP Code. You need to create a file and name it as sendmail.php and paste the PHP code.
and create another page contact.HTML and paste the HTML code there. It will for the Web server but if you need to run it on Localhost you need to configure your SMTP server.
Thanks Any further suggestions are welcomed by you in comments.

Playing with JavaScript Adding & Dividing numbers using Java Script

2013-07-29T11:37:00.000-07:00

<!DOCTYPE html>
<html>
<body>
<p id="demo"></p>
Enter Number One<input type="text" name="no1" id="1"><br>
Enter Number Two<input type="text" name="no2" id="2"><br>
<button onclick="myadd()">Press</button>
<p id="dem"></p>
<script>
function myadd()
{
var y=document.getElementById("1");
var x=document.getElementById("2");
var a=y.value;
var b=x.value;
if(a=="")
{
alert("Please Enter No 1");
return
}
if(b=="")
{
alert("Please Enter No 2");
return
}
if(a==b)
{
alert("No cannot be Same");
return
}
else
{
var c=parseInt(a)+parseInt(b);
document.getElementById("demo").innerHTML="On Adding"+c;
var e=parseInt(b)/parseInt(a);
document.getElementById("dem").innerHTML="On Division"+e;
}}
</script>

</body>
</html>

Advice for Prgrammers

2013-06-13T00:59:00.002-07:00

Hi I am a Software Developer having one year of experience from India. I would like to tell you how to crack interviews. Interview depends on many things such as:-

Interview in Small Companies

1.First and important point is which company you are going for how much it is old and does it have any experienced employees?.

2.How much experience do you have?

3. What the company needs from you ?

As in my first point i asked how the company is? There are situation where the boss is Non Technical he does not has any knowledge about software or codes. So firstly he asks the developer how much experience does he have and what qualification does he have. Then he asks about what kinds of projects he has done. If you are satisfying his needs the you are selected and you are the first employee of the company luckily.

If he does have employees then they will take the interview they can ask anything they are good at so be prepared and be friendly them if you are able to impress them then you are selected.

In Small Companies if you can give you the output and can generate the income for them or say you can do projects at the given time then only they will give you money/salary. There are situations when small companies don't give salary at the time so don't get frustrated get the experience get the knowledge and then switch to good company according to you.

Interview in MNC

1.How big the company?.

2.How much experience do you have?

3. What the company needs from you ?

First Round:-

To crack a interview in MNC you have to be good at Basis and at the same time you have to be good at
application development. They will test the logic first by giving you simple problems in Data Structures , Al go, Oops Arrays etc so don't forgot to revise the basics if you to work in a good company.

Second Round:-

In this round they will test that you will fulfils their work or not. If they found you suitable and cleared all the rounds you are selected.

So to be a good programmer /developer don't ever forgot to work on basics at regular intervals Big companies will check that only the they will proceed further.

Waiting for Answers

2013-06-13T00:23:00.001-07:00

http://onurag-dotnetfunda.blogspot.in/p/interview-questions-answers.html

Please Check Interview Question page for details.

Send Sms from ASP.NET Website using Full On Sms

2013-05-26T14:58:00.001-07:00

ASPX CODE
-----------------------------------------------------------------------------------------------------------------------------------------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Send Sms</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server" Text="Mobile No"></asp:Label>    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <br />
        <asp:Label ID="Label2" runat="server" Text="Message"></asp:Label>
          
        <asp:TextBox ID="TextBox2" runat="server" TextMode="MultiLine"></asp:TextBox>
        <br />
           
        <asp:Button ID="Button1" runat="server" Text="Send Sms"
            onclick="Button1_Click" />

    </div>
    </form>
</body>
</html>
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

CS CODE
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
using System;
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;
using System.Net;

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

string uid;
string password;
string message;
string no;

    protected void Page_Load(object sender, EventArgs e)
    {

    }
    public void send()
    {
    HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create("http://ubaid.tk/sms/sms.aspx?uid=" + uid + "&pwd=" + password + "&msg=" + message + "&phone=" + no + "&provider=fullonsms");
    HttpWebResponse myResp = (HttpWebResponse)myReq.GetResponse();
    System.IO.StreamReader respStreamReader = new System.IO.StreamReader(myResp.GetResponseStream());
    string responseString = respStreamReader.ReadToEnd();
    respStreamReader.Close();
    myResp.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            uid = "";
            password = "";
            message = TextBox2.Text;
            no = TextBox1.Text;
            send();
            TextBox2.Text ="";
            TextBox1.Text="";
        }
        catch(Exception ex )
        {
            ex.Message.ToString();
        }
    }
}

Please Download

http://www.c-sharpcorner.com/UploadFile/ANURAGSARKAR19/send-sms-from-Asp-Net-using-way2sms/

CSS3 SHAPES

2013-05-26T14:55:00.002-07:00

You can use these shapes in any html control like text area , buttons , grids etc.

SQUARE

#square {
width: 140px; 
height: 140px; 
background: blue; 
}

CIRCLE

#circle { 
width: 140px;
height: 140px;
background: blue; 
-moz-border-radius: 70px; 
-webkit-border-radius: 70px; 
border-radius: 70px;
}

OVAL
#oval {
width: 200px; 
height: 100px; 
-moz-border-radius: 100px / 50px; 
-webkit-border-radius: 100px / 50px; 
border-radius: 100px / 50px;
}

you can use the oval shape in text area .

ROUNDED CORNER
#rc 
{
border:display:solid;
border-radius: 5px;
   border-width:1px;
 }

you can use this in text area .

SPEECH BLUE
#speech-bubble {
width: 120px; 
height: 80px; 
background: blue;
position: absolute;
-moz-border-radius: 10px; 
-webkit-border-radius: 10px; 
border-radius: 10px;
}
#speech-bubble:before {
content:"";
position: absolute;
width: 0;
height: 0;
border-top: 13px solid transparent;
border-right: 26px solid blue;
border-bottom: 13px solid transparent;
margin: 13px 0 0 -25px;
}

you can use speech blue to show messages if text boxes are left blank

Logical vs. Physical Separation Software Development

2013-05-02T00:37:00.002-07:00

Logical Separation refers to:
Code organization Namespaces, classes, folders, and assembliesSoftware design pattern

Physical Separation refers to:
Infrastructure organization Separate physical processes, machines, devicesSoftware architecture

By- Vidya Vrat Agarwal.

Dynamically Login in Crystal Report

2013-04-13T00:04:00.001-07:00

Here I am going to show you how to dynamically login in Crystal Reports. Sometimes developer faces the issue that he has to provide server name and etc this code will help you to remove those exceptions in applications.

TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();                 TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
Tables CrTables;
ConnectionInfo Cr = new ConnectionInfo();
Cr.ServerName = "";//here you should provide your Server Name
Cr.DatabaseName = "";//here you should provide your Database Name
Cr.UserID = "";//here you should provide your User Name
Cr.Password = "";//here you should provide your Password
CrTables = Ip.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = Cr;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
crystalReportViewer1.ReportSource = Ip;

In this code I have created a crystal report and created its object IP and used that in the report source.

Saving Data Using DataGridview and Doing Calculations in it Billing Software & Inventory Software

2013-03-18T11:10:00.000-07:00

Introduction

Billing and Invoicing Software Included. Calculations in Data Grid view for billing software and calculating total at the last.

Hi there are many programmers who face the problem into creating Invoicing and Billing Software this will help them to save the data(Items via DataGridview) in database. And this is for those basic programmers who don't know how to save data using DataGridview in Window Forms using C# and SQL SERVER. Download Sample

Code For Saving Data In Database( MS SQL SERVER ) via DataGridview

Here i have created a function for collecting the information entered by the use and after that he can save all that information in the database.

void Save()

{

try

{

if (dataGridView1.Rows.Count > 1)

{

for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++)

{

string col1 = dataGridView1.Rows[i].Cells[0].Value.ToString();

string col2 = dataGridView1.Rows[i].Cells[1].Value.ToString();

string col3 = dataGridView1.Rows[i].Cells[2].Value.ToString();

string col4 = dataGridView1.Rows[i].Cells[3].Value.ToString();

string col5 = dataGridView1.Rows[i].Cells[4].Value.ToString();

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString))

{

string insert = "INSERT INTO InvoiceItems(SNo,Quantity,Rate,Description,Total) VALUES (@SNo,@Quantity,@Rate,@Description,@Total)";

con.Open();

SqlCommand cmd = new SqlCommand(insert, con);

cmd.Parameters.AddWithValue("@SNo", col1.ToString());

cmd.Parameters.AddWithValue("Description", col2.ToString());

cmd.Parameters.AddWithValue("@Quantity", col3.ToString());

cmd.Parameters.AddWithValue("@Rate", col4.ToString());

cmd.Parameters.AddWithValue("Total", col5.ToString());

cmd.ExecuteNonQuery();

con.Close();

}

catch (Exception ex)

{

ex.Message.ToString();

}

Code For Doing Calculations In DataGridview

Code will be done at the CellEndEdit Event of the Datagridview.So when user clicks on next column the value gets calculated. The total net amount also gets calculated automatically at the cellend event of the gridview.Column Index No refers the values which is to be multipled. Here i have multiplied 2nd & 3rd column and the value is achieved in 4th column.

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs)

{

try

{

if (e.ColumnIndex == 2 || e.ColumnIndex == 3)

{

double cell1 = Convert.ToSingle(dataGridView1.CurrentRow.Cells[2].Value);

double cell2 = Convert.ToSingle(dataGridView1.CurrentRow.Cells[3].Value);

if (cell1.ToString() != "" && cell2.ToString() !="")

{

dataGridView1.CurrentRow.Cells[4].Value = cell1 * cell2;

}

label17.Visible = true;

decimal tot = 0;

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

{

tot += Convert.ToDecimal(dataGridView1.Rows[i].Cells[4].Value);

}

txt_netamoun.Text = tot.ToString();

}

catch(Exception ex)

{

MessageBox.Show(ex.ToString());

}

All these thing i learned when i started working on Billing Software.This is all for a beginner.

Thanks Hope you will like this.

How to access My Sql using CMD (Command Line)

2013-01-17T05:27:00.001-08:00

Use these commands:-

1.Open Cmd->

2.Type Cd\program files\mysql->

3.Then type Cd\program files\mysql\mysql server 5.0\bin->

4.Then type :-mysql -u root -h localhost -p .

5.Then type password.

Then you can use it.

Here the screen shot for this:-

How to save image path in database using My Sql & C- Sharp

2013-01-14T11:57:00.000-08:00

In this article I will explain how to save images into a MySQL database in Windows Forms applications using C#.

Introduction

In this article first we will create a table in a MySQL database and then we will use a Windows Forms application to save an image into the database.

Description:-

Create a table in a MySQL database using MySQL browser as in the following. To store the image:

Script for the table:-

CREATE TABLE `image` (
          `name` varchar(100) default NULL,
          `type` varchar(100) default NULL,
          `desc` varchar(100) default NULL,
          `docname` varchar(5000) default NULL,
          `docdisc` varchar(500) default NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=latin1

Create a new Windows Forms application and arrange controls on the form as in the following:

Add a reference to the MySql.Data dll using the Add Reference dialog box and include the following two namespaces:

using MySql.Data.MySqlClient;

using System.IO;

Write the following code in the Click event of PictureBox to select an image to save in the database:

        //The String used to store the location of the file that is currently loaded in the picture box picFile
        String location;
        //The String used to store the name of the file that is currently loaded in the picture box picFile
        String fileName;

private void Browse_Click(object sender, EventArgs e)

{

            openPic.Filter = "JPeg Image|*.jpg|Bitmap Image|*.bmp|Gif Image|*.gif";
            //Showing the fileopen dialog box
            openPic.ShowDialog();
            //showing the image opened in the picturebox
            pictureBox1.BackgroundImage = new Bitmap(openPic.FileName);
            //storing the location of the pic in variable
            location = openPic.FileName;
            textBox2.Text = location;
            //storing the filename of the pic in variable
            fileName = openPic.SafeFileName;

}

Write the following code in the Click event of the btnSave Button:

private void btn_SaveImage_Click(object sender, EventArgs e)

{

MySqlConnection con = new MySqlConnection(ConString);

MySqlCommand cmd;

FileStream fs;

BinaryReader br;

   try
            {
                //Creating a filestream to open the image file
                FileStream fs = new FileStream(location, FileMode.Open, FileAccess.Read);
                //Getting the legth of the fil in bytes
                int fileLength = (int)fs.Length;
                //creating an array to store the image as bytes
                byte[] rawdata = new byte[fileLength];
                //using the filestream and converting the image to bits and storing it in
                //an array
                fs.Read(rawdata, 0, (int)fileLength);
                //Creating a new mysql command object which will be used to store the image
                MySqlCommand cmd = new MySqlCommand();
                //creating sql command
                String sql = "insert into doc1 values(@pfno,@depname,@doctype,@docdesc,@docexpdate,@docname,@docdisc)";
                //Connection
                con = new MySqlConnection();
                con.ConnectionString = ConfigurationSettings.AppSettings["constr"];
                con.Open();
                //Setting the connection of the command
                cmd = new MySqlCommand(sql, con);
                //setting the sql of the command
                //cmd.CommandText = sql;
                //Setting up the parameter values to be used when storing the image to a
                //table
                //cmd.Parameters.AddWithValue("@docsize", rawdata);
                cmd.Parameters.AddWithValue("@name", label8.Text);
                cmd.Parameters.AddWithValue("@type", comboBox1.Text);
                cmd.Parameters.AddWithValue("@desc", textBox1.Text);
                cmd.Parameters.AddWithValue("@docname", textBox2.Text);
                cmd.Parameters.AddWithValue("@docdisc", fileLength);
                //Executing the query and writing the image to the database
                cmd.ExecuteNonQuery();
                //Closing the filestream
                con.Close();
                MessageBox.Show("Done");
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

}

The comments are given in // block.

How to Create ProgressBar Column in DataGridView

2013-01-09T13:09:00.001-08:00

Thanks

Useful (3.5).NET links......

2013-01-09T13:07:00.001-08:00

N Tier Architecture & ORM Technologies

http://www.codeproject.com/Articles/48292/Three-tier-NET-Application-Utilizing-Three-ORM-Tec

http://www.codeproject.com/Articles/434282/A-N-Tier-Architecture-Sample-with-ASP-NET-MVC3-WCF

http://www.codeproject.com/Articles/11128/3-tier-architecture-in-C

Beginners guide to a secure way of storing passwords

http://www.codeproject.com/Articles/425150/Beginners-guide-to-a-secure-way-of-storing-passwor

Thanks

Windows Form Programming Using C#

2012-10-27T01:08:00.003-07:00

Windows Form Programming for Begginers Using C#

Check This out :-

1.) http://www.codeproject.com/Articles/2448/Windows-Forms-Programming-with-C-Chapter-3-Menus

By:- Erik Brown

2.)http://www.c-sharpcorner.com/uploadfile/mamta_m/windows-forms-events-lifecycle/

By:- Mamta M

3.) Top 10 Articles on Windows Form

By:- Dot Net Curry

Delegate Part 2

2012-10-26T00:38:00.001-07:00

In Delegate Part 1 :-I have explained how to declare a delegate and create an instance of it and use it. Now i am going to explain Multicast Delegate.

We can also create a delegate which can point to multiple functions and methods. If we invoke such delegate it will invoke all the methods and functions associated with the same one after another sequentially.In order to add multiple methods and function we need to use ‘+=’ symbols. Now if we invoke the delegate it will invoke ‘Method1’ first and then ‘Method2’. Invocation happen in the same sequence as the attachment is done.

// Associate method1
mydelegate += Method1;
// Associate Method2
mydelegate += Method2;
// Invoke the Method1 and Method2 sequentially
mydelegate.Invoke();

.....

How to Export Data Of DataGridview To Excel using C# Windows Appllication

2012-10-04T05:24:00.002-07:00

Namespaces

Function For Exporting To Excel

private void ToCsV(DataGridView data, string file)

        {
            string stOutput = "";
            string sHeaders = "";

            for (int j = 0; j < data.Columns.Count; j++)
                sHeaders = sHeaders.ToString() + Convert.ToString(dataColumns[j].HeaderText) + "\t";
            stOutput += sHeaders + "\r\n";

            for (int i = 0; i < dataRowCount - 1; i++)
            {
                string stLine = "";
                for (int j = 0; j < data.Rows[i].Cells.Count; j++)
                    stLine = stLine.ToString() + Convert.ToString(data.Rows[i].Cells[j].Value) + "\t";
                stOutput += stLine + "\r\n";
            }
            Encoding utf16 = Encoding.GetEncoding(1254);
            byte[] output = utf16.GetBytes(stOutput);
            FileStream fs = new FileStream(filename, FileMode.Create);
            BinaryWriter bw = new BinaryWriter(fs);
            bw.Write(output, 0, output.Length);
            bw.Flush();
            bw.Close();
            fs.Close();
        }

Code For Button On Export To Excel

            SaveFileDialog sfd = new SaveFileDialog();

            sfd.Filter = "Excel Documents (*.xls)|*.xls";

            sfd.FileName = "export.xls";

            if (sfd.ShowDialog() == DialogResult.OK)
            {

                ToCsV(dataGridView1, sfd.FileName);
            }

Delegate Part 1

2012-07-10T06:59:00.000-07:00

In this article, I will explain delegates and their usage with the help of simple C# programs.
What is a Delegate?

Delegate is a type which holds the method(s) reference in an object. It is also referred to as a type safe function pointer.

Advantages

Encapsulating the method's call from caller
Effective use of delegate improves the performance of application
Used to call a method asynchronously

//Declaration

public delegate void mydelegate();

//Program using System;

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

namespace Delegates
{
    public delegate int mydelegate(int a, int b);

    class Program
    {
        static int fn_Prodvalues(int val1, int val2)
        {
            return val1 + val2;
        }
        static void Main(string[] args)
        {

//Creating the Delegate Instance

mydelegate delObj = new mydelegate(fn_Prodvalues);

            Console.Write("Please Enter Values");
            int v1 = Int32.Parse(Console.ReadLine());
            int v2 = Int32.Parse(Console.ReadLine());

//use a delegate for processing

int res = delObj(v1, v2);

            Console.WriteLine("Result :" + res);
            Console.ReadLine();
        }
    }
}

Output:-

Enter Two Values 5
2
Result : 7

Note

    You can use delegates without parameters or with parameter list
    You should follow the same syntax as in the method
    (If you are referring to the method with two int parameters and int return type, the delegate which you are declaring should be in the same format. This is why it is referred to as type safe function pointer.)

Here I have used a small program which demonstrates the use of delegate.

The delegate "mydelegate" is declared with double return type and accepts only two integer parameters.

Inside the class, the method named fn_Prodvalues is defined with double return type and two integer parameters. (The delegate and method have the same signature and parameter type.)

Inside the Main method, the delegate instance is created and the function name is passed to the delegate instance as follows:

mydelegate delObj = new mydelegate(int a , int b);

After this, we are accepting the two values from the user and passing those values to the delegate as we do using method:

delObj(v1,v2);

Here delegate object encapsulates the method functionalities and returns the result as we specified in the method.

Inheritance & Polymorphism (Part 1)

2012-04-12T14:41:00.001-07:00

Its always nice to re-use something instead of creating it again & again. Since c-sharp is a pure Oop's oriented language its supports re-usability. To achieve re-usability we must create classes from existing one's. The process through which we can achieve this is known as Inheritance.It can be achieved in two ways

1.)Classical form.
2.)Containment form.

Inheritance represents represents a class of relationship b/w two classes

1.)Classical Inheritance:-

Simple Inheritance

2.)Containment Inheritance:-

Multiple Inheritance

Defining A Sub Class

Class subclass-name : base class

{

variables dec;

methods dec;

}

Ado.Net For Begginers -Connecting & Inserting Data To DataBase

2012-04-10T06:12:00.000-07:00

Insertion Data In windows Form by Ado.Net For Begginers (Connecting & Inserting Data To DataBase<br /> By Using Try Catch Block & Sql Connection & Command Class Objects & Insert Command <br /> <br />Insertion Data In windows Form by Ado.Net For Begginers -Connecting & Inserting Data To DataBase By Using Try Catch Block Sql Connection & Command Class Objects & Insert Command

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;
namespace AcceptButton
{
      public partial class Registration : Form
    {
        //Oblects for sql class
        SqlConnection cm;
        SqlCommand cmd ;
        public Registration()
        {
            //Connection String
            cm = new SqlConnection();
            cm.ConnectionString="Data Source=ONU-PC;Initial Catalog=AcceprtButton;User ID=sa; password=12345";
            cmd=new SqlCommand();
            cmd.Connection=cm;

            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //Object of form 1
            Form1 fr = new Form1();
            fr.Show();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Application.Exit();

        }

        private void button9_Click(object sender, EventArgs e)
        {
                        try
            {
                cmd.CommandText = "insert into Ab values ( @username, @password ,@email,@Name ,@Mobileno)";
                cmd.Parameters.AddWithValue("@username", textBox1.Text);
                cmd.Parameters.AddWithValue("@password", textBox2.Text);
                cmd.Parameters.AddWithValue("@email", textBox4.Text);
                cmd.Parameters.AddWithValue("@Name", textBox5.Text);
                cmd.Parameters.AddWithValue("@Mobileno", textBox6.Text);
                cm.Open();
                if (cmd.ExecuteNonQuery() > 0)
                {
                    MessageBox.Show("Success");
                }
                else
                {
                    MessageBox.Show("Failed");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Sry Exception");
            }
            finally
           {

            cm.Close();
           }
        }

        private void Registration_Load(object sender, EventArgs e)
        {

        }
    }
}
In this MemReg:-Button 9
& Exit:-Button2

List Box In Window Form Using C#

2012-04-05T01:31:00.003-07:00

Simple Example Of List Box For Beginners

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

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

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (listBox1.Items.Count > 0)
                {
                    listBox2.Items.Add(listBox1.SelectedItem.ToString());
                    listBox1.Items.Remove(listBox1.SelectedItem);
                }
            }
            catch (Exception exx)
            {
                MessageBox.Show(exx.Message);
            }
            if (listBox1.Items.Count > 0)
            {
                listBox1.SelectedIndex = 0;
                listBox2.SelectedIndex = listBox2.Items.Count - 1;
            }

        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            listBox1.Text = "";

        }

        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                if(listBox2.Items.Count>0)
                {
                    listBox1.Items.Add(listBox2.SelectedItem.ToString());
                    listBox2.Items.Remove(listBox2.SelectedItem);
                }
            }
            catch(Exception Exx)
            {
                MessageBox.Show(Exx.Message);
            }
            if(listBox2.Items.Count>0)
            {
                listBox2.SelectedIndex=0;
                listBox2.SelectedIndex=listBox2.Items.Count-1;
            }

        }
    }
}

Screen Shots:-

Implementing Reading From the Text Files(File Input Output Operations)

2012-03-09T13:12:00.000-08:00

Implementing File Input Output Operations In C#.

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

namespace FileInputOutput
{
    class Program
    {
        public void readdata()
        {
            FileStream fs = new FileStream("Myfile.txt", FileMode.Open, FileAccess.Read);
            StreamReader sr = new StreamReader(fs);
            sr.BaseStream.Seek(0, SeekOrigin.Begin);
            string str = sr.ReadLine();
            while (sr != null)
            {
                Console.Write("{0}", str);
                str = sr.ReadLine();

            }
            sr.Close();
            fs.Close();
        }
        static void Main(string[] args)
        {
            Program fr = new Program();
            fr.readdata();
        }
    }
}

Output:--

Programming Language Lovers

Free ASP.NET MVC project to learn for beginners

How to remove the .aspx from ASP.NET url's ? How to cut the URL's in short form

Solution:-

The type or namespace name 'Linq' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

Problem in Web Config File :-

The type or namespace name 'Linq' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

Solution:-

FreeProgrammingChapters Lucknow

Sending Mail from Website Using PHP & HTML

Playing with JavaScript Adding & Dividing numbers using Java Script

Advice for Prgrammers

Interview in Small Companies

Interview in MNC

So to be a good programmer /developer don't ever forgot to work on basics at regular intervals Big companies will check that only the they will proceed further.

Waiting for Answers

Send Sms from ASP.NET Website using Full On Sms

CSS3 SHAPES

Logical vs. Physical Separation Software Development

Dynamically Login in Crystal Report

Saving Data Using DataGridview and Doing Calculations in it Billing Software & Inventory Software

Billing and Invoicing Software Included. Calculations in Data Grid view for billing software and calculating total at the last.

How to access My Sql using CMD (Command Line)

How to save image path in database using My Sql & C- Sharp

In this article I will explain how to save images into a MySQL database in Windows Forms applications using C#.

Introduction

Description:-

Script for the table:-

CREATE TABLE `image` ( `name` varchar(100) default NULL, `type` varchar(100) default NULL, `desc` varchar(100) default NULL, `docname` varchar(5000) default NULL, `docdisc` varchar(500) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1

Create a new Windows Forms application and arrange controls on the form as in the following:

Add a reference to the MySql.Data dll using the Add Reference dialog box and include the following two namespaces:

using MySql.Data.MySqlClient;

using System.IO;

Write the following code in the Click event of PictureBox to select an image to save in the database:

//The String used to store the location of the file that is currently loaded in the picture box picFile String location; //The String used to store the name of the file that is currently loaded in the picture box picFile String fileName;

Write the following code in the Click event of the btnSave Button:

How to Create ProgressBar Column in DataGridView

How to Create ProgressBar Column in DataGridView

CodeProject Frequently Asked Questions Series 1: The ASP.NET GridView

GridView column header merging in ASP.NET

Thanks

Useful (3.5).NET links......

http://www.codeproject.com/Articles/48292/Three-tier-NET-Application-Utilizing-Three-ORM-Tec

http://www.codeproject.com/Articles/434282/A-N-Tier-Architecture-Sample-with-ASP-NET-MVC3-WCF

http://www.codeproject.com/Articles/11128/3-tier-architecture-in-C

Beginners guide to a secure way of storing passwords

http://www.codeproject.com/Articles/425150/Beginners-guide-to-a-secure-way-of-storing-passwor

Windows Form Programming Using C#

Delegate Part 2

How to Export Data Of DataGridview To Excel using C# Windows Appllication

Namespaces

Function For Exporting To Excel

Code For Button On Export To Excel

Delegate Part 1

//Creating the Delegate Instance

mydelegate delObj = new mydelegate(fn_Prodvalues);

//use a delegate for processing

int res = delObj(v1, v2);

Inheritance & Polymorphism (Part 1)

1.)Classical Inheritance:-

2.)Containment Inheritance:-

Defining A Sub Class

Class subclass-name : base class

{

variables dec;

methods dec;

}

Ado.Net For Begginers -Connecting & Inserting Data To DataBase

List Box In Window Form Using C#

Simple Example Of List Box For Beginners

Implementing Reading From the Text Files(File Input Output Operations)

CREATE TABLE `image` (
`name` varchar(100) default NULL,
`type` varchar(100) default NULL,
`desc` varchar(100) default NULL,
`docname` varchar(5000) default NULL,
`docdisc` varchar(500) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

//The String used to store the location of the file that is currently loaded in the picture box picFile
String location;
//The String used to store the name of the file that is currently loaded in the picture box picFile
String fileName;