<div>
Using a SqlDataReader object,<br />
<br />
SqlConnection conn = new SqlConnection(&quot;Connection String&quot;);<br />
SqlCommand cmd = conn.CreateCommand();<br />
cmd.CommandText = &quot;SELECT FIELD_NAME FROM Database_Name&quot;;<br />
SqlDataReader mySqlDataReader = cmd.ExecuteQuery();<br />
if(mySqlDataReader.Read())<wbr /><br />
&nbsp; &nbsp; string cSharpString = (string)mySqlDataReader[&quot;F<wbr />IELD_NAME&quot;<wbr />];<br />
else<br />
&nbsp; &nbsp; // no Records found, data reader is empty
</div>


Using a SqlDataReader object,

SqlConnection conn = new SqlConnection("Connection String");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT FIELD_NAME FROM Database_Name";
SqlDataReader mySqlDataReader = cmd.ExecuteQuery();
if(mySqlDataReader.Read())
    string cSharpString = (string)mySqlDataReader["FIELD_NAME"];
else
    // no Records found, data reader is empty

<div>
sCSharpStr = Convert.ToString(Your_SQL_<wbr />String);<br />
<br />
HTH<br />
Ashok
</div>


sCSharpStr = Convert.ToString(Your_SQL_String);

HTH
Ashok

<div>
This is what I try to do:<br />
<br />
System.Data.SqlTypes.sqlst<wbr />ring to system string
</div>


This is what I try to do:

System.Data.SqlTypes.sqlstring to system string

<div>
Are you trying to read a string of text from a database? &nbsp;And how?
</div>


Are you trying to read a string of text from a database?  And how?

<div>
ashok111: that works!<br />
<br />
one small thing more...<br />
<br />
string[] SL = Response.Split(&quot;&lt;td&gt;&lt;a class=&quot;);
</div>


ashok111: that works!

one small thing more...

string[] SL = Response.Split("<td><a class=");

<div>
JustAskMe,<br />
<br />
What is the problem?<br />
<br />
Ashok
</div>


<div>
The compiler doesn't like it<br />
the error is that best overload.. excepts...
</div>


The compiler doesn't like it
the error is that best overload.. excepts...

<div>
<div class="content wysiwyg-content">
Whats the correct syntex?
</div>
</div>


Convert Sql String to c# string

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).

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.