以编程方式使用 sql server 身份验证连接到数据库 [英] Connect to database using sql server authentication programatically

问题描述

如何在 c# winforms 中以编程方式使用 sql server 身份验证连接到数据库?我的意思是我在 sql server 2012 中创建了一个名为 loginTesting 的登录名，其中一个 loginTesting 作为用户.我想通过接受来自文本框的用户输入来访问 c# 中的登录名.谢谢.

How can I connect to database using sql server authentication programmatically in c# winforms? I mean i created a login named loginTesting with a loginTesting as user in sql server 2012. I want to access that login in c# by accepting user inputs from textbox. Thanks.

推荐答案

扩展答案 1，如果您想根据用户输入测试您的用户名/密码，您可以使用 SqlConnectionStringBuilder 对象，如下例所示:

Expanding on Answer 1, if you'd like to test your usernames/passwords based on user input you could use the SqlConnectionStringBuilder object as shown in this example:

SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder();
connectionString.ConnectionString = @"data source=.;initial catalog=master;";
connectionString.UserID = "username";
connectionString.Password = "password";

using (var sqlConnection = new SqlConnection(connectionString.ConnectionString))
{

}

这篇关于以编程方式使用 sql server 身份验证连接到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！