Dotnet Learning Point : 04/20/12

20 April 2012

How to insert data into database with help of asp.net

About.aspx=>
<%@ Page Title="About Us" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeFile="About.aspx.cs" Inherits="About" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
    <style type="text/css">
    .style1
    {
        width: 100%;
    }
    .style2
    {
        width: 148px;
    }
</style>
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">

    <table class="style1">
    <tr>
        <td class="style2">
            User Name</td>
        <td>
            <asp:TextBox ID="t1" runat="server" Width="192px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style2">
            password</td>
        <td>
            <asp:TextBox ID="t2" runat="server" TextMode="Password" Width="190px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style2">
            retype password</td>
        <td>
            <asp:TextBox ID="t3" runat="server" TextMode="Password" Width="190px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style2">
            Address</td>
        <td>
            <asp:TextBox ID="t4" runat="server" ontextchanged="t4_TextChanged"
                Width="188px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style2">
            Mobile number</td>
        <td>
            <asp:TextBox ID="t5" runat="server" Width="188px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style2">
             </td>
        <td>
            <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit" />
        </td>
    </tr>
</table>

</asp:Content>
About.aspx.cs=>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
public partial class About : System.Web.UI.Page
{
    SqlConnection con;
    SqlCommand cmd;
    String s = ConfigurationManager.ConnectionStrings["cmd"].ToString();
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        con = new SqlConnection(s);
        con.Open();
        cmd = new SqlCommand("Insert into login values(@User_name,@pass,@address,@Mob_num)", con);
        cmd.Parameters.AddWithValue(@"User_name", t1.Text);
        cmd.Parameters.AddWithValue(@"pass", t2.Text);
        cmd.Parameters.AddWithValue(@"address", t4.Text);
            cmd.Parameters.AddWithValue(@"Mob_num", t5.Text);
            int x=cmd.ExecuteNonQuery();
            if (x > 0)
            {
                Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Data Insert')", true);
            }
            con.Close();

    }
    protected void t4_TextChanged(object sender, EventArgs e)
    {
    }
}

How give the comments in asp.net

Comments.aspx=>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Comments.aspx.cs" Inherits="Comments" %>
<!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></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <table>
<tr>
<td>Enter Name: </td>
<td><asp:TextBox ID="txtName" runat="server"/></td>
</tr>
<tr>
<td>Enter Subject: </td>
<td><asp:TextBox ID="txtSubject" runat="server"/></td>
</tr>
<tr>
<td valign="top">Enter Comments:</td>
<td><asp:TextBox ID="txtComment" runat="server" Rows="5" Columns="20" TextMode="MultiLine"/></td>
</tr>
<tr>
<td></td>
<td><asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" /></td>
</tr>
</table>
</div>
<div>
<asp:Repeater ID="RepDetails" runat="server">
<HeaderTemplate>
<table style=" border:1px solid #df5015; width:500px" cellpadding="0">
<tr style="background-color:#df5015; color:White">
<td colspan="2">
<b>Comments</b>
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr style="background-color:#EBEFF0">
<td>
<table style="background-color:#EBEFF0;border-top:1px dotted #df5015; width:500px" >
<tr>
<td>
Subject:
<asp:Label ID="lblSubject" runat="server" Text='<%#Eval("Subject") %>' Font-Bold="true"/>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblComment" runat="server" Text='<%#Eval("Comment") %>'/>
</td>
</tr>
<tr>
<td>
<table style="background-color:#EBEFF0;border-top:1px dotted #df5015;border-bottom:1px solid #df5015; width:500px" >
<tr>
<td>Post By: <asp:Label ID="lblUser" runat="server" Font-Bold="true" Text='<%#Eval("UserName") %>'/></td>
<td>Created Date:<asp:Label ID="lblDate" runat="server" Font-Bold="true" Text='<%#Eval("PostedDate") %>'/></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
    </div>
    </form>
</body>
</html>
Comments.aspx.cs=>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class Comments : System.Web.UI.Page
{

    SqlCommand cmd;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindRepeaterData();
        }
    }
    private SqlConnection con = new SqlConnection("Data Source=AMRIT;Initial Catalog=dct;Integrated Security=True");

protected void btnSubmit_Click(object sender, EventArgs e)
{

con.Open();
cmd = new SqlCommand("insert into Repeater_Table (UserName,Subject,Comment,PostedDate) values(@UserName,@Subject,@Comment,@PostedDate)", con);
cmd.Parameters.AddWithValue("@UserName", txtName.Text);
cmd.Parameters.AddWithValue("@Subject", txtSubject.Text);
cmd.Parameters.AddWithValue("@Comment", txtComment.Text);
cmd.Parameters.AddWithValue("@PostedDate", DateTime.Now);
cmd.ExecuteNonQuery();
con.Close();
txtName.Text = string.Empty;
txtSubject.Text = string.Empty;
txtComment.Text = string.Empty;
BindRepeaterData();
}
//Bind Data to Repeater Control
protected void BindRepeaterData()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Repeater_Table Order By PostedDate desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();
con.Close();
}
    }

Show and Hide Text in asp.net

How to show hide sidebar

Default.aspx=>

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"

CodeFile="Default.aspx.cs" Inherits="_Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">

</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <div>
        <h2 style="color: Navy; font-style: italic;">
            Wizard Example: show hide sidebar</h2>
        <asp:Wizard ID="Wizard1" runat="server" DisplaySideBar="true" BorderColor="RosyBrown"
            BorderWidth="2" HeaderText="Sample Wizard" HeaderStyle-BackColor="PeachPuff"
            HeaderStyle-ForeColor="SaddleBrown" HeaderStyle-Font-Size="Large" Height="200"
            Width="400">
            <WizardSteps>
                <asp:WizardStep Title="First Step">
                    <asp:Label ID="Label1" runat="server" Font-Bold="false" ForeColor="PaleVioletRed"
                        Font-Size="Large" Font-Names="Comic Sans MS" Text="This is first step">
                    </asp:Label>
                </asp:WizardStep>
                <asp:WizardStep Title="Second Step">
                    <asp:Label ID="Label2" runat="server" Font-Bold="false" ForeColor="PaleVioletRed"
                        Font-Size="Large" Font-Names="Comic Sans MS" Text="This is second step">
                    </asp:Label>
                </asp:WizardStep>
            </WizardSteps>
        </asp:Wizard>
        <br />
        <asp:Button ID="Button1" runat="server" ForeColor="SteelBlue" Text="Hide Wizard SideBar"
            Height="45" OnClick="Button1_Click" Font-Bold="true" />
        <asp:Button ID="Button2" runat="server" ForeColor="SteelBlue" Text="Show Wizard SideBar"
            Height="45" OnClick="Button2_Click" Font-Bold="true" />
    </div>

</asp:Content>

Deafault.aspx.cs=>

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 Button1_Click(object sender, EventArgs e)
    {
        Wizard1.DisplaySideBar = false;

}

    protected void Button2_Click(object sender, EventArgs e)
    {
        Wizard1.DisplaySideBar = true;

}

Upload and Download Files from file system

Default.aspx=>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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>Save and Download Files from file system</title>
<style type="text/css">
.modalBackground
{
background-color: Gray;
filter: alpha(opacity=80);
opacity: 0.8;
z-index: 10000;
}
.GridviewDiv {font-size: 100%; font-family: 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Arial, Helevetica, sans-serif; color: #303933;}
Table.Gridview{border:solid 1px #df5015;}
.Gridview th{color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;padding:0.5em 0.5em 0.5em 0.5em;text-align:center}
.Gridview td{border-bottom-color:#f0f2da;border-right-color:#f0f2da;padding:0.5em 0.5em 0.5em 0.5em;}
.Gridview tr{color: Black; background-color: White; text-align:left}
:link,:visited { color: #DF4F13; text-decoration:none }
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FileUpload ID="fileUpload1" runat="server" /><br />
<asp:Button ID="btnUpload" runat="server" Text="Upload" onclick="btnUpload_Click" />
</div>
<div>
<asp:GridView ID="gvDetails" CssClass="Gridview" runat="server" AutoGenerateColumns="false" DataKeyNames="FilePath">
<HeaderStyle BackColor="#df5015" />
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" />
<asp:BoundField DataField="FileName" HeaderText="FileName" />
<asp:TemplateField HeaderText="FilePath">
<ItemTemplate>
<asp:LinkButton ID="lnkDownload" runat="server" Text="Download" OnClick="lnkDownload_Click"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
Default.aspx.cs=>
using System;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    private SqlConnection con = new SqlConnection("Data Source=AMRIT;Initial Catalog=dct;Integrated Security=True");
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            BindGridviewData();
        }
    }
    // Bind Gridview Data
    private void BindGridviewData()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from FilesTable",con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        con.Close();
        gvDetails.DataSource = ds;
        gvDetails.DataBind();
    }
    // Save files to Folder and files path in database
    protected void btnUpload_Click(object sender, EventArgs e)
    {
        string filename = Path.GetFileName(fileUpload1.PostedFile.FileName);
        fileUpload1.SaveAs(Server.MapPath("Files/"+filename));
        con.Open();
        SqlCommand cmd = new SqlCommand("insert into FilesTable(FileName,FilePath) values(@Name,@Path)",con);
        cmd.Parameters.AddWithValue("@Name",filename );
        cmd.Parameters.AddWithValue("@Path", "Files/"+filename );
        cmd.ExecuteNonQuery();
        con.Close();
        BindGridviewData();
    }
    // This button click event is used to download files from gridview
    protected void lnkDownload_Click(object sender, EventArgs e)
    {
        LinkButton lnkbtn = sender as LinkButton;
        GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow;
        string filePath = gvDetails.DataKeys[gvrow.RowIndex].Value.ToString();
        Response.ContentType = "image/jpg";
        Response.AddHeader("Content-Disposition", "attachment;filename=\"" + filePath + "\"");
        Response.TransmitFile(Server.MapPath(filePath));
        Response.End();
    }
}

Menu Bar

Total Pageviews

20 April 2012

How to insert data into database with help of asp.net

How give the comments in asp.net

Show and Hide Text in asp.net

How to show hide sidebar

Upload and Download Files from file system

Contact Form

Latest Update menu

Dot Net Learning Point

Followers