What about making asp.net application just in the same way you work with your favourite scripting language like php ? How can I bind dataset without
using heavy Grid View from server side? How can I achieve paging and sorting in client-side? How to make super fast web applications with asp.net ?
OK. Here is the answer ..
As experienced programmer in both php and asp.net what I have realize is , php is flexible in front end developments and it is kind of ahead
performance wise . The main overhead asp.net developers face is heavy server controlls.
In fact there is no difference in asp.net server controlls and html controlls if we deeply have a look , keep in mind that grid view render as Html
Table control, and this is the trick! If your are good in programming , dynamically creating html table in serverside is not a big deal .Just cares
for some syntaxes.
Now here we are going to bind same dataset in two differentways to measure performance .
well We did it! Let us start coding.
First step :
we will bind with generic gridview controll .
Please note that configure some of your database table and field names in bellow code sample.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
</asp:GridView>
Codebehind
protected void Page_Load(object sender, EventArgs e)
{
String Q; Sql command cmd; Sql DataReader dr; SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings ["cn"].ConnectionString.ToString(); conn.Open(); Q = "select * from ATEST "; cmd= New Sqlcommand(Q, conn); dr = cmd.ExecuteReader(); Gridview1.DataSource = dr; Gridview1.DataBind();
}
Second step :
we will bind with creating dynamic html table .
protected void Page_Load(object sender, EventArgs e)
{
String Q;
SqlCommand cmd;
SqlDataReader dr;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString.ToString();
conn.Open();
Q = "select * from ATEST";
cmd= new SqlCommand(Q, conn);
Response.Write("<table id='example'>");
Response.Write("<tbody>");
Response.Write("<thead><tr><th>Rendering engine</th><th>Browser</th></tr></thead>");
int i = 0;
while (dr.Read())
{
string id = dr.GetInt32(dr.GetOrdinal("CompanyID")).ToString();
string did = dr.GetString(dr.GetOrdinal("DeveloperCode"));
Response.Write(" <tr>");
Response.Write(" <td>" + id + "</td><td><a rel='facebox' href='Editgrid.aspx'> "+ did + "</a></td>");
Response.Write(" </tr>");
i++;
}
Response.Write("</tbody>");
Response.Write("</table>");
}
You can make your table just as gridview by applying appropriate styles . Notice here I applied popular jquery “facebox “ popup in table . You can
use it to update data in row by row .
If your good in front end development and love playing with clientside scripting it is all yours . Visit jquery datatable website . http://www.datatables.net/
Apply datatable properties to achieve paging and sorting in high efficent way in clentside .
Trace record taken by Table sample.Notice the final figure.
So buddy Asp.net developers dnt worry bout heavy servercontrolls anymore . Cheers …!
