I am trying to create a stock scanner which allows users to filter stocks based on multiple criteria that they select. Like the following example with 2 criteria:
Criteria 1 Filtered Result: StockA, StockB, StockC, StockD
Criteria 2 Filtered Result: Stock B, Stock C, StockE, StockF
SCANNER RESULT: Stock B, StockC (ideally this result would be displayed in a GridView)
[code]......
I'm using this function to return a value from multiple databases across three SQL instances (On the same server). I'm looping though a DataGridView that lists all the databases on one of the three SQL instances.Is there a faster way of doing this? It's quite slow using this method.
Function DatabaseStatus(ByVal SQLServer As String, ByVal Database As String)
Dim myConn As New SqlConnection("Server=" & SQLServer & ";User Id=USER;Password=PASSWORD;Database=" & Database & ";")
Dim Status As String = ""
[code]....
I've been searching all day about this and can't find a solution..I'm fairly new to VB and SQL Queries, so I apologize if I sound a little daft.Basically I'm working on a project in VB 2010 where a user can add new teams, players, also create matches between teams and record the score. I have done nearly all forms, but now I need to show data from 2 tables on one form and the method I used for 1 table doesn't work.I have 4 tables:team, player, match & matchdata and they are linked like this:
[Code]...
Every table I have has an 'UpdatedBy' field which lists the user who last made an update to the record. I need a way of searching every datatable for that username and returning the count of the rows where the LastUpdated field is equal to a parameterized username. How can this be accomplished without writing a seperate query for each datatable that does the same thing and running each query one at a time? I'm not sure if this can accomplished somehow in the dataset itself or if a SQL Function could do this.
View 2 RepliesI'm not even sure what I'm asking is even possible, but here goes:
Is there a way to loop through a sqlDataAdapter to find multiple tables?
Currently I have a module that you pass in an object and it automatically fills the parameters of a stored procedure with the values of the object. It works great, except when the stored procedure returns more than one table, it only returns the first one.
Here is what I tried to get to that second table:
Dim ds As New DataSet
Dim table As New DataTable
Dim reader As SqlDataReader = command.ExecuteReader
[Code].....
I am using Microsoft Access database. Since Access Database Table cannot have more than 255 columns, I am using vertical database partition technique where I have splitted informations into 5 different tables. Each table has 100 columns, and first column is primary key. Now I need to read data from these five tables so that I can export it into Excel file.
[Code]...
I have been searching for quite a while about joining multiple datatables via LINQ to dataset (When i say multiple, i don't mean just 2!!!), and it seems there aren't lot of examples in the net. I have seen examples of joining two datatables, done that, no problem there. Now i want to join three datatables. And there's nothing i can find out there.For example i have a 3 datatables:
PERSON (columns: person_id, name, gender_code, ethnic_code)
GENDER (columns: gender_code, gender_description)
ETHNICITY (cols: ethnic_code, ethnic_description)
[code].....
I'm having a hard time joining 2 datatables and have the joined datatable as result. First datatable (labels) holds data including a printerid. Second datatable (printers) holds printer references (id > unc). I would like to have as endresult (joined) a datatable with all data from the first datatable with the field (unc) of the second datatable. [Code]
View 3 RepliesHeres my issue, I am retrieving data from xml and populating a DataSet with the results into multiple DataTables but i have an issue where an item is repeated in my input data and it is causing it to exception because of the constraints imposed between these tables. how can i determine if a row exists prior to adding the DataRow and thus not include it in my DataTable?
View 1 RepliesI'm creating an application that will export several datatables into a single Excelspreadsheet, but on different sheet names. How can I do that?
View 2 Replieshave a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).I get this error when trying to send a query to a database. Its an access 2000 DB. Google suggests the error indicates that I am using a vb keyword as a field name or table name. I have checked with these here and can't see anything that matches.
View 6 RepliesI'm using VB.net for a project i'm building for a friend. He has access to data on all the schools in our country and also data on the local area Authorities which run these schools. I have a database with two related tables; 'TBLlocalauthority' and 'TBLschools'. Each localauthority can have several schools, but each school can only have one local authority.
[Code]...
Is there a particular class in .NET available that will allow a user to query IIS to see what websites are running on the local server? I would like to try to write a simple program that programmitically lets me know which websites are running in IIS along with some basic information about them. Can this be done in VB?
View 3 RepliesWhenever I have
Dim catID as integer
And I use this in a query like this:
cmd.CommandText = "select * from categories where parentid='" + catID + "'"
I get:
Conversion from string select * from categories where p to type Double is not valid.
Why is it so?The parentid datatype in sql is integer.
My form has a DateTimePicker and a DataGridView on it. I need to have it query a SQL Server DB and return the table to the DGV. The query is to search the Date_Joined field for date less than the date that the user input with the DTP. With the code below, my DGV is populated with all data and not the filtered data I need. I also have added a Go button for the purpose of execution instead of using the ValueChanged sub for the DTP.
Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
Dim query As String
'dtpDateJoined is a DateTimePicker on the form
[code].....
Is it possible to re-use a DataTable in .net? Here's an example from code-behind:
[Code]...
I have some sql statement error while querying the DB and to display the result on a data grid view. Could someone check the codes below and let me know the problem with the codes.
Dim cm As New System.Data.OleDb.OleDbCommand
Dim rd As System.Data.OleDb.OleDbDataReader
Dim Conn As OleDbConnection
[code].....
I`d like to do a query to a SQL server database using the statements like "SELECT...FROM...." an so on. Then I`d like to save results of the query to an array or other variables. I`d like to handle the data of the query results "manually". I don`t want to use the datagridview and tableadapters and so on which are created when I drag a table from the datasources window to the form. is the ADO.NET and datasets the right tool at all? If yes, I believe these are the first steps needed:
- create a connection string
- create a connection and open it
- create a dataadabter
- create a dataset and populate it with the dataadabter
The first problem is the connection string. When I create a connection to a new data source in datasources window, a string is created and saved to some configuration file. Can I use it and how?
Basically for normal select queries from my database I have no problems as I would put the following and then bind it to a controller to display the iteam, however now I am trying to query sum of a field from the database, but I think it should be different as It's giving a Nullable value:
SELECT SUM(PointsRedeemed) AS tAward
FROM [Transaction]
WHERE (BusinessId = ?) AND (CardNo = ?)
[Code]....
the remaining code for my vb.net project? In my Project, I have a table name tblBatch that has a field name btchGravel. Since in my project, a field name gravel has more than 10 inputs from the 10 textboxes in my main form. I manage to save it in this manner:
'Save the textboxes in a single string, separated by comma
Dim GravelLine As String
GravelLine = txt1G.Text & "," & txt2G.Text & "," & txt3G.Text _
[code]......
Given the following XML file:
<users>
<user name="admin" password="foobar" roles="Admin,Guest" />
<user name="guest" password="foobar" roles="Guest" />
</users>
How do I find a specific node? In this case I want to find the node that has its name attribute to be "admin"
Dim authGroup As XElement = XElement.Parse(myXMLDoc.OuterXml)
Dim foundUser As IEnumerable(Of XElement) = From i In authGroup.Elements Where i.Attributes("name") = "admin" Select i
[Code].....
good afternoon people, i got a problem here on my program, i need to query from a different tables in database but it gives me error, here is my code
[Code]...
vb
Dim conn As New OleDb.OleDbConnection(ConnStr)
conn.Open()
[code].....
I have a DataTable filled with employee names and hours. I want to query that data to make a list of all the unique employees and the total hours for each, but I don't know how to do that. If I were to query the database directly I would do something like this
View 6 RepliesI have been looking into dynamic querying of datasets and the use of copytodatatable() for a project. I have seen in alot of forums that the copytodatatable functionality is unusable as it was removed. have an example of a dynamic Linq query being loaded into a datatable.
View 1 RepliesHow do I return a top 5 with rank number using linq?
Dim Top5 = From A In DAO.Cache.Select(Of VO.Empresa).Take(5) Select A.Nome
I would like this result:
Rank Name
1 "Example Name"
2 "Example Name"
3 "Example Name"
4 "Example Name"
5 "Example Name"
querying a remote Access database! We are currently using this because thus far we have failed at hooking up a sp_linkedserver. I feel like it's a terrible hack and want to be done with this whole network mapping business once and for all!
[Code]...
I am querying a date from my Access 2007 database in the format: MM/DD/YYYY It's then saved as a string
Depending on the month and day, it might be 1 or 2 characters. To set the DateTimePicker, it takes it as this format: DateTimePicker.Value = New DateTime(YYYY, MM, DD)
How can I switch around the characters in my string so that it can satisfy the format the DateTimePicker wants? I was thinking about some kind of reader that "consumes" characters until it reaches a delimiter ("/") and then does something with it. I remember doing that in JAVA but not in VB.NET
I am having a problem saving related tables and querying them. I have both data binding sources on the form and I have both being added, end edit, and both being saved. When I "view all" and click on the related table "crimes" they're not showing with the Inmate that committed them. I have gotten it to do this with a code similar to that below and I am wondering what I'm doing wrong so that the datagridview for crimes will display the correct crimes for the correct inmate. The primary key for inmates is DOC# and the Primary Key for Crimes is "Entry ID"
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Me.Validate()
[Code].....