how to create xml schema for dataset at runtime? - Visual Basic Discussion Boards

Counting results in VB.Net 2005 Express ?

Weeler J.F.23-Jan-06 1:24

23-Jan-06 1:24

Hi funs of vb.net,
I have rewrited (converted) some code with xyz.dll (C)
form vb6 to vb.net 2005 Ex.
Have change Long types to Integer - of course.
It works. B U T the resuts are differnt ??? Unsure | :~

I am sure of the vb6 results. The astronomical countings.
They are the same in vb6, c++ and even in vba2003.
Does anyone know something about it?
Mayby the beta version or so?

sbststtswbwgf

Re: Counting results in VB.Net 2005 Express ?

Dave Kreskowiak23-Jan-06 3:02

Dave Kreskowiak

23-Jan-06 3:02

There are not differences between how each handles a 32-bit signed Integer. But, of course, that depends entirely on your code and how it's passing parameters back and forth between languages.

Without any code samples, it's pretty much impossible to tell you what's going on.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Create an UDP connection

Fulmine23-Jan-06 1:06

Fulmine

23-Jan-06 1:06

Hi to all,
do you remember when we could make an easy UDP connection with VB 6.0?
we needed only to drag and drop the winsock... one minutes of codes and... we could make two applications "talk together"!!!

Now i have a problem!!!

I want to do the same thing with "Microsoft Visual Studio 2005"... but there is a new way to program that i don't know... even i don't know what is the name/identifier of this new language... (maybe "VB.NET 2005"?)

I have found, on this site, articles/source on UDP connection... but "Microsoft Visual Studio 2005" say that this code is old so it make a convertion... EVEN THOUGH I DON'T UNDERSTAND THE SOURCE!!!

There are a lot more lines of code...

Please Help Me... I NEED A SMALL EXAMPLE (SOURCE FOR "Microsoft Visual Studio 2005") LIKE TWO FORMS THAT CAN CHAT BETWEEN THEM!!!

THAKN YOU ALL!!!

And excuse my english

How to unistall the software

JUNEYT23-Jan-06 0:42

JUNEYT

23-Jan-06 0:42

Hello!

I developed an application but I intend to write an uninstall app for it. I don't know how I could remove the software from Add/Remove programs section in the control panel with my code.

Any idea would be very helpfull

Thanks.

Bedri.
bckurd@e-kolay.net

Re: How to unistall the software

Owner drawn23-Jan-06 1:47

Owner drawn

23-Jan-06 1:47

This key maintains a list of applications to be Uninstalled.

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall.

Add/Remove wizard takes entries from here(though I am a bit tentative about this).

Jesus Loves Rose | [Rose]

<marquee direction="up" height="40" scrolldelay="1" step="1" scrollamount="1" style="background:#aabbcc;border-bottom:thin solid 1px #6699cc">
--Owner Drawn Rose | [Rose]

--Nothing special
--Defeat is temporary but surrender is permanent
--Never say quits
--Jesus is Lord Rose | [Rose]

Re: How to unistall the software

progload23-Jan-06 12:32

progload

23-Jan-06 12:32

Check out this article:

http://www.dotnetspider.com/kb/Article1725.aspx[^]

It may give you an idea or two...

progload

Re: How to unistall the software

Mekong River26-Jan-06 14:58

Mekong River

26-Jan-06 14:58

B Journey wrote:
I developed an application but I intend to write an uninstall app for it.

Do you develop your application in vb.net? As far as i know, when you build an installer for vb.net application it also has a property that ask you to allow to have uninstall feature or not. If you allow, after you install an application, the name of your application will appear in the ADD/REMOVE PROGRAM dialog box.

how to create xml schema for dataset at runtime?

lavanya_satheesh23-Jan-06 0:07

lavanya_satheesh

23-Jan-06 0:07

when u create a dataset at design time the xml schema gets automatically generated. i want to generate that schema in code so that the dataset i am creating comes in the project data of available datasources in the database expert dialog box of the crystal report. can anyone tell me how to do it?

thanks in advance,

lavanya Smile | :)

No touch Deployment!!!

johnsonliveshere22-Jan-06 23:59

johnsonliveshere

22-Jan-06 23:59

I Want to deploy my application through No Touch. But i have two projects client and server which has to be deployed in a single click .I don't know how to implement this pls help me
Regards
Johny

-- modified at 6:00 Monday 23rd January, 2006

Re: No touch Deployment!!!

Mekong River23-Jan-06 17:05

Mekong River

23-Jan-06 17:05

It is simillar to the answer file for windows 2000 and windows xp or an INF file for microsoft batch when you need to install windows 98 with less administrative support. I do not have any code for you but i just give me some idea about this application.

You need to build a single form of collecting an information from the user (name, organization, serial number) and save it to another file after user enter into a specific form. Then write your own setup file to read an information this file. So everything might work fine.

I can't guarantee that it is working or not but I hope it is working like windows does when you need to install by using the answer file.

Re: No touch Deployment!!!

johnsonliveshere23-Jan-06 17:23

johnsonliveshere

23-Jan-06 17:23

Hi Roath Kanel!

My application has these two projects one is windows services and other is outlook Add-inn and now i want to use the one touch deployment to implement my application.When i click the link these two projects has to be deployed

I don't know how to implement this if you have any idea or sample code how to implement this pls fwd it

Thaks in Advance
Johny.R

-- modified at 23:24 Monday 23rd January, 2006

How to Insert line number in VB

Paritos22-Jan-06 22:52

Paritos

22-Jan-06 22:52

Hi
How to insert line number in VB6.0.

Ex:

1010 msgbox("Hi")
1020 msgbox("Hello")
1030 msgbox("Hello2")

Paritosh

Re: How to Insert line number in VB

Dave Kreskowiak23-Jan-06 2:59

Dave Kreskowiak

23-Jan-06 2:59

Why??? It's such an outdated concept. You really shouldn't be doing it.

In properly written code, you just don't need them at all.

Labels, still an outdated concept, can be done like this (IIRC):

    code
    code
    code
Label3:
    code
    code
    code

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

parameterise SQL Query....

Sasmi22-Jan-06 22:48

Sasmi

22-Jan-06 22:48

Hi Guy's
I want to Filter the time which is not between given two Times.
i mean i want to filter the Time which is not between 07:00:00 Am and 10:00:00 am.

Sasmi

Re: parameterise SQL Query....

lavanya_satheesh23-Jan-06 0:14

lavanya_satheesh

23-Jan-06 0:14

think this is your answer.

select field from table where time(field) between parameter1 and parameter2

try this out.

regards,

Lavanya

Re: parameterise SQL Query....

Colin Angus Mackay23-Jan-06 7:43

Colin Angus Mackay

23-Jan-06 7:43

I'm guessing that the column storing the time is a datetime or smalldatetime. Also, as you didn't say, I'm assuming you are using SQL Server 2000. In this case you need to extract out the time portion from the date portion and filter on that.

Something like this might work:

SELECT * FROM MyTable
WHERE ((datepart(hours, timeColumn)*3600)+(datepart(minutes, timeColumn)*60)+datepart(seconds, timeColumn)) 
      NOT BETWEEN 25200 AND 36000

The calculation in the WHERE clause represents the timeColumn being converted to seconds since the start of the day.
"timeColumn" is the name of the column that contains the time information.
The numbers after the BETWEEN represent 7AM and 10AM in seconds since the start of the day.

Does this help?

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

-- modified at 13:45 Monday 23rd January, 2006

Columnstyle drag'ndrop in WinForms app (VB.NET 2.0) ?

MrBean22-Jan-06 22:15

MrBean

22-Jan-06 22:15

I'm currently developing a application where the end-user must be able to arrange "fields" in a "panel" via drag'n'drop much like columns are often re-arranged in grid header at runtime.

The "panel" must support arranging the order of the "fields" by the end-user and also support adding and removing "fields" from the "panel" from a "stock panel" which contains all available "field"-items.
I must be able to implement my own "Field"-item control so I can't just use a normal grid.

I'm currently looking into using the new FlowLayoutPanel control but it doesn't support drag'n'drop of items in runtime.

Any advice how to implement such a feature ?

I'm open towards commercial 3. party components but if this feature can be done for free, it would be best Smile | :)

Re: Columnstyle drag'ndrop in WinForms app (VB.NET 2.0) ?

MrBean27-Jan-06 1:56

MrBean

27-Jan-06 1:56

"problem" solved.

I have implemented my own drag'n'drop functionality into the FlowLayoutPanel.

Display Properties, Advanced, DPI Setting

cylix200022-Jan-06 21:32

cylix2000

22-Jan-06 21:32

In my application,
All the controls in the form is setted to Arial, 8.25pt.
But one of user computer set the DPI setting to Large, 125DPI.
But not normally 96DPI.
All my font in the form is enlarged.
Most of text of controls are outside the boundary.

How can I set the form will not affect by this factor like all window application ?

Re: Display Properties, Advanced, DPI Setting

Hunter197317-Feb-06 2:10

Hunter1973

17-Feb-06 2:10

Have you found a solution to this issue? I am running into the same issue myself. Any help will greatly be appreciated!

Problem on Migrating VB to VB.NET using Dataset instead of recordset

drexler_kk22-Jan-06 21:31

drexler_kk

22-Jan-06 21:31

Hello everyone,I'm new to VB.NET. I am having problem with migrating the following code from VB to VB.NET.I'm a new beginner on this VB.NET. This code doesn't run at all in VB.NET. Anyone can please give me a solution to change it to VB.NET?

VB Code:
Private Sub Spam()

Set con1 = New ADODB.Connection
con1.Open conStr1

Set rs1 = New ADODB.Recordset
Set rs1.ActiveConnection = con1
Set rs2 = New ADODB.Recordset
Set rs2.ActiveConnection = con1

sql1 = "SELECT TOP 20 * FROM TT_Member WHERE Reminder = '0' AND Status = '1'"
rs1.Open (sql1)

If rs1.EOF And rs1.BOF Then
Label1.Caption = "Finished - " & Now
Else
Do Until rs1.EOF
Label1.Caption = "Spamming - " & Now

OriginatingAddress = rs1.Fields("Mobile_No").Value
If Mid(OriginatingAddress, 1, 3) = "601" Then
Telco = 2
ElseIf Mid(OriginatingAddress, 1, 3) = "013" Then
Telco = 3
End If

Reminder_Msg = "You are charged $2."

MT_Msg = Reminder_Msg
MT_Msg = Replace(MT_Msg, "datedate", Renewal_Date3)

rs1.MoveNext
Loop
End If
End Sub

Hope someone can give me a solution here. Thank you so much~!

Re: Problem on Migrating VB to VB.NET using Dataset instead of recordset

lavanya_satheesh23-Jan-06 1:02

lavanya_satheesh

23-Jan-06 1:02

vb and vb.net are like a mango and a mango tree. pls familarize yourself with the concepts of ado.net.

this is a sample code. this is for insertion. try this out.

Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlDbType
Public Function inserttotables()
Dim sqlcon1 As New SqlConnection(constr)
Dim sqlcon As New SqlConnection(constr)
Dim strq1, strq2 As String
sqlcon1.Open()
sqlcon.Open()
strq1 = "insert into BillCommonDet(BillNo,BillDate,Customer,Doctor,Pharmacist,GrossTotal,Discount,NetTotal,AmtReceived,Balance)values(@BillNo,@BillDate,@Customer,@Doctor,@Pharmacist,@GrossTotal,@Discount,@NetTotal,@AmtReceived,@Balance)"
strq2 = "insert into BillProductDet(Billno,Billdate,PID,PName,BatchNo,MfgDate,ExpDate,UnitPrice,ReqQty,Tax,Amount) select billno,billdate,pid,pname,batchno,mfgdate,expdate,unitprice,reqqty,tax,amt from TempCustBill"
Dim cmdstring As New SqlCommand(strq1, sqlcon1)
Dim cmdstr As New SqlCommand(strq2, sqlcon)
cmdstring.Parameters.Add("@BillNo", TextBillNO.Text.Trim)
cmdstring.Parameters.Add("@BillDate", DateTimeDate.Text.Trim)
cmdstring.Parameters.Add("@Customer", TextCustomer.Text.Trim)
cmdstring.Parameters.Add("@Doctor", doctor)
cmdstring.Parameters.Add("@Pharmacist", pharmacist)
cmdstring.Parameters.Add("@GrossTotal", Val(TextGrandTotal.Text.Trim))
cmdstring.Parameters.Add("@Discount", Val(TextDiscount.Text.Trim))
cmdstring.Parameters.Add("@NetTotal", Val(TextNetTotal.Text.Trim))
cmdstring.Parameters.Add("@AmtReceived", Val(TextAmtRec.Text.Trim))
cmdstring.Parameters.Add("@Balance", Val(TextBalance.Text.Trim))
Try
cmdstring.ExecuteNonQuery()
cmdstr.ExecuteNonQuery()
cmdstr.Dispose()
cmdstring.Dispose()
sqlcon1.Close()
sqlcon1.Dispose()
sqlcon.Close()
sqlcon.Dispose()
Catch x As SqlException
MessageBox.Show(x.Message)
End Try
End Function

Re: Problem on Migrating VB to VB.NET using Dataset instead of recordset

drexler_kk23-Jan-06 15:23

drexler_kk

23-Jan-06 15:23

Hello there,I am sorry because I'm really a beginner. I think your code doesn't really help me because I need to select the data row by row inside the dataset. And used movenext function with loop together.I found that there is no more BOF and EOF function. Can you give me a better solution code? Any other example which is more similar to what I need can show me please?

Thank you ~!

Regards
Drexler

Re: Problem on Migrating VB to VB.NET using Dataset instead of recordset

mayhem_rules23-Jan-06 17:28

mayhem_rules

23-Jan-06 17:28

Go through these pages. Your will get a good idea how things are to be done in .NET

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbwlkwalkthroughdisplayingdatafromsingletableinwindowsform.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbcondatasets.asp[^]

With Best Regards,

Mayur

Creating VB Forms on FLY

MalikRizwan22-Jan-06 19:36

MalikRizwan

22-Jan-06 19:36

I couldnt find the VB6 Message board hope u wudnt mind asking question here.
I want to create vb6 forms dynamically . i have form names in database and i want to create form of that specific name on fly

R A M

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