May I request you to post it in the Questions section of this website? A little hint in order to solve your problem is "30-8-2008 " is not a correct Date Time format (try to convert or parse it to Date Time and you will get error). tulsi When you will use Sql Data Source, you are writing your select query, connectionstring and other stuffs at the page itself.So just pass the value in correct Date Time format. Just curious why you did not use the gridview wizard to display the list of records. This approach is good if you have a small project but for bigger projects it is not suggestable. Sql Client; /// In the above code, I have a member variable called conn Str that is getting database connection string from my web.config file that is being used through out the class. Code for Grid View Data Key Names="Person ID" Auto Generate Edit Button="True" Auto Generate Columns="False" On Row Editing="Edit Record" On Row Updating="Update Record" On Row Canceling Edit="Cancel Record" On Row Deleting="Delete Record" Page Size="5" Above method will fire when Delete link will be clicked on the Grid View. To list the record into Grid View that will also enable us to Edit, Delete record, copy paste following code.
Can you please help me telling me how to capture a date field and save it in SQL 2005. In the above code, first I am validating the page by using Page. Lets create a form that will have three textboxes for First Name, Last Name and Age.aspdotnet-suresh offers C#articles and tutorials,csharp dot net,articles and tutorials, VB.3-Tier architecture is a very well know buzz word in the world of software development whether it web based or desktop based. Below is the code for BAL (Your can overwrite your default written code for the class file by pasting this code). You can also navigate to another page your created (list.aspx) and try updating, deleting records. I am not goint into details of how I am connecting database and manipulating the data just to make this tutorials short. Code to Update records Above method will fire when Update link will be clicked for a particular row of the Grid View in edit mode.