Search:
Type: Posts; User: kpmc
Search:
Search took 0.04 seconds.
-
Based on your description and code/procedure provided, I recommend that you use PhotoShop to accomplish your goal.
-
You will probably have to loop through the dictionary collection using a keyvalue pair and compare your string to the key. Also, maybe you should be using a task? Not sure...
Dim Dict As...
-
I was thinking that too, I am unsure when decimal became part of SQL, but we've been kicking this erp around for quite some time now.
-
Hey tg. The erp/mrp giant in their infinite wisdom decided to use float in their order table. I assume so it could be used in several different applications, ie some end users may sell things by the...
-
Good advice, Sir Geek. All the scales I have seen were .999~ so I just plopped ceiling. You're spot on though.
-
Thanks Si, I want whole numbers in this case. I figure if I cast through sql command it should get me there. I am about to find out
Changed my Sql Command to:
Dim ProductionOrdersSelCols As...
-
So I have a sql table i am loading into dataset with SqlDataReader. The sql column type is float, the value is 225. In the datatable the type is double, and the value is 224.99999999999997
How can...
-
The data comes from a cloud based HR service that offers no validity, or restraint. You can literally type the word hippo into a date field. You're right, it is terrible. I have a few other words I...
-
Hello folks, It's been a while, hope your all doing well.
I've been crawling around the rabbit hole of nullable types and am wondering if anyone can simplify this procedure. The incoming date from...
-
As is, you would go with Option A for simplicity?
-
Here is one for yas,
Mission is to fill a datatable available from Class scope, which of the below options most closely matches how you would do it, and do you recon there is anything "unsafe"...
-
-
-
Though your description contradicts your code, or in the least, makes very little sense, the problem is youre not binding to a table, youre binding to a dataset.
txtcust.DataBindings.Add("Test",...
-
No, you cant, You can however pass the Tag value into the DoWork event
-
I was just doing some tests on dgv and found its the new row messing with it and was about to tell you to calculate for it.
-
What if you hired a DataTable?
Option Strict On
Public Class Form1
Dim DtTable As New DataTable
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
-
Dim Position As Integer = 20
Dim RowCount As Integer = DataGridView1.Rows.Count - 1
If Position > RowCount Then
DataGridView1.Rows.Add(Position - RowCount)
...
-
You are better off describing what you want without the code.
-
No, it is not possible to open and write string to txt without opening it.
-
I dont know about that tablemanager/updateall business, but it is likely there is no command builder, insert or update commands, I dont see any fk update/delete/cascade rules. It seems like you are...
-
Do you have a particular reason that you are using a TableAdapter rather than a DataAdapter?
-
Why is that? A Union would form 1 table with their items from useritems table and from all items in itemtable minus their items. then just databind to that table with 1 clb.
-
You could
Private Sub RichTextBox1_KeyDown(sender As Object, e As KeyEventArgs) Handles RichTextBox1.KeyDown
e.SuppressKeyPress = True
End Sub
-
If both lists come from SQL type database you could select all user items and union all items where not in user items.
-
If you call on `NotifyCurrentCellDirty` after the WriteXml then the cell will act normally, but then for some reason `Dgv.IsCurrentCellDirty` no longer returns True... Scratching my head on this one....
-
I would like to understand what is happening with a DataGridViewCell and why keypresses are replacing instead of appending. For some reason it is difficult for me to explain, so I have prepared a...
-
Try like this
Public Class check
Public payee As String
Public amount As Single
End Class
Module Module1
Sub Main()
-
this forum is for visual basic.net not vb6
-
Try Application.StartupPath
-
Fair point JMC, and I did know that, it is the reason you need a method invoke from within that event to access controls; though I reckon that the data is not taking the same journey when using...
-
I have been tinkering with ThreadPooling lately. See if this solution will help. More info for ThreadPool
Private Sub FormThreading_Load(sender As Object, e As EventArgs) Handles MyBase.Load...
-
I cant speak much on tableadapter, but using DataAdapter a typical setup may look like this (give or take)
Dim DtSet As New DataSet
Dim ParentBS, ChildBS As New BindingSource
Using SqlConn...
-
I am glad it worked out for you.
-
I cant think of a reason to refill the table at all unless you need data that another user entered. The database table gets the row from the row entered into the DataTable, its redundant to pull all...
-
Yes. When you say they are related I am going to assume that they are related in a dataset. I also assume you related them through the table wizard dealyo... If that is the case then goto that wizard...
-
Remove the AI from the datagridview and add it to the datatable prior to filling it
-
You can use the OledbConnection to write changes back to the excel file. The only thing you cant do is delete.
-
I am pretty confused by what your problem is. I am going to use the keyword "unbound" and ignore the rest of what you said.
Here is a working sample how to add data from an XLSX to a datagridview...
-
Nono, not ADODB... ADO.Net
it looks more like this
Dim XLSFile As String = "C:\DATA\xlfile.xlsx"
Dim connstring As String = "Provider=Microsoft.ACE.OLEDB.12.0;" &
"Data...
|
Click Here to Expand Forum to Full Width
|