网站前台与数据库连接的问题
青红脸 2012-08-16 08:17:24 正在做一个预约板块,需要输入学号和密码,然后与数据库中的学生信息进行比对,如果存在这样的学号和密码,则登录到另一个页面中,然后在另一个页面中填写一个表单,然后提交,数据库进行存储。
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
string strConstrin = ConfigurationManager.ConnectionStrings["Constring"].ConnectionString;,1,这一句话有什么作用??
protected void Page_Load(object sender, EventArgs e)
{
2, 这里应该写些什么??
}
protected void Button1_Click(object sender, EventArgs e)
{
string number= this.TextBox1.Text;
string passWord = this.TextBox2.Text;
InsertData(name, number);
}
private void InsertData(string number, string passWord)
{
SqlConnection con = new SqlConnection(strConstrin);
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO xinxi (number,passWord) VALUES (" + number + "," + passWord + ")";
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('登录成功!')</script>");
}
private void BindData()
{
SqlConnection con = new SqlConnection(strConstrin);
string strCmdText = "SELECT * FROM xinxi";
con.Open();
SqlDataAdapter Adapter = new SqlDataAdapter(strCmdText, con);
DataSet Ds = new DataSet();
Adapter.Fill(Ds);
3,这里应该怎样写
con.Close();
}
希望大家可以帮助我一下,大家也可以重新帮我写一下,谢谢了
}