3 tier architecture example in asp.net with C#

ASPX page

<table>
        <tr>
            <td colspan="2">
                <asp:Label ID="lblMsg" runat="server" Text="" ForeColor="Red"></asp:Label>
            </td>
        </tr>
        <tr>
            <td>
                Name :
            </td>
            <td>
                <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Button ID="btnAdd" runat="server" Text="Add" OnClick="btnAdd_Click" />
            </td>
            <td>
                <asp:Button ID="btnBack" runat="server" Text="Back" />
            </td>
        </tr>
    </table>

**************************************************************************

cs file of aspx page


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;

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

    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
//call class file here
        Datatbl objData = new Datatbl();
        objData.tblId = "";
        objData.tblName = txtName.Text;

        DAOtbl objDAO = new DAOtbl();
        objDAO.insert(objData);
    }
}

*****************************************************************
now add class file Datatbl.cs



using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public class Datatbl
{
    private string id;
    private string name;

    public string tblId
    {
        get
        {
            return id;
        }
        set
        {
            id = value;
        }
    }

    public string tblName
    {
        get
        {
            return name;
        }
        set
        {
            name = value;
        }
    }
}

*************************************************************************
Now Establish connection Database.cs



using System;
using System.Data;
using System.Configuration;
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.Data.SqlClient;

public class Database
{
    public static SqlConnection connect()
    {
        SqlConnection con1 = new SqlConnection();
        con1.ConnectionString = "Data Source=.\\SQLExpress;AttachDbFileName=|DataDirectory|Database1.mdf;Integrated Security=True;User Instance=True;";
        return con1;
    }
}



*****************************************************************

Logic of get data,delete,update DAOtbl.cs


using System;
using System.Data;
using System.Configuration;
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.Data.SqlClient;

public class DAOtbl
{
    SqlConnection con = null;
    SqlCommand cmd = null;
    SqlDataAdapter adp = null;
    DataTable dt = null;
    string query = "";

    public Boolean isDuplicate(string name)
    {
        query = "SELECT COUNT(*) FROM tbl WHERE Name=@Name";
        con = Database.connect();
        cmd = new SqlCommand(query, con);
        cmd.Parameters.AddWithValue("@Name", name);

        con.Open();
        int count = Convert.ToInt16(cmd.ExecuteScalar());
        con.Close();
        if (count == 0)
            return false;
        return true;
    }

    public Boolean insert(Datatbl obj)
    {
        query = "INSERT INTO tbl VALUES (@Name)";
        con = Database.connect();
        cmd = new SqlCommand(query, con);
        cmd.Parameters.AddWithValue("@Name", obj.tblName);

        con.Open();
        int noOfRowsAffected = cmd.ExecuteNonQuery();
        con.Close();

        if (noOfRowsAffected == 1)
            return true;
        return false;
    }

    public Boolean update(Datatbl obj)
    {
        query = "UPDATE tbl SET Name=@Name WHERE Id=@Id";
        con = Database.connect();
        cmd = new SqlCommand(query, con);
        cmd.Parameters.AddWithValue("@Id", obj.tblId);
        cmd.Parameters.AddWithValue("@Name", obj.tblName);

        con.Open();
        int noOfRowsAffected = cmd.ExecuteNonQuery();
        con.Close();

        if (noOfRowsAffected == 1)
            return true;
        return false;
    }

    public Boolean delete(string id)
    {
        query = "DELETE FROM tbl WHERE Id=@Id";
        con = Database.connect();
        cmd = new SqlCommand(query, con);
        cmd.Parameters.AddWithValue("@Id", id);

        con.Open();
        int noOfRowsAffected = cmd.ExecuteNonQuery();
        con.Close();

        if (noOfRowsAffected == 1)
            return true;
        return false;
    }

    public Datatbl getDataById(string id)
    {
        query = "SELECT * FROM tbl WHERE Id=@Id";
        con = Database.connect();
        cmd = new SqlCommand(query, con);
        cmd.Parameters.AddWithValue("@Id", id);

        dt = new DataTable();
        adp = new SqlDataAdapter(cmd);

        con.Open();
        adp.Fill(dt);
        con.Close();

        Datatbl dataObj = null;
        if (dt != null && dt.Rows.Count == 1)
        {
            dataObj = new Datatbl();
            dataObj.tblId = dt.Rows[0]["Id"].ToString();
            dataObj.tblName = dt.Rows[0]["Name"].ToString();
        }
        return dataObj;
    }

    public DataTable getData()
    {
        query = "SELECT * FROM tbl";
        con = Database.connect();
        cmd = new SqlCommand(query, con);
        dt = new DataTable();
        adp = new SqlDataAdapter(cmd);

        con.Open();
        adp.Fill(dt);
        con.Close();

        return dt;
    }
}

How to pass "&" or other sign in query string in asp.net

string subject="you # me";

Response.Redirect("About.aspx?sub="+ Server.UrlEncode(subject));

limit text string in Eval asp.net

<%#Eval("MyText").ToString().Length <= 30 ? Eval("MyText") : Eval("MyText").ToString().Substring(0, 30)+"..."%> 

javascript set to uppercase , Lowerase, Capitalize

Upper case

 <script>
  var str="Hello world!";
  document.write(str.toUpperCase());
</script>

Lower case

 <script>
  var str="Hello world!";
  document.write(str.toLowerCase());
</script>

Capitalize

function toTitleCase(str)
{
    return str.replace(/\w\S*/g, function(txt){return txt.charAt(0).toUpperCase() + txt.substr(1).toLowerCase();});
}

Trim a string in JavaScript

String.prototype.trim=function(){return this.replace(/^\s+|\s+$/g, '');};

String.prototype.ltrim=function(){return this.replace(/^\s+/,'');};

String.prototype.rtrim=function(){return this.replace(/\s+$/,'');};

String.prototype.fulltrim=function(){return this.replace(/(?:(?:^|\n)\s+|\s+(?:$|\n))/g,'').replace(/\s+/g,' ');};

C# Copy a file to another location with a different name

System.IO.File.Copy(oldPathAndName, newPathAndName);

Get Table from Word Document Asp.Net C#

for (int t = 1; t < doc.Tables.Count; t++)
        {
            DataTable dt = new DataTable();
            DataRow dr = dt.NewRow();
            int col = doc.Tables[t].Columns.Count;
            int row = doc.Tables[t].Rows.Count;
            for (int i = 1; i <= col; i++)
            {
                                   dt.Columns.Add(doc.Tables[t].Columns[i].Cells[1].Range.Text);
              }
               

            }
            for (int r = 2; r <= row; r++)
            {
                dr = dt.NewRow();
                dt.Rows.Add(dr);
                for (int c = 1; c <= col; c++)
                {
                                  dr[doc.Tables[t].Columns[c].Cells[1].Range.Text] = doc.Tables[t].Rows[r].Cells[c].Range.Text.Trim();
                    }
                                   
                }
            }

        }