My project contains a DataGridView with a SQL Database Table called Shows. This is a list of TV Shows and I want to apply several filters to it. So I have several different columns to apply the filter to.
1. Completed (bit)
2. Hide (bit)
3. Seen (bit)
4. Genre (nvarchar)
Currently I am using RadioButtons to switch between the queries, but I want to be able to have several filters applied at the same time with CheckBoxes.
[Code]...
I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
I am trying to UNION the two queries below without success.
Dim
ds1
As
New
DataSet
Dim
MyConnection1 As
New
OleDb.OleDbConnection(GetPOWERConnectionString())
[Code] .....
somehow combine the results of separate Fill queries on a single dataset?Basically, I'm trying to implement a 'Filter' function, whereby, the user can filter the records in a DataSet according to specific criteria.
View 4 RepliesI have a form that will have at least 3 seperate sql queries that I want to have submitted with an onclick event.
View 4 RepliesI am trying to figure out a way of combining the below Dim statements into one line and maybe also combining Return dblResult into there. currently it is three lines and I have been told that it is possible but kind of lost of how to do it
[Code]...
How do I combine multiple files into the one file with a new extension. No need to be compressed. So I avoid Zip or similar solutions. (Actually don't want to add third party solutions into my application.)
View 13 RepliesI have three arraylists (datasets and subsets) that I need to combine into one arrraylist so I can databind it to a repeater control and then present data to the user. As far as I know, you can only bind the repeater with one datasource (please correct me if this is wrong) that's why I'm combining these arraylists.Each arraylist has an ID from the database which I can use as a datakey to keep the data aligned. How do I combine these lists?
View 4 RepliesI am using C# and MSAccess as my database.
Code:private void ExecuteQuery(string strempname,string strQuestion,string IndividualRating,string OverallRating, string Comment1, string Comment2,string Comment3, string SessionName) { string strQuery= string.Empty; try { strQuery = "insert into FeedbackDetails(EmpName,Question,IndividualRating,OverallRating,Comment1,Comment2,Comment3,SessionName)"
[code]....
so this actually opens and close connection for every method. but i need to open and close the connection only one time. so how to customize this code to achieve my need. now i am hitting database for 14 times in a button click as of now. instead i need to hit only once but all the rows has to be inserted in my database.i am using MSAccess as Database.
I have 2 queries to run, one after another.
View 7 RepliesI am used to creating a data set with data from one table, for instance:
[Code].....
Now I am needing to add a second table. For instance, my second table "EQUIPMENT" has a field called "DESCRIPTION" that I would like to add to my dataset. The "WORKORDER" table has a field called "EQNUM" which is what the "EQUIPMENT" table uses as the primary key. how to combine these into one dataset?
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 am trying to understand transformation matrices (not just their implementation in VB, but in general) and I've put about 3 full days into this so far. I believe I have the data in my matrices correct. Applying any single matrix to an array of points does a correct transformation.I am wondering if I understand how to combine multiple matrices into a single one.I understand you just have to multiply them together.I took this to mean you just have to multiply each element with its corresponding element in the second to make a third matrix?[code]
View 5 Replieswriting a script to allow the user form to browse to a directory and combine multiple files to one text file. In DOS it would be copy *.* to Text.txt.
I am using Visual Basic 2008 express...
I can use the OpenFileDialog to browse and open a single file but I am unable to use the multiselect option to open multiple files.
all files are parsed in the same place.
I have attached what I have managed so far which included converting the opened file to .txt
I am new(ish) to Visual Basic and i have learned from looking at old VB6 code for programs that have been made for us in the past, this includes using the old ADODB connections and FlexGrids which both have been changed in VB.Net to OLEDB and DataGridView.I have started to understand the way the connections and datasets etc are created but i am struggling to get to where i was with the old code (I am trying to completely upgrade the code from FlexGrid).This is the VB6 Code i am trying to upgrade from:
[Code]...
i am creating a program in vb.net and was wondering if there is a way to perform multiple queries with one button without adding a second button. like i have two text boxes, one is for date and the other is for name. what i want to do is if i hit search and both the date and name boxes are filled, i want it to search for the name based on that date. but if only the name is filled i want to search for everything under that name.This is what i have. right now it only does one search:
[Code]...
I'm building an application that will be using several (7) SQL queries, I'm wondering whats the best way to approach this since I've never built an app with this many queries in it. These queries really won't change, just the start date and end date and I have query in my first form that finds out the next available date by checking a table. What I'm wondering is if it would be better to construct these queries in my application or if it would be better to use stored procedures on my sql server to do the same thing and not have the application carry the load of the queries.
View 1 RepliesI have multiple queries that I need to run when a user clicks a button but they are all separate queries. Can this be done?
View 1 RepliesMi am creating a program in vb.net and was wondering if there is a way to perform multiple queries with one button without adding a second button.like i have two text boxes, one is for date and the other is for name. what i want to do is if i hit search and both the date and name boxes are filled, i want it to search for the name based on that date. but if only the name is filled i want to search for everything under that name
View 2 RepliesI have a rather complicated application (for me anyway). I have a word template setup with text controls. A web app with ASP controls and vb backend code binds data to the text controls using an xml file.
[Code]...
In .NET, Is it possible to run a nested query from two separate Oracle databases?
[Code]...
Ultimately, this is an effort to overcome an "ORA-01795" error from using an "in" statement with over 1000 items in the conditional list, without having to break the query out into multiple "OR value IN" lists.
I am trying to fill a temporary table with one column( a code) with the unique results of three queries of their respective table adapters.I can't figure out how to do it from here.The database is Access 2007 and I have activated the appropriate dataset on the form from which this code executes. The table adapters are part of that dataset.I could try to use the recordset approach, but that means making another connection to the same database.Is that a preferable approach?My purpose in doing this is to build a VB process like the one that works in a VBA Module of this Accessdatabase, partly to help me learn VB2008 and partly to overcome the necessity to keep updating queries used by the module.Code below
[Code].....
I need to loop through a gridview to find records that match items in a different table (in SQL). Is the best method to loop through the gridview and call an SQL procedure on every loop to find matching records? Or should I pull the entire sql db into a datatable and query the dataset in my gridview loop?
'find source ID based on make/model/serial No combination.
Dim cSource As New clsSource()
Dim ds As DataSet = cSource.GetSources()
[Code].....
There is not a VB.net database forum, and there is a HUGE difference (unfortunately) between ADO and ADO.net. I have a connection to a MS SQL database, which I understand is capable of handling multiple SQL statements in one Execution, ie
Using cmdExe As New System.Data.SqlClient.SqlCommand
sSQL = "Delete * from mytable where UniqueID=123;Insert into mytable (UniqueID, Field) values (123, 'something')"
.CommandText = strSingleSQLLine
[Code]....
There are two questions here actually...can I add the parameters before setting the command text, and do I have to add the same parameter over and over again?
I've programmed a vb.net application. This is a matching applcation generates 3 lisboxes. I have written these to a csv files. [code]...
View 3 RepliesHow can I combine multiple *.txt files in a specific directory into one txt file in another directory using VB.NET? (And to delete blank lines at the end of the new file)
I know how to do it in vbscript:
Const ForReading = 1
Const ForWriting = 2
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objOutputFile = objFSO.CreateTextFile("C:logsimportoutput.txt")
[Code] .....
I've made a rudimentary program that combines multiple files into one single file. Currently if I combine two .csv files together the output comes out correctly for what I need, which is a coma delimited file. When I try to combine two .csv files into a .xls file it doesn't format correctly (I get all the data separated by commas, but thrown into one column in the .xls file). For this reason I believe I need to add a delimiter.I'll post my code below.
[Code]...
I Want to show result from multiple tables from database but how to set property (Setdatasource) for the same in vb.net. Iam using visual studio 2008 back end sql compact 2005
View 1 RepliesWe use an ERP program in conjuction with SQL server and lots of tables that keep track of product records customers and all these kinds of stuff. I am building a fairly simple Warehouse Inventory Application that warehouse employees will use to count and inventory stock on hand from products around the warehouse and then check if any quantity errors occur between stock on hand and logistic quantities.I have created a custom Inventory table that I would populate with records like {stock_code, Description, Quantity_remain, quantity_avail}. Those records already exist in 2 different tables in my database. The aim is that I want my program to fetch daily 10 random codes from the stck table, and records about their quantities,bringing together the "columns" that my new custom table has +2 more editable columns: inventory, date, user with a query like this:[code]
As you can imagine my custom table contains the exact same fields as the query suggests + 3 more.I use the the stck table to fetch product info like its code,description, its group_code, categ_code, and then I outer join the stck_x_th that contains records concerning quantities remaining or available asociated with each product code and the "places" those quantities reside in the warehouse.Then, store them in a datagridview control, with only one editable column -inventory- (user and date columns are auto-populated with default values), and then when the user fills out the inventory quantites, I want to save the datagrid "as it is" in my new custom table.I am creating a databound gridview control using one table adapter (which refers to the inventory table). Then I add to my table adapter using "add query" the forementioned query with a fillby method to populate the Datagrid (and therefore my Table in SQL) with the exact same values my query returned from the different tables. But whenever I try to update the table concurrency exceptions raise.It works like a charm if I enter the values in the grid cells manually, without populating the grid control with the new fillby method my self but not if I populate the grid via a query and then hit update.
I want to combine multiple lists of items into a single list, retaining the overall order requirements. i.e.:
1: A C E
2: D E
3: B A D
result: B A C D E
above, starting with list 1, we have ACE, we then know that D must come before E, and from list 3, we know that B must come before A, and D must come after B and A.If there are conflicting orderings, the first ordering should be used. i.e.
1: A C E
2: B D E
3: F D B
result: A C F B D E 3 conflicts with 2 (B D vs D B), therefore requirements for 2 will be used.
If ordering requirements mean an item must come before or after another, it doesn't matter if it comes immediately before or after, or at the start or end of the list, as long as overall ordering is maintained.
This is being developed using VB.Net, so a LINQy solution (or any .Net solution) would be nice - otherwise pointers for an approach would be good.
Edit: Edited to make example 2 make sense (a last minute change had made it invalid)