ASP.Net Example

how to maintain session and how to Display Different User data

Unknown 23:12 Add Comment

Unknown

Click hear to get Whole Example of Session maintain and display user info use of session.

Get Example :- Click On Session

How to display data in Detailview control from database(Declarative Binding) in ASP.NET -Example

Unknown 23:33 Add Comment

Unknown

.aspx File

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource2" Height="50px" Width="125px">
<Fields>
<asp:BoundField DataField="id" HeaderText="id" SortExpression="id" />
<asp:BoundField DataField="user_name" HeaderText="user_name" SortExpression="user_name" />
<asp:BoundField DataField="password" HeaderText="password" SortExpression="password" />
</Fields>
</asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [All_Users]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [All_Users]"></asp:SqlDataSource>
</form>
</body>
</html>

.aspx.cs File

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)

{

}

WE can get step to declarative binding same as another controls...

How to display data in DataList control from Database(Declarative Binding) in ASP.NET -Example

Unknown 23:27 Add Comment

Unknown

.aspx File

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
id:
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
<br />
user_name:
<asp:Label ID="user_nameLabel" runat="server" Text='<%# Eval("user_name") %>' />
<br />
password:
<asp:Label ID="passwordLabel" runat="server" Text='<%# Eval("password") %>' />
<br />
<br />
</ItemTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [All_Users]"></asp:SqlDataSource>
</form>
</body>

</html>

.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)

{

}

How to Upload Image in database Store in folder in ASP.NET-Example

Unknown 22:41 Add Comment

Unknown

Upload IMAGE.ASPX

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

<!DOCTYPE html>

</head>

<div>

</div>

<asp:FileUpload ID="FileUpload1" runat="server" />

<p>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<asp:Label ID="Label2" runat="server" Text="plz Enter any image first.." Visible="False"></asp:Label>

</p>

<p>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />

</p>

<p>

<asp:Label ID="Label1" runat="server" Text="PhotoUploaded" Visible="False"></asp:Label>

</p>

</form>

</body>

</html>

UPLOAD IMAGE.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.SqlClient;

using System.Data;

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

{

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\Asp_dot_ne\WebSite3\App_Data\pro_gridview.mdf;Integrated Security=True");

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

if (TextBox1.Text == "" || FileUpload1.FileName == "")

{

Label2.Visible = true;

Label1.Visible = false;

}

else

{

conn.Open();

string str = "~/myupload" + FileUpload1.FileName;

FileUpload1.SaveAs(Server.MapPath(str));

cmd = new SqlCommand("insert into imgupload values('" + str + "','" + TextBox1.Text + "')", conn);

cmd.ExecuteNonQuery();

conn.Close();

Label1.Visible = true;

Label2.Visible = false;

}

How to insert data in SQL database in ASP.NET-Example

Unknown 22:39 Add Comment

Unknown

INSERT.aspx

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

<!DOCTYPE html>

.auto-style1 {

width: 100%;

}

.auto-style2 {

width: 98px;

}

</style>

</head>

<body>

<tr>

<td>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td class="auto-style2">Address</td>

<td>

<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

</td>

</tr>

</table>

<br />

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Insert" />

<br />

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

</form>

</body>

</html>

INSERT.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.SqlClient;

using System.Data;

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

{

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\Program OF Asp.net\WebSite2\App_Data\Database.mdf;Integrated Security=True");

SqlCommand cmd; //for insert update delete.

SqlDataAdapter adp;

DataTable dt;

public void disp_emp() // create Function and define it.

{ // Or manualy you can write it.

conn.Open();

adp = new SqlDataAdapter("select * from emp", conn);

dt = new DataTable();

adp.Fill(dt);

GridView1.DataSource = dt;

GridView1.DataBind();

conn.Close();

}

protected void Page_Load(object sender, EventArgs e)

{

disp_emp(); //define class.

}

protected void Button1_Click(object sender, EventArgs e)

{

conn.Open();

cmd = new SqlCommand("insert into emp values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')", conn);

cmd.ExecuteNonQuery();

conn.Close();

disp_emp(); //define class.

}

How to Update data in SQL database in ASP.NET-Example

Unknown 22:38 Add Comment

Unknown

UPDATE.ASPX

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

<!DOCTYPE html>

.auto-style1 {

width: 100%;

}

.auto-style2 {

width: 98px;

}

</style>

</head>

<body>

<tr>

<td>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td class="auto-style2">Address</td>

<td>

<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

</td>

</tr>

</table>

<br />

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Update" />

<br />

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

</form>

</body>

</html>

UPDATE.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.SqlClient;

using System.Data;

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

{

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\Program OF Asp.net\WebSite2\App_Data\Database.mdf;Integrated Security=True");

SqlCommand cmd; //for insert update delete.

SqlDataAdapter adp;

DataTable dt;

public void disp_emp() // create class and define it.

{ // Or manualy you can write it.

conn.Open();

adp = new SqlDataAdapter("select * from emp", conn);

dt = new DataTable();

adp.Fill(dt);

GridView1.DataSource = dt;

GridView1.DataBind();

conn.Close();

}

protected void Page_Load(object sender, EventArgs e)

{

disp_emp(); //define class.

}

protected void Button1_Click(object sender, EventArgs e)

{

conn.Open();

cmd = new SqlCommand("update emp set name = '" + TextBox2.Text + "', address = '" + TextBox3.Text + "' where id = '" + TextBox1.Text + "'", conn);

cmd.ExecuteNonQuery();

conn.Close();

disp_emp(); //define class.

}

How to delete data in SQL database in ASP.NET-Example

Unknown 22:37 Add Comment

Unknown

DELETE.ASPX.CS

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

<!DOCTYPE html>

.auto-style1 {

width: 100%;

}

.auto-style2 {

width: 98px;

}

</style>

</head>

<body>

<tr>

<td>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td class="auto-style2">Address</td>

<td>

<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

</td>

</tr>

</table>

<br />

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Delete" />

<br />

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

</form>

</body>

</html>

DELETE.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.SqlClient;

using System.Data;

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

{

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\Program OF Asp.net\WebSite2\App_Data\Database.mdf;Integrated Security=True");

SqlCommand cmd; //for insert update delete.

SqlDataAdapter adp;

DataTable dt;

public void disp_emp() // create class and define it.

{ // Or manualy you can write it.

conn.Open();

adp = new SqlDataAdapter("select * from emp", conn);

dt = new DataTable();

adp.Fill(dt);

GridView1.DataSource = dt;

GridView1.DataBind();

conn.Close();

}

protected void Page_Load(object sender, EventArgs e)

{

disp_emp(); //define class.

}

protected void Button1_Click(object sender, EventArgs e)

{

conn.Open();

cmd = new SqlCommand("delete from emp where id = '" + TextBox1.Text + "'", conn);

cmd.ExecuteNonQuery();

conn.Close();

disp_emp(); //define class.

}

Featured Posts