I have separate method for inserting, deleting, updating records into database and loading records from database. In the above code, I am instantiating Person BAL3 and calling Delete method by passing person ID as parameter so that select reocrds will be deleted from datbase.
Dear Sir, I find there is a format mismatch between i BO.
Help Desk Call Date and txt Help Desk Request Date in the code-behind but really dont know how to fix it. Help Desk Call Date - txt Help Desk Request Date : "30-8-2008 " I am new to programming, but looking at this I feel IBO.
Help Desk Call Date is expecting the format which is not provided by txt Help Desk Request Date... The problem you are talking about is related with a specific scenario.
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.
To list the record into Grid View that will also enable us to Edit, Delete record, copy paste following code.
Dispalying Records into Grid View Create a file called and create a Grid View something like displayed into the picture.
For the ease of understanding, I have created BAL, DAL into the App_Code folder. pre 2) Can you post other similar article with Ajax? Because in practice we expect the delete to be performed with confirmation and also in details screen. Add new / Edit in 2 different tab panels - to have better usability. Regards, Sreedhar Thanks Vansree for your suggestions. Regarding pre class, I will let the webmaster know about it. As far as article on Ajax is concerned, I will try my best to post few articles on Ajax in coming days. Regards This is simpler example for 3-Tier Architecture.
In real scenario, you should create separate projects for BAL, DAL (as Class Library) and UI (as Web project) and reference your BAL into UI. I wonder if you can come up with the same but using Ajax Tabs. Like having add button in Grid View will switch you to Tab Panel (Add new) and then perform the add ... But would like to see if you can come up with Tabs and your example above. I have one question about passing the data between layers.
Did you create the source code for the page manually or did you use some type of wizard to do this? tulsi Hi Sheo Narayan, Indeed a very useful article with easy to understand example.
I'm use to binding the gridview to the sqldatasource, but want to learn more on the way you created this page. But Sheo Narayan, as in this example you are creating DAL and BAL inside App_Code, I need an architecture wherein the DAL and BAL should be outside App_Code folder.
Download source code for 3-Tier Architecture in ASP. Seperation - the functionality is seperated from the data access and presentation so that it is more maintainable 2.