Question

asp.net网站后台如何和sqlserver2005进行连接 数据库该如何建立？能给点提示吗？

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected SqlConnection GetConnection()
{
string conn = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection myConn = new SqlConnection(conn);
return myConn;

}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
//与数据库的连接
SqlConnection conn = GetConnection();
conn.Open();
string sqlStr;
sqlStr = "select * from Tb_Login where UseName='" + Login1.UserName + "' and UsePassword='" + Login1.Password + "'";

SqlDataAdapter adp = new SqlDataAdapter(sqlStr, conn);
DataSet ds = new DataSet();
adp.Fill(ds);

if (!(ds.Tables.Count < 0))
{
Response.Redirect("NavigatePage.aspx?UserName=" + Login1.UserName.ToString());
}
else
Response.Write("登录失败");
adp.Dispose();
ds.Dispose();
conn.Close();

不知道该如何建立数据库！

Answer 1

在web.config文件的ConnectionString字段写好你的连接字符串就可以了。
我看了你的代码，没什么问题，只要连接字符串正确就可以正常连接数据库了。格式如下：
data source = 211.122.122.122,1433;uid=sa;pwd=abcdefg

自己对照你的服务器信息修改吧

Answer 2

SqlConnection conn = new SqlConnection();
String connString = "server = 127.0.0.1; user=sa; password = sa";
conn.ConnectionString = connString;
conn.Open();
SqlCommand cmd = new SqlCommand(“create database AAA”);
cmd.Connection = conn;
执行后，重新连接即可！