<div>
<blockquote>
//filling the studentinfo data model object here.
</blockquote>
<br />
You omitted the most significant piece of information from your question. Could you please demonstrate what is it that is being written where you have mentioned the above text?<br />
<br />
Also, please show us the structure of the Student table.
</div>


> //filling the studentinfo data model object here.


You omitted the most significant piece of information from your question. Could you please demonstrate what is it that is being written where you have mentioned the above text?

Also, please show us the structure of the Student table.

.NET Developer

Abhilash Nagar

<div>
I was referring a command object which was incorrect.<br />
<br />
Correct command object was SqlCommand comm<br />
<br />
I was referring to the SqlCommand testcomm which was running execute scalar.<br />
<br />
Thanks for all the responses. Really appreciate your time.
</div>


I was referring a command object which was incorrect.

Correct command object was SqlCommand comm

I was referring to the SqlCommand testcomm which was running execute scalar.

Thanks for all the responses. Really appreciate your time.

<div>
<div class="content wysiwyg-content">
Hello,<br />
Anything incorrect below as i am getting only single field rather then 3 in the datareader. I am just getting StudentID field value only.<br />
<br />
SqlCommand getStudent = InitiateDatabaseCommand();<wbr /><br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; getStudent.Parameters.Add(<wbr />&quot;@StudentI<wbr />d&quot;, SqlDbType.Int);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; getStudent.Parameters[&quot;@St<wbr />udentId&quot;].<wbr />Value = 1;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; getStudent.CommandText = &quot;Select * From Student &nbsp;r where r.StudentID=@StudentId AND r.Name like '%R%'&quot;;<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDataReader dr = comm.ExecuteReader();<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; while (dr.Read()){<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;//filling the studentinfo data model object here.<br />
&nbsp; &nbsp; &nbsp; &nbsp; }
</div>
</div>


Hello,
Anything incorrect below as i am getting only single field rather then 3 in the datareader. I am just getting StudentID field value only.

SqlCommand getStudent = InitiateDatabaseCommand();

            getStudent.Parameters.Add("@StudentId", SqlDbType.Int);
            getStudent.Parameters["@StudentId"].Value = 1;
            getStudent.CommandText = "Select * From Student  r where r.StudentID=@StudentId AND r.Name like '%R%'";

            SqlDataReader dr = comm.ExecuteReader();

        while (dr.Read()){

           //filling the studentinfo data model object here.
        }

SQLDataReader giving  only one field

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

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

ADO.Net

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.