Visual Basic

17-Jan-09 15:55

Hi,

I am trying to use the Fill() method of dataAdapter class to fill a dataset but Im getting a SqlException error when I run my code. The error says Invalid object name 'Testing'. My database name is Runner.mdf and Testing is a table in my database. Heres my code. Hope someone can help. Thanks

Dim ds As New DataSet
Dim cn As New SqlConnection()
Dim connString As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents\Runner.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

cn.ConnectionString = connString
cn.Open()

Dim da As New SqlDataAdapter("SELECT * FROM Testing", cn)

da.Fill(ds)

N a v a n e e t h17-Jan-09 16:33

N a v a n e e t h

17-Jan-09 16:33

carrigart wrote:
SELECT * FROM Testing

Is this query executing successfully in query browser?

Navaneeth

How to use google | Ask smart questions

carrigart17-Jan-09 17:18

17-Jan-09 17:18

How do you use the query browser. Is that the same as the object browser.
I'm not familiar with both of them anyway

carrigart17-Jan-09 19:42

17-Jan-09 19:42

Yeah I figured out how to use the query browser and my query is working fine. It returns the contents of my database. Still getting the same error, so frustrating. Confused | :confused:

carrigart17-Jan-09 19:56

17-Jan-09 19:56

and one more thing, the code executes fine when I comment out the line da.Fill(ds), So is there something wrong with my dataset.

Wendelius17-Jan-09 21:33

17-Jan-09 21:33

Do you have the database (runner.mdf) included in your project? If you do, select it from the project explorer and from properties, check two things:
- path to the file
- is Copy to output directory true

If copy to output directory is true, you should attach the database from the projects debug/bin folder, since each time you start the project the db is copied to that folder. Also note that in this case, all modifications done by program are not reflected to the original database, which is included to the project.

The need to optimize rises from a bad design.My articles[^]

carrigart17-Jan-09 22:45

17-Jan-09 22:45

Yes the database is included in my project. I have checked the properties and the 'Copy to output directory' is set to 'Copy Always'. I'm not sure that I get you. Is it that the Path to the file should be the file in the debug/bin folder. So would I have to change and connection string and setup a new data source. Bit confused sorry

Wendelius17-Jan-09 22:53

17-Jan-09 22:53

carrigart wrote:
would I have to change and connection string and setup a new data source

Yes, exactly, you should modify the connection string and attach the mdf from your projects debug/bin folder. You don't have to create a new datasource, just modify the connection string.

carrigart wrote:
Bit confused sorry

Nothing to be sorry about Smile | :)

The need to optimize rises from a bad design.My articles[^]

carrigart18-Jan-09 1:34

18-Jan-09 1:34

Fixed it

. Only took me like a day D'Oh! | :doh:

. I changed the path off my connection string. Bit of a school boy error D'Oh! | :doh:

. Well its a lesson learnt anyway.
Thanks for your help

Wendelius18-Jan-09 1:47

18-Jan-09 1:47

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

How to always keep focus on a textbox?

TheComputerMan18-Jan-09 12:26

TheComputerMan

18-Jan-09 12:26

This may sound daft, but have you tried it by populating a command and then setting the dataadapter.selectcommand to the command?

VB web browser

ragual17-Jan-09 15:50

ragual

17-Jan-09 15:50

Hey gang I got a web browser that I am creating for a group that I belong to. The question is I have everything set up they way it should look. The only thing missing is the ability to block pop ups when debug before I make it a finale cut for distribution. This is my first attempt I got some help form a friend form a different forum but he is stumped as well. I hope some one can point me in to the right direction.

Re: VB web browser

Saul Johnson18-Jan-09 6:42

Saul Johnson

18-Jan-09 6:42

Hi!

Are you using the .NET webbrowser control? I ask because the features it provides are quite limited so implementing a pop-up blocker from it would be next to impossible. You may want to look into CSEXWB It provides a far richer set of features than the standard control and, though it's written in C#, can easily be added to your VB project.

Hope This Helps!

MrWolfy Big Grin | :-D

Re: VB web browser

ragual18-Jan-09 7:31

ragual

18-Jan-09 7:31

Yes it is in .Net I see your point is there a tool kit that I can download? And if so could you send me the link?

Re: VB web browser

Saul Johnson24-Jan-09 10:45

Saul Johnson

24-Jan-09 10:45

Hi!

Sorry for the late reply. There was a link to CSEXWB in my last post, and with web browser controls being insanely complicated under the hood (Loads of C++ and stuff) they are very difficult to manipulate from VB.

This is basically why CSEXWB was created, it exposes several underlying events, methods and properties that you could not normally access from VB.

Hope This Helps!

MrWolfy Big Grin | :-D

xbiplav17-Jan-09 10:50

xbiplav

17-Jan-09 10:50

I have a windows form which has several controls like buttons, listviews, labels and a textbox.
Is there any generic way to always keep focus on that textbox?

Re: How to always keep focus on a textbox?

Christian Graus17-Jan-09 11:33

Christian Graus

17-Jan-09 11:33

Wow - let's see. You have buttons and listviews, and you never want any of them to get the focus ? how would that work ?

I guess you could catch keypresses and always respond by focusing on the textbox.

Christian Graus

Driven to the arms of OSX by Vista.

Re: How to always keep focus on a textbox?

xbiplav17-Jan-09 11:38

xbiplav

17-Jan-09 11:38

What my point is here. As soon as other control's work is done, then the textbox should be focus.
I dont want to put textbox1.focus in every control's lostfocus event. I hope you understand me.

Thanks!

Re: How to always keep focus on a textbox?

Colin Angus Mackay17-Jan-09 11:42

Colin Angus Mackay

17-Jan-09 11:42

xbiplav wrote:
As soon as other control's work is done, then the textbox should be focus.

Then set is back to being focused. Control.Focus() method[^]

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

mobile conectivity

vish143317-Jan-09 6:09

vish1433

17-Jan-09 6:09

I WANT VB.NET CODE FOR MAKING PROJECT ......

MY PROJECT IS CONECTIVITY OF MOBILE AND COMPUTER TO SEND SMS AND MAKE CALL WITH USE OF COMPUTER.....

SO GIVE ME ADVICE ..... AND ALSO SEND CODE FOR THIS PROJECT.....

THANKYOU...

Re: mobile conectivity

Wendelius17-Jan-09 6:31