VS 2008 : SQL Query - Works At Design Time But Not Runtime?
Aug 16, 2010
I've created an SQL Query using the query builder. In the query builder, you can test the query by clicking the button "Execute Query", and entering the desired values in the parameter fields.
My query returns the correct results when I do this, but when I seemingly pass the same values at runtime, I get 0 records returned.The query is designed such that you can pass nulls if you don't wish to filter data by that particular parameter.
SQL Query:
SELECT ID, UPC, Quantity, Manufacturer, Style, Color, Size, Category, DateReceived, Cost, OriginalRetail, Retail, LocationID
FROM Inventory
WHERE (UPC = @UPC OR
[code]....
In the query builder "Execute Query" dialog, I enter a value I know that the db contains in the "Size" field, "1/1/1900" & "1/1/2199" in Dates A & B, respectively, and nulls for all other fields. This returns 1 record, which is just as I expected. It works correctly.But when I pass the same values into the method created by the designer, I get 0 records returned. I can't figure out where the problem lies. Even if I enter nulls for all fields other than the dates, it returns 0. This tells me that the dates are causing the problem, but I can't figure out why, because I'm passing strings equivalent to what I entered in the query builder.
I use try catch finally to handle errors in my program. And these work fine when i debug application, but when i install it, error handling does not work?!
using VS2008, targetting framework 3.5I have a rather complex UserConrol which does some of its own rendering.I display this UserControl on a form.Opening that form in the Designer creates an instance of the UserControl in the Designer, which tells me a NullReferenceException is occurring in one of my rendering methods.I have attempted to correct this by making alterations to the UserControl's default constructor, but have not found success.
In some of the forms ,whenever i change some properties using the Properties Window of some controls or the form they get reflected in the Properties Window but will not get changed at Run Time.
I am facing this in quite many of the forms, hence i am applying the property changes in form load, this is causing performance breach .
In a VB.NET winform App I want to place icons on each tab header of a TabControl.I set the ImageList property of the TabControl and for each Tab I set the ImageKey property.My icons show as expected on each tab at design time within the IDE but when I run the App, my icons don't show (an empty space is shown instead).
I have a small dataset which has most of its schema defined at design time, but I add a few columns to one of its tables at runtime. My problem is how do I reset those changes? he dataset is not linked to any datasource. It just has its own table which I "manually" populate. The static columns have been added to the datatable at design time. However, I add a few columns as runtime based on a list of categories. Like this:
[Code]....
The dataset is used in a small dialog that pops up within my application. I add the dynamic columns when the dialog is opened by using the Load event. Everything works great the first time. But if you close the dialog and reopen it, there are problems. My startup routine tries adding the dynamic columns again, but an error is thrown saying the column already exists. I have tried a lot of things and did some reading but I can't figure out a way to reset the dataset when the dialog is closed. The only solution is to close the whole application and reopen it. I have tried the following in the Leave event of the dialog form:
I want to ask a question about adding controls in design time (controls may be any win form control or a user control) and adding the control in run time.
I'm using .net 2008 Trying to create a small graphic component, I have a problem setting background both at design time and then runtime. I derived a panel like this
[code]...
But it isn't working! If I don't Overrides Property BackColor, this is working as expected but I really need to group in my custom tab.
Is it possible to create a menu at design time and populate it at run time and then display it at the mouse pointer when I click on a cell in a datagrid?
I am creating a custom Label control (by simply Inheriting the standard Label control and re-painting the background and text) because I need a very specific background and border. In the constructor of the control, I set the AutoSize property to false so I can have a standard default size for the new label.
Public Sub New() /*Set the default size of the control to 75x24*/ Me.Height = 24
[code]....
In my application that uses this control, if I create the new custom label at run time (in code), the AutoSize property stays False, and it works properly.If I try to add the new custom label to my form at design time, it comes in with the AutoSize property set to True, and I have to manually set it to False in the properties window. It's not a huge problem, but I don't understand why the behavior is different.
New to reports here. Using VB.NET, my application makes use of datatables it creates from a postgresql database.These datatables are defined at runtime rather than design-time, and I would like some way of generating reports from these datatables at runtime as well.
Should I be trying to create the report template at design-time, and then "binding" a datatable to it at runtime?
i have a treeview which has a bunch of parent and child nodes preset at design time, there is 1 parent node tho which is called developer, that i want to add child nodes to at runtime.When the form first loads im trying to have it check a text file and for each line in the text file add the text/string from that as a child node tot he 'developer' parent node.
vb Dim reader As String = My.Computer.FileSystem.ReadAllText(Application.StartupPath() & "ConfigDevs.txt") Dim strs() As String = Split(reader, Environment.NewLine) For Each s As String In strs
[code]....
Thats what i have so far, how can i set it so 'Dim parentNode As TreeNode = ' points at the 'Developer' node?
I have a question regarding the manipulation of a form at runtime. Let's say I created a simple form in the form designer before runtime containing a couple of buttons, text boxes and labels. While the program is running, I would like to change properties of these controls, while having the ability to move them around, along with the addition of newer controls, say a listbox.
After the form is 're-designed', I would like to save the new settings of my form, in either a database or settings file. Whats the best way to implement this?
Im having odd problems with how my form is displaying at runtime...if you look at the 2 attachments you can see at runtime the labels disappear under the check box's, but at design time they are positioned perfectly.
I have created a query method for my tableAdapter in the dataset designer. I typed the command text manually, but tested it in the query builder after I got a Constraint Exception when debugging. When running in the query builder via 'Execute Query' I get exactly the results I expect. When running the application I get this exception: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." I tried temporarily setting my dataset's EnforceConstraints property to FALSE but still get the same exception. I can't understand why the Query Builder would return the correct datatable but running the app would not. Is this a bug?
I'm currently working on a treeview but want to add custom nodes at design time, is this possible?Also the treeview is part of a control, so i have created a control designer and added a custom design time form to add my custom nodes, but can't seem to get the nodes into the treeview in design time, and serialize into the form automatically?All my custom tree node is is an extra integer at the minute, but more properties will be added later if I can get this working.
OK maybe this is completely silly question that everyone knows the answer to but me! Is it possible to hide a component while in design view? e.g. I'm working with multiple components that overlap and would just like to be able to view/work on one at a time. Have I completely missed something or is this not possible?
When I use the Execute Query button in the Tableadapter Query Builder, the query works fine; I get all the rows I expect. However, when I run this in my code, the query behaves like an equality statement (i.e. Lotnumber = @Lotnumber) rather than a LIKE statement (Lotnumber LIKE '%' + @Lotnumber + '%').Here is the code that is not behaving correctly. Note that I have a textbox, LotSearchTextbox, where I enter the portion of the Lotnumber that I want to use as the filter. I also have a button, LotSearchButton:
Private Sub LotSearchButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LotSearchButton.Click Try Dim SomeNumber As Integer = Me.LotCalcinerO2TableAdapter.FillByLotNumber(Me.CalcinerDBDataSet.LotCalcinerO2,[code].....
why the query works in the Query Builder but not in the code?
Can we make the Combo Box not drop down if we click on it even though it have item in the list, button not click-able even though it have the on_click event..textbox not allow to set focus but not in disable mode...everything like design time.. because I want to do drag and drop control like visual studio.. but I can drag now, just when I want to click the control to drag, the control still remain the default function...
How can i do this ... by the propper way i mean so that the grippers don't even display - like they do with an auto-sized label, or a non-multiline textbox.
I recently made some changes to my VB 2008 application, and now there are crosshatched lines throughout parts of my tab-control at design time. When executing the application everything looks fine, and there are no errors generated. Why has this happened?
I have a UserControl with a Panel (Panel1). The UserControl has a property Items (type ControlCollection) that returns the Controls collection of Panel1.Via a custom CollectionEditor, I tell the designer that it should add my custom controls called Item (inheriting Control). For the sake of example, the Item control is just a control with a random background color:[code]The custom CollectionEditor creates new Item controls using the DesignerHost service (and its CreateComponent method), so that they appear as actual components in Panel1, selectable during design-time just like any other control.It might be a little hard to see (because the colored Items are docked to the top), but I have selected the red item, which can also be seen from the Properties list.
As you can see in the code, I attach a Click event handler to each item as it is added to Panel1. When clicked, a MessageBox shows the color of the item. Obviously this is just for the sake of this example, but the point is that I need to be able to click an item and something then needs to happen.This works fine during run-time. I can click each item, and the MessageBox shows.The problem is that it does not work (quite obviously) during design-time. When I click it during design-time, it is simply selected (as any other control) and of course does not register any Click (nor MouseClick) events.But, I need the Click event to fire even when in design-time! Clicking an item corresponds to selecting it, and when selected (even in design-time), some other panel (not shown in this example) should be brought to the front so it gets visible. Now, I have created lots of things very similar to this (clicking an item during design-time), but there has always been one major difference: those items were not actual controls on the form. Instead, they were drawn manually on to their parent (and they only looked like separate controls). Obviously there was no design-time support for those 'items' (as they weren't controls), but I could handle clicking them quite easily: by handling the MouseClick event of the parent, I can check the location and see if it falls within an item. If so, that item was 'clicked' (artificially).This time, the items are actual controls, and this method does not work (the parent does not receive a MouseClick event either).So, does anyone know of any way to do this? The only way I can think of right now (although I have no idea how to implement it) is to somehow 'listen' to changes in the designer selection.
I've written my code to implement a new property and to set the content to this default text and grey the text whenever the textbox is empty, and to hide it when the user starts typing. This all works fine at runtime.[code]My question is this : If I place an instance of the control on a form, and set the DefaultText via the properties grid, why doesn't my Property Set code run?I'd expect the control on the form to show my new DefaultText in the control, but instead it remains blank. When I run the form it does display correctly, but just not at design time. I place a breakpoint in the DefaultText set property code and it simply doesn't run.
I have a TabControl on a UserControl. I want the UserControl to behave like a TabControl as usual (it contains only the TabControl and a Contextmenu), including Design-time behavior.I have spent the last two weeks finding out how to add the Design-time behavior and I think I have come a far way.The problem is with adding TabPages during Design-time (while the UserControl is a custom tabcontrol, it is using regular windows forms TabPages).In the Designer class, I have the following code to add a TabPage:
vb.net Dim dh As IDesignerHost = DirectCast(GetService(GetType(IDesignerHost)), IDesignerHost) If dh IsNot Nothing Then Dim i As Integer = tc.SelectedIndex Dim name As String = GetNewTabName() Dim tab As TabPage = TryCast(dh.CreateComponent(GetType(TabPage), name), TabPage) tab.Text = name tc.Controls.Add(tab)
[code]....
So it would add the control to the TabPages collection if it was a TabPage, and use the regular routine otherwise.
(I'm now using 'tc.Controls.Add(tab)' again instead of 'tc.tabCtrl.TabPages.Add')
But, I don't think the designer even gets that far because it is telling me I cannot add TabPages to my usercontrol, because only TabControls can accept TabPages... How can I make my usercontrol understand that it is a TabControl (without Inheriting from a TabControl?)
Im doing my first project with WinForms, and Im trying to get the DataBinding working. Theres no database in my project, but I'd like to bind some of the TextBoxes to objects' properties. In the other section of this forum (here) I found this line of C# code which does it: textBox2.DataBindings.Add(new Binding("Text", this.myPerson, "LastName"));
my question is can data binding to object properties be set up during design time (without writing code)? If so, how? P.S. I know how I would set up this binding if in WPF, but I'm forced to use WinForms.
I am trying to extend the functionality of the ToolStripPanel control (which is a panel hosting ToolStrips that can be moved during design-time, as I'm sure you know).One thing I wanted to add was a 'ToolStrips' property, which would be a collection of ToolStrips the user can edit via the collection editor in the designer. So instead of manually placing ToolStrips on the ToolStripPanel via the toolbox, the user can just use the property to add/remove (or even edit) them. This is of course similar to how you add/remove/edit TabPages in a TabControl.So, I came up with this code, which I have used successfully in the past for other controls:
Public Class cToolStripPanel Inherits ToolStripPanel Private _ToolStrips As New ToolStripCollection(Me)[CODE]....
The cToolStripPanel control inherits the ToolStripPanel control and adds the ToolStrips property, which is of type ToolStripCollection. That class, in turn, inherits the Collection(Of ToolStrip). In the InsertItem method, I add the 'item' ToolStrip to the cToolStripPanel. Of course I also need to override the RemoveItem / ClearItems methods but that's for another time.I am 100% sure that this code should works, at least for other controls. If you replace ToolStrip with Button (for example), I can add buttons via the property during design-time just fine, exactly the way I want it.But it seems that ToolStrips are special. When I try to Add a toolstrip (via the collection editor Add button), a null reference exception occurs. I've been trying to debug this all day and I've finally come up with a possible candidate for the problem... (I've actually used design-time debugging for the first time ever, which was pretty cool, and which showed me that the InsertItem method is not run!)
I think the problem is that the collection editor cannot create a new instance of the ToolStrip class. I can remember when trying to inherit from the ToolStrip, I was forced to add a constructor, because the ToolStrip "has more than one constructor that can be called with no arguments".Perhaps this is causing my problem? Do I (and if yes, how?) have to somehow control the creation of a new instance of the ToolStrip? Or am I completely off track and that is not what is causing the problem? I'm sure that it's a problem with the ToolStrip class, since I can use the exact same method with other controls just fine. It's only when I change the type to ToolStrip that it starts getting angry at me....
I created a RDCL in the designer. I would like the User to Determine what is shown in the Report. How can I change the query at runtime? (ex. changing the customer Name)
This is the query that I have in the properties:
SELECT [Date], Address, Customer, Orders FROM Report_qry WHERE (Customer= 'JohnDoe')
Just started with VS2010. (vb) Coming from VS2005. (i skipped VS2008)
My question is this. Why do I have to hit save before every build in order to see design changes at runtime? Example: I change the text on a button at design time. I click on run and the text does not reflect the change. But if I saved the form before clicking run, than it does. Also like to add VS2010 runs much slower compared to VS2005 running on the same computer. I understand VS2010 can do more, but a lot of times you don't need it to.
