|
hi everyone!!
i have a huge problem and i've been working out this one for a long time now. i need your help..
does anyone knows how am i supposed to set the database connection for access if the target computer (the one i am about to deploy the application) is not connected on the network? i have created some applications and executables before and it had perfectly worked because i am using a database that is stored in a server computer and i just configure the connection string based on the shared folder.
my current project work well with that too but i need to install this application to a laptop which is to be brought anywhere (of course) and is not connected on the network. how am i supposed to do this..? i badly need your help guys...
btw, i am using visual studio .net 2002 and my database is in ms access.
thanks a lot in advance!!! 
crookshanks
|
|
|
|
|
If your DB is access, then it's just an MDB file, deploy it with your app.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
thanks. i have included the database file in my project. but i dont know how to set the oledbconnection datasource..? i mean, i do not know how to declare the datasource path if my database is included in the project.
pls help.thanks.
crookshanks
|
|
|
|
|
The connection string will just be a path to the file - well, not just that, but it will contain the path to the file. So, you may have to build it in code.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
please help me how i am supposed to do that one.
i need to make a connection to the dataadapter that i am using to access my database. and since the database is included in the project which is stored in my C drive(for example), the path for the connection is in Cdrive also.
my problem is that when i install the application to the target computer, an error occur saying that it can't find the path to the database (since the target computer is not connected to the network)
crookshanks
|
|
|
|
|
crookshanks wrote: an error occur saying that it can't find the path to the database (since the target computer is not connected to the network)
Are you not deploying the database ? You should not keep the files in C drive. Keep it in your application directory and .NET framework provides method to access the current application working directory. So you won't miss the path.
|
|
|
|
|
i have the database included in the project.but i don't get what you mean by "deploying the database". i'm sorry i'm new in vb.net..
and also what you mean by application directory? thanks a lot.
crookshanks
|
|
|
|
|
deploying the database means copying the mdb file onto the target PC
the application directory is the directory in the file system that contains your exe, and presumably your mdb
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
I would like to add a button column on each row in datagrid.
How should i do it? I searched the forum from google.
The codes look like this: -
' Set datagrid XP Style Button ColumnStyle for City field
.Add(New DataGridXPButtonColumn(SystemColors.ControlText, SystemColors.Control))
' Also you may set datagrid Button ColumnStyle for City
' field without XP Button Style as the following:
' .Add(New DataGridButtonColumn())
With .Item(3)
.MappingName = "City"
.HeaderText = "City"
.Width = 60
.NullText = String.Empty
End With
But the problem that I'm facing is, i can't add "New DataGridXPButtonColumn" or "New DataGridButtonColumn" in datagridtablestyle.
There is no "datagridbuttoncolum" for me to add.
It's not allow for me to do so. How should i do?
Pls help.....
thanks in advance.
regards,
eunice
|
|
|
|
|
Are you using the DataGrid (.NET 1.0 and 1.1) or the DataGridView (.NET 2.0 and above)??
Google results for "add button to datagridview[^]".
|
|
|
|
|
Hi Dave,
I'm using DataGrid (.net 1.1) version, for vb.net window application.
It doesn't have "DataGridButtonColumn" control.
How can i add the button column in datagrid.
Pls guide me.
Thanks.
|
|
|
|
|
If like me, you have been waiting for a version of Crystal Reports 2008 that integrates with Visual Studio 2008, then the wait is over.
You can download Crystal Reports 2008 Service Pack 0 (yes, zero) from here[^], which includes VS 2008 integration.
Steve Jowett
-------------------------
I may not always be right, but I'm never wrong !
|
|
|
|
|
I have just started working for a company and I am having to learn vb.net.
I have been set a task to write a web app that will check a specified folder periodically for a new file. I was just wondering if you guys had any advice on what areas to concern my studies on?
Thanks in advance,
Aaran
|
|
|
|
|
The following are the namespaces you should research :-
System.IO<br />
System.IO.Directory<br />
System.IO.File
Also have a look at the FileSystemWatcher
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Now my friend, the first thing you should start buying a book in vb.net ,or Download some E-books. and try to Google. they already gave you an answer, but as a Beginner , you might be wonderig what does he means about the text he just sent you, he just mean look for those namespaces and start googling and look for answers your self, Good Programmers try to make a research before start asking people how somethings are done
hoope that helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Aaran Heavey wrote: eb app that will check a specified folder periodically for a new file.
A webapplication(ASP.NET) is having a very short lifetime on the server. And it is initiated by a request. I mean it's can't run in the background and check folder periodically. What you are supposed to do when the folder changes ? You may try windows services.
|
|
|
|
|
From what I gather when a new excel file is found, it's data must be transfered to a SQL server database. I am more accustomed to windows applications but the company seem to do most of their programs as web pages though they only run a few across the web (if that makes sense), the rest are locally ran.
Thanks to everyone for the replies!
modified on Wednesday, March 26, 2008 8:26 AM
|
|
|
|
|
Aaran Heavey wrote: new excel file is found, it's data must be transfered to a SQL server database.
Windows service is the best way to go. Write a windows service which use FileWatcher component and looks for the new file. This service shall open it and send data's to SQL server database. You need to install this windows service on the server where your web application is running.
|
|
|
|
|
Hello!
I am using VB2005.
I have a Form and have two buttons on it: 1) PRINT. 2) PRINT PREVIEW.
I have also dropped two controls on form: 1) PrintDocument. 2) PrintPreviewDialog.
Code Behind PRINT button is:
PrintDocument1.Print()
Code Behind PRINT PREVIEW button is:
PrintPreviewDialog1.Document = PrintDocument1<br />
PrintPreviewDialog1.ShowDialog()
When i click 'print' button it sends print to printer which is all OK.
But when i click 'Print Preview' i can see only a dot inside previw area.
However when i click Print button inside Print Preview control it prints fine.
Can't resolve problem!
Thanks for any help.
colgateas900197
|
|
|
|
|
What does the code look like that's doing the rendering of both the printed page and the print preview??
|
|
|
|
|
Thanks for your reply!
PRINT BUTTON CODE:
Try<br />
PrintDocument1.Print()<br />
Catch ex As Exception<br />
MessageBox.Show("An error occurred while printing" & vbCrLf & ex.ToString())<br />
End Try<br />
PRINT PREVIEW BUTTON CODE
<br />
PrintPreviewDialog1.PrintPreviewControl.Document = PrintDocument1<br />
PrintPreviewDialog1.PrintPreviewControl.InvalidatePreview()<br />
PrintPreviewDialog1.ShowDialog()<br />
PrintDocument1_PrintPage CODE contains simple drawing methods.
Print works fine but print preview displays nothing except small black dots in print preview area; that is each dot for each page.i have tried
InvalidatePreview() but it didn't help.
Thanks
colgateas900197
|
|
|
|
|
SoInnocentIAm... wrote: PrintDocument1_PrintPage CODE contains simple drawing methods.
Print works fine but print preview displays nothing except small black dots in print preview area; that is each dot for each page.i have tried
InvalidatePreview() but it didn't help.
This is the code I was asking for, not the code behind the buttons.
|
|
|
|
|
Hello Dave!
I have tested my code on other machine it worked fine.
Problem was: my Visual Studio dll files were corrupted and i was facing all these problems. Now i am repairing Visual Studio.
Anyhow, Thankyou for your time.
Thanks.
colgateas900197
|
|
|
|
|
|
Without seeing your code that calls this service, it's pretty difficult to say what's wrong.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
any body