怎麼樣在ASP.NET中配置各種連接數據庫?

ADVERTISEMENT

怎麼樣在ASP.NET中配置各種連接數據庫?

一、數據庫連接語句

1、MSSQL數據庫鏈接示例

<connectionStrings>

<add name="Conn" connectionString="server=.;database=demo;uid=sa;pwd=123456" providerName="System.Data.SqlClient"/>

</connectionStrings>

2、Access 2003數據庫鏈接示例:""代表根目錄

<connectionStrings>

<add name="Conn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=App_Data/demo.mdb" providerName="System.Data.OleDb"/>

</connectionStrings>

Access 2007或以上版本的鏈接

<connectionStrings>

<add name="Conn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=App_Data/demo.mdb" providerName="System.Data.OleDb"/>

</connectionStrings>

3、Oracle 數據庫鏈接示例

<connectionStrings>

<add name="Conn" connectionString="Provider=MSDAORA;Data Source=demo;User ID=sa;Password=123456;" providerName="System.Data.OracleClient"/>

</connectionStrings>

4、SQLite 數據庫鏈接示例

<connectionStrings>

<add name="Conn" connectionString="Data Source=App_Data/demo.db;failifmissing=false" providerName="System.Data.SQLite"/>

</connectionStrings>

5:MySQL數據庫鏈接示例

<connectionStrings>

<add name="Conn" connectionString="host=127.0.0.1;Port=3306;Database=mysql;uid=sa;pwd=12346" providerName="MySql.Data.MySqlClient"/>

</connectionStrings>

二、json數據轉換

using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using System.Reflection;

using System.Text;

using System.Web;

using System.Web.Script.Serialization;

namespace Role.DAL

ADVERTISEMENT

{

public class Json

{

public Json() { }

/// <summary>

///將datatable數據轉換成JSON數據, 字符串拚接寫成的

/// </summary>

/// <param name="jsonName">json名稱。沒發現什麼作用</param>

/// <param name="dt">得到的數據表</param>

/// <returns></returns>

public string DataTableToJson(string jsonName, DataTable dt)

{

StringBuilder Json = new StringBuilder();

Json.Append("[");

if (dt.Rows.Count > 0)

{

for (int i = 0; i < dt.Rows.Count; i++)

{

Json.Append("{");

for (int j = 0; j < dt.Columns.Count; j++)

{

Json.Append(dt.Columns[j].ColumnName.ToString() + ":\"" + dt.Rows[i][j].ToString() + "\"");

if (j < dt.Columns.Count - 1)

");

if (i < dt.Rows.Count - 1)

Json.Append("]");

ADVERTISEMENT

return Json.ToString();

}

/// <summary>

/// 列表數據轉換到json數據;字符串拚接寫成的,太難

/// </summary>

/// <typeparam name="T"></typeparam>

/// <param name="jsonName">json名稱。沒發現什麼作用</param>

/// <param name="IL"></param>

/// <returns></returns>

public string ObjectToJson<T>(string jsonName, IList<T> IL)

{

StringBuilder Json = new StringBuilder();

Json.Append("[");

if (IL.Count > 0)

{

for (int i = 0; i < IL.Count; i++)

{

T obj = Activator.CreateInstance<T>();

Type type = obj.GetType();

PropertyInfo[] pis = type.GetProperties();

Json.Append("{");

for (int j = 0; j < pis.Length; j++)

{

Json.Append(pis[j].Name.ToString() + ":\"" + pis[j].GetValue(IL[i], null) + "\"");

if (j < pis.Length - 1)

");

if (i < IL.Count - 1)

Json.Append("]");

return Json.ToString();

}

/// <summary>

/// 將DataTable轉化為自定義JSON數據

/// </summary>

/// <param name="dt">數據表</param>

/// <returns>JSON字符串</returns>

public static string DataTableToJson(DataTable dt)

{

StringBuilder JsonString = new StringBuilder();

if (dt != null && dt.Rows.Count > 0)

{

List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();

for (int i = 0; i < dt.Rows.Count; i++)

{

Dictionary<string, string> dict = new Dictionary<string, string>();

for (int j = 0; j < dt.Columns.Count; j++)

{

dict.Add(dt.Columns[j].ColumnName, dt.Rows[i][j].ToString());

}

list.Add(dict);

}

JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();

return jsonSerializer.Serialize(list);

}

else

{

return "

/// <summary>

/// 將datatable轉換為json

/// </summary>

/// <param name="dtb">Dt</param>

/// <returns>JSON字符串</returns>

public static string Dtb2Json(DataTable dtb)

{

JavaScriptSerializer jss = new JavaScriptSerializer();

System.Collections.ArrayList dic = new System.Collections.ArrayList();

if (dtb != null && dtb.Rows.Count > 0)

{

foreach (DataRow dr in dtb.Rows)

{

System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();

foreach (DataColumn dc in dtb.Columns)

{

drow.Add(dc.ColumnName, dr[dc.ColumnName]);

}

dic.Add(drow);

}

//序列化

return jss.Serialize(dic);

}

else

{

return "

以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持路飯。

本文地址:

ADVERTISEMENT