I am new to asp.net. I have C# MVC application and I need read data (id, name) from .mdb file (in controller) and then pass it to view.
My controller code:
OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("App_Data/data.mdb") + ";");
I've an XML file stored in App_Data which is only used to read some configuration on startup. When I attempt to open it within my code, I get an Access to the path ... is denied message.
I'm having trouble understanding why, and how to solve it. I guess in theory I should alter the permissions on the file (and directory), but this hasn't changed anything.
To give a bit more background:1. Its a file bundled with the project, so the setup created by VS2008 writes it to the correct place during install. I didn't think I'd need to do anything unusual post install such that the ASP.NET application would have access.
2. When I've tried publishing this locally, I've not had any problems. - This is only on a test Windows 2003 server.
3. I've ran a simple page to understand the effective user of IIS - It is NT AUTHORITYNETWORK SERVICE. I tried granting "Full Access" to this user to this file, and still it doesn't work.The code to open it is simple:
FileStream fs = new FileStream(Server.mapPath(s), FileMode.Open);
Where s is defined as '~/App_Data/myfile.xml
I've even copied and pasted the full path & filename (from the exception) and tried "dir" on it, and it is indeed present (to get around a typo for example).I've also tried running aspnet_regiis.exe /s
I have a lot of members data to enter into the ASPNETDB database. How can I read this data from an Access data file and input into the SQL database. All data is for user Names and Password,
View 1 Replieshow to give read only access to the xml file in c#?
View 1 RepliesI upload the file. I m creating web service to read that uploaded file. how can I access that uploaded file path in web service.? How can I read the uploaded file using web service?
View 5 Repliesi am facing some problem in update, edit and even create new data into my access database using data detail view. i am using microsoft visual web developer 2008, i can do the same when sql server database were to tore the data. but when i try to do the same using access database, an application error. may i know whats going wrong? and how to solve this problem?
View 7 RepliesI´have this situation: I have a Master Page for all my pages.
Inside it I have a Partial Page that render the Main Menu of my site.
My question is how to pass a data from a Controller (For example AboutController) to the Menu so it can "knows" that in the "about" li, render an aditional class in it..
Normally is: <li>About</li>
But the About page: <li class="on">About</li>
I think that controllers must send this aprameter.. or not? how?
I want to read the data from the grid view(Default1.aspx) for a particular row. How do I achieve this?
After that I want to redirect to another page(Default2.aspx) and display the data for that row in different controls of another page(Default2.aspx). how do I achieve this?
i have loaded a datagrid with some data from access database using sql query. i have to read the data loaded in datagrid view the syntax to read data cell by cell usiing vb code.
View 6 RepliesI have a strongly typed view for my User edit action. When I press edit all the fields in Users model is filled with values from the DB. If I enter an invalid data for a particular field say email, then the view throws an error, but after that the email field contains data pulled from the DB and not the one which i entered previously.
I will explain to you in steps if my explanation is confusing.
1.Click the edit action.
2.A page displays with all fields in my User model.
3.Email field contains : johnson@company.com (pulled from the database)
4.I try to change the email to "johnson@company1" (This is an invalid email id)
5.The form does a post back and return an error saying that email id is invalid.
6.Email field contains : johnson@company.com (pulled from the database) and not "johnson@company1"
Is there a way to convert the FormCollection to an User model and send it back to the view?
I need to read a table from a dtgrid there is one code for example?
View 5 RepliesI have created a Details View and set some of the fields to read only. I have added the edit command which is allowing me to edit all of the fields that are not set to read only but when I press the update button all the infomation stored in the readomly fields gets deleted and just show up as blank is there a way to stop them from getting deleted.
View 1 RepliesCan a view pass some sort of model like data to a Master page? I am using the ViewData collection, but that makes for confusion in my code. When I specify the Master in the View, can I also specify a parameter?
View 1 RepliesHow Can I Pass data(not the part of model) to Controller from View? View Code
[Code]....
I am doing loan sysytem where you first select the amount you want to borrow and click apply. the problem im getting is i cant seem to be able to redirect the amount selected to my second view where the client fill up the form.
View 1 RepliesI have 5 colums but i want name and  (time total ) means only name and sum of time appear in list view like this
name    time
ali       00:20:14
aslam    00:30:45Â
my query is
CONVERT name , (TIME, DATEADD(s, SUM(( DATEPART(hh, Timer) * 3600 ) + ( DATEPART(mi, Timer) * 60 ) + DATEPART(ss, Timer)), 0)) AS total_time FROM Project_To_Done where name = @ name
but i got an error
Column 'Project_To_Done.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Let's say there is a textbox and a dropdownlist in mainview page, these two values are used by three partial views as well. when I use Html.RenderAction to post action to those three partial views, how to pass these two values to those partial views and in those views how to get these two values as a part of a object to send to database.
View 10 RepliesI'm trying to pass a list of data from the column CICodeID in my database where the currently logged in users name matches the UserId.
Here is my controller: [Code]....
And here is my view: [Code]....
This is the exception I'm getting at run time:"Cannot compare elements of type 'System.Linq.IQueryable`1'. Only primitive types (such as Int32, String, and Guid) and entity types are supported."
I have 2 views(2 view pages) in first view page I will display some names in this page i will have add button after clicking on add button it will redirect to another page (2nd view page) in this i will display multi selected list or listview then i will select multiple items from multi selected list now this selected items has to bind with first view names and display updated list in 1st page?
My question is this selected items in 2nd view page has to bind with 1st view page and display how to do this using mvc razor for mobile application?Â
I would like to add a partial view to my view page
The view page contain a mode name "<IEnumerable<JvTake1.Models.VortN>>
And the partial view contain a model name "<IEnumerable<JvTake1.Models.VideoL>>"
So, theoretically I think they were suppose to work together but no Can any one guide me how to make it happen?
how can we pass data from view to controller in Asp.net mvc
View 1 RepliesI'm having a difficult challenge of passing a DropDownList Selected Value to a Data Layer having a Function containing 'cmd.Parameters.AddWithValue("@CourseDDLid", CoursesDDL.SelectedValue.ToString)'. Visual Studio is indicating I need to declare 'CoursesDDL'. I tried accessing the 'Find Control' method but it did not work. Below are the codes for your review.
[Code]....
Well i am a sort of a beginner..
I am writing an Application using mvc and c#..
Well i have a View where i have the following code..
[Code]....
if I use a Html.Hidden field in my view, when the value click to submit the form I would like to pass this data to the controller. This variable would contain int as key and string as value,
Dictionary<int, string> interestTable = new Dictionary<int, string>();
How can I specify the htmlAttribute fo this variable in my Html.Hidden code?
<% using(Html.BeginForm("Search", "SearchMembers")) { %>
<input type="hidden" name="ResearchInterests" id="researchInterests" value=""/>
<%= Html.Hidden("fullInterestsPath") %>,
Iam facing the problem with creating the Data Access layer using Dataset.xsd file and How to access the data from the file.
View 2 Replies