函数不返回sqlconnection [英] Function not returning sqlconnection
本文介绍了函数不返回sqlconnection的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我创建了一个函数来获取动态的sql连接字符串,
但是当我调用这个函数时它没有返回值
< b>我尝试了什么:
功能衰减
I made a function to get dynamic sql connection string,
but its not returning value when I am calling this function
What I have tried:
Function Decleration
public string GetConnectionString()
{
//return "Data Source=DELL\\HRMS; " +
// " Integrated Security=true;" +
// "Initial Catalog=CL1COM0032;";
Common cmn = new Common();
SqlConnection connn = new SqlConnection();
connn = cmn.getConnectionForCompany(uInfo.prDBName);
connn.Open();
return connn.ToString();
}
函数调用
Function Calling
string connectionString = GetConnectionString();
推荐答案
ToString方法不返回连接字符串;你正在寻找 ConnectionString [ ^ ]属性:
The ToString method doesn't return the connection string; you're looking for the ConnectionString[^] property:
public string GetConnectionString()
{
return cmn.getConnectionForCompany(uInfo.prDBName).ConnectionString;
}
这篇关于函数不返回sqlconnection的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文