Create a Help Desk Web Application Using ASP.NET, MVC, JQUERY And More.: January 2015

Monday, 19 January 2015

Use sinple & light weight jquery editor in Web Application

HTML

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" ValidateRequest="false" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div id="sample">
            <script type="text/javascript" src="../nicEdit.js"></script>
            <script type="text/javascript">
                bkLib.onDomLoaded(function () { nicEditors.allTextAreas() });
            </script>
            <textarea id="txtmain" runat="server" name="area3" style="width: 300px; height: 100px;"></textarea>
        </div>
        <asp:Button ID="btnsubmit" runat="server" Text="Submit" OnClick="btnsubmit_Click" />
    </form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        string a;
        a = txtmain.InnerText;
        Response.Write(a);
    }
}

Sunday, 18 January 2015

Insert Into Sql Database

Make Class File Name Code.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

/// <summary>
/// Summary description for Code
/// </summary>
public class Code
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["yogesh"].ConnectionString);

    public void GETCONNECTION()
    {
        con.Open();
    }

    public void CLOSECONNECTION()
    {
        con.Close();
    }

    public int INSERTDATA(SqlParameter[] pr, string query)
    {
        GETCONNECTION();
        SqlCommand cmd = new SqlCommand(query, con);
        cmd.Parameters.AddRange(pr);
        int i = cmd.ExecuteNonQuery();
        CLOSECONNECTION();
        return i;     
    }

    public DataTable SELECTDATA(SqlParameter[] pr, string query)
    {
        GETCONNECTION();
        SqlCommand cmd = new SqlCommand(query, con);
        SqlDataAdapter ad = new SqlDataAdapter(cmd);
        cmd.Parameters.AddRange(pr);
        DataTable dt = new DataTable();
        ad.Fill(dt);
        CLOSECONNECTION();
        return dt;
    }
}

Back Code To Insert Data

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
    Code objcode = new Code();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            binddata();
        }
    }

    public void binddata()
    {
        string content = string.Empty;
        SqlParameter[] pr = new SqlParameter[0];
        string query = "select * from employee";
        DataTable dt = new DataTable();
        dt = objcode.SELECTDATA(pr, query);
        ddlbind.DataSource = dt;
        ddlbind.DataTextField = "name";
        ddlbind.DataValueField = "id";
        ddlbind.DataBind();
    }

    protected void btnsubmit_Click(object sender, EventArgs e)
    {       
        int i = 0;
        SqlParameter[] pr = new SqlParameter[2];
        pr[0] = new SqlParameter();
        pr[0].ParameterName = "@name";
        pr[0].Value = txtname.Text;
        pr[1] = new SqlParameter();
        pr[1].ParameterName = "@address";
        pr[1].Value = txtaddress.Text;
        string query = "insert into employee(name,address) values(@name,@address)";
        i = objcode.INSERTDATA(pr, query);
        if (i > 0)
        {
            Response.Redirect(Request.RawUrl, false);
        }        
    }
    protected void ddlbind_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlParameter[] pr = new SqlParameter[1];
        pr[0] = new SqlParameter();
        pr[0].ParameterName = "@id";
        pr[0].Value = Convert.ToInt32(ddlbind.SelectedItem.Value);
        string query = "select * from employee where id=@id";
        DataTable dt = new DataTable();
        dt = objcode.SELECTDATA(pr, query);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

Friday, 16 January 2015

Dynamic Menu And Sub Menu From Database

Css

<div>
<ul id="nav" runat="server"></ul> 
</div>

Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
using System.Configuration;

public partial class home : System.Web.UI.Page
{
    Code objcode = new Code();

    protected void Page_Load(object sender, EventArgs e)
    {
        menu();
    }

    public void menu()
    {
        string content = string.Empty;
        OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["datacon"].ConnectionString);
        con.Open();
        OleDbCommand cmd = new OleDbCommand("select * from menu", con);
        OleDbDataAdapter ad = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        ad.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            foreach (DataRow dr in dt.Rows)
            {
                string st="#";
                content += "<li><a href='" + st + "'>" + dr["menu_name"] + "</a>" + submenu(dr["menu_name"].ToString()) + "</li>";               
            }
            nav.InnerHtml = content;
        }
    }

    public string submenu(string str)
    {
        string content = string.Empty;
        content += "<ul>";
        if (str.Trim() == "About Us")
        {
            content += bindmainmenu();
        }

        if (str.Trim() == "Contact Us")
        {
            content += bindmainmenu2();
        } 
        content += "</ul>";
        return content;
    }


    public string bindmainmenu()
    {
        string content = string.Empty;
        OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["datacon"].ConnectionString);
        con.Open();
        OleDbCommand cmd = new OleDbCommand("select * from sub_menu", con);
        OleDbDataAdapter ad = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        ad.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            foreach (DataRow dr in dt.Rows)
            {
                content += "<li><a href='" + dr["menu_url"] + "?pid=" + dr["id"] + "'" + ">" + dr["menu_name"] + "</a></li>";
            }
        }        
        return content;
    }

    public string bindmainmenu2()
    {
        string content = string.Empty;
        OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["datacon"].ConnectionString);
        con.Open();
        OleDbCommand cmd = new OleDbCommand("select * from sub_menu2", con);
        OleDbDataAdapter ad = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        ad.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            foreach (DataRow dr in dt.Rows)
            {
                content += "<li><a href='" + dr["menu_url"] + "?pid=" + dr["id"] + "'" + ">" + dr["menu_name"] + "</a></li>";
            }
        }
        return content;
    }
}

Wednesday, 14 January 2015

show limited text in label

<asp:Label ID="pro_typeLabel" runat="server" CssClass="ShortDesc" Text='<%# Eval("Model").ToString().Substring(0,Math.Min(8,Eval("Model").ToString().Length)) %>' />..                                            


<span style="font-weight: 300;">
                                        <asp:Label ID="briefLabel" runat="server" Text='<%# Eval("brief").ToString().Substring(0,Math.Min(78,Eval("brief").ToString().Length)) %>'></asp:Label>...</span>