silverlight连接SQL Server数据库

来源：互联网发布：惊天战神游戏源码编辑：程序博客网时间：2024/05/22 00:38

1.和sqlite基本相同，只是连接语句略有差别

using System.Data;using System.Data.SqlClient;using System.Web.Configuration;/// <summary>        /// 查找所有数据        /// </summary>        /// <param name="sql"></param>        /// <returns></returns>        static public DataSet DBselect(string sql)        {            string conn;            conn = WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;            try            {                using (SqlConnection cnn = new SqlConnection(conn))                {                    cnn.Open();                    using (SqlTransaction trans = cnn.BeginTransaction(IsolationLevel.Serializable))                    {                        try                        {                            using (SqlCommand cmd = new SqlCommand(sql, cnn))                            {                                cmd.Transaction = trans;                                using (DataSet ds = new DataSet())                                {                                    using (SqlDataAdapter da = new SqlDataAdapter(cmd))                                    {                                        da.Fill(ds);                                        trans.Commit();                                    }                                    return ds;                                }                            }                        }                        catch (Exception ex)                        {                            trans.Rollback();                            return new DataSet();                            throw ex;                        }                        finally                        {                        }                    }                }            }            catch (Exception ex)            {                return new DataSet();                throw ex;            }        }

2.在web.config中加入数据源信息

<appSettings>    <add key="DBappSetting" value="Data Source=(localdb)/Projects;Initial Catalog=SLRiaTest;Integrated Security=True;Connect Timeout=100;Encrypt=False;TrustServerCertificate=False"/>  </appSettings>  <connectionStrings>    <add name="myConnectionString" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\User\Documents\database.mdf;Integrated Security=True;Connect Timeout=30"/>  </connectionStrings>

3.在SQL server 中新建数据库信息，查看属性Data Source 替换connectionString即可

0 0