Storing In Variables Versus Calling From Database?
Dec 29, 2009
I am developing an application where I need to make use of multiple values during the run time. These values are configuration setting of the application as specified by user and are stored in a database (more than 50 in number containing strings/boolean and numeric). I have defined a structure to contain all the variables that will store this information. At start of app, I retrieve all values from database and fill the structure which i can use when required. I am wondering if it is a good idea to declare too much of variables and keep them alive during the run-time as compared to retrieving the values from database every time it is required?
View 4 Replies
ADVERTISEMENT
Sep 27, 2010
I have code, shown below, that works all except for 1 thing: The variables being passed byRef get passed, but once modified in the else section of the "if me.invokerequired" code of RecordData, the variables are never updated in the calling function. To reiterate, the calling function does not receive the updated data that is in the variables custid and amt.When debugging, I see the data change in the else section of "if me.invokerequired", but once it returns from the callback the data is missing.[code]
View 15 Replies
Dec 19, 2010
I was a VB6 programmer. And back in the day global variables, functions and subroutines were put in a module. The program started in the module using a sub named Main(). Now in vb2010 it looks like using sub Main() is possible only for console apps, which is not what I want, I'm still trying to write a windows app but it looks like everything has to go at the top of the starting form?? How is this good coding practice? Shouldn't public vars and functions be in their own module?What is considered best practice?Are there any links that would walk me through the differences between vb6 and vb2010?
View 2 Replies
Oct 15, 2011
In a program I've been working on I would like to start a process and save it in a variable of type Process. This is so I can kill it later, if needed, and change the window type.
View 2 Replies
Jul 8, 2009
I have been tasked to create an application, for which the requirements may change over time.This application will be a data entry Windows application,of which multiple copies will be running.All data will be written to text (.CSV) files for validation before being uploaded to a remote mainframe system (iSeries).My application needs to store certain variable information in an external text (or XML) file; for example, the file path to shared resources (which may change over time),as well as the specific data fields required by the mainframe system.
My questionsare these: what is considered the best practice for accomplishing such a task, and how would I accomplish it?I am completely new to XML, so I don't even know where to begin, although I am sure that XML is the path to follow for what I am trying to accomplish.
View 1 Replies
Nov 22, 2009
SI have a form and on submit I need the following variables stored in array.
Dim OrderName, OrderNumber, OrderSize, OrderQuantity, OrderAddOn, OrderEachPrice, OrderTotal As String
So pretty much its an order a customer will be making and every time a new order is placed, a new array will be made.
Example:
OrderName = TextBox1.Text was Sean
OrderNumber = TextBox2.Text was 123456
OrderSize = TextBox3.Text was Large
OrderQuantity = TextBox4.Text was 2
OrderAddOn = TextBox5.Text was Pocket
OrderEachPrice = TextBox6.Text was 10
OrderTotal = TextBox7.Text was 20.00
On submit a new array would be created and would be something like this:
Dim ArrayName(,) As String = {{"Sean", "123456", "Large", "2", "Pocket", "10", "20.00"}}
BUT a new array has to be created each time the submit is clicked.
View 6 Replies
Feb 20, 2009
Is there a way to set session variables during login that are then available to reports? We have a reporting services server where we move and denormalize data from our transaction system for reporting purposes. In order to allow our users to login with the same user name and password from the transactional system we have set up custom forms authentication and after much trial and error it is finally working. In addition we have the authorization accessing our transactional system so that any changes in user authority is immediately reflected in Reporting Services.
Our problem now is that we would like to add some additional features such as locking down parameters depending on user authority/groups in our transactional system. We have found a way to do it but it's inefficient, basically we have stored procedures that will query our transactional system to check for access. The problem is that these queries will often be run for every report request even though the answer is unlikely to change. It would be nice to have access to session level data that can be set once during log in and then accessed from the reports.
View 3 Replies
Mar 10, 2009
I have this string
mainString="/MyApp/ViewPage.aspx?userId=admin&password=1&id=975"
I am getting value in mainString using this code
Dim mainString As String = Request.QueryString("dest")
And I have two sting variables
1)strTempUsername
2)strTempPassword
In these variables I want to store userId and password values from mainString.
So for this requirement how I write logic in code
Dim arrArray() As String
'/MyApp/ViewPage.aspx?userId=admin&password=1&id=975"
strIndexq = mainString.IndexOf("?") ' Check QuestionMark Exist or not in mainString
If strIndexq > 0 Then
Dim strTemp As String
[Code] .....
Here I am getting userId and password but in this code I will get problem when after ? if userId and password starts wit capital letters and password maybe contain characters like "1&a"
And after getting userid and password. I want to remove userid and password from mainstring. So I want mainstring look like:
"/MyApp/ViewPage.aspx?id=975"
View 15 Replies
Apr 5, 2011
I've got a dictionary<string,string> that I need to access and use on several windows forms. In asp.net, I could store it in Session and use it from any aspx page. How would I do this in forms?
[Code]...
View 3 Replies
Nov 10, 2010
I have an application that has several forms in it. On form #1 I am declaring the variables:
Public payPeriodStartDate, payPeriodEndDate As Date On form2 I have this:
Public Class Form2
Public payPeriodStartDate, payPeriodEndDate As Date
Private localVariable As Integer
What I'm trying to do is to call payperiodStartDate and payPeriodEndDate and to use those variables in the following query:
[Code]...
View 9 Replies
Jun 15, 2011
In a form I am designing I have a picture box. I want this picture box to display an image from My.Resources. However, the picture to be displayed will change based on conditions. I have written a statement to store the name of the picture I want to call in a string variable called strPicName. So how do I properly use the string variable to get the line of code below to work?[code]...
View 3 Replies
Jul 5, 2009
What is the difference between a local database and a Service-based database? I read the MSDN and searched the Inet.
View 4 Replies
Apr 13, 2011
Below is the code i am using to read and update the system environmental variable. This code is working fine when i am executing .exe on Local Machine. I am getting problem when i try to access this .exe from Browser(using citrix i am doing this) and invoke. when i invoke from browser its going to catch block and displaying MsgBox("Unable to Create LDAP Key.
[Code]...
View 8 Replies
Jan 16, 2009
just want to know what is the difference between these date values?Once some one told me that its difference is server date and client date but not sure which one he meant.Below is 3 type of date currently I'm using and don't know what is the difference between them.
DateTime.Now is from System.DateTime.Now
Now is from Microsoft.VisualBasic.DateAndTime
Today.date is also from System.DateTime
View 4 Replies
Mar 21, 2012
I have a vb .net ArrayList that I would like to store in one field on my Ms SQL 2008 database. Is it possible to put it in and get it back out as an ArrayList? I'm guessing i need to break down the Array some how and store it as a string, then rebuild it when reading back as i dont see any datatypes for sql that are for arrays. Which is a bummer for me! edit - The ArrayList stores a set of quote ID's. There is no limit to how big it is so it could hold 1 or 1001 different ID's
View 3 Replies
Aug 15, 2011
i am making a project and in that getting storing and loop problems there are two fields serial no and quantity when quantity is entered serial number must be asked then only and the number of times quantity is entered that many times serial number must be asked also serial number is from to too like 1 to 6 or 1 to 5 so i have to taken 2 textboxes serialfrm and serialto to store but now the problem is that i am not able to write proper code for it either it doesn't get saved to the particular name to which both fields belong or it keeps saving without stopping.
View 2 Replies
Jun 23, 2011
i am generating a barimage and storing in a database i am able to create a barimage and store in a local drive but while transferring i am facing difficulties my code is
con.Open()
barcode = New BarcodeLib.Barcode.Linear.Linear()
barcode.Type = BarcodeLib.Barcode.Linear.BarcodeType.CODE39
barcode.Data = TextBox1.Text
[Code]....
View 1 Replies
Dec 18, 2009
how to store images in database using VB.Net?
View 2 Replies
Mar 22, 2010
Hello All,
Can anybody help me, i am having challenges getting collections value into the database
Here is my sample code. but is not working at all rather is crashing the applications
Dim collections As New System.Enrolment.CustomerBiometricsCollection()
collections = Me.PrintCaptureWizard1.ShowDialog()
Dim dbs As New DBClass
Dim mee As String
mee = dbs.ConnectionString
Dim conn As New SqlClient.SqlConnection(mee)
conn.Open()
Dim ds As New SqlCommand("Custoon", conn)
ds.CommandType = CommandType.StoredProcedure
ds.CommandText = "CustBiometrics"
For k As Integer = 0 To collections.Count - 1
ds.Parameters.Add("@TemplateID", SqlDbType.UniqueIdentifier).Value = New Guid(TextBox1.Text)
ds.Parameters.Add("@TemplateIdentifierID", SqlDbType.UniqueIdentifier).Value = (collections(0).TemplateId)
ds.Parameters.Add("@CustomerID", SqlDbType.UniqueIdentifier).Value = New Guid(id)
ds.Parameters.Add("@Template", SqlDbType.Image).Value = collections(0).PrintTemplate
ds.Parameters.Add("@TemplateSize", SqlDbType.Int).Value = collections(0).Size
Dim dr As SqlDataReader = ds.ExecuteReader()
dr.Close()
Next k
conn.Close()
MessageBox.Show("Record Inserted")
View 1 Replies
Oct 5, 2011
Here is the code I used to store an image in my database (SQL Server 2008 R2) using VB 2010. The images get stored but the problem is the clarity of the image is lost when retrieved and seen in a picture box.
Public Function InsertUpdateImage(ByRef _SqlConnection As System.Data.SqlClient.SqlConnection, ByVal _Image As System.Drawing.Image, ByVal _ImageFormat As System.Drawing.Imaging.ImageFormat) As Integer
[Code]....
View 1 Replies
Nov 27, 2010
I am using an Access database and vb.net 2010. I have created a table in the database with columns for title, datein, dateout and roomnymber. In vb.net 2010 I made a distinguished title = combobox, datein and dateout = DateTimePicker. When I click on F5, an error occurs: INSERT INTO Syntax Error in statement. [Code]
View 1 Replies
Jan 30, 2009
I am in front of a great dilemma whether to store files in Database or doing it the standard way. I would choose the second option, but my application will be used by multiple users, so I am doing it by Web Services.
On the one hand, storing in database will be very useful as every user would have access to everything very fast, not caring about file paths, locations and so on.
On the other hand, if this table consists of 1000 files, wouldn't it be a bad idea as there should be some performance loss?
At the present moment, I am using mysql as database, but I am thinking of moving to SQL Server, but I suppose this is not DB Issue.
View 2 Replies
Aug 22, 2010
I'm trying to store three images from a form (PictureBox's) into a SQL Database (MSSQL2008) The below does what I want but is clearly inefficient. Any pointers on what to change to improve this?
Private Sub SaveImages()
Dim ConStr As String = "Data Source=SERVERSQL2008;Initial Catalog=NorthPole;Integrated Security=True"
[Code].....
View 1 Replies
Jun 20, 2012
i simple want to store the textbox data into the dataset .after that i want to fill using adapter into the sql server table
View 11 Replies
Feb 20, 2012
I am using vb.net (visual studio 2010) and have made a form application that uses a login screen. All that works but I am having trouble any firm way to encrypt the passwords in the database. The encryption doesn't have to be very high standard as its just for a college project. Whats the best way to encrypt the password into the database? Or just encrypt the password string, I can then sort out the database end myself.
View 2 Replies
Apr 12, 2010
i had a go at the jmc's codebank submissionon this particular topic: [URL]
And the basic concept of doing is that converting the image to a binary before it will be save in a database.
I am using the .mdb database(access 2003)....so what will be the datatype of the field where i will be saving the binary format of the image?
View 16 Replies
Jul 18, 2010
I have my form set in french as well, and it automatically changes the text format to use ','. However When I try to insert my values into the database it says cannot convert nvarchar to decimal? Worst case, Is there a way I can disable the numbers from changing to use ',' and just use '.' always regardless what language it is? My working language is vb.net?
View 1 Replies
Aug 11, 2009
I've created a rich text box which stored the "textBox.Text" value in an SDF database. The storing works, but the formatting seems to be lost. Is this something that SDF databases can't handle? Do I need to store in binary or something? Not sure how to do that either.I'm using Visual Basic Express Edition with Winforms and writing in VisualBasic.NET btw This is how I store to the database:
Private Sub btnToolStripSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnToolStripSave.Click
Try
Me.Validate()
Me.SangerBindingSource.EndEdit()
[code]....
And this is how I insert the text in to the rich textbox
txtBoxText.SelectionFont = New Font("Verdana", 16, FontStyle.Bold)
txtBoxText.SelectionColor = System.Drawing.Color.RoyalBlue
[code]....
View 2 Replies
Jun 6, 2011
Entering Username and Password and Storing it to a database in ASP.Net?
View 1 Replies
Sep 8, 2011
I had try several type of date format and yet, I stil can't get it right. Below are the coding which had been writen
[Code]....
View 1 Replies