Visual Basic Discussion Boards

how to initialize a database connection for the target computer?

crookshanks25-Mar-08 17:47

25-Mar-08 17:47

hi everyone!!

i have a huge problem and i've been working out this one for a long time now. i need your help.. Confused | :confused:

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!!! Wink | ;)

crookshanks

Re: how to initialize a database connection for the target computer?

Christian Graus25-Mar-08 18:48

Christian Graus

25-Mar-08 18:48

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 )

Re: how to initialize a database connection for the target computer?

crookshanks25-Mar-08 19:05

crookshanks

25-Mar-08 19:05

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

Re: how to initialize a database connection for the target computer?

Christian Graus25-Mar-08 19:08

Christian Graus

25-Mar-08 19:08

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.

Re: how to initialize a database connection for the target computer?

crookshanks25-Mar-08 19:40

crookshanks

25-Mar-08 19:40

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

Re: how to initialize a database connection for the target computer?

N a v a n e e t h25-Mar-08 19:45

N a v a n e e t h

25-Mar-08 19:45

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: how to initialize a database connection for the target computer?

crookshanks25-Mar-08 20:29

crookshanks

25-Mar-08 20:29

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

Re: how to initialize a database connection for the target computer?

Christian Graus25-Mar-08 20:30

Christian Graus

25-Mar-08 20:30

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

How to add button in window form datagrid

Eunice (VB junior)25-Mar-08 16:49

Eunice (VB junior)

25-Mar-08 16:49

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

Re: How to add button in window form datagrid

Dave Kreskowiak26-Mar-08 6:50

Dave Kreskowiak

26-Mar-08 6:50

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[^]".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: How to add button in window form datagrid

Eunice (VB junior)26-Mar-08 14:08

Eunice (VB junior)

26-Mar-08 14:08

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.

FYI: Crystal Reports 2008 integration with Visual Studio 2008

Steven J Jowett25-Mar-08 7:53

Steven J Jowett

25-Mar-08 7:53

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 !

Check for newest file

AHeavey25-Mar-08 7:11

AHeavey

25-Mar-08 7:11

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

Re: Check for newest file

Steven J Jowett25-Mar-08 7:57

Steven J Jowett

25-Mar-08 7:57

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)

Re: Check for newest file

Vimalsoft(Pty) Ltd25-Mar-08 10:47

Vimalsoft(Pty) Ltd

25-Mar-08 10:47

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

Re: Check for newest file

N a v a n e e t h25-Mar-08 19:48

N a v a n e e t h

25-Mar-08 19:48

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Check for newest file [modified]

AHeavey26-Mar-08 1:52

AHeavey

26-Mar-08 1:52

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

Re: Check for newest file

N a v a n e e t h26-Mar-08 4:39

N a v a n e e t h

26-Mar-08 4:39

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

PrintPreviewDialog control is creating problems!

BooleanTrue25-Mar-08 2:47

BooleanTrue

25-Mar-08 2:47

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

Re: PrintPreviewDialog control is creating problems!

Dave Kreskowiak25-Mar-08 4:04

Dave Kreskowiak

25-Mar-08 4:04

What does the code look like that's doing the rendering of both the printed page and the print preview??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: PrintPreviewDialog control is creating problems!

BooleanTrue25-Mar-08 4:22

BooleanTrue

25-Mar-08 4:22

Thanks for your reply!

PRINT BUTTON CODE:

Try<br />
            PrintDocument1.Print()<br />
        Catch ex As Exception<br />
            MessageBox.Show("An error occurred while printing" &amp; vbCrLf &amp; 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

Re: PrintPreviewDialog control is creating problems!

Dave Kreskowiak25-Mar-08 4:50

Dave Kreskowiak

25-Mar-08 4:50

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: PrintPreviewDialog control is creating problems!

BooleanTrue25-Mar-08 6:14

BooleanTrue

25-Mar-08 6:14

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

How to call Java Web Services (wsdl) in .net

C.Shivashankar25-Mar-08 1:43

C.Shivashankar

25-Mar-08 1:43

Hi can anybody help me,
am calling some web service which is developed in java
I have added web reference it is doing god but when I call any function of any class in service am getting error

The request failed with HTTP status 401: Unauthorized. <br />
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <br />
<br />
Exception Details: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.<br />
<br />
Source Error: <br />
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. <br />
<br />
Stack Trace: <br />
<br />
[WebException: The request failed with HTTP status 401: Unauthorized.]<br />
   System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +551137<br />
   System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +204<br />
   com.rephero.billing.WebServicesSessionLocalService.getUserId(String in0) +79<br />
   JBillingWebReff.Page_Load(Object sender, EventArgs e) +47<br />
   System.Web.UI.Control.OnLoad(EventArgs e) +99<br />
   System.Web.UI.Control.LoadRecursive() +47<br />
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436<br />
<br />
________________________________________<br />
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

The username and password is given correct what the problem Confused | :confused:

Please help me Smile | :)

any body

The Value Has Its Value Only Its Value Is Valied

Re: How to call Java Web Services (wsdl) in .net

Dave Kreskowiak25-Mar-08 4:01

Dave Kreskowiak

25-Mar-08 4:01

Without seeing your code that calls this service, it's pretty difficult to say what's wrong.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.