How to store data in ASP.NET
19
June
2013

1) Go to file and select New Website.
2) In the Solution Explorer right click on the project an select Add New Item and select Web Form and give file name as you want for example (Default.aspx).
3) In the Default.aspx page we can design layout/form which is displayed in front of the user where they can insert data.
See below to write code to create layout/form.Here we design simple login form.

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>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align: center">
<div style="text-align: center">

<table>
<tr>
<td style="width: 100px">
user name
</td>
<td style="width: 100px">
<asp:TextBox ID="txtunm" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td style="width: 100px">
password
</td>
<td style="width: 100px">
<asp:TextBox ID="txtpwd" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="2" style="text-align: center">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Insert" />
</td>
</tr>
<tr>
<td colspan="2" style="text-align: center">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></td>
</tr>
</table>

</div>
</div>
</form>
</body>
</html>

Now we write the code to store data in to the database.

Default.aspx.cs:-


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;  //don't forget to add

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("Connection String");

string sqlstr;
sqlstr="insert into Login values('"+txtunm.Text+"','"+txtpwd.Text+"')";

SqlDataAdapter sda=new SqlDataAdapter(sqlstr,cn);

DataSet dst = new DataSet();
sda.Fill(dst);
Label1.Text = "record is stored";
}
}

That’s it.Now run the website through F5 and see the result.

ASP.NET Project Training in Vadodara

Pin It