怎么使用SQL和.NET编写的登陆系统连接
来源:百度知道 编辑:UC知道 时间:2024/06/29 02:50:45
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Data.SqlClient ;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string StrConn = "server = 211.87.182.90; uid = Administrator ; password = 090; database =shi.xls";
SqlConnection SqlConn = new SqlConnection(StrConn);
SqlConn.Open();
}
}
看看这个登陆的数据库连接语句,有没有错。。。
这是连接数据库的类,你要能懂三层架构的话直接调用好了,注意传参就好
using System;
using System.Data;
using System.Data.SqlClient;
namespace Aptech.Student.Common
{
public class DataBaseOperate:IDisposable
{
// 保存数据库连接字符串
private string m_sConnectionString;
// 数据库连接标志
private bool m_bConnected;
// 存储过程开启标志
private bool m_bTransaction;
//数据库连接对象
private SqlConnection m_sqlConnection;
private SqlCommand m_sqlCommand;
private SqlTransaction m_sqlTransaction;
private SqlDataAdapter m_sqlDataAdapter;
/// <summary>
/// 构造函数,初始化内部变量
/// </summary>
public DataBaseOperate()
:this("user id=sa;password=510902;data source=\"YAOYANG\\YAOYANG\";initial catalog=Student")
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public DataBaseOperate(
string