Re: Error MSG box - Visual Basic Discussion Boards

nlindley720-Sep-06 4:28

20-Sep-06 4:28

I am trying to use the built-in .NET Binding Navigator and am having some issues. I use a dataset for the Binding Source's Data Source and when I fire the program the icons on the navigator are disabled. The count also says only 1 when there are 3 records in the DB. This part of the project is just displaying user details that are retrieved from a Sql Server DB. Let me know if this is too general of a description.

UPDATE:
I am now having a problem connecting to the DB, getting a SQLException Unhandled : 'login failed for user (user)' . The connection string it uses is the same as another currently working DataAdapter. I can preview the data from the TableAdapter so I know the connection is working. Any ideas?

TIA

Big Pimpin, Spendin Gs
Nate Lindley, .NET Aficionado

how to connect mysql database to vb.net 5

POIKAYIL20-Sep-06 4:06

POIKAYIL

20-Sep-06 4:06

I am a amateur programmer.just to jumbed into the pool only with interest.I have experience in database progrmming in mysql and vb6.I have no formal software education as I am a Government officer.
so please help
how can i connect MYSQL DATABASE TO VB.NET 2005.

I USE THE FOLLOWING CODE IN VB6

Public cnn as new ADODB.CONNECTION
Public str as string
sub main()
str= "Provider=MSDASQL.1;Persist Security Info=False;Data Source=revive"
cnn.connectionstring=str
cnn.open

This will connect mysql database to vb6

Pleae help me

with regards

JOSEPH

Re: how to connect mysql database to vb.net 5

Dave Kreskowiak20-Sep-06 5:49

Dave Kreskowiak

20-Sep-06 5:49

Try checking this[^] site out.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Sql server ip Using vb.net

GabrielVarun20-Sep-06 3:51

GabrielVarun

20-Sep-06 3:51

Can any body tell me how to get a server ip address in a textbox.
I have sqlserver 2000 in my lan and i am using vb.net 2003.
Please help me

Cannot connect to smtp server error !

Coding C#20-Sep-06 3:37

Coding C#

20-Sep-06 3:37

Hi programmers,

i get the cannot connect to smtp server error when i try to send mail through mail from my vb application.

i used aspsmartmail componet for this.
the mails goes correctly when i use normal outlook express or my domain account through internet explorer but gives error when i send it through my code.

i am giving the code snippet which sends mails. sorry i cant give full details of my mail server and email account in code snippet plz consider for this.

plz help me guys.

Dim mySmartMail As aspSmartMail.SmartMail<br />
    Set mySmartMail = New aspSmartMail.SmartMail<br />
<br />
    mySmartMail.Server = "ip address of mail server"<br />
    mySmartMail.ServerTimeOut = 35<br />
    mySmartMail.UserName = "username"<br />
    mySmartMail.Password = "password"<br />
<br />
    mySmartMail.SenderAddress = "test@mydomain.com" <br />
    <br />
<br />
     mySmartMail.Recipients.Add "nitin@mydomain.com"<br />
<br />
    mySmartMail.Subject = "my mail"<br />
    mySmartMail.Body = "body"<br />
<br />
    mySmartMail.SendMail<br />
<br />
    Set mySmartMail = Nothing<br />
    <br />

Help!
Nitin...

Re: Cannot connect to smtp server error !

Dave Kreskowiak20-Sep-06 5:54

Dave Kreskowiak

20-Sep-06 5:54

Well, you'll most likely have to get with the people that wrote that component. If you purchased it, then you have at least 1 FREE support incident, otherwise it's $159/incident.

If the IP works in Outlook, the exact same server name/IP should work in this component. If it's not, there might be some setting in this component that you have to set, but have so far failed to do so. I have no idea what that would be, since I've never used this component.

Another possibility is that you have the free version and it expires. If so, then you'll have to shovel out the money to get the full version.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Error MSG box

SavageZaing20-Sep-06 2:52

SavageZaing

20-Sep-06 2:52

With VS2003 in a webapplication.

I want to have a messagebox to pop up when a user fills data into a textbox and this data is invalid. spesifically : there is a field for filling in a price, I have a function that makes sure that the data is valid and in range. But I want to inform the user that the data is invalid. If tried using the msgbox(...) function but I take it that it cant be used in a webpage, in that way.

Is there a way to do this?

Re: Error MSG box

Coding C#20-Sep-06 3:23

Coding C#

20-Sep-06 3:23

Hi,

u ll have to use Javascript alert functiom

hope this works.

Nitin...

Re: Error MSG box

SavageZaing20-Sep-06 4:06

SavageZaing

20-Sep-06 4:06

Ok then if i may ask how do you call a javascript function (alert) from within VB code.???

Re: Error MSG box

Coding C#20-Sep-06 4:32

Coding C#

20-Sep-06 4:32

hi,

Response.Write("<script lang=""javascript"">alert('Nitin')</script>")

hope this works

Nitin..

Re: Error MSG box

Christian Graus20-Sep-06 11:57

Christian Graus

20-Sep-06 11:57

You really should use registerclientscriptblock to insert jscript. If I get you right, you're saying do a postback, if the values are outside the range, insert the script so that the posted back page shows a popup message ? It would be easier to use validation controls that generate teh script and run without postback.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Error MSG box

SavageZaing21-Sep-06 0:58

SavageZaing

21-Sep-06 0:58

Thank you very much!!! It works!!!!

Just one last question? I know I'm becoming annoying - hehe
Is there a way to preserve the items in the background?

My app is fairly mature so I hay have inadvertently changed something that cases this phenomenon

The MSGBOX displays but there is a completely blank page behind it until you click ok at which stage it returns to normal.

Thanx once again

Re: Error MSG box

Christian Graus20-Sep-06 11:55

Christian Graus

20-Sep-06 11:55

What you want to do is use a validation control, this can generate the javascript to check the values on the client, and pop up a message box. You need to also check on the server, if there's a chance your client page could be hacked.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

i need to open a word file which contain some formated text and images,tables

Batchu Rajesh20-Sep-06 2:03

Batchu Rajesh

20-Sep-06 2:03

in my vb.net project
i have a requirement to open a word file which contain formated text ,tables,images

i can open it in a rich text box or pannel or in any way but the area allocated to me half the screen onely
i dont know how to open it in
vb.net
can any one help me

mail me at rajesh.batchu@cesltd.com

DataGridView Column Type

Maira K20-Sep-06 1:59

Maira K

20-Sep-06 1:59

hi,
I want to know if there is a way to change the type of a Column in DatagridView at run time. And if so, how?

Thanks in advance

Re: DataGridView Column Type

Dave Kreskowiak20-Sep-06 6:01

Dave Kreskowiak

20-Sep-06 6:01

Once the column is created, you cannot change it's type. You have to remove the column(s), then create your own and add them to the Columns collection. It would probably be a good idea to create your own columns for each column you want to display:

    Private Sub SetupDGVAndBind()
        DataGridView1.Columns.Clear()
 
        Dim col As New DataGridViewTextBoxColumn
        col.HeaderText = "headerText"
        col.DataPropertyName = "columnName in table"
        DataGridView1.Columns.Add(col)
 
        DataGridView1.DataSource = myBindingSource
    End Sub

Dave Kreskowiak
Microsoft MVP - Visual Basic

Tricky!! VB.NET counterpart of CLSIDFromProgID and CoCreateInstance

Stephan Pilz20-Sep-06 1:55

Stephan Pilz

20-Sep-06 1:55

Hello,

I have some (more than once) COM-Servers (in different DLL's) and each of them implements the same Interface. Only what I know is the InterfaceName and the ProgID of the COM-Server.

How can I instanciate a COM-Object in VB.NET with this informations? I C/C++ it looks like:

HRESULT hr = CLSIDFromProgID (ProgID), &clsid);
hr = CoCreateInstance (clsid, NULL, CLSCTX_INPROC_SERVER, IID_IInterfaceName, (void **) &m_pCOMSmartPtr);

                   \\\|///
                 \\  - -  //
                  (  @ @  )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz   stephan.pilz@stephan-pilz.de |
|                <a href=www.stephan-pilz.de>www.stephan-pilz.de</a>          |
|                ICQ#: 127823481              |
+-----------------------Oooo------------------+
                 oooO   (   )
                (   )    ) /
                 \ (    (_/
                  \_)

Re: Tricky!! VB.NET counterpart of CLSIDFromProgID and CoCreateInstance

Dave Kreskowiak20-Sep-06 5:38

Dave Kreskowiak

20-Sep-06 5:38

Does something like this work for you?

Dim t As Type = Type.GetTypeFromProgID("progID")
Dim retVal As Object
retVal = Activator.CreateInstance(t)

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Tricky!! VB.NET counterpart of CLSIDFromProgID and CoCreateInstance

Stephan Pilz20-Sep-06 20:57

Stephan Pilz

20-Sep-06 20:57

Hello Dave,

Yes this works fine. Thank you.

Regards
Stephan

                   \\\|///
                 \\  - -  //
                  (  @ @  )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz   stephan.pilz@stephan-pilz.de |
|                <a href=www.stephan-pilz.de>www.stephan-pilz.de</a>          |
|                ICQ#: 127823481              |
+-----------------------Oooo------------------+
                 oooO   (   )
                (   )    ) /
                 \ (    (_/
                  \_)

Re: Tricky!! VB.NET counterpart of CLSIDFromProgID and CoCreateInstance

Dave Kreskowiak21-Sep-06 3:24

Dave Kreskowiak

21-Sep-06 3:24

No problem! Big Grin | :-D

Dave Kreskowiak
Microsoft MVP - Visual Basic

i convert my project in atm in vb.net but i am having error!!

Brian Jay20-Sep-06 1:48

Brian Jay

20-Sep-06 1:48

i convert my project atm in vb6 to vb.net but i am having error... app error! can someone help me???

asa

Re: i convert my project in atm in vb.net but i am having error!!

Dave Kreskowiak20-Sep-06 2:27

Dave Kreskowiak

20-Sep-06 2:27

Would you care to explain what the problem is, or should we just guess?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: i convert my project in atm in vb.net but i am having error!!

Christian Graus20-Sep-06 11:59

Christian Graus

20-Sep-06 11:59

As Dave said, we can't guess your problem if you won't tell us. VB.NET is very different to VB6 and the upgrade wizard is not perfect, it's no surprise you have errors.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Printer + WMI + GetJob API

K ^edar V20-Sep-06 0:41

K ^edar V

20-Sep-06 0:41

With reference to my this post ....

http://www.codeproject.com/script/comments/forums.asp?msg=1676656&forumid=1646&mode=all&userid=2124480#xx1676656xx

can any one help me out with GETJOB API ??

"hay Dave is it you again answering this??" Wink | ;)

"You can do any thing you set to your mind" - theGhost_k8

Re: Printer + WMI + GetJob API

Dave Kreskowiak20-Sep-06 2:25

Dave Kreskowiak

20-Sep-06 2:25

The code you already have will work, so long as the machines are patched up to current levels...

Visit http://update.microsoft.com[^]. I can't make it any clearer than that.

Dave Kreskowiak
Microsoft MVP - Visual Basic

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