Configure database connection and json conversion
This article mainly introduces the configuration methods of various database connections in ASP.NET. It introduces the configuration of MSSQL, Access, Oracle, SQLite, and MySQL databases in detail. It has certain reference value. Those who are interested can learn more. .
1. Database connection statement
1. MSSQL database link example
<connectionStrings> <add name="Conn" connectionString="server=.;database=demo;uid=sa;pwd=123456" providerName="System.Data.SqlClient"/> </connectionStrings>
2. Access 2003 database Link example: "{0}" represents the root directory
<connectionStrings>
<add name="Conn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}App_Data/demo.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>Access 2007 or above version link
<connectionStrings>
<add name="Conn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}App_Data/demo.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>3, Oracle database link example
<connectionStrings> <add name="Conn" connectionString="Provider=MSDAORA;Data Source=demo;User ID=sa;Password=123456;" providerName="System.Data.OracleClient"/> </connectionStrings>
4, SQLite database link Example
<connectionStrings>
<add name="Conn" connectionString="Data Source={0}App_Data/demo.db;failifmissing=false" providerName="System.Data.SQLite"/>
</connectionStrings>5: MySQL database link example
<connectionStrings> <add name="Conn" connectionString="host=127.0.0.1;Port=3306;Database=mysql;uid=sa;pwd=12346" providerName="MySql.Data.MySqlClient"/> </connectionStrings>
2. json data conversion
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
{
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)
{
Json.Append(",");
}
}
Json.Append("}");
if (i < dt.Rows.Count - 1)
{
Json.Append(",");
}
}
}
Json.Append("]");
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)
{
Json.Append(",");
}
}
Json.Append("}");
if (i < IL.Count - 1)
{
Json.Append(",");
}
}
}
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 "{}";
}
}
}
}[Related recommendations]
2. ASP Tutorial
3. Li Yanhui ASP Basic Video Tutorial
The above is the detailed content of Configure database connection and json conversion. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1657
14
1415
52
1309
25
1257
29
1230
24
How to implement database connection and transaction processing in FastAPI
Jul 30, 2023 am 11:45 AM
How to implement database connection and transaction processing in FastAPI Introduction: With the rapid development of web applications, database connection and transaction processing have become a very important topic. FastAPI is a high-performance Python web framework loved by developers for its speed and ease of use. In this article, we will introduce how to implement database connections and transactions in FastAPI to help you build reliable and efficient web applications. Part 1: Database connection in FastA
How to use PHP database connection to implement paging query
Sep 08, 2023 pm 02:28 PM
How to use PHP database connection to implement paging query. When developing web applications, it often involves the need to query the database and perform paging display. As a commonly used server-side scripting language, PHP has powerful database connection functions and can easily implement paging queries. This article will introduce in detail how to use PHP database connection to implement paging query, and attach corresponding code examples. Prepare the database Before we start, we need to prepare a database containing the data to be queried. Here we take the MySQL database as an example,
Common database connection and data reading and writing problems in C#
Oct 10, 2023 pm 07:24 PM
Common database connection and data reading and writing problems in C# require specific code examples. In C# development, database connection and data reading and writing are frequently encountered problems. Correct handling of these problems is the key to ensuring code quality and performance. This article will introduce some common database connection and data reading and writing problems, and provide specific code examples to help readers better understand and solve these problems. Database connection issues 1.1 Connection string errors When connecting to the database, a common error is that the connection string is incorrect. The connection string contains the connection to the database
How to connect to and operate databases and handle SQL queries
Aug 02, 2023 am 09:06 AM
How to connect and operate the database and process SQL queries. In the process of developing applications, database connection and operation are a very important part. Database is an important tool for storing and managing data, and SQL (StructuredQueryLanguage) is a standard language for querying and operating databases. In this article, we will learn how to connect to and operate a database and show some code examples for handling SQL queries. Connect to the database: First, we need to connect to the database to proceed
Advanced PHP database connections: transactions, locks, and concurrency control
Jun 01, 2024 am 11:43 AM
Advanced PHP database connections involve transactions, locks, and concurrency control to ensure data integrity and avoid errors. A transaction is an atomic unit of a set of operations, managed through the beginTransaction(), commit(), and rollback() methods. Locks prevent simultaneous access to data via PDO::LOCK_SHARED and PDO::LOCK_EXCLUSIVE. Concurrency control coordinates access to multiple transactions through MySQL isolation levels (read uncommitted, read committed, repeatable read, serialized). In practical applications, transactions, locks and concurrency control are used for product inventory management on shopping websites to ensure data integrity and avoid inventory problems.
Why does my PHP database connection fail?
Jun 05, 2024 pm 07:55 PM
Reasons for a PHP database connection failure include: the database server is not running, incorrect hostname or port, incorrect database credentials, or lack of appropriate permissions. Solutions include: starting the server, checking the hostname and port, verifying credentials, modifying permissions, and adjusting firewall settings.
How to connect to a Microsoft Access database using PDO
Jul 29, 2023 pm 10:17 PM
How to use PDO to connect to the Microsoft Access database Microsoft Access is a commonly used relational database management system that provides a user-friendly graphical interface and powerful data management functions. For many developers, using PHP to connect to a Microsoft Access database is a challenge. However, by using PHP's PDO (PHPDataObject) extension, connecting to an Access database becomes quite
PHP error: Unable to connect to the database solution
Jul 12, 2023 pm 06:07 PM
PHP error: Solution to the inability to connect to the database During the development process using PHP, we often encounter the problem of being unable to connect to the database. This is a very common mistake, but it causes a lot of trouble to developers. This article will introduce some common solutions and provide corresponding code examples to help developers quickly solve the problem. Check the database connection information First, you should check whether the database connection information is correct. Typically, database connection information includes hostname, username, password, and database name. Correct database connection information
