学步园

 今天纠结了一上午的问题，于下午3点12分尘埃落定！

事情是这样的：

作为一个里程碑记录下吧，也算是我第一次将asp.net与数据库结合，并完成从软件编程到web的过渡。

在此感谢今天为我解决问题的“杀手”（也称老道），还有以前为我解决问题的大队、御风、华哥等牛...

言归正传，本文介绍一下怎样在asp.net平台上连接数据库：（C#编写的软件连接数据库见前几篇）

 using System;<br /> using System.Collections.Generic;<br /> using System.ComponentModel;<br /> using System.Data;<br /> using System.Drawing;<br /> using System.Linq;<br /> using System.Text;<br /> using System.Data.OleDb;<br /> using System.Data.SqlClient;<br /> using System.Runtime.InteropServices;<br /> using System.Configuration;<br /> using System.Web.UI.WebControls;<br /> using System.Web.Services.Description;</p> <p>public partial class _Default : System.Web.UI.Page<br /> {<br /> static DataSet ds;<br /> int index;<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> //set mode of textbox2 as password<br /> //在asp.net中设置textbox 属性为password (C#中是passwordchar = ……)<br /> TextBox2.TextMode = TextBoxMode.Password ;</p> <p> //count the num of user,as we can add the new user with index++(as id)<br /> string strConnection = ConfigurationManager.AppSettings["Str.Properties.Settings.masterConnectionString"].ToString();<br /> SqlConnection objConnection = new SqlConnection(strConnection);<br /> objConnection.Open();<br /> string sql = "count user num";<br /> sql="select userid as userid,name as name from judging";<br /> SqlDataAdapter adp = new SqlDataAdapter(sql, objConnection);<br /> ds = new DataSet();<br /> ds.Clear();<br /> adp.Fill(ds, "judging");<br /> index = ds.Tables[0].Rows.Count+1;<br /> }</p> <p> //Register function<br /> protected void Button1_Click(object sender, EventArgs e)<br /> {<br /> /******************method 1*******************/<br /> //string strConnection = "Data Source=ZRQ-PC;";<br /> //strConnection += "Initial Catalog=master;Integrated Security=True";<br /> //SqlConnection objConnection = new SqlConnection(strConnection);</p> <p> /******************method 2->web config 中用</connectionStrings>*******************/<br /> /*ConfigurationManager.ConnectionStrings是用来读取配置文件web.config中<connectionStrings></connectionStrings><br /> ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString是来读取<connectionStrings></connectionStrings>内部name为MyConnection的connectionString内容的<br /> */<br /> // string strConnection = ConfigurationManager.ConnectionStrings["Str.Properties.Settings.masterConnectionString"].ConnectionString;<br /> //SqlConnection objConnection = new SqlConnection(strConnection);</p> <p> /******************method 3->web config 中用</appSettings>*******************/<br /> string strConnection = ConfigurationManager.AppSettings["Str.Properties.Settings.masterConnectionString"].ToString();<br /> SqlConnection objConnection = new SqlConnection(strConnection);</p> <p> objConnection.Open();<br /> SqlCommand cmd = new SqlCommand("select * from judging where userid='" + TextBox1.Text.Trim() + "'", objConnection);<br /> string sql = "insert into judging (userid,name,password) values('" + (index++) + "','" + TextBox1.Text.Trim() + "','" + TextBox2.Text.Trim() + "')";<br /> cmd.CommandText = sql;<br /> cmd.ExecuteNonQuery();<br /> }</p> <p> //login function<br /> protected void Button2_Click(object sender, EventArgs e)<br /> {<br /> string strConnection = ConfigurationManager.AppSettings["Str.Properties.Settings.masterConnectionString"].ToString();<br /> SqlConnection objConnection = new SqlConnection(strConnection);<br /> objConnection.Open();<br /> SqlCommand cmd = new SqlCommand("select * from judging where name='" + TextBox1.Text.Trim() + "'", objConnection);<br /> string sql="select * from judging where name='"+TextBox1.Text+"'and password='"+TextBox2.Text+"'";<br /> cmd.CommandText = sql;<br /> /*<br /> ***********************************************************************************************<br /> *判断是否有此ID,ExecuteScalar() return the first column of the first row in the result set.<br /> */<br /> if (cmd.ExecuteScalar() == null)//无此用户<br /> {<br /> // MessageBox.Show("用户名输入错误", "提示", 0);<br /> Response.Write("用户名输入错误");<br /> }<br /> else<br /> {<br /> Response.Write("Welcome to "+TextBox1.Text );<br /> }<br /> }<br /> }<br />

 <!--web.config--></p> <p><?xml version="1.0"?><br /> <!--<br /> 注意: 除了手动编辑此文件以外，您还可以使用<br /> Web 管理工具来配置应用程序的设置。可以使用 Visual Studio 中的<br /> “网站”->“Asp.Net 配置”选项。<br /> 设置和注释的完整列表在<br /> machine.config.comments 中，该文件通常位于<br /> /Windows/Microsoft.Net/Framework/v2.x/Config 中<br /> --><br /> <configuration><br /> <configSections><br /> <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"><br /> <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"><br /> <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/><br /> <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"><br /> <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/><br /> <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/><br /> <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/><br /> <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/><br /> </sectionGroup><br /> </sectionGroup><br /> </sectionGroup><br /> </configSections><br /> <!-- /******************method 2->web config 中用</appSettings>*******************/--><br /> <appSettings><br /> <add key="Str.Properties.Settings.masterConnectionString" value="Data Source=ZRQ-PC;Initial Catalog=master;Integrated Security=True"/><br /> </appSettings></p> <p> <!-- /******************method 3->web config 中用</connectionStrings>*******************/--><br /> <connectionStrings><br /> <!--<br /> <add name="Str.Properties.Settings.masterConnectionString" connectionString="Data Source=ZRQ-PC;Initial Catalog=master;Integrated Security=True"<br /> providerName="System.Data.SqlClient" /><br /> --><br /> </connectionStrings><br /> <system.web><br /> ……