Visual Basic

8-May-07 21:06

Hi to all
I have a problem with database in vb.net using sqlexpress.

My problem is:
I have created a.mdf database file and tables in it, and written code for inserting data to this table through command object. But my real prob is when i supply the connection string which is created by the "data configuration wizard" to this cmd object then on runtime insert executes and also datais visible in datagridview but when i check the data in the table it is not there and all fields are NULL. given connection string.
("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\LIB.mdf;Integrated Security=True;User Instance=True")

But on the otherhand if i give connection string as ::
"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\LIB\LIB\LIB.mdf;Integrated Security=True;User Instance=True"

then data is successfully inserted in the database and i m also able to view it in my database table.

So if Any one can help me it will be highly appreciable.

Thanks.

P P Vilsad8-May-07 21:32

8-May-07 21:32

change the path to Application.startuppath & "\databasename" and try

Vilsad P P
MCTS (Windows Applications) .Net 2.0

hbk_leo9-May-07 3:18

9-May-07 3:18

hi thks for your reply.
I ttied it but it did not worked.
Please can u give it with an example o how to declare it.

Thanks Smile | :)

P P Vilsad9-May-07 4:18

9-May-07 4:18

try this

<br />
dim constring as string = "Data Source=.\SQLEXPRESS;AttachDbFilename=" & application.startuppath & "\LIB.mdf;Integrated Security=True;User Instance=True"<br />

connect with this string

Note : after exiting application you need to click on server explorer and right click lib.mdf database and click on close connection and copy lib.mdf and lib.log files from debug folder to back to lib folder. otherwise you will not get the changes and the file will be overwritten with the old one when you are running your application again

Vilsad P P
MCTS (Windows Applications) .Net 2.0

hbk_leo9-May-07 8:44

9-May-07 8:44

Hi When i try the constring u suggested i am getting another error at the point of cn.open, the error is as :

DriveLetter:\Project Folder\bin\Debug\LIB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

what is this error about i cant understand.

Dave Kreskowiak9-May-07 9:27

9-May-07 9:27

Either that path doesn't exist or Sql Server already has that database attached. Use the SQL Server Management Studio to see if it's listed under the Databases folder in the Object Explorer.

A guide to posting questions on CodeProject[^]

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

hbk_leo9-May-07 19:24

9-May-07 19:24

Hi thx for reply.
as u suggested i serched it in sql server mgmt studio under databases but it is not listed there.

P P Vilsad9-May-07 17:51

9-May-07 17:51

just add msgbox(constring) in my previous code after constructing constring. and run the application. varify that the message you are getting is pointing to the exact location of your database

Vilsad P P
MCTS (Windows Applications) .Net 2.0

hbk_leo9-May-07 19:28

9-May-07 19:28

I tried this and also got the database path correct but still i m getting the same error msg about auto-named and UNC share.

P P Vilsad10-May-07 16:54

10-May-07 16:54

what is exactly you are getting about autonamed and unc shares ?

the error you are getting about the database name already exist is because it is already attached to sqlserver. if you have connected your database in server explorer, try to detach it and run this program error, i am not getting this error when i tried here. if this problem still exist after you detach db try after installing visual studio sp1

Vilsad P P
MCTS (Windows Applications) .Net 2.0

Dave Kreskowiak9-May-07 4:38

9-May-07 4:38

The |DataDirectory| portion of the AttachDbFilename path is only usable if your database file is in either the Data folder of the SQL Server Program Files folder or when using ClickOnce Deployment - I can't remember which.

You have to replace this with the full path to your database .MDF file for the connection string to work. If your database is in your applications .EXE folder, you can do something like this to get it work:

Dim dbPath As String = Path.Combine(Application.StartupPath, "mydatabase.mdf")
Dim connString As String = String.Format("Data Source=.\SQLEXPRESS;AttachDbFilename={0};Integrated Security=True;User Instance=True", dbPath)

A guide to posting questions on CodeProject[^]

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

hbk_leo9-May-07 8:00

9-May-07 8:00

hi Thxs for u r reply.
Can u plz tell what is the key word "Path.combine"
because when i m writing the string u told about a message is displayed "Path" is not declared .
So let me know ,do i have to import some namespace or what should i do.

Regards

Dave Kreskowiak9-May-07 9:25

9-May-07 9:25

The Path class is defined in the System.Io namespace.

Stick this at the top of your code:

Imports System.Io

A guide to posting questions on CodeProject[^]

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

hbk_leo9-May-07 19:31

Insert data to word template

9-May-07 19:31

Hi by including IO class the error was removed but now i m getting this

error at the point of cn.open, the error is as :

DriveLetter:\Project Folder\bin\Debug\LIB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

what is this error about i cant understand.

Jats_4ru8-May-07 20:18

Jats_4ru

8-May-07 20:18

Hi,

I have a need to send some data from database to a word template.
Do any body have any idea about it.

Example: If i have a word file as certificate.doc (with images and text)
and at particular occurance of a word as <name> the text has to change with the data in the database table.

Any help... plz

Jats

Re: Insert data to word template

Dave Kreskowiak9-May-07 4:32

Re: Insert data to word template

9-May-07 4:32

You would probably have better luck getting this question answered if you asked in a forum that specialized in Word Interop, like this one[^] on MSDN.

A guide to posting questions on CodeProject[^]

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

Jats_4ru9-May-07 22:55

Jats_4ru

9-May-07 22:55

Hi,
Thanks for the suggestion found a way.

Jats

VB communication problem

Mr ericsson8-May-07 19:29

Mr ericsson

8-May-07 19:29

Hi to all.
I am Having Some difficult to grabe from serial port (VB Communication) and to save data in an access database.
if someone could help me in this topic,by a simple example or a source code in VB6.
Thanks in advance Smile | :)

Re: VB communication problem

Dave Kreskowiak9-May-07 4:30

HowTO: Packet Capture / Redirect URL

9-May-07 4:30

There's tons of examples out on the web. All you have to do is Google for "vb6 serial port", or click[^].

A guide to posting questions on CodeProject[^]

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

Sunil KC8-May-07 19:15

Sunil KC

8-May-07 19:15

Hi All,
I want to capture incoming / outgoing raw-packet of NIC card.

And redirect/block packet for porn site etc.

I am VB6 coder and have no idea for C/C++.

Can somebody help me in this regards.

Sunil KC
from NEPAL

Re: HowTO: Packet Capture / Redirect URL

Colin Angus Mackay8-May-07 23:47

Colin Angus Mackay

8-May-07 23:47

Sunil KC wrote:
I want to capture incoming / outgoing raw-packet of NIC card.

And redirect/block packet for porn site etc.

I am VB6 coder and have no idea for C/C++.

Can somebody help me in this regards.

Well, time to start learning C, because to do this you'll need to write an NDIS driver and you can only do that in C or C++. Well, you can also do that in assembly, but I guess you won't want to do that.

Upcoming events:
* Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: HowTO: Packet Capture / Redirect URL

Sunil KC9-May-07 0:50

Sunil KC

9-May-07 0:50

can somebody help me by making a ndis driver with dll

Re: HowTO: Packet Capture / Redirect URL

Dave Kreskowiak9-May-07 4:25