What is Object and Collection initialization in C#? Example.

class Program
    {
        static void Main(string[] args)
        {
            List<Employee> emp = new List<Employee> {
                new Employee{Name="Kulshresth0",Address="Noida0"},
                new Employee{Name="Kulshresth1",Address="Noida1"},
                new Employee{Name="Kulshresth2",Address="Noida2"},
                new Employee{Name="Kulshresth3",Address="Noida3"},
            };
            foreach(Employee em in emp)
            {
                Console.WriteLine("Name : "+em.Name +" "+"Address : "+em.Address);
            }
            Console.ReadLine();
        }
    }-----------------------------

class  Employee
    {
        public string Name { get; set; }
        public string Address { get; set; }
    }

Share:

Read More

What is the Abstract class and Overriding in C#? Example.

  Example 

 abstract class Student
    {
       public abstract void Name();
    }
    class Student_Details:Student
    {
        public override void Name()
        {
            Console.WriteLine("Kulshresth Kumar");
        }
    }--------------------------

 class Program
    {
        static void Main(string[] args)
        {
            Student_Details obj = new Student_Details();
            obj.Name();
            Console.ReadLine();
        }
    }

Share:

Read More

Why call the Overriding till two Level by Virtual Key in C#? Example.

class Student
    {
        public virtual void Name()
        {
            Console.WriteLine("Kulshresth");
        }
    }
    class Student_Details:Student
    {
        public override void Name()
        {
            Console.WriteLine("Kulshresth Kumar");
        }

        public override void Name(string name)
        {
            Console.WriteLine("Kulshresth Kumar "+) name;
        }
    }------------------------

class Program
    {
        static void Main(string[] args)
        {
            Student_Details obj = new Student_Details();
            obj.Name();
            obj.Name("Nagar");
            Console.ReadLine();
        }
    }

Share:

Read More

How to override a class in C#? Example.

 class Student
    {
        public void Name()
        {
            Console.WriteLine("Kulshresth");
        }
    }
    class Student_Details:Student
    {
        public void Name()
        {
            Console.WriteLine("Kulshresth Kumar");
        }

        public void Name(string lastname)
        {
            Console.WriteLine("Kulshresth Kumar " + lastname);
        }
    }------------------------------

class Program
    {
        static void Main(string[] args)
        {
            Student_Details obj = new Student_Details();
            obj.Name();
            obj.Name("Nagar");
            Console.ReadLine();
        }
    }

Share:

Read More

What is method Overloading and how to work in C#? Example.

class Overloading
    {
        public string Name(string name)
        {
            return name;
        }
        public string Name()
        {
            return "Nagar";
        }
    }--------------------

class Program
    {
        static void Main(string[] args)
        {
            Overloading obj = new Overloading();
            Console.WriteLine("Name : "+ obj.Name("Kulshresth"));
            Console.WriteLine("Full Name : " + obj.Name("Kulshresth Kumar Nagar"));
            Console.ReadLine();
        }
    }

Share:

Read More

What is Abstraction in C# with example?

Abstract Class:-

Abstract classes are the way to achieve abstraction in C#. Abstraction in C# is the process to hide the internal details and showing functionality only. Abstraction can be achieved by two ways:

     A-Abstract class

     B-Interface

Abstract class and interface both can have abstract methods which are necessary for abstraction.

Abstract Method:-

A method which is declared abstract and has no body is called abstract method. It can be declared inside the abstract class only. Its implementation must be provided by derived classes. 

For example: public abstract void draw(); 

Impression : An abstract method in C# is internally a virtual method so it can be overridden by the derived class.

Abstract class:-

In C#, abstract class is a class which is declared abstract. It can have abstract and non-abstract methods. It cannot be instantiated. Its implementation must be provided by derived classes. Here, derived class is forced to provide the implementation of all the abstract methods.

Example

 class Program

    {

        static void Main(string[] args)

        {

            Square ob = new Square(4);

            double result = ob.Area();

            Console.WriteLine(result);

            Console.ReadLine();

        }

    }

    abstract class Shape

    {

        public abstract int Area();

    }

    class Square : Shape

    {

        private int Side;

        public Square(int x = 0)

        {

            Side = x;

        }

        public override int Area()

        {

            Console.Write("Area of Square: ");

            return (Side * Side);

        }

    }

Share:

Read More

What is Encapsulation in C#? Example.

 class Encapsulation
    {
        private string Name;

        private string Salary;

        public string GetName
        {
            get
            {
                return Name;
            }
            set
            {
                Name = value;
            }
        }
        public string GetSalary
        {
            get
            {
                return Salary;
            }
            set
            {
                Salary = value;
            }
        }
    }
---------------------
 class Program
    {
        static void Main(string[] args)
        {
            Encapsulation encap = new Encapsulation();
            encap.GetName = "Kulshresth";
            encap.GetSalary = "1,00,000/-";
            Console.WriteLine("Name  : {0}", encap.GetName);
            Console.WriteLine("Salary  : {0}", encap.GetSalary);
            Console.ReadLine();
        }
    }

Share:

Read More

What is Polymorphism and why use in C# with example.

Polymorphism

This is the ability of an object to perform in a wide variety of ways. There are two types:

1. Dynamic polymorphism (runtime time). You can obtain this type through executing function overriding.

2. Static polymorphism (compile time). You can achieve static polymorphism through function overloading and operator overloading.

Within OOP, polymorphism can be achieved using many techniques including:

• Method overloading (defining several methods at the same time)
• Method overriding (this allows a subclass to override a specific implementation of a method already issued by one of its super-classes)
• Operator overloading (some or all of the operators are handled has polymorphic functions with different behaviors depending on the types of its arguments)

Share:

Read More

What is Oops concept? Example.

• Encapsulation is when a group of related methods, properties, and other members are treated as a single object.
• Inheritance is the ability to receive (“inherit”) methods and properties from an existing class.
• Polymorphism is when each class implements the same methods in varying ways, but you can still have several classes that can be utilized interchangeably.
• Abstraction is the process by which a developer hides everything other than the relevant data about an object in order to simplify and increase efficiency.

Share:

Read More

Date Format in C# with Example.

 class DateFormat
    {
        public static void DifferentTypeDateFormat()
        {
            DateTime date = DateTime.Now;
            Console.WriteLine("Some Date Formats : ");
            Console.WriteLine("Date and Time:  {0}", date);
            Console.WriteLine(date.ToString("yyyy-MM-dd"));
            Console.WriteLine(date.ToString("dd-MMM-yyyy"));
            Console.WriteLine(date.ToString("M/d/yyyy"));
            Console.WriteLine(date.ToString("M/d/yy"));
            Console.WriteLine(date.ToString("MM/dd/yyyy"));
            Console.WriteLine(date.ToString("MM/dd/yyyy"));
            Console.WriteLine(date.ToString("yyyy/MM/dd"));
            Console.Read();
        }
    }

Share:

Read More

How to check Odd Even Number in C# with example.

class OddEvenNumber
    {
        public static void OddEven()
        {
            int i;
            Console.Write("Enter a Number : ");
            i = int.Parse(Console.ReadLine());
            if (i % 2 == 0)
            {
                Console.Write("Entered Number is an Even Number");
            }
            else
            {
                Console.Write("Entered Number is an Odd Number");
            }
        }
    }

Share:

Read More

How to Sum Of Numbers digit using JavaScript with example?

class SumOfNumberDigits
    {
        public static void Display()
        {
            int number, sum = 0, reminder;
            Console.WriteLine("Enter a Number : ");
            number = int.Parse(Console.ReadLine());
            while (number != 0)
            {
                reminder = number % 10;
                number = number/ 10;
                sum = sum + reminder;
            }
            Console.WriteLine("Sum of Digits of the Number : " + sum);
            Console.ReadLine();
        }
    }

Share:

Read More

How to Swap Two Numbers in C#? Example.

class SwapTwoNumbers
    {
        public static void Swap()
        {
            int a, b;
            a = 5; b = 10;
            b = b - a;
            a = a + b;
            Console.WriteLine("After swaping value of a : " + a);
            Console.WriteLine("After swaping value of b : " + b);
            Console.ReadLine();
        }
    }

Share:

Read More

Check Prime Number in C# with example.

class PrimeNumber
    {
        public static void Prime()
        {
            int number, i, m = 0, flag = 0;
            Console.Write("\nEnter the Number to check Prime: ");
            number = int.Parse(Console.ReadLine());
            m = number / 2;
            for (i = 2; i <= m; i++)
            {
                if (number % i == 0)
                {
                    Console.Write("Number is not Prime.\n");
                    flag = 1;
                    break;
                }
            }
            if (flag == 0)
                Console.Write("Number is Prime.\n");     
        }
    }

Share:

Read More

How to check Palindrome in C#? Example.

class Palindrome
    {
        public static void Palindrom()
        {
            int number, reminder, sum = 0, temp;
            Console.Write("Enter a number: ");
            number = Convert.ToInt32(Console.ReadLine());
            temp = number;
            while (number > 0)
            {
                reminder = number % 10;
                number = number / 10;
                sum = sum * 10 + reminder;
            }
            if (temp == sum)
            {
                Console.WriteLine("Number is Palindrome.");
            }
            else
            {
                Console.WriteLine("Number is not a palindrome.");
            }
            Console.ReadLine(); 
        }
    }

Share:

Read More

How to reverse a String Words in C#? Example.

 class ReverseString
    {
        public static void ReverseAStringWords()
        {
            StringBuilder sb = new StringBuilder();
            Console.WriteLine("Please Enter Any String.");
            string str = Console.ReadLine();
            var reverse = str.Reverse();
            foreach (char c in reverse)
            {
                sb.Append(c);
            }
            string [] sentence = sb.ToString().Split(',');
            string finalSentence = "";
            for (int i = sentence.Length-1; i <= sentence.Count()-1 ; i--)
            {
                if (i == -1)
                {
                    break;
                }
                else
                {
                    finalSentence+=sentence[i] + ",";
                }
            }

            Console.Write(finalSentence.TrimEnd(','));
            Console.ReadLine();
        }
    }

Share:

Read More

How to compare two list in c# with example?

 class Program
    {
        static void Main(string[] args)
        {
            while(true)
            {
            List<string> list1 = new List<string>();
            Console.WriteLine("Please Enter First List");
            String firstList = Console.ReadLine();
            list1.Add(firstList);
            List<String> list2 = new List<string>();
            Console.WriteLine("Please Enter Second List");
            string secondList = Console.ReadLine();
            list2.Add(secondList);
            var hashsetFirst = new HashSet<string>(list1);
            var hashsetSecond = new HashSet<string>(list2);
            bool compare = hashsetFirst.SetEquals(hashsetSecond);
            if (compare == true)
            {
                Console.Write("Match List");
            }
            else
            {
                Console.Write("Unmatch List");
            }
            Console.ReadLine();
            }
        }
    }

Share:

Read More

How to call JavaScript function from code behind in C#? Example.

   <script type="text/javascript" language="javascript">
        function helloWorld(data) {
            alert(data);
        }
</script>
-----------------
 string strParamter = "Hello World test";
        ClientScript.RegisterStartupScript(GetType(), "Javascript", "javascript:helloWorld('" + strParamter + "'); ", true);

Share:

Read More

How to DataTable refresh by selected CheckBoxList in C#? Example.

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="Setting.ascx.cs" Inherits="Setting" %>
<style type="text/css">
 
    .web_dialog_overlay {
        position: fixed;
        top: 0;
        right: 0;
        bottom: 0;
        left: 0;
        height: 100%;
        width: 100%;
        margin: 0;
        padding: 0;
        background: #000000;
        opacity: .15;
        filter: alpha(opacity=15);
        -moz-opacity: .15;
        z-index: 101;
        display: none;
    }

    .web_dialog {
        display: none;
        position: fixed;
        width: 900px;
        height: 700px;
        top: 20%;
        left: 30%;
        margin-left: -50px;
        margin-top: -50px;
        background-color: #ffffff;
        border: 2px solid #336699;
        padding: 0px;
        z-index: 102;
        font-family: Verdana;
        font-size: 10pt;
    }

    .web_dialog_title {
        border-bottom: solid 2px #336699;
        background-color: #336699;
        padding: 4px;
        color: White;
        font-weight: bold;
    }

        .web_dialog_title a {
            color: White;
            text-decoration: none;
        }

    .align_right {
        text-align: right;
    }
</style>
<script type="text/javascript">

    $(document).ready(function () {
        $("#btnClose").click(function (e) {
            HideDialog();
            e.preventDefault();
        });
    });

    function ShowDialog(modal) {
        $("#overlay").show();
        $("#dialog").fadeIn(300);

        if (modal) {
            $("#overlay").unbind("click");
        }
        else {
            $("#overlay").click(function (e) {
                HideDialog();
            });
        }
    }

    function HideDialog() {
        $("#overlay").hide();
        $("#dialog").fadeOut(300);
    }

</script>
<asp:Button ID="btnSetting" runat="server" OnClick="btnSetting_Click" Text="Setting" />

<div id="output"></div>
<div id="overlay" class="web_dialog_overlay"></div>
<div id="dialog" class="web_dialog">
    <table style="width: 100%; border: 0px;">
        <tr>
            <td class="align_right"><a href="#" id="btnClose">Close</a></td>
        </tr>
        <tr>
            <td>
                <asp:CheckBoxList ID="CheckBoxList1" runat="server" ></asp:CheckBoxList>
            </td>
        </tr>
        <tr>
            <td style="text-align: center;">
                <asp:Button Text="Submit" runat="server" ID="btnSubmit" Style="margin-top: 20%;" OnClick="btnSubmit_Click" />
                <asp:Button Text="Cancel" runat="server" ID="Button1" />
            </td>
        </tr>
    </table>
</div>
<div style="margin-top: 30px">
</div>

-----------------------------------------------------

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Setting : System.Web.UI.UserControl

{

    SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());

    public event EventHandler ehClick;

    protected void Page_Load(object sender, EventArgs e)

    {

        if(!IsPostBack)

        {

            BindCheckBox();

        }

    }

    protected void btnSetting_Click(object sender, EventArgs e)

    {

        BindCheckBox();

        ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "ShowDialog();", true);

    }

    public void BindCheckBox()

    {

        cn.Open();

        SqlDataAdapter adapter = new SqlDataAdapter();

        SqlCommand cmd = new SqlCommand("SP_CmmonSetting", cn);

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add(new SqlParameter("@User", "Admin"));

        cmd.Parameters.Add(new SqlParameter("@Client", "122"));

        cmd.Parameters.Add(new SqlParameter("@Proc", "SP_GetASN"));

        adapter.SelectCommand = cmd;

        DataSet ds = new DataSet();

        adapter.Fill(ds);

        int status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());

        if (status == 0)

        {

            DataTable tbl = ds.Tables[2];

            string col = "";

            foreach (DataColumn column in tbl.Columns)

            {

                col += column.ColumnName + ",";

            }

            var items = col.TrimEnd(',');

            var list1 = items.Split(',');

            string data = "C_Fname,C_Lname,C_Email,C_Login,C_Password,C_MobileNo,C_Country,C_Role,C_IMID,C_TypeOf,C_SocialReferennce,C_SocialProfId,C_Operation,UID,FromDate,ToDate,Test,Test1";

            List<string> list2 = data.Split(',').ToList();

            var match = list1.Intersect(list2);

            var li1 = match.Select(x => "m" + x).ToList();

            var unmatch = list2.Except(list1);

            var li2 = unmatch.Select(x => "u" + x).ToList();

            var result = match.Concat(unmatch);

            CheckBoxList1.DataSource = result;

            CheckBoxList1.DataBind();

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

            {

                string prefix = li1[i].Substring(0, 1);

                if (prefix == "m")

                {

                    CheckBoxList1.Items[i].Selected = true;

                }

                else

                {

                    CheckBoxList1.Items[i].Selected = false;

                }

            }

        }

        else

        {

            var list1 = ds.Tables[1].Rows[0]["Columns"].ToString().Split(',');

            string data = "C_Fname,C_Lname,C_Email,C_Login,C_Password,C_MobileNo,C_Country,C_Role,C_IMID,C_TypeOf,C_SocialReferennce,C_SocialProfId,C_Operation,UID,FromDate,ToDate,Test,Test1";

            List<string> list2 = data.Split(',').ToList();

            var match = list1.Intersect(list2);

            var li1 = match.Select(x => "m" + x).ToList();

            var unmatch = list2.Except(list1);

            var li2 = unmatch.Select(x => "u" + x).ToList();

            var result = match.Concat(unmatch);

            CheckBoxList1.DataSource = result;

            CheckBoxList1.DataBind();

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

            {

                string prefix = li1[i].Substring(0, 1);

                if (prefix == "m")

                {

                    CheckBoxList1.Items[i].Selected = true;

                }

                else

                {

                    CheckBoxList1.Items[i].Selected = false;

                }

            }

        }

        cn.Close();

    }

    protected void btnSubmit_Click(object sender, EventArgs e)

    {

        string items = "";

        foreach (ListItem item in CheckBoxList1.Items)

        {

            if (item.Selected == true)

            {

                items += item.Value.ToString() + ",";

            }

        }

        items = items.TrimEnd(',');

        SqlCommand cmd = new SqlCommand("UpdateColumns", cn);

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add("@User", "Admin");

        cmd.Parameters.Add("@Client", "122");

        cmd.Parameters.Add("@Proc", "SP_GetASN");

        cmd.Parameters.Add("@Columns", items);

        cn.Open();

        cmd.ExecuteNonQuery();

        cn.Close();

        ehClick.Invoke(this, new EventArgs());

        ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "ShowDialog();", false);

    }

    

}
-----------------------------------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<%@ Register Src="~/Setting.ascx" TagPrefix="uc" TagName="PO" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

    <script src="js/jquery-1.11.1.min.js"></script>

    <script src="js/jquery.dataTables.min.js"></script>

    <link href="CSS/bootstrap-theme.css" rel="stylesheet" />

    <link href="CSS/dataTables.jqueryui.css" rel="stylesheet" />

    <script type="text/javascript">

        $(document).ready(function () {

            $('#example').dataTable({

                "bLengthChange": true,

                "paging": true,

                "sPaginationType": "full_numbers",

                // "scrollY": 400,                                 

                "jQueryUI": true

            });

        });

    </script>

    <style type="text/css">

        .paging_full_numbers span.paginate_button {

            background-color: #fff;

        }

            .paging_full_numbers span.paginate_button:hover {

                background-color: #ccc;

            }

        .paging_full_numbers span.paginate_active {

            background-color: #99B3FF;

        }

    </style>

</head>

<body>

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

        <div>

            <uc:PO ID="poControl" runat="server" />

        </div>

        <div style="margin-top: 30px">

            <table class="table table-striped table-bordered " style="font-family: Serif;"

                border="1px" id="example">

                <thead id="hlist" runat="server">

                </thead>

                <tbody id="blist" runat="server">

                </tbody>

            </table>

        </div>

    </form>

</body>

</html>

-----------------------------------------------

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Dynamic;

using System.Linq;

using System.Reflection;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Default2 : System.Web.UI.Page

{

    SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());

    protected void Page_Load(object sender, EventArgs e)

    {

        this.poControl.ehClick += new EventHandler(this.btnPageButton_Click);

        if (!IsPostBack)

        {

           BindDataTable();

        }

    }

    protected void btnPageButton_Click(object sender, EventArgs e)

    {

      BindDataTable();

    }

    public void BindDataTable()

    {

        SqlDataAdapter adapter = new SqlDataAdapter();

        SqlCommand cmd = new SqlCommand("SP_CmmonSetting", cn);

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add(new SqlParameter("@User", "Admin"));

        cmd.Parameters.Add(new SqlParameter("@Client", "122"));

        cmd.Parameters.Add(new SqlParameter("@Proc", "SP_GetASN"));

        adapter.SelectCommand = cmd;

        DataSet ds = new DataSet();

        adapter.Fill(ds);

        int status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());

        if (status == 0)

        {

            cn.Open();

            DataTable tbl1 = ds.Tables[2];

            string col = "";

            foreach (DataColumn column in tbl1.Columns)

            {

                col += column.ColumnName + ",";

            }

            var items = col.TrimEnd(',');

            var list1 = items.Split(',');

            string Column = items;

            string query = "Select " + Column + " from RegistrationForm ";

            SqlDataAdapter da = new SqlDataAdapter(query, cn);

            DataTable tbl = new DataTable();

            da.Fill(tbl);

            String UnreadText = "";

            UnreadText += "<tr>";

            var li1 = Column.Split(',');

            foreach (var item in li1)

            {

                UnreadText += " <td class=\"center\">" + item + "</td>";

            }

            UnreadText += " <td class=\"center\">";

            UnreadText += " <i class=\"icon-edit icon-white\"></i>  ";

            UnreadText += " Action                                    ";

            UnreadText += " </td>";

            UnreadText += " </tr>";

            hlist.InnerHtml = UnreadText;

            foreach (DataRow row in tbl.Rows)

            {

                //For body binding 

                UnreadText += "<tr>";

                var li = Column.Split(',');

                foreach (var item in li)

                {

                    UnreadText += " <td class=\"center\">" + row[item] + "</td>";

                }

                UnreadText += " <td class=\"center\">";

                UnreadText += " <a class=\"btn btn-info\" href=\"Edit.aspx?ID=" + row[0] + "\">";

                UnreadText += " <i class=\"icon-edit icon-white\"></i>  ";

                UnreadText += " Edit                                    ";

                UnreadText += " </a>";

                UnreadText += " <a class=\"btn btn-info\" href=\"Delete.aspx?ID=" + row[0] + "\">";

                UnreadText += " <i class=\"icon-edit icon-white\"></i>  ";

                UnreadText += " Delete                                    ";

                UnreadText += " </a>";

                UnreadText += " </td>";

                UnreadText += " </tr>";

                blist.InnerHtml = UnreadText;

            }

            cn.Close();

        }

        else

        {

            string col = ds.Tables[1].Rows[0]["Columns"].ToString();

            string query = "Select " + col + " from RegistrationForm ";

            SqlDataAdapter da = new SqlDataAdapter(query, cn);

            DataTable tbl = new DataTable();

            da.Fill(tbl);

            String UnreadText = "";

            //For Header Binding

            UnreadText += "<tr>";

            var li1 = ds.Tables[1].Rows[0]["Columns"].ToString().Split(',');

            foreach (var item in li1)

            {

                UnreadText += " <td class=\"center\">" + item + "</td>";

            }

            UnreadText += " <td class=\"center\">";

            UnreadText += " <i class=\"icon-edit icon-white\"></i>  ";

            UnreadText += " Action                                    ";

            UnreadText += " </td>";

            UnreadText += " </tr>";

            hlist.InnerHtml = UnreadText;

            foreach (DataRow row in tbl.Rows)

            {

                //For body binding 

                UnreadText += "<tr>";

                var li = ds.Tables[1].Rows[0]["Columns"].ToString().Split(',');

                foreach (var item in li)

                {

                    UnreadText += " <td class=\"center\">" + row[item] + "</td>";

                }

                UnreadText += " <td class=\"center\">";

                UnreadText += " <a class=\"btn btn-info\" href=\"Edit.aspx?ID=" + row[0] + "\">";

                UnreadText += " <i class=\"icon-edit icon-white\"></i>  ";

                UnreadText += " Edit                                    ";

                UnreadText += " </a>";

                UnreadText += " <a class=\"btn btn-info\" href=\"Delete.aspx?ID=" + row[0] + "\">";

                UnreadText += " <i class=\"icon-edit icon-white\"></i>  ";

                UnreadText += " Delete                                    ";

                UnreadText += " </a>";

                UnreadText += " </td>";

                UnreadText += " </tr>";

                blist.InnerHtml = UnreadText;

            }

        }

    }

}

Share:

Read More

SQL Script

USE [Pyramid]
GO

/****** Object:  Table [dbo].[RegistrationForm]    Script Date: 06/14/2019 11:03:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[RegistrationForm](
[Id] [int] IDENTITY(1,1) NOT NULL,
[C_Fname] [varchar](50) NOT NULL,
[C_Lname] [varchar](50) NULL,
[C_Email] [varchar](50) NULL,
[C_Login] [varchar](50) NULL,
[C_Password] [varchar](50) NOT NULL,
[C_MobileNo] [varchar](50) NOT NULL,
[C_Country] [varchar](50) NOT NULL,
[C_Role] [varchar](50) NULL,
[C_IMID] [varchar](50) NOT NULL,
[C_TypeOf] [varchar](50) NULL,
[C_SocialReferennce] [varchar](50) NOT NULL,
[C_SocialProfId] [varchar](50) NULL,
[C_Operation] [varchar](50) NULL,
[UID] [int] NULL,
[FromDate] [date] NULL,
[ToDate] [date] NULL,
[Test] [varchar](50) NULL,
[Test1] [varchar](500) NULL,
[CreatedBy] [int] NULL,
 CONSTRAINT [PK_RegistrationForm] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [UQ_RegistrationForm] UNIQUE NONCLUSTERED
(
[C_Login] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[RegistrationForm]  WITH CHECK ADD  CONSTRAINT [FK__Registrat__Creat__29572725] FOREIGN KEY([CreatedBy])
REFERENCES [dbo].[RegistrationForm] ([Id])
GO

ALTER TABLE [dbo].[RegistrationForm] CHECK CONSTRAINT [FK__Registrat__Creat__29572725]
GO

ALTER TABLE [dbo].[RegistrationForm] ADD  CONSTRAINT [DF_RegistrationForm_C_Operation]  DEFAULT ('No') FOR [C_Operation]
GO

-------------------------------------------------
USE [Pyramid]
GO

/****** Object:  Table [dbo].[Setting]    Script Date: 06/14/2019 11:05:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Setting](
[ID] [int] IDENTITY(1,1) NOT NULL,
[User] [varchar](100) NULL,
[Client] [varchar](100) NULL,
[Proc] [varchar](100) NULL,
[Columns] [varchar](max) NULL,
[Status] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

----------------------------------------------
USE [Pyramid]
GO

/****** Object:  StoredProcedure [dbo].[SP_CmmonSetting]    Script Date: 06/14/2019 11:05:54 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


--EXEC SP_CmmonSetting 'admin','121','SP_GetASN'

CREATE PROCEDURE [dbo].[SP_CmmonSetting](
@User VARCHAR(100),@Client VARCHAR(100),@Proc VARCHAR(100)
)
AS
BEGIN
    BEGIN
         DECLARE @Cnt INT
         SET @Cnt=(SELECT [Status] FROM Setting WHERE [User]=@User AND Client=@Client AND [Proc]=@Proc)
         IF @Cnt=1
         BEGIN
              SELECT 1 AS [Status]
              SELECT * FROM Setting WHERE [User]=@User AND Client=@Client AND  [Status]=1
         END
         ELSE
         BEGIN
       
              SELECT 0 AS [Status]
              SELECT * FROM Setting WHERE [User]=@User AND Client=@Client  and [Status]=0
              EXEC @Proc
         END
    END
END
GO

----------------------------------------------
USE [Pyramid]
GO

/****** Object:  StoredProcedure [dbo].[UpdateColumns]    Script Date: 06/14/2019 11:06:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[UpdateColumns](
@User VARCHAR(100),@Client VARCHAR(100),@Proc VARCHAR(100),@Columns VARCHAR(MAX)
)
AS
BEGIN
    update Setting set Columns=@Columns,[Status]=1 WHERE [User]=@User AND Client=@Client AND [Proc] =@Proc
END
GO

---------------------------------------------
USE [Pyramid]
GO

/****** Object:  StoredProcedure [dbo].[SP_GetPO]    Script Date: 06/14/2019 11:06:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[SP_GetPO]
AS
BEGIN
     SELECT C_Fname,C_Lname,C_Email,C_Login FROM RegistrationForm
END

GO

--------------------------------
USE [Pyramid]
GO

/****** Object:  StoredProcedure [dbo].[SP_GetASN]    Script Date: 06/14/2019 11:06:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[SP_GetASN]
AS
BEGIN
     SELECT C_Fname,C_Lname FROM RegistrationForm
END

GO

Share:

Read More

Model PopUp in C# with example.

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

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!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>Untitled Page</title>
    <style type="text/css">
        .modalBackground {
            background-color: Gray;
            filter: alpha(opacity=80);
            opacity: 0.8;
            z-index: 10000;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ToolkitScriptManager ID="ScriptManager1" runat="server">
        </asp:ToolkitScriptManager>
        <div>
            <asp:ImageButton ID="imgbtn" ImageUrl="~/Edit.jpg" runat="server" Width="25" Height="25" OnClick="imgbtn_Click" />
            <asp:Label ID="lblresult" runat="server" />
            <asp:Button ID="btnShowPopup" runat="server" Style="display: none" />
            <asp:ModalPopupExtender ID="ModalPopupExtender1" runat="server" TargetControlID="btnShowPopup" PopupControlID="pnlpopup"
                CancelControlID="btnCancel" BackgroundCssClass="modalBackground">
            </asp:ModalPopupExtender>
            <asp:Panel ID="pnlpopup" runat="server" BackColor="White" Height="269px" Width="400px" Style="display: none">
                <table width="100%" style="border: Solid 3px #D55500; width: 100%; height: 100%" cellpadding="0" cellspacing="0">
                    <tr>
                        <td>
                            <asp:CheckBoxList ID="CheckBoxList1" runat="server"></asp:CheckBoxList>
                        </td>
                        <td>
                            <asp:Button ID="btnUpdate" CommandName="Update" runat="server" Text="Update" OnClick="btnUpdate_Click" />
                            <asp:Button ID="btnCancel" runat="server" Text="Cancel" />
                        </td>
                    </tr>
                </table>
            </asp:Panel>
        </div>
    </form>
</body>
</html>

///////////////////////

using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

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 AjaxControlToolkit;

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

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ToString());

protected void Page_Load(object sender, EventArgs e)

{

if(!IsPostBack)

{

 BindGridData();

}

}

protected void BindGridData()

{

        string str = "select Name,Address from Employee";

        SqlDataAdapter da = new SqlDataAdapter(str,con);

        DataTable dt = new DataTable();

        da.Fill(dt);

        string[] columnNames = dt.Columns.Cast<DataColumn>()

                                 .Select(x => x.ColumnName)

                                 .ToArray();

        CheckBoxList1.DataSource = columnNames;

        CheckBoxList1.DataBind();

}

protected void btnUpdate_Click(object sender, EventArgs e)

{

        string str = "";

        foreach (ListItem item in CheckBoxList1.Items)

        {

            if(item.Selected==true)

            {

                

            }

        }

        string data = str;

       //BindGridData();

}

protected void imgbtn_Click(object sender, ImageClickEventArgs e)

{

 this.ModalPopupExtender1.Show();

}

}

Share:

Read More