I have a datasource attached to an Access DB. I have a problem if I remove a datatable from my datasource(which contains lots of datatables). I have to manually remove the reference to that datatable from the designer file for each form that uses the dataset.
View 6 RepliesI am using VB.net.
I have a gridview with a datatable datasource.
What is the best option to update the datatable when i delete a row in the gridview and then show the gridview without that row?
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
using vb.net/asp.net 2008question: i found this c# code snippet and wondering how do you do this in vb.net?DataTable dataTable = gridview.DataSource as DataTable;
View 1 RepliesI am using code similar to this to populate a combobox with items from a database. The display works fine, but when I try to get the combobox.SelectedValue it is returning a DataRowView, where I need an integer. Obviously this is becuase I haven't casted the value to an integer, but the function, CInt(cboPosition.SelectedValue) is throwing an InvalidCastException. Is there any way that I can get the ValueMember's type to be an Integer?
Dim cn As New SqlConnection(CreditDisputesLogConn)
Dim cmd As New SqlCommand("CustomersLookup", cn)
Dim da As New SqlDataAdapter(cmd)
[Code]....
How can I get an item value from a Combobox using a datatable as it's datasource? Here's my code for constructing the combobox. This code works, that's why I'm not showing it all, but I want you to know how I'm creating the combobox.
Try
query = "SELECT category_id, name FROM categories ORDER BY name ASC;"
dbCommand = New MySqlCommand(query, dbConnection)
[Code]....
I want to display what is the item you physically see in the combobox that you select.
Can you tell me how to syncronise the a DataSource when inserting a new row into a DataTable? [code]The user enters values in the Textboxes and clicks a save button.At that point I get a concurrency violation when using .Update to get the new row into the database.Can you tell me if I need to add any more code to synchronise everything?
View 2 Replies[code]My question is how can I remove xStopBits(0) before setting the DataSource?To get around this I currently have a check in the ComboBox1_SelectedIndexChanged event.
View 14 RepliesLet's say that I have a DataGridView(myDGV) which I populate as follows:
'...
Dim strSQL as String = "SELECT col1,col2,col3 FROM myTable"
'....
myda.Fill(myDtb)
myDGV.DataSource = myDtb.
'The above code fills the DGV with data from the underlying query
'of the DataTable.
'Supposing that I want to add an unbound Column to the end of the DGV which appears together with the data returned by the query, is it possibe?
Dim GridDTB as Datatable[code]...
It is updating only on the table "DT3", which is last create table in the array.
i need to query the datatable & set the outcome as datagridview controls datasource
vb.net
Private Sub Txt_Search_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Txt_Search.TextChanged
'routine objective:- Filter datatable & set the datagridview datasource
[code]....
Keep getting this error. Using ASP datagrid Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
CODE:
I have binded a datatable to a combobox, using DataSource, DisplayMember and ValueMember properties. Now I try to set the combobox to a preset value using comboBox.SelectedValue = value. Nothing happens however.
[Code]...
I have a base form and I am trying to get the DataSource of the ActiveControl if the control is a datagridview.What I have so far is:
Dim curControl As Control = Me.ActiveControl
Dim ControlType As String = curControl.GetType.ToString()
If ControlType = "System.Windows.Forms.DataGridView" Then
[code].....
I'm trying to setup a form to search for data within an existing DataTable.
FilterColumnsComboBox.DataSource = WOTable.Columns?
FilterColumnsComboBox.DisplayMember = ???
FilterColumnsComboBox.ValueMember = ???
[Code]....
I could hard-code in the column names ("WO_Number",WO_CustID","CustLastName", etc...), but would prefer to pick this up dynamically (partly because I want to reuse this code later).
I want to know how to perform row delete to datatable which is a datasource to the grid.
In details: I have a datagridview (dg) and its datasource is set to dtItem. User will select some rows in dg and press 'delete' button.
dg.DataSource = dtItem;
I will perform a loop and delete the records. Here is the code eg:
foreach (DataGridViewRow drw in dg.Rows)
{
if (drw.Selected)
[Code]....
The problem is it didn't delete correctly. If user selects row index 0 and 1 in dg and delete it, it will delete the first one correctly and then finished cuz no more row is selected in next gridviewrow.
I tried google and didn't find what I want. may be because i don't know the correct keywords I should use to search.
I have a simple application that uses a database to store usernames and passwords.I have a hidden control that, when activated,should clear all usernames and passwords from the datatable.Then, one admin account is added. I have tried the datatable.clear method BUT while it throws no errors, it doesn't clear the datatable.I have also tried the datatable.reset method, with the same problem. I am now trying this method:
Dim row As DataRow
For Each row In Authenticate.Logins
row.Delete()[code]....
I am trying to delete rows from datatable using code below,
View 10 RepliesI would like to remove the first 2 columns in the datatable if the first character is not numeric. Here is my code so far.
For Each DRow As DataRow In aTable.Rows
Dim cRow As String
cRow = DRow.Item("Column 4").ToString()
[Code]....
_CheckPayees = ds.Tables("Payees")
_CheckPayees is a DataTable variable. After it is set with the code above, I would like to go through it and remove duplicate rows from it. These rows have to be exactly dupes though, say two columns have matching values however another one doesn't, that's not considered a dupe.
I have a table with many values inside of it that might have single quotes around them. I need to create a duplicate table without those single quotes. I can't modify the original table as I need to use it, 'as-is' later.
I've done this with a table.Clone and using a foreach to loop through the rows and columns removing single quotes as I need and then putting that new row into the new table. It works and it's straight forward.....but
I'd like to do the same thing using LINQ. This was my attempt....
Dim myResults = From myRow In dtTable _
From myItem In myRow.ItemArray _
Where TypeOf myItem Is String AndAlso _
myItem.ToString.StartsWith("'"c) AndAlso _
myItem.ToString.EndsWith("'"c)
I had trouble finding examples that weren't looking at a specific column in the DataRow. It looks like my code does pull back all the matching results - but I'm at a lose for how I can create a duplicate table/modify the values?
The only requirement is to not using a For Each; as I already know how to do that. I've gotten closer - but I still can't seem to create a new row or a new table.
My new approach hits a dead-end when I try to do this:
Dim MyNewRow As New Data.DataRow With {.ItemArray = myRemovedQuotes.ToArray}
The Error message I get says, "Error 1'System.Data.DataRow.Protected Friend Sub New(builder As System.Data.DataRowBuilder)' is not accessible in this context because it is 'Protected Friend'."
I'm pulling data from my DB, adding it to a DataTable and binding that DataTable to my DataGridView. Before I bind the data, I need to change/remove some data. When I loop through the rows and use a Select Case, just for this column, it doesn't work. But if I use an If, it works fine. [Code] In the example above, the "Pass_Flag" row works just fine, but the "FailureCD" does not. But after the Select, with the If statement, it works. In the example, I'm casting the row as a string first and then an integer. I tried casting to an integer in the select case and it doesn't work either.
View 4 RepliesMy application must display some data in Datagridview (status of COM ports communication) and i Used .mdb databases before for faster search and Datagridview update. How i understand Datagridview is importing data from DataTable and data in DataTable is imported from .mdb file, so i decided to make shortcut - stop to using .mdb file (data must be erased every time application start and it is useless make .mdb file and erase it every time, becouse it is increasing even when drop is used) and using only DataTable..
I want to row in Datagridview change it color to red when it's Collumn(6).text countains %error% string..
When Error in COM port is starting, i can fast find row in DataTable for that port and write information that Error accured for that port and DataGridview automatically updates:
Dim RRow as () DataRow
RRow = ds.Select("Port = 'COM3')
RRow(0).Item(6) = "Error Opening COM3"
I use vb.net and windows form and sqlserver
I added Data Source(Microsoft SQL Server (SqlClient)) to my project. and now I need to change it to ODBC Data Source .
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
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 am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I came across a problem with using a BindingSource as my DataGridViews.DataSource. Whenever I applied a filter to a column in the BindingSource and the user makes changes that don't match the column filter the DataGridViewRows would automatically disappear. A similar thing would happen when applying a Sort to a column. If the user made any changes the DridGirdViewRows would automatically sort causing rows to be moved around. This was not ideal for my application and there isn't anyway to stop this from happening with the BindingSource.
To correct this issue I have to use subsets of data. I use a DataView to apply the filter and sort to the main DataTable, which creates the subset DataTable.The problem is when I use the DataView.ToTable method I loose the Primary Key and RowError information. So I have to reapply this information everytime the user filters or sorts the DataGridView.Is there a better way to get a subset DataTable?[code]...
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
Just had to remove remove statics and use Delegates refering to class. i have got a little problem in one of my project.I need help to resolve it.My application Connect several FTP server with the same Class.I'm using TCPclient for few specifics Commands.The problem : All threads call the same TCPclient wich can't connect several server at once.I would like to create a New TCPclient for each thread.
[Code]...