Webform For A Simple Lookup Table Maintenance?
Aug 31, 2010I'm looking for a simple webform for maintenance of a SQL Server which has only two columns: LookupID (int, not null) identity and LookupValue (nvarchar (50), not null).
View 1 RepliesI'm looking for a simple webform for maintenance of a SQL Server which has only two columns: LookupID (int, not null) identity and LookupValue (nvarchar (50), not null).
View 1 Replieshow to draw shapes in ASP.Net. I did a lot of research for the same. But every solution tht i got involved using Paint events wich are not available in ASP.nET. I also imported all the required pakackes like Drawing,Imaging,Drawing2D etc..
View 8 RepliesI'm using a GridView control, using the Northwind database as a sandbox.
I have allowed editing of rows using AutoGenerateEditButton="true" and that all works fine. The book I'm using for reference the following code behind for error handling (C#):
[code]...
However, this seems to have no effect upon my label text, leading me to believe that the exception handling snippet won't work either.
I have asp.net Forms View.
I have three textboxes to lookup three different product codes from a product lookup table.
When you enter search criteria in a Textbox it would popup listbox control with Products and
when user selects the product it populates product-id back in to textbox.
I have lookup table and listbox working. However, My problem is I can't figure out how to pupulate TextBox2 if search Criteria was typed into TextBox2and to populate TextBox 3 if the search criteria was typed into textbox 3 etc.
My manager designed a table exactly like this
[Exception]
PK | ExceptionId
ExceptionCode varchar(100)
ExceptionDesc varchar(255)
ExceptionMSG varchar(255)
I'm using ASP.NET Webforms and using stored procedures/ADO.NET for DataAccess. Now he does not want me to hard code validation in stored procedures nor in the code behind, but to catch the constraint exception message and look up the same error message in the database and look for the message that we want to show. I wonder if his design will work or should I explain to him that something is wrong here.
I've installed Visual Web Developer 2010 Express on a Windows XP Pro PC. IIS is NOT installed yet. I am just evaluating this now, and the built in web server works fine for now.
I've followed these very basic steps and I'm stuck with this error:
Error WebForm_PostBackOptions is undefined
I am trying to add a RequiredFieldsValidator control to the page. Here are the steps I followed...
1- Menu options: File -> New Web Site
2- ASP.NET Empty Web Site
3- Website -> Add new item
4- Select Web Form with Place Code in separate file checked. Master page not checked.
5- No changes to the web.config file
6- I added a couple text boxes and labels to the page and a button.
7- If I click the button now, no problem. The page submits and is displayed with the information entered in the text box fields.
8- Add a RequiredFieldsValidator next to the first text box.
9- I set the ErrorMessage to some text
10- I set the ControlToValidate to the first text box's ID
11- I save then run with CTL + F5
12- The page is displayed in IE 7. I hit the Submit button and I get the popup error described above.
I used the Web Platform Installer for the installation. Everything went fine. All other aspects of my development and testing have been fine. This is the first major roadblock I hit. I think it has something to do with a configuration setting in the web.config file, but I do not know what setting to add/change.
I ahve two tables each with a primary key. There is a lookup table in between the two tables with relationships. Below is a simplified look at the table structure
Table 'Product'
Column ProductPK int (Primary Key)
Table 'County'
Column CountyID int (primary key)
Table Product_County_Lookup
Column ProductPK int (Joint Primary Key)
Column CountyID int (joint primary key)
I already have the ProductPK and CountyID. What is the correct LINQ statement to insert into Product_County_Lookup table ONLY?
I'm using vwd 2008 express
I need to display a single field from an sqlserver table, do I need to use sqlDataSource ect. or is there a simpler way (like msaccess's LookUp) for single values.
as a php developer ive been told to go the MVC route which ive been trying since yesterday. Im using visual web delveloper 2010 express and im using the MVC template project.Ive basically got a news table in MSSQL Express, in there are these fields ID,(Title,Body,PostedOn,PostedBy) all i wanna do is loop through them to put them on the view.Im after a nudge in the right direction, I want to be able to do a SQL lookup in the controller put that data in a DataTable then run a foreach loop on the table to display this on the view. The problem im getting is I know youre not suppsed to put any HTML in the controller and I cant pass the datatable to the view to do the loop in the view.. so where/how do I do the loop.
View 2 RepliesI have a GridView control that has a SQLDataSource.
The GridView provides me with a list of musical artists (from the tblArtists)
In the Grid, I have a field, FKGenreID, that is a Foreign Key value for music Genres.
(An example of the data in that field would be "7", which upon lookup would mean Classical in the
tblGenreList table.)
What I'd like to do is add a DropDownList control that looks up the tblGenreList table and populates the DropDownList with the ID and Description from the tblGenreList Lookup table.
Now the tricky part is that if the GridView field (FKGenreID) has a value, then I'd like the corresponding Genre Description to be displayed in the DropDownList
Alternately, if there is no value for FKGenreID in the GridView, then I'd like the DropDownList to show that nothing was selected, but have the list of Genres available.
Most importantly here, when the user makes a selection, I'd like the GenreID (from the DropDownList) to be entered into the FKGenreID field in the GridView field.
My thought is that a gridview record may or may not have a value in the FKGenreID field. Either way, the DropDownList is bound to that field. The DropDownList would display a list ofGenre Descriptions for the user to select from. Upon selection, the GenreID column of the DropDownList becomes the value in for the FKGenreID field in the GridView.
Is this possible?
In case it matters, I'm using ASP.NET 4, Visual Studio 2010, and coding in VB
On my DetailsView for inserting, I have a field "manager code". When the user types in the code, I want another field "manager name" to be populated based on a lookup table in the database. I have done this on a FormView using code behind and "ontextchanged". How can I do this in DetailsView?
View 3 RepliesI am creating a kind of feedback website which has a feedback form on it. Each question is answered choosing from a radio button group. the answers to each question are (very good, good, bad, failed). I need to be able to create a table on the webform that will display the number of answers to each questions. for example, if the question is "Rate the use of this software" i need to be able to put in table format say 20 people said "very good", 30 said "good" etc. at the moment i only have one table to display the questions and answers and a date that will be used to select the date's report. so all the information i need is coming from this table. all i need to do is how to say like "SELECT Count* Question where Review date = "user entered date" and answer = "very good" etc.
View 4 RepliesI want to SELECT a user from a table using the WHERE clause. I know how to write the query, but how do I execute it and how do I match the UserId with the current one (how do I know what the current userid is using the login controls)? I basically want to display profile information by selecting the table and matching it to the userid.
View 2 RepliesI need to insert records in my webapp into a simple sql-db-table. The thing is, that the user chooses the position of every new record to insert. If I take an integer index, and the user want to insert an object between the 3rd and the 4th object, it is not possible, because 3.5 is no integer-value. An index of real could be the solution. Probably a litte complicated, as soon as a new object needs to be inserted between 3.45 and 3.89 (example).
If you know an easier approach for inserting records at any position by having the ability to sort by the initially choosen order (index?)
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 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 have an ASP.NET site that I'm going to have to take down to make some major structural updates to, and I was wondering how I should go about it from the client-side perspective. I have heard of an App_Offline.htm file or something like that, but I've never really gotten that to successfully work. Does anyone know how to do this?
EDIT
My app is running ASP.NET 4.0, for what it is worth.
I am using a server control on a single web.forms page. I have to use this control on a web.forms page since its a server control, although this is actually a MVC project. So I created a web.forms folder and put my new page in it. I then copy the example code from the signature control. I get the following error:
The base class includes the field 'ctrlSign', but its type (WebSignatureCapture.SignatureControl) is not compatible with the type of control (ASP.signaturecapture_signaturecontrol_ctlsignature_ascx).
I know the code works because if I removed the ID attribute from the server control, it no longer gives me this error and my control renders. But I need the attribute for the ID so I can perform is post event
I am using this signature control. Here's the web.forms code...
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="KahunaCentralTIDRevamp.SignatureCapture.Index" %> [code]....
What I'm looking to do is lock the application so the admin can do maintenance for however long. All i want to do is be able to click a button on a "maintenance" page and it makes it so anyone who attempts to use the system and anyone who is already in the system is redirected to a page, if they try to do anything, that says the site is down for maintenance.
on postback, on redirect, etc. No Access until that button is clicked again to unlock.
How does one put up a server maintenance page or reference..
Do you build a whole separate asp.net project with you basic page and logo and use that on the domain, until your main project is back up and running..
I want to put website in maintenance mode, so i can rollover my new stuff. How can i keep users away from loging into my website and i will test my website live.
App_offline.html takes admin away as well. Is there any logical way of doing this?
in webform 1, i have search button when i click its open webform2 and there the gridview.
I want when i click the link in gridview in webform 2 then it close webform 2 and change the datasource parameter in webform 1 without open the new window (still same window)
What is right way to send visitors from one webform to other. What are their limitations and their plus points.
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
I 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.