Hello All!
I am using access object to run a module in my access database. The module runs fine. However, the database does not get closed even though I have tried many things to quit\close\rele ase objects. Everytime the calling class tries to open a connection to that db, I get an error saying "cannot use the file".
Following is my code -
-----------------------------------------------------------------------------------------...
helloitsme
Last Activity: Dec 30 '09, 04:47 PM
Joined: Oct 5 '06
Location:
-
MS access object - db does not get closed
-
Problem Setting TimeZone with SetTimeZoneInformation
Hello All!
I know there already exists a thread with this topic by Mike! But my problem did not get solved with that....
I have a working code in VB6 that can set the selected timezone for the system. When i converted that code in VB .NET, I am having a problem similar to what Mike was having. When I select my timezone to Eastern Time Zone (or SA Pacific), my code sets my system timezone to 'Bogota, Lima, Quito'. i guess... -
Kill and restart the same application through code
Hi!
For a certain requirement, I need to kill the current application and restart the same application again. For that, I have the follofing code in the form-closing event of the application -
...Code:If myflag = false Then Dim p As New System.Diagnostics.ProcessStartInfo() p.FileName = """" & My.Application.Info.DirectoryPath & "\" & My.Application.Info.AssemblyName
-
I am using Windows XP Professional 2002....does that matter? -
Check Access permissions of Directory?
Hello!
How can we find out the sharing/access permissions of a directory ? Like, i need to know if a given directory is shared as readonly or with full access?
I guess we can use directoryinfo.a ttributes somehow to do that, but I dont know how exactly ??
Please help me with this....
Thanx -
Problem with executing DTS package !
Hello!
I have a DTS package that copies data from a flat file source to a OLEDB destination ( a table in SQL server database). The package executes fine when the .dtsx is executed (by double clicking it), but when i try to execute it through my VC# code, the records are not copied in the database, though the result shown (by DTSExecResult) is 'success'.
...Code:Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
-
Thank you for replying...
I tried doing so using the following before doing the .Fill -
if this is what you were talking about, then this did not help either...Code:DA.MissingSchemaAction = MissingSchemaAction.AddWithKey;
Please let me know if did something wrong or understood wrong...
thanx...Leave a comment:
-
Duplicate rows in the Dataset!
Hello!
I use DataAdapter.Fil l method to fill the dataset with data from a SQL database table. But when the same method is called for a second time subsequently, it appends the data instead of overwriting the duplicate rows in the table.
For example, i use DataAdapter.Fil l(mydataset,"my table"). the "mytable" has 50 rows and copies the same to "maytable" in mydataset. But after a subsequent... -
use INSERT INTO with a VALUE which a variable
Hello!
Can someone please help me build the query to insert a record in a data table, where this record is a variable and is obtained by reading a texbox.
below is the code (VC#) i tried to accomplish this,
...Code:string matter = textBoxSetMatterNo.Text; string myquery = "INSERT INTO S_Matter (Name) Values (@matter)"; SqlCommand command = new SqlCommand(myquery, -
ComboBox items from a column in a database table!
Hello!
Can someone please guide me to do the following -
I am using a combobox on my form. I want the items of this combobox to come from a column in one of my database tables. Something like this - i have a combobox that would list name of the employess. these names are present in a column called "Name" in a table S_Employee in my SQL database Process_Employe e.
in the propoerties of the combobox,... -
How to run a SQL script from within a VC# code?
Hello!
I have a SQL script that generates some tables. I need to intigrate that into my VC# code, and get or set data values in the tables generated by that script through the code. The values to be obtained from or set into these tables come from a GUI (a user sets some values through the GUI).
I have the GUI, I have the SQL script, but I dont know how to integrate them and achieve the abovesaid....
Kindly... -
Hello..Thanx for replying...
well, I do not understand what you mean by evidence in this case....
if you mean I need a stream reader or somthing, then I am able to read the file using a streamreader and then display the contents in a richtextbox. but what I want is that the file should open as it does when you open it up from the windows explorer....
please let me know ....
thanx again !Leave a comment:
-
Thank you for replying...
According to what I understand from the description of the filedialog, the method openfile opens the file that is selected by the user in the dialog box of filedialog that appears...
Please let me know if I understood something wrong...I am not sure what is to be saved for that to happen...
Thnax..Leave a comment:
-
Open a File using openfiledialog...
Hello!
I am trying to open a file that is selected by a user from the openfiledialog box, but the file does not open. Below is the part of the code that does so...
............... ............... ............... ............... ........
OpenFileDialog fdlg = new OpenFileDialog( );
fdlg.Filter = "Text Files(*.txt)|*. txt";
fdlg.RestoreDir ectory = true;
... -
Thank you for replying. I found out the cause. Actually my string was in unicode, which made my characters occupy 2 bytes....
Thank you though...Leave a comment:
-
Unwanted space characters in the created file...
Hello!
I created a batch file, which contains a string. But the string is written in the file with a space character between 2 consecutive characters ...
When I write the same string in a *.txt file, no space characters are written.
Please help me find out whats going on...
Thanx a lot! -
Hello !
to conitnue my previous post, below is the part of the code where I am trying to launch notepad through command prompt using shellexecute.
with this, the commandprompt does come up, but the text "NOTEPAD" is not passed to the command window. please help me do that...
............... ............... ............... ............... .........
int x = (int)ShellExecu te(NULL, NULL, L"C:\\WINDOWS\\ system32\\cmd.e xe",...Leave a comment:
-
Hello Jagdish!
Thank you for your reply!
Can you please tell me how to open the command prompt using shellexecute...
thank you once again....Leave a comment:
-
Thanx a lot Banfa for your reply!
I tried using CreateProcess. But I keep getting the error "Unhandled exception at 0x7c825352 in InventoryFiles. exe: 0xC0000005: Access violation writing location 0x006a3ce2.".
I dont know where the problem lies.
the part of code I used for my testing of this function is -
-----------------------------------------
STARTUPINFO si;
...Leave a comment:
-
How to launch a EXE file from within the VC++ code?
Hello!
Could someone please help me figure out how to run an executable file from within the soure code and pass the commands to the exe file to be launched!
I was trying to use tools.shell, but it gives me error...
please help....
No activity results to display
Leave a comment: