DB/Reporting :: Where To Store SQL Statements
Jan 18, 2011
I have an existing system wherein the SQL Statements, Stored Procedure Names (and other messages sent to mainframe, etc) are stored in a table and is retrieved everytime it is needed by the application.
Having this, the system it would require at least 2 db traffic - First, just to retrieve the said data, and Second, to execute it.Im planning to revise the system and remove the first traffic out of the database and put it somewhere. on where to put it? Hard Coding it is not an option as a change on the SQL Statement would require me to rebuild it.
Is there a global cache that can be used by my Class Libraries? If so, how to i use it programatically.
Ill be using Class Libraries (VB.NET) which will be reusing these data repeatedly.
View 2 Replies
ADVERTISEMENT
Jun 28, 2011
Not sure if this is possible but can you use the select statements in VB to pull in from not just one but multiple tables and put the data in a gridview? [URL]
Code:
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
[Code].....
View 3 Replies
Jun 25, 2009
I have a connection to a MS SQL database, which I understand is capable of handling multiple SQL statements in one Execution, ie
Code:
Using cmdExe As New System.Data.SqlClient.SqlCommand
sSQL = "Delete * from mytable where UniqueID=123;Insert into mytable (UniqueID, Field) values (123, 'something')"
cmdExe.CommandText = strSingleSQLLine
cmdExe.ExecuteNonQuery()
End Using
will delete from "mytable" and insert a new record all at once. This is great, but I want to expand upon that to use parameters because using string concatenation in my SQL queries is a bad idea. Now my question is this. If I add a parameter which is used in multiple SQL statements, do I have to add the parameter VALUE twice to the command object? ie, will the following code work?
Code:
Using cmdExe As New System.Data.SqlClient.SqlCommand
sSQL = "Delete * from mytable where UniqueID=@uniqueID;Insert into mytable (UniqueID, Field) values (@uniqueID, 'something')"
cmdExe.Parameters.AddWithValue("@uniqueID", 123)
[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?
View 1 Replies
Oct 15, 2011
I have a question regarding the dataset usage in Reporting Services. I have a stored procedure which returns multiple select statements (result tables), and I created a Dataset in Reporting Services 2005 with this stored procedure. The problem is that I can not reference the second or third result table, and I can only use the first select statement fields. Is this the limitation on Reporting Services Dataset or is there a way to use multiple table results in one dataset?
View 1 Replies
Jan 1, 2009
MAy i know can we store image in database? And yes, can we call out the image from database?? the database used is MS Access..
View 1 Replies
Nov 25, 2009
I performed a search by completing this information in my form:
TextBox1: the user types DB-20-RTS
DateTimePicker1: selects 7 april 2004
DateTimePicker2: selects 7 april 2004
[Code]....
I don't have errors of syntax in my code the only problem is when I press the search button (it doesn't store me in the columns of datagridview the 5 things I want).
View 1 Replies
Aug 13, 2009
I have a matrix with rows indicating a name (Ex Store name) and I have data pertaining to that in the DATA cells. I also have another date field in this format (MM/DD/YYYY). I would like to use a cross tab between Store Names and Just the Month of the date field.
[code]...
is there any expression I can use to get the month format on the header of column.
View 2 Replies
Oct 11, 2009
Can someone give me a site to a tutorial that will help me write a program that will generate a pattern using do while, if else statements,and do until statements. I have been using google but I can't find anything. I need to generate patterns a certain size 6 by 6 or similar such as something like a checkerboard but where the ^ symbols is there a suppose to be a blank space..
View 3 Replies
Jul 25, 2010
will SQL statements that work in Compact SQL Server also work in the Express Edition of SQL Server?
View 2 Replies
Mar 22, 2012
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
[CODE[...
View 14 Replies
Mar 14, 2012
I am trying to figure out how to do this:
if (phrase = hello) then
"say hello"
if (phrase = how are you?) then
[CODE]...
So basically, I want it to work like a timeline. If I say hello, then it will respond and move onto the next if statement. Get it?
Here is the code I have now:
If phrase.Result.Text = "hello" Then
synth.Speak("Hello to you too")
If phrase.Result.Text.Contains("How are you") Then
[CODE]...
View 21 Replies
Feb 19, 2009
i know that integer is a variable to store whole numbers and that a string is a varialbe used to store any text, but what variable type would you use to store a number that has decimals?
View 7 Replies
Apr 15, 2012
"Create a class called Invoice that a hardware store might use to represent an invoice for an item sold at the store. An Invoice should include four pieces of information as instance variables--a part number (type String), a part description (type String), a quantity of the item being purchased (type Integer) and a price per item (Type Integer). Your class should have a constructor that initialize for each of the four instance variables. Provide a property for each instance variable. If the quantity is not positive it should be set to zero. If the price per item is not positive it should be set to zero."
I attached the code I have. obj is underlined and says "Argument not specified for parameter 'Invoice4' of the 'Public Sub New (Invoice1 As Object, Invoice2 As Object, Invoice3 As Object, Invoice4 As Object)' and so the program won't run. What am I doing wrong?
Public Class Form1
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim obj1 As New Invoice(Val(TextBox1.Text))
TextBox1.Text &= obj1.Invoice1 & vbNewLine
TextBox1.Text &= obj1.Invoice2 & vbNewLine
TextBox1.Text &= obj1.Invoice3 & vbNewLine
TextBox1.Text &= obj1.Invoice4 & vbNewLine
[CODE]...
View 14 Replies
Jan 9, 2009
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
View 5 Replies
Oct 18, 2011
I have to Create a Bowling Scores application that allows the user to enter 5 scores and then displays the high score and the low score and then clicking on the Statistics button there would be a label showing which is higher and lower. We HAVE TO USE FOR AND NEXT STATEMENTS.
View 7 Replies
Nov 5, 2011
How can i implement a statement with if for this number to be greater than 0 but less than 10? More Specifically where would the < 10 go?
Quote:
Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
[code].....
View 12 Replies
Dec 20, 2009
is there any way to use 2 for every.... statements?
i want to load up my.settings and 1 list will make new toolstripdropdownitem and the other lists is for the tooltiptexts
or I could do it another way, but how can I check the index of items in a my.setting string collection? like if I want to get the text of index number 3 how do I do that?
View 4 Replies
Oct 6, 2010
I am using Microsoft Visual Studio 2008 with VB.NET, and in class we were assigned this project: A procedure should calculate a 2% price increase on all red shirts, but a 1% price increase on all other items. In addition to calculating the price increase, the procedure also should calculate the new price. You can use the variables strItemColr, strItem, decOrigPrice, decIncrease, and decNewPrice. Format the original price, price increase, and new price in the lblOriginal, lblIncrease, and lblNewPrice controls, respectively.
View 1 Replies
Jul 20, 2010
Basically if i wanted my controls to be checked at startup id use a setting obviously
'UI Settings
chkCloseToTray.Checked = My.Settings.CloseToTray
chkAlwaysShowSystemTrayIcon.Checked = My.Settings.AlwaysShowTrayIcon
[code].....
View 3 Replies
Oct 31, 2011
how to combine this 2 statment..
IsConnected("Select * from manager_table", False)
Call Loader()
IsConnected("Select * from Clerk_table", False)
Call Loader()
i hve 2 listview, 2 table from accessdatabase..i put listview in tabcontrol..1 in tab 1 & second in tab 2...
View 1 Replies
Oct 24, 2011
I need to know if this particular block of code will work, and if not, what i need to do to make it work. I'm doing touchy business and i'd prefer to have it right the first time.
strsql = "IF COL_LENGTH('orders','nosign') IS NULL" & _
"BEGIN" & _
"ALTER TABLE orders" >& _
"ADD nosign bit;" & _
"END"
View 2 Replies
Sep 21, 2011
How do I make an OR Statement.
Im trying to do this
name3 = [name2].EndsWith("," Or "." Or "?" Or "!" Or ";" Or ":")
View 1 Replies
Apr 13, 2012
I just wanted to know if it's possible to get an if statement to accept two strings into the same text box. An example of my code so far is below: (although please note that the program does not accept the strings after the "Or" boolean)
Private Sub btnpreview_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnpreview.Click
If cbox2.Checked Then
[code].....
View 5 Replies
Jun 27, 2010
Okay I need two blocks of code for each of these:[code]Now both of these are under the if statements checking if the startsWith or equalsIgnoreCase check boxes are checked. (Only one is under the corresponding code not both.) At runtime when I check off the boxes neither of these two code blocks execute.
View 4 Replies
Mar 17, 2011
Here is my code as I have it
Code:
Public Class Form1
Dim OpePro(7) As String
[code].....
View 8 Replies
May 3, 2011
I'm having some problems getting a query to run based off another query. Here's the database diagram to give a little background. The primary keys for all the tables are automatically generated by identites. The first 2 insert statements (Donation and Food_Donation) work but I can't get the last insert into Donation_Details to work. Here's the code so far:
View 2 Replies
Sep 8, 2011
I cant really find any good sources for connecting to a database via connection string and executing prepared statements. Could someone show me an example or point me to a resource that might be useful?
View 2 Replies
Jun 27, 2012
I have two if statements and my project sees one and not the other. Here is the code:
If (IsPostBack) Then
HandleUploadedFile()
End If
Dim savePath As String = "Images "
If (fileUpload.HasFile) Then
[Code] .....
When I trace my code I find it goes to the second if and then go to end if without running the code inside the conditional.
View 2 Replies
Jan 29, 2012
I am trying to use if statements to add the prices of a cruises special packages together. I am using check boxes for the packages, so any, from none to all 3 are able to be checked. The packages available are VIP, excursion and restaurant. The price will also depend on the cruise length (7 or 10 day). I am wondering on which format to use, and if I even need to use if statements, how to make this statement true,
View 1 Replies
Nov 5, 2009
ok so i am in programming 1 and im trying to use a like statement for someone imputing a password and here is the details
-Changes all vowels to "X"
-Changes all numbers to "Z"
-Changes password to origonal form
i have tried but this is all i have
Dim vowelA As String
Dim vowelE As String
Dim vowelI As String
[Code]....
View 9 Replies