Populate ComboBox with a DataReader

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
    - SYNCHRONISING ALL OPEN FORMS - WINFORMS I have a client-server application using ADO.NET datasets where the user can open several forms - and as many copies of a form as they care to - and edit the data on them. How do you synchronise all the open forms when the user changes a value on the currently active form? For example: * user opens a ViewOrders form which shows a list of Orders including the SupplierName for each Order * user opens EditSupplier form which shows a list of Suppliers * user edits a SupplierName The corresponding SupplierName on ViewOrder form should now change to reflect the edit. I need a general pattern for this - there are hundreds of possible fields the user can edit and any number of different forms could be open - any of which may (or may not) need to be "synchronised". (This sort of behaviour is common in most quality shrink-wrapped software.) cheers Andrew -- **************************************************************************** andrewbingham.com tel 01223 514674 (Cambridge) mobile 07970 161057 fax 07970 601283 email Andrew@AndrewBingham.com DISCLAIMER, PLEASE NOTE: This communication is for the attention of the named recipient only The content should not be passed on to any other person. It is sent in good faith, in confidence, and without legal responsibility. VIRUS CHECK Emails and attachments are virus checked using Norton® AntiVirus® 2002 which is regularly updated. However it remains the recipients responsibility to check emails and attachments sent, or forwarded, from andrewbingham.com for viruses and macro viruses **************************************************************************** Tag: Populate ComboBox with a DataReader Tag: 65269
  - 2
    - WinForms / ODBC.net security Using the ODBC.net data provider to access dbase V tables. Everything works fine on the develpment system, but I get a security error on the production system (running XP on both, so MDAC=2.7) here's the code block that generates an UNHANDLED sercurity exception. I'm not sure what type of exception to try to trap here... thought the Security.SecurityException would catch it so I could see what is going on, but it doesn't. I also checked the security rights on the production machine, and to the best I could determine, it has the rights.... but not really sure about this. ' get the information in TALKNET.dbf Private Function GetTalkNetInfo(ByVal connStr As String) As DataSet lbl_usermsg.Text = "Procedure GetTalkNetInfo Retreiving data from TALKNET.dbf: " + "connection string:" + connStr Dim ok As Boolean = True Dim talknetCONN As OdbcConnection = New OdbcConnection() Dim talknetDA As OdbcDataAdapter Dim talknetDS As DataSet = New DataSet() talknetCONN.ConnectionString = connStr Dim talknetQRY As String = "SELECT * FROM TALKNET WHERE THREADID=100" talknetDA = New OdbcDataAdapter(talknetQRY, talknetCONN) Dim talknetCMD As New OdbcCommand(talknetQRY, talknetCONN) Try talknetCONN.Open() talknetDA.Fill(talknetDS, "Talknet") Catch e As OdbcException cRetrnmsg = e.Errors(0).Message & " " & e.Errors(0).Source lbl_usermsg.Text = cRetrnmsg Catch e As Exception cRetrnmsg = " & e.Errors(0).Message & e.Errors(0).Source" lbl_usermsg.Text = cRetrnmsg Catch e As Security.SecurityException cRetrnmsg = " & e.Errors(0).Message & e.Errors(0).Source" lbl_usermsg.Text = cRetrnmsg Finally talknetCONN.Close() End Try Return talknetDS End Function Tag: Populate ComboBox with a DataReader Tag: 65261
  - 3
    - DataGrid and Wheel on mouse Using VS 2003, VB.net, msde... I have a databound datagrid that works fine. The form also has several combo boxes that determines what the datagrid displays. When data is displayed, if you highlight a row, or click on a cell, and use the mouse wheel to scroll down, it immediately gives focus to combobox tab stop 1, scrolling down it's options. I would anticipate the wheel to simply scroll down the datagrid (like hitting the down arrow on the scroll bar), not swich to another control and scroll its options. Any idea what is going on and how to prevent this? Thanks! Bob Tag: Populate ComboBox with a DataReader Tag: 65260
  - 4
    - WinForms app passes DataSet to remoted type: possible bug Our DAL (Data Access Layer as a dll) is hosted by IIS. We use binary serialization to pass a DataSet into the DAL from a client exe. Our client exe calls GetChanges on DataSet and passes the changes to our remoted DAL. On inserts we have an output parameter for the primary key. After the call to DataAdapter.Update, we watch the insert sproc run and return the output param value. We watch the DataRow change from Added to Unchanged. We watch the source column for output param get set to the outparam's value. The DAL then returns the DataSet to the client exe. Once back in the client exe, the DataRow is still marked as Added and the source column is empty. This is exactly the way it looked when it was sent to the remoted DAL. Now, if we run the DAL locally in a private folder, we see the same results in the DAL. However, back in the client exe the DataRow is marked as Unchanged and the source column contains the output parm value. This leads me to believe there is a bug in the Remoting or ADO.NET architecture. Tag: Populate ComboBox with a DataReader Tag: 65248
  - 5
    - Building forms the VS.NET way Does anyone know how VS.NET generates the code for the forms you create? Just a general idea on how it goes from design to code would be really helpful. My interest is in generating forms with my own app, but I need for those forms to be compatible with the VS.NET form designer. The VS.NET form designer has a bad habit of tossing out code it doesn't like. Thanks. Pete -- http://www.petedavis.net Tag: Populate ComboBox with a DataReader Tag: 65246
  - 6
    - Re:Re :Is it possible to clear containts of all textboxes on a form by issusing one command TIA Thanks I am already using this form of code I just thought there might have been one command Tag: Populate ComboBox with a DataReader Tag: 65245
  - 7
    - events in multithreaded application Hi, I want to create a class that creates a thread internally to do some work. It will interact with winforms using events. What happens when the code that is running in a seperate thread raises an event? Will the code in the event handler that is attached to the event run in the internal thread, or will it run in the GUI thread? The MSDN documentation says that all interaction with the GUI from other threads have to go through an Invoke method. The user shouldn't know that the class used threads internally. If anybody has any ideas, article links etc it would be most apreciated. Thanks, Chris Tag: Populate ComboBox with a DataReader Tag: 65240
  - 8
    - Is it possible to clear containts of all textboxes on a form by issusing one command TIA Tag: Populate ComboBox with a DataReader Tag: 65239
  - 9
    - datagrid horizontal scrolling Hello: Hope you could help me on this. I have a datagrid with 12 columns. I am displaying 8 columns and then I scroll to the right to see the rest of the columns. When I scroll to see the rest of the columns, the first columns are not visible unless I go back to see them. How can I always see by default the first 4 columns while scrolling to the right or horizontally? Thanks! Nancy. Tag: Populate ComboBox with a DataReader Tag: 65238
  - 10
    - PropertyGrid not updating correctly Hi, I've made a class containing a public int and a public Point. I also created a TypeConverter (in fact an ExpandableObjectConverter) supporting InstanceDescriptorInfo. This results in a nice expandable property containing the integer property and an expandable Point property. So far so good. Further I've found out that in order to inform my control that a sub- property has been changed then I have to override GetCreateInstanceSupported and CreateInstance. Now the control catches the updates. However: If I expand the property in the PropertyBrowser like this: -MyClassProp - PointProp X Y IntProp and then enter a new X value and press Enter then the PropertyGrid somehow gets confused and displays something like this: -MyClassProp + PointProp IntProp Y IntProp Ie. the Point-property is collapsed but still partially drawn as expanded! Collapsing and expanding the MyClassProp updates the PropertyGrid. My implementation of CreateInstance is pretty simple: public override object CreateInstance(ITypeDescriptorContext Context, System.Collections.IDictionary PropertyValues) { Point p = (Point)PropertyValues["PointProp"]; MyClassProp mcp = new MyClassProp((int)PropertyValues["IntProp"], p); return mcp; } What am I doing wrong? Or is this a bug in the PropertyGrid? Regards /Claus Tag: Populate ComboBox with a DataReader Tag: 65235
  - 11
    - WinApp Deployment Hello All, I am frustrated with the concept of No-Touch Deployment. This was a big marketing aspect of the .NET development model, but there are many ways to do it, and none of them are working for me. The Updater Application Block requires BITS, its own service, a script file, etc. This is a deployment issue to begin with. The 'navigate to an '.exe' file doesn't seem to work on my W2K3 Server, through an ISA firewall. (no idea where the issue is, just nothing happens when I navigate to the URL from my network. It works on the server itself. The server is in my Trusted Zone. I don't want to go opening huge holes without knowing how to approach this). Will W2K3 Server server the EXE over the net by default? Is my ISA Server preventing it? When I do run it on the server itself, I then get security issues related to the fact that my app hits a web service. Is this an effective means of deploying an application that will need to hit the user's hard drive, as well as a database / web service? How would I go about implementing it? Or, am I better to use the Updater Application Block? I have not found any article that details the security side of this, How To, Best Practices, etc. Just a few articles that make it sound so simple. Kevin Tag: Populate ComboBox with a DataReader Tag: 65230
  - 12
    - Passing values between 2 Windows Forms (C#) I am wanting to create a Lookup window that receives inputted text, searches a database, shows results, and then returns a key value when the user selects the correct record What is the best way to communicate between 2 windows? For example, in Access, the OpenArgs parameter was available within the Open command Thanks Larry Tag: Populate ComboBox with a DataReader Tag: 65228
  - 13
    - DateTimePicker Databound Control I trying to create a Form that is Databound to an underlying Dataset. The Dataset Contains a Date Field which is currently '07/01/2001'; and a Milege rate Field which is '0.345'. When I create the Databound Form and use a Textbox for the Date Field, the Form Fills properly, and I am able to modify the data. However, when I Change the Date Textbox to a DateTimePicker Control, with IDE Generated Databinding. The MileageRate Field, and any other Databound controls on the page become unbound. Any Ideas? Tag: Populate ComboBox with a DataReader Tag: 65224
  - 14
    - ValueChanged event NOT being fired when setting NumericUpDown.Value property Hi, I am setting the NumericUpDown .Value property and the ValueChanged event is NOT being fired. Does this ONLY get fired when I change it on the UI and not programatically? Thanks Tag: Populate ComboBox with a DataReader Tag: 65202
  - 15
    - ComboBox Hi, Why does all the other controls have FlatStyle of Flat and the ComboBox does not? If I configure a form to have all Flat, the ComboBox stands out like a pink cow in a dairy. Why the inconsistency? Somebody forget something or was it BY DESIGN to have inconsistencies? Tag: Populate ComboBox with a DataReader Tag: 65201
  - 16
    - when to call dispose()? Hi, I have a form containing controls, a timer, and the EventLog component. I also create some new instances of classes that do not implement idisposable I don't want to leave the tidying up to the GC so... Do I need to explicitly call EventLog.dispose() as in the following snippet? protected overloads sub dispose(byval disposing as boolean) if disposing if components is nothing then components.dispose end if call MyEventLog.dispose(True) <<<-- end if end sub Also how do I make sure that the classes that don't implement idisposable return their memory one I've finished.Do I just close them, or set them to nothing, or what? Help much appreciated Tag: Populate ComboBox with a DataReader Tag: 65200
  - 17
    - Crystal Reports: Database connection problem. Highly Urgent Hello All, I have a windows application that is using Crystal reports. The database for the application is located on a different machine than the machine on which the application is running. Currently, we are using the IP address of the database server in the DB connection string. But when the user tries to pull up the reports, there is a request for the login information for the database server. I am completely at a loss to understand as to why this is happening. If anyone can provide any pointers towards this issue, it would be greatly appreciated. Thanks Mithun. Tag: Populate ComboBox with a DataReader Tag: 65197
  - 18
    - New line in multiline text box Hey, was just wondering if anyone knows why in a multiline text box i need the escape characters "\r\t" together to go to the next line. thanks, Clive Tag: Populate ComboBox with a DataReader Tag: 65193
  - 19
    - How recall Measure items when Listbox Resizing Dear Sirs. I Use OwnerDraw Method in ListBox Component. All Works Fine But i have problem when i resizing the ListBox Component. (need redraw) in List Box OnMeasureItem and OnDrawItem Called when ListBox is Created or when Add new Item. But They are not calling when i resize a listbox. I try in my code: onresize() { listbox1.Invalidate(); } but I have no effect one way is remove and readd all item on listbox. but i have big amount of items and this way is very bad. plz help me how is posible extend exsiting listbox. or i need reimplement full textbox. Thank you in Advance. Irakli Lomidze Tag: Populate ComboBox with a DataReader Tag: 65189
  - 20
    - Solved: Microsoft Help: IEExe.exe and STA Hi. Thanks for all suggestions. I have finally solved the problem. The System.Windows.Forms.Timer fails because of the UI-operations it executes in my program. So the program crashes when it is being closed. The solution was to replace the System.Windows.Forms.Timer with an implementation of SetTimer and KillTimer. Now it works fine. ... int monitorTimer = SetTimer(this.Handle, 9999, 1000, 0); ... /--- Set timer [System.Runtime.InteropServices.DllImport("user32.dll")] extern static int SetTimer(System.IntPtr hWnd,System.UInt32 iEvent,System.UInt32 iElapse, int iCallbackMustBeZero); //--- Kill timer [System.Runtime.InteropServices.DllImport("user32.dll")] extern static int KillTimer(System.IntPtr hWnd,int iEvent); //--- Timer static static int WM_TIMER = 0x0113; protected override void WndProc(ref Message m) { //--- Check if it is a timer process if (m.Msg == WM_TIMER) { ) base.WndProc(ref m); } br/ peter Tag: Populate ComboBox with a DataReader Tag: 65188
  - 21
    - Drag and Drop of OUTLOOK mail items I want to drag and drop of outlook mail items to my form. I want to save the dragged mail item as a ".msg" file. Help? Thanks, Vijaya Krishna P. Tag: Populate ComboBox with a DataReader Tag: 65187
  - 22
    - Problems binding control data types to a dataset I've run into a problem with binding form properties to data in an xml file (through a dataset). As it turns out, I can easily bind if the data type of the property on the control is a normal datatype such as a string or integer. If the datatype is not one of the built-in types however, things go horribly wrong. Consider this xml file: <?xml version="1.0" standalone="yes"?> <SettingsData> <one> <Text>Center</Text> </one> </SettingsData> If I create a normal winforms application and add the following code to the form's constructor, it works. I get "Center" in the text box. Here's the code that works: DataSet dataset; dataset = new DataSet(); dataset.ReadXml(@"d:\development\bindtest\form.xml"); TextBox textbox = new TextBox(); Binding binding = new Binding("Text", dataset, "one.Text"); textbox.DataBindings.Add(binding); textbox.Width = 150; textbox.Height = 50; textbox.Top = 50; textbox.Left = 50; textbox.Parent = this; this.Controls.Add(textbox); I hardcoded the size and placement of the text box, but I can easily get that from the xml as well. I encountered a problem when I tried to pull TextAlign from the xml file though. I know that this would require the use of Format, so I implemented that. I changed the xml from above to look like this: <?xml version="1.0" standalone="yes"?> <SettingsData> <one> <TextAlign>Center</TextAlign> </one> </SettingsData> And I changed the code from above to look like this (changed from Text to TextAlign, and added the convert event handler): DataSet dataset; dataset = new DataSet(); dataset.ReadXml(@"d:\development\bindtest\form.xml"); TextBox textbox = new TextBox(); Binding binding = new Binding("TextAlign", dataset, "one.TextAlign"); binding.Format += new ConvertEventHandler(FormatHorizontalAlignment); textbox.DataBindings.Add(binding); textbox.Width = 150; textbox.Height = 50; textbox.Top = 50; textbox.Left = 50; textbox.Parent = this; this.Controls.Add(textbox); I also added the Convert Event Handler: public void FormatHorizontalAlignment(object sender, ConvertEventArgs cevent) { switch((string)cevent.Value) { case "Center": cevent.Value = HorizontalAlignment.Center; break; case "Left": cevent.Value = HorizontalAlignment.Left; break; case "Right": cevent.Value = HorizontalAlignment.Right; break; } } This event handler looks right to me. I followed the example from the help files. I've made similar code work with other data types such as booleans being coverted from a T or F in the xml file. DesiredType shows HorizontalAlignment. When I run this code, oddly, the event handler is executed three times. Each time seems to execute correctly. Then I get an unhandled exception from the Application.Run(new Form1()); Error creating window handle. Can anyone tell me what's happening and how to fix it? I foresee I'll have the same problem trying to read the font name and size from the xml file. I have a workaround, but it's very unelegant. Here's the stack trace: System.ComponentModel.Win32Exception: Error creating window handle. at System.Windows.Forms.NativeWindow.CreateHandle(CreateParams cp) at System.Windows.Forms.Control.CreateHandle() at System.Windows.Forms.TextBoxBase.CreateHandle() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow) at System.Windows.Forms.Control.SetVisibleCore(Boolean value) at System.Windows.Forms.Form.SetVisibleCore(Boolean value) at System.Windows.Forms.Control.set_Visible(Boolean value) at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(Form mainForm) at bindtest.Form1.Main() in d:\development\bindtest\form1.cs:line 109 tia, brian Tag: Populate ComboBox with a DataReader Tag: 65186
  - 23
    - New C# and VB.Net Training Videos. We have placed new training videos on our website: www.vtmag.com Please take a look and donate to our site to help cover our expenses. Please also provide feedback to let us know how we are doing. Thanks, Wade Beasley Visual Training Magazine http://www.vtmag.com Tag: Populate ComboBox with a DataReader Tag: 65185
  - 24
    - No Touch Deploy creating EMF's problem Hi, I have a No Touch Deploy application that I want to create and EMF File and serialize it back to the Server via Web Services. When I test the client application running from a local directory (MyComputer zone) it works fine. But when I launch with NTD from my web server I get a Security Exception in the CTOR of the emf. Is there anyway around this. I have tried several of the different CTORs available and the all have thrown the exception. It doesn't make sense that Creating a metafile would be a security violation. I am using the CTORs with a Memory Stream for saving to, so it isn't a FileIO Security issue. Thank You, -- Paul Tag: Populate ComboBox with a DataReader Tag: 65179
  - 25
    - CheckedListBox and ItemCheck Event Is there an event similar to ItemCheck, within the CheckedListBox class, that is called after a list item is checked and updated with the new check value? I currently have a method that iterates through the CheckedItems collection of a CheckListBox control. My problem is the CheckedItems collection doesn't have the correct count because of the ItemCheck event occurring before the checked state is changed. Thanks, Lan Tag: Populate ComboBox with a DataReader Tag: 65176
- Next
  - 1
    - weird bug on buttons I created 2 buttons and in the .Text property in teh designer I set one to "load..." and the other to "save..." The "load..." button was fine but the save button was displayed as "... save" on the form with the eplipses BEFORE the text, but the property for .Text was AFTER the text. Really odd. Anybody seen this before on the 2003 designer? Tag: Populate ComboBox with a DataReader Tag: 65170
  - 2
    - TreeView with tri-state buttons Is there any way to have tri-state checkboxes in the TreeView, preferably without having to use the state icons for that purpose. Does anyone have or know of an implementation of tri-state checkboxes for the TreeView? Thanks, Aaron Queenan. Tag: Populate ComboBox with a DataReader Tag: 65168
  - 3
    - System.Windows.Forms.ListView: OnItemCheck method called when displaying the form Is there any way to know whether the OnItemCheck is being called in response to a user action (mouse or keyboard) as opposed to the form loading? I have a class which derives from System.Windows.Forms.ListView. Among other features, it enables the checkboxes and overrides the OnItemCheck() method. I have placed this ListView on a form and use form.ShowDialog() to display it whenever the user presses a certain button. If the user ticks any of the items in the ListView, and then presses the button again, the form displays okay, but it calls the OnItemCheck() method twice for each item that was previously checked (once to uncheck, and again to check the item). The problem is, that I keep track of the order in which the user checked the checkboxes, and when OnItemCheck is called it effectively changes the order to be the same as the insertion order in the list. Thanks, Aaron Queenan. Tag: Populate ComboBox with a DataReader Tag: 65166
  - 4
    - Method System.CodeDom.CodePropertyReferenceExpression.xxx not found. I have a baseform, which contains an own made component that implements the IExtenderProvider interface, so that this component provides properties to the controls in the form. The IExtedenderprovider is kept in a seperate project (project reference). Then I try to inherit from this baseform. When opening the screen at design, (after putting some extra controls on it), all the controls disappear, and in the task list I get messages like: Method System.CodeDom.CodePropertyReferenceExpression.SetDataTag not found. At run time, everything works fine. What could be the problem with this ? Is it a VI bug, or am I doing something wrong ? Thanks ! Tag: Populate ComboBox with a DataReader Tag: 65162
  - 5
    - controls are interacting even though they have different binding contexts I have a windows form containing a listbox and a datagrid. Eac control's DataSource is a different DataView from the same DataTable Each control has its own binding context. The pseudo-code I use to se up the controls is as follows listBox.DataSource = view1 listBox.DisplayMember = "Field1" listBox.BindingContext = new BindingContext() dataGrid.DataSource = view2 dataGrid.BindingContext = new BindingContext() If I make changes to any of the cells of the top 2 rows of th datagrid, I get a SelectedIndexChanged event raised for the listBox This is driving me crazy for the past 2 days. Is there anyway to kee that event from happening or to test that it is bogus?? Thanks for the help Dav Tag: Populate ComboBox with a DataReader Tag: 65156
  - 6
    - DateTimePicker as ListView sub-item Hi, In my MovieScheduler app, I have a listview with a column of "times" (actually, TimeSpan's) (see http://www.dgp.toronto.edu/~jtalbot/moviescheduler -- 2nd screenshot from the top, showing the list of movies). I want to let the user edit those. So I put a DateTimePicker whenever the user clicks on that column. That's all working fine. My question is, how can I detect that the user clicked "on something else"? There's lots of other things the user can click on -- tabs, menu items, scrollbars, etc... I wouldn't want to have to catch each of those other components' click events... But, the DateTimePicker doesn't seem to have "lost focus" event...? Thanks JT Tag: Populate ComboBox with a DataReader Tag: 65155
  - 7
    - where is OnCommandUI Hello I'm searching for the right method to enable/disable my toolbar buttons something equivalent to OnCommandUI. any hint will be appreciated. yoramo Tag: Populate ComboBox with a DataReader Tag: 65151
  - 8
    - Error: Cannot insert a non-null value into a timestamp column Hi, I have a typed dataset with tables including timestamp type field, when ready to commit the change back to the SQL server trough the data adapter and my storeprocedure, I receive the error. How can I force SQL server inside a storeprocedure a NULL value for that timestamp field? Is there a better solution from my c# code? I try the following, ---------------------------------------------------------------------------- ALTER PROCEDURE dbo.InsertUser ( @last_name char(25), @first_name char(20), @phone char(20), @login_name char(30), @email char(100), @last_login datetime, @datemodif datetime, @timestamp timestamp, @user_id uniqueidentifier OUTPUT ) AS SET NOCOUNT OFF; SET @user_id = NEWID() SET @timestamp = NULL INSERT INTO [user] (user_id, last_name, first_name, phone, login_name, email, last_login, timestamp, datemodif) VALUES (@user_id, @last_name, @first_name, @phone, @login_name, @email, @last_login, @timestamp, @datemodif); SELECT user_id, last_name, first_name, phone, login_name, email, last_login, timestamp, datemodif FROM [user] WHERE (user_id = @user_id) Tag: Populate ComboBox with a DataReader Tag: 65148
  - 9
    - Call to FillRectangles Hangs We have an VB.NET Windows Forms application, which only when running under a terminal server via a Remote Desktop Connection, hangs. The hang occurs on a call to FillRectangles, via an Overridden OnPaint method in our custom control. Has anybody experience a hang similar to this and if so do you have any suggetions for how I might be able to fix the problem? Thanks, Brian Swanson brian@swanson.com Tag: Populate ComboBox with a DataReader Tag: 65138
  - 10
    - WinForm Question Hi, I am trying to validate a form with two tab pages by looping through each control on the form and setting focus to it. I am running into a problem, each time I loop to a control on the tab page not selected it does not fire the validating the event. I am confused why this is happening and was wondering if there is a way around this. I have tried to use ctl.TopLevelControl property to get the tabpage and then call the Show method. However, this does not work very well. Here is the code below I use: formControls is an array of Controls that I create in a method that retrieves all the controls including subcontrols on the form. foreach (Control ctl in formControls) { if (ctl.CausesValidation) { ctl.Focus(); if(!this.Validate()) { break; } } } Thanks Tag: Populate ComboBox with a DataReader Tag: 65137
  - 11
    - Internet Explorer is bleeding through when using MDI Forms We are using MDI Forms. We have an MDI parent w/ a navigation panel to the left. (Similar to the toolbox panel in the .net environment) Then we click on a link in the navigation panel, a new form is loaded inside the MDI parent. The bleeding seems to take place while the child form is being loaded. Once the form is loaded inside the parent the bleeding is gone. Does anyone know what is happening? Thanks... Tag: Populate ComboBox with a DataReader Tag: 65136
  - 12
    - Uploading file to Intranet from Windows Application I am trying to upload a file created from within my application to an Intranet address as follows; Dim MyClient As System.Net.WebClient MyClient.UploadFile(myWebaddress, myfile) However, I get "(405) Method not allowed". I've set Read and Write on the directory but that seems insufficient. What priviledges are required on the IIS server to allow uploading the file? Tag: Populate ComboBox with a DataReader Tag: 65135
  - 13
    - Looking for some help Hello, Can somebody please help me with this? I have a hashtable which I converted to a datatable with "key" and "value" as column names. I also have a windows form with two datagrids. Now I want to fill datagrid 1 with the datatable, but I only want to see the "value" column. The user may select (double click) one recod inside this datagrid, I want to know the value inside the "Key" column of the selected column. Remember, the column "Key" you cannot see on the screen. Thats it! Can somebody show me how to connect the datatable to the datagrid? How to hide the "Key" column? How to retriev the selected record with the value of that "Key" column? Can you give me some sample code? Thanks! Arjen Tag: Populate ComboBox with a DataReader Tag: 65134
  - 14
    - Creating forms on a non UI thread Hi Could someone clarify something for me please? There is a rule about not creating a Windows control on a non UI thread isn't there but what exactly is the rule. Is it I shouldn't construct a control on a non UI thread or I shouldn't Show a control on a non UI thread. If I have a callback method that is invoked when a worker thread completes. The callback method needs to display a form with some information obtained from the worker thread. Now, the callback method is actually executed on the worker thread, not the UI thread and so I'm creating the UI control on a different thread. I do however have a ShowControl() method on the main form that I call to display the newly create control and this method checks the Form.InvokeRequired property before calling Show(), calling Invoke() if required. Is this the correct way of doing it or should I also be asking the UI thread (aka the main form) to create the new UI control as well? Hope this all make sense!! Regards Graham Allwood Tag: Populate ComboBox with a DataReader Tag: 65132
  - 15
    - TopMost Hi All, When I set a form to be TopMost, I expected it to be the topmost form within the application, but when I open some other application, this form is still on top of the application. Is this the expected behaviour of TopMost property? TIA --Saurabh Tag: Populate ComboBox with a DataReader Tag: 65124
  - 16
    - How do I "flash" my notifyicon? Hi Everyone, I'd like my notifyicon icon to change every few seconds on a given event. I guess I'd approach this using System.Timers.Timer or the Windows.Forms.Timer, where I'd set the "Enabled" property of the timer to "true" in the eventhandler. I've tried this but with little success. Can anyone tell me the best way to achieve this? Thanks, Wobbles Tag: Populate ComboBox with a DataReader Tag: 65123
  - 17
    - How to detect control move when parent is moved I'd like to detect when a control is moved relative to the screen (SCREEN coordinates changed). Is there a way to do this except adding a handler to ctl.FindForm.Move, .Resize... events??? Thanx Tag: Populate ComboBox with a DataReader Tag: 65120
  - 18
    - clipboard class I want to know how to use the clipboard class. The class take dataobjects. Does that mean that U cannot add controls to the clipboard. I am designing a Form Designer and I want to implement cut,copy and paste for that I need to use the clipboard. But it throws me exception when I try to add any control to clipboard through setdataobject. Please help me with this Thanks for ur help Tag: Populate ComboBox with a DataReader Tag: 65118
  - 19
    - How can I set the TreeView.Indent = 0? How can I set the TreeView.Indent = 0? it can't be set to zero. e.g ParentImage ChildImage1 ChildImage2 I want to my parent and child node on the same indent level. Is there any possibility that parent and child node are at the same indent level in TreeView control? I want my Treeview control as microsoft folder bar. Is there any other way plz let me know its very urgent. Thanks --- Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/ Tag: Populate ComboBox with a DataReader Tag: 65113
  - 20
    - Generic GDI+ error in DrawString Hi, I don't know why DrawString is causing this error: System.Runtime.InteropServices.ExternalException: A generic error occurred in GDI+. at System.Drawing.Graphics.DrawString(String s, Font font, Brush brush, RectangleF layoutRectangle, StringFormat format) at System.Drawing.Graphics.DrawString(String s, Font font, Brush brush, Single x, Single y) at WK.Windows.Forms.WKTabControl.OnDrawItem(DrawItemEventArgs e) at System.Windows.Forms.TabControl.WmReflectDrawItem(Message& m) at System.Windows.Forms.TabControl.WndProc(Message& m) at WK.Windows.Forms.WKTabControl.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) First, this exception had been thrown by GroupBox control, so we decided to buid our own group box control to avoid using DrawString. It worked, but now, it's happing again with TabControl, as you can see... Please, help me. I'm really in trouble. What could I do? Tag: Populate ComboBox with a DataReader Tag: 65112
  - 21
    - Get a value of a VB.Net application from another VB.Net application I would get a value of a VB.Net application from another session of the same VB.Net application.. I stored the value in a global variable and I would get this value from another session of the same VB.Net application.. The steps I'm implementing are 1) Look for if another instance of the same VB.Net application is running on the PC... (I found the code to implement it... 2) If another session is found, I would get the value of a variable, to compare it with the value stored in the active instance to do something.. Any idea ??? Thanks in advanc n Tag: Populate ComboBox with a DataReader Tag: 65111
  - 22
    - ComboBox in TabControl I have 2 ComboBox in a form. One is in a TabPage of a TabControl They are data-associated through a code as this objDA.Fill(objDS With objComboBo .ValueMember = strI .DisplayMember = strValu .DataSource = objDS.Tables(0 .SelectedValue = 0 : .SelectedIndex = - End Wit When the form is shown, the one in the form contains the items but has no one selected while the one in the TabPage of the TabControl has the first item selected... If I force the empty selection setting his SelectedValue=0 or/and SelectedIndex=-1 it goes ok, but when I change the TabPage and then return to it, the first item is shown again !! Any ideas ?? Thanks in advance.. nq Tag: Populate ComboBox with a DataReader Tag: 65102
  - 23
    - drag & drop between datagrid in vb.net Hello, I am having problem in drag and dropping the selected row from one datagrid to another.I am unable to match content of which cell from source datagrid to which cell of the destination grid. Tag: Populate ComboBox with a DataReader Tag: 65099
  - 24
    - Anchoring problem Hi I have a problem with anchoring. The problem can be recreated like this 1. Create WindowsForms application 2. Add a button to the for 3. Set the button anchor style to Top|Left|Right 4. Subscribe the form for its Resize event an in the handler change the height of the button to some value like this private void Form1_Resize(object sender, EventArgs e) {this.button1.Height=250; The problem is that when this application is started and the window is minimized and maximized, the buto changes not only the height (as it should be-we change it in the handler), but also its width. The button is anchore but, the form does not change size, so shoudl not the button. And what is even stranger is that if we dont change th height in the Resize handler, the width willnot change Why assigning a value to the height affects the width Thank yo Tag: Populate ComboBox with a DataReader Tag: 65094
  - 25
    - Modal forms... Help! Hi, I'm building an application that has many windows and I'm using modals as part of that... but I have a problem... First of all I was building this as mdi but when a modal form then tried to show a non-modal form in the mdi it failed... so I changed the app to non-mdi. Now the problem I have is that when the modal dialog comes up it locks ALL current windows, although new non-modal forms can be started from the modal dialog and they all work together. Why do I want to do this? I'll describe a simple example.. An application has 2 main windows, these manage data that has no impact on the other window. So when window A opens a modal dialog I'm expecting A to be locked, pending the closure of the modal, but I still want B to be usable.... Is this actually achievable? HOW! I've tried examining the properties of forms during runtime but I see no obvious clues as to what's going on under the covers and how I can make it do what I want.. Thanks in advance. G Tag: Populate ComboBox with a DataReader Tag: 65091

Is it possible to populate a ComboBox's DisplayMember and the ValueMember via a SqlDataReader in C#?

I know how to do it off of a dataset, but I would rather not incur the overhead since it is just a display field that is used to populate other information from the key value (ValueMember).

Larry

Top

Re: Populate ComboBox with a DataReader by Mohamoss

Mohamoss
Thu Jan 22 04:26:24 CST 2004

Hi Lary

You can do it by looping through the data Reader and adding the items one
by one. But you can?t bind a control to data reader in windows apps since it
is a fast forward read only object. You can do that in webApps though.

Thanks ,

--
Mohamed Mossad
Microsoft GTSC Developer support for Middle East

"Larry" <larrystewart[SPAMCTRL]@moodyreview.com> wrote in message
news:71DEDC69-0A90-42D4-A125-EBCAD1881261@microsoft.com...
> Is it possible to populate a ComboBox's DisplayMember and the ValueMember
via a SqlDataReader in C#?
>
> I know how to do it off of a dataset, but I would rather not incur the
overhead since it is just a display field that is used to populate other
information from the key value (ValueMember).
>
> Larry

Top