.NET SQL Query Designer Control

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Winforms
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Chart on Windows Form VS2005 I have VS2005 Team Edition for Software Developers Version 8.0.50727.42 with .Net Framework 2.0.50727 I have created a Windows Form Project. I have installed OWC11. I have Office 2003 installed on my machine. I have added references to Microsoft Office Web Components 11.0, Microsoft.Office 11.0 Object Library, Microsoft Graph 11.0 Object Library, Microsoft Excel 11.0 Object Library I click tools, chose toolbox items, Comm components and select Microsoft Office Chart 11.0 I drop a chart on my form. When I run the project and open the form I get: Could not load file or assembly 'Interop.OWC11, Version 1.0.0.0, Culture=neutral, PublicKey Token=null' or one of its dependencies. The system cannot find the file specified. Tag: .NET SQL Query Designer Control Tag: 100883
  - 2
    - ListView selection I have a ListView control, and anytime I manually set the selected item, the original item OnSelectedIndexChanged event fires twice. Here is a sample of what I am doing in the OnSelectedIndexChanged function: if ( listView1.SelectedItems.Count == 1 ) { MessageBox.Show( "index = " + listView1.SelectedIndices[0].ToString() ); if ( isinternal ) return; isinternal = true; if ( last >= 0 ) // last is the last selected index { MessageBox.Show( "Not Shown" ); //behaves regardless if the next line is present listView1.SelectedItems.Clear(); listView1.Items[0].Selected = true; } last = listView1.SelectedIndices[0]; isinternal = false; } else if ( listView1.SelectedItems.Count == 0 ) { } I have 4 items in my ListView. Assume I select index 4. I should see message boxes in this order: index = 4 Not Shown index = 0 However, I really see index = 4 Not Shown index = 0 index = 4 Not Shown index = 0 If I don't manually set the selected index to 0, the control behaves as expected. Why does manually setting the selected index cause this behavior? How can I manually set this index and avoid this behavior? Thanks in advance for your help! Tag: .NET SQL Query Designer Control Tag: 100879
  - 3
    - External component has thrown an exception Hi, I'm getting this error really sporadically in my Winforms app. Seems to happen when trying to display a form with a call to .ShowDialog() It doesn't seem to happen on any particular form, just pops up now & again. I can close the application and restart it, then I can view the form without the error? The application is running in a Citrix terminal server environment, the assemblies themselves are running from a network share. Can anyone think of what would be causing this error - why is it only happening every now & then (the worst sort of errors!) Thanks Dylan Tag: .NET SQL Query Designer Control Tag: 100878
  - 4
    - MDI Form question hi, I am new to winForm development. When I am using the .NET 2.0 MDI Forms, I want to close one of the child form at the very begining. For example, I want to close Form1, so I write public Form1() {this.close();} And in the MID Parent, I write form1 = new Form1(); form1.MdiParent = this; form1.Show(); The problem is that everytime I open Form1, it will close but there will be an object dispose exception unhandled and my program will hang up. Could anyone here please tell me how to solve this problem? I just want to close one of my child form. Thanks a lot! Tag: .NET SQL Query Designer Control Tag: 100875
  - 5
    - Datatable Row Number Hi All, I am using a datatable to store some data from the xml. I need the row number where a particular string exists (Note: All values in datatable are unique). Please help me in this regard. Tag: .NET SQL Query Designer Control Tag: 100870
  - 6
    - How to check if application is in debug mode Hi, Is there any way to check if the application is in debug mode or running from the exe. Thanks in advance, Debi Tag: .NET SQL Query Designer Control Tag: 100866
  - 7
    - RichTextBox Control Captures Shortcut Keys in Regular Windows App but Fails to Capture in an MDI App? Hello All, First, I apologize for posting this to so many newsgroups but I wasn't sure which newsgroup was most appropriate nor which newsgroup would most likely have subscribers that have done this or would have the answer. That said, below is a description of my problem: If I create a standard Windows executable in C# or VB.Net and place a RichTextBox control on the main form, the control captures standard shortcut keys as expected (i.e. Ctrl-V, Ctrl-X, etc.). However, if I add an MDI parent form to the project, make the original form a child form to this parent MDI form and display the original form, the RichTextBox control no longer captures these shortcut keys. Can someone please tell me what is necessary to correct this behavior? Thanks & Regards, TC Tag: .NET SQL Query Designer Control Tag: 100865
  - 8
    - Application Settings I'm just venting. I finally got around to converting a big WinForms app for my biggest client to .NET 2.0. I've heard all along that application settings are now writable, which has always been one of many bones of contention with .NET 1.1 for me. So I get to the point where I am going to convert my custom settings mechanism, do a little investigation, and find out the reason I made a custom configuration file mechanism hasn't changed at all. Sure - you can write user setttings, and settings are type safe now, but the application scope settings are still read-only. (If anybody knows a reasonable workaround that works within the framework for this, I'd like to hear it). I certainly understand MS's reasoning for making them read-only, but I'm more of the mind that in "most cases" the application settings shouldn't/wont need to be written. However, to prevent it altogether is simply stupid, imho. I feel like I'm old enough to be responsible for my own actions by now. I do like the new stuff for user settings and for application settings that don't change, so I'm actually going to use the new stuff for all of that. However, I have one setting that all users must be able to change, and must be the same for all users. I had a custom configuration file, and I allowed write access to its containing folder on installation. I may move this value to the database for now. Or, Gawd Forbid, the Registry! Don't get me started on generic collections! Ok, I'll start, but just barely... Ha! Have you seen the Find() or Exists() method on List? Here's the code to find '6' in a list of ints: List<int> myInts = new List<int>(); myInts.Add( 0 ); myInts.Add( 1 ); myInts.Add( 2 ); myInts.Add( 3 ); int n = myInts.Find( delegate(int x) { x==6; } ); // seems rather obtuse to Find(6), doesn't it? This returns '0'! Ha! int m = myInts.Find( delegate(int x) { x==0; } ); // This returns '0' too! I tried deriving my own collection, and quickly found that two values of type T cannot be compared. I'm sure there's a good reason for this - I just hope there's a better workaround eventually. It makes me wish for the days #define! Even though that's just the tip of the tip of the iceberg of my complaints, I still like it (2.0 that is). It's definitely a step in the right direction. Tag: .NET SQL Query Designer Control Tag: 100854
  - 9
    - How can I make a modeless form receive input when a modal form is open? >From my main form, I can open and access a modeless form. However, if I then open a modal form (from the main form), the modeless form will no longer accept keyboard and mouse input until the modal form is closed. Is there a way to allow the modeless form to continue to receive input? As an example, Windows Notepad does this. If you open the Find dialog, then open the About box, you can still access the Find dialog. Any pointers appreciated. Thanks, Andrew Tag: .NET SQL Query Designer Control Tag: 100850
  - 10
    - Non-rectangular Window Hi, I have developed an application that looks like Windows Media Player. Every thing looks wonderful, but when I resize the window it flickers a lot. How can I implement resizing of the window without any flickering? Remember my window doesn't have frame border, title bar etc. thanks, Balu. Tag: .NET SQL Query Designer Control Tag: 100848
  - 11
    - Image beneath of my window I have Windows application, and I need to draw on it surface the content of desktop (which may consist from another windows or part of desktop or their combination), so, the question is: How to get image which contains windows and/or part of desktop which are located under my window? Tag: .NET SQL Query Designer Control Tag: 100847
  - 12
    - Moving images fluently I am looking for technique which allows to fluently move several images over the form without using DirectX & Open GL. Several images should be moved simultaneously but with different speed. Also one more feature: I should be able to change their (moved images) opacity during moving. Does anybody know good algorithm (or may be article, example, link) to implement these features? Tag: .NET SQL Query Designer Control Tag: 100846
  - 13
    - Setting focus to a control within a usercontrol I have a user control that contains a grid. I want to set focus to the grid when the user control receives focus. I have tried calling grd.focus() for the gotfocus of the user control, but that doesnt work. Any ideas? Thanks Tag: .NET SQL Query Designer Control Tag: 100838
  - 14
    - Get Notification when an external application started I have create two windows applications called WinAppX andWinAppY. First I opened the WinAppX . When ever i opened the WinAppY ( second app ) , the WinAppX should get notification , after that these two app should communicate each other someway. How can i do this.. Tag: .NET SQL Query Designer Control Tag: 100833
  - 15
    - autosrollbar does not activate I have a windows form with a button on it. The button anchor property is right and the forms autoscroll property is set to true. When adding a second control (also anchor.right) to the left of the viewable area, the scrollbar does not activate. Why? When using anchor.left and adding controls to the right, the scrollbar activates automatically. I want to have the same functionality when adding to the left of the screen. Tag: .NET SQL Query Designer Control Tag: 100831
  - 16
    - Problem with no touch deployment of application which has dynamically loaded assemblies We have an application which dynamically loads an assembly and creates instances of classes. For this we have written a factory class which reflects the assembly and creates the classes and returns the created objects as plain objects. The caller method casts the object returned by the object factory into appropriate class object and uses it. All this works fine when exe is invoked directly. But when the application is deployed on the IIS for no touch deployment, the casting of the object returned by the object factory is throwing an invalid cast exception. Strange thing is that the statement that is causing exception during run time works fine if executed in the Immediate window of the VS.Net IDE. How do I fix it? Tag: .NET SQL Query Designer Control Tag: 100826
  - 17
    - TextRenderer problem Hi, I'm creating a control that overrides ListView and so I'm working on redrawing everything myself with some changes here and there... But I'm having a problem with drawing the text inside the rectangle on LargeIcon mode... I thought I'd finally discovered the solution with TextRenderer but this still doesn't give the correct results. Here's the code I'm trying to use (item is a ListViewItem) Rectangle text_rect = item.GetBounds(ItemBoundsPortion.Label); TextFormatFlags formatFlags = TextFormatFlags.WordBreak | TextFormatFlags.HorizontalCenter | TextFormatFlags.Top | TextFormatFlags.EndEllipsis; if (item.Text != null && item.Text.Length > 0) TextRenderer.DrawText(dc, item.Text, item.Font, text_rect, item.ForeColor, item.BackColor, formatFlags); The problem is that its still not exactly what the original ListView displays... ie I'm displaying: ___________ | some | | really long | original ListView displays: ___________ | some really | | long text | Surely it should fit inside the bounding box if its using the GDI draw method and I'm using the bounding box thats returned to me from the ListViewItem itself? Any ideas? thanks Kris Wragg Tag: .NET SQL Query Designer Control Tag: 100820
  - 18
    - Custom Control Design Time Property Selector I'm creating a custom control with design time support, i wish to create the a property which is xml document and let the deisgner to use the property selector in VS.Net to browse to the xml file and attach it to the custom control, how can i do that? Tag: .NET SQL Query Designer Control Tag: 100816
  - 19
    - How to make dynamic toolboxes ina form Hi there, I'm doing a GUI for my apllication and i wanted to know if it is possible to do something similar to what is done in the GUI of whidbey. I want to have in the right part of my main form toolboxes that i can show or hide dynamically to let the user save space. Anyone knows how can i do it? Tag: .NET SQL Query Designer Control Tag: 100812
  - 20
    - Customization In Web Application All, Using VS 2005, C#.NET, SQL Server 2005, W2K3. We are developing a web application that would be shared by numerous customers for information management. Some of those customers want variations on the usual form layout. For example, we have a form where the user can enter their dependents information (parents, siblings, spouse, kids, etc.), but we know one of our customers wants to include additional information on that form that none of the other customers would use (company specific insurance coverage). Based on our experience with our C/S version of the product, we can expect to see many more requests like this. There are 3 ways to do this that I see. 1. Create a separate web application for that customer and host it on a different web server. 2. Add the custom fields to the single web application but hide the extras based on the customer using it. 3. Allow the customer to add the fields themselves and store them for just that customer. Pros and cons that I see. 1. Quick to implement, but costly in new infrastructure, and would end up difficult to maintain. 2. Still relatively quick to develop, and uses existing infrastructure, but would create complex forms. 3. Difficult to develop, but would use existing infrastructure and wouldn't need extra maintenance. Personally, I'd like to use 3. That is... Design the application so that each form includes standard fields, but a customer can add new labels, textboxes, drop-down combos, lists, etc., themselves and doing so doesn't require us to change any code or the database schema. While this would be a no-brainer in an C/S application, it gets a little more difficult in a web app since the only client they use is a browser. Any thoughts? Tag: .NET SQL Query Designer Control Tag: 100808
  - 21
    - Type of member 'DataReader1' is not CLS-compliant. Hi, Why do I have this error in one project but not another? Type of member 'DataReader1' is not CLS-compliant. Tag: .NET SQL Query Designer Control Tag: 100806
  - 22
    - Bigger Large Icons in listview, possible? Hi all, I'm just wondering if it's possible to make the icons under large icons view in listview bigger? For some reason, I think the default is set at 16 X 16 pixels? I don't think I've done anything wrong? ----------------------------------------------------------------------------------------------- this.listView1.View = View.LargeIcon; this.listView1. ImageList il = new ImageList(); il.Images.Add(Bitmap.FromFile("C:\\pictures\\topics\\1.gif")); listView1.LargeImageList = il; ListViewItem item1 = new ListViewItem("ALL"); item1.ImageIndex = 0; listView1.Items.AddRange(new ListViewItem[] {item1}); --------------------------------------------------------------------------------------------------- Even though it was set to largeIcon, it's still only 16 X 16 pixels at best. Any help will be appreciated. Cheers Edmond Tag: .NET SQL Query Designer Control Tag: 100805
  - 23
    - How to attach to a process middle tier for debugging Hi, I'm consulting on a project that has two solutions, a client solution, and a middletier solution. The middle tier solution is hosted in asp.net. I want to debug something in the middle tier, and I've been told that I have to attach to the asp.net process. So I add a breakpoint on the code in the middle tier. I build the middle tier solution and then the client solution in debug mode. Then I start the client application. Then I'm supposed to attach to the ASP.NET process. I've tried to attach to the asp.net process from both solutions but the debugger doesnt stop at the breakpoint. The middletier is not in the client solution, but is referenced Can Anyone help? Tag: .NET SQL Query Designer Control Tag: 100803
  - 24
    - TextBox Size.Height Is there any way to control a TextBox Size property's Height? Besides making it Multiline? Everytime I set the Size, it always reverts back to Size.Height = 20 (or whatever value based on the current font, I think). I've tried setting the Min/Max Size but that only seems to hold during design time. Tag: .NET SQL Query Designer Control Tag: 100800
  - 25
    - Marlett not allowed? [VS 2005] I want to display a right-pointing triangle glyph like that indicating a submenu. This is "8" in the Marlett font. However, when I put a label on a form and set its font to Marlett, all I see is a regular "8", both in the designer and when the app is running. Is there a limitation? I once created a drop-down button by explictly drawing text in Marlett, and that worked, but I had to do it that way because I was using two fonts (one for the button text and one for the down glyph). I'd like to avoid doing that much work when it seems like the control should handle it for me. Suggestions? Tag: .NET SQL Query Designer Control Tag: 100794
- Next
  - 1
    - Form -> Panel -> Child Form -> Resize -> Bug? I'm using the following code to show/hide a form located inside a panel that is located on my main form. The panel is set to DockStyle.Fill so that when the main form is resized the panel is also resized. The problem is that the included child form never resizes beyond it's initial starting size. Don't child forms respect the DockStyle setting during resize of parent controls? If I take out the commented lines of code it works - but of course it looks like crap while doing it. Button click event: if (f2 == null) { f2 = new Form2(); f2.TopLevel = false; this.pnl_childform.Controls.Add(f2); } if (!f2.Visible) { f2.Show(); f2.BringToFront(); f2.Dock = DockStyle.Fill; //f2.WindowState = FormWindowState.Minimized; //f2.WindowState = FormWindowState.Maximized; } else { f2.Hide(); } Tag: .NET SQL Query Designer Control Tag: 100792
  - 2
    - AD Replication Problem Hello All, I recently restored two of my Windows 2003 domain controllers from a backup. They were backed up using Symantec LiveState Recovery 6.0. Everything seemed to be just fine, but just recently I noticed that AD Replication is not working. I've received Event id: 13559 Source: NtFrs. I did some research and tried what's suggested at the following link http://www.eventid.net/display.asp?eventid=13559&eventno=657&source=NtFrs&phase=1 That doesn't seem to resolve my problem, after creating the NTFRS_CMD_FILE_MOVE_ROOT file with no extension in C:\winnt\sysvol\domain, and running "net stop ntfrs" and then "net start ntfrs" I notice much diff. I did get Event Id: 13508 Source: NtFrs. Also, I can see both the servers in Sites and Services. But when I try to manually replicate i get "The Source server is currently rejecting replication requests" Does anywhere know how I resolve this issue? It's causing major issues for me and I need to figure it out ASAP. Last thing I wanna do rebuild any of the servers! Please HELP! -- Raghbir Flora Network Administrator Tag: .NET SQL Query Designer Control Tag: 100790
  - 3
    - How to get ValueChanged event from PropertyGrid collection using default editor? When makign a change to a collection using the default editor in the property grid, you do not get a value change event. Now I know I can code up my own editor and deal with the valeu change myself, but I have 40 lists I'd have todo this with and it seems like there should be a way to get the default editor to work... Anyone have any ideas? Tag: .NET SQL Query Designer Control Tag: 100783
  - 4
    - Problem with Waiting Form Owner I have a process that take some time to process data in formA. While processing the data I wish to pop a "waitingform". The waiting form have it's own thread and show the process advancing between 0 and 100%.There is a timer within the Waitingform, on each tick the progress percentage is read and display, also this reflect that the program is still running. When the processing finish, the waiting form just close. I have done everything and it's work well except for one thing. I wish the waiting form to be modal and own by the main form. If I set the waitingform owner : WaitingForm->Owner = FormA The waitingform doesn't appear before the data process finish, the form disappear as soon as it appear. If I dont set the owner, the waitingform works as expected, but can be lost behind other windows, and user may believe there is a problem when it's not. I use multiple threads in my application. The data processing thread is not the same as formA nor the same as the Waitingform. Does someone have an idea how I can set the ownership of the waiting form and still keep the behavior i wish? Thank you Tag: .NET SQL Query Designer Control Tag: 100777
  - 5
    - how to raise the click event by code Hi all, I want to raise the event click of a control by code. How can i do that ?? Tag: .NET SQL Query Designer Control Tag: 100773
  - 6
    - Best way to organize large project I am working on rewriting a Fox 7 ODBC app. and teaching myself .NET in the process. So far I have over 130 of the screens rewritten, but debug performance is terrible. It would be much better if I had each screen as seperate solutions, but then I'm constantly having to remove and readd references which became way too much hassel. So currently my solution has the 130+ projects included. But when I start debugging it rebuilds EVERYTHING! eventhough I haven't changed a single thing!! I can play a hand of Solitaire before it finally starts executing. Not finding this situation very productive at all!!! Is there an option that can be set to only rebuild changed modules? Or has the size of my application exceeded the capability of .NET? It sure is looking that way. Or how should an application of this size be organized? The two ways I've discovered each have serious flaws and I'm seriously wondering about the feasibility of developing large application in .NET. -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/winform/200605/1 Tag: .NET SQL Query Designer Control Tag: 100759
  - 7
    - scroll user control? I am painting my control entirly and need it to show scroll bars when it's being resized below it's min size. Please suggest how to go about this. Simply setting autoscroll to true does not work. Thansk in advance. Tag: .NET SQL Query Designer Control Tag: 100755
  - 8
    - deployment i was finish project with visual basic 2003 + SqlCE database for POCKET PC, and now i have to create setup can someone help me a little, couse all that is realy confused for me :-( Tag: .NET SQL Query Designer Control Tag: 100747
  - 9
    - capture application output Hi, How can I capture the text output of a console app? For example, I would like to capture the outpur of "qwinsta" Thanks. Tag: .NET SQL Query Designer Control Tag: 100746
  - 10
    - How to kill a terminal server session (VB.NET) Hi, Is there a way to kill a Terminal Server session from vb.net? I have to constantlly access our servers to reset ureser that get hung. I would like to have a web interfave that I can access via my PDA/Phone. It dose not have to be a wab page that does this. I could write to a queque that is read by a windows servrice on the TS server and then reset the user. Thanks. George. Tag: .NET SQL Query Designer Control Tag: 100745
  - 11
    - ErrorProvider in Datagrid with Comboboxcolumn Hello, I have got a Datagrid containing a Datagridtablestyle which is a comboboxcolumn derived from DataGridColumnStyle. When validating my datagrid the error icons appear but the tooltip does not appear. Not having a comboboxcolumn everything is fine. My first idea is to implement the IDataErrorInfo interface in my Comboboxcolumn but there is no effect! Can anybody help me? Thanks Tag: .NET SQL Query Designer Control Tag: 100741
  - 12
    - grid component similar to Excel Hi all I need a suggestion. I have a customer that wants the grids in the application i'm going to develop lokoking as much as possible as Excel grids. I suppose he wants the filtering possibilities of Excel in the header of the grid, the possibility to copy&paste from one cell to the other etc. My question is: is there any component that can suit my needs? something that someone used/has used for large scale apps? Please give me a suggestion! Tag: .NET SQL Query Designer Control Tag: 100736
  - 13
    - how to point the cursor in specific cell Hi everybody, im working in infragistics ultragrid. Can any one know how to get the cursor in to active cell . i need to check the empty field before leaving cell. if its empty then cursor should be forced to come into the empty field. ive tried in beforedeactivecell event but the cursor is not coming to the empty field when i changed the cursor to another cell. below is my code *** //function returns bool if cell is empty chekemfield =checkemptyfield(); if(chekemfield ==true) { MessageBox.Show("Field must be entered","V-1550",System.Windows.Forms.MessageBoxButtons.OK,System.Windows.Forms.MessageBoxIcon.Error); ultraGrid1.ActiveRow=ultraGrid1.Rows[actrowinx]; Infragistics.Win.UltraWinGrid.UltraGridCell acell; acell = ultraGrid1.ActiveRow.Cells["INSULATION_DUTY"]; ultraGrid1.ActiveCell = acell; ultraGrid1.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode); //function public bool checkemptyfield() { string duty=ultraGrid1.ActiveRow.Cells["INSULATION_DUTY"].Value.ToString(); string material=ultraGrid1.ActiveRow.Cells["INSULATION_MATERIAL"].Value.ToString(); if(duty==string.Empty || material==string.Empty) { chekemfield=true; return chekemfield; } else { chekemfield=false; return chekemfield; } } **** can anyone help me -- We cannot find solution but will arise from SuperConscious. Regards Prabakar Tag: .NET SQL Query Designer Control Tag: 100735
  - 14
    - infragistics how to get the cursor in specific cell Hi everybody, im working in infragistics ultragrid. Can any one know how to get the cursor in to active cell . i need to check the empty field before leaving cell. if its empty then cursor should be forced to come into the empty field. ive tried in beforedeactivecell event but the cursor is not coming to the empty field when i changed the cursor to another cell. below is my code *** //function returns bool if cell is empty chekemfield =checkemptyfield(); if(chekemfield ==true) { MessageBox.Show("Field must be entered","V-1550",System.Windows.Forms.MessageBoxButtons.OK,System.Windows.Forms.MessageBoxIcon.Error); ultraGrid1.ActiveRow=ultraGrid1.Rows[actrowinx]; Infragistics.Win.UltraWinGrid.UltraGridCell acell; acell = ultraGrid1.ActiveRow.Cells["INSULATION_DUTY"]; ultraGrid1.ActiveCell = acell; ultraGrid1.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode); //function public bool checkemptyfield() { string duty=ultraGrid1.ActiveRow.Cells["INSULATION_DUTY"].Value.ToString(); string material=ultraGrid1.ActiveRow.Cells["INSULATION_MATERIAL"].Value.ToString(); if(duty==string.Empty || material==string.Empty) { chekemfield=true; return chekemfield; } else { chekemfield=false; return chekemfield; } } **** can anyone help me -- We cannot find solution but will arise from SuperConscious. Regards Prabakar Tag: .NET SQL Query Designer Control Tag: 100733
  - 15
    - How to control date format in combo Hi All, This SHOULD be simple, but I just can't see it... I have a combo box which uses a dataset as its list source. The displayed member is a date column from the underlying table. When I run it, the date in the combo is formatted as d/m/yyyy hh:mm:ss, which I don't want - I just want the date part. How can I control the format of the date? Do I have to delve into owner-drawing? Surely not! Thanks Tag: .NET SQL Query Designer Control Tag: 100730
  - 16
    - Processing Enter on Form Controls I've been having trouble correctly processing the "Enter" key on form controls. Here's what I've done: Set the "AcceptsReturn" property to true Overridden IsInputKey and KeyDown; on KeyDown, if the "Enter" key was pressed, I set e.Handled to true. So now I'm receiving the event, which is good but.... When I press "Enter" in that control (it's a text box, if that makes any difference) I get the Windows "Default Beep." I don't want the default beep. Who else is receiving this event, and why is it causing the default beep? How do I stop this behavior? On a related note: I remember writing Windows software back in the day, and there were handy programs that would show me *all* of the events a particular control received...event watchers. Does Visual Studio have such a program and, if not, I assume there is something out there...if anyone has any recommendations, I would welcome hearing them. Tag: .NET SQL Query Designer Control Tag: 100726
  - 17
    - Newlines in TextBox I'm trying to programatically add new lines to the content of a (System.Windows.Forms.)TextBox and, while I have found a solution, I feel that it can't be very efficient. There must be a better way. I first tried: textBox.AppendText( "\n New line" ); But that didn't work. Nor did variations on the theme, like textBox.Text += .... Here's what *did* work: String[] lines = new String[textBox.Lines.Length+1]; textBox.Lines.CopyTo( lines, 0 ); lines[lines.Length-1] = textBox.Text; textBox.Lines = lines; This seems very inefficient since we're copying the *entire* contents of the text box just to add a single new line. Am I missing something here? -- T Tag: .NET SQL Query Designer Control Tag: 100724
  - 18
    - Problem with ServiceController.ExecuteCommand Running ServiceController.ExecuteCommand on my custom service raises a "Cannot control service on machine <machineName>". Drilling thru the inner exceptions, I come across an "Access is denied" error msg. Funny thing is I can start and stop the service using the same ServiceController instance, so an issue on permissions seems remote. Service originally runs under LocalSystem; changed it to my Windows account but had no effect. Any help will be greatly appreciated. Tag: .NET SQL Query Designer Control Tag: 100718
  - 19
    - How to disable search i ListBox/ComboBox This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C67355.993BB800 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, All: In ListBox and ComboBox when you type a letter, say 'k', it will jump to = the first item starting with 'k'. I want to disable it and do my own = search that can search more than one letter, like 'kite', not just one = character which ListBox currently does. But I cannot disable ListBox's = own search. everytime when I type 'i', then jump to the item starting = with 'i', not the one starting with 'ki'. Do you know how to disable it? Thanks, Dennis Huang ------=_NextPart_000_000F_01C67355.993BB800 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>Hi, All:</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>In ListBox and ComboBox when you type a letter, say = 'k', it=20 will jump to the first item starting with 'k'. I want to disable it and = do my=20 own search that can search more than one letter, like 'kite', not = just one=20 character which ListBox currently does. But I cannot disable = ListBox's own=20 search. everytime when I type 'i', then jump to the item starting with = 'i', not=20 the one starting with 'ki'. Do you know how to disable it?</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Thanks,</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Dennis Huang</FONT></DIV></BODY></HTML> ------=_NextPart_000_000F_01C67355.993BB800-- Tag: .NET SQL Query Designer Control Tag: 100717
  - 20
    - tool window & shortcut keys In my application I have some tool window. some of these tool window do accept key input. yet I would like key shortcut (CTRL+S, F2, etc...) to be handled by the main menus of my main window. how could I achieve somethink like that? Tag: .NET SQL Query Designer Control Tag: 100716
  - 21
    - Consolas Hi, Many people using this font...Is there a system or screen requirment. http://www.microsoft.com/downloads/details.aspx?familyid=22E69AE4-7E40-4807-8A86-B3D36FAB68D3&displaylang=en I could get used to it as it probably save screen space. Tag: .NET SQL Query Designer Control Tag: 100715
  - 22
    - Drag & Drop Multiple Items between ListBoxes This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C67351.6BF06660 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, All: Do you know how to do drag & drop multiple items between listboxes? I = can only do with single selection. Thank you, Dennis Huang ------=_NextPart_000_0006_01C67351.6BF06660 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>Hi, All:</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Do you know how to do drag & drop multiple items = between=20 listboxes? I can only do with single selection.</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Thank you,</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Dennis Huang</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C67351.6BF06660-- Tag: .NET SQL Query Designer Control Tag: 100714
  - 23
    - Disabled DataGridView Textbox column Hi, I am having difficulties creating a derived class for DisabledDataGridViewTextBoxColumn and cell when the VisualStyle is not supported. Basically I am down to either using ControlPaint or Graphics to achieve this. But with Graphics, I am not sure how I can make them diabled. Below are my codes: class DataGridViewDisabledTextBoxColumn : DataGridViewTextBoxColumn { public DataGridViewDisabledTextBoxColumn() { this.CellTemplate = new DataGridViewDisabledTextBoxCell(); } } public class DataGridViewDisabledTextBoxCell : DataGridViewTextBoxCell { private bool enabledValue; public bool Enabled { get { return enabledValue; } set { enabledValue = value; } } // Override the Clone method so that the Enabled property is copied. public override object Clone() { DataGridViewDisabledTextBoxCell cell = (DataGridViewDisabledTextBoxCell)base.Clone(); cell.Enabled = this.Enabled; return cell; } // By default, enable the textbox cell. public DataGridViewDisabledTextBoxCell() { this.enabledValue = true; } protected override void Paint(Graphics graphics, Rectangle clipBounds, Rectangle cellBounds, int rowIndex, DataGridViewElementStates elementState, object value, object formattedValue, string errorText, DataGridViewCellStyle cellStyle, DataGridViewAdvancedBorderStyle advancedBorderStyle, DataGridViewPaintParts paintParts) { // The button cell is disabled, so paint the border, // background, and disabled button for the cell. if (!this.enabledValue) { // Draw the cell background, if specified. if ((paintParts & DataGridViewPaintParts.Background) == DataGridViewPaintParts.Background) { SolidBrush cellBackground = new SolidBrush(cellStyle.BackColor); graphics.FillRectangle(cellBackground, cellBounds); cellBackground.Dispose(); } // Draw the cell borders, if specified. if ((paintParts & DataGridViewPaintParts.Border) == DataGridViewPaintParts.Border) { PaintBorder(graphics, clipBounds, cellBounds, cellStyle, advancedBorderStyle); } // Calculate the area in which to draw the textbox. Rectangle textBoxArea = cellBounds; Rectangle textBoxAdjustment = this.BorderWidths(advancedBorderStyle); textBoxArea.X += textBoxAdjustment.X; textBoxArea.Y += textBoxAdjustment.Y; textBoxArea.Height -= textBoxAdjustment.Height; textBoxArea.Width -= textBoxAdjustment.Width; // Draw the disabled textbox if (System.Windows.Forms.VisualStyles.VisualStyleRenderer.IsSupported && Application.RenderWithVisualStyles) { if (System.Windows.Forms.VisualStyles.VisualStyleRenderer.IsElementDefined(System.Windows.Forms.VisualStyles.VisualStyleElement.Button.PushButton.Normal)) { TextBoxRenderer.DrawTextBox(graphics, textBoxArea, System.Windows.Forms.VisualStyles.TextBoxState.Disabled); // Draw the disabled text. if (this.FormattedValue is String) { TextRenderer.DrawText(graphics, (string)this.FormattedValue, this.DataGridView.Font, textBoxArea, SystemColors.GrayText); } } } else { Brush brsh = new SolidBrush(Color.Gray); Brush brFill = new SolidBrush(Color.LightGray); Pen p = new Pen(brsh,1); graphics.DrawRectangle(p, textBoxArea); graphics.FillRectangle(brFill, textBoxArea); graphics.DrawString((string)this.FormattedValue, this.DataGridView.Font, brsh, textBoxArea); } } else { base.Paint(graphics, clipBounds, cellBounds, rowIndex, elementState, value, formattedValue, errorText, cellStyle, advancedBorderStyle, paintParts); } } } I would appreciate if anyone can point me out here. Thanks, Sunny Tag: .NET SQL Query Designer Control Tag: 100713
  - 24
    - Smart Client - IIS error I'm writing the download stub for a Smart Client, following the QuickStart samples that come with the Updater Block 2.0. Tested against my local IIS, the stub works perfectly, but when I deploy it to a server, I get "The system cannot find the file specified" in my browser. Local Machine is IIS 6.0, Remote Server is IIS 5.0 Thanks for your help Tag: .NET SQL Query Designer Control Tag: 100710
  - 25
    - HttpContext? In Windows Forms, is there anyway to get the HttpContext for a web server running on the localhost? TIA. </joel> Tag: .NET SQL Query Designer Control Tag: 100709

Does anyone know of a .NET control for building SQL Query command that can be
embeded in a Windows Form?

I am developing a Windows form application and want to give user a visual
tool to design SQL querys (SELECT only). The designer needs to be able to
work with a .NET dataset directly without a database connection.

I did some search and only found a few ActiveX SQL query designers.

Thanks for you help.

Top

Re: .NET SQL Query Designer Control by George

George
Thu May 11 15:06:10 CDT 2006

Take a look at Easy Query. We've been using it for years, and our users
really like it.

http://devtools.korzh.com/eq/

--
------------------------------------------------------------------------
George Shubin Custom Software Development
dX Software Systems Database Applications
Ph: 503-981-6806 Fax: 503-982-0120
www.dxonline.com george@dxonline.com
------------------------------------------------------------------------

"You are going to call him William? What kind of a name is that? Every
Tom, Dick, Harry is called William. -- Samuel Goldwyn

"Bing" <Bing@discussions.microsoft.com> wrote in message
news:04BAF6B2-35F3-4BDD-92A6-8A781B1F59C5@microsoft.com...
> Does anyone know of a .NET control for building SQL Query command that can
> be
> embeded in a Windows Form?
>
> I am developing a Windows form application and want to give user a visual
> tool to design SQL querys (SELECT only). The designer needs to be able to
> work with a .NET dataset directly without a database connection.
>
> I did some search and only found a few ActiveX SQL query designers.
>
> Thanks for you help.

Top