Starting Form Based On Dataset?
Feb 10, 2010
I'am trying to write a program for projects management.It is based on MS SQL Express Server 2008 database.I have 2 forms.In first form I have list of projects (using DataGridView and showing all projects).So if user click on Project name cell second form will open with Project details (using text boxes and labels to show one project).I try something like this:
Public strValue as String
Private Sub DataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick
[code]....
View 3 Replies
ADVERTISEMENT
Feb 25, 2010
Ok, I know this has been asked many, many times but I haven't seen the correct answer yet. When the database schema changes how do you update the dataset designer to reflect those schema changes without wiping out the whole dataset and starting over?
View 1 Replies
Jan 25, 2011
I have an iSeries query in VB.NET/VS 2008 that I need to run with 2 separate values of a same parameter and present in a report for A/B comparison. In other words - I want to see a report where the result of a run with parameter = value1 is on the left, same query with parameter = value2 on the right.My initial idea was to use 2 tables on a report where each table would be based on result of each run from a DataSet (xsd), but I seem to be only able to specify the parameters on the ReportViewer level, which means I have 2 identical tables instead of A/B cases.
Obvious second way was to create 2 separate reports, each with its own parameter value and get them as subreports onto a main one. However, both subreports show up with "Error: Subreport cannot be shown". Is there a way to catch an error to see why?What is the best way (a.k.a. best practices, industry standard, whatever you want to call it) to create this kind of A/B report? I was well sure that there is a well-known method to make this work, but to my surprise I haven't found anything except multiple copies of MSDN articles.
View 1 Replies
Jun 9, 2011
I have a combobox which is populated from a dataset (pulling values from the column Actuator_ID). When an item is selected from the combobox, I need to return another value from the dataset (column Gateway_Channel). In the 'selectedindexchanged' sub, I have the following line which should return the value from the second field (gateway_channel) but whatever item is selected in the combobox, only the value from the first row is returned.
errBox.AppendText((ds.Tables("Actuators").Rows("Actuator_ID" = ComboBox3.SelectedItem.substring(0, 2)).Item("Gateway_Channel")).ToString
View 1 Replies
Jul 6, 2010
I am trying to create a spreadsheet based on a filtered Dataset. The problem is I cannot connect to XL. I get the following error:
Warning1Namespace or type specified in the Imports 'Microsoft.office.interop' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
From these lines of
Imports Microsoft.office.interop
Imports Excel = Microsoft.office.interop.excel
Another issue is I only have XL 2000, and I won't be able to get 2003 anytime soon. 2003 is what the target computer is using. I would like to develop the app with 2000 and make the appropriate changes to 2003 when I get upgraded. I couldn't get any information on the 2000 PIA here: [URL]. After reading this: [URL] it almost seems like I don't need the 2000 PIA. Many of the techniques described in this document involve the use of IAs for the Office applications.
For Office 97 and Office 2000, you can autogenerate these IAs using TlbImp. Office XP includes pregenerated (and optimized) IAs that you should use instead of autogenerating IAs. An IA distributed by the owner of the original COM server is called a primary interop assembly (PIA). You should always use the specific version of the IA that matches the version of Office you're targeting. I just want to develop the app. Then I can download the 2003 PIA, right? I would use this: [URL].
View 5 Replies
Nov 7, 2011
I apologize if it is not. I am trying to write a script in Visual Studio 2008 (using a VB project) that will, upon the clicking of a button:
- A file object will be created.
-Said file object will read in a number of files from a specified file path.
-A dataset will be created and populated with fields from two columns within a database table; app_id and company_name.
-The script will read through the file names and fields recorded in the dataset, renaming the file to the app_id if the original file name contained the company_name.
The code I have so far to do this:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
'Create the file object
Dim objFSO
The problem is that currently this code will only rename the file if the file name and company_name match exactly, ideally I'd need to include a clause to make it rename if the file name is "LIKE" or "contains" the company_name.
View 4 Replies
Jun 3, 2010
I am creating a program that will allow me to manage server EXE's for which I have the method to do so already completed. The problem comes when I want my front end to be able to use a database of different server configs stored in a dataset.
My Database has 4 columns (ServerID | ServerName | ServerPath | ServerMod)
I wish to be able to select the ServerName in a combo box (already done via Datasource/DataMember) and then load the ServerPATH and ServerMOD for that row into two variables.
View 1 Replies
Oct 4, 2008
I'm a bit confused when it comes to setting the start location of a form, relative to another form.I know how to set the start location for a form, however, I have a "main" form, which is behind this form. The main form will be displaying different images, labels, ect. I need the second form to display at the bottom of the main form. The main form's resolution is 800x600, and the bottom form is 800x65. I tried to set the bottom form's location to 0,535, which WOULD make it right at the bottom of the main form, but it seems that it puts it at that location relative to the user's display resolution.So basically, I just need help with getting this form to appear at the bottom of the main form. I read a bit about "containers", but am not sure exactly if they would work for this, and if they did, how exactly I would incorporate them into my situation.
View 2 Replies
Nov 15, 2010
Q:how can i add columns dynamically to rdlc report from dataset in windows based.
View 1 Replies
May 13, 2010
I need to make a button invisible at the start up of a VB form. However, when text is entered into an input textbox the button needs to become visible without a click event procedure. When the button to enter the text from the textbox into an array is clicked the button needs to become invisible again unitl more text is entered into the box, repeating the cycle. I have found related topics but they don't cover this.
View 4 Replies
Nov 29, 2009
I am trying to set a form position before it shows but i cant get it working.Form Name: ColorCentraling.vb
I've tried: Private Sub ClickNPC_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ClickNPC.Tick
[Code]...
are 2 integers which represent a number which does not need to be explained.There i've made a DIM as the form but new! I've tried settings its location but its not possible for me.I know this is possible because: I've visited many VB.NET 2008 Programs that do this
View 6 Replies
Oct 10, 2010
Ok so my main form takes around 5 seconds to load i can't make it so that my load subs are on a seperate thread because too many cross thread calls being made besides i want a splash screen anyway i want a splash screen on a seperate thread that can update status while main thread is loading this way main thread carries the load subs and invokes status label changes in the splash form which is on another thread
this is my code
Dim SPForm As SplashForm
Public Sub LoaderSub(ByVal Splashed As Boolean)
If Splashed = False Then
[Code]...
what happens is the splash form shows and so does the main form but they both lag for 5 seconds (as if they are both on main thread) how do i make it so that the splash form loads from the new thread? I thought the way i did it that's what should happen...
EDIT: also why did code wraps failed to show proper vb code?
View 10 Replies
Jul 7, 2011
I have a "Please Wait..." form that I show when doing some long task. This works quite well. But I cannot seem to control the opening position of the form. Currently I am using:
WaitWindow.StartPosition = FormStartPosition.CenterParent
WaitWindow.Show()
and this is just being ignored. The window opens at random locations. If I change it to CenterScreen, that works! But I don't want it center screen, I want it centered on the parent. Can I manually set the location? I am using VB 2008 Express and the wait form is a plain windows form.
View 3 Replies
Jun 5, 2010
I need to pick all data in my application from my database and use it in my form
my question : how to pick all data in my application then i use it
View 3 Replies
Dec 17, 2009
' Show Loading Screen
--> Do anything like initializing or updating UI
' Close Loading Screen
In this case I can fire (Show Loading Screen) anywhere in the form I want,
Like
Dim LoadingScreen as New LoadingScreen
LoadingScreen.ShowLoading()
' Do things
[code]....
View 1 Replies
Nov 19, 2009
I want to link sql server and vb.net (ADO.NET) . I'm using visual basic 2008 express edition and sql server management studio.
My problem is how to perform a search starting from the completion of a form (in vb.net ). On pressing the button search it verifies if the records are in the table (in my case FoaieParcursMasina).
SQL Server:
Step1: Create the table and insert into them the values (full DDL):
-- creating the table FoaieParcursMasina
CREATE TABLE FoaieParcursMasina
[Code]....
View 3 Replies
Jun 11, 2012
In my software course, each time we submit an assignment, we have to include a document with the starting properties of each object in a form.
E.g.
TextBox1
Location: 241, 115
Name: TextBox1
Size: 100, 20
TabIndex: 0
It's a real pain to scroll through the properties viewer and copy and paste each customised value for 30+ objects on a form... I was wondering if there'd be an easy piece of code or way about getting an (at least partially) automated printout/view of all the properties of the objects.
Was thinking some sort of private sub I could past into the bottom of the program and run on load, that gets all objects, and outputs the non-default properties to a report or something?
View 1 Replies
Jan 24, 2010
well basically i created a new instance of Form1 because i do not like to use a default form instance. but of course doing so gives me 2 Form1s. is there anyway to stop the default form instance from being generated? [code]
View 11 Replies
May 19, 2009
I have a Parent form that loads a child form and I only want to allow one instance of the child form. I have this on the button to open the form. Stepping through the code with the debugger it "appears" to work OK when the form is open (I say appears because nothing changes) but when the form is closed it doesn't open as I would expect. What am I missing?
[Code]....
View 6 Replies
Feb 24, 2011
In a vb 2010 project, I have 2 win forms: Form1 and Form2.
In the Form1 class there is a server-based timer: when the "elapsed event" fires, then I update the text of a Label1 on the Form2. A very simple code:
View 13 Replies
Nov 11, 2009
i deleted my previous start up form to be replaced by another one but each time i launch the application,the deleted start up form is still displayed.i dont know from where this deleted start up form is being loaded.
View 3 Replies
Jun 28, 2009
I created a SQL database using the migration tool.I am converting my access forms to VB.net (VS2008).I am wondering if I create a single dataset in studio to the database or do I create a dataset for each form (query)? I am trying to determine what the best solution is. Many of my forms have drop downs that are populated using queries from tables.
View 3 Replies
Nov 15, 2010
I'm writing a help application for the Customer support team at my company to help agents ask better questions when customers report problems. In it, I've got a SQL database that contains all the products, topics, and questions. The layout is similar to the following:
Products Table:
Product_ID Product Name:
Topics Table:
Topic_ID Product_ID Topic
[code]....
I don't know if I'm making myself clear, but I basically need to do the equivalent to the following SQL statement: "SELECT PRODUCT_ID FROM Products WHERE PRODUCT_Name = LstProducts.SelectedValue"
View 2 Replies
Apr 8, 2009
I have a DataGridView on a form that is being populated from a SQL table dataset by giving criteria from a previous form. I have 6 columns in the dataset, of which the last column should be combo box column containing items "Done" and "Pending". How do I make this bound column to a combo box column and display the value as well as the alternate item too in the combo box?
View 6 Replies
Feb 28, 2009
below i have the form which i made in access, its BIG, REALLY BIGI am going to try and recreate this form using VB and MySQL, the question is how?The purpose of this form is to display all locations ready for someone to enter in information into them, normally the first field in each table has a unique name (which is set as the default value for that field), in the morning, the only field which is altered is a sign on field, which in access, the user clicks and the time is entered.
View 7 Replies
Aug 24, 2009
I have two forms....Mainform is filled with controls that are databound to a datasource.....then I have a child form that is used to edit data from parent form.......the data that is displayed on the child form uses the Filter() method of the binding source to display data only for the customer selected......
The child form has the standard OK and CANCEL buttons set up as dialog result.......after I edit the content in child form, the changes are displayed on the child form correctly......but when closing the child form and going back to the parent form the changes dont appear there unless I restart the application.....I also tried adding the tableadapter.update/fill method in the 'OK' dialog result event handler and it still doesnt work......
How can I make the changes take effect on the parent form without restarting the application?
View 2 Replies
Jan 12, 2011
Had this matter on Xp machine and visual studio 2010 ultimate after windows update between december and january: even the simplest windows form program crash on start when starting for debug (inside Ide, F5) unless putting breakpoints on each line of the autogenerated (and marked as "debugger step thorugh") code.(see: [URL]) I was wondering if this matter affects only Xp machines, or if someone with Seven or Vista had same matter.
View 2 Replies
Aug 26, 2011
How can I add a new form to my project that is based on an existing form in the same project?
I want to add a new form to my project with the same control layout as an existing form in my project, and then just change the label text and so on.
I tried to just copy and paste, then rename the pasted .vb file, but get an error when I try to open it for modification.
View 3 Replies
Feb 24, 2012
Is it possible to reload a form of the running application from one computer when I executed a function from my other computer with the same application? co'z I want to see the changes of data on my datagrid view
View 1 Replies
Oct 7, 2010
I hope this is in the right category. If its not, direct me for where it should go. I'm quite a, what you would call "noob" to visual basic. I'm trying to make a web-based (LOCAL ONLY) Tech Request system for my LOCAL machines (Only 1 noted for use). I want a login area (I think I know what to do for that.), a open request area, a OPENED requests area, a way to CLOSE requests (by staff only), and and started/not started field for staff to use.
View 4 Replies
