Anyone who is working in programming.

[us1415]

Re: Anyone who is working in programming.

@NaMaan

First thing first , stop living in stone age and start using Entity Framework . It will make your life a lot easier and will prevent any SQL injection attack . Guys start using ORM if you haven’t done that yet .

Second thing , start using LINQ so you won’t have to worry about ‘‘syntax’’ of your SQL query . Rather you’ll know it if its right or wrong at compile time .

Using both of the above techniques your solution should be two linear .

mydatagrid.datasource = entitymanager.SalesInfo.where( o => o.Sales_Date == DateTime.Parse(Textbox.text));
mydatagrid.databind();

Good luck learning new technologies and welcome to 2013

Going off topic here but I dont know if any of you here have heard of Django (not the movie). Here is a little about it from the wikipedia. Works about the same as the code above.

Django is a free and open source web application framework, written in Python, which follows the model–view–controller architectural pattern.

Django’s primary goal is to ease the creation of complex, database-driven websites. Django emphasizes reusability and “pluggability” of components, rapid development, and the principle of don’t repeat yourself. Python is used throughout, even for settings, files, and data models. Django also provides an optional administrative create, read, update and delete interface that is generated dynamically through introspection and configured via admin models.