Forms Data Controls :: Using Formview, Tables, And Access Database Along With The BLL & DAL Model?
Jul 7, 2010
Really new to C# & Web developing - but have used the DAL & BLL model from a number of the turorials. Have a situation that I not sure the best way to accomplish. I have an application dealing with courses, books, etc. utilizing an Access Database. All was going well in creating an on-line catalog using Formview and tables to display the db values stored in the Course Table (Course ID the key). User is able to use dropdown list to locate the course - dropdown list showed the Course Nbr & Name, but used the Course ID to get the detail. This issue appeared when they introduced a Prerequisite field in the Course Table. This contains the Course ID of the prerequisite course, but they want to display the Course Nbr and Name in the table field. So today it show 18 (Course ID) and they want B101 Intro to Biology. Hope I have provided enough information of what the code looks like below
Here is the FORMVIEW & TABLEROW
<asp:FormView ID="FVGeeralidades" runat="server" DataKeyNames="ClaveAsignaturas"
DataSourceID="ObjectDataSource1">
<ItemTemplate>
<asp:TableRow ID="TableRow5" runat="server">
<asp:TableCell ID="TableCell11" runat="server" HorizontalAlign="Left" Text="<STRONG>1.6</STRONG> Prerrequisito"
Width="150px"></asp:TableCell>
<asp:TableCell ID="TableCell12" runat="server"></asp:TableCell>
<asp:TableCell ID="PrerrequisitoValue" runat="server" HorizontalAlign="Left">
<%# Eval("AsignaturaPrerrequisito")%>
</asp:TableCell>
Here is also the OBJECT DATA SOURCE
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}"
SelectMethod="GetCourseByCourseID" TypeName="CoursesBLL">
<SelectParameters>
<asp:ControlParameter ControlID="DDLCourse" Name="CourseID" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
View 1 Replies
Similar Messages:
Apr 6, 2010
my application have two tables. TableA and TableB TableA have one record
ID StudentName Age
1 MARK 20
I use selectlist to select StudentName .
ViewData["StudentName"] = new SelectList(_db.StudentSet.ToList(), "StudentName", "StudentName");
and then add to TableB. for this case , for me is success, but I also want to add the"Age" into TableB on same time. I don't know how to do it.
View 3 Replies
Oct 27, 2010
How do I access a specific control within a FormView's "<InsertItemTemplate>"?
View 2 Replies
Jan 30, 2010
I am trying to access accessing a control in a Formview. I have tried several methods, but nothing seems to work
[Code]....
[Code]....
View 6 Replies
Sep 9, 2010
I have a main formview which contains another formview. In the second formview I have a section that needs to insert/update. I want to access this formviews events for example I can access the main formviews item inserted event in the code behind:
FVInvoiceHCPAgreement_ItemInserted
I can't choose the nested formview events in the code behind
ie. FVInvoicePaymentInfo_ItemInserted
I have tried adding the ItemInserted event in the .aspx page
i.e. onItemInserted = "FVInvoicePaymentInfo_ItemInserted"
but for the handles clause it can't see FVInvoicePaymentInfo.
View 3 Replies
Aug 3, 2010
I am trying get a file upload DLL control ( Subgurim.Controles) to function inside of a FormView
I have it registered as an assembly, but FileUploaderAJAX1 is not in context.
I tried :
[Code]....
View 1 Replies
Mar 18, 2010
I have a formview and a few buttons outside the formview. How can i access the formview.itemcommand event if the buttons are not in the formview?
View 9 Replies
Feb 24, 2010
I have a Customer database table with a text field named customerPicture with the name of the JPG file.
I have made a Customer Entity class with the LinQ to SQL Designer.
I also have a FormView displaying Customer instance binding with a LinqDataSource.
My problem is:
I want to make some modifications when some control want to bind the customerPicture field.
For example, when my FromView want to show the field customerPicture I want to return not only the JPG file name, I want to modify this string to add the complete file path and perhaps resample the image to a determinate width and height.
I know that is posible to defeine a partial class named Customer to implement certains partial methods, like OnCustomerPictureChanged(), but I dont know how to do this.
If I make, in this Customer partial class, a new method, for example getResamplePicturePath(), how could I invoke it from a FormView?
View 10 Replies
Apr 16, 2010
Basically as the title of this thread states, I have a FormView that has a GridView inside it and my ObjectDataSource that populates this grid cannot access the Grid.
The Control Id needs to be the name of the Grid I want to access, however through the 'wizard' the Control parameter drop down cannot 'see' the grid I need, only the FormView that is in.
I have tried numerous ways to get round this and am struggling now..
I've tried the following...
ControlID="FormView.GridView1"
ControlID="FormView.FindControl("GridView1")
ControlID="<%= GetNameOfGrid %>"
and numerous other attempts that also failed that I now cant remember...
View 2 Replies
Aug 3, 2010
I have an access database where when the record is updated I would like to automatically check a box and update the date to the current date in an Access 2002-2003 database. I've tried this for several days without any resolution and can't find anything that works on the net. ...I'm new at this.
I'm using VWD 2005 Express and Expressions Web 3.
Here is a short version of the code.
[Code]....
View 5 Replies
Nov 17, 2010
Is there a way to create dynamic access database, tables and it's columns in c# and export or insert the data in it from excel file in c#?
How can I create the Access database and tables at run time using c#?
View 1 Replies
Aug 12, 2010
when i create my entity data model i have a situation in the DB like this :
TableFirst : [Id,IdTableSecond,IdTableSecondAgain];TableSecond[Id]
Created data model is: TableFirst.TableSecond and TableFirst.TableSecond1
Question is: Every time when i create my entity TableFirst.TableSecond will have same relation in behind (IdTableSecond) and TableFirst.TableSecond1 (IdTableSecondAgain)
or they may change?
View 1 Replies
Mar 13, 2010
I am using a FormView in an online quiz page for displaying the questions and RadioButtons (for answers) http://stackoverflow.com/questions/2438219/online-quiz-using-asp-dot-netNow, I need to pick the questions according to a TestID and a particular Set of that Test. The testid and the set_number would be passed using Session variables.I'm having 3 testIDs and 3 Sets per TestID and, thus, am using 9 tables to store the Questions, the Options and the correct answer.I need help on how to set the FormView so that it extracts the questions from a particular table only. Do I need to use a StoredProcedure ? If yes, how?PS: If I use only one table to store all the questions from each Set and for each TestID, I can do that, but I'd prefer using separate tables.UpdateSOLVED myself[CLOSED]
View 1 Replies
Feb 1, 2010
I'm not sure if I can explain this properly, I just need some advise. I'm working with a formview and datasets to populate the information. However I have a table specifiying which fields to display. In my table If cell, work and home fields are selected then those fields must be populated in the formview if they not selected then it shouldn't be shown. These are 2 different datasets being pulled into the formview.
Right now I have a datasource populating the formview via the wizard, not sure what to do next.
View 5 Replies
Aug 20, 2010
i would like to find out how to go about displaying data from multiple database tables on the same page. What i mean is it would look like the feeds on the facebook home page where you can see the information like newply uploaded photo or a new post.
I have two tables, and i want to display any newly created row on my home page from either table in the same control. Currently, i have two gridviews, but i want the data from both tables be displayed together.
View 4 Replies
Jan 10, 2011
here I can find some info on how to display data from my MSSQL database in something like old style tables (table,<tr>,<td>) becouse I used to done it like this in classic asp but i had a formula for calculating where to put tr or td and it becomed very confused, not to mention displaying gruped records like 10 on each page...I tried gridview in VisualStudio but I can not find any info how to use sql in it so I think it can not help me becouse it is to much predefined and I do not know where I can change code for it like what data source to use, sql and other important thing
View 3 Replies
Oct 20, 2010
I have an ASP.net security database which is normally ASPNetDB.MDF however I have created the same database structure in MS Access. All works great. However, I need to add a couple of other tables but I can't find how to do that in VWD. I'm pretty sure I was able to when the first database I created was an MDF file but not in MS Access.
View 5 Replies
Oct 25, 2010
Example: we have different articles in a database like cars, jewelery, boats. The data related to these articles is different in the tables. I have to show that data in a textboxes and let the user change those data and update. I can do the update and reading the data from database. But the problems is for each item the no.of columns and rows will differ.
My task is I need to get the data according to the use selection in the table with textboxes. I dont know which container (gridview, formview or etc) will suites for my requirement. send me any sample code or any tutorial related to this.
Note: showing the data in a table should be a constraint. Because I should show data row wise (each row contains 3 textboxes and 3 labels (DB table column names))
View 6 Replies
Feb 4, 2011
I have used a microsoft tool before that was allowing me to automatically generate admin web pages from database tables. By admin web pages I mean pages that allow me to do CRUD operations on my tables.
View 1 Replies
Feb 16, 2011
I have three tables
tbl_Cus CatID (Int) CustID(int) CabID(int)
tbl_Cat CatID(int) CatName(varchar) CusID
tbl_Cab CatId(int) CabID(int) CabName(varchar)
I am using Tree View control for the first time.
The above tables I want to bind it to a tree view control the tree view should look some thing like this.
Cus Name1
Cat Name1
CabName1
CabName2
CatName2
CabName1
CabName2
Cus Name2
Cat Name3
CabName1
CabName2
CatName4
CabName1
CabName2
View 2 Replies
Feb 1, 2011
Using a class component, an Object data source and a formview I am successfully pulliing data from a SQL database. In some cases the rows contain one or more Null values and I would like them to be ignored completely. My simple code follows:-
<%# Eval("add_1") & ","%>
<%# Eval("Add_2") & ","%>
<%# Eval("Add_3") & ","%>
OUTPUT:-
Rose Cottage, 123 New Road, Margate,
View 2 Replies
Apr 27, 2016
How to Call a record on datalist by button click and display record on formview in model using Username
Here is what i tried
<asp:DataList ID="GetMergedAll." runat="server">
<asp:Label ID="Name" runat="server" Text="Label"></asp:Label>
<asp:Label ID="Post" runat="server" Text="Label"></asp:Label>
<asp:LinkButton ID="LinkButton6" runat="server">LinkButton</asp:LinkButton>
</asp:DataList>
protected void Page_Load(object sender, EventArgs e)
[Code] ....
HTML
model here
<asp:FormView ID="Post" runat="server">
<asp:Label ID="Name" runat="server" Text="Label"></asp:Label>
<asp:Label ID="Post" runat="server" Text="Label"></asp:Label>
</asp:FormView>
View 1 Replies
Dec 5, 2010
I'm fairly new to all this, but have slowly been teaching myself C# and ASP.net MVC over the past year or so...I really tried to search for this, but haven't been able to find anything - it may be I'm using the wrong terminology!I'm using ASP.NET MVC2 with EF4 connected to a SQL Express db. Situation: Without getting into too much specifics, I have one table called 'Plan.' Under 'Plan' are several different categories that are related to a single Plan item [say Category A, Category B, Category C and Category D]. Each 'Category X' table has a beginDate, endDate and other details specific to that category.
I'd like to be able to create a summary page that combines all items from Category A, Category B, Category C, and Category D and sorts by beginDate - but only need a few of the columns [eg - begin/end date, name, id].
View 1 Replies
Jun 18, 2010
I have a set of MS Access data (tables); is there a simple way to convert to SQL (.mdf) tables?
View 2 Replies
Feb 9, 2010
I'm trying make FormView insert a new row into a database table via a stored procedure.My code runs without error but nothing appears in the database table.
View 14 Replies