如何从UI传递连接字符串值作为参数？ [英] How to pass Connection string values as parameters from UI ?

问题描述

嗨朋友们，

我在asp.net中使用下面的示例连接字符串。我需要的是我是否可以从UI传递连接字符串属性值作为参数。数据源值必须从UI中的文本框传递，同样初始目录值也必须从ui中的文本框传递，同样的用户名和密码？任何人都可以给我样品?????????



数据源= urServerAddress;初始目录= urDataBase;

用户Id = urUsername;密码= urPassword;

Hi Friends,
I am having a connection string in asp.net with the below sample . What i need is whether can i pass connection string property values as parametrs from UI. Datasource value must be passed from textbox in UI,similarly initial catalog value also must be passed from textbox in ui , and samething for username and password ? Can anyone give me sample ??????????

Data Source=urServerAddress;Initial Catalog=urDataBase;
User Id=urUsername;Password=urPassword;

推荐答案

亲爱的Murugappan，



以下是您的解决方案问题:)

Dear Murugappan,

Here is the solution for your question :)

string connectionString = @"Data Source=" + textBox1.Text + ";Initial
Catalog=" + textBox2.Text +";User ID=" + textBox3.Text + ";Password="
+ textBox4.Text;

请为解决方案评分。



问候，



Praveen Nelge

Please rate the solution.

Regards,

Praveen Nelge

Hi Murua，

Hi Murua,

string dataSource = txtDataSoure.Text;
            string database = txtDatabase.Text;
            string user = txtUser.Text;
            string password = txtPassword.Text;

         public  static string con = "Data Source="+dataSource+";Initial Catalog="+database+";User Id="+user+";Password="+password;
           System.Data.SqlClient.SqlConnection sqlCon = new System.Data.SqlClient.SqlConnection(con);

这篇关于如何从UI传递连接字符串值作为参数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！