弟四讲数据库开发.ppt

第四讲 数据库开发实例 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 数据库开发实例 建立数据库：数据表 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 数据库开发实例 1、设置config文件 appSettings add key=ConnectionString value=Server=(local);user id=saews;pwd=123;DataBase=dbSAEWS;pooling=true/add /appSettings appSettings add key=ConnectionString value=“Data Source=.\SQLEXPRESS; Initial Catalog=webTest; Integrated Security=SSPI/add /appSettings Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 数据库开发实例 2、添加“类”文件并在其中添加相关底层代码（默认名class1） 3、 “类”文件添加相关引用：using System.Data.SqlClient; static public bool ExecuteSql(string sqlStr) { SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings[ConnectionString]); try { SqlCommand com = new SqlCommand(sqlStr, conn); conn.Open(); com.ExecuteNonQuery(); conn.Close(); return true; } catch (Exception ee) { conn.Close(); return false; } } Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 实例1——用户登录 static public DataSet GetDsFromSql(string sqlStr) { SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings[ConnectionString]); DataSet ds = new DataSet(); try { SqlDataAdapter da = new SqlDataAdapter(sqlStr, conn); conn.Open(); da.Fill(ds); } catch (Exception) { ds.Tables.Add(TempTable); } conn.Close(); return ds; } Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. protected void btnOK_Click(object sender, EventArgs