I'm trying to connect to a MS Access database, loop through all db tables and read the 'modified' timestamp, how to achieve that. Using 'Microsoft.Jet.OLEDB.4.0' driver and C#.
View 3 Replies
[code]....
Above is my select query result. "Select Groupname from table". Now i want to add dynamit row in table which display like follows.
[code]....
so that i can display the combobox with default value '-Select-'. I tried combobox.item.insert(0.'"Select") but it gives error.
"Items collection cannot be modified when the DataSource property is set."
so I am trying to add dynamically into table.
I got 2 listboxes in a window form, one on left and one on right. The 1st listbox have some items while the 2nd listbox is empty. Also there are 2 buttons between the 2 listboxes which used to move item from/to the 1st and 2nd listbox.My problem here is that after I bind the data to the 1st listbox (from a dataTable, using DisplayMember and ValueMember) , and I try to move 1 of the item from this 1st listbox to the 2nd listbox and I want that the selected item is also removed from the 1st listbox by:
lbMembers2.Items. Add(lbMembers1. Text);
lbMembers1.Items. Remove(lbMembers 1.Text);
But the selected item is not removed from the 1st listbox.Also on deselect button when i move item from 2nd listbox to 1st listbox,it displays error message "Items collection cannot be modified when the DataSource property is set."
Here's a short explanation of my asp.net project.
1) the default page loads, it will read the Windows Login of the user opening the page.
2) I'll check if this login exists in a table stored on the webserver.
In this Access Database, there's a 2nd linked table, pointing to another access table on a network location. Now, I want to read data from this linked table. However, at this moment I receive an error:
"The Microsoft Jet database engine cannot open the file '\<ip><shared-folder>statistics.mdb'. It is already opened exclusively by another user, or you need permission to view its data".
Some extra info:
- The network folder has read and write permissions for everyone
- the user and group permissions on both access files are set to read/modify/administer for the Admin user (on the tables I want to read from)
- IIS authentication on the server is set to "Windows Authentication" (this is needed so I can read the Windows Login from the user). All other authentication modes are disables (like anonymous, ...)
- When the error occurs, no other program or process has access to the statistics.mdb (so, it can't be locked by someone else)
- the web.config files access connection string looks like:
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\<IP><shared-folder>statistics.mdb;User Id=admin; Password=;" />
Like I said before, in this statistics.mdb file, there are 2 tables. One normal table, and another linked table (pointing to a network location)
Searching for solutions, I discovered the following:
- if I don't use linked tables, everything works fine (however, I have to use this linked table)
- even if I connect directly to the table in the network I receive the error. So, I'm pretty sure I don't have sufficient rights to read from this table.
I read that not the Admin user is opening the file, but actually a user called ASP.NET. This user doesn't have the correct rights to do this. However, I'm not sure if this is true.
I have an ASP.Net ListBox that I'm trying to populate via jQuery, using the following snippet:
$("#MyList_btnAddAll").click(function(e) {
e.preventDefault();
$('#MyList_lstAll option').appendTo('#MyList_lstSelected');
});
The code has two ListBoxes in fact, one a "source" and the other a "destination". As you can tell above the ListBoxes are MyList_lstAll and MyList_lstSelected. These are rendered in the browser as <select> elements, as you'd expect.
The jQuery is working great, the items are moving from one ListBox to the other, the DOM is updated but when I submit this form (not using jQuery), the ListBoxes don't reflect this change on postback.
I realize my modifications via jQuery aren't available in ViewState but I thought since the DOM was updated these changes would be part of the postback data? But in the codebehind after postback the ListBox contents haven't changed. Does anyone know what might be going on and what I can do about it?
I am modified CreateUserWizard Template to accept additional user information such as address, city, state and zip. I wanna store this additional data into a table i create call UserInformation. The table has UserId as it's primary key and it's also a foregin key to apsnet_Users. The tables also has an Address, city, state and zip column/field. I have an event that is called after a new User is Created and it is at this point where i wanna write the Address, City, State and Zip to the the database. What is the best way to write the data to the database..
[Code]....
i have a problem that only shows if EntityDataSource present on aspx pages ,interesting thing it's just occures when i'm refreshing the page (F5) or viewing it again and it's driving me crazy it's seems to be a bug with entity framework because i tried it with another project and i just get the same error:
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
[Code]....
I have a vb class that reads a single row of data from an SQL view. I want to add a property to it that will expose the value of a new bit field. But whatever I do my class always returns the value "false".What am I doing wrong?
Public ReadOnly Property IsPublished() As Boolean
Get
Return valPublished
End Get
End Property
Here's the relevant line from my datareader: Me.valPublished = Convert.ToBoolean(theObjectReader("Authorised"))Authorised is my bit field. I have tried it with and without the "ConvertToBoolean" statement.When I response write the value of the property for rows where this field is true, it always shows false.
I need to read a Property/variable from outside the webpart usercontrol to determine a course of action. This is not the same as using the Property Editor.
I have numerous usercontrol webparts all accessing the database.
When minimised, I don't want the webpart to hit the database.
So, I need to either : detect within the usercontrol webpart itself that its chromstate is minimised and therefore not access the database (and)or from the Webpartmanager loop through webparts, determine those that are minimised and set a variable / property within the webpart to inform it not to access the database on postback.
Something like...(pseudoCode)
for (int i = 0 ; i < webpartmanager1.webparts.count ; i++ )
webpart wp = (webpart)webpartmanager1.webpart[i];
if (wp != null)
if (wp.ChromeState == PartChromeState.Minimized)
{
// set a known variable in this particular webpart so it can determine whether to refresh its datagrid or gridview or whatever
}
}
OR
Can a usercontrol webpart determine its own ChromeState ????
Dim ds As New AccessDataSource
ds.DataFile = "c:InputTest.mdb"
ds.DataSourceMode = SqlDataSourceMode.DataSet [code]....
I have a masterpage that contains all the javascript and inside the content control, there is a link that calls a javascript function and I want to pass the id once it's rendered differently by the server.
<asp:TextBox ID="txtstart" runat="server" Width="20%"></asp:TextBox>
<a title="Pick Date from Calendar" onclick="calendarPicker('<% txtstart.ClientId %>');" href="javascript:void(0);">
However, I keep getting this error:
Property access must assign to the property or use its value.
How would I be able to accomplish this?
Here's the code below:
[Code]....
The application that I am currently modifying is using an xsd file and the stored procedure has parameters which are passed.
I want to be able to take a select statement like: SELECT password FROM table WHERE user_name = @user_name and compare it with what was entered in a form text box. I have tried:
AccessDataSource1.SelectParameters("password").DefaultValue
= TextBox1.Text
AccessDataSource1.Select() (not sure how this works or what to set it equal to)
I also tried to connect to the database with a basic ADO connection that I got off another forum, with no luck
i need to retrieve all the records present in a database
iam using the following code but it fails to show any record
Dim con As New System.Data.OleDb.OleDbConnection
Dim myPath As String
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 RepliesI'm trying to retrive images from SQL (2005) using ASP.NET 2008
At present I have a business object layer and a data access layer to get some data from the database. This works fine but now, i would like to also retrive an image along with the data.
part of my business object layer is shown below, how can i incorporate the image into this.
I have a DLL file which will take care of displaying the image in the web page once i have retrived it.
[Code]....
I have table in database in which near about 2 lac records are available.
I am using access as database.
How can i get the particular row or records from the database in a minimal time
I want data to be retrieved faster
I have a simple issue that most likely is syntax related. I have a table ("myTable") that is dynamically generated at PageLoad and can be actively changed during run-time. One of the features the user is able to make use of is adding additional rows to the table, generated via Javascript. The user also has the ability to save the table (and it's changes) to the database via button. Upon selecting the button, I run a function that creates a two-dimensional array to store values (Row, column). After using the .FindControl function, I was able to get the client-side changes to each of the textboxes and dropdowns and populate the array with it.
After checking the information, it does in fact store into the array the value in the textboxes at the time of clicking the button. Example: Textbox loads with 200 in value, user changes it to 400, when button is selected the value stored is also 400. This works great, except for one issue... The additional rows.
When checking back in the array, it appears that the arrays size is generated by the table that is created at PageLoad instead of the table at the time the save button is selected. Example: myTable is created with 3 rows, user adds 2 more rows to the table, save button is pressed. The array displays 3 rows instead of 5 rows, however.................................
is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc? if so, how?
View 3 RepliesI have three tables.
CustomProfile
UserID (pk)
DisplayName
CompanyID
Teams
TeamRecordID (Pk)
TeamID
CompanyID
EmployeesInTeams
UserID
TeamID
I want to assign employees to teams via a gridview control with a templated checkbox.
I have a dropdownlist control to select the TeamID.
I am having problems with the select statement.
The gridview needs to select employees that are not assigned to any teams as well as assigned to other teams. An employee can be assigned to many teams.
What I have been trying is:
cp.UserID, cp.DisplayName, et.TeamIntID, cp.CompanyID
On UI Ajax calendar control is used to allow the user Expiry Date as shown below. As this is one of the controls in search, when the Search button is pressed using SQL statement (copied below) data is retrieved from ExpiryDate column of the table. The table creator declared the column type as string and the dates are saved as single digits(Example: 2/2/10 sometimes and sometime as double digits (Example: 02/02/10) I like to know the best practice in retrieving both type of strings from database table. Calendar control
[Code]....
SQL(part of stored proc)
[Code]....
with in button click event stored procedure is called to return search results.
I a function that used a mySQL Data Adapter and inserts a new row.
I want the function to return the value of the auto-incremented column of the updated row.
Public Function addRow(ByVal colA as String, ByVal colB as String) As Integer
Dim dbConnection As New MySqlConnection("server=xxx; user id=xxx; password=xxx; database=xxx; pooling=false;")
Dim dbDataAdapter As New MySqlDataAdapter("SELECT * FROM table", dbConnection)
[Code].....
The "Return..." line doesn't work and don't know what the correct code would be.
I am using query string under gridview, when i click link on gridview "
Datas are in table,
add_cat_name(field)
Educational aides-Glass Decorators (Display the value in search related page)
Colleges-Arts & Science Colleges UG/PG (does not display the value because (&)
My coding
<asp:GridView ID="GridView2" GridLines="none" runat="server" AutoGenerateColumns="false" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<a href="search_related.aspx?id=<%# Eval("add_cat_name")%>">
[Code] .....
I have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
[Code]....
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?
Can a query output made in MS ACCESS be accessed as a database in Visual Studio 2008?
I have a Parent and Child Table in MS Access with a one-to-many relationship. I created a query in Access that would produce a result table and I want the contents of this Query to be displayed in a Data Grid in Visual Studio 2008.
