.net 数据库连接方法

最新推荐文章于 2024-03-06 11:26:18 发布

jovigu

最新推荐文章于 2024-03-06 11:26:18 发布

阅读量498

点赞数

CC 4.0 BY-SA版权

分类专栏： .NET 文章标签：数据库 .net string database insert

本文链接：https://blog.csdn.net/jovigu/article/details/1728448

.NET 专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何在ASP.NET应用中配置数据库连接字符串，并演示了使用SqlConnection和SqlCommand进行数据库插入操作的具体步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

web.config

<appSettings>
<add key="SiteSqlServer" value="http://www.blog007.com/server=192.171.2.40;uid=sa;pwd=sa;database=test" />
......

......

</appSettings>

dim strConnectionString As String = ConfigurationSettings.AppSettings("SiteSqlServer")

   'Open connection to database
   Dim MyConnection As New SqlConnection(strConnectionString)
   Dim MyCommand As New SqlCommand()

   Dim strSql As String= "INSERT INTO ptm_recommendfriend (sender, senderEmail, recipients, recipientsEmail) VALUES ('" & MailFrom & "','" & MailFromUser & "','" & MailToUserArr(i) & "','" & MailToArr(i) & "')"
    MyConnection.Open()
    MyCommand = new SqlCommand(strSql, MyConnection)
    MyCommand.ExecuteNonQuery
    MyConnection.Close()