Visual Basic

move reports form a datagridview to another

18-Feb-09 2:17

This sounds much like a homework assignment. That's why you're getting the answers you are.

And they're right, even if it's not homework. If someone else writes the code for you, it's not your work you're turning in and you don't deserve to get the credit for it. And, you just doing yourself a diservice because you won't be prepared for either the next class, or the next project assignment you get.

A guide to posting questions on CodeProject[^]

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

lordgara17-Feb-09 23:05

lordgara

17-Feb-09 23:05

Hi, I'm using ado.net to connect to an access database. There are 2 tables "Collezione", bound to dgv1, and "Mazzo", bound to dgv2.
I have a problem with a button (see below for the code) that take a row from dgv1 and copy it in the dataset2 (das2) that is linked to dgv2. When the datarow that I want to copy it's just present in dataset2 I must increase the value in the quantity field in da2 without copy the row.

The code works, but when I copy the 3th different row it stops. Same thing when I try to increase the amount of the second row that I moved :S

Where I'm wrong? Thanks for help!

Here's the code of the button:

Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click

Dim dr As DataRow
dr = das2.Tables("Mazzo").NewRow()

'copy the data from dgv1 to a datarow
Dim i, indexRiga1, colonne1, righeDas2 As Integer
colonne1 = dgv1.ColumnCount - 1
indexRiga1 = dgv1.CurrentRow.Index
If dgv1.SelectedRows.Count > 0 Then
For i = 0 To colonne1
dr(i) = dgv1.Item(i, indexRiga1).Value
Next
dr(11) = 1 'it's the amount index
End If

'if dataSet2 is empty, add the row
righeDas2 = das2.Tables("Mazzo").Rows.Count - 1
If righeDas2 < 0 Then
das2.Tables("Mazzo").Rows.Add(dr)
End If

'if dataSet2 is not empy, try to find if datarow is just present
For i = 0 To righeDas2
If das2.Tables("Mazzo").Rows(i).Item("Nome") = dr(1) And _
das2.Tables("Mazzo").Rows(i).Item("Col") = dr(5) And _
das2.Tables("Mazzo").Rows(i).Item("Tipo") = dr(6) Then

dr(11) = das2.Tables("Mazzo").Rows(i).Item("Giocate") + 1 'increase the amount
das2.Tables("Mazzo").Rows(i).Delete()
das2.Tables("Mazzo").Rows.Add(dr)

End If
Else
das2.Tables("Mazzo").Rows.Add(dr)
End If
Next

End Sub

Re: move reports form a datagridview to another

Dave Kreskowiak18-Feb-09 4:43

Re: move reports form a datagridview to another

18-Feb-09 4:43

I'd love to be able to help you, but this code doesn't make any sense and your description of what you need it to do doesn't either.

A guide to posting questions on CodeProject[^]

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

lordgara18-Feb-09 5:21

lordgara

18-Feb-09 5:21

I try to be more clear...
I have a access database. This database have 2 tables. The first table name is "Collezione" and the second "Mazzo".
In a form I have two datagridview one called "dgv1" and the last "dgv2". The first is bound to datas that are in "Collezione" and the other to data in "Mazzo".
I make a button that copy the report selected by user from dgv1 and add it to dgv2.

the problem is that the code doesn't work Sniff | :^)

VB.NET

Umesh_8617-Feb-09 20:22

Umesh_86

17-Feb-09 20:22

How can I Connect database with Disconnected Architecture?

Re: VB.NET

Vimalsoft(Pty) Ltd17-Feb-09 21:51

Need Autocomplete Textbox With Text and Value Property

17-Feb-09 21:51

Good Morning Umesh_86

I Forgive you because you are new to this Forum. But next time Before you Post you must First Google. Promise me you will never commit this offense again.

here is your Answer

http://www.google.co.za/search?hl=en&q=Introduction+to+ADO.NET+in+VB.NET&meta=[^]

Hope it helps

Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

Jagz W17-Feb-09 19:17

Jagz W

17-Feb-09 19:17

Hi all
i am working on a VB.net Project. this is my first project in vb.net and i need a autocomplete textbox which return entered text id..like dropdownlist.
I have seen some properties of textbox regarding autocomplete but that not return value of entered text.

Please Help
Thanks
Jagwinder Singh

Er. Jagwinder Singh

Re: Need Autocomplete Textbox With Text and Value Property

dan!sh 17-Feb-09 20:17

dan!sh

17-Feb-09 20:17

You need to set AutoCompleteMode and AutoCompleteSource to do this. If you set AutoCompleteSource as CustomSource, then AutoCompleteCustomSource should also be populated with list of values.

The word "politics" describes the process so well: "Poli" in Latin meaning "many" and "tics" meaning "bloodsucking creatures."

जय हिंद

Get Pen Drive Serial No. Not Drive No

Vikash Yadav17-Feb-09 18:56

Vikash Yadav

17-Feb-09 18:56

Hi,

Please help me

How Can I get Pendrive Serial No in VB.Net.

Thanks & Regards

Form :-
Vikash Yadav

vb2008 doesn't call a sub in a form Called through assembly

Aiman Farouk Mohamed17-Feb-09 18:46

Aiman Farouk Mohamed

17-Feb-09 18:46

Dear All:
I have a problem in vb2008 that when using assembly method to call a form ,When trying to call a sub within this form vb2008 doesn't do anything.
could you help me
Thanks in advance
Aiman Farouk

Re: vb2008 doesn't call a sub in a form Called through assembly

kvelu.d17-Feb-09 19:22

kvelu.d

17-Feb-09 19:22

just two days back only i solved this problem, Try this below code and this may help you to find out your solution

******This is your windows application or class library project, but it should be "Public Module"******
Public Module TestModule
    Public Sub Test()
        MsgBox("Test successfully completed")
    End Sub
End Module

******Below Code to your Current Project******
Imports System.Reflection

******Use the below code at any event or funtions******
Dim Path As String = "......\"
Dim FileName As String = "XXXX.dll" 'Or "XXXX.exe"
Dim FileAssembly As Assembly = Reflection.Assembly.LoadFile(Path & FileName)
Dim ModuleName As String = "TestModule"
Dim SubName As String = "Test"
Dim RefType As Type = FileAssembly.GetType(FileAssembly.GetName.Name & "." & ModuleName)
Dim MyForm As Form = New Form
RefType.InvokeMember(SubName, BindingFlags.InvokeMethod, Nothing, MyForm, Nothing)

Please tell me the above codes are working or not.......

Re: vb2008 doesn't call a sub in a form Called through assembly

Aiman Farouk Mohamed18-Feb-09 0:30

Aiman Farouk Mohamed

18-Feb-09 0:30

Thank you for your reply .
I tried it but an error displayed
System.Reflection.TargetInvocationException was unhandled

again I want to clear it I want to call a public sub declared inside the form class which I am opening through assembly
Hope to clear it for me

Create setup project using own code

kvelu.d17-Feb-09 17:58

kvelu.d

17-Feb-09 17:58

Without using any setup and deployment, how can we create the setup file using fresh code.

Please help me to find out the solution.

Thanks in Advance,
KV

Dave Kreskowiak17-Feb-09 18:02

17-Feb-09 18:02

Write code to copy your files to the appropraite places required, create and the registry keys and values you need, and modify any other configuration files. Shouldn't be too hard, just time consuming.

A guide to posting questions on CodeProject[^]

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

kvelu.d17-Feb-09 18:12

kvelu.d

17-Feb-09 18:12

please give me any sample code

Thanks
KV

Vimalsoft(Pty) Ltd17-Feb-09 21:54

17-Feb-09 21:54

You Have to Create Installer Class and create CustomActions. look at this

http://www.google.co.za/search?hl=en&q=Create+Installer+Class&btnG=Google+Search&meta=[^]

Am Still Struggling in that matter too. trying to update the WebConfig.

Dave Kreskowiak18-Feb-09 1:35

18-Feb-09 1:35

I don't have any code that shows how to do it. And seriously, if you can't copy a file in code, you really don't have the skills to make an entire setup for you app.

The only thing I use are MSI installer editors, like InnoSetup, Wise Package Studio, or InstallShield. I just don't believe in reinventing the wheel.

A guide to posting questions on CodeProject[^]

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

Vimalsoft(Pty) Ltd17-Feb-09 21:56

17-Feb-09 21:56

hi Dave ,

Can you please help me with the kinda same Problem , i posted my Problem here

http://www.codeproject.com/script/Forums/View.aspx?fid=12076&select=2929159#xx2929159xx[^]

Thanks

Dave Kreskowiak18-Feb-09 1:34

18-Feb-09 1:34

An ASP.NET app is a bit more complicated, and no I don't have any sample setup projects. I just don't go through the MAJOR hassle of reinventing the setup project that comes with Visual Studio.

A guide to posting questions on CodeProject[^]

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

Vimalsoft(Pty) Ltd18-Feb-09 1:40