Validation CSS In ASP.NET

Validation CSS In ASP.NET

ASPX PAGE :-

<table cellpadding="0" cellspacing="30" >
            <tr>
                <td>
                    First Name:
                </td>
                <td>
                    <asp:TextBox ID="TextBox1" runat="server" />&nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator1"
                        runat="server" CssClass="triangle-border left" ErrorMessage="FirstName Required"
                        ControlToValidate="TextBox1" ValidationGroup="submit"></asp:RequiredFieldValidator><asp:RegularExpressionValidator
                            ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox1"
                            ValidationExpression="[a-zA-Z\s]+" CssClass="triangle-isosceles left" ErrorMessage="FName should be alphabetical"
                            Display="Dynamic" EnableClientScript="true"></asp:RegularExpressionValidator>
                </td>
            </tr>
            <tr>
                <td>
                    Last Name:
                </td>
                <td>
                    <asp:TextBox ID="TextBox2" runat="server" />&nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
                        runat="server" CssClass="triangle-border left" ErrorMessage="Last Name required"
                        ControlToValidate="TextBox2" ValidationGroup="submit"></asp:RequiredFieldValidator>
                    <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="TextBox2"
                        ValidationExpression="[a-zA-Z\s]+" ErrorMessage="LName should be alphabetical"
                        CssClass="triangle-isosceles left" Display="Dynamic" EnableClientScript="true"></asp:RegularExpressionValidator>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                    <asp:Button ID="Button1" runat="server" Text="Submit" ValidationGroup="submit" OnClick="Button1_Click" />
                    <asp:Label ID="Label1" runat="server" Font-Bold="true" />
                </td>
            </tr>
        </table>

Bind Date In Chart Using Datebase IN 3 Tier in C#

Bind Date In Chart Using Datebase IN 3 Tier in C#.

First of all create table in database like

ON ASPX PAGE :-

<asp:Chart ID="Chart1" runat="server" ViewStateMode="Enabled" Width="700PX" Height="400PX"
        BackColor="Wheat">
        <Titles>
            <asp:Title Font="Times New Roman, 12pt, style=Bold, Italic" ForeColor="Red" Name="Title"
                Text="Oskar Tamrakar">
            </asp:Title>
        </Titles>
        <Series>
            <asp:Series Name="Series1" ToolTip="Percentage" ChartArea="ChartArea1" ChartType="Column"
                YValuesPerPoint="4" LegendToolTip="COuntry Name" Color="#CC0000">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1">
                <Area3DStyle Enable3D="True" IsClustered="True" LightStyle="Realistic" Rotation="-20"
                    WallWidth="20" Inclination="10" />
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>

ON CODE BEHIND :-

Name space :-

using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using BusinessLayer.Entity;
using BusinessLayer.Manager;
using DataLayer.Data;
using System.Drawing;
using System.Text;
using System.IO;
using System.Drawing.Imaging;

protected void Page_Load(object sender, EventArgs e)
        {
            bind();
        }
        private void bind()
        {
            DataSet ds = new DataSet();
            ds = manager.Getcounrtyrecordsbyname();//stored procedure using 3 tier
            Chart1.DataSource = ds.Tables[0];
            Chart1.DataBind();
            Chart1.Legends.Add("CountryName").Title = "CountryName";
            Chart1.Series["Series1"]["DrawingStyle"] = "Emboss";
            Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
            Chart1.Series["Series1"].IsValueShownAsLabel = true;
            Chart1.ChartAreas["ChartArea1"].AxisX.Title = "CountryName";
            Chart1.ChartAreas["ChartArea1"].AxisY.Title = "CountryId";
            Chart1.Series["Series1"].XValueMember = "CountryName";
            Chart1.Series["Series1"].YValueMembers = "CountryId";
          
        }

ON BUSSINESS LAYER :-

public static DataSet Getcounrtyrecordsbyname()
        {
            return NGODataLayer.Group.Getcounrtyrecordsbyname();
        }


ON DATALAYER :-

public static DataSet Getcounrtyrecordsbyname()
        {
            return BusinessLayer.Dataaccess.DataAccess.GetData("usp_task6selectcountrytable", null);
        }

IN DATALAYER ADD CLASS DATA.CS :-

Ans paste code for GETDATA function.

public static DataSet GetData(string SPName, List<SqlParameter> Parameters)
        {
            using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText = SPName;
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd.Connection = con;

                    if (Parameters != null)
                    {
                        foreach (SqlParameter parameter in Parameters)
                        {
                            cmd.Parameters.Add(parameter);
                        }
                    }
                    con.Open();
                    DataSet ds = new DataSet();
                    SqlDataAdapter da = new SqlDataAdapter();
                    da.SelectCommand = cmd;
                    da.Fill(ds);
                    con.Close();
                    return ds;
                }
            }
        }

Just change CHART TYPE IN ASPX PAGE and get different type of chart

Show multiple file of your folder,download and delete from server in C#

Show multiple file of your folder,download and delete from server in C#

ASPX PAGE :-

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" EmptyDataText="No files found">
        <RowStyle BackColor="Wheat" />
            <Columns>
                <asp:BoundField DataField="Text" HeaderText="Files" HeaderStyle-BackColor="DarkOrange" HeaderStyle-ForeColor="White"  />
                <asp:TemplateField HeaderText="Save" HeaderStyle-BackColor="DarkOrange" HeaderStyle-ForeColor="White" >
                    <ItemTemplate>
                        <asp:LinkButton ID="lnkDownload" Text="save" Width="70px" CommandArgument='<%# Eval("Value") %>'
                            runat="server" OnClick="DownloadFile"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Remove" HeaderStyle-BackColor="DarkOrange" HeaderStyle-ForeColor="White">
                    <ItemTemplate>
                        <itemtemplate>
                        <asp:LinkButton ID="lnkDelete" Text="Remove" width="100px" CommandArgument='<%# Eval("Value") %>'
                            runat="server" OnClick="DeleteFile"></asp:LinkButton>
                    </itemtemplate>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>

NAMESPACES USED :-

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

CODE BEHIND ASPX.CS :-

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

                string[] filePaths = Directory.GetFiles(Server.MapPath("~/Images/"));               
                List<ListItem> files = new List<ListItem>();
                foreach (string filePath in filePaths)
                {
                    files.Add(new ListItem(Path.GetFileName(filePath), filePath));
                }
                GridView1.DataSource = files;
                GridView1.DataBind();
            }
        }

        protected void DownloadFile(object sender, EventArgs e)
        {
            string filePath = (sender as LinkButton).CommandArgument;
            Response.ContentType = ContentType;
            Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(filePath));
            Response.WriteFile(filePath);
            Response.End();
        }


        protected void DeleteFile(object sender, EventArgs e)
        {
            string filePath = (sender as LinkButton).CommandArgument;
            File.Delete(filePath);
            Response.Redirect(Request.Url.AbsoluteUri);
        }