I 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]...
I 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 making a window based application in vb.net. Now i have work in two sql databases, so i when the window opens it will show two databases..when i select first db then i can work in that particular db only..if select 2nd db then i can work in second db only..how to do that?
View 1 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 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 RepliesMy 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]...
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 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'm in the middle of a project, I've got the bulk of it working but I cannot work out how to get my variables to modify the SQL query properly, I'll try and explain. GUI has 5 search fields Q1, Q2, Q3, Q4 & Q5 with 4 checkboxes that denote AND / OR operators that need to be inserted into the query correctly. If they are all set to 'AND' it works fine. However if the user wants 'Q1 AND Q2 OR Q3' then it fails. If I hard code then I just user brackets ie '(Q1 AND Q2) Or Q3'. For some reason I seam incapable of working out the code to achieve this...
Code snippet:
'Check AND OR Checkbox and assign Operator
If Q1AND.Checked = True Then
Q1Op = "AND"
Else : Q1Op = "OR"
[Code] .....
I have an access database that has nested queries. For example, the querydef below is called qs_Pedon_type: SELECT qs_Pedon_basic.peiid, metadata_domain_detail.domain_id, metadata_domain_detail.choice, qs_Pedon_basic.siteiidref FROM qs_Pedon_basic LEFT JOIN metadata_domain_detail ON qs_Pedon_basic.pedontype = metadata_domain_detail.choice_id
[Code]...
i have 3 user roles "ALGEMEEN,OZIS,VERPLEEGKUNDIGE".And I want them added to the database.But when I use the code below it only adds the userrole "ALGEMEEN" and not the other 2.
Dim cmdCheckLidVan As New SqlCommand("SELECT COUNT(*) FROM [Lid van] WHERE [Gebruikers-ID] = @ID AND [Rol-ID] = @RolID", connection)
Dim strRolArrCount As Integer
Dim strRolArr() As String
[code].....
Is there anyway to import a crosstab query from Access 2007 to VB 2005?If not, can I create a crosstab query within VB 2005 from the raw database tables
View 3 Repliesi'm new at vb.net (though i have extensive vb6 experience and oracle experience), and i need a sample program/project which uses multiple queries (of the same oracle database namespace) to display counts in text boxes.user will use a pull down list to select action from there.
View 1 RepliesI 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 have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
View 4 RepliesI have an Access database with some table and some queries.Here you see one query which returns 2507 records:I also added this database to a vb.net project.However, if i try to fill the datatable of the query with the specific tableadapter, the datatable stays empty. Also when I click the query in the dataset and choose 'preview data' I get none of the 2507 records:Any idea why he won't load the records into the dataset?
View 2 RepliesI've written an application and I'm trying to utilise a database behind it. I've created a mysql database, and table which all appears to work correctly. I appear to have connected to the db correctly too. And hit a bit of a brick wall. As a side-note, within Visual studio connected to the database using the add data source wizard, I then dragged and dropped my db table's column onto my form that intends to display them all (6 textboxes, including primary key) and that now displays the first record of the table. It confused me, because i did this as soon as I had setup the database with no visual basic code assisting, so there wasn't even a connection string?!
One functionality i want to have is to press a button and cycle through the table's records using the form by the unique id, how would I do this? I'm essentially asking how can I enter a number in a textbox which would then return me the relevant primary key and data attached to that record.
I'm using oledbdataadapter for query lets say i have a fields Firstname, Surname, Location, Gender
Firstname| Surname| Location| Gender
Angel David Alaska Female
David Leonard Alabama Male
Michael Reeves Indiana Male
i want to filter data so that if I put a keyword %david% and select combobox as "MALE" it will search david on the first three fields and return
David Leonard Alabama Male
Is it possible to create database queries on the fly with VB?
For i = 0 To (UBound(WeekNo) - 1)
For NLoop = 1 To 50
WeekRow(NLoop) = WeekSinceLast(i, NLoop)
Next
Next
I want to write each WeekRow to the database for each week (= i). WeekRow contains 50 elements, each of which needs to be placed in a separate field.
So, can I generate a SQL query that is constructed on the fly? If so, how do I go about it?
Is this possible programmatically? Getting the names of stored queries or checking if a query with a specific name exists?
View 3 RepliesI have written a program that queries an sql database displays it in a detailed listview, no problems so far. The only problem I am running in to is when I got to print the listview. When I do a regular printdocument.print() It prints out the listview exactly how I have it set up to do so. Which is a title , then column headers, next comes the listview, and then a total of some the columns. When I do a printpreview everything looks great. When I click the print button within the printpreviewdialog only the Title, Column headers, and the totals print. [code]
View 7 Replies