I'm trying to populate it with the results from a table in a dataset, something like Dim MyStringArray() as string = {Me.MyDataset.MyUsers.Rows.Tostring}. So I would end up with, StringArray() = {"Bob", "Jane", "Sally"}. I know I'm missing something very simple but I'm just not getting it.
View 5 RepliesIm using a combobox that bound to a DataSet. The Dataset retreives it's values from SQL.
I can retreive the values fine. However only displaying (1) Column. Which is fine.
Here's where it gets complicated for me. The dataset has 2 other columns that get filled. I need the resulting columns to be sent to text boxes when I select a value from the combobox.
How could I add array values and populate the results in a specified text box?Then repeat for each line after. Then get a final total.
For example:
1 2 3 4 5 (15)-text box
1 2 3 4 5 (15)-text box
2 4 4 3 5 (18)-text box
-----------------------
(48)-text box
why I cannot populate the data grid with the results of my loop>
Public Class FormInput
'The disabled close button declarations;written by Achmad Zeanuri
Private Const MF_BYPOSITION = &H400
[Code].....
I'm having a devel of a time getting what I figure is something simple to work.
I need to set up a Combobox where the list of items is created by accessing a stored procedure.
The SQL code is simply (I left off the code to create the sp);
SELECT ItemCode
FROM vw_CodeList
GROUP BY ItemCode
ORDER BY ItemCode
populating a Listbox control with the results of a T-SQL query in VB.NET? Here is some code to start with:
Dim myconnection As SqlConnection
Dim myda As SqlDataAdapter
Dim ds As DataSet
[Code]....
I do however have a slight background with VBA particularly with MS Access, so I am not completely lost.I am recreating my Access database application in VB.net.I created a new project and added an Access database through the wizard, which automatically created a dataset for the database. On one of my forms I have, esentially, a search form. What I want to happen is have a text box, and as I start typing display a search result from my customers table in the list box under it. So for example, I type "A" and all customer names that start with "A" are displayed in the list box.I continue typing with a "p" (full string is now "Ap"), then all customer names that start with "Ap" are displayed and so on...
I did search on my own first before posting this and found a few tips but cant really get it to work the way I want. This is what I have... I know I would put this code in the keypress event of my test box, but just until I get it working I attached it to a button to search. (I basically got this online and not even sure its the correct usage.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Create a dataview[code].....
The item in red is where i get an error. it sucessfully builds and i open the find form enter a last name that I know is in the customers table, but I get the error "Cannot find Column ["whatever name i typed inthe text box"].So first of all is this the correct way of going about what I want to achieve?If so how can I get it to work?BTW the next step for the user would be to double click the customer in the list box they are searching for to open the customer Details form for that customer, so I would need an ID or Index attached to that item to be able to open that record in another form.
I've populated my DataTable will all the results from a SQL search. Upon a button click I want to populate a combobox with all the results where a condition is met. My DataTable as a column called UserID and I want to add all results where the UserID is equal to a set value (for example 12). I can do this to add all results and I guess I could add a if statement inside this to be If Entry.Tag = 12 Then but is there a better way?
[Code]...
I want to populate my table in datagridview from my access database table
I'm not just trying to bind the table in access to my datagridview...I want to put the data's in my access database to my table in datagridview
so far this is my code.....
Sub filldatagridview()
Dim conn As OleDb.OleDbConnection = New OleDbConnection(strConnect)
conn.Open()
[Code].....
compare two strings is equalto and remove element in both and get remaining element string using vb.net
View 2 RepliesI have this code to return a list of fund sources for our organization.
Dim FundSourceList As New List(Of FundSource)
Dim fs As New FundSource
If results.Count > 0 Then[code].....
The problem is that when I loop through the resulting FundSourceList all it shows is the last value. For example, if I have three fund sources (state, federal, athletic), then when I use this code to loop through all I get listed is athletic, athletic, athletic.
For Each FundSource In FundSources
Debug.Print(FundSource.FundDescription)
Next
So I change the code to this. I moved the creation of the fs variable inside the loop.
Dim results = From result In dsResult.Tables(0) Select result
Dim FundSourceList As New List(Of FundSource)
If results.Count > 0 Then[code]....
This works fine but now I'm creating a new class over and over again. It seems a little inefficient to me. Can I not create the class outside the loop and use it over and over again?
I have a CheckedListBox with Items I also have a Stringarray which contains values from a DB All Items in the CheckedListBox ar checked, now i like to uncheck all items if there are in the StringArray.
Normaly i would do 2 for loops like Code is only pseudo - so no need to say it would not work this way
I know
' Loop though CheckedListBox
For i = 0 to CheckedListBox.count -1
' Loop though StrArray
For ii = 0 to Ubound(strArray)
[Code]...
I have the following combobox items:
[Code]...
I'm not very good with web services and I'm dealing with one developed internally in Java. This web service requires a Header element named Token with a value (an encrypted string). I've been able to add this "Token" but the service doesn't accept it. This is the request xml my proxy calls generates (proxy class built with WSDL.EXE and modified to accept a SoapHeader external class I wrote to add Header to request):
<soap:Envelope> <soap:Header>
<TokenHeader soap:actor="[URL]">
<Token>[TOKEN VALUE]</Token>
</TokenHeader>
</soap:Header>
<soap:Body>
</soap:Body>
</soap:Envelope>
And this is what the web services wants (this is a xml request made by a java tyest client):
<soapenv:Envelope>
<soapenv:Header> .....
This is the code I wrote:
Imports System.Web.Services
Imports System.Web.Services.Protocols
<System.Xml.Serialization.XmlRoot(Namespace:=[WSDL NAMESPACE])> _
Public Class TokenHeader
Inherits SoapHeader
[Code] .....
I have declared 2 variables as Double in my VB Code. Example:[code]Somerwhere down the code, after some internal calculations, the variables A1 and B1 have attained new values. Example:[code]Do I need to do a conversion of some sort in my program codes ??
View 12 RepliesI'm having a problem with part of my application I'm trying to get the directory entry for a computer object in AD (it could be mutiple computer objects based on whether or not the users passes a wild card for the object name). These names would be added add a child node of the parent node "Computers" in the tree view. I'm just having problems with using the search results...
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim parentCNNode As TreeNode = New TreeNode("cn")
TreeView1.Nodes.Add("Computers")
[code].....
I seem to be having a heck of a time trying to figure out how to add the results from a mySQL query to an array in vb.net. Right now, I only understand that you have to define the dimension of the array, however this is shy of impossible since the dimension of the array will change due to different results from the query. What is the proper way to take my results and put them in an array?
View 12 RepliesI'm trying to write a function which obtains the sequence_number by counting the records in a table that fit a particular criteria and if the result is 0 or nothing sets a variable to 1 but if the result is 1 for instance, the variable will be set to 1 + 1.
This is the code i'm using but i'm not getting the correct result when results are actually returned. For instance, if the result of count is 1, i want "seq" to equal 1 and total (which represents the sequence # assigned to the next record which is entered with the same plan and date) would therefore be 2 which is the result of seq + 1 (i.e. 1 + 1)
[Code]...
I am having a remote server it has INVENTORY DATABSE , and also iam having same databse in my local system. I want to populate by local database table with my Remote database table through Vb.net code by click a button. How to do this .
View 1 Replieshow to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI am trying to update one table with results from another table as such:
Table A (field, type) : Table B
ID (key) Integer : ID (key) Integer
ParentID Integer : IssueID Integer
Number String : ParentID Integer
: Number String
I need to construct and UPDATE statement that does:
Sets B.IssueID = A.ID When B.ParentID = A.ParentID AND B.Number = A.Number AND B.IssueID = 0
Here is what I have so far but it is producing an SQL syntax error (missing operator)
sqlStr = "UPDATE B SET IssueID = A.id FROM B JOIN A ON (B.ParentID = A.ParentID AND B.Number = A.Number) WHERE B.IssueID = 0
I have also tried
sqlStr = "UPDATE B SET IssueID = A.id FROM B, A WHERE (B.ParentID = A.ParentID AND B.Number = A.Number AND B.IssueID = 0)
So hopefully this is a quick fix but for the life of me I can't figure out how to get my results from a OracleDataReader record set.Just trying to get all the users for a specific TNS into an array. I was able to do this easily before with ADODB, but thought I would try using ODP.net.Here is what I have so far and it definitely gets all the USERs for a given TNS. its when I get to the READ() part where the syntax is ??
View 1 RepliesI have created a search form based on my SQL database to search for individual records based on 3 types of criteria. The form is up and running but I want to be able to add some more code. I have assigned Stored Procedure to each click event for each button. What I wantr to be able to do is after value is added to text box and button is clicked if there are no reults to display than a message box is displayed with adequate message detailing this. Also is it possible to add a count of records to the form. Once value has been enetered ij tyext box and stored procedure runs and fills dataset with required data can I display a box to show number of records from this search.
[Code]...
I want to populate my asp:table with the contents from my SQL query. The page loads but with nothing in the table.
<%@ Page Title="stuff"Language="vb" AutoEventWireup="false" MasterPageFile="~/Site1.Master" CodeBehind="stuff.aspx.vb" Inherits="WebApplication1.WebForm1" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Net.Mail" %>
[Code] .....
I have two table called
1.Register product table
2.Sell product table
Register product table consist of (Product Id (txtProdId.text) and Product Name(txtProdName.text)) NB. All are textboxes Sell product table consist of (Product Name(cboProdName.text) and ProdPrice (txtProdCost.text)). NB. ProductName over here is a combobox.
When someone saves record in the Register product table, items should be added into the combobox into Sell product table.
I'm working on a form that has a few data grid views that are populated from LINQ queries, no problem there it works as it should however that sorting does not work. After doing some reading its because LINQ results do not support sorting.As I have the LINQ results already is there a way of copying the results into a dataset or datatable then binding the data grid view to that so sorting will work?
View 4 RepliesI have an access database that is populating a txtbox field on my form..How do I get those results to be currency?do I add code to the form? or do I add code to the function of the tbl? [code]I dont know which side to code or what to code to get the results to be formated as curency
View 17 RepliesI am trying to create a CLR SQL Stored procedure that uses a query and adds the results to a list in VB.NET. Through debugging I determined that my add statement for the reader into the List is somehow converting my data types and throwing an error when I attempt to execute the compiled Stored Procedure.The columns I am querying are Integers
Code:
Imports System
Imports System.Data
[code].....
I have a stored procedure, and I want to save the results of the stored procedure into a table. Is there a way I can do this with a simple query without creating the table beforehand.
View 8 RepliesWhen subtracting two doubles the result appears to be correct but when I save said results in a SQL Server table they are incorrect. I know their are problems with decimal values in the binary world but isn't there a work around for this?For example 421.2 - 418.9 = 2.3, but the result stored in the SQL Server table is 2.29!In the VB code I used Math.Round to round to two digits and the values appear correct during debugging but, as I've said, in the end they are off by .01. [code] decimal(10,2)BTW, I've tried numerous methods of getting the correct value but have not met with any success. I've used Math.Round on Val1 and Val2 separately, after the subtraction, and on the ResultVal. I've also converted the ResultVal to a string using Format(ResultVal, "#####.00") and then back to a number but still the value that ends up in the SQL Server table is wrong.
View 5 Replies