VS2010与access2010实现登录和注册 在access2010中有数据库user(有user_name和user_pwd两个字段),在vs2010的窗体中有两个文本框和两个按钮(登录和注册),想要用C#实现登录和注册功能。求能人指点,最好能重点说一下数据库的连接。access2010c#数据库vs2010 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个有很多吧,就是数据库的检索和插入//连接数据库//定义数据库连接对象OleDbConnection accConnection//定义数据库连接字符串string strConnection = "Provider=Microsoft.ACE.OlEDB.12.0;" + " Data Source=DB\\数据库名.accdb;"//初始化accConnection = new OleDbConnection(strConnection);//使用OleDbConnection对象的open()方法,打开与数据库的连接accConnection.open();//一般都与在try{...}catch(..){...}语句块中与数据库的连接就打开了如果是登陆的话可以使用OleDbDataReader对象如果是注册可以使用OleDbDataAdapter对象对象楼主多看书噢,关于ado.net的书都有,基本的 下面的是添加 剩下的修改啦删除都差不多,string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("你的access.mdb");OleDbConnection conn = new OleDbConnection(strCnn); conn.Open(); string sql = "insert into form (gzsx,fzr,jdr,jhwcsj,sjwcsj,knd,wcjg) values ('" + gzsx_TextBox.Text + "','" + fzr_TextBox.Text + "','" + jdr_TextBox.Text + "','" + jhwcsj_TextBox.Text + "','" + sjwcsj_TextBox.Text + "','" + knd_TextBox.Text + "','" + wcjg_TextBox.Text + "')"; OleDbCommand cmd = new OleDbCommand(sql, conn); cmd.ExecuteNonQuery(); Response.Write("添加成功"); conn.Close(); 楼主我有一个类,如果有疑问邮箱联系/绑定数据到DataGridViewpublic void selects() { string str1 = "select * from table1"; dataGridView1.DataSource = SqlHelper.GetDataView(str1,CommandType.Text); }//执行sql语句,返回DataGridViewpublic static DataView GetDataView(string commText, CommandType commType) { OleDbCommand command = new OleDbCommand(commText, Connection); OleDbDataAdapter da = new OleDbDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds, "table"); return ds.Tables["table"].DefaultView; }private static OleDbConnection connection; #region 1.数据库连接字符串 /// <summary> /// 连接数据库 /// </summary> public static OleDbConnection Connection { get { //获取连接字符串 string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\Backup\\projects\\customsoftware\\customsoftware\\DB\\Access.accdb"; if (connection == null) { connection = new OleDbConnection(connString); connection.Open(); } else if (connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } else if (connection.State == System.Data.ConnectionState.Broken) { connection.Close(); connection.Open(); } return connection; } } 有关socket 编码,大侠 waveInGetDevCaps 高分求C#写的无刷新聊天室源码!!! 请问一下,我怎么样在C#调用windows API函数? 只请C#图形编程高手回答的几个问题: DES加密解密 [疑问]用GDI+绘图曲线时,为何会出现锯齿形状?该怎么解决? VS.net2003创建工程问题!!! 如何在多个窗体中使用Ado.net 初学者:提问 在ASP中有RS.RECORDCOUNT取得总共的查询条数,现在C#中用什么表示呀?马上就结分 DevExpress ProgressPanel控件怎么用? C#初学者求解
OleDbConnection accConnection
//定义数据库连接字符串
string strConnection = "Provider=Microsoft.ACE.OlEDB.12.0;"
+ " Data Source=DB\\数据库名.accdb;"//初始化
accConnection = new OleDbConnection(strConnection);//使用OleDbConnection对象的open()方法,打开与数据库的连接
accConnection.open();
//一般都与在try{...}catch(..){...}语句块中
与数据库的连接就打开了
如果是登陆的话可以使用OleDbDataReader对象如果是注册可以使用OleDbDataAdapter对象对象楼主多看书噢,关于ado.net的书都有,基本的
string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("你的access.mdb");
OleDbConnection conn = new OleDbConnection(strCnn);
conn.Open();
string sql = "insert into form (gzsx,fzr,jdr,jhwcsj,sjwcsj,knd,wcjg) values ('" + gzsx_TextBox.Text + "','" + fzr_TextBox.Text + "','" + jdr_TextBox.Text + "','" + jhwcsj_TextBox.Text + "','" + sjwcsj_TextBox.Text + "','" + knd_TextBox.Text + "','" + wcjg_TextBox.Text + "')";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.ExecuteNonQuery();
Response.Write("添加成功");
conn.Close();
public void selects()
{
string str1 = "select * from table1";
dataGridView1.DataSource = SqlHelper.GetDataView(str1,CommandType.Text);
}
//执行sql语句,返回DataGridView
public static DataView GetDataView(string commText, CommandType commType)
{
OleDbCommand command = new OleDbCommand(commText, Connection);
OleDbDataAdapter da = new OleDbDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds, "table");
return ds.Tables["table"].DefaultView;
}
private static OleDbConnection connection;
#region 1.数据库连接字符串
/// <summary>
/// 连接数据库
/// </summary>
public static OleDbConnection Connection
{
get
{
//获取连接字符串
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\Backup\\projects\\customsoftware\\customsoftware\\DB\\Access.accdb";
if (connection == null)
{
connection = new OleDbConnection(connString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
return connection;
}
}