|
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
|
|
|
|
|
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.
|
|
|
|
|
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 
|
|
|
|
|
How can I Connect database with Disconnected Architecture?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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."
जय हिंद
|
|
|
|
|
Hi,
Please help me
How Can I get Pendrive Serial No in VB.Net.
Thanks & Regards
Form :-
Vikash Yadav
|
|
|
|
|
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
|
|
|
|
|
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.......
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
please give me any sample code
Thanks
KV
|
|
|
|
|
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.
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
|
|
|
|
|
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.
|
|
|
|
|
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
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
|
|
|
|
|
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.
|
|
|
|
|
Thanks for your Reply Dave
me too. The only thing that i need to achieve is Accept the user input from the Setup Process and change the Webconfig(ConnectionString), i dont want to move directories around, but i think i should be easy to do that. My problem in the link i gave you, is that i cant open the WEbConfig to write on it. well the code works on the page , but not on the installer Class Project.
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
|
|
|
|
|
|
I don't see the point of having two threads, if one has to stop while the other runs. I think you've missed the point of threading.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
hai all,
is it possible to take and run vb.net windows application setup as windows service...if possible means how to take and run vb.net windows application setup as windows service....
is it possible to run the vb.net windows application setup automatically 5 mins once....if possible means...how to run vb.net windows application setup automatically...want to run 5 minutes once automatically...
thanks in advance...
|
|
|
|
|
You want to install a service and have it then run automatically ? Yes, that's easily done.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
When i run My Project there is ERROR that
Could Not load file or assambly " DriveinfoEX.dll, 1.1.3326.15292 Culture=neutral,Public key token=1 or its dependensy. the application faild to start because its side by side configration is incorrect please see the application event log for more detail(Exception from HRESULT:0x800736B1)
Thanks & Regards
Form :-
Vikash Yadav
|
|
|
|
|
Hi,
you are not the first[^] to have such problem.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
