When i am trying to add a data source to a dropdownlist control in asp.net using VWD, it doesnt allow me to to do that says the extension doesnt match.
I have msofficce 2007 and the msaccess file gets saved as accdb .
when trying to setup either sql or access DataSource control or Add- Connection in server explorer, i get the error 'the system cannot find the file specified' for my main user acct, its an admin for another admin acct going for same db, it works fine! in the past the 'cannot find file' error has sometimes turned out to be a permissions problem, but shouldn't be with 2 admin accounts. this is a .mdb and i can run access2003 no problem.i've checked the machine.config file for a bunch of suggestions on posts and even some registry keys, so far all checks out. evidently vs2005 has unique settings for each user, eg. i had to turn on line numbering for 2nd user. somehow i messed up my vs2005 settings for the problem user? or some registry key?
View 39 RepliesWhile writing to the SQL Server database, I might encounter the below error message:
"Error 823I/O error <error> detected during <operation> at offset <offset> in file
'<file>'"This error message may occur every time when I start SQL Server and access the MDF file.
i have a gridview that show data from sql data source . how i can make a button for save as gridview data into mdb access file !?
View 6 Repliesi have two dropdownlist , i want to add item in dropdownlist 2 from database if the city is changed in first dropdownlist..I am using access database
here is my code:
[code]....
but when i select any text , it will not show anything in dropdownlist2 ..
I simply want to create one file and then delete it, means I want to access one file subsequently. I am getting the very familiar error as shown in title. (Process can't access the file,) I have tried using file stream and all other stuff that I found from Googling but no success so far. Does any body have small and neat solution? in short, I would like to run the following statements without any error.File.Create("C:\hsp1.txt");
File.Open("C:\hsp1.txt", FileMode.Open, FileAccess.Read, FileShare.None);
i have an asp.net application
c# code
i have adtabase in access and i craete adatset from it
i want to create excell file
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 Repliesi use 2 dropdownlist with 2 object data source first dropdownlist to display departments name using object datasource (field to display DeptName , value of field DeptID)
second dropdownlist to display Employee name but depend on departments (field to display EmpName , value of field EmpID)
how to display employee name in dropdownlist depend on departments name in the other dropdownlist
2 tables
1 table deprtments with column (DeptID , DeptName , DeptDescription)
2 table Employee with column (EmpID , DeptID , EmpName)
I have a situation where I am accessing a database multiple times and I'm wondering if it is necessary.
I have a GridView with a template column with a hyperlink to "Get Results" and on the RowDataBound event I have it check the batch number against the database and see if results exist and then if they don't, hide the link.
So when viewing the page if there is 20 rows in the gridview it is effectively doing 20 queries.
I was wondering if it is a better idea to query the database once with all "batches" and load it into a datatable, then on the RowDataBound event query the datatable. The only issue I see with this is there is currently 40,000 batches and grows daily.
I have 4 file uploader in my form to upload 4 images in the DB for each article submitted. My issue when I want update/edit my article with some new pictures and I want delete or update the old pictures with the replacement with the new one.
How I can implement it? I am using ASP.NET based on VB.NOT .... NOT C#
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 Repliesi am building a member management site for a sports club, i have all the usual feilds
lastName, firstName, address1, address2, address3 ....
but they also want a photo
when i first made the DB i used access 2010 which uses the 2007 file type which supports attachments, however asp.net doesnt support the 2007 format. and the 2003 file type doesnt support attachments, i assume i use the OLE object data type but i have no idea how i get my aspx page "new.aspx" to upload an attachment. plus i want to restrict the file type to *.jpg
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
i just wanted to know how to perform back up and restore of Ms Access database on a folder on the remote server through c# code.
View 1 Repliesthere are an access file . >> "test_file.mdb"
there are a table in mdb file .>> "test_table1"
and there are 2 columns in "test_table1" >> "name" and "age"
and i have 2 textbox in my web form . >> "textbox_name" and "textbox_age"
and i have a button for save textbox_name.text and textbox_age.text in mdb file .
i need adox vb code for save textboxs data in mdb file .
I have a page that I want to be able to amend certain user details.
The page starts with a drop down list where I query a table that holds the first and lastname of the users from an Access database. I concatenate the results so the full name appears in the drop down.
Then the problem comes when I click on a name I need it to populate a GridView with some of the details about that user with a Select and Delete button.
Because I'm using this as a query for the drop down and combining the two values the subsequent gridview query fails to take the value.
[Code]....
I have page which has many DropDownLists. I want to access them all with foreach. I had found some codes but they didn't worked for me. Some of them are having page.controls etc.
I have
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI;
I wan to edit Database file which is with .dat Extension.
The Connection string use in Configuration file that is.
<add name="TecsHomeConnectionString"
connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=TecsHome.dat; Jet OLEDB:Database Password=fdsa"
providerName="System.Data.OleDb" />
I have TecsHome.dat file. I am opening it in MS Access using Passwored = fdsa but MS access prompting invalid Password
how can i open it if the given password in connectionstring is not working.
keep in mind i don't have source code. I just want to open .Dat Database file.
Here is the code from a datagrid edit command in which I am attempting to populate a DropDownList in the EditTemplate from the database. The result is only one item (the first) from the database, instead of all items.
[Code]....
hi,i am creating form of purchase order . so i am using a datatable to get data from textbox, dropdownlist and then i want to display that data in gridview and after that do store that data to table in database . but due to some reason , its not working
I am trying to populate (store) an access database with the information from a DropDownList.
At the moment i have a form where the user inputs data into a textbox and on sumbission it adds to the access database. I am unsure how to add data to the database from the selections choosen in the DropDownList. I have a DropDownList for Title e.g. Mr,Mrs,Ms,Miss.
I have provided the code that populates the database from the TextBox's
[Code]....
I need to use FindControl to access a Dropdownlist in my webpage, however the control resides inside many panels like below:
ContentPlaceHolder -> UpdatePanel -> Panel -> TabContainer -> TabPanel -> Table -> TableRow
will I have to use FindControl recursively inorder to read the dropdownlist.
I have some field in datadase which is filled through checkboxlist , only selected checkbox has save to fields otherwise they remain blank: My problem is I want to show only filled value in label text using ";" , but when i am going to display it id display like:
[Code]....
I have a MVC dropdown list (Html.DropDownList) with list of Movies populated. I want to retrieve both Title(value field), Description(Text field) when I perform the form Submit. I can access the Title(value field), but I can't access the description. My code sample is below.
[Code]....
public string CinemaName { get; set; }