I am a student with non IT back ground. I got a request from my client to develop a simple form with 10 data elements and store it in oracle table.I have to use ASP.net to develop this application.
View 5 RepliesI am working on some ASP.NET web forms which involves some dynamic generation, and I need to add some onClick helpers on the client side. I have a basic outline of something working, except for one huge problem.
There are multiple HTML tables, each generated by a different ASP.NET web control. Each table can contain overlapping field names, which is causing a problem with my JQuery click event handlers. The click event handler is linking to unintended form fields in addition to the intended form field.
I have provided a simplified sample version of the code below. This code is trying to set the value of textbox box1 when a particular radiobutton is selected in the table with id=thing1. Obviously, the jquery code will be triggered for the form fields in both tables.
The tables are dynamically added to the webpage based upon different conditions. It is possible that no tables will be loaded, only 1 table, or both tables might load. In the future, other tables could be added. Each table comes from a different .net web control.
Other than renaming the form fields to make sure they are unique across all user controls, is there a way to have JQuery act only on the intended form fields? In other words, could the table ID be incorporated into the JQuery code in a manner that does not become a nightmare to maintain later?
[code]....
I have...a dynamic populated select box several input boxes a submit button form fields are loaded initially using cookies several dynamic populated divs
I want... start loading the content of my DIVs after all FORM elements have been loaded completely (= filled with data, select boxes are populated)
Sample code:
[code]....
As I am working on Employee Management system, I have two table (for example) in database as given below.
EmployeeMaster (DB table structure)
EmployeeID (PK) | EmployeeName | City
MonthMaster (DB table structure)
Month | Year | EmployeeID (FK) | PrenentDays | BasicSalary
Now my question is, I want to store data in file system rather than storing data in SQL or ORACLE.
I want my data in file system storage for Insert, Edit and Delete opration with keeping relation with objects too.
I am a C# developer, Could anybody have thoughts or idea on it. (To store data in file system with keeping relations between them)
I am going to develop a website in ASP.NET in which users can submit article for this i need a CMS(Content management system ) to handle their article and users comment. which CMS will we good and simple.
View 8 RepliesHow can I make this get a specific users data, Example user enters his 3 digit code in the badge text box so that only his information is shown. Can I add a where clause to the select command? or is there a better way to do this? Also is there a good book out there with information about asp.net, c# and oracle.
// string Badge = "100000" + Request.Form["xBadgeTextBox"]; in
default.aspx.cs
//"SELECT * FROM CLOCK_HISTORY WHERE BADGE ='" + Badge + "'"; would
something like this work?
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionStrings %>"
ProviderName="<%$ ConnectionStrings:ConnectionStrings.ProviderName %>"
SelectCommand="SELECT "CLOCK_IN_TIME", "CLOCK_OUT_TIME" FROM "CLOCK_HISTORY"">
</asp:SqlDataSource>
After I developed the system by usin vs2008 , my supervisor asked me to develop form in the interface  so they can enter information about projects as(project code,project title, country,sector,year) to the database with out dealing with the database in the  backend .. so how can i develop it because i am still new to the vs.
View 1 RepliesI am working in a school and we recently installed a new server running WinServer 2008R2. I want to be able to point people to a URL on our intranet and have them fill out a simple registration form and have this data written to a database. It would also be nice to have some data auto-populate (such as their name).
Is it overkill to set up a sharepoint server and try to do this with Access Webforms? Could I use something like dotnetnuke and find a module that works? Or how about options for writing custom forms?
So I have a dropdown setup on the page called ddlVehicleType that is populated from a store. This method gets called when another dropdown is changed, and it's supposed to remove all items from the aforementioned store, re-add them as needed, and then populate the dropdown with the new values. It's doing everything it's supposed to EXCEPT clearing the store before it re-adds the values, so the result is, when I switch, I'm getting what it used to be PLUS the new values that should be in there by themselves. Here is the weird thing though, when I switch back, the values are removed without re-adding anything. Can anyone tell me what I'm doing wrong? Method is below:
function filterVehicleTypes() {
var masterStore = Global.getComponent("vehicleTypeStore").getStore();
var Source = Global.getComponent("ddlValuationSource").getRawValue();
var isIncuded = '';
var IncludeFlags = '';
if (Source == undefined || Source == null)
Source = '';
Global.getComponent("ddlVehicleType").getStore().removeAll(false);
masterStore.each(function(rec) {
switch (Source.toUpperCase()) {
case 'KBB':
if (rec.get('Code') == 'KBB') {
Global.getComponent("ddlVehicleType").store.add(rec);
}
case 'NADA':
IncludeFlags = rec.get('MiscCode1');
if (IncludeFlags != null) {
isIncuded = IncludeFlags.substr(1, 1);
if (isIncuded == 'Y' && rec.get('Code') == 'NADA') {
Global.getComponent("ddlVehicleType").store.add(rec);
}
}
break;
default:
IncludeFlags = rec.get('MiscCode1');
if (IncludeFlags != null) {
isIncuded = IncludeFlags.substr(0, 1);
if (isIncuded == 'Y') {
Global.getComponent("ddlVehicleType").store.add(rec);
}
}
break;
}
});
}
I need to fetch the data from a table with Alias name in oracle.
example: select f1 'Field Name1',f2 'Field Name2' from sometablename;
I have been asked to develop an ASP.Net application which will directly connect (store and retrieve) to the ACT! databse already functional. I am new to ACT and looking for a starting point to integrate it with ASP.Net application. In particular I am looking for answers to the following questions:1. What database technology is used by ACT? Is SQL Server? In that case, I should be able to connect just like any SQL Server database?2. Is there any class library or API for .Net from ACT which will help achieve this?3.
View 1 Replieshow to store & retrieve image in asp.net with oracle database.
View 2 Replies1)table student
studentno varchar(50)
hobby1 varchar(40);
hobby2 varchar(40);
hobby3Â varchar(40);Â
2)if record in data database such that
hobby1Â hobby2Â Â hobby3 in this maximum is one must be chose
like
here studentno hobby1 hobby2  hobby3
          1            cricket  null        null     Â
          2            null     hockey    null
          3            null      null       tennis
if i want to write function in mysql if i pass the studentno
i want to get the hobby of respective student
like select functionname(1)
your hobby is cricket
like select functionname(2)
your hobby is hockey
ike select functionname(3)
your hobby is tennis
How do I read excel(with many worksheets) using asp.net c# and load the data into oracle database?
View 2 RepliesI want to do is create a simple page which allows a user to post data into a data table. It should not allow them to view, update or delete any data.
Is there a good online tutorial which would guide me through how to do this in Visual web developer 2008?
I have connected a db, and can add "SELECT" controls to view forms, but I need to be able to INSERT to the table.
i created a asp.net form for registration without using login controls and a table for storing information. the passwords in the password column in the table is clearly visible in text form i want it to be in encrypted form.
View 8 RepliesI am goig to execute an oracle store procedure using C# through through ODP.NET. The store procedure executes succsfully but it does not return any value in the out parameter.
When I execute the same store procedure with the same input parameteres from within SQL*Plus. It does return values.
This is to be clearify here that in the oracle store procedure the data type for the out parameter is number and in the c# the variavle that will hold its value is Integer. I also tried using Long on the C# side but it is still not working. After the successfull execution of the store procedure the C# variable contains nulll value.
I have a problem at the time of updating the datagrid. I want that at the time of update data is shown in form instead of datagrid.
[code]....
I need to store data from a form for recovery from the session.
Below is my rough first attempt for a generalized method for textboxes:
Load Session:
[code]....
However, it appears that the Controls collection is not working for me. What am I doing wrong?
this.Controls.OfType<TextBox>() yields no results at run time when I do a quick watch on it.
how to store into sql data base and and how to retriew xls file as xls file from database in the form form of byte[] using c# in asp.net application.
View 1 RepliesSo I am new to ASP.NET MVC and I would like to create a view with a text box for each item in a collection. How do I do this, and how do I capture the information when it POSTs back? I have used forms and form elements to build static forms for a model, but never dynamically generated form elements based on a variable size collection.
I want to do something like this in mvc 3:
[Code]....
How do I do a text box for each guest? And how do I capture them in the action method that it posts back to?
Currently, I have a list of PhoneNumber objects that I display. Here's an example of the output of the view:
[Code]....
Notice the naming of these elements: name="existing_phone[labels][6]", name="existing_phone[numbers][6], name="new_phone[labels][]", name="new_phone[numbers][].Back in the Classic ASP days, I recall being able to do something along the lines of:
[Code]....
And that would give me a 2d array of phone numbers to work with. This doesn't seem to work in .NET. Has anyone tried to do something similar that can point me in the right direction?For new phones, I should simply be able to iterate through each item and insert into the database. For existing phones, I should be able to update (or delete if the label or number are blank) records based off of the id number supplied in the array.OR..if anyone has a better, alternate solution, I'm open to something else.
I am using Visual Studio 2008.
I created a New Project ASP.NET Web Application.
I created a Textbox named VisitorName. The visitor puts in their name and it goes in VisitorName.Text
There is a Label that says "Which do you own?"
There is a RadioButtonList. It has Cat, Dog and None.
There is a button that says Add to list.
The button needs to add the results of the above items and put them in the list.
Now you keep adding people and their pets.
Once there are all entered you press send and I get the results for everyone entered during that session via email.
I have no database access and the information does not need to be stored in such a way.
I would like to use a datatable or datalist or something to that sort.
Oh and I would like the visitor to be able to click on a name in the table and edit the data using the form controls not in the datalist or datatable itself.
If I have a large amount of fields/data on the Form, what's the strategy to organize or break them down within Form? or There
is other approach to develop rich experience form submission.
I have a form with a bunch of labels and images on it. Is there a way I can capture parts of that form into an images file (jpg/bmp, etc)? Ideally I could specify the x-y coordinates, and save that to a jpg.
View 3 Replies