Re: get data from another form - Visual Basic Discussion Boards

Re: data report display type mismatch error and invalid data sourec

Dave Kreskowiak4-Dec-07 4:34

4-Dec-07 4:34

It would appear that your DSN is not valid in some way. Since you're using a DSN, and not a full connection string, it's impossible to tell you what's wrong with it.

A guide to posting questions on CodeProject[^]

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

Hi friends

kalyan3-Dec-07 19:40

kalyan

3-Dec-07 19:40

How can i write the ode for tab pages?means when i click the tab then the tab page will display,so what is the process?
Thanks,
Kalyan

Re: Hi friends

John_Adams4-Dec-07 2:50

John_Adams

4-Dec-07 2:50

Hi,

Please visit the following links, these links explain how you can code for TabPages and TabControl.

http://blogs.vbcity.com/xtab/archive/2007/06/25/8465.aspx[^]

http://blogs.vbcity.com/xtab/archive/2007/07/18/8508.aspx[^]

I hope this helps.

Regards,
John Adams
ComponentOne LLC

Convert String To DataGridViewCell

VB 8.03-Dec-07 19:22

VB 8.0

3-Dec-07 19:22

I need to convert a string to a DataGridViewCell. I tried " CType(StringHere, DataGridViewCell) " but that does not work. If anybody know anything about this, please reply as this is extremely urgent. Thanks!

Re: Convert String To DataGridViewCell

Dave Kreskowiak4-Dec-07 4:11

Dave Kreskowiak

4-Dec-07 4:11

Noone cares how "urgent" it is. We get to answering posts in our own time, whenever we get the chance. This is an all volunteer effort. Besides, what makes you think your problem, that you want answered for FREE, is any more important that any other problem he on the boards?

To answer your question - you can't do that. It's impossible to convert a string to an object. What are you trying to do with this?

A guide to posting questions on CodeProject[^]

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

get data from another form

Travis James3-Dec-07 17:33

Travis James

3-Dec-07 17:33

I am trying to get text from a textbox in one form and post it to a Label in another form.

So far I have:

Public Class properties
Dim temForm1 As Form1

Private Sub properties_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label8.Text = temForm1.tbFilename.Text
End Sub
End Class

The code checks out until you run the application and then it comes up with some type of error.
Can anyone tell me how to solve this problem and get the text from my textbox in Form1 to the label in my Properties form?

Thanks in Advanced!

Re: get data from another form

ReactiveX3-Dec-07 17:49

ReactiveX

3-Dec-07 17:49

It's a bit difficult to diagnose the problem without an error, but the only thing i can think of is that your form's instance hasn't been instantiated properly.

Try the following:

---- Main form click event:

Dim frm2 As New Form1()
frm2.Show()
Label8.Text = frm2.tbFilename.Text
frm2.Close()

If that doesn't work, then you're doing something else wrong that you haven't specified.

Daniel Minnaar
.NET Solutions Architect

Re: get data from another form

Travis James3-Dec-07 18:17

Travis James

3-Dec-07 18:17

i need the text in the textbox, which is in form1, to load into the label, which is in the properties form, when the properties form is opened from a menustrip.

Re: get data from another form

Mycroft Holmes3-Dec-07 18:51

Mycroft Holmes

3-Dec-07 18:51

You need to pass the value of the textbox to the new form when you instantiate it
oFrm = New frmSource(Text1.text)

Then in the sub new on the form you put the text into the label

	Sub New(ByVal sText As String)<br />
<br />
		' This call is required by the Windows Form Designer.<br />
		InitializeComponent()<br />
<br />
		' Add any initialization after the InitializeComponent() call.<br />
		Label1.text = sText<br />
	End Sub

Quote from Great Outdoors:
its a confident traveller who farts in India

Re: get data from another form

Christian Graus3-Dec-07 19:39

Christian Graus

3-Dec-07 19:39

Wow - I spent two hours fighting bad internet and you're still not got a good answer

Member 3694999 wrote:
it comes up with some type of error.

This is ridiculous. IF you want help, tell us the error message.

Member 3694999 wrote:
im temForm1 As Form1

This may work, IF you set this to be the form1 instance that is visible on your screen. If not, it's a waste of time, and my guess is you got a null reference because you gave it no value at all

What you need to do is read the article on this site on passing values between forms, especially the section on delegates. Use delegates always to pass values between forms. Every other way is a hack

Christian Graus - Microsoft MVP - C++

"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 )

Rapidshare Downloader - Where To Start

j_foulkes3-Dec-07 14:41

j_foulkes

3-Dec-07 14:41

Hi,

There was a topic posted last week about this same problem, but I think mine is a bit more specific.

Now, I want to get files from rapidshare using my premium account, however haven't the first clue where to start. There are plenty of articles on the web about how to download binary files over http, but its the requesting data from rapidshare and providing the login credentials that I can't find anything on. I *think* I need to use NetworkCredential, but again, haven't a clue where to start with this one.

If anyone could give me any pointers or send me in the right direction it would be much appreciated.

Thanks.

John.

Stop Word date fields from auto updating

atregent3-Dec-07 13:49

atregent

3-Dec-07 13:49

I'm writing an application that manipulates various office documents, but am having trouble with Fields containting dates that automatically update.

All my efforts so far are too late in the process. As soon as I perform a wrd.Document.Open(filename), the fields have updated.

Is there a way to open a word document and unlink, or lock, the fields before they update?
Cheers,
Anthony

Re: Stop Word date fields from auto updating

Dave Kreskowiak4-Dec-07 4:37

Dave Kreskowiak

4-Dec-07 4:37

atregent wrote:
Is there a way to open a word document and unlink, or lock, the fields before they update?

This question is geared more towards a Word-centric forum than VB.NET. AFAIK, there's no way to stop the field from updating, but I could be wrong.

A guide to posting questions on CodeProject[^]

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

ruler in crystal report

jhyn3-Dec-07 13:37

jhyn

3-Dec-07 13:37

how can i change the ruler measurement in vb.net 2003 crystal report???
thank you in advance!!!

jyn

Using TableAdapters

AAGTHosting3-Dec-07 11:04

AAGTHosting

3-Dec-07 11:04

Do I have to Import any namespaces when I set up a TableAdapter and/or DataTable?.

I am having a problem, where if I drag and drop a Table Adapter to the form then if I do anything at all the form shows errors. The errors are in designer generated code that I did not change. I am wondering about something else. If this is not as simple as just importing the right namespace or class, then it might be because I started this program in Visual Basic 2003. Then I let Visual Basic 2005 do programatic changes to it, so that it would work with VB 2005.

This does not happen when I remove the TableAdapter. I downloaded 2008, but am not sure if I want to use it yet. There has got to be some bugs.

Is there another way to do this?

Re: Using TableAdapters

ReactiveX3-Dec-07 17:52

ReactiveX

3-Dec-07 17:52

The DataTable class lives inside a namespace of System.Data

Try creating an untyped DataTable in code manually to see if it recognizes the object successfully without errors. If it does, then the problem lies elsewhere...

Daniel Minnaar
.NET Solutions Architect

get column names

Cory Kimble3-Dec-07 10:48

Cory Kimble

3-Dec-07 10:48

I need to know how to get the column names of a database. I want to offer my users the ability to choose a database from a list of databases and then have them select what columns they want. I want to know how to get the column names and store them in a combobox. Does anyone know how to do this or where I can find an article? Thank you.

Re: get column names

atregent3-Dec-07 13:54

atregent

3-Dec-07 13:54

This is from something I wrote a while back for checking the structure of an Access table, it might be of some help to point you in the right direction:

Dim tblExport As DataTable<br />
Dim TableName as string = "tblTest"<br />
tblExport = TestConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, TableName, "TABLE"})

Re: get column names

ReactiveX3-Dec-07 18:02

ReactiveX

3-Dec-07 18:02

The Microsoft SQL Server equivalent is:

SELECT syscolumns.name
FROM syscolumns INNER JOIN sysobjects ON syscolumns.id = sysobjects.id
WHERE sysobjects.name = ''

Daniel Minnaar
.NET Solutions Architect

A question about SMTP

Member 19965433-Dec-07 5:40

Member 1996543

3-Dec-07 5:40

Unless specific server takes the default,
That specified in the settings of your computer?
Fulvio

Re: A question about SMTP

Dave Kreskowiak3-Dec-07 12:18

Dave Kreskowiak

3-Dec-07 12:18

Member 1996543 wrote:
Unless specific server takes the default,
That specified in the settings of your computer?

Uhhh... what? Your question makes no sense and there isn't enough information to even guess at what you're trying to get at.

A guide to posting questions on CodeProject[^]

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

Re: A question about SMTP

ReactiveX3-Dec-07 18:03

ReactiveX

3-Dec-07 18:03

But that was an excellent answer anyway Dave Smile | :)

Daniel Minnaar
.NET Solutions Architect

set .net application at windows login

satyadeva1-Dec-07 17:57

satyadeva

1-Dec-07 17:57

when the windows logon comes i should show my application before coming desktop how Confused | :confused:

Re: set .net application at windows login

Christian Graus1-Dec-07 22:22

Christian Graus

1-Dec-07 22:22

You can't show it 'before' the desktop. You can run it on startup, many different ways.

Microsoft VBScript compilation (0x800A03F6)

Paul McGann1-Dec-07 9:29

Paul McGann

1-Dec-07 9:29

I have the following If statement

bmi = weight/(height * height)

If bmi < 18.5 then
Response.Write("Your underweight")
Else If bmi >= 18.5 And bmi <= 24.9 then
Response.Write("Your normal")
Else If bmi >=25 And bmi <=29.9 then
Response.Write("Your overweight")
Else
Response.Write("Your obese")
End If

But keep getting this error:
Microsoft VBScript compilation (0x800A03F6)
Expected 'End'

I know that this means that it is expecting the if statement to end which when i look at it it is closed. I'm new to programming and sleep depravation is probably causing me to over look the minor detail. If any one can spot where i'm goin wrong it's much appreciated.

Thanks

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