VS2010增删改查
时间: 2023-11-18 13:06:15 浏览: 31
以下是使用VS2010进行增删改查的示例代码:
1.连接到数据库
```csharp
using System.Data.SqlClient;
SqlConnection conn = new SqlConnection("Data Source=yourServerName;Initial Catalog=yourDatabaseName;Integrated Security=True");
conn.Open();
```
2.插入数据
```csharp
string insertQuery = "INSERT INTO yourTableName (column1, column2, column3) VALUES (@value1, @value2, @value3)";
SqlCommand cmd = new SqlCommand(insertQuery, conn);
cmd.Parameters.AddWithValue("@value1", "example1");
cmd.Parameters.AddWithValue("@value2", "example2");
cmd.Parameters.AddWithValue("@value3", "example3");
cmd.ExecuteNonQuery();
```
3.更新数据
```csharp
string updateQuery = "UPDATE yourTableName SET column1 = @value1 WHERE column2 = @value2";
SqlCommand cmd = new SqlCommand(updateQuery, conn);
cmd.Parameters.AddWithValue("@value1", "newExample1");
cmd.Parameters.AddWithValue("@value2", "example2");
cmd.ExecuteNonQuery();
```
4.删除数据
```csharp
string deleteQuery = "DELETE FROM yourTableName WHERE column1 = @value1";
SqlCommand cmd = new SqlCommand(deleteQuery, conn);
cmd.Parameters.AddWithValue("@value1", "example1");
cmd.ExecuteNonQuery();
```
5.查询数据
```csharp
string selectQuery = "SELECT * FROM yourTableName WHERE column1 = @value1";
SqlCommand cmd = new SqlCommand(selectQuery, conn);
cmd.Parameters.AddWithValue("@value1", "example1");
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader["column1"].ToString());
Console.WriteLine(reader["column2"].ToString());
Console.WriteLine(reader["column3"].ToString());
}
reader.Close();
```
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)