I want to add value to column called [DateDifference] ,the values equal the diference between other column called [date of consumed] I want to subtract all the values in this column from the minimum date in the column exe: the values will insert in [Date differnce] column 0 1 10 15
The code I wrote but it doesnt work
[Dim sql As String
Dim b As Integer
Dim thisdate, mindate As Date
[CODE]...
i was wondering if it possible to have a condition where lets say you have a column in the datatable called amount and a textbox acting as the filter called say maxamount to set it so the rowfilter when filtering the table will sum the number in the amount column until the number in maxamount is met, then stop and only return the rows where the total sum of the amount column is equal or less than the maxamount value, so i guess if the next row takes us over the maxamount it discards this row and returns the rows previous to it. is this possible using datagridview rowfilter or should i be loooking elsewhere to achieve this?
View 4 RepliesWhere am i going wrong with this line of code? I think its with the (REO/Bank_Owned_Desc)
compute
[code...]
There is no column REO is REO/Bank Owned Desc, I would think it doesnt like the /between REO and Bank.But that is what the column is called in the database.
[code]Gets me one column called Length with the size of FullName in it?
View 1 RepliesI updated my DataSet with a new string column called WorkingEmployee. I dragged the WorkingEmployee onto my form and it seems to work ok, except when I change a value it does not save to the database like everything else. Any ideas on whats going on?
View 8 RepliesI have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but dont know how to compelte the rest.
Imports System.Data.SqlClient
Public Class cbo2
Private Sub cbo2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]...
I have a form called FrmPracDetails which is built up with a List view called LvwColProc. Therefore when you click a field on the LvwColProc it takes you to another form called FrmColProcessing, here you can make changes to certain fields which are also present on FrmPracDetails. What I want to do is when you make changes on FrmColProcesing and Click the Save Button (which calls the Save function)the changes appear instantly on FrmPracDetails. Please note, FrmColProcessing will always be open next to FrmPracDetails. I have tried to put this code in the Save function present in FrmCol Processing as shown below, but it doesnt Refresh FrmPracDetails form. [code]
View 1 RepliesI have the following line of code in my program:
JCL_History.Enqueue(JCL_History(I))
This JCL_History object is basically a Generic.List encapsulated in a wrapper and has the following method:
Public Sub Enqueue(ByRef value As String)
If Members.Contains(value) Then
Me.RemoveAt(Members.IndexOf(value))
[Code].....
In my testing I have 2 items in this JCL_History list. When I call that first line of code I posted (the one that invokes Enqueue) with I = 1 I expect the first item to be shuffled to the bottom and the second item to be shuffled to the top.
After the thread returns from Enqueue I notice that this is exactly what happens to my list, HOWEVER if I hit the "step_in" button after the execution of Enqueue I go into the Default Property's set method where Index = 1 and value = and it screws everything up, because the item that got shuffled to the end (index 1) gets overwritten by the item value shuffled to the top.
So basically the set method on the default property is getting called at what I think to be a completely ridiculous time. What gives? By the way I'm running VS2005 on XP.
Can you look at my coding and let me know what I'm missing or doing wrong?I have a SSRS report that is called from a ReportViewer control and the ProcessingMode for this control is Remote. The report also has 1 parameter in it's DataSet.In the code I placed a MsgBox to make sure the code is finding the parameter and returning the parameter name. I am trying to stick the value of 10 into the parameter for playerID 10. Data for this player does exist.
I believe I need to add some more code to make this work but I'm not sure what else to add.
When the code executes the report is displayed but no data is shown in the report.
[Code]...
I recently found an awesome tool called "Freemind" that is called a 'mind mapping' program. It's similar to MS Visio but way cooler and more automated.I reeeallly would like to integrate this into a VB.net Form, but how?
Has anyone seen or heard of mind mapping inside VB.net before? Are there programs out there already that work with VB.net or anyone have an example they have seen / built that works?
My code Adds a New Row from a Source Table called "objTablaOrigen" To a final table called "objTablaDestino". This tables are passed ByRef because they come from a DataSet respectively. objRowNuevo is The Row that will be added to "objTablaDestino" The data from "objRow" is well copied to the "objRowNuevo" (that is the new Row with type of objTablaDestino).
'The problem occurs when the instruction Add is executed. ¿What happens? The new row is added as well, but this generates an Exception with the next message:
[Code]...
How to add a checkbox column at first column of datagridview including column header?After adding, how to code to "check all" or "uncheck all"?
View 27 RepliesI have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
Dim*OpenTextFile*As*String*= IO.Path.Combine("C:Test1.txt")
Dim*OpenTextFile2*As*String*= IO.Path.Combine("C:Test2.txt")
Dim*SaveTextFile*As*String*= IO.Path.Combine("C:Test2.txt")
[code]....
in the .net dll (named "Calendar") I have a public class called clsCalendar that has several public properties and functions. In the Calendar project properties I have checked "Register for COM Interop" on the Compile tab. Also on the Application tab I clicked the "Assembly Information" button and selected "Make Assembly COM-Visible".
I have tried every tip/idea I can think of that I stumbled across such as running sn.exe and then in the Signing tab of Calendar properties checking "Sign the Assembly" and picking the .snk file created from running sn.exe.I have tried running "Regasm.exe" against my Calendar.tlb file with the /Codebase option. Nothing seems to work.When testing in a .net app, I needed to code as "new Calendar.clsCalendar" to get it to work. Our existing vb6 apps that need to call the dll simply say "new clsCalendar" and I can't change these apps.
Add persistence to multible DataGridView in terms of Hide/Show column and column width
View 1 RepliesVB GridView control will not allow code in the vb code file to access a data column that has its visible property set to false. When it is set to true, the data column can be accessed with no problem. Any suggestions as to how to correct this? I have looked through the documentation, text books, and I have not found anything that gave me any clue as to what the problem could be. I thought that the property was just applied to the column, not that it would remove the column from being accessible.
[Code]...
I am trying to placed several check boxes (15) in a group box or on a form. I receive the following error message in Visual Studio:
Cannot set column, "The value violates the MaxLength limit of this column".
I have been trying to find out how to resize listview column width to the largest widthor either column header or item in c#
[URL]
I have a listview and i want to make one column's font smaller than the other column to fit form design. How will i do that?
View 1 RepliesIt seems that on clicking datagridview column header, the column will be automatically sorted based on the column type. I have a column showing some numbers. If column type is string, it sorts "1","20","3" into "1","20","3". If column type is double, it sorts into "1","3","20" which is the result that I want. However, there might be some erros in the numbers and error messages(text) will show in the cell instead of numbers. So I cannot set the column type as double. I want to ignore these error messages and sort all the numbers. How can I do this?
Also, I need to add some background colors to different rows in datagridview. So in the column header click event, I call the bkgColor Sub to achieve this. My question is that how can I override the sorting method in this event?
Private Sub DataGridView1_ColumnHeaderMouseClick(sender As Object, e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView1.ColumnHeaderMouseClick
Try
[code]....
I am developing Restaurant POS Application with home devliery module. Customer call to restaurant and give the order. so whenever customer calls comes i need to show the pop-up on my desktop application with particular customer information. Please guide me how to do this. I am using visual studio 2008 (vb.net)
View 1 RepliesPrivate someSub()
If someBoolean = True Then Exit Sub
' do some great work because someBoolean is False
End Sub
I know there is a name for this. The idea is to check something and if it isn't what you want then you stop code processing. I thought it was called "escape pattern", but Google isn't confirming that name.
So I've got some code that I've written in C and compiled into a DLL. This code is called by my VB.NET code. That interface is working fine, but I need to debug some of the C code. But obviously since it's not in VB I can't use the Visual Studio debugger. I've tried attaching a GDB debugger to the process while it's running. It lets me set the breakpoints and it even stops at them, but it doesn't let me see the lines of code. My code was compiled with debug information, so I don't know why it won't let me see it.
View 3 RepliesI have a project I'm updating to Framework 4. It's not originally my project, I have inherited it from a former colleague, so I'm not completely up to speed with it yet.
In one of the libraries of the project that controls context menus, I get pInvokeStackImbalance MDA alerts on the line:
Dim c As Color = Color.FromArgb(GetSysColor(COLOR_MENUBAR))
I've started programming and have this piece of [code]...
The problem is: It seems to not get called at all when i close my application!?
I've tried using msgbox instead of code to see if it worked, setting cancel = 1, using breakpoints... I think I can pretty definitely say it's not getting called.
I have a datagrid that I am unable to change the width setting, it always reverts back to the original setting.
To change this setting:
1. select the datagrid view tasks
2. Edit columns bound column properties
3. Select Width property
4. Width property will always revert back to the original setting.
I have check the properties settings without any luck.
i have a datagridview with three columns. i set the first column to visible=false, so the user can only see two columns.when the user presses the tab key in the first visible column -- column(1), i want to ignore column(2) so that the user only tabs through the rows in column(1)i can't get it to work. it will always tabs through the rows in column(2) even if i use the column name.
[code]...
I want to disable column in datagridview so the column will not receive focus,
when user press tab to move from cell to cell this column will be skipped and the focus move to the next cell or column.
I have a program and I get time data from a sqldb and display it in a column in a listbox. What are the proper steps for adding the time as I iterate through the data in the column? I figure I will need to do some conversions on the time to be able to add it and display it as a total.
View 9 Repliesi need to do a macro. this is what my excel looks like
1 2 3 4
seq1 name name seq2
abcde vv1 abcdddd
abcxy vv2 abcdlmn
[code]....