Life Element, Inc. found a way to extremely reduce development time and cost by building a very Powerful AI data handling control. Friend... listen closely... Lets say you have to create 10 web form pages. Lets say that each page has at least 20 input fields. Lets say each of these pages will transfer data to an SQL Server database. Now, the business rule allows the data of those pages to be updated by users. This means that you will have to do a lot of work on the front and back-end to provide that type of functionality.
If you are an experienced developer, then you will most likely build a ton of stored procedures to handle all the Insert, Update, and Deletes that is required by the application. Friend, LISTEN to us... Would it be nice if you could simply create your web forms without the need of building those Insert, Update, and Delete stored procedures AND without writing ANY SQL??? Well Friend... Now you CAN!
Form Data .NET is the Power Toy of all times. It perfectly extracts data from the following ASP.NET controls: TextBox, HtmlInputText, DropDownList, HtmlSelect, CheckBox, HtmlInputCheckBox, RadioButton, HtmlInputRadioButton, and ListBox.
It only works with
SQL Server, for now.
This is a must have component. After using this component you will be upset that you worked so hard in the past. We know and we're sorry for not thinking of this product sooner, but now IT'S HERE!!!
That's interesting LE, but how does it work? It's easy really. By writing 2 to 4 lines of code, the AI control will do the rest based on the action property you set (insert, update, delete). It analyzes the Page object so it works with User Controls as well. As long as your data tables have primary keys set, everything is a breeze! There are standard notations that you must use with your web controls.
For example:
<asp:TextBox id="txtUsername" runat="server" /> and not <asp:TextBox id="textUsername" runat="server" />.
The other cute requirement is that the name following the notation has to be the same name as the actual data table column to interact with.
For example:
For inserts under the Username column, the TextBox control's id must be, "txtUsername".
Ohhh but it doesn't stop there. Form Data .NET allows you to pass a HashTable object with key/value pairs for handling additional data that might not be visible to your users. The key/value pair is basically the column name and the data value respectfully.
In the code sampes below, the keyword "this" refers to the actual Page or Control object. For VB.NET applications, it's the same as the "Me" keyword.
How to loop through page or form controls in .NET?
sample code (Insert):
FormData oForm = new FormData("YOUR_CONNECTION_STRING");
oForm.Table = "users";
oForm.Execute(FormData.ActionType.Insert, this);
sample code (Update):
FormData oForm = new FormData("YOUR_CONNECTION_STRING");
oForm.TableName = "employees";
oForm.RecordID = 1971;
oForm.Execute(FormData.ActionType.Update, this);
sample code (Bind data to page):
FormData oForm = new FormData("YOUR_CONNECTION_STRING");
oForm.TableName = "customers";
oForm.RecordID = 1911;
oForm.BindData(this);
sample code (Delete):
FormData oForm = new FormData("YOUR_CONNECTION_STRING");
oForm.TableName = "customers";
oForm.RecordID = 1906;
oForm.Execute(FormData.ActionType.Delete, null);
Purchase Pricing (Licenses):
Items () :: US $ :: Checkout ::