I have a function that writes value of dynamic textboxes (quantity & price) and their sum (value) into sql db, all in other column. Now there multiple entrys for the sam user (ID). Now I would like to know how can I get the sum of the value3 fields in the db to the vb.net form?
this is my code:
Dim kol As String = ""
Dim cena As String = ""
Dim znesek As String = ""
[Code]......
I am required to send MS-Access table to SQL Server Database, based on fields Selected in Listview.
1)Till now i am able to get Access table names and their field in List view.
2)I am able to check whether database exists and Whether table exists in SQL Server with same name from VB.Net.Now i don't know how to insert Access Tables based in Fields Selected in ListView to SQL Server.
I am looking to define data types by fields in SQL Server 2005. My source is an Excel spreadsheet and I cannot define by columns because each row requires a set of definitions applied to each field in that row. Ex, row 1 requires field1 to be CHAR while in row 2 field 1 needs to be DATE.
View 1 RepliesBasically what I want to do is, say after I've filled my datatable(whichever fill method i used[dataadapter.fill; or datatable.load(reader)]), now the datatable has the fields i've selected albeit, "Select * from" or "Select field1, field3 from" - either way the table now has my fields. Later incode when i'm ready to access them, say "dt.rows(x)(" OR "dt.rows(x)!", right here I would like intelisense to show me the available fields for that table. I already have my clsDataTable that inherits DataTable.
View 6 RepliesI'm currently refactoring an old Visual Basic DLL (VB.Net), which stores all of its data in one module called Globaldefinitions as public fields. There are about 200 fields, referenced thousands of times all around the code:
Public Module Globaldefinitons
Public a As Short
...
Public zz10 As Double
[Code]...
I need to change the module into a class with non-shared fields. This means, each and every of these thousands of references needs to reference the instance of that class:
globalDefinitionsInstance.a = 5
How do I go about this efficiently?
Regular expressions operating on the source fall flat. Refactoring tools like Re-Sharper or CodeRush don't seem to offer this functionality. Visual Studio 2010 cannot do it automatically either.
Class Foo
ReadOnly name As String
Public Sub New(name As String, dependentUpon As Foo)
Me.name = name
[code]....
The output of New Bar() is:
Dependent created. Dependent upon nothing.
Independent created. Dependent upon nothing.
It seems fields are initialized in the same order as they appear in the source code, which (a) leads to an unexpected result, and (b) seems a little puzzling, given that one is normally not permitted to read from uninitialized variables in .NET, yet that seems to be working fine above.I would've expected VB.NET to be smart enough to initialize referenced fields first, and only then those that reference it; i.e. I'd have liked to see this output instead:
Independent created. Dependent upon nothing.
Dependent created. Dependent upon Independent.
how to get VB.NET to behave like that instead, without simply having to swap the declaration order of dependent and independent inside class Bar?
I'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesMy intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
View 2 RepliesI have several sqldatasources for my gridview. All of the columns are autogenerated. However they all have some consistent fields and I'd like to make those fields template fields so I can modify the edit template for them such as adding a drop down menu. Is this possible?
View 1 Repliesexperience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
how to execute this SQL Statement
Scenario:
Given Tables T_Data, T_AllDesc, T_System1, T_System2
Given Fields:
T_Data= f_id, f_Desc, f_CreationDate, f_CreationTime, f_System1, f_System2
[Code].....
I'm creating a Process Control application that will save various data fields to SQL Server 2005. Part of the data will be input via a VB hand-held application which was created on the CE 5.0 - we are running VB.NET 2.0 on Visual Studio 2005. The rest of the data will be collected via plant equipment which will interface will PLCs on the production floor. There are approximately 25 different attributes which will be stored in a SQL server table.
The user wants me to create 3 alert levels that will involve:
1) Checking to see IF a reading was manually input.
2) Checking to see if the value passed or failed.
The FIRST alert involves notifying the operator via the hand-held or some other technique. The SECOND alert involves checking back after a set time interval (15 minutes, 30 minutes, etc.) to see if the attribute passed or failed and then taking a higher action - such as an email, text message or phone call to a higher level manager. If the second check fails, the same escalation process continues with the THIRD alert level - and another action takes place such as a message being sent to yet a higher level manager.
Presumably, once the status check passes, the alert level is re-set back to 0. But I'm thinking that the process that checks for the failed attributes will need to continue to run in the background - probably at set intervals. I'm not sure if the functionality for this is something that would be best handled by VB.NET or SQL Server...
I have two money fields in a SQL database called TotalClaimed and PartialSettlementAmountRecd.They are declared as Decimals like so:
Public PartialSettlementAmountRecd As Decimal
Public TotalClaimed As Decimal
They both output the repsective amounts perfectly. I need to do a calculation on them, by subtracting PartialSettlementAmountRecd from TotalClaimed. I have tried the following, but it just outputs a random number, not the amount I require.
Dim NewSettAmount As Decimal = (ClaimDetail.TotalClaimed) - (ClaimDetail.PartialSettlementAmountRecd)
Response.Write("New Settlement Amount: £" & NewSettAmount)
I have the aplication which requires name fields... and i wan tto clear these fields whenever i closed the application using close(X) button. i dont want to use 'clear' button.
View 3 RepliesI have a class being populated from comma separated rows in a text file.I am trying to have the name property of each object appear in a listbox, then have the rest of the properties of a selected object show up in text boxes. How do I load the properties of the selected object to the correct textbox?
View 2 RepliesI have a code that I found as a VBS and ported it to VBA and works perfectly, but I am now trying to run on VB.NET 2010 but am getting a Path not found error. I am trying to get the complete name and e-mail from the Acitive Directory from the current user.[code]
View 21 RepliesSo this is my code
Private Sub SK_btn_OpenFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SK_btn_OpenFile.Click
Dim sLine As String = String.Empty
Dim sAllTExt As String = String.Empty
If SK_OpenFileDialog1.ShowDialog() = DialogResult.OK Then
[Code] .....
The text that appears in my textbox is this
Person 1 * 12 * 123.45 *
Person 2 * 24 * 2345.78 *
Employee 1 * 34 * 23.34 *
Employee 2 * 123 * 11.23 *
I want to take the average of the 2nd field. Each field is separated by "*". I have to use the format display 2 integer digits and 2 decimal digits.
So in this case
12, 24, 34, 123 are the numbers
I have to do the same thing for the 3rd field. But I got to add all 3 numbers instead. and use format to display five integer digits (with leading zeros), and 2 decimal digits.
I am trying to put the value in the textbox fields. I do have a working query for it.
here is my code:
[Code].....
I am new to VB.Net and was using VB 6.0 for the last 10 years. I am having some difficulty in accessing fields and changing these.[code]...
View 4 RepliesI wanted to know what 'Fields' are in the Class Designer.
View 11 RepliesI am trying to populate a web from from a SQL table.
Public Class userDetails
Public address1 As String
Public address2 As String
Public city As String
[code].....
however, there are like 50 fields in the User db, and it seems like a lot of retyping...
In .net 4.0 dictionary I know I can calculate the sum of all integer value field like this:
[Code]....
Does exist a more elegant way to do calculate the sum?
I'm trying to add a textbox to the initial step of the CreatUserWizard.Let's say it is tbMyTextbox.Now when I add an event on created user, I want to get the value in the field.I thought I could use dim mc as textboxmc = ctype(CreateUserWizard1.Findcontrol("tbMyTextbox"),textbox)mc.text should be the text of the field.But it can't find the control... so I trieddim mystep as CreatuserWizardstepmystep = createuserwizard1.activestepmc = ctype(mystep.findcontrol("tbMyTextbox"),textbox)But it also fails.The example just uses tbMyTextbox.text which just throws a compiler error.
View 6 RepliesI have a data grid view on a form which is currently filled with the following query:
SELECT TopicCode, TopicName, NoOfCourses, Lev FROM tblTopics WHERE TopicCode = @TopicCode1(Where I obviously pass a TopicCode parameter)
However, I have added two custom columns to the data grid view, and the values that i want be in here are in a different table than the query i'm using to fill the data grid view.is it possible to "nest" queries? which will allow me to select fields from two different tables?
Example:SELECT TopicCode, TopicName, NoOfCourses, Duration, Lev FROM tblTopics AND SELECT StartDate, EndDate FROM tblSubscriptions WHERE TopicCode = @TopicCode1
Possible? or not?
in an sql table there's an id, first name and last name field. i'd like to concatenate the first and the last name fields and display it as one in a dropdown control.
this is the vb.net code:
con()
sqry = "[SELECT QUERY]"
sqcom = New SqlCommand(sqry, sqcon)
[Code]....
^this code displays only the first name. how do i go about concatenating in asp.net?
In my application, I have a single table. Two of the fields in the table are COUNTY and CATNUM. Both are string.
I want to perform a FIND on both fields. I have no problem doing the search on CATNUM alone IF I set a FILTER first. Due to the size of the table, it takes a few seconds to set the filter. Once the filter is set, .FIND works quickly.
The customer has the option of setting a filter to work on one COUNTRY at a time. If they choose to do so, no problem.
If they don't have a filter set and they are using the entire table, then when the customer wants to search for a COUNTRY & CATNUM, I present a list of COUNTRIES in the table and a textbox for them to input the CATNUM.
Now I have the COUNRTY and CATNUM - how do I do the FIND? I already know that I can FILTER the table by COUNTRY then do the find but as I said before, it takes too long for the filter to be set (in my mind anyway!).
I am working on a timekeeping application, using Visual Basic 2008 Express edition with an Access 2000 database.The application requires the user to complete a timesheet by recording in tme and out time daily. Blank fields are perfectly frquent and perfectly legitimate.Using these lines of code it works perfectlywhen there is a time value in the database.[code]This indicates to me that the code to ignore a field containing nothing is not working
View 10 Repliesis it possible to build objects/classes in a way that every field in a table is represented as an object/control in a form? (I heard it, but I don't know if/how it can be done).
For example:
Description = textbox (with the necessary validations)
Country ID = Combo box (foreign key to a related table)
IsCustomer = Checkbox
so I can build a form by creating the necessary fields/objects in it, and every field is a form control with the necessary rules and validations already in place? This way, fields could be "reused" anywhere in the application retaining their characteristics.
For some reason I can not get some fields to calculate correctly. It seems anything I enter over 24 in the Pay Rate field it throws it spits out the exact numbers I am trying to multiply. The FWT (0.2), FICA(0.08),and State fields (0.25) respectively.
[Code]...