I am creating a data logger that pulls data from an existing OPC server. When the data logger is launched, I look into the OPC server and get the names of the sensors that need logging (ColumnNames() as string) . From that, I am creating a data table with columns based on the items in ColumnNames(). That part is working. What I am having problems with is adding rows to the table. When I read the values from the OPC server, I get an array of strings (values() as string) which is guaranteed to be in the same order as the ColumnNames.I have been trying to use an SqlDataAdapter with a dynamically built insert command, but it is getting extremely convoluted and ugly.Is there an way to add a data row to my table using an array of string values directly?
I have a dynamic datatable, created from a database. I want to add a new row (blank), so there is an option to choose nothing in a combobx. Everything works ok without adding the new row. But when I add a new row, the combobox displays nothing. What am I missing?
Here is the code Dim DT As New DataTable DT = DS.Tables("CallStatus")
I am working on an application which involves serial port communication with stepper motors. Now I am sending queries to the PLC via modbus protocol. There is one query in which I ask the PLC for the current position of the moving motor and display it in a current position textbox using a DO Loop. Here the problem is the textbox only displays the position at the end of the motor movement and not while the motor in movies though I have included the code to do so inside the DO loop. So pls anyone who has the solution for this or any other alternative to perform this type of dynamic data display updation then pls reply.
I work on representation layer . My friend work on datalyer( back end) I only get a value which is datatable type. How can i show it to crystal report.
I have a custom DropDownField for a GridView. I have to specify the DataSourceMethod property to the name of a function. I can not use a SqlDataConnector object. I want to take the name of the function (e.g.MyNamespace.MyClass.GetYears) and get the resulting object and assign it to a DropDownList data source.I know I will need to use the CallByName function
I am looking for sample linq code snippet which uses System.Linq.Dynamic against a datatable.
Dim entities = (From ent In dt.AsEnumerable().Where(String.Format("IsUSFederal == {0}", "true")) _ Select Description = ent("Description"), Acronym = ent("Acronym")).ToList
I am getting an error "there is no accessible Where can be called with these arguments". I have included the DynamicLinq.vb file and the application compiles fine (aside from this error). I have included Imports System.Linq.Dynamic but it doesn't appear to be working.
I'm am creating a "pop-up" CheckedListBox over a button on my DataGridView. The values in the list are going to be filtered based on the value in column 0 of the DataGridView.I have already pulled in a "master" DataTable with two columns: ACODE and MATRIX.I want to call the following function and return an array of strings that I can use to build this CheckedListBox with. The line between "For Each r" and "Next" generates a "Number of indices is less than the number of dimensions of the indexed array". The number of items is variable in the array so I can't predefined it. I know I'm going down the wrong path.
Function StudyGroupSamples(ByVal sampleType As String) As String() Dim thisArray() As String Dim theseRows() As DataRow
i can connect to only one Data Base with dataset in Visual Basic . but i want Have Dynamic connection to data base i mean in want to my appliction users have ablity to connect to any data base they want (For Example : Choose file from menu and then open and then Select any Data base.)
I have a datagridview with data from a datatable, this datatable have these fields (id,num1,num2, date,user,ref,qt,cost,center), some of them are hided in the dgv (id,num1,num2,date,user). The user can edit,delete and add new rows to the dgv.
I have a save button that performs this actions:
First check if there are new rows, and if yes it fill the hidden fields. Then validate the inserted values by the user with a couple of ifs. In the end, i call the bindingsource EndEdit, and call the adapter Update command against the datatable...
This sometimes works others not really, i don't understand why.
The error it's: "Concurrency violation: the DeleteCommand affected 0 of the expected 1 records"
The next step is I need to build a randomizer to randomly select a row and read the columns of that row into varibles.I have a working randomizer that can randomly pick a number between min and max values but what I don't know if how to select a row / How to find out how many rows are available and how to read the values into varibles.Am I right in declaring an Integer Varible then using:
AvailableRows = DDT.Rows.Count
Then use my Random Function to pick a number between 0 and AvailableRows
I load up a datatable - bind it to a binding source and a binding navigator - and lots of textboxes on the screen bound to that as well.When I get a concurrency violation - another user has already changed my vendor, let's say - what is the best method to go about refreshing the datatable with current data from the DB?
I have a Business Logic Layer that contains function that return datatables. I'm writing a function that will return just the records that begin with the string passed in. this is what I've come up with so far:
Public Function FetchBusinessAreas(ByVal area As String) As List(Of BusinessArea) Dim AreasList As New List(Of BusinessArea) Dim dt As DataTable
my .net app output data from sql server to a datatable in my app using executreader.for example:one of the column size in sql server varchar(40),actullay the field only contain 2 chars (like: "AB" for example)when it executes into datatable,it display in the column like "AB" <<this chars + white space = actual size of the column,but I want only the size of the data only, which is "AB" when I export it as csv file the field is >> "AB?
I need to represent the following query using LINQ:
DECLARE @PurchasedInventoryItemID Int = 2 DECLARE @PurchasedInventorySectionID Int = 0 DECLARE @PurchasedInventoryItem_PurchasingCategoryID Int = 3 DECLARE @PurchasedInventorySection_PurchasingCategoryID Int = 0
[code]....
Now, I know that a query in .NET doesnt look like this, this is my test in the SQL Design Studio. Naturally VB.NET variables will be used in place of the SQL local variables.My problem is this: All of the conditions after "WHERE" are optional. In that a query might be made that uses one, some, all, or none of the conditions. V.PropertyID and V.Value can also appear any number of times.In VB.NET I can make this query easy enough by simply concatenating strings, and using a loop to append the "V.PropertyID/V.Value" conditions.I can also make a Stored Procedure in MS SQL, which is easy enough.However, I want to accomplish this using LINQ.
Ive managed to dynamically create a form, and dynamically create a timer, but i have not been able to create the timer on the dynamic form. Specifically, i need to be able to have the timer itself create another form with a timer. (I realize that this would create a new form every interval on the timer, that is what i want to do)
1. A way to add the timer to the dynamic form, and maintain the timer sub on my main form.
2. A way to create the whole thing over (dynamic form and timer) through the previous dynamic form and timer.
I was thinking i could use a collection/array to store the forms and timers, but i'm still having trouble figuring out how to add entire forms or timers into a list. (A timer is not considered a control, so i cant use a controlcollection...)
Heres my code;
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim frm As New Form
[Code]....
*EDIT* Btw, my idea was to use i as a variable that increases every time a form is created, then insert the form into the array, with i as the integer. i just need to know how to create a new form with a different name each time. (as with timers)
I'm trying to do a LINQ Query against a typed datatable that will return me duplicated data.With out going into too much detail, here's the basic setup:
strCode1 - string type intCode1 - int32 type intAdjustor - int32
There are more fields but these are the ones that are important.I'm going to do my best to describe this, as it's kind of confusing.In theory intCode1 is a key for strCode1 (hence the names). So each time intCode1 is duplicated, the same strCode1 should appear. Example:
[code]...
Ultimately I'd like to get a List(Of T) - where T is my typed data row. In SQL, I would simply use a sub query, to get a distinct list of strCode1 and intCode1, then do a count, grouped by strCode1 where I get more than one row.I'm not sure how to translate that into LINQ, AND get the original types data rows returned in a list.
I am updating a data table (dt_report_crypt) from an encrypted csv file in the code below:I decrypt the colums and update the same dreport_crypt, such that it will contain de-crypted data.This part is working wellI however need to use this de-crypted datatable as a data source to update a second table(dt_report), using the sql SELECT command to filter relevant data,
Dim dt_report As DataTable Dim dt_report_crypt As DataTable Using cn As
I'm using the 2008 express edition. Now, I created an application that will allow the user to choose transaction in the combobox.text and input its price and quantity using an textbox.text. When the user click button1, it will be push in the datagrid/datable I created. And when the user click the button2, it must be save to excel file. The only thing I need is how to save the data from datagrid/datatable to excel. This is my code.
I have a vb.net form to add, modify or delete the product list..i have a datagridview in which i m loading data from sql server datatable...now i have a text box which accepts code for the product..i want that when i press a key, all data starting with that key should be highlighted in datagridview.....
eg i have product codes A001 A002 A003 C001 D001,, etc..
Now i press A in text box...in datagridview all data with A should be highlighted
I've created a new ASP.NET Dynamic Data website and have used LINQ-to-SQL for the framework. I start up the application and it displays my tables fine and I can browse them - but it doesn't give me any create/update/delete abilities - all I can do is read? I didn't change anything from the defaults - what gives?
Which technology should I use for data access layer?What's the best way of connecting to a dynamic data source and binding the result to a grid?I'm writing a little web app that user can define connection string and table name (MS Sql Server) and the program will display values in that table inside a grid.We must use datasets (because of dynamic data source) and generate the query as a text command ("Select * From " + TableName).We don't have a model (data source is defined by user at run time) so we can not use EF.
[URL]..And put into a dynamic array where each month represents a record in the array with 3 given with C/P, Strike and Settle
The criterion is for every month grab all C/P that have matching strikes thus returning the following for every month. See data below and what I would like to return below. Want to use excel VBA to return the values from array into a sheet in excel. See data below
I have a form that builds and populates dynamic text boxes from parsing a file. There is a "Last Name" text box that when populated, also labels a tab page with the name. After the form is populated, the user can change data as they desire but I was wondering how to update the tab page text when the user updates the last name text box? All the controls are built in code.