System.Configuration.ConfiguartinSettings.AppSettings["connString"].ToString();
这个表示从web.config中提取connection string
不过再visual stuido 2005中,要使用下面的不然有可能出现 connectstring 属性尚未初使化的问题.
修改为以下通过,并且成功得到
System.Configuration.ConfigurationManager.ConnectionStrings["ahaoaConnectionString"].ToString();
哈哈太开心了.
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["xpConnectionString"].ToString());
SqlCommand comm;
DateTime dt = DateTime.Now;
string stradduser = "insert into User_reg (User_name,User_pass,User_Question,User_Answer,User_Mail,User_RegTime) Values (@username,@password,@question,@answer,@mail,@time)";
SqlParameter parmuser = new SqlParameter("@username", SqlDbType.VarChar);
SqlParameter parmpass = new SqlParameter("@password", SqlDbType.VarChar);
SqlParameter parmques = new SqlParameter("@question", SqlDbType.VarChar);
SqlParameter parmanswer = new SqlParameter("@answer", SqlDbType.VarChar);
SqlParameter parmmail = new SqlParameter("@mail", SqlDbType.VarChar);
SqlParameter parmtime = new SqlParameter("@time", SqlDbType.DateTime);
comm = new SqlCommand(stradduser, conn);
parmuser.Value = tbuser.Text;
parmpass.Value = tbpass.Text;
parmques.Value = tbqiz.Text;
parmanswer.Value = tbanswer.Text;
parmmail.Value = tbmail.Text;
parmtime.Value = dt;
comm.Parameters.Add(parmuser);
comm.Parameters.Add(parmpass);
comm.Parameters.Add(parmques);
comm.Parameters.Add(parmanswer);
comm.Parameters.Add(parmmail);
comm.Parameters.Add(parmtime);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();