SQL Instances (c#).

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
    - Correction to that The actual event I'm subscribing to is... AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException); not the threadexceptioin as I put in the earlier message -- Regards, Gary Blakely Tag: SQL Instances (c#). Tag: 110834
  - 2
    - Trapping Exceptions - another issue I'm trying to capture all unhandled exceptions in my Forms Application. First I subscribe to ThreadException ... public Form1() { InitializeComponent(); Application.ThreadException += new System.Threading.ThreadExceptionEventHandler(Application_ThreadException); Then I define a method to handle the event.... private static void CurrentDomain_UnhandledException(object sender, UnhandledExceptionEventArgs ue) { Exception myEx = (Exception)ue.ExceptionObject; here I write to the database logging exception details - the data gets written ok To force an exception I put a button on my form and I handle the click as .... private void btnBlow_Click(object sender, EventArgs e) { decimal dec = Convert.ToDecimal("MakeException"); //cause an exception } The intentional exception triggers my method just fine. But then the btnBlow_click gets triggered again - over and over forever. I don't know why that is happening. thanks, Gary Tag: SQL Instances (c#). Tag: 110833
  - 3
    - Cursor position when stepping through. Hi, Does anyone know about any bugs or technique to 'reset' the code pages for debugging and stepping through. I am sure that VS is showing the yellow step through on the wrong line all the time. It seems to be ignoring a stop statement. Thanks Jared Tag: SQL Instances (c#). Tag: 110830
  - 4
    - DESPERATE - dataGrid with binary values Hi I have problems displaying binary values on cells on the GUI. The program crashed with following dialog box: "The following exception occurred in the DataGridView: System.ArgumentException: Parameter is not valid at System.Drawing.Image.FromStream(... at System.Drawing.ImageConverter.ConvertFrom(... at System.Windows.Forms.Formatter.FormatObjectInternal(... at System.Windows.Forms.Formatter.FormatObject(... at System.Windows.Forms.DataGridViewCell.GetFormattedValue(... To replace the default dialog please handle the DataError event." source code ========== : : string query = "SELECT * FROM icc.provisioning"; //Retreive the table that holds user profile information DataSet ds = new DataSet("Provisioning"); adapter.Fill(ds, rs, "Provisioning"); adapter.TableMappings.Add("Table", "Provisioning"); dataGridView1.DataSource = ds.Tables["Provisioning"].DefaultView; : : TimesTen database data =================== Command> describe icc.provisioning; Table ICC.PROVISIONING: Columns: * BU VARCHAR (30) INLINE NOT NULL KI BINARY (32) TIMESTM BINARY (8) 1 table found. (primary key columns are indicated with *) Command> select * from icc.provisioning; < iden, 0000000000000000000000000000000000000000000000000000000000000000, 4625F296000625D1 > How do I overcome this to display binary values in datagrid ? Are there excellent books for programming Windows Forms and database ? I'm a novice programmer. Any help is appreciated. Tag: SQL Instances (c#). Tag: 110829
  - 5
    - Cancel windows message from reaching parent I am developing a set of controls that must function inside of an application that loads them through COM interop (I don't believe that makes a difference). The application is designed to always handled the "Enter" key. One of my controls is a text box which needs to allow the user multiline input and not being able to use the "Enter" key is borderline unacceptable. I have tried to override WndPRoc, PreProcessMessage, and a host of other behaviors, but I cannot get the application to stop catching the enter message. I have written all messages to a text file when I transition using enter versus using a mouse click, and I cannot even find a message that indicates my control received an "Enter" at all. All suggestions welcomed. Tag: SQL Instances (c#). Tag: 110827
  - 6
    - Can a RichTextBox be hijacked so as to paint on another control's display surface? Is it possible to hijack a RichTextBox's Paint method in such a fashion as to get the RichTextBox's paint logic to operate on another control's display surface? If so, how? The task I'm trying to accomplish is to include a RichTextBox column in a DataGridView. The problem is, DataGridView cells don't readily lend themselves to being derived from a RichTextBox so I have the choice of re-inventing RichTextBox painting in code or somehow getting the results of a RichTextBox's paint back to my DataGridViewCell derived control. My thought is, I can do this by copying the RichTextBox's rendering from its own display surface over to the cell's display surface or pass the Graphics object (or maybe the HDC?) from the cell into the RichTextBox's Paint method. Any ideas how to do this? -- Richard Lewis Haggard www.Haggard-And-Associates.com Tag: SQL Instances (c#). Tag: 110825
  - 7
    - Deploying desktop app What are the advantages/disadvantages in allowing a .net app to be executed from a network share? All the user machines will be configured to have fulltrust from this share. Is deploying to a networkshare with proper trust better over oneclick deployment ? Here is a post which gives details about how to use Caspol to configure a network share for full trust. http://west-wind.com/weblog/posts/275.aspx Thanks KN Tag: SQL Instances (c#). Tag: 110823
  - 8
    - cannot send emails with attachments from .NEt 1.1 using cdonts Hi all, environment : windows 2003 using remote desktop, .netf framework 1.1 using VB.net with Visual studio 2003 users log into the application over remotedesktop to windows 2003 server and access the application. the application lets the users send out emails of reports which have attachments and this is done using the system.web.mail namespace of .net in my vb code and i think this namespace is using the cdonts object. Email with attachments are send out successfully but only under the windows administrator type accounts and not user type accouts, it gives me a huge error saying not able to create CDONTS. Message object. And seems this restriction applies only for emails being send out with attachments, if there is no attachment with the emails that there is no problem. can any body tell me why this is happening? here is the code that i user to send that email : mailmsg.To = torecepient mailmsg.From = fromrecepient mailmsg.Attachments.Add(New MailAttachment(FullPathAndName)) mailmsg.Subject = subject SmtpMail.Send(mailmsg) how can i send out emails with attachments from my application using this namespace even under the windows user type accounts ? thanks Tag: SQL Instances (c#). Tag: 110822
  - 9
    - BindingSource - how can I access nested member? I populate BindinSource with this collection: ================= public class PreliminaryPickupRequest { private string shipper; public string Shipper { get { return shipper; } set { shipper = value; } } private Terminal pickupTerminal; public Terminal PickupTerminal { get { return pickupTerminal; } set { pickupTerminal = value; } } } public class Terminal { private int key; public int Key { get { return key; } set { key = value; } } private string number; public string Number { get { return number; } set { number = value; } } } ============================= Here is the problem: I can bind Shipper column: DataGridViewColumn c = new DataGridViewTextBoxColumn(); c.HeaderText = "Shipper"; c.Width = 300; c.DataPropertyName = "Shipper"; dgvMain.Columns.Add(c); but I cannot do this: DataGridViewColumn c = new DataGridViewTextBoxColumn(); c.HeaderText = "Terminal"; c.Width = 300; c.DataPropertyName = "Terminal.Number"; dgvMain.Columns.Add(c); Is there a way to do it? Thanks, -Stan Tag: SQL Instances (c#). Tag: 110820
  - 10
    - Encrypt a soap message by using an x509Certificate hi i am trying to encrypt a soap message using an x509Certificate. I am having certificate . In that certificate i can view public key , i am also having private key in .key format so how can i convert .key file to .pfx file to import private key. please reply me as early as possible. Tag: SQL Instances (c#). Tag: 110818
  - 11
    - Encrypt a SOAP message by using an x509Certificate Hi I am trying to encrypt a soap message using x509certificate, But i am getting Error that "Cannot find certificate and privat key for decryption". i am using the code given by msdn i am getting error at following place. else if ((IsTokenForSigning) && (!cert.SupportsDigitalSignature || (cert.Key == null))) { MessageBox.Show("The certificate must support " + "digital signatures and have a private key available."); securityToken = null; } cert.key throwing an exception "Cannot find certificate and privat key for decryption". I have private key in another file having extension .key how can i import this key for specific certificate to encrypt the message. Please send me the solution as early as possible. Tag: SQL Instances (c#). Tag: 110817
  - 12
    - Customising DesignSurface Hi, Has anybody had any experience with DesignSurface and design time controls?! I have a UserControl with a Splitter on it that i want to 'pass through' the UIOverlay so it can be dragged at design time... I presume i have to create a customised service, but i cannot find which one i need. Thanks in advance, James. Tag: SQL Instances (c#). Tag: 110815
  - 13
    - String Comparing in Debug\Release modes Hi, I have some code wich looks like so.. s1= "1.1.4" s2="1.1.4" if s1<>s2 then myfunc end if Problem, is myfunc is being called in "Release" mode on one particular developers machine, but above code work as expected in Debug mode or even in Release mode on entire different machine. So what the hell cause illogical code flow, and I have tried string.copare and string.equal. I have also deleted \din and \obj folder and also "cleaned" project but that did nothing as well. TIA Jared Tag: SQL Instances (c#). Tag: 110812
  - 14
    - Seeking Textbox with "popout" for longer text - like Vis Studio 05 Project Settings Still a newbie at this: I'm trying to find a ways to get a textbox control to behave similar to the beahvior of the control seen in the Visual Studio IDE > Project ? [Application Name] Properties > Settings tab. On that page, the 'value' column is normlly displayed as a single line. However, it is possible to click the down arrow in the cell to pop-out a larger editor to accomodate more text. can something like this be easily accomplished with a standard textbox (i.e., without a grid?)? I'm far from making my own controls at this point, and this functionaility is just the thing I need for cases where 90% the data fits a single line, but ocassionally is much longer. thanks in advance d. Tag: SQL Instances (c#). Tag: 110809
  - 15
    - No data appearing in my report I'm putting together a REALLY simple report for my WinForms app. I use an object data source. Here's the class: -------------------------------------------------------------------------- public class ProjectEnergyUsageReportValues { private double defaultUsage; public double DefaultUsage { get { return defaultUsage; } set { defaultUsage = value; } } private double oldUsage; public double OldUsage { get { return oldUsage; } set { oldUsage = value; } } private double newUsage; public double NewUsage { get { return newUsage; } set { newUsage = value; } } } -------------------------------------------------------------------------- No brainer. I have an embedded RDLC file. When I created the RDLC file, I added the class to my data sources window, and dragged the properties (DefaultUsage, OldUsage, NewUsage) to the "data fields" section. I see the three of them listed there. When I added the ReportViewer control to my form, I used the smart tag to associate it with the RDLC file I created. Here's what I'm doing in my report form constructor: -------------------------------------------------------------------------- reportViewer1.ProcessingMode = ProcessingMode.Local; ProjectEnergyUsageReportValues reportValues = new ProjectEnergyUsageReportValues(); reportValues.DefaultUsage = 5.0; reportValues.OldUsage = 6.0; reportValues.NewUsage = 7.0; BindingSource bindingSource = new BindingSource(); bindingSource.DataMember = "ReportValues"; bindingSource.DataSource = reportValues; reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("ProjectedEnergyUsage_ReportValues", bindingSource)); -------------------------------------------------------------------------- And finally, in the form load event: -------------------------------------------------------------------------- this.reportViewer1.RefreshReport(); -------------------------------------------------------------------------- When I run the app and open the form, I see the report layout fine, but there's no data. Any idea why? Tag: SQL Instances (c#). Tag: 110808
  - 16
    - Simple Rich Text Parser/Painter? I have a DataGridView with a column that needs to display text that may be normal or bold, has user specified color and can handle hyper text links. The obvious solution was to derive from RichTextBox. I figured out how to get a real RichTextBox control to handle the edit functions but I have not been as successful in displaying the results once the edit control has been disposed of. Any suggestions how this might be accomplished? I can think of two approaches - display the RichTextBox editor's contents as a bitmap or write a simple RTF parser and paint the results on the cell. I'm leaning towards the parser but have not found sample code on which to base my own implementation. Would someone be so kind as to give me the benefit of their experience with this particular problem? -- Richard Lewis Haggard www.Haggard-And-Associates.com Tag: SQL Instances (c#). Tag: 110806
  - 17
    - DataGridView custom cell - losing first character on edit I've created a RichTextBox DataGridView cell but the first character entered when the cell is in display mode is lost when the cell makes the transition to edit mode. What is the sequence of events that happens behind the scenes when: a) RichTextBox cell is displaying data and has focus. b) User enters a keyboard character. c) Cell transitions to edit mode. When the edit process starts, the editor control collects the data that is present in the cell and sets its own value to it. Initially, of course, this is an empty string. Any subsequent keystrokes are properly handled by the RichTextBox control but the initial keystroke that triggered the display of this control is lost. I did do one odd thing - I got tired of having that stupid page show up that said design mode was unavailable for the RichTextBoxEditingControl so I encapsulated the RichTextBox itself into a User Control. The RichTextBoxEditingControl is derived from the RichTextBox encapsulating User Control and this makes Visual Studio '05 happy. public partial class RichTextBoxControl : UserControl { // Accessor to allow operations on the contained RichTextBox // The child RichTextBox control was added to the UserControl form as richTextBox. public RichTextBox RichTextBox { get { return richTextBox; } } public RichTextBoxControl() { InitalizeComponent(); } } public class RichTextBoxEditingControl : RichTextBoxControl, IDataGridViewEditingControl { // Bunches of code to implement the IDataGridViewEditingControl interface. // Influenced by the MSDN DateTIme Calendar sample. // ... } Any suggestions on where the lost character is going to and, more importantly, how I can get it into the RichTextBox? -- Richard Lewis Haggard www.Haggard-And-Associates.com Tag: SQL Instances (c#). Tag: 110805
  - 18
    - Trapping Exceptions in Forms apps In ASP.Net applications we are able to trap exceptions in the Application_Error Event in the Global.asax with the following code... System.Exception myException = new Server.GetLastError().InnerException. Where do I trap this in a Forms Application? -- Regards, Gary Blakely Tag: SQL Instances (c#). Tag: 110800
  - 19
    - LicenseingApplication I am not sure where to post this question, but thought maybe someone from this newsgroup would have an answer. I have developed a commercial software application. When the install program runs I will display a license agreement for them to accept. Where can I find or buy a software license agreement with a disclaimer. All they can do is install the software on 1 PC and use it. There is no source code delivered with it. TIA Tag: SQL Instances (c#). Tag: 110799
  - 20
    - Help to trap Datagridview cell keypress events... Hi I seek help to trap .net Datagridview cell keypress events. Thanks in advance. Raftar. Tag: SQL Instances (c#). Tag: 110798
  - 21
    - Strange problem with DataGridView AutoGenerateColumns I have a DGV on a form that is bound to a BindingSource, bound to a business object. The DGV has AutoGenerateColumns = False and I have created the columns I want in the designer. When I make any change to the code behind, even something innocuous like a new line, and then switch back to the designer, it automatically generates the columns in my binding source and adds them to the ones I created manually. Also, I don't see AutoGenerateColumns anywhere in the DGV's property sheet. Am I missing something? I'm using the latest SP. Any ideas? Tag: SQL Instances (c#). Tag: 110797
  - 22
    - Strange problem with DataGridView AutoGenerateColumns I have a DGV on a form that is bound to a BindingSource, bound to a business object. The DGV has AutoGenerateColumns = False and I have created the columns I want in the designer. When I make any change to the code behind, even something innocuous like a new line, and then switch back to the designer, it automatically generates the columns in my binding source and adds them to the ones I created manually. Also, I don't see AutoGenerateColumns anywhere in the DGV's property sheet. Am I missing something? I'm using the latest SP. Any ideas? Tag: SQL Instances (c#). Tag: 110796
  - 23
    - Strange problem with DataGridView AutoGenerateColumns I have a DGV on a form that is bound to a BindingSource, bound to a business object. The DGV has AutoGenerateColumns = False and I have created the columns I want in the designer. When I make any change to the code behind, even something innocuous like a new line, and then switch back to the designer, it automatically generates the columns in my binding source and adds them to the ones I created manually. Also, I don't see AutoGenerateColumns anywhere in the DGV's property sheet. Am I missing something? I'm using the latest SP. Any ideas? Tag: SQL Instances (c#). Tag: 110795
  - 24
    - Empty NumericUpDown Hello, I have a small problem ; I have found an alternate solution but I don't like it. The problem is simple, let's take a form, a numericUpDown inside and a button that will show the value of the numericUpDown in a MessageBox (or elsewhere, whatever). Let's say you put '5' in the numericUpDown, click the button, "5", ok. Now, erase the '5' in the numericUpDown, click the button, still "5" but _nothing_ in the numericUpDown. My problem is that I would like to catch when the user erases what's inside the numericUpDown in order to put in the MinimumValue or just display the actual Value. Of course, I don't want it to be ReadOnly. My alternate solution is to use numericUpDown.UpButton() then numericUpDown.DownButton() but as I said, I don't like it. If anyone has encountered the same problem and found a (better) solution, I would like to read it. Thanks, -- neva Tag: SQL Instances (c#). Tag: 110794
  - 25
    - Form Editing Events Hi, I'm designing a form and I'd like to know when a control has been edited. I know how to get around this, by putting code behind every control to see if theres a change and then set a flag, but thats a waste of time and a lot of code to write. I can see someone having a much more elegant solution, I just can't work it out. I was thinking of having every control inherit some master control so I can have one peice of code that 'detects' when a change has been made to any field or check box, just not sure how to go about it. Anyone have a nice and simple solution? Thanks, Tag: SQL Instances (c#). Tag: 110791
- Next
  - 1
    - Detecting changes on a form Hi, I'm designing a form and I'd like to know when a control has been edited. I know how to get around this, by putting code behind every control to see if theres a change and then set a flag, but thats a waste of time and a lot of code to write. I can see someone having a much more elegant solution, I just can't work it out. I was thinking of having every control inherit some master control so I can have one peice of code that 'detects' when a change has been made to any field or check box, just not sure how to go about it. Anyone have a nice and simple solution? Thanks, Tag: SQL Instances (c#). Tag: 110785
  - 2
    - Export from Datagridview I must be doing something seriously weird as I can't find anything on what I need to do. I have a form that imports an Excel file into a dgv (to preview the data) I then want to export this into an existing table in a sql server database. I can't find anything to do this direct from the dgv. Does anyone have any code or methods for doing this? Or am I going about this in completely the wrong way? Any help greatly appreciated Tag: SQL Instances (c#). Tag: 110784
  - 3
    - MdiContainer Benched... for what? Hi there, While searching for answer to another question i stumbled onto a trail of forum type posts where people were discussing MdiContainer support being phased out. They never actually got around to saying what they replacement model would be and i couldn;t be bother signing up for yet another website just to get an for the question. So im asking it here. Is MdiContainer model now not recommended practise and if so what hsas replaced it? Thanks Richard Tag: SQL Instances (c#). Tag: 110780
  - 4
    - Total Loss of control in VS.net 2005 code window I'm now consistently having a problem (shortly after SP1), that, heretofore, only happened once in a while. Now, I bring up the code window in VB.Net 2005 - and I loose total control - I type in a letter or two (most of the time, it's only one), and the intellisense seems to think that's all I need - the code window loses focus, sometimes thinking I'm finished, and adds parentheses at the end. Then, no matter what, I click in the code window, and I can't type in but 1 letter - then it does it again. When it first started happening, I could just shut down VS.Net - then re-open it, and it would be OK for a good while - - I'm loosing my mind with this - Does anyone have any ideas on what may be causing this? Tag: SQL Instances (c#). Tag: 110775
  - 5
    - Help! How to embed a "windows explorer" into a form? Hi everyone, I'm working on a program contains two "Windows Explorer" in one form which allows people to copy files from one to another. I searched in CodeProject and Google but only got some messages about how to make a fake "Windows Explorer", not embedding one into a winform. I also found something about SHFolderView, but I don't know how to use it. Did anyone have experiences about this before? Any help is appreciated. Regards, Anderson Tag: SQL Instances (c#). Tag: 110774
  - 6
    - Tabs similar to the ones in Excel Hi all, I am just wondering if anyone has tried to implement a tab control that allows the user to edit the tab title text at runtime. If so, how much work did it take? Also, please list some pointers on how this can be done. Thanks. GW Tag: SQL Instances (c#). Tag: 110773
  - 7
    - "default" Desktop and Ctrl+Alt+Del Hello, I'm currently programming an application which is started replacing the userinit.exe. The code does the following. When the user logs on the application is creating a new desktop "newDesktop", then the original userinit is created at "newDesktop". So the shell uses "newDesktop" as its desktop, too. The same is with the other applications, that are started when the user logs on. After starting the original userinit the program creates another desktop "formDesktop" where the forms of my Desktop are displayed, while the system configuration of the logged on user is loaded in the background. In this form the user has to solve some tasks and when this is done correct the "formDesktop" closes and the "newDesktop" is set as visible Desktop and the program exits else the user will be logged off. For sure you ask why "newDesktop" for the shell process? The answer is that when the user logs on the visible desktop is "default". If I don't use "newDesktop" the user can manipulate the desktop before the form is displayed and this cannot be allowed. If the application sets the "default" desktop visible before exit the hotkeys and trayicons and so on are still registered to the "newDesktop" and not the "default" desktop, so "newDesktop" stays the user's desktop for the session. What is the problem I have? Well, the ctrl+alt+del event opens the taskmanager in the "default" desktop, thus it's invisible to the user, although the process exist. Making the long story short, here is the question: Is there a way to make the taskbar appear in the "newDesktop" when ctrl+alt+del is pressed? I hope I could make myself clear. kind regards, Alexander Tag: SQL Instances (c#). Tag: 110772
  - 8
    - do win forms have skins like asp.net? Can anyone tell me do winforms have skins and themes like ASP.NET 2.0? If so, can you attach links to information on this subject? Thanks! Tag: SQL Instances (c#). Tag: 110769
  - 9
    - datagridview I have a buttoncolumn in a dgv and the cellcontentclick event opens up a dialog. The end result: the 'OK' value will edit an editable cell in the dgv. The value will not allow me to enter into editmode but will let me edit the cell. any ideas??? --- code ---- private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Columns[e.ColumnIndex].Name == "Btn") { DialogResult result = folderBrowserDialog1.ShowDialog(); if (result == DialogResult.OK) { try { dataGridView1.BeginEdit(true); //dataGridView1.Rows[e.RowIndex].Cells[5].Value = folderBrowserDialog1.SelectedPath; //dataGridView1.CancelEdit(); if (dataGridView1.IsCurrentCellInEditMode) { dataGridView1.Rows[e.RowIndex].Cells[5].Value = folderBrowserDialog1.SelectedPath; dataGridView1.CancelEdit(); } else { Console.WriteLine("Fail to enter editmode"); } } catch(Exception z) { Trace.WriteLine(z.Message); } } } } Tag: SQL Instances (c#). Tag: 110765
  - 10
    - Send messages to other window Hello. I need send some commands to other window. I did this before with VC++. So it work like this. I found this window (for example cacl.exe have text â??Calculatorâ??) then get handle of this window and then send some windows messages on this handle. My old code looks like this HWND hwndFound = ::FindWindow(NULL, " Calculator"); // Ð¿Ð¾Ð¸Ñ?Ðº Ð¾ÐºÐ½Ð° ::PostMessage(hwndFound,WM_COMMAND,IDYES,0); How I can do something like this in C#? Tag: SQL Instances (c#). Tag: 110764
  - 11
    - DataGridView: last column can be made smaller but not bigger Hi, I have a DataGridView control where the user can resize the columns. The control is embedded inside a Panel. When clicking on and dragging the column seperator to the right of the rightmost column, I can make the column smaller when I move it to the left. If I try to move it to the right however, my cursor is halted against the edge of the control. So the column can't be made bigger. This can be reproduced in the sample at http://msdn2.microsoft.com/en-us/library/1x64c23x.aspx by clicking Customer->View Orders in the main form and doing it on the table that appears. In that sample, it is possible to make the last column bigger again by making the whole window bigger, until its length is more than the total length of the columns, creating an open space between the columns and the edge of the window. Then the right seperator of the rightmost column can be dragged freely, up until the edge of the window. However, this trick isn't practical in my own control, since the control is too small and the total column length too long. Is there some standard way to make it behave like the list view in Explorer, where you can resize past the border of the window? Kind regards, Raf Tag: SQL Instances (c#). Tag: 110762
  - 12
    - SnapToGrid and GridSize Hello in VS.NET 2003 using VB.NET there was a property for windows forms , SnaptoGrid , True/False and Grid Size where we can set them for individual forms , now those 2 settings are gone from VS.NET 2005 i can only set them from the Tools/Options/Windows forms designer , but that will affect all new forms , i want to manually control previously saved forms or set the properties for some forms only , can anyone please tell me where the 2 settings gone in VS.NET 2005 and why they are not showing in the form property page ? Best Regards Bassam Tag: SQL Instances (c#). Tag: 110761
  - 13
    - What is a DataGridView template cell? In a number of the Microsoft example snippets for custom DataGridView cells, there are references to something called a 'template cell'. What is this? -- Richard Lewis Haggard www.Haggard-And-Associates.com Tag: SQL Instances (c#). Tag: 110756
  - 14
    - Opening Mailclient with MAPI From my application, informations can be sendt by the user. Until now I'm using Process.Start("mailto:....) This works very fine, but I get problems, when the preset content is to much, because the length of the URL is restricted. IIRC this also can be solved by MAPI, but I can't find any example how to do this with C#. Is this really possible and can anyone give me a hint, how to do this? thanks Christof Tag: SQL Instances (c#). Tag: 110754
  - 15
    - Re: How to avoid flicker when adding controls to a panel? You can minimize the flicker using interop to suspend the painting (which is different than suspending the Layout events). Here is a FAQ link on this. http://www.syncfusion.com/faq/windowsforms/Search/637.aspx ======================= Clay Burch Syncfusion, Inc. Tag: SQL Instances (c#). Tag: 110753
  - 16
    - How to avoid flicker when adding controls to a panel? Hi, I've got a flickering-problem when I try to add controls to a panel (with flow layout) at runtime. My code executes the following steps: public void BuildView() { ... // suspend layout to not perform layout each time an item is added mFlowLayoutPanel.SuspendLayout(); // remove all elements from the panel: mFlowLayoutPanel.Controls.Clear(); // in a loop I add new items to the panel: foreach (... in ...) { Panel panel = new Panel(); // set size of the panel: panel.Size = MaxSize; // MaxSize is a constant value // then the color of the panel is set panel.BackColor = Color.CornflowerBlue; // after all the panel is added the the panel with the flow layout mFlowLayoutPanel.Controls.Add(panel); } mFlowLayoutPanel.ResumeLayout(true); } Every time the method BuildView() is called, the panels are flickering. What went wrong? I thought that SuspendLayout() and ResumeLayout() will avoid that? How can I avoid flickering every time my panels are added to the flow layout panel? Thanks a lot for your answer in advance. Best regards, Ralf Tag: SQL Instances (c#). Tag: 110747
  - 17
    - Datagridview and the Enter Key Hi all, I have a datagrid that doesnt allow the user to edit. When the user clicks a row, the whole row gets selected. I'd like it so that when the user has a row selected and presses enter, a new form is opened and passed data from the row. At the moment, when I press enter, I can get the window to open, but the selected row moves down one. Is there any way I can surpress this behavior when pressing enter? Many thanks Simon Tag: SQL Instances (c#). Tag: 110743
  - 18
    - Child form focus problem Hi all, An application I am woking on consist of a main form. On the main form there are several possible ways for the user to open a non-modal child forms to display even more information. The problem I am encountering is about loss of focus. Let's say here, that initialization of the child form takes about =BD second, from the point where the window is first shown to the point where all controls have been rendered and set with data. Now, on the main form there is a datagridview which is updated on intervals. The problem occurs the user clicks a button to open a child form. The child form is created. But before initialization of the child form has finished, the DataGridView on the main form is updated. Seemingly because of this, the main form gets focus and is moved to the front, and the child form is moved to the back. The user can manually put focus on the child form again and continue working, but tuhis is a behaviour that is very anoying to the end users. Have any of you encountered something like this before? The non-modal strategy is by design. The users want to be able to go back to the main form, without closing the child form. Therefore, I'm searching primarily for any help on the focus problem, and will only use a modal child form strategy if no resolution to the problem can be found. Thanks in advance, Christer Tag: SQL Instances (c#). Tag: 110739
  - 19
    - Windows Form App and VPN I have some clients who have users who reside outside of the company's network. The company is going to allow remote access through a VPN on the server for access to the SQL Server database. I want to have my forms app which will run on the client machine to automatically open the VPN when the program starts and close it when the program ends. That way, the clients doesn't have to set anything up and they don't have to worry about how the data is accessed. Is it possible to this from a windows form app and if so what operating systems would the client have to be running in order to do this? Bill Tag: SQL Instances (c#). Tag: 110729
  - 20
    - OnPaint automatically call e.Graphics.Clear()? Hello. I have a question about OnPaint override. For example, if i have the following code in my inherited form class, private Brush _brush = Brushes.Black; private RectangleF _rect = new RectangleF(0,0,100,100); private int counter =0; protected override void OnPaint(PaintEventArgs e){ if (counter==0){ counter++; e.Graphics.Clear(Color.White); e.Graphics.DrawString("Test", this.Font, _brush, _rect); } } I expect the OnPaint method will do nothing after the first call. That means, the string "Test" should stay on screen if the form is not resized/moved/covered by other windows. However, in reality, the OnPaint do the e.Graphics.Clear() automatically. I'd like to know if that is possible for me to stop that behavior. In my application, my form contains many individual text strings. The strings are updated periodically individually. I would like to render the updated strings only, not rendering the whole thing for every string update. Thank you very much for your help! Gilbert Tag: SQL Instances (c#). Tag: 110726
  - 21
    - mouse move I want to detect and receive a event to my MDI window when the moves outside of the window.. I am unable to receive events. I know there is a case of sending a manual message (George Shepherd's Win FAQ) before opening Top Level windows or doing anything that take mouse focus away from the MDI window. Considering the scope of our application, this I feel might be an effort. Is this the only way? or any other way possible? VJ Tag: SQL Instances (c#). Tag: 110725
  - 22
    - Filtering key strokes Hi, having a card reader attached to the PS/2 keyboard interface, I would like to filter the keyboard input, so that the input from the card reader does not reach the GUI controls. I tried setting KeyPreview=true on the form and catched all input with the KeyDown event. In order to detect, if the input comes from the card reader, I need to check a sequence of at least 10 keys. So I collect the keys in KeyDown and if it's a card reader sequence, I trigger a special action for it. If it's normal user input, I need to "forward" the collected key strokes to the form. The second part is the complicated one. Having a sequence of key strokes in an array of type System.Windows.Forms.Keys, how do I resend these to the application? Sendkeys only accepts a string and seems to not support all values of the System.Windows.Forms.Keys enum. Is there maybe a way to resend keystrokes using the integer values captured from the KeyValue member of the KeyEventArgs? bye, Marc T. Tag: SQL Instances (c#). Tag: 110724
  - 23
    - ClickOnce & proxy authentification We have developed a VisualStudio 2005 smart-client application which we deploy using .NET framework 2.0 ClickOnce. We are experiencing difficulties deploying in certain corporate environments: clients that use proxy authentification simply cannot install unless they disable the proxy which is usually not an option. Apparently this is a known issue with ClickOnce and Microsoft has released a HotFix for it: http://support.microsoft.com/kb/917952/en-us Could we please receive a copy of this HotFix? This is a huge and recurring problem that makes us look bad. Tag: SQL Instances (c#). Tag: 110720
  - 24
    - Outlook Express Newsgroups How do I download all messages in a newgroup? -- Nick Haury Tag: SQL Instances (c#). Tag: 110717
  - 25
    - Forms and Labels I wonder if you could help. The event handler code below, will allow the user to change the phone number and write it on a label of a message box. I want to replace the message box with a dialog box. Can anybody help me replace the message box below to a dialog box. In other words. I want to write the new phone number on a label (named "labe1")of a dialog box (named "dialog2),instead of writing the new phone number on the label of a message box. private: System::Void dialogBtnItem_Click(System::Object * sender, System::EventArgs * e) { // Create the dialog MyDialog* box = new MyDialog(); //Fill in the initial data box->Phone = S"(650)123-3456)"; // <------ This is the phone number to be changed //Show dialog if (box->ShowDialog() == DialogResult::OK) { MessageBox::Show(box->Phone); //<-----I tried to change this line } } Tag: SQL Instances (c#). Tag: 110713

Hello,

I want to display the running instances of SQL server in the drop-down list,
allow the user to enter username/password, if successfully connected i want
to display list of tables in another window.

is there any .Net framework assembly which I can use to retrieve running
instances and object of Database dynamically (reading schema).

Thanks,

Top

RE: SQL Instances (c#). by ManishBafna

ManishBafna
Fri Apr 27 03:06:00 CDT 2007

Hi,
This link presents a procedure that can be used to populate a Windows Form
combobox with a list of SQL Servers by using SMO.Although not given you can
list the tables also using SMO.You can google for SMO and you will get plenty
of articles on it.SMO applies for SQL Server 2005.For SQL Server 2000
equivalent for SMO was DMO.
http://www.sqldbatips.com/showarticle.asp?ID=45
--
If my answer helped you,then please do press Yes below.
Thanks and Regards.
Manish Bafna.
MCP and MCTS.

"Ibrahim." wrote:

> Hello,
>
> I want to display the running instances of SQL server in the drop-down list,
> allow the user to enter username/password, if successfully connected i want
> to display list of tables in another window.
>
> is there any .Net framework assembly which I can use to retrieve running
> instances and object of Database dynamically (reading schema).
>
> Thanks,
>
>

Top