<div>
If you already have the connection object (<a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection(v=VS.100).aspx" rel="ugc">SqlConnection</a>) then you can pas the connection string into a <a href="http://msdn.microsoft.com/en-us/library/ms254947.aspx" rel="ugc">SqlConnectionBuilder</a> to get the User ID that is being used to connect<br />

<pre><code class="code-1 nolinks" id="code-20-36935616-1"><span>...</span>
<span>SqlConnection conn = GetYourConnetion();</span>
<span>SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(conn.ConnectionString);</span>
<span>string userID = builder.UserID;</span>
<span>...</span>
</code></pre>
</div>


<div>
this is my connectionString:<br />
&lt;add name=&quot;ReportManagerLibrary<wbr />&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connectionString=&quot;Data Source=mkitani;Initial Catalog=Test;Integrated Security=false;User ID=testUser;Password=123; TimeOut=20;&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; providerName=&quot;System.Data.<wbr />SqlClient&quot;<wbr /> /&gt;<br />
<br />
but always when i am using &quot;builder.Password&quot; i get an empty string Why????
</div>


<div>
This is documented behavior for the <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.password(v=vs.80).aspx" rel="ugc">Password property</a>.<br />
<br />

<blockquote>
If the value <u>has not been set</u> and the developer tries to retrieve the property, the return value is String.Empty.
</blockquote>
This is obviously for security reasons, if you pull a connection string into the builder the password is not visible unless you set it manually.
</div>


<div>
<a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.integratedsecurity(v=vs.80).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.integratedsecurity(v=vs.80).aspx</a>
</div>


<div>
so in case the integrated Security in the connection string is false always i get an empty string when i used SqlConnectionStringBuilder<wbr />.Password
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
i get the sql connection from an ocx object.<br />
how i can get the user ID from sql connection.<br />
<br />
regards,
</div>
</div>


Hi All,
i get the sql connection from an ocx object.
how i can get the user ID from sql connection.

regards,

get user id from sql connection+C#+window application

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).