I have this code so I can grab the values ind the dataset before i bind it.can't get the dirctcast to work
dim ds as new dataset("Mytable")
gridView.DataSource = ds
Dim dataRow As DataRowView = DirectCast(ds.Tables.Item("MyTable").Rows(), DataRowView)
Dim ID_Equipamento As String = dataRow("ID_Equipamento").ToString()
Dim ID_Password = dataRow("ID_Password").ToString()
I'm having trouble locating a specific value in a dataset.
I have a datatable with 2 columns... "TaskName" and "TaskID" ...I need to look against the dataset using a "Task Name" to return a "TaskID"
on button click...
dim dv as new dataview(ds.tables("TaskTable")
dv.sort = "TaskName"
dv.RowFilter = "TaskName = '" & Textbox1.Text & "'"
Textbox2.text = dv.item(0).toString
This doesnt work, and I don't really want to use a dataview object when I'm not publishing the data to a datagrid or anything like that..
I have made a small "front-end" application for an Access databasefile.
I set up 3 tables with relations in Access, and added the database as a datasource in my project. I have done no database programming, and the app has worked nicely for about 2 years. It's a simple master-detail form with 2 datagridviews dragged from the datasource window.
Yesterday I opened the project to add a new form. The form is just a "setttings form" with no database activities.
When I press F5 - the main form do not start, and I get the error message "DataMember property '{0}' cannot be found on the DataSource." - where the property name is the name of one of the 2 relationships in the datasource.
I pass it a valid dataset that has the department name and the Department id as a number..20, 40, 30..... I want to get the department number.. I pass it HR(which is in the ds.table) but I am getting an error on the rows.find() "Input string was not in a correct format" it is a string.. what else could i be doing wrong here...
Public Function GetDeptID(ByRef ds As DataSet, ByVal strDepartment As String) As Integer
'Dim dr As DataRow
' Check to see if date is already in the table
[code].....
How to find record on a table using dataset?
View 2 Repliesi have a dataset and i want to create a textbox and a button that once you click on it it will search for the word in that textbox in the dataset, for example like in sql with the "LIKE %xxxx%" format.
here is an exapample:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim dr As DataRow()
[Code].....
i have a situation where I need to search a table for a specific record that matches an ID number the user will specify. I know 2 methods to accomplish this. The first would involve writing some VB.net code that would call a TSQL statement and return the value through the return parameter. The second method would involve creating a dataset and populating it with a select statement.
View 2 RepliesWhen i load my database i load it into a DataSet.When i search the database i load the results in to a DataTable.I want to find what index a search result has in the DataSet.When navigating the dataset i can use this code to get the index ds.Tables"Filmer").Rows.IndexOf(ds.Tables ("Filmer"). Rows(inc))But i can't make i get the dataset index of a search result from the DataTable.I thought that i could use the same code when navigating the DataTable, but it only returns.
View 3 RepliesI've got a databound query in my application which is querying the "Customers" table in our database.I've created this directly from the ComboBox's datasource creator in the Design view.Various bits of code created in the designer include:
Me.CustomerBindingSource.DataSource = Me.CustomerDataSet
Me.ComboBox_Customers.DataSource = Me.CustomerBindingSource
What I've done in the first stage of developing this feature is to show my users a ComboBox showing a specific subset of the customer list by applying a filter to the BindingSource.
Me.CustomerBindingSource.Filter = "someColumn = 3"
What I want to do on a second pass is to allow the users to type a specific bit of information into a textbox and check whether it appears in Me.CustomerDataSet like so:
Dim x As IEnumerable(Of CustomerDataSet.customerRow) = From cust In Me.CustomerDataSet.customer Where cust.custno.Trim = "test"
If x.Count <> 0 Then
At this point, I have a customerRow object. I want to check whether this customerRow object appears in the list presented to users in Me.ComboBox_Customers via the filtered Me.CustomerBindingSource. Me.CustomerBindingSource does not (directly) contain customerRow objects, it contains Object objects.How do I find out whether Me.CustomerBindingSource contains the customerRow object at whatever lower level?Also Once I've determined that Me.CustomerBindingSource contains the item, how do I select that entry in the ComboBox?
I working on a VB.NET project to manipulate a VB6 form using COM Interop. Some of the controls on my VB6 form are indexed and some not, so calling ctl.Index fails on those that have no index. Is there a way to work out if a control is indexed?
View 1 RepliesI have a DataGridView with 4 columns which I transfer toa dataset - this works fine, i posted the code belowHowever I adde a CalendarColumn into my DataGridView but this doesnt transfer over to my dataset.Does anyone know how I can add this Calendar column onto my dataset along with the other 4 columns?
Dim col As New CalendarColumn()
Me.dataGridView1.Columns.Add(col)
Me.dataGridView1.Name = "Trip Date"
[code].....
How can I connect Dayview Calendar control to my strongly typed dataset I can add appoinments to the control, but dont know how to hook it up to my database.I am using vb express 2008
Code to add appointment:
Private Sub btnAddAppointment_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddAppointment.Click
Dim m_App As New Appointment
m_App.StartDate = Me.DayView1.SelectionStart
[code]....
I have a datagrid that I use to display data from a SQL 2000 table. I am trying to write back any changes the user makes to the datagrid data back to the original table but don't know the proper method to do this.
[Code]...
I have an app that downloads from a networked SQL database to a dataset and also to an XML file on laptops. Laptop users will take their executable and the XML file which the local dataset will read.Although I can get gridviews etc to bind to that dataset syntax such as
"TextBox1.DataBindings.Add("Text", ds, "fname")"
I have an aspx page that has two different user controls. I want to find user control A and be able to set properties, etc., from user control B.
I was thinking I could do something like this:
Dim CMFilters As Control = Me.Parent.FindControl("CMFilters")
...but that doesnt work to be able to set properties and call methods. I somehow need to get the user control and and declare it as that user control type.
i'm trying to do some appointment book so i decided to use MonthCalendar control and date changed event for choose the date i tried dataset.table.rows.find() function on other tables which have int primary key and it works its finds my row/s i need but when i tried this func. on date type primary key it cannot find i tried to search with date type ==> fail search with string type like 03.07.2012 ==> failed etc.
View 3 RepliesI am using Visual Basic 2008 Pro. I am trying to figure out how to bind a set of column headings in a DataSet (or DataGridView) to a ListBox. I want to show the column headers in the listbox control (not the data), and allow users to select one or more items
View 4 RepliesI wanna know if the user is holding the control key or not...there was a class for all this, what happened to it? where did it go?btw wasnt there a way to get information about hardware, such as monitory, keyboard, etc using the .NET classes?
View 8 RepliesHow do i search a dataset or datatable for a record by entering 3 values in the search. If the row exists, I want to amend some of the data in that row?
View 1 RepliesI think my subject sums up what I am interested in knowing. I am looking to create a chart where Series1 is from Table1, Series2 is from Table2 in the given Dataset. My code below doesn't throw any errors, but it appears to be grabbing the data for each series from the first table.
Imports System.Windows.Forms.DataVisualization.Charting
Public Class Form1
Public Sub New(ByVal ChartData As DataSet)
' This call is required by the designer.
InitializeComponent()
[Code] .....
I have a control into a html div in this way: <div id="FilesUploadedAttachment" runat="server"></div> that's part of a page called Donations.aspx)that allows you save info, (this page have a master page) After fill all needed fields, the user can attach a document pressing a image button and the document (link) appears in the control "FilesUploadedAttachment". When the user press save button I validate all required fills git a routine called ValidateFields in ohter module. The problem is that i need validate if exists something into this div, but until this momment i can't find this control, only can find the controls of the master page but no the rest so first, is possible do this and if is possible, how i can do. I let you the routine that i have been used for do that. I'm using IE6 and framework 2.5
(html)
<tr>
<td colspan="4" style="border-bottom:None; width: 239px;" >
<asp:Label id="LblAttachment" runat="server" cssClass="LabelFormat" Font-Names="Arial" Font-Size="8pt" Enabled="False"></asp:Label>
[Code].....
I am trying to convert some old VB6 code to VB.NET. The VB6 uses a Canvas control, simply
Dim cv as Canvas
I cannot for the life of me figure out how to use the Canvas control in VB.NET (using VS2005). MSDN says it is in the System.Windows.Controls namespace, which doesn't seem to exist? All I see is System.Windows.Forms, which doesn't include the Canvas control.
My page has a DetailsView that has a hidden field in it that gets referenced by an SQLDataSource to populate a different field in the same DetailsView. I cannot get the codebehind to find the Control, no matter how many different ways I try. I really need to be able to show the TEXT field which is associated with the dsPicklist SqlDataSource. I have marked the code that is causing problems.
<asp:Label ID="Label1" runat="server" Text="Select Survey:"></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="dsSurvey" DataTextField="SurveyName" DataValueField="SurveyID">
</asp:DropDownList>
[Code].....
i cant find the control txt which is a textbox in the repeater i have used the following on rgroups itemdatabound event
[Code]....
I'm trying to find a control in a page. The Id is available as a server control (CheckBox) This throws exception "not able to convert string to double"
Dim taskId As HtmlInputCheckBox
i =10
taskId = Me.FindControl("chkTaskOption_" + i)
taskId.Checked = True
How to find out which Control the Panel currently contains.
If I show my forms through a panel , then how can I find out which form the panel currently has ?
Where can I find the slider control that i used in vb6... is there one for VB2010?
View 6 RepliesI am writing a .NET DLL to iterate through all controls in the a VB6 Form passed byref.So far it seems to work VB.NET code:[code]but the TypeOf operator does not work. Is there another way to find the type of control?
View 2 RepliesI am making a wpf application and cant find the timer control.
View 4 RepliesI have a simple gridview that contains a label in one of the rows. I'm trying to access that label in the RowDataBound event, but for some reason I keep getting a "Object reference not set to an instance of an object." error on the line where I am using FindControl.
I've tried using "gvQReport.FindControl", "e.Row.FindControl", and "Me.FindControl" but nothing works.
[Code]....