<div>
For a quick solution, probably you can use gridview control.<br />
<br />
Example for ref:<br />
<a href="http://www.aspsnippets.com/Articles/Simple-Insert-Select-Edit-Update-and-Delete-in-ASPNet-GridView-control.aspx" rel="ugc">http://www.aspsnippets.com/Articles/Simple-Insert-Select-Edit-Update-and-Delete-in-ASPNet-GridView-control.aspx</a>
</div>


For a quick solution, probably you can use gridview control.

Example for ref:
http://www.aspsnippets.com/Articles/Simple-Insert-Select-Edit-Update-and-Delete-in-ASPNet-GridView-control.aspx [http://www.aspsnippets.com/Articles/Simple-Insert-Select-Edit-Update-and-Delete-in-ASPNet-GridView-control.aspx]

<div>
Not interested in Gridview.
</div>


<div>
you might not care for this advice but it is well intentioned:<br />
<br />
select * ...<br />
should not be used in production code regardless if asp or c# or even SQL<br />
<br />
you are asking for trouble if you assume that whatever software you are using will automatically align all the (now current) columns of a query for you, it's a data security risk too.
</div>


you might not care for this advice but it is well intentioned:

select * ...
should not be used in production code regardless if asp or c# or even SQL

you are asking for trouble if you assume that whatever software you are using will automatically align all the (now current) columns of a query for you, it's a data security risk too.

<div>
may be the answer I am looking for is not a possibility.
</div>


may be the answer I am looking for is not a possibility.

<div>
<div class="content wysiwyg-content">
For a particular record I do the following, select * from table where recordId=2. &nbsp;Then I have an automatic way of showing every field of the record with it's value. &nbsp;<br />
<br />
Not sure how to show the new record so I do not have to rewrite the code.<br />
<br />
using asp.net but my question is of a general nature.
</div>
</div>


For a particular record I do the following, select * from table where recordId=2.  Then I have an automatic way of showing every field of the record with it's value.  

Not sure how to show the new record so I do not have to rewrite the code.

using asp.net but my question is of a general nature.

I am using mssql and c# and javascript and how can i first display and insert new record

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

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

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.