Visual Basic Discussion Boards

Re: How can I add multiple new row into datagrid ?

Eunice (VB junior)25-Dec-07 20:11

25-Dec-07 20:11

Hi CKnig,

Can you advice me how should i write the code if i want to save the data from datagrid to database?
eg: Let's say i had 'Add' 10 rows. I want to add these 10 rows into database. How should i do?
I have been searching for codes. But the result not what i want.
Can you pls help. Thanks in advanced.

Here is my codes that stuck half way:-

Dim strQuery1 As String

strQuery1 = "Insert into MMBarCode (HBarCode,EMIBarCode) values('" & DataTable.Rows(HBarCode) & "','" & DataTable.Rows(EMIBarCode) & "')"
myConnection.Open()
myCommand = New SqlCommand(strQuery1, myConnection)

Try
ra = myCommand.ExecuteNonQuery()
myConnection.Close()
Me.Close()

Catch ex As Exception
myConnection.Close()
MessageBox.Show(ex.Message)

End Try

Thanks, eunice

parameter search

BOREC18-Dec-07 22:37

BOREC

18-Dec-07 22:37

This is a SQL statement that is witten in Access for parameter search with wildcard

...
WHERE (((SLUŽBA.Priimek) Like "*" & [Search text] & "*"));

why doesn't it work in a Visual Basic Querry? I write the same expression in Function field and it doesn't work. Any suggestions?
Thanks.

Re: parameter search

CKnig18-Dec-07 23:36

CKnig

18-Dec-07 23:36

In SQL - sytax this becomse something like

WHERE (SLUŽBA.Priimek LIKE %[Search text]%)

(% <=> * and no &)

Re: parameter search

Christian Graus18-Dec-07 23:36

Christian Graus

18-Dec-07 23:36

Well, hard to understand what you mean by a 'Visual Basic Querry', but if you're building a string, you need to deal with how to represnt quotes for a start.

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 )

security issue

Tauseef A18-Dec-07 22:31

Tauseef A

18-Dec-07 22:31

hi guys

i am running dotnet 2 exe file from network but it doest not run on my system , it says something

security like exception, but if i make my intrantet setting from dotnet framework2 configuration to gullytrusted it runs fine, but in this way i will have to make this setting on individual system, how to i do avoid from this issue,is there any that dotnet bypass the security or we can run our exe on tuntime in the fully trusted zone, thanks in advance

hello

Re: security issue

CKnig18-Dec-07 23:39

CKnig

18-Dec-07 23:39

First: there is no workaround IN code (that's what CAS is for)

As you said yourself: you either have to put the folder in the trusted zone / put the assembly in there or get some company policies for this task. However you will need to set these settings on ever client.

Of course if you copy the exe to local disks - say with a batch file before starting ... Blush | :O

Do i need a close at the end of this code???

Support12318-Dec-07 22:19

Support123

18-Dec-07 22:19

Hi, I just want to know if it would be advised to put the following at the end of this code:

Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
				Set objOutFile = objFSO.OpenTextFile("\\jhbtest01\e$\SARS\Script\FileWithFilePath\FileNameFormA.txt", 2, True)<br />
				strLine = FileName<br />
				objOutFile.WriteLine strLine

Should i add this at the end:
objOutFile.Close AND is this the right way of doing the close section??? (it is working without it but i get error... so it works the first time round but fails second time round... without me seeing the error.)...

Oh yeah... this bit of code is in a javascript file that i call through VB.Net using the Shell()

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Re: Do i need a close at the end of this code???

Dave Kreskowiak19-Dec-07 4:06

Dave Kreskowiak

19-Dec-07 4:06

Support123 wrote:
Should i add this at the end:
objOutFile.Close

Yeah, that would probably be a good idea.

Support123 wrote:
it is working without it but i get error...

And that error would be ....??

Support123 wrote:
so it works the first time round but fails second time round...

This is probably because you didn't close the file and are trying to open it again.

Support123 wrote:
this bit of code is in a javascript file

No, it's not. This is code snippet you posted is VBScript.

A guide to posting questions on CodeProject[^]

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

Re: Do i need a close at the end of this code???

Support12320-Dec-07 4:15

Support123

20-Dec-07 4:15

Support123 wrote:
this bit of code is in a javascript file

No, it's not. This is code snippet you posted is VBScript.

sorry about that... i was thinking one thing and writing another. I had a java question too (i am working on a ssis project and asp.net project so i messed up the question).

i appologize and thank you for the info. I will add the objOutFile.Close() section to the VBSript. (i dont know what the error is exactly... it is not displaying anything of use... it is saying that i have issues in one of my script files (vb.net) in the ssis package but it is working fine through visual studio... Only a problem when it is ran through a job in sql, so i thought that maybe the VBScript needed to be tweeked a bit.)

I will test to see if it works.

Thank you for your time.

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Web Browser control on .net compact framework 2.0

Benny_Lava18-Dec-07 20:23

Benny_Lava

18-Dec-07 20:23

Hi,

I'm developing a network application for a windows CE 5.0 device.

I need to visit a certain http:// url to process a php script. I have tried using process.start but that doesn't work.

So i'm using a webBrowser control to do the job.
The device is hooked to a usb cable on activeSync sharing the PC's internet connection. The connection works. ( I tried tracert somesite.com and it returned 30 hops.)

I'm using this code:

Dim uri As New System.Uri("http://www.somesite.hr/subfolder/index.php")
WebBrowser.Navigate(uri)

This code is on a button's click event. ( it works the same way on .net framework 2.0 but not the compact)

I keep clicking, and the code executes but the web browser is empty, nothing happens.

Any ideas?

Thank you!

Re: Web Browser control on .net compact framework 2.0

Dave Kreskowiak19-Dec-07 4:09

Dave Kreskowiak

19-Dec-07 4:09

unix_master01 wrote:
( I tried tracert somesite.com and it returned 30 hops.)

30 hops?? The only way you should get that may hops to a web site is if you bounced the signal off of Mars and through NASA's Deep Space Communuications Network.

It would appear as though the packets are getting looped through the same set of hops, over and over again. This would indicated that there's something wrong with your network setup somewhere.

A guide to posting questions on CodeProject[^]

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

Help:

angelo0718-Dec-07 20:07

angelo07

18-Dec-07 20:07

Any one can help.? a i'm new in vb.net i have a problem to shutdown, rebot and display screenshot of certain computer in local group by intering ip their address. heres my problem..!

=>> A program that will ask the user to input an IP address and then capture the screenshot of the computer,restart,shutdown, the computer will the given IP address.

Hope Anyone can help me here.? Thanks and have a nice day..

God Bless....????? Smile | :)

Re: Help:

Christian Graus18-Dec-07 20:13

Christian Graus

18-Dec-07 20:13

IF you have a username and password, you can remote desktop to machines that support that, with an IP address. I don't know if it's possible through code.

Re: Help:

Vasudevan Deepak Kumar19-Dec-07 3:45

Vasudevan Deepak Kumar

19-Dec-07 3:45

Christian Graus wrote:
. I don't know if it's possible through code.

Actually there is a Microsoft provided utility called shutdown.exe (shutdown -i) invokes a 'Remote Shutdown Dialog'. But I am not sure whether that can be automated though.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Re: Help:

Vasudevan Deepak Kumar19-Dec-07 3:43

Vasudevan Deepak Kumar

19-Dec-07 3:43

angelo07 wrote:
=>> A program that will ask the user to input an IP address and then capture the screenshot of the computer,restart,shutdown, the computer will the given IP address.

Are you intending to make something like 'Remote Shutdown Dialog' which gets invoked using shutdown -i from Windows XP onwards?

Upload file

tellytub18-Dec-07 19:55

tellytub

18-Dec-07 19:55

Hi all,

I'm using VB.net and currently I want to do a depositary which allow people to upload file to it. I researched and found a lot of resources, which they did using ASP.NET

1) Can VB.net - Window Form create depositary (upload files (.doc, .txt ..), etc?) [i know asp.net is also like under vb.net group, but the codes are kinda different, some functions only work for one but not for the another]
2) If yes, how do I do it? (cos' ASP.net uses localhost, how about general VB.net - Window Form)? Where would the files be uploaded to?

I hope I'm not too vague. Any help is appreciated. Thanks in advance.

telly

Re: Upload file

Christian Graus18-Dec-07 20:15

Christian Graus

18-Dec-07 20:15

tellytub wrote:
Where would the files be uploaded to?

Good question. You can do it, if you have an FTP site set up to copy the files to.

Multilingal application

A.kalai18-Dec-07 19:53

A.kalai

18-Dec-07 19:53

hi,
i have a .net windows application that support multiple languages, if it is installed in a spanish system, in what languages will the exception messages will be generated (ex.message). what other issues we may face while deploying the application.
please share your experiance, feedback and comments on this post with me.
if any more clarification is needed pl let me know.
thank you,
kalai

Error Handler

nishkarsh_k18-Dec-07 18:49

nishkarsh_k

18-Dec-07 18:49

Hello every one

I am developing a application in VB 2005
I am using On Error Goto to handle errors.

Now my issue is that I want to handle different type of errors in a function separately.

That is like
Do some thing if the database connection is not there
Do some thing else if the data is not found

And so on

I am not able to identify the errors in that way.. I am able to displaying the error number and description provided by the error object.

Is there any way to find out or a list of error numbers available?

Re: Error Handler

MohammadAmiry18-Dec-07 19:16

MohammadAmiry

18-Dec-07 19:16

Why are you still using this totally abandoned way of error handling?!!!

Use Try...Catch instead:

<br />
Try<br />
  .<br />
  YourCodeHere<br />
  .<br />
Catch ex1 As DataException<br />
<br />
Catch ex2 As IOException<br />
<br />
Catch ex3 As Exception<br />
<br />
Finally<br />
 .<br />
 .<br />
 .<br />
End Try<br />

Re: Error Handler

Nilesh Hapse18-Dec-07 19:17

Nilesh Hapse

18-Dec-07 19:17

Why are you using On Error Goto when you have Try... Catch block in VB.NET??

Re: Error Handler

Christian Graus18-Dec-07 20:11

Christian Graus

18-Dec-07 20:11

So, in other words, you're not using the mechanism that allows you to do this, so you want to know why you can't do it ?

Anything that VB.NET gets from VB6 is almost certainly a disaster.

mon***z18-Dec-07 18:40

mon***z

18-Dec-07 18:40

i want to convert some code in vb to vb .net..and i dont know how it will be. the vb code is
Screen.MousePointer = 11
i want to write in vb.net.. how we will write this code in vb.net. or in c# .net

Re: hi

Ajay.k_Singh18-Dec-07 19:10

Ajay.k_Singh

18-Dec-07 19:10

You may change mouse cursor using cursor property of Form, such as –

Vb.Net-

Me.Cursor = Cursors.WaitCursor

C# -

this.Cursor = Cursors.WaitCursor;

I hope this helps Smile | :)

.

-Dave.

Dave Traister,
ComponentOne LLC.
www.componentone.com

Re: hi

MohammadAmiry18-Dec-07 19:25

MohammadAmiry

18-Dec-07 19:25

My.Computer.Scree.MousePointer=Cursors.WaitCursor

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