Login. aspx
Create a text box for username and password on the page, and click "Log on ".
-----------------------
Login. aspx. CS
Protected void submit_click (Object sender, eventargs E)
{
Dataaccess. class1 DAC = new dataaccess. class1 ();
If (DAC. checklogin (this. uname. text, this. pwd. Text ))
// Response. Write ("success! ");
// Response. Redirect ("default. aspx? ");
Server. Transfer ("default. aspx ");
Else
Response. Write ("failed! ");
// Server. Transfer ("login. aspx ");
}
----------------------------------------------------
Default. aspx
Create a gridview on the page and enter the text box and button for the content to be written to the database.
-------------------------
Default. aspx. CS
Protected void page_load (Object sender, eventargs E)
{
If (! Ispostback)
{
Binddata ();
}
}
Public void binddata ()
{// 51aspx.com
Dataaccess. class1 DAC = new dataaccess. class1 ();
Dataset DS = DAC. getusers ();
This. gridview1.datasource = Ds. Tables [0]. defaultview;
This. gridview1.databind ();
}
Protected void button#click (Object sender, eventargs E)
{
Dataaccess. class1 DAC = new dataaccess. class1 ();
Dataset DS = DAC. getusers ();
Datarow DR = Ds. Tables [0]. newrow ();
Dr ["usersname"] = This. textbox1.text;
Dr ["passwords"] = This. textbox2.text;
Dr ["blogname"] = This. textbox3.text;
DS. Tables [0]. Rows. Add (DR );
DAC. updatabystoredprocedure (DS );
Binddata (); // 51aspx.com
}
Common Class Library:
Public const string connectstring = "Server = localhost; database = dbxblog; uid = xblog; Password = 123456 ";
// SQL
Public const string SQL _getuser = "select * from users ";
// Table
Public const string table_users = "users ";
// Storedprocedure
Public const string storedprocedure_insert = "insertusers ";
Dataaccess class library (data layer): sqlconnection Cn = new sqlconnection (common. class1.connectstring );
Sqldataadapter da;
Dataset DS = new dataset ();
// Gettable
Public dataset getusers ()
{
Sqlcommand cmd = new sqlcommand (common. class1. SQL _ getuser, CN );
DA = new sqldataadapter (CMD );
Da. Fill (DS, common. class1.table _ users );
Return Ds;
}
// Login
Public bool checklogin (string name, string PWD)
{
Try
{
Sqlcommand cmd = new sqlcommand ("select count (*) from users where usersname = '" + name + "' and passwords = '" + PWD + "'", CN );
CN. open ();
Int COUNT =-1;
Count = convert. toint32 (CMD. executescalar ());
If (count <1)
Return false;
Return true;
}
Catch (exception ex)
{
Return false;
}
}
// Textbox updata
Public void updata (Dataset DS)
{
Sqlcommand cmd = new sqlcommand ("insert into users (usersname, passwords, blogname) valuse (@ usersname, @ passwords, @ blogname)", CN );
Cmd. Parameters. Add ("@ usersname", sqldbtype. varchar, 20, "usersname ");
Cmd. Parameters. Add ("@ passwords", sqldbtype. varchar, 50, "passwords ");
Cmd. Parameters. Add ("@ blogname", sqldbtype. varchar, 20, "blogname ");
DA = new sqldataadapter ();
Da. insertcommand = cmd;
CN. open ();
Da. Update (DS, common. class1.table _ users );
CN. Close ();
}
// Stroedprocedure updata
Public void updatabystoredprocedure (Dataset DS)
{
Sqlcommand cmd = new sqlcommand (common. class1.storedprocedure _ insert, CN );
Cmd. Parameters. Add ("@ usersname", sqldbtype. varchar, 20, "usersname ");
Cmd. Parameters. Add ("@ passwords", sqldbtype. varchar, 50, "passwords ");
Cmd. Parameters. Add ("@ blogname", sqldbtype. varchar, 20, "blogname ");
Cmd. commandtype = commandtype. storedprocedure;
DA = new sqldataadapter ();
Da. insertcommand = cmd;
CN. open ();
Da. Update (DS, common. class1.table _ users );
CN. Close ();
}