Multiple Sql Queries?
Nov 5, 2010I have a form that will have at least 3 seperate sql queries that I want to have submitted with an onclick event.
View 4 Replies
ADVERTISEMENT
Get Multiple Insert Queries From C#?
Apr 23, 2009I 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.
Run Multiple Access Queries In .NET?
Oct 20, 2009I have 2 queries to run, one after another.
View 7 Replies.NET - DataGridView - Multiple Connections And Queries?
Oct 8, 2010I 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]...
.net Search Button Multiple Queries?
Jan 13, 2012i 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]...
How To Execute Multiple Queries In An Application
Nov 17, 2010I'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 RepliesRun Multiple Queries With An Onclick Handler?
Nov 4, 2010I 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 RepliesSearch Button Multiple Queries?
Jan 8, 2009Mi 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 RepliesVS 2005 Multiple Database Queries?
Sep 8, 2009I 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]...
VS 2010 Combine Multiple SQL Queries?
Feb 13, 2012My 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]...
.net - Nested Queries From Multiple Oracle Databases
Jul 21, 2011In .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.
Combining Data From Multiple TableAdapter Queries?
Mar 9, 2009I 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].....
Keeping Dataset In Memory Or Multiple SQL Queries?
Apr 19, 2011I 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].....
VS 2008 Using Parametrized Queries With Multiple SQL Statements
Jun 25, 2009There 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?
Crystal Report Multiple Queries - Set Property (Setdatasource)
Dec 30, 2010I 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 RepliesDatagrid And Queries With Multiple Joins To Update A Table
Jan 19, 2010We 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.
Sample Program / Project Which Uses Multiple Queries To Display Counts In Text Boxes
Jul 24, 2009i'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 RepliesLINQ Queries - Combine The First 3 Queries Into A Single Query And Place In A List?
Jan 6, 2010I 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?
.Net Cannot See JET Queries?
Dec 5, 2010I have a Access 2003 backend db and I'm using vb 2005 to connect to the db via conntection string. It works ok! I can see all the tables but only some of the queries. Why should some queries be absent? In 1 query I have a user define function which cuts up a string. I've created a new VB project with a new connection but the same result. I've compacted the database with not change.
View 2 RepliesAny Way To Combine Two Queries?
Jun 8, 2011I am trying to UNION the two queries below without success.
Dim
ds1
As
New
DataSet
Dim
MyConnection1 As
New
OleDb.OleDbConnection(GetPOWERConnectionString())
[Code] .....
Asp.net - Search Queries In .net?
Aug 3, 2011I am trying to perform a search query using drop down boxes with a button named search. I want it to bring up the data that is searched for. I dont know where to start from, i have looked around for some coding and different ways to do it but they seem complicated, this is the bit of ASP that is my weakness, need some assistance and guidance. below is the code for the page;
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="ForSale.aspx.vb" Inherits="Users_ForSale" title="Properties For Sale" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
[code]......
Asp.net - SQL Queries Through .NET And JSON?
Feb 19, 2010I'm trying to figure out how to do SQL queries towards an SQL 2005 Express server and format the return value to JSON. I got the queries working using this (perhaps very newbie-like) code;
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI
[code]....
Available WMI Queries For ManagementObject
Aug 6, 2009Where can I find informations on which WMI queries are in fact available for .NET interface through ManagementObjectSearcher. The command below returns exception for "Win32_LogicalDisk", but works for "Win32_Environment". Every reference in msdn directs to msdn library, which contains all Win32 and COM development classes (that seems not to be available from vb .net code):
[Code]...
Parametrized Queries With ADO.NET
May 18, 2012I've been going through a lot of forums and see a lot of mention of ADO.NET and how it's better to use. I guess because it's newer and being maintained with current times?I've done google searches for this, but every time I see different programming languages other than VB.NET implementing param queries with ADO.net, or it brings me to results that have oledb commands again.Is there a good ADO.NET for VB.NET tutorial with parametrized queries?
View 3 RepliesQueries - Loop Through Dgv
Dec 14, 2011finish my querie, it works for the first 2 rows, I need ti to loop through my dgv:
[Code]...
Run .sql Files Queries In .net?
Sep 22, 2010I want to send the a vb.net application which will run some updates on the database. I have built the sql script files which i would normally run thru query analyser but that is not available thru MSDE.I know i can use OSQL or ISQL to run these scripts but i really want to run them thru a VB.Net application.here is the code i'm using which is generating an error beacuse i'm trying to execute more than one statement?
Dim connectionString As String = ' CONNECTION STRING IS HERE
Dim conn As New SqlClient.SqlConnection(connectionString)
Dim cmd As New SqlClient.SqlCommand
[code]....
Update Queries In VB?
Nov 23, 2009i have a form which once the user has entered their correct Account No they will access the jobs relating to their number. I now need to use and update query so that once I select yes in the Query handled box, after clicking the update button, this row will then be deleted from the table. Here is the code that I have so far:
Public Class Form1
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
End Sub
[code]....
Using Variables In SQL Queries
May 18, 2009I am a beginner when it comes to VB express. I went to the FAQ and found what looked like the answer to my question in "Database - How can I put the value of a variable/control into my SQL statement?" which said I should use thecode ...... where Field = ' " & variablename & " ' at the end of the SQL statement
I am using a field defined as a nchar with 10 charecters and my variable is defined as a string. my field has been given the value "abcdefghij" so it is full to avoid confusion with spaces and even though the variable is identical and I have used the len command to check there are no hidden spaces etc. When I run the query I get no records selected. What am I doing wrong?. If I use Where Field = 'abcdefghij', ie specify the value in the SQL I get the correct records selected but this does not give me the flexibility I need
.net - Know To Refresh Linq Queries?
Aug 24, 2011I have a basic grid of Linq2Sql entities (frmList). I have a separate form for editing (frmEdit). frmEdit has its own DataContext (as that appears to be the recommended way). How can I tell when my detail form has saved changes?
I don't see a built-in method. I am considering raising an event on the detail form when I save the datacontex, but not sure how I consume this event on frmList, and I have a feeling these events are already created for me somewhere?
.NET Reporting System: IMP Queries?
Aug 2, 2011We have a reporting system where in we are getting unexpected results:
1) The size of reports at different time of interval is different?
2) The reports are writen as pdf to a directory. When we have thousand of older unused pdf(which will not get merged) in the directory the Adobe Life Cycle(to murge the PDF) throws error.But when we clear the directory by deleting the old unused pdf, it works fine?
3) Some of the pdf that are rejected by Adobe life cycle may or may not be corrupted. Meaning they may or may not open up with Adobe Reader, manually.