 |
|
Code (C#)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace WindowsFormsApplication1
{
class TableUser : AccessDatabase
{
public bool AddNewUser(string UserName, string UserPassword, string UserEmail)
{
bool Success = false;
if (!IsUser(UserName))
{
base.CommandString = "Insert Into [Table_User] ([UserName], [UserPassword], [UserEmail]) Values (@UserName, @UserPassword, @UserEmail)";
base.AddParameter("@UserName", OleDbType.VarChar, UserName);
base.AddParameter("@UserPassword", OleDbType.VarChar, UserPassword);
base.AddParameter("@UserEmail", OleDbType.VarChar, UserEmail);
Success = base.ExecuteNonQuery();
}
return Success;
}
private bool IsUser(string UserName)
{
bool HaveUser = false;
base.CommandString = "Select Count(*) From [Table_User] Where [UserName]=@USerName";
base.AddParameter("@UserName", OleDbType.VarChar, UserName);
int User = (int)base.ExecuteScalar();
if (User > 0)
HaveUser = true;
return HaveUser;
}
}
}
|
 |
 |
 |
 |
Date :
2012-01-13 09:39:18 |
By :
pongtanakorn |
|
 |
 |
 |
 |
|
|
 |