Visual Basic

be rollbacked my transaction

27-Dec-04 4:40

You can use whichever one your comfortable with. Both SQL Server and Oracle are scalable, enterprise class, backends...

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

nazli25-Dec-04 23:54

nazli

25-Dec-04 23:54

I have a database that is greater than 2 gig.
i want to create many tables an after that create index for them .
i open my transaction before table creation and commit it after Index creation. but i get error for create index and it means my table hasn't been created . my program works well when i do it on another database.
If you know please help me.

Re: be rollbacked my transaction

Rob Graham26-Dec-04 10:47

Rob Graham

26-Dec-04 10:47

Might help if you told us what the error was, and maybe posted your code...

Why would anyone waste time arguing with an accountant about anything? Their sole function is to record what happenned, and any higher aspirations are mere delusions of grandeur. On the ladder of productive contributions they are the little rubber pads at the bottom that keep the thing from sliding out from under you. - Roger Wright

Re: be rollbacked my transaction

Dave Kreskowiak27-Dec-04 0:48

How to use a C# class through VB.NET

27-Dec-04 0:48

Like Rob said, it would help greatly if you posted your code. Also, it's better practice to create the table in one transaction, then create the indexes in the next. If the table creation fails, what's the sense in creating the indexes on it?

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

azam31625-Dec-04 6:19

azam316

25-Dec-04 6:19

hi,
i really need to know the solution to this problem as soon as possible!!!
i have to use a class written in C# through VB.NET for my project.
the C# class contains all image procesing methods i need, and the rest of the project is in VB.NET!!
i would really appreciate any help as soon as possible.

thanx in advance!!!

☺«««DTA»»»☺

Re: How to use a C# class through VB.NET

Dennis C. Dietrich25-Dec-04 8:07

Dennis C. Dietrich

25-Dec-04 8:07

azam316 wrote:
i have to use a class written in C# through VB.NET for my project.

Just add a new C# Class Library project to your existing solution. This new project will be compiled to a DLL. Then reference the C# project in your VB.NET project (also remember to check the project dependencies). Of course you could also first compile the C# sources to a DLL and then reference the compiled DLL. But using a multi-project solution has the advantage of enabling you to quickly change the C# sources if necessary. For more details see Managing Solutions, Projects, and Files[^] (in particular Multi-Project Solutions[^]).

Best regards
Dennis

Re: How to use a C# class through VB.NET

azam31625-Dec-04 18:26

azam316

25-Dec-04 18:26

thanx a lot Dennis. u r a life saver!!

thanx again!

☺«««DTA»»»☺

Reading from a Coma delimited text file

kobezt0825-Dec-04 0:37

25-Dec-04 0:37

hi I am having this problem where i have a Text file with data

000189,380661,SUPERSTAR VIRGO,410081,0813,2.200,5.76,12.67,.....

which i need to read and spreadly placed into selected colume of a ListView.

Below is the VB.net code i currently have & onli able to display the data from the 1st cloume instead of assigning:
...
If (openFiledlg.CheckFileExists()) Then
flag = True
txtSAPsrc.Text = openFiledlg.FileName
FileOpen(1, openFiledlg.FileName, OpenMode.Input)
Do While Not EOF(1)
Input(1, str)
If Microsoft.VisualBasic.Left(LTrim(str), 1) <> "," And Trim(str) <> "" Then

mitem = New ListViewItem(str.Split(","), 0)
lstvReport.Items.AddRange(New ListViewItem() {mitem})

End If
Loop

End If
.....

Help greatly appreciated.

PaleyX25-Dec-04 1:16

PaleyX

25-Dec-04 1:16

Why not read each input line into a single string then use the Split function of that string with a delimiter of ',' to split the input into an array of objects which you can then interate through.

Rugby League: The Greatest Game Of All.

kobezt0825-Dec-04 1:57

25-Dec-04 1:57

the code i posted together was able to store all the content into the str variablem split them by "," and display the data starting from he 1st colume of the listview. But how should i do it in the way i can set certain value of the input line into certain seleted colume

Dennis C. Dietrich25-Dec-04 2:21

Dennis C. Dietrich

25-Dec-04 2:21

kobezt08 wrote:
If (openFiledlg.CheckFileExists()) Then

This is not what you need to do at this point. You want to figure out if the file exists. The FileDialog.CheckFileExists Property[^] however only specifies if the dialog should warn the user if the file does not exist. What you need here is the File.Exists Method[^].

kobezt08 wrote:
txtSAPsrc.Text = openFiledlg.FileName

When naming your fields in VB.NET don't use the old VB Object Naming Conventions[^] with prefixes. Use the new Design Guidelines[^] instead no matter which programming language you use.

kobezt08 wrote:
FileOpen(1, openFiledlg.FileName, OpenMode.Input)

I recommend to use the base classes from the System namespace (personally, I think the whole Microsoft.VisualBasic namespace is only about backwards compatibility). Therefore the appropriate object would be an instance of the StreamReader Class[^].

kobezt08 wrote:
mitem = New ListViewItem(str.Split(","), 0)
lstvReport.Items.AddRange(New ListViewItem() {mitem})

I don't know if there is a more elegant way but I suggest to create a new ListViewItem[^] with all the belonging sub items and add that to the ListView.Items[^] collection. Also don't use str.Split(",") but str.Split(","c) because the first version won't compile with Option Strict[^] on (Option Explicit[^] should be switched on too).

After some additional declarations...

Dim InputReader As StreamReader
Dim InputLine() As String
Dim Counter As Integer

...my suggestions looks like this:

If File.Exists(openFiledlg.FileName) Then
  flag = True
  txtSAPsrc.Text = openFiledlg.FileName

  InputReader = New StreamReader(openFiledlg.FileName)
  Str = InputReader.ReadLine()

  Do Until Str Is Nothing
    InputLine = Str.Split(","c)
    mitem = New ListViewItem(InputLine(0))

    For Counter = 1 To InputLine.Length - 1
      mitem.SubItems.Add(InputLine(Counter))
    Next Counter

    lstvReport.Items.Add(mitem)
    Str = InputReader.ReadLine()
  Loop
End If

Best regards
Dennis

kobezt0825-Dec-04 2:45

25-Dec-04 2:45

Thanks so much for all th ehelpful tips....
Just 1 more question how do i set the data to be displayed on select colume?

example: iI wish to put "000189" in the 1st colume and "SUPERSTAR VIRGO" on like 5th colume.

And btw in str.Split(","c), wat is the c stand for & wat does InputLine(0) do, cos i cant find info on InputLine() on msdn? Char?

Dennis C. Dietrich25-Dec-04 3:09

Dennis C. Dietrich

25-Dec-04 3:09

kobezt08 wrote:
Just 1 more question how do i set the data to be displayed on select colume?

Since we're just adding items to a collection and we can't directly replace the collection itself (the ListViewItem.SubItems Property[^] is read-only) I guess the only possibility is to throw in some extra (empty) items. Try adding some of these:

mitem.SubItems.Add(New ListViewItem.ListViewSubItem)

kobezt08 wrote:
And btw in str.Split(","c), wat is the c stand for

The c tells the compiler that the character is a char and not a string (see Visual Basic Language Reference: Char Data Type[^]).

kobezt08 wrote:
what does InputLine(0) do, cos i cant find info on InputLine() on msdn?

Nothing. Just an array of strings I declared.

Best regards
Dennis

kobezt0825-Dec-04 3:30

25-Dec-04 3:30

thank you very much for your help.
guess I learnt something new tonight Blush | :O

Merry Christmas

single exe program

surendramishra24-Dec-04 22:53

24-Dec-04 22:53

can anyone tell me how to make ones application in VB to run one s only from a setup that is if i sell my application in a CD to any Client then how can i ensure that he can run it only once
thanx in advance
merry christmas to u all Smile | :)

;)

Re: single exe program

Dave Kreskowiak27-Dec-04 4:37

27-Dec-04 4:37

You really can't. There are libraries out there that will help with this, but they cost $ and are not fool proof solutions.

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

Re: single exe program

surendramishra27-Dec-04 7:22

problem in adding Data report

27-Dec-04 7:22

thanx a lot for replying ,
but there r people doing this and which libraries r there with this stuff or where can we find that
thanx and bye
Smile | :)

(

surendramishra24-Dec-04 22:33

Re: problem in adding Data report

24-Dec-04 22:33

Hi all formatted my system and am having problem in adding Data report to my project in VB 6.0, it says error no 429 thats either active control corrupted or user dont have license to use this control
plz help me out of this trouble
thanx all
merry christmas

Dave Kreskowiak27-Dec-04 4:35

Re: problem in adding Data report

27-Dec-04 4:35

Did you reinstalled Visual Studio 6 Service Pack 6 when you reformatted your system?

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

surendramishra27-Dec-04 7:18