using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace LoginSite
{
public class loginClass /////////Chek if user exist
{
static string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\WebSites\myFirstSite\DB\users1.mdb;Persi st Security Info=True";
public static bool logAuth(string username, string password)
{
string query = "SELECT user,pass from userAuth";
OleDbConnection conn = new OleDbConnection(connStr);
OleDbCommand cmd = new OleDbCommand(query, conn);
conn.Open();
OleDbDataReader rd = cmd.ExecuteReader();
bool userExist = false;
while (rd.Read())
{
if (username == rd["user"].ToString() && password == rd["pass"].ToString())
{
userExist = true;
}
}
if (userExist)
{
query = String.Format("UPDATE userAuth SET login={0} WHERE user ='{1}'", userExist, username);
cmd = new OleDbCommand(query, conn);
cmd.ExecuteNonQuery();
}
conn.Close();
return userExist;
}
}
public class registrationClass /////////// INSERT INTO DB (access)
{
static string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\WebSites\\myFirstSite\\DB\\users1.mdb;P ersist Security Info=True";
public static string details(string username, string pass, string email)
{
bool Login = true;
string input;
OleDbConnection conn = new OleDbConnection(connStr);
input = @"INSERT INTO userAuth ([user], [pass], [mail], [login]) VALUES ('" + username + "', '" + pass + "', '" + email + "', " + Login + " ) ";
OleDbCommand cmd = new OleDbCommand(input, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
String.Format("Error: " + e.Message);
}
finally
{
conn.Close();
}
return String.Format("Done");
}
}
יש עוד הרבה...........................
מקווה שזה יספר לבנתיים :-)