Simple Method for Insert,Update,Delete,Naviagate and Search

• Download Article - 821 B
• Download Demo - 34.05 KB
• Download Images - 146.68 KB
• Download WCLbase-dll - 11.42 KB

Introduction

I Looked for the tool for insertion,deletion,updation and Navigation for develop the web application.I couldn't get it. I decided to make that control using web custom control project. I am sure this will be usefull for all.

Background

Using the code

This Article will be most usefull for simple way of designing application without write any code for insertion,deletion,updation,search and Navigation. Through setting properties it will work.This tool only support for ODBC (sqlserver, Access and Mysql).

WCLbase.dll consists WCLTextbox,WCLComboBox,WCLSearch and WCLToolBar.
Use these dll in your web application please follows the below steps:

1. Choose the items from in ur toolbox.Browse the .Net Component add the    WCLbase.dll.
2. After getting items in ur toolbox ,just drag and drop the controls.
3. For example put the WCLTextbox on the page and set its properties.
   DataSource mentions the Tablename and DataMember mentions the Field of the  Table.Type       property is must to identify the column of the type. It can be  string,integer,date,decimal.

4. WCLToolbar has the three properties: Connection,DataSource and Keyvalue.
   We should set Connection string to  Connection Property.
   Keyvalue is unique id of the tablename and its datatype should be int.

5. WCLCombobox has five properties : Connection,DataSource,DataTextField,DataValueField and      ControlSource.DataTextField is display the text,DataValueField is value of the field and    ControlSource is used for releation of the WCLToolbar DataSource and its Datasource.
   
6. We should give the search items to WCLSearch control on page_load event.
   These properties should match with WCLToolbar Properties.

Remember to set the Language of your code snippet using the Language dropdown.

Use the "var" button to to wrap Variable or class names in <code> tags like this.

Points of Interest

Did you learn anything interesting/fun/annoying while writing the code? Did you do anything particularly clever or wild or zany?

History

Hi, Am Gnanavadivelu,living in Puducherry.Am very much interesting working in ASP.Net. Am working as Software Engineer in PSL Management and Software Technology LTD.