I have a sql query with that adds numerical values from different table to find total for a shipment. When I execute this query, it works fine for the first record but rest of the records show null value when I know there are records present. SQL pros take a look if there is a problem with my syntax.
CODE:
how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....
Hpw can I pass multiple values from same column in a query? I am using vb.net and sql server database.
With my query an exception is generated saying that @booking_date has already been declared try a different variable....
My query is:
Dim da As New SqlDataAdapter("select * from Bookings where booking_date Between (@booking_date AND @booking_date) AND booking_time Between (@booking_time AND @bookinbg_time) AND game = " & x, con)
I have 4 checkboxes available, what I want is the user to be able to select as many of the four checkboxes.Each of the four checkboxes have a value, but when i set the code it only selects the first checkbox and only adds the first checkbox i select to the totals, rather then all selected checkboxes.The values have been set in the module and all the values appear correctly, they are just not adding all together when i select more than one checkboxHere is what I have in the calculate button.
Dim PriceDecimal, DiscountDecimal As Decimal
'Find Price of Service
If MakeoverCheck
[code].....
Looping code is adding my values multiple times
View 4 RepliesI am trying to create a simple Word doc that when the user presses the button it takes the information in the boxes and tosses it into a template style paragraph. But my issue is that I have two combo list boxes as seen in the picture. I want to have two values in the drop down list as seen in the labels next to them but for the life of me I can't figure out how to do this in Word 2007. In Visual Studio this is much easier but I am work and need to snap this out for the folks at work. Is there an option that I can choose in the properties where I type in the values for each drop down or do I have to add them in at run time?
View 1 RepliesWhen I click on button1, employee_id and P values need to be transferred from button1_click to Cal_Category13() and go through all the calculation. After the calculation, udtnew.X and udtnew.MTD values need to be transferred back to button1_Click
I've no problem to return multiple values Cal_Category13().MTD and Cal_Category13().X from Cal_Category13() to button1_Click but i've no idea how to transfer employee_id and p values from button1_click to Cal_Category13().
Program Code
Public Structure PCB
Public Employee_ID As String
Public MTD As Decimal
[Code]......
i have retrived this datatable from datasource and i want to add a more colum 'category'basedon the each value of each Role, like if role column has the value '90 daya client' then in the same row it should have a value 'DC' in the category column.n make a temporatry dt1 table but to add related values.
S.No First Name Last Name Role Date
1 Us er1Name User1Name 90 Day Client 11/01/2011
2 User1NameAtt1 User1NameAtt1 90 Day Client 11/01/2011
[code].....
I have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 RepliesI have simple columns and their respective sums. However, I exclude 1 particular value from each sum, like so [code]...
Now I need to exclude another value ("Awaiting Progression") from a second column called "PROGRESSION".
Since I already exclude value based on 1 column called CATEGORY, how do I change my =Sum(Code.ExcludeOthers(Fields!CATEGORY.Value,Fields!ACTION_PLAN_NEW.Value)) to exclude a value from the PROGRESSION column if it's = ("Awaiting Progression") ?
i.e. How do I exclude multiple values, depending on values in 2 columns in SSRS 2005?
I'm doing a movie database project where I want to add a first name, surname, DVD and role of that person in that movie to a query which will be displayed in the next tab.
Here's a couple of screen shots of what I'm talking about.
[URL]
Here is the code I have in the submit button as seen on the first screen shot.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
BindingSource4.AddNew()
[Code].....
I debated whether or not to ask in the database section, but decided this was probably more of a VB question, than DB.I'm performing a query on my database and add its value to a DGV. At the moment, I'm just running tests to make sure the base example works so I can expand on it for more advanced tests.[code]It doesn't matter how I add the row, just adding it causes the error. And yes, the AllowUsersToAddRows property of the DGV is set to True, which wouldn't cause this problem anyway, but I decided to be extra careful.
View 1 RepliesI'm having issues w/ querying the database w/ user selected dates. Hardcoded everything worked fine but when I started to use the DateTimePicker things stopped working.
Dim sqlcn As New SqlConnection(db.dbcn)
Dim cmd As SqlCommand = sqlcn.CreateCommand()
cmd.CommandText = "SELECT * FROM TABLE " _
& "WHERE CHK_DT BETWEEN @BeginDt and @EndDt"
[Code]...
I've added a COM reference to one of my projects (the DLL resides in C:Program FilesIntwerwovenWorksiteiManage.dll) but when I view the References in my project the path is something like c:usersusernamedocumentsvisual studio 2008project nameobjdebugiManage.dll..I seem unable to edit this path. I can remove the reference and re-add it using the browse button, picking up the correct dll but it keeps showing as the path of the project.The application works on my development machine but as soon as it's deployed to a client machine it complains of the missing DLL. Of course, the DLL is present but the app is looking in the debug folder.
View 13 RepliesI have a program that generates a daily hex code. What I am trying to do is get the number of days since the start of the year which I can do using the following
Code:
Dim dtStartDate As Date = "1/1/2010"
Dim tsTimeSpan As TimeSpan
Dim iNumberOfDays As Integer
tsTimeSpan = Now.Subtract(dtStartDate)
iNumberOfDays = tsTimeSpan.Days
Then starting from zero (January 1st) increment the code by the hex value "FF6086A" up to the current number of days. So if done correctly the code for March 17th should be BD0A7F78.
I was wondering if anyone could give me an idea of how I could accomplish this because I seem to be having a problem with arithmetic overflows:I have a program that generates a daily hex code. What I am trying to do is get the number of days since the start of the year which I can do using the following
Dim dtStartDate As Date = "1/1/2010"
Dim tsTimeSpan As TimeSpan
Dim iNumberOfDays As Integer
tsTimeSpan = Now.Subtract(dtStartDate)
iNumberOfDays = tsTimeSpan.Days
Then starting from zero (January 1st) increment the code by the hex value "FF6086A" up to the current number of days. So if done correctly the code for March 17th should be BD0A7F78.
I am trying to do a simple summary of table data using a LINQ query.a regular SQL Query looks like:[code]This query works fine and returns the correct results.[code]This LINQ query returns the incorrect results some of the time. Off by .01 in most cases.The "value" column is of type Numeric (12,2) in the database.Now when I show the values from the Sum in a msgbox I get extra precision and thus incorrect results as my end result because of rounding.For example I get 835.18 + 54.62 = 889.80960 from the above LINQ query.I am running Visual Studio 2008 9.0.30729.1 SP on Vista 64Bit with .NET 3.5 SP1.
View 3 RepliesI seem to be having a heck of a time trying to figure out how to add the results from a mySQL query to an array in vb.net. Right now, I only understand that you have to define the dimension of the array, however this is shy of impossible since the dimension of the array will change due to different results from the query. What is the proper way to take my results and put them in an array?
View 12 Repliesurl...How do I reference a query in a DataTableAdapter so that I can put the values gathered into a Textbox? I'd like them to all go on their own line in an order like so: LastName, FirstName, GradYr: MP1_Pts: MP1_Comments; MP2_Pts: MP2_Comments.Can someone guide me in the right direction here? This is the final step I need to take in creating my program.
View 12 Replies Right now I have an array that is unparsed. One of its elements goes something like this:
"Blah, 555-5555"
So it's a name and a telephone number separated by a comma. The instructions I have tell me to use a query to put the information in the array into a data grid view in two columns, one for the name and one for the telephone number. I don't know how to isolate each inside a query.
i am writing a golf score program and i have 18 text boxes. i also have a text box that will calculate the total of all of the 18 other text boxes. what would be the best way to add these text boxes? i have already written code to only except numbers 1 thru 8 for each text box.i started with some code like this:
TextBoxTotal.Text = CInt(TextBoxHole1.Text) + CInt(TextBoxHole2.Text) + CInt(TextBoxHole3.Text)
but if there is no value in one of the text boxes i get an error:Conversion from string "" to type 'Integer' is not valid.so i am guessing i need to check for empty strings and then ignore them
I'm making an application in school where I have to display the values of domestic, international, and total sales of company "Conway Enterprises." Everything seems to be working except it is not displaying the totalCompany sales as a currency. I'm sure it's probably an easy fix but I've been searching the internet and re-reading my book for awhile with no results. Below is the code, as I said everything seems to be working fine aside from adding the two array values and then displaying them as currency.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
[code]....
I have two comboboxes in my form (cbAdresse & cbVerwaltung). Choosing the value in the first combo, i get the value from the table into the textbox txtAdID. Now i try to use the value in the txtAdID as the parameter for the SQL command selecting the values from the table (tblVerwaltung). These values must be added to the second combo (cbVerwaltung). So i use the following code for the SQL Compact Client:[code]Using this code i get the following value in my combo cbVerwaltung: "System.Data.DataViewManagerListItemTypeDescriptor".[code]
View 3 RepliesI am trying to run an event which will search through the different files in a given directory. The goal is to have it search for all files that begin with 'SP_', which are .sql files containing Stored Procedures. I would then like to add the full text of these Procedures to an array to be used later. This is causing an error when run, which I believe is because 'FullProcedureArray()', the string array I am trying to load does not have defined boundaries. When I declare it as 'FullProcedureArray(7)', or with some other value, it appears to run fine. But I don't want to have to hard-code a boundary for 'FullProcedureArray'; I would rather let it be defined by whatever the number of files in the folder is.
My question: Is there a way to declare 'FullProcedureArray' without having to give it an absolute value? I may just be missing something painfully obvious, but I haven't worked with this type of array much in the past.
Dim AppDataLocation As String = "C:FilesTestFiles"
Dim ProcedureArray As String()
Dim ProcedureText As String
[Code].....
I wanna add values from my database to a datagrid, my bigger problem is adding a whole column of values, because I know how to add 1 by 1. So, how can I add a whole column of values from my database?
View 2 RepliesI have DataGridView Named EditRecordDates with column called RecDateApp. Its the 3RD Column in DataGridView--I want to take Value from Textbox called AppDateTextBox and Populate all Rowa in Column with Value
[Code]...
I would like to add values to my existing db ie to say:
currently in my db table (trade) has column (buy). It has alr a value of 10 to it. Now when the user inputs a value "20" into the textbox in vb.net, how do i write the syntax such that the user input value "20" will add to the db's "10" which means now the db column (buy) has a value of "30"? Been thinking quite long but no ideas so far.
I am having some troubles with a project of mine. Its a basic financial manager for windows mobile 5 using VB.net. Everything works fine, however, when a value is saved in xml, it will be overwritten when another is saved. I want it to add these values instead of overwriting them entirely.[code]
View 2 RepliesI am having some troubles with a project of mine. Its a basic financial manager for windows mobile 5 using VB.net. Everything works fine, however, when a value is saved in xml, it will be overwritten when another is saved. I want it to add these values instead of overwriting them entirely.
Private Sub MenuItem3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem3.Click
Dim writer As New XmlTextWriter("product.xml", Nothing)
[code].....
..i am working in my project i am having problem in the list box part.. .
[Code]....