Note:-Don't copy red coloured text,its only for better explanation of code.
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.
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");
---------------------------------------------------------------------------------------------------------
//connection
string will be provided when you create database.first go to solution
explorer->right click on site->click on add new item->select
Sql server database.
//Then
you can see your database in server explorer window.click on the
database,so you can see connection string in the property window.Just
copy it and paste in above code instead of "Connection String".
//Then add @ before starting inverted coma "".So you will not see the redline below the 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.
0 comments:
Post a Comment