DB/Reporting :: SQL Query - Use The Data Properly With Different Forms And Different Controls With Queries
Apr 21, 2008
I am working on a Data Survey Project and first I have a few questions about the different types of databases, and second, I need help querying my tables that have relationships.
1. I need a database that is stand alone. It is just the back end for the program. Simply to hold all the data an employee gets while out on a job. So would I be better using access, or SQL Express? I have played with both, but I do not want a large redistribution to my user machines. When I compile and produce this app does the SQL Database still work without installing any SQL Technology? Or do they have to go in after they install my app, and install Express?
2.Overview: I suppose depending on the first question regarding the database, it might change this question a bit, but none the less...I have 4 tables( using Access at the moment) I will be generating Reports based on data in the database. I haven't gotten that far yet. *Project* is the table that holds all the details that pertain to the job and client. It has a "one-to-many" relationship to *Survey*. So for one customer there are going to be many Survey Records. *Project Type* also has a 1-to-many back to *Projects*. Parts is kind of an orphan, but is linked to the *Survey* table with a one to many. So there can be many parts for one survey. I wanted this table for a drop down box, so the user could just simply select what hardware he was using instead of typing all the names and parts.
So in VS 2008 using the Designers and related Query tools, how do I constrain the Survey Data to one Customer? I have one form that opens from a button that is "New Project" and then there are all the *project* fields listed, so the user fills out the info and hits accept and that opens a new form called "frmSurvey" I need to add some code to the accept button to check what type of project is selected from the frmNewProject and then run a select query based on that. How do I write query statements in the code section of the form, without using the Visual Database tools?
Ill stop here, and get these questions out of the way first. If I could just get a handle on how to use the data properly with different forms and different controls with my queries, that would be great.
DATABASE
CODE:
View 4 Replies
ADVERTISEMENT
Jan 6, 2010
I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
View 1 Replies
Sep 15, 2011
I have a window form with a label. On the form I have a dataset, bindingsoure, and tableadaptor (all created by the IDE in response to binding the text property of the label) To fill the datatable, the IDE created this: Me.ClientsTableAdapter.Fill(Me.MyDataSet.Clients) Works fine. The bound field is a phone number, stored in the db as a 10 digit numeric string I need to format this with the standard ()-, and I have a function that will do just that. How can I apply the formatting so the phone number appears in the label properly?
[Code]...
View 3 Replies
Aug 2, 2011
We have a reporting system where in we are getting unexpected results:
1) The size of reports at different time of interval is different?
2) The reports are writen as pdf to a directory. When we have thousand of older unused pdf(which will not get merged) in the directory the Adobe Life Cycle(to murge the PDF) throws error.But when we clear the directory by deleting the old unused pdf, it works fine?
3) Some of the pdf that are rejected by Adobe life cycle may or may not be corrupted. Meaning they may or may not open up with Adobe Reader, manually.
View 1 Replies
Nov 4, 2010
I'm new to SQL Server but have been using Access with Visual Basic for quite some time.I am moving an existing project from Access to SQL Server 2008 Express R2. Using the SSMS I redid a number of Queries and SSMS puts the queies in a folder entitled "Project" which is not pointed at any specific database on the server.When I try to call a query in Visual Basic I get the error "Could not find stored procedure...".
Obviously there is something that I am missing, but I don't know what. Can anyone tell me where I should have these queries filed in SSMS?
View 1 Replies
Sep 3, 2009
I got the whole database thing figured out now I've got a problem with these parametrized queries. If I remove them and just explicitly put in the data I'm looking for the datareader works, however doing as I have below returns no results in the datareader.
[Code]...
View 2 Replies
Aug 24, 2010
I have a program that generates text tab-delimited files with a header row and sometimes a units row followed by data.
Example:
FirstName LastName Birthday
Michael Jordan 6/6/66
Alan Jackson 7/7/77
or
FirstName LastName Birthday
Name Name Date
Michael Jordan 6/6/66
Alan Jackson 7/7/77
I would like to be able to perform SQL queries on these files. How can I connect to a text tab delimited file to either pretend it is a database table or import it into SQL as a table, preferably through VB.NET? I could have 300,000 rows, and the fields are all numbers, not text... I have manually imported these files into SQL before using management studio, so I know it is possible but I would love to be able to do it programmatically.
Is there any way I can get the SQL code from this process because it does exactly what I need it to do but it is manual. There is an SSIS package that I saved, but I do not know what that is.
View 1 Replies
Jun 30, 2007
How do you query a Dataset with SQL queries? I'm using VB with Visual Studio 2005. I've got a large library of SQL queries I'd like to run in-memory on a Dataset.All the examples in the documentation show how to "query a dataset with code," but none show how to run a simple SQL query against a dataset. I've seen other threads that say you can do so, but no code examples. Can anyone provide sample code to show how you would run a simple SQL "Select..." query (using the same syntax you would use to query a database) on an in-memory dataset?
View 3 Replies
Jun 18, 2012
Sample Table
Job_ID Job_Name Status
1 TEST00001 FOR KE
2 TEST00002 FOR KE
[code]....
I have sql query that will get a jobname where status is equal to 'FOR KE' and I have multiple users that will query that.Now, what if two queries was executed at the same time? Will the two users get the same jobname? How can I avoid that?
View 15 Replies
Jul 11, 2011
I built a prototype system with some database queries. Since it was just a prototype and I was very new to databases, I just used a direct string. This is the string I used and it works fine:
command = New OleDbCommand("SELECT * FROM " + prefix + "CanonicForms WHERE Type=1 AND Canonic_Form='" + item + "'", dictionary_connection)
Now, in putting it in a real system, I wanted to use the more secure parametized method, so after some googling I came up with this:
command = New OleDbCommand("SELECT * FROM @prefix WHERE Type=1 AND Canonic_Form=@form", dictionary_connection)
command.Parameters.AddWithValue("@prefix", prefix + "CanonicForms")
command.Parameters.AddWithValue("@form", item)
But all I get is an error for an incomplete query clause. What have I done differently between the two?
View 3 Replies
Apr 9, 2008
I have populated a dataset with the contents of a csv file. Here is a sample of the imported data:
Protocol,Process ID,Process Name,Local Address,Local Port,Remote Address,Remote Port,Status
TCP,4,SYSTEM,134.190.220.54,4505,134.190.184.193,139,ESTABLISHED
TCP,4,SYSTEM,134.190.220.54,3963,134.190.218.5,139,ESTABLISHED
TCP,4,SYSTEM,134.190.220.54,3816,134.190.176.154,445,ESTABLISHED
Here is the code that I used to import and display the data:
Code:
Dim sConnectionString2 As String
sConnectionString2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& CasePath & ";Extended Properties=""text;HDR=Yes;FMT=Delimited"""
[code]....
The problem is, all of the data gets displayed correctly except for the ip address. It gets truncated to "134.1892". How can I change the formatting for the "Local Address" and "Remote Address" columns.
View 5 Replies
Jul 9, 2010
I have a basic three form application. It doesn't seem to close after navigating through forms. If I were to open the application, and the main form is displayed. If I press the X button, the application closes fine(Goes from processes) If I were to open the application, and then navigate from the main form to another form using me.hide & form1.show, and press the red X on Form1, the application again, closes fine.
[Code]...
View 6 Replies
Apr 21, 2009
I have a windows form that I bind to a datatable via a binding source. The binding is done in code at run time. Eg;Me.txtCode.DataBindings.Add(New System.Windows.Forms.Binding("Text", bsForm, "ToolCode", True)) (bsForm is the binding source)This works well except if the form control is hidden (I have a couple controls on the form that hold Record ID and Version numbers that the user doesn't need to see). Databinding doesn't seem to work reliably for hidden controls.
View 10 Replies
May 20, 2010
I have a windows form with multiple TextBoxes that are bound to a DataSet of type XML. I load text into the textboxes using DataSet.ReadXML method in the form's load event.
I have another windows forms application which edits the XML contents in that XML file.
How do I force the textBox controls on this form to refresh once the XML datasource file items are changed?
View 8 Replies
Jan 21, 2012
how to input data in mysql, different tables with one query?is it possible to do in gridview in vb.net 2008?
View 4 Replies
Dec 31, 2009
Basically, I want to create a timer for each row of data that will get returned by a SQL query:
SELECT * FROM Projects
I would want the timers to be called "Compteur" & ROWID. This really is necessary.I need them to have different Ticks and so that some can be enabled all at once. Basically it is for a project tracker to count the time you are working on the current project. However you could indeed work on many project at the same time.
View 3 Replies
Oct 21, 2009
I have to make some automatization on a web server, I use Visual Studio 2005 Visual Basic Windows Console Application. I want to make a load/performance test of the web server, so I open several Internet Explorer instances, and I login the application, that is not a problem. But after that I have a mess on the page and I cannot make any more automatization...The composition of the page after the login is like this: I have the default form, another form and a multiple data window(mdw) controller, which dinamically can switches the forms on this part.
The problem is that I don't know how to access the controls of this mdw forms. I couldn't find much about this mdw controller and I am not an expert.
My code is here:
Imports System
Imports System.Diagnostics
Imports System.Web.Ui.Webcontrols
[Code].....
View 5 Replies
Jun 7, 2011
I am trying some Uiculture change functionality.In that I need the name and text of controls in a form to change the culture.I got some Demo project and it is in C#. I tried to make the same functionality with the C#.net and Also using VB.net. But the below mentioned code returns control name with an underscore as prefix. But I don`t want underscore .Code is actually written in Class library.
code is written below
Dim fields As FieldInfo() = form.[GetType]().GetFields(BindingFlags.Instance Or BindingFlags.DeclaredOnly Or BindingFlags.NonPublic)
[code]......
View 1 Replies
Mar 11, 2010
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 Replies
Mar 23, 2011
I am using Visual Basic Express 2010.
I have programmatically set up a Datagrid and binding navigator etc., but I cannot get the movenext, movelast buttons to actually hook up to the Data on the Datagrid.
I have tried to set up an addhandler for the BindingNavigatorMoveLastcontrol, and although I can get the BindingNavigatorMoveLastcontrol to display my messagebox
WHICH IT DISPLAYS TWICE FOR SOME REASON I cannot get it to actually move around the Dataset, or any of the other navigation properties for that matter.
Wednesday61
Imports System.Data.SqlClient
Imports System.Windows.Forms
Imports System.Drawing
[Code].....
View 4 Replies
Apr 30, 2009
I am a new to programming, trying to learn vb.net, so I apologize if my questions are very elementary or my terminology is incorrect. I am trying to format a query to an Oracle table based on user-selected radio buttons on a Windows form (i.e. the query will return different elements from the table based on the radio buttons selected). The query results will be placed in a listbox on the form. My thought was to make a Property containing my query like so:
[Code]...
and then I have a sub that feeds this SQL property (containing the query) into an OracleConnection.My problem is that I don't know how to customize that query depending on what radio buttons are selected by the user. Is a Property the best way to go about this, or is there some other way that may be better?
View 1 Replies
Aug 23, 2010
I have couple of forms can be opened on the screen but how can close all forms properly when i click the "x" button from the main form?
View 1 Replies
Mar 27, 2009
I designed a software in which I used active captionas background colour. Now It works on my computer or current OS but not working properly onto other computers or OS. I mean to say that the background colour
View 1 Replies
Oct 31, 2010
I want al(InitialStrength.Text) to be set as the variable iST so I'm typing this at the top of the page before all my subs:
Public Class CharacterSheet
Public iST As Integer = Val(InitialStrength.Text)
[code]....
but every time I do that and try to compile without even using the variabe, I get this error: "An error occurred creating the form. See Exception.InnerException for details. The error is: Object reference not set to an instance of an object."
View 5 Replies
Feb 25, 2011
I have a form that when you click a button it begins a query. I want the user to know that they already started a query and they basically need to wait and not hit the button again. To do this I have a list box that has an lbResults.item.add() to it
Code:
Private Sub btnControlKSMS1117Query_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnControlKSMS1117Query.Click
[code]....
View 1 Replies
Sep 17, 2010
I have a query about dynamically added controls to a form. I have a series of buttons which are created and added at run time. I have a two drop down lists and two buttons which are created at design time. Button 1 creates a series of buttons called "Test 1.x" based upon the selection of the two drop down lists. This works fine and am happy with the logic.However.... Button two should remove all the dynamically created buttons from the form.This does not happen. What does happen is that 50% of the buttons are removed starting with the first one. WHen checking the loop it only enters the loop half the amount of times that there are buttons. Very strange. When the loop is run repeatability it will remove all controls. Why will my logic not remove all the dynamically created controls at once? What is wrong with my logic?
I attach two code snippets and the .net file for your consideration.Button method which creates the dynamically created buttons from the two drop down lists and adds to form
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Count As Integer
Dim MaxHours As Integer
[code]....
View 3 Replies
Mar 17, 2009
I have 2 tables that are related. Each app can relate to many apps. ie, office can be related to word, excel.[code]I would like to do the following query. I use vb.net but c# is ok.Query is to return all the apps that are not related to (1), so the result should be (4, quake) .
View 3 Replies
Sep 6, 2011
I'd like to display the same data in 6 different listboxes but with different queries.The data is formatted as so:
ExptStage
expt1Expt List
expt2Ready to Print
[code].....
View 8 Replies
May 6, 2009
I added a tooltip control in my form and set a tooltip for a checkbox. The tooltip shows fine until I check the checkbox... If I check the checkbox once and uncheck it, the tooltip never shows up when I hover the mouse over it... How to make the tooltip to show on mousehover no matter the checkbox is clicked or not?
View 3 Replies
Feb 20, 2010
I am facing a problem regarding distributing a visual basic application , Third party controls are not properly placed in win forms while trying to deploy in windows xp machines with diffrent screen resolution , I just commented the below line in designer.vb
[Code]...
View 2 Replies
