<div>
&gt;&gt; &nbsp;The difference between the two<br />
<br />
The difference between the THREE &nbsp; :)
</div>


>>  The difference between the two

The difference between the THREE   :)

<div>
ADO.NET is the best and allows you to create mulitple join statements, whereas ODBC, and OLEDB you can only hit one table at a time...<br />
<br />
Plus with ADO.NET you have use of parameters which prevents SQL injection and the dataaptor lets you easily find data that you just quried....its really a step up...<br />
<br />
example of parameters to prevent sql injection<br />
<br />
Dim SQLstring As String = &quot;SELECT * FROM PRODUCT p Join customer c ON &nbsp;c.id = p.id WHERE WxxD = @var_xxIxt_ID AND 1 = 1&quot;<br />
<br />
&nbsp;Using command As New SqlCommand(SQLstring, sqlConn)<br />
&nbsp; &nbsp; command.Parameters.Add(New<wbr /> SqlParameter(&quot;@var_xxIxt_I<wbr />D&quot;, SqlDbType.Int)).Value = var_xxIxT_ID <br />
&nbsp; &nbsp; dataReader = command.ExecuteReader(Syst<wbr />em.Data.Co<wbr />mmandBehav<wbr />ior.CloseC<wbr />onnection)<wbr /><br />
&nbsp; &nbsp; If dataReader.HasRows Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; Do While dataReader.Read()<br />
<br />
<br />
with the old stuff I would add &quot;&nbsp;AND 1 = 1 &quot;&nbsp;as a trick to prevent sql injection...
</div>


ADO.NET is the best and allows you to create mulitple join statements, whereas ODBC, and OLEDB you can only hit one table at a time...

Plus with ADO.NET you have use of parameters which prevents SQL injection and the dataaptor lets you easily find data that you just quried....its really a step up...

example of parameters to prevent sql injection

Dim SQLstring As String = "SELECT * FROM PRODUCT p Join customer c ON  c.id = p.id WHERE WxxD = @var_xxIxt_ID AND 1 = 1"

 Using command As New SqlCommand(SQLstring, sqlConn)
    command.Parameters.Add(New SqlParameter("@var_xxIxt_ID", SqlDbType.Int)).Value = var_xxIxT_ID
    dataReader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
    If dataReader.HasRows Then
        Do While dataReader.Read()


with the old stuff I would add " AND 1 = 1 " as a trick to prevent sql injection...

<div>
<div class="content wysiwyg-content">
How many method that c# connect to my sql &nbsp;odbc , .net and what is the difference
</div>
</div>


How many method that c# connect to my sql  odbc , .net and what is the difference

c# connect to mysql databae

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