<div>
<div class="content wysiwyg-content">
Does this SQL code look like it will work using VS2010 with .NetFramework 4.0 ?<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strSQL1 = &quot;&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strSQL1 = &quot;select bank from dbo.tbl_CSL_ML1new where dbo.tbl_CSL_ML1new.[entity<wbr />] is not null&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dh1.GetDataSetD(strSQL1);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int iDatasetCount = ds.Tables[0].Rows.Count;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (iDatasetCount != 0)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strBankID = ds.Tables[0].Rows[0][&quot;bank<wbr />&quot;].ToStrin<wbr />g();<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ListBox1.Visible = true;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ListBox1.DataSource = ds.Tables[0];<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ListBox1.DataTextField = &quot;bank&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ListBox1.DataValueField = &quot;bank&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lblNote.Text = &quot;you have to add missing banks above to the bank table and re-import again! &quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
</div>
</div>


Does this SQL code look like it will work using VS2010 with .NetFramework 4.0 ?

                strSQL1 = "";
                strSQL1 = "select bank from dbo.tbl_CSL_ML1new where dbo.tbl_CSL_ML1new.[entity] is not null";
                dh1.GetDataSetD(strSQL1);
                int iDatasetCount = ds.Tables[0].Rows.Count;
                if (iDatasetCount != 0)
                {
                    strBankID = ds.Tables[0].Rows[0]["bank"].ToString();
                    ListBox1.Visible = true;
                    ListBox1.DataSource = ds.Tables[0];
                    ListBox1.DataTextField = "bank";
                    ListBox1.DataValueField = "bank";
                    lblNote.Text = "you have to add missing banks above to the bank table and re-import again! ";
                }

Does this SQL code look like it will work using VS2010 with .NetFramework 4.0 ?

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.

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

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