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 looking for a way to combine a field from multiple tables into a single field in a new table. Because the data populating the tables is coming from an outside source, I would prefer not to change the data in the original files. I have a separate table for each year because this is the way the data is provided. The field layout is not consistent from year to year, but each year there is a field that we'll call "score." I'd like to pull the field "score" from each year's table and have it populate a "score" column in a new table along with the year of the data so that all the years' scores are in the same place. Is there a way to do this using Visual Basic + Access?
View 3 RepliesI am trying to create a form which will be fed by an underlying database to create multiple form fields for each entry in an underlying database table. This is for a program to monitor patients under anesthesia, and prior to surgery, the doctor will choose which monitors they will be using. Then, on the actual monitor screen which will pop up every X minutes, there will be a text box and a check box for each chosen monitor. I am relatively new to VB, so I have tried to illustrate what I am needing but using the logic that I know from my previous life in PHP.
I am using DevExpress's layout control to place the form fields, so that is the code in the middle of the first loop (on_load), and I know that part works, I just need to know how to name the fields and then recover those fields and commit the values to the database. (the text boxes are added to the database, the check boxes are used to determine if an entry is made for that monitor- i.e. at the end of surgery if a monitor is turned off). I know that my syntax for naming the fields is no where close to correct, and it probably would not work in PHP, but I remember doing something like this in a PHP application I built long ago. [Code]
I am combining data from multiple tables into one table for a presentation software. I am doing a select statement and running a loop. Inside that loop I have multiple selects and I build a datatable an enter the data into the main table. There is a ton of records and it takes forever.
'Requisition Demands
InsertStr =
"SELECT COUNT(*) FROM Requisition WHERE (DMD_DT = " & dateVal & ") AND (QTY_REQ > QTY_PEND_CANC + QTY_CANC + QTY_REJT) " & searchvalString
[code].....
I am create a mysql table with TIME Data type fields. Like FROMTIME and TOTIME. And some insert data to that table. And that data is view through DataGridView. I can show all data in DATAGRIDVIEW. But, Have a error data, when current row click time ( Error data is : DataGridViewTextCell {ColumnIndex=0,RowIndex=0}.
How to store TIME types to Variables or Control;
I have created an windows application which stores it data in a database. What I would like to know is how do I access the tables in the dataqbase and transfer the data in them into textboxes on the forms in my application. I can connect to the database and view the tables, but I have'nt got any idea how to get the data from the fields in the tables into the appropriate textboes on the application forms.
View 2 RepliesI have tested my code in order to pass single value to single parameter field in crystal report from VB.NET Form, it is ok but the problem is that I want to pass multiple values to only one parameter field called "Product Name" and it displays only one last record.
I want to display like this
Receipt : 0001 Product Name
pencil
pen
stamp
book
[Code]....
I already set parameter field "productname" for allowing to multiple values, but it is still the same.
in my form, I want to display a 200x200 table each field containing a 16x16 image. There should be no space between fields, and the fields need to be selectable... how to create such table.
View 5 RepliesOk. Next in line for the week....
.Sheets("PivotData").PivotTables(1).AddFields(RowFields:="CauseCode", _
pageFields:="Responsibility")
<error>
[code].....
Imports System.Data.SqlClient
Dim con As New SqlConnection
Dim cmd As New SqlCommand
[code].....
I have been using the code below to edit SQL database fields from the data stored in a dataset. Problem is I have to repeat this long code for each database field to be edited....I find this very tiring...IS THERE A SHORTER WAY OF EDITING SQL Database FIELDS. (Am using VS 2005 and SQL Server 2005
'3. Create an Update command
Dim strUpdateAccounts As String = "UPDATE Accounts SET Description = @Description"
'create a SqlCommand object and assign it to the UpdateCommand property
[Code].....
How do i find out the number, names and datatype of fields in an Access table
View 16 RepliesAssume my form has four text boxes and it's bond with a Dataset, therefore The user can 1-4 fields. Typically I write one update statement that take four input parameters. Therefore I update the updated fields as well as non updated field. To do this in the proper way, how many update statements I have to write?
Or
How do I do this update properly? I use SQL server 2K5
I will post a sequence of examples and thought about sql injection, I wish the expert will correct any small mistake in what I will say so I can know exactly the possible danger.
The required is to create a function in vb.net that accept 2 parameter (table_name, fields_list) and return the result in datatable
Now, I am aware of that table_name and fields_list cannot be passed as parameter to the command object using .AddParameter
here is a couple of thoughts, what I would like to know is
1- which function is exposed to sql injection
2- Which function is more safe
Public Class Form14
Dim conn as New SqlClient.SqlConnection(connection_string)
Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
so far i have this for my code:
Using myConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & databasePath & ";User Id=admin;Password=;")
[Code]......
This did not work but did when i just tried creating the table and not the fields.
Have anyone developed a textbox where it is possible to display 2 fields in the textbox. We want to be able to show ID + description in the same textbox. (When user enter the textbox description may go away and the user can enter an ID)
View 2 RepliesIn my first attempt to create a Class that contains something useful (if you will), I am a little lost what a sound way to proceed is. I am trying to make a table that has fields and records. Perhaps imagine a tiny spreadsheet. So, I create my Class. Properties might include the number of columns, the column titles, and the number of rows or records. I then think the thing to do is create a couple of structures to be used within the class. Thus far I have this:
Imports System.Console
Public Class ConsoleTable
Property NumberofCOlumns As Int32
[Code]....
Problems I am creating in my mind include:
1) In the Field Structure, could I make the FieldValue so that I can change the data type? Meaning sometimes I want an instance of a Field to hold a string,or an integer, or a decimal.
2) In the Record structure, for any given instance of one I don't know the number of fields it will hold until I create the new instance. I tried Public RecordFields(FieldCount) As Field in the Structure, but that's not allowed.
I then used Public RecordFields() As Field, and then in my code used the ReDim method. Is there a better way?
3) With the Table Class, same problem. The number of records within any instance of the class needs to be dynamic.
Using VB.Net I would like to read the fields from a SQL table and populate a CheckedListBox control with each field in the data table.
View 3 RepliesI have to update some fields of a table of access according to the value of parameter. If this paramter is "true" I need to update.
Table
idInvoice
price
[Code].....
What i'm trying to do here is login using a table and fields with username and password and also usertype in it. If the user is an Admin then it displays the the command button cmdAdmin and if not admin it disables it. This is the code that i currently have at the moment Hope someone can help me out and also i want to get rid of the username and password that's currently in it and use database instead.?
[Code]...
I want to display in a combobox the names of the fields of a table (table is in SQL server 2005).
View 6 RepliesI'm trying to add a service company from a vb form to an SQL table. It works as long as I enter something in every field on the form. If not I get a syntax error so I thought I should check that the field values were not null
I've tried to add a sub to check for blanks but it's not working
btw the table will allow nulls for all fields
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Try
[Code].....
In VB.NET I would like to create a complicated data structure with multiple types of data stored in an array like format (see below). I am trying to create a data structure that would look something like this: [Name; xLoc; yLoc; zLoc; [Jagged Array]] Note: Name needs to be dimensioned as a string, xLoc and so forth as integers. The Jagged Array would look like this:
[Code]...
Is it possible to fill a Combo Box with the names of the fields of a table(from a database)?
View 6 RepliesI am trying to filter fields in a table that contain percent (%) and apostrophe (') characters. I kow that to filter an apostrophe you need to add another apostrophe (''). However, when a text contains the percent (%) character in combination with an apostrophe (') character, an exception is thrown. Also, when using the % character in a filter string, it will be function as an "*" (fields starting or ending with). I need the % to be considered as a character whenever the % makes part of a string in the field. How can I address these issues? [code]
View 8 RepliesWhy MS Access adodb in .NET returns 34 in fieldcount when table has 42 fields ?I see 42 fields in table of my MS Access mdb database. But ADODB layer in .NET sees only 34 fields. The Outofrange exception occures when I am calling method getOrdinal("FieldName") of reader class.
View 1 RepliesI have the code I am using below. On 3.5 framework Access 2003 database vb net 2008
I already have the database created but need to be able to add Tables and fields with the correct datatypes. So far it's not working but i don't know why or where the error is.
Private Sub MDIParent_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code].....
I have a problem with unicode character, as i create a database in SQL Server 2005. I want to query from a table that criteria fields are contain unicode character i.e NVARCHAR.
e.g: SELECT * FROM tblMyTable WHERE MyField='ភាសាខ្មែរ'. But when i did like this all rows that contain Unicode Character always display. it doesn't fit to my criteria
Assuming this schema:
Table1 (Col1 int, Col2 str, Col3 str, ...)
Table2 (Col1 int, Col2 str, Col3 str, ...)
[Code]....
I need to select all records from Table2 where there are NO records in Table1 having matches of both Col2 & Col3. For instance, Table 2 records where Table1.Col2 <> Table2.Col2 AND Table1.Col3 <> Table2.Col3.
I have a typed dataset with 2 tables and a relation between the 2 tables. The relation is a 1 to 1 relation.First, who cane help me how to bind both the fields of the parent and the child table to a textbox.And second, in the dataset designer you cane preview the data. There a see for each record 1 row with all fields of the parent and also the fields of the child table. How cane i have the same result in a datagridview?
View 1 Replies