Posts made by udikantz

udikantz

help please

Net

udikantz

hey, cant find how to solve this thing, i have a test project with the following directory structure: /root/pages/default.aspx /root/App_LocalResources/default.aspx.resx /root/App_LocalResources/default.aspx.fr.resx using the following simple code: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TestLocale._Default" UICulture="auto:en-US" Culture="auto:en-US"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:Label ID="Label1" runat="server" Text="Label" meta:resourceKey="Label1"></asp:Label> </div> </form> </body> </html> at the resx file i have simple mapping for Label1.Text , The problem: for ssome reason ASP.NET can't find local resources when my default page is not at the root folder in the project, when i place the default.aspx in the root project the localization works, when i place the default.aspx inside a folder it doesnt work i have been searching everywhere and couldnt find how to make it work when using folders. any kind of help would help! thank you.

Net

udikantz

i need the messege to be displayed even if the file is already opened by MS ACCESS.

Net

udikantz

hi, i use VB.NET to develop an application which uses local MDB files as databases, my question is: is there anyway that i can indicate if a certain mdb file is already opened by another user ( even in access client ). the goal is if for example a user open 2 instances of my application and connect with both instances to the same mdb file, i would like to display a warning messege on the 2nd connection that there is already 1 connection opened to this particular mdb file. thanks in advance!

Net

udikantz

hey guys, i have a dataset which is bound to a gridview , i would like to make the first row in the dataset as the last row in the dataset or in the gridview ( eventually i need it for the gridview) what is the most effective way to do such simple task?

Net

udikantz

im using OLEDB my current connection string looks something like this: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\data\Demo.wwdb any known way for oledb i couldnt find

Net

udikantz

hi, is there anyway to set programaticly a connection to ms access .mdb file so the culture info in the connection would "en-us" or example if windows set to germany culture info ( dates are like 10.9.1982 ) i would like to insert rows through .net framework which contains dates in en-us format all the time and so acceess db would be able to parse them , or any alternatives? thanks

Net

udikantz

i am working on project which i developed for long time, recently someone out in germany wanted to use my application, so i made a few tests on my application on germany set regional info in windows ) then i found out they use a comma decimal separator which pretty much killed my application. i never thought of that before , i have done some reading on the subject and a lot of people like the idea of CultureInfo.InvariantCulture. in every parsing or to string method in the application , how ever the project contains kazzillion lines of codes, and i rather shoot my self then doing that. i was looking for a way to set the, cultureinfo to en-us in the application level , found this example which didnt work for me: CultureInfo myCulture = new CultureInfo("en-US"); myCulture.DateTimeFormat.ShortDatePattern = "MM/dd/yyyy"; Application.CurrentCulture = myCulture; also found that i can change it on a thread level which doesn't really help me. please anyone with any tips or answer to how i can change the culture in application level , or any other alternative i would like to here , it would me alot thanks in advance!!!!!!!

Net

udikantz

yes i got the icon set in the application tab and in the main form it still happens.

Net

udikantz

Hello , I'm facing a problem , when i open 2 dialogs in my project my application icon disappear instead i get the ugly .net default icon showing there are 2 windows open , when i click on it , i can see the two different windows with the icons , my question is how can i prevent my application icon to disappear and keep it visible no matter how many open dialogs I'm viewing. thanks in advance!

Net

udikantz

hey i have created my own custom property the property is of type collection , it displays a form which allow the user to add a list of images and strings, it stores the data in a collection , my problem is , i have noticed that after adding items to the collection at design time , there is no code generated in the .Designer file of the form and there for when i close the for / save it and reload it , all the items that i added to my custom property are gone. my question , what did i miss here ? how do i make my custom property generate code at the .designer file for the items i have added to my property? thanks.

Net

udikantz

hi guys, i am developing an application which uses access mdb files as database. untill now i used a connection to the files, using the following code:

Public Class DBconnector

Private \_dbConnection As OleDbConnection
Private \_dbCommand As OleDbCommand
Private \_dbDataReader As OleDbDataReader
Private \_dbDataAdapter As OleDbDataAdapter
Private \_dbTransaction As OleDbTransaction
'Private \_dbADODBConnection As ADODB.


Public Sub New(ByVal cs As String)

    \_dbConnection = New OleDbConnection(cs)
    \_dbCommand = \_dbConnection.CreateCommand

End Sub

where the connection string is:

"Provider=Microsoft.Jet.OLEDB.4.0;"
& "Data Source=" & TextEditPath.Text

texteditpath is the file path and name. recently i have encountered an error while trying to create a relationship using "ON DELETE CASCADE" in the constraint clause. error mentioned theres a syntax error on the constraint clause and there was no real syntax error , after troling microsoft forums , they have told me i need to use ADO connection because this bug results cause of use in DAO , also i may add that when i execute the query in the imidiate debug widow of access 2007 it is executed with no errors , how ever when i execute it on the SQL design window of access 2007 i get the same error as i get in the .net frame work my question is how do i establish an ADO connection to access MDB file or how do i over come this bug , please help im stuck with this for a week now , thanks...

Net

modified on Tuesday, March 17, 2009 4:09 AM

udikantz

Hey everyone , i am working on a custom control, i was wondering how could i make a property which acts like a list so you could add a list of integers or strings to it through the designer. for example when you add items to a combobox you got a "..." button near items in the designer and when you click it you can add a list of items through the designer , i was wondering how could i achieve that. thank you for your time.

Net

udikantz

.

Net

udikantz

need help here

Net

udikantz

hey, I have established an ado connection and excuted the query through the connection resulted with the same error as the oleDB i used the following code:

Public Sub adoUpdate(ByVal ct As String)
Dim con As New ADODB.Connection()
con.ConnectionString = _dbConnection.ConnectionString
con.Open()
con.Execute(ct)
con.Close()

End Sub

_dbConnection.ConnectionString contains the same connection string that i mentioned in this thread. im really clueless need some more help pelase , thanks for all the help !!!

Net

udikantz

mistake in my post the sql in design window is:

ALTER TABLE Holiday ADD CONSTRAINT CalendarHoliday FOREIGN KEY ([calendarid]) REFERENCES Calendar ([id]) ON DELETE CASCADE

Net

udikantz

yes, in the command line the Query works im executing the following query:

CurrentProject.Connection.Execute "ALTER TABLE Holiday ADD CONSTRAINT CalendarHoliday FOREIGN KEY ([calendarid]) REFERENCES Calendar ([id]) ON DELETE CASCADE"

although in the SQL designer window of access 2007 the following query wont work:

ALTER TABLE Holiday ADD CONSTRAINT CalendarHoliday FOREIGN KEY ([calendarid]) REFERENCES Calendar ([id])

generate same error as i get in the oleDB connector withing the .net framework: syntax error in constrain calause i dont know how to set a connection to the file so this query will work as it works in the immidiate window

Net

udikantz

hi guys, i am developing an application which uses access mdb files as database. untill now i used a connection to the files, using the following code:

Public Class DBconnector

Private \_dbConnection As OleDbConnection
Private \_dbCommand As OleDbCommand
Private \_dbDataReader As OleDbDataReader
Private \_dbDataAdapter As OleDbDataAdapter
Private \_dbTransaction As OleDbTransaction
'Private \_dbADODBConnection As ADODB.


Public Sub New(ByVal cs As String)

    \_dbConnection = New OleDbConnection(cs)
    \_dbCommand = \_dbConnection.CreateCommand

End Sub

where the connection string is:

"Provider=Microsoft.Jet.OLEDB.4.0;"
& "Data Source=" & TextEditPath.Text

texteditpath is the file path and name. recently i have encountered an error while trying to create a relationship using "ON DELETE CASCADE" in the constraint clause. error mentioned theres a syntax error on the constraint clause and there was no real syntax error , after troling microsoft forums , they have told me i need to use ADO connection because this bug results cause of use in DAO , my question is how do i establish an ADO connection to access MDB file you can see my discussion in the ms forums here: http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?pg=2&cat=en_us_328f8dd6-f51c-496e-93d7-5d47a17e195c&lang=en&cr=us&guid=&sloc=en-us&dg=microsoft.public.access.queries&fltr=[^] under the title : "add constraint return syntax error"

Net

udikantz

Thank you its exactly what i was looking for.

Net