|
Along those lines, could you help me out with this code that isn't working the way I want it to.
I am trying to insert new row(s) into a datagridview called "CustSalesOpportunityLineDataGridView" (that is databound to a table called "custsalesopportunityline" in a master-detail form that contains includes the header info as well).
I have also created a generic product selection form that contains a datagridview called "ArticleDataGridView" that displays all the info and contains the filters that users need to efficiently search and filter out products. The dataset for the "ArticleDataGridView" is based on a view that I have created in the database.
On the "ArticleDataGridView" I have created a column called "Select_Article" that is a DataGridViewCheckBoxColumn. (false value = 0, indeterminate = 0, true =1). If the users want to add a particular product to the SalesOpportunityLine datagridview they should be able to check the checkbox for each desired row and then click the AddAndContinueButton. The Select_Article checkbox column is the leftmost column of the datagridview.
For each product that they have selected in the articledatagridview a new row in the "CustSalesOpportunityLineDataGridView" should be created and displayed as well as the articleID, name and Salesopportunityheaderid.
Where am I going wrong with the code below? Based on the error messages I am getting I don't think it is reading from the correct column.
Private Sub AddAndContinueButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddAndContinueButton.Click<br />
<br />
For Each dgvRow As DataGridViewRow In Me.ArticleDataGridView.SelectedRows<br />
If Me.ArticleDataGridView.Item(ArticleDataGridView.CurrentRow.Index, 1).Value = 1 Then<br />
Dim dt As DataTable = Me.SalesOpportunity.Tables("custsalesopportunityline")<br />
Dim dtRow As DataRow = dt.NewRow()<br />
dtRow("Salesopportunityheaderid") = NewSalesOpportunity.SalesoppHeaderID<br />
dtRow("articleid") = dgvRow.Cells("ArticleIdDataGridViewTextBoxColumn").Value<br />
dtRow("work_articlename") = dgvRow.Cells("ProduktnavnDataGridViewTextBoxColumn").Value<br />
dt.Rows.Add(dtRow)<br />
<br />
End If<br />
Next<br />
<br />
End Sub
|
|
|
|
|
thx for the Info Dave.
Don't block the drive way of all the newbies in programming.
|
|
|
|
|
Hi, Can someone tell me what windows messages a UserControl receives when the parent (ie a vb form) is moved/minimized/maximized)? I tried subclassing the WM_MOVE, WM_MOVING messages but it doesn't seem to be sent.
|
|
|
|
|
When the PARENT form is resizing?? None. About the only thing it will get are WM_PAINT messages, and if the form is dynamically resizing or moving controls, WM_SIZE, and/or WM_MOVE messages. Ther eis no message sent to the controls telling it the parent is being moved or it's window state changes.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Hi all,
I would like to know if there is a way to disable all date selections before the current date in the asp.net calendar control. The part to disable or strike-out the date should be something like this :-
<cal>.DayStyle.Font.Strikeout = True
<cal>.SelectionMode = CalendarSelectionMode.None
but how do we select all the dates < the current on which the above could be applied?
tks
|
|
|
|
|
On the calender day render event you set the e.Day.IsSelected = False if you don't want the day selectable.
Here is an example from MS help:
Protected Sub Calendar1_DayRender(ByVal sender As Object, _
ByVal e As DayRenderEventArgs) Handles Calendar1.DayRender
Dim myAppointment As Date = New Date(2005, 10, 1)
If (e.Day.Date = myAppointment) Then
e.Day.IsSelectable = True
Else
e.Day.IsSelectable = False
End If
End Sub
Hope that helps.
Ben
|
|
|
|
|
WORKS BEAUTIFUL!!!!!!!! thanks a lot Ben
|
|
|
|
|
Hello all,
I have three tables:
Tablename 1: Agent
Collums:
Agentnumber (PK)
Agentname
Tablename 2: Agent_Group
Collums:
Agentnumber (FK, connection with Agentnumber of Agent table)
Groupnumber (FK, connection with Groupnumber of group table)
Tablename 3: Group
Collumns:
Groupnumber (PK)
Groupname
Now i need to show the names of the agents which belong to (for example) groupnumber 300.
This is the SELCECT statement i made:
SELECT Agent.Agentname
FROM (Agent_Group INNER JOIN
Agent ON Agent_Group.Agentnumber = Agent.Agentnumber)
WHERE (Agent_Groep.Groupsnumber = ?)
The "?" is a variable, called groupNumber.
Wen run the statement in the querybuilder i get some results bun when running the application i get the error message:
"An unhandled exception of type 'System.Data.ConstraintException' occurred in system.data.dll"
Maybee som extra info (in dutch):
Additional information: Beperkingen konden niet worden ingeschakeld. Een of meer rijen bevatten waarden die in strijd zijn met de beperkingen met betrekking tot niet-null waarden, unieke waarden of afwijkende sleutels.
The following statement works fine but then i see only the agentnumbers who belong to group 300.
SELECT Agentnummer, Groepsnummer
FROM Agent_Groep
WHERE (Groepsnummer = ?)
Somebody any idea?
Thanks
|
|
|
|
|
This is a question for the SQL Forum.
The Babelfish translation is a bit rough, but, it would appear that you have a key constraint violation in your INNER JOIN. You shouldn't be allowing NULL's on the keys, primary or foreign, in either table. Also, is the data constistent? Do ALL of the FK values in the Agent_Group table actually exist in the PK's of the other two tables?
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
I am trying to find some VB .net 2005 code that will help me to read and pass individual records from an Access table to a (formated) Text file file. How do I write the individual lines? TIA
|
|
|
|
|
You have to write your own parser for this. Fetch records from your access DB and insert them line by line in a Text file. See THIS for how to read/write data into a text file
Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.
|
|
|
|
|
Thanks Mubashir. I though that would be it, but I wondered if anyone already had some code scenarios that i could modify.
|
|
|
|
|
That's not how this site works. We'll help you write your own code, we won't write it for you. Why?? Because you wouldn't learn anything if we did the work.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Thanks for the input and patience. Through trial and error, I am now in an advances stage of writing a custom parser (using the WriteLine method). Appreciate the help.
|
|
|
|
|
Hello all,
I was just wondering if there is any way to make a form to minimize to the windows toolbar (the one with clock).
So, when minimized there will be an icon of the application next to the clock (bottom right) that is when i right click on it, there will be a menu showing.
Thanks
|
|
|
|
|
|
Thanks Kubben 
|
|
|
|
|
How To compare data in array A and array B
|
|
|
|
|
Do U need this?
Using simple for loop
we can achieve this.
flag=true
for i=0 to n
if a(i) not equal to b(i) then
flag=false
next
if flag = false then
the arrays are not equal.
If U want something else other than this,
U will have to elaborate so that everyone can understand
what U really need.
Regards,
Arun Kumar.A
|
|
|
|
|
|
How to use crystal report Engine 10 in vb.net and open my *.rpt
so i don't like using crviewer in .net for opening my report
help me
ahmadi
|
|
|
|
|
hi,
so where do you want you to view your report if you don't like to use crviewer?
Don't block the drive way of all the newbies in programming.
|
|
|
|
|
I want the user to be able to choose the colours of the title, score, lives etc
I thought if I have a text file in the folder with the colours,
Red
Yellow
Blue
How do I then transfer it to the project?
Title.color = text line one
Score.color = text line two
Lives.color = text line three
|
|
|
|
|
If you accept words, you may be able to use reflection if they are colors in the enum the framework provides. Otherwise, you need a lookup table to establish what "Red" means, if it's Colors.Red, or if it's 0XFF0000, or whatevr.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello all,
Does anyone know how to use variable values in SELECT statements?
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
