如何从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屋!