Gohil Infotech

Display Current date in griedview

2013-09-11T04:58:00.001-07:00

Introduction:

Here i will explain how to display current date in griedview.

Description:

Most of the very useful in the griedview to show current date.

Example:

Multiple Rows Delete in a GridView in ASP.Net

2013-09-11T04:51:00.000-07:00

Introduction:

Here i will explain how to Multiple Rows Delete in a GridView in ASP.Net.

Description:

While fetching data from SQL tables to a webpage, adding data source to the GridView comes foremost. The next big thing is to provide an interface to the user so that data can be accessed, updated, removed in lesser clicks.The lesser the process is hectic, more user friendly our interface becomes.

Example:

 
<asp:gridview datakeynames="empid" datasourceid="SqlDataSource1" id="GridView1" runat="server">

       <columns>

           <asp:templatefield>

                <itemtemplate>

                <asp:checkbox id="chk" onclick="Check_Click(this)" runat="server">

                </asp:checkbox></itemtemplate>

            </asp:templatefield>

 <asp:boundfield datafield="empid" headertext="empid" insertvisible="False" readonly="True" sortexpression="empid">

            <asp:boundfield datafield="name" headertext="name" sortexpression="name">

            <asp:boundfield datafield="password" headertext="password" sortexpression="password">

            <asp:boundfield datafield="city" headertext="city" sortexpression="city">

            <asp:boundfield datafield="country" headertext="country" sortexpression="country">

        </asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield>
</columns>

</asp:gridview>

 protected void btnDelete_Click(object sender, EventArgs e)

{

        SqlConnection con = new SqlConnection(@"Data Source=(local);Initial Catalog=Employee;Integrated Security=True");

        con.Open();

        int count = 0;

        for (int i = 0; i < GridView1.Rows.Count; i++)

        {

        CheckBox chk = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("chk");

            if (chk.Checked)

            {

                string id = GridView1.DataKeys[i].Value.ToString();

                SqlCommand cmd = new SqlCommand("delete from users where empid='"+id+"'", con);

                cmd.ExecuteNonQuery();

                count++;

            }

        }

        Response.Write("");

        con.Close();

DataBind();

}

Create a Simple and Stylish Calculator Using HTML, CSS and JavaScript

2013-09-07T05:08:00.000-07:00

Introduction:

Here i will explain Create a Simple and Stylish Calculator Using HTML, CSS and JavaScript.

Description:

In this article, we will create a calculator step-by-step. We need to create a basic structure using HTML, style it using CSS and make it work using JavaScript.

HTML:

CSS:

body
{
background-color:tan;
}
.box
{
background-color:#3d4543;
height:300px;
width:250px;
border-radius:10px;
position:relative;
top:80px;
left:40%;
}
.display
{
background-color:#222;
width:220px;
position:relative;
left:15px;
top:20px;
height:40px;
}
.display input
{
position:relative;
left:2px;
top:2px;
height:35px;
color:black;
background-color:#bccd95;
font-size:21px;
text-align:right;
}
.keys {
position:relative;
top:15px;
}
.button {
width:40px;
height:30px;
border:none;
border-radius:8px;
margin-left:17px;
cursor:pointer;
border-top:2px solid transparent;
}
.button.gray {
color:white;
background-color:#6f6f6f;
border-bottom:black 2px solid;
border-top:2px #6f6f6f solid;
}
.button.pink {
color:black;
background-color:#ff4561;
border-bottom:black 2px solid;
}
.button.black {
color:white;
background-color:303030;
border-bottom:black 2px solid;
border-top:2px 303030 solid;
}
.button.orange {
color:black;
background-color:FF9933;
border-bottom:black 2px solid;
border-top:2px FF9933 solid;
}
.gray:active {
border-top:black 2px solid;
border-bottom:2px #6f6f6f solid;
}
.pink:active {
border-top:black 2px solid;
border-bottom:#ff4561 2px solid;
}
.black:active {
border-top:black 2px solid;
border-bottom:#303030 2px solid;
}
.orange:active {
border-top:black 2px solid;
border-bottom:FF9933 2px solid;
}
p {
line-height:10px;
}

SCRIPT:

function c(val)
{
 document.getElementById("d").value=val;
}
    function v(val)
{document.getElementById("d").value+=val;
}
function e() 
{ 
    try 
    { 
        c(eval(document.getElementById("d").value)) 
    } 
    catch(e) 
    {
        c('Error') } 
}

Create an Auto Complete List Like Google Using jQuery

2013-09-07T04:57:00.001-07:00

Introduction:

Here i will explain Create an Auto Complete List Like Google Using jQuery

Description:

On many sites you must have seen that whenever you start writing in any TextBox then it starts showing the predicted and related results that allow you to choose from a number of available options. The best example is Facebook's Friends Finder and of course Google.

Example:

Step 1

First of all you need to create a database in which all the country names are to be entered.

Step 2

After that you need to add jQuery 1.8.3 js and Jquery-ui. js file to your application.You can either download my Zip Code and retrieve both the jQuery files from there or can search for them on Google and can download them from another site.

<html>
<head runat="server">

    <title>Auto Complete List </title>

    <link rel="stylesheet" href="css/jquery-ui.css" />

 

    <script src="js/jquery-1.8.3.js" type="text/javascript" ></script>

    <script src="js/jquery-ui.js" type="text/javascript" ></script>

 

    <script type="text/javascript">

    function LoadList()

    {       

        var ac=null;

        ac = <%=listFilter %>;

            $( "#Country" ).autocomplete({

              source: ac

            });

    }

    </script>

 

</head>

<body onload="LoadList()">

    <form id="form1" runat="server">

        <h2>

           Auto Complete List</h2>

        <div class="auto-complete">

            <label for="tags">

                Type Country Name:

            </label>

            <input id="Country" />

        </div>

    </form>

</body>

</html>

Download Code File

Send SMS using Modem(GSM Dongle) in C#

2013-09-03T04:44:00.002-07:00

Introduction:

Here i will explain Send SMS using Modem(GSM Dongle) in C#.

Description:

today we will discuss a very important topic, sending SMS alerts to a mobile phone that is a common demand of most clients. So we developed a small application that runs on the server and sends a SMS whenever a new record is inserted into the database from any client.

In this application we will use the following:

GSM Modem (I have used Vodafone; you can use any)
SIM Card.

Create the table in SQL Server.

CREATE TABLE [dbo].[Donor_Profile](

      [Don_Date] [datetime] NULL,

      [Don_Donor_ID] [varchar](20) NOT NULL,

      [Don_Donor_Name] [varchar](50) NULL,

[Don_Mobile_Phone] [varchar](50) NULL,

      [Don_Member] [varchar](10) NULL,

      [Don_SMS1] [varchar](10) NULL,

      [Don_SMS2] [varchar](10) NULL,

      [Don_Logo] [image] NULL,

      [Don_Donor_Type] [int] NULL,

 CONSTRAINT [PK_Donor_Profile] PRIMARY KEY CLUSTERED

(

      [Don_Donor_ID] ASC

)
WITH (PAD_INDEX  = OFF,
STATISTICS_NORECOMPUTE  = OFF,
IGNORE_DUP_KEY = OFF, 
ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

)
ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Now you can insert any record in the table but please make sure to insert: [Don_Donor_ID]= CF-00001-12 and leave the [Don_SMS1], [Don_SMS2] field NULL, [Don_Mobile_Phone] please enter valid phone number where you want to recive the sms. Create the new Desktop application. Design the form as shown in the picture.

Step 5

Dear Reader, please read this carefully in thais step we need to include the following DLL files in the bin\ Debug folder:

GSMCommServer.dll
GSMCommShared.dll
GSMCommunication.dll
PDUConverter.dll

Step 6

Now we need to add the reference to the project as shown in the picture.

Now we have added one more reference.

Now we need to move to the code behind window and use these references in the code.

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.Text.RegularExpressions;

using System.Runtime.Remoting.Channels;
using System.Runtime.Remoting.Channels.Tcp;
using GsmComm.PduConverter;
using GsmComm.PduConverter.SmartMessaging;
using GsmComm.GsmCommunication;
using GsmComm.Interfaces;
using GsmComm.Server;
using System.Globalization;

namespace GSMModem
{
    public partial class Form1 : Form
    {
        private GsmCommMain comm;
        private delegate void SetTextCallback(string text);
        private SmsServer smsServer;
        public Form1()
        {
            InitializeComponent();
        }

Now we need to add few textboxes and private variables that we will use in our code.

namespace GSMModem
{
    public partial class Form1 : Form
    {
        private GsmCommMain comm;
        private delegate void SetTextCallback(string text);
        private SmsServer smsServer;
        public Form1()
        {
            InitializeComponent();
        }
        TextBox txtMessage = new TextBox();
        TextBox txtDonorName = new TextBox();
        TextBox txtNumber = new TextBox();
        TextBox txtDonorId = new TextBox();

Now we will add the two classes Operation and Main as in the following and add two methods in it GetDBConnection, ipconfig and Execute.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace GSMModem
{
    class Operation
    {
        public string ipconfig(string filePath)
        {
            StreamReader streamReader = new StreamReader(filePath);
            string text = streamReader.ReadToEnd();
            streamReader.Close();
            return text;
        }

        public void Execute(string SQL)
        {
                SqlConnection con = Main.GetDBConnection();
                con.Open(); 
                SqlCommand cmd = new SqlCommand(SQL, con);
                cmd.ExecuteNonQuery();
        }
    }
}

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

namespace GSMModem
{
    class Main
    {
        public static SqlConnection GetDBConnection()
        {
            Operation ipconf = new Operation();
            string path = Directory.GetCurrentDirectory();
            string path1 = ipconf.ipconfig(path + "\\" + "IPCONfG.txt");
            string strerverIP = path1;

            // Define the Access Database driver and the filename of the database
            SqlConnection conn = new SqlConnection(
        "Data Source=" + strerverIP + @"\CRMIS;Initial Catalog=PSH;User ID=sa;Password=sa12345");
            return conn;
        }
    }
}

Now add the following code in the form load event.

private void Form1_Load(object sender, EventArgs e)
        {
            cmbCOM.Items.Add("COM1");
            cmbCOM.Items.Add("COM2");
            cmbCOM.Items.Add("COM3");
            cmbCOM.Items.Add("COM4");
            cmbCOM.Items.Add("COM5");
            cmbCOM.Items.Add("COM6");
        }

Now add the following code in the connect button click event.

 
private void btnConnect_Click(object sender, EventArgs e)
        {
            if (cmbCOM.Text == "")
            {
                MessageBox.Show("Invalid Port Name");
                return;
            }
             comm = new GsmCommMain(cmbCOM.Text , 9600, 150);
            Cursor.Current = Cursors.Default;
            bool retry;
            do
            {   retry = false;
                try
                {   Cursor.Current = Cursors.WaitCursor;
                    comm.Open();
                    Cursor.Current = Cursors.Default;
                    MessageBox.Show("Modem Connected Sucessfully");
                }
                catch (Exception)
                {   Cursor.Current = Cursors.Default;
                    if (MessageBox.Show(this, "GSM Modem is not available", "Check",
                        MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning) == DialogResult.Retry)
                        retry = true;
                    else
                   { return;}
               }
            }
            while (retry);

        }

Now add the following code in the send button click event.

private void btnSend_Click(object sender, EventArgs e)
        {
            Operation code = new Operation();
            try
            {
                SqlConnection con = Main.GetDBConnection();
                DataTable consultanttable = new DataTable();
                string sqlConsultant = @"SELECT  Don_Donor_ID,Don_Donor_Name,left(Don_Mobile_Phone,4)+ right(Don_Mobile_Phone,7) 
                FROM  psh.dbo.Donor_Profile WHERE (Don_SMS1 IS NULL) or (Don_SMS1='notsend') and Don_Donor_ID ='CF-00001-12'";
                SqlDataAdapter Consultantdataadapter = new SqlDataAdapter(sqlConsultant, con);
                Consultantdataadapter.Fill(consultanttable);
                foreach (DataRow myrow in consultanttable.Rows)
                {
                    txtDonorId.Text = Convert.ToString(myrow[0]);
                    txtDonorName.Text = Convert.ToString(myrow[1]);
                    txtNumber.Text = Convert.ToString(myrow[2]);
                    Cursor.Current = Cursors.WaitCursor;
                    txtMessage.Text = "Respected " + txtDonorName.Text + ", Welcome to Clapp Trust. Your donor ID is " + txtDonorId.Text + ". Our online system will send you SMS whenever your donation is received.";
                    try
                    {
                        SmsSubmitPdu pdu;
                        byte dcs = (byte)DataCodingScheme.GeneralCoding.Alpha7BitDefault;
                        pdu = new SmsSubmitPdu(txtMessage.Text, Convert.ToString(txtNumber.Text), dcs);
                        int times = 1;
                        for (int i = 0; i < times; i++)
                        {
                            comm.SendMessage(pdu);
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Modem is not available");
                        code.Execute("update psh.dbo.donor_profile set don_sms2='notsend' where don_donor_id ='" + txtDonorId.Text + "'");
                    }
                }
            }
            catch
            {
                MessageBox.Show("SMS not send");
            }

        }

Now we need to attach the modem to the system. It will install its own application but keep this point in your mind, you need to close the application after the installation is complete because that software captures the port that we will use in our code. let this application to be installed and close it when it is finished Now run the application; press F5. First we need to select the port name from the drop down menu then press the connect button; if port is not valid then it will show the error message.

Now I will select port COM4; it will connect successfully. Dear reader, you need to check your port one by one; Windows XP normally uses port COM3 or COM4.

Now press the "Send SMS button"; you will then get a SMS on your mobile phone

Download

Chart Controls

2013-09-02T23:55:00.001-07:00

Introduction:

Here i will explain Chart Controls.

Description:

The Chart Controls for .NET Framework 3.5 enables ASP.NET and Windows Forms developers to easily create rich and professional-looking data visualization solutions. The Chart Controls currently contains 25 different chart types with 3-D support for most of them, and all of these, available for FREE. In this article, we will create a sample chart using the Chart controls.

To get started, download and install the following in the order given below:

Microsoft Chart Controls for Microsoft .NET Framework 3.5 – assemblies containing the Chart Controls (ASP.NET and Windows Forms)

Microsoft Chart Controls Add-on for Microsoft Visual Studio 2008 – Add as a control in the Visual Studio toolbox and provides IntelliSense for Chart controls.

Once you have downloaded and installed these components, open Visual Studio 2008. In the Data tab on the Toolbox, observe the new ‘Chart’ control.

To get started, let us create a sample application using the Chart control:

Step 1: Drag and drop the Chart control from the Toolbox to the Design surface of Default.aspx. You will see a ‘Column chart’ which looks similar to the following:

If you click on the ‘Source’ view of the page, you find the following mark up added to the page:

<%@ Register Assembly="System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
    Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>

By default the ChartType is ‘Column’. In order to change the Chart Type to either Line, Bar, Pie or any of these 25 chart types; with the Chart control selected, go to the Properties window > go to ‘Series’ > Click on the ellipse button(…) > in the ‘Series Collection Editor’, click on the ‘ChartType’ to view and select a different chart type as shown below:

For this demonstration, we will keep the ChartType to the default ‘Column’.

We will be binding the chart to some data. For this purpose, we will be using the SqlDataSource.

Step 2: Click on the smart tag or right click Chart > Show Smart Tag > Choose a DataSource > New Data Source… > Select Database. We will keep the default ID for SqlDataSource, SqlDataSource1 and click OK.

Step 3: On clicking OK, you will be presented with a ‘Configure Data Source’ wizard. Click on ‘New Connection’ to open the ‘Add Connection’. Type your ‘Server Name’ and ‘Select a database Name’ to connect to. Over here, I have typed (local) as the ServerName and the database I am connecting to is ‘Northwind’. Click on ‘Test Connection’ to make sure that there are no errors connecting to the server. Click Ok.

Step 4: In your ‘Configure Data Source’, click Next. An option will be displayed for saving the connection string to the configuration file. Select the checkbox ‘Yes, save this connection as:’ , type a name for the connectionstring ‘NorthwindConnectionString’ and click Next.

Step 5: In the ‘Configure Select Statement’ > select ‘Specify a Custom SQL Statement or stored procedure’ > click Next

Type the SQL query to ‘list the count of products in a category’ as shown below:

SELECT CategoryName, COUNT(*) AS ProductCount FROM Products
JOIN Categories 
ON Products.CategoryID = Categories.CategoryID
GROUP BY CategoryName

Click Next > Finish.

Step 6: Select the Chart control > Go to the Properties window > ChartAreas property and click the ellipse (…) button to open the ChartArea collection editor. Go to the ‘Axes’ property in the ChartArea Collection Editor and click the ellipse (…) button to open the Axis collection editor as shown below:

Set the ‘Title’ of the X axis to ‘Categories’ and the ‘Title’ of the Y axis to ‘Product Count’. Click OK to close the Axis Collection Editor and an OK again to close the ChartArea Collection Editor.

With the Chart control selected, go to the Series property in the Properties window and click the ellipse (…) button to open the Series collection editor. Go to the Data Source section and add the XValueMember as ‘CategoryName’ and YValueMembers to ‘ProductCount’. Also set the ‘IsValueShownAsLabel’ to True to display the value of ProductCount on the columns. Click OK.

I am sure all we developers who have used 3rd party Charting solutions in the past, are going to welcome this awesome control from Microsoft. The best part is that it is available for FREE.

Hide class in javascript

2013-08-23T22:42:00.001-07:00

Introduction:

Here i will explain Hide class in javascript.

HTML:


appbanner

JS:

document.getElementsByClassName('appBanner')[0].style.visibility='hidden';

How to open whole website into particuler div

2013-08-23T22:37:00.000-07:00

Introduction:

Here i will explain How to open whole website into particular div

Example:

Assign a class if condition is true

2013-08-23T22:33:00.001-07:00

Introduction:

Here i will explain Assign a class if condition is true.

Example:


Hidden

How to disable Autocomplete on web form field / input tag

2013-08-23T22:29:00.002-07:00

Introduction:

Here i will explain How to disable Autocomplete on web form field / input tag

Example: