Can anyone demonstrate with an example how to shift the position of a datacolumn in a specific position after it is added at the end of a datatable.For example lets say I have a datatable with 9 columns and 5 rows. Now I added a 10th column. However I need this new column as the 5th column which requires shifting. How do I perform this shifting?
View 3 RepliesI'm adding a DateTime DataColumn to a DataTable like this:
Dim colDate As DataColumn = New DataColumn("Date")
colDate.DataType = System.Type.GetType("System.DateTime")
dt.Columns.Add(colDate)
Then when I try to add it to my datatable, if the value is Nothing I get an error saying string was not recognized as a valid DateTime. I'm having trouble getting this to work.
How do I go about adding a ButtonColumn to a DataTable.
I am basically using a DataTable as the DataSource of a DataGrid and need to add a ButtonColumn to the DataTable so that when I DataBind it to the DataGrid it all works.
Although when I try
dt.Columns.Add(buttonColumn)
This is not allowed. It has to be a basic DataColumn.
I am currently working with a datatable and I want to be able to show richtext in a column of the table. First question can this be done? I can force the column to be Type Of richtext box. However, when I try to view/display the table, I get something like..."System.Windows.Forms.RichTextbox, Text: Text That I have added" in the column.
Is there a way that I can get it to show the rich text in a cell of a datacolumn of a datatable?
I have a datatable which loads data from an Excel Spreadsheet. One of the columns in the Excel SpreadSheet was of type "Date/Time" in which date values are stored. Now I appended the datatable with three new rows and I wanted to store string values in these rows using the code below. However due to the fact that one of the columns are date/time type, an error is generated as date/time column does not accept string value. I have two questions
a. Is it possible to store string value in date/time DataColumn?
b. Is there a remedy to this situation? [code]
Anyone have any ideas what would prevent my data from not be ing able to be bound to my data column? [code]My error says cant bind to column named SellingPrice? I have many other columns ALL binding the same way and other parts of my program recognize SellingPrice ?
View 9 Repliesi have a code where I dynamically generate the columns name and bind it it datatable. now I am iterating thru loop for each column and fill the datatable. My Problem is when I fill for first column row is already added to the position(e.g 0,1). if row at some position already exist in datatable I should not write
dr = dt.NewRow()
dt.Rows.Add(dr)
I have a datatable that contains the rows of a database table. This table has a primary key formed by 2 columns.
The components are assigned this way: datatable -> bindingsource -> datagridview. What I want is to search a specific row (based on the primary key) to select it on the grid. I cant use the bindingsource.Find method because you only can use one column.
I have access to the datatable, so I do manually search on the datatable, but how can I get bindingsource row position based on the datatable row?
I have a datatable and I apply a filter to the defaultview.rowfilter property of that datatable. If I then loop through the rows collection of the datatable, will I only be able to see those rows that the filter applies to, or will it loop through all the rows?
View 6 RepliesI want to find a particular ID in a DataTable, I am using a DataView to filter the results, but how do I know which row in the original table the filter view corresponds to? Any ideas? In know I could use LINQ but I don't think this would help either?
[Code]...
I'm currently converting a Visual Basic application to Ruby because we're moving it to the web. However when converting some algorithms I've run into a problem concerning bit shifting.How I understand it, the problem lies in the size mask VB enforces on Integer types (as explained Here). Ruby, in practice, doesn't differentiate in these types.
[Code]...
I am writing a programme for Payment calculations.I have four textboxes txtPaymentDue, txtDiscount, txtBalancePaymentDue, txtAmountPaid, txtChange
PaymentDue, BalancePaymentDue and Change are calculated by the programme.My requirements are:
1) when i enter Discount in txtDiscount on EnterKeyPress cursor should go to txtBalancePaymentDue wherein it will display the calculated BalancePaymentDue and on next EnterKeyPress the cursor should go to the txtAmountPaid and finally on EnterKeyPress the cursor should move to txtChange.
2) When I enter a digit in txtDiscount it should take it as right to left sequence and it should allow the insersion of digits .......like if i want to type 36.45 then if i type 5 the texbox should immediately look like this 00.05 when i type next digit it should look like this 00.45 likewise when i type next digit it should display 06.45 and finally 36.45.
The problem is that, when you delete MM value from the MaskedTextBox, it is shifting remaining dd/yyyy values to left in the place of deleted MM.So we would like to know how to stop shifting of dd/yyyy to left when some data is deleted from the control.
View 4 Replieswhat the purpose of the following code is:[code]....
What it does appears obvious: it increments the position by 0 (i.e. leaves it unchanged) so it appears that it does nothing-but the vendor included it so I'm assuming there's a reason.From the comments, MyCurrencyMgr is the CurrencyManager for the 'primary table' and the CurrencyMgrCollection should contain CurrencyManagers for 'other tables' but I can't find where any are actually added to it-and whether the other CurrencyManagers exist or not, I still can't see what the purpose of this code is.
When you select Definition in VB6.0 there is this Last Position menu that lets you return to the line where the cursor is located previously, it seem to be missing in .Net IDE or I can not just find it?
View 3 RepliesI'm testing a small program that can read & write to an rtf file. Examples I have found work fine, although I have two questions:
1)If I need to ALWAYS write to line number 9 of an existing RTF file, do I need to "read" 9 times or can I immediately position myself to line number 9. I have found character manipulation but can't seem to find what I need with positioning to a particular line number.
2)BOLD text: I have found examples where I should be able to format my text, such as
MyFile.WriteLine ""
MyFile.WriteLine Text
MyFile.WriteLine "0"
but when doing this, it does not "bold" my text, but actually prints the text exactly as shown. I'm looking for information/links that I can "bold" "Italicize" text. Code is written in VS2005.
how to move a label to new position programaticly I have tried:
[Code]...
None of these works, it's driving me crazy, in VB6 no problem, but VB2005 No hair left on my head, it's all on the floor
I wanna get the position of cursor(not mouse position !!), when the cursor is inside a textbox or richtextbox. On the click of a button, i should get the current position. If i get X,Y co-ordinates, it s well and good. If not possible pixel co-ordinates. Please help. I am new to vb.net
View 19 RepliesI want to read a file from a specific position and at the same time i want to use the StreamReader.Peek to check out how it works....... So i tried out this
[Code]...
I have a bunch of PNG images in my project's resources. I need to find out whether the pixel at any X,Y is transparent or not. Testing the alpha of the color returned by GetPixel doesn't work, and I can't test it against the transparency key because Bitmap objects only have a MakeTransparent method, for some strange reason. Is there a way to tell?
View 2 RepliesIf TextBox1.Text has atleast one number 0 or 1 or 2 or 0 (it may have text too, with numbers) then End If Also what command is it to get window position coordinates and what winpos[x] and winpos[y] are. All I found was setwindowpos
View 2 RepliesI am trying to get a picture box to update with a new picture when I type in a number in the navigator position item box and hit enter. I have tried various methods, but I can't seem to get a combination that works in this way. Could anyone tell me if what I am trying to achieve is possible, and if so
This is the latest variation I tried (yeah, I know...) :
Private Sub BindingNavigatorPositionItem_KeyUp(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorPositionItem.ModifiedChanged
Dim Picture As String
[Code].....
** note that the <fileLocn> is just truncated for the purposes of this post - it does actually have proper code, so that isn't the issue!
Very simply, I'm positioning a small ListBox over a DataGridView column when the user right-clicks and selects "Show Distinct Values". This works fine until the vertical scrollbar of the DataGridView is clicked. Once that's done the listbox pops up all the way over to the left edge of the DataGridView. As confirmation of the problem I created a small app to test with.
[Code]...
What I'd like to do is position Form2 underneath the Label on Form1 when the "down arrow" button is clicked. (Basically Form2 should have the same "Left" as the Label on Form1, and its "Top" should be the Top of Label1 plus the Height of Label1.) Please see attached images for further clarification. (I did something like this in VB6 with the SetCursorPos API and the Screen.TwipsPerPixelX and Screen.TwipsPerPixelY properties, but I'm sure there is a better way to do this in .NET.)
View 7 RepliesHere's the issue in a nutshell (I can elaborate if you feel it's needed). In a DataGridView I want to capture the value of the row's key column so that when the user clicks on a column header to sort the data, I can reposition to the row that was selected prior to the click. The problem is that the sorting itself, once it's done, fires the same events (RowEnter for example) that I used to determine my key value, so it sets my variable to a new value and now
View 7 RepliesFor some background please see the following thread where I just posted a solution that worked for me:[URL]..The issue involves the shifting of controls on a form when it is first being loaded (it may not necessarily happen in the Load event though). As I write in the first linked thread above.I have noticed it on a few projects -- all MDI -- but with no apparent rhyme or reason as to which controls get "afflicted". I've had it happen on labels, textboxes, pictureboxes, radio buttons, etc. Also the distance they shift is varied, as well as teh direction the move - sometimes different directions on the same form.There are no consistent properties that these controls share and I am positive that it is not a simple anchor issue. This is a true and serious bug and amazingly frustrating because there appeas to be nothing you can do or test to hack into the behavior and begin to debug it. Scrapping a solution and redoing it from scratch can seem like a viable answer it is this vexing.
My solution was to set the AutoScaleMode to None and the issue resolved itself immediately. Since many people come to this forum with Forms questions I thought it might be useful information -- at the very least it might get on the radar of some of teh answerers here in case a question pops up of this nature in the future.
I have a DataTable that I am creating and binding to a GridView. Currently the headers do not have any spaces and it makes it hard to read. I want to space them out but I'm having a minor issue.[code]I know that I can set the HeaderText in the columns declaration like below, but I won't know how any columns I am going to have. And would rather the columns be generated automatically. [code]
View 2 RepliesI have a problem which I am struggling to efficiently put into code. I have a datatable
ID | NAME | DATE | JOB
0 | Joe | 01/01 | Selling
1 | Bob | 03/01 | Buying
[code].....
Is there a way to change when an expression in a datacolumn is evaluated?
I'm trying to make a simple total function which sums the values of a particular column in a data grid. Normally the expression is evaluated when I leave from the datagridview, but I wish it to be evaluated when the row is changed.
in my datatable I've a String.Byte[] column which contains the array of bytes of an image. So, when the datatable is binded to the datagrid, I can see the picture, if present, and the red cross if is not presente. So I can remove the red cross, by assign a value to the DefaultValue property of the datacolumn. But what default value I've to assign?? I tried with system.dbnull.value but the red cross is still present.
View 8 Replies