TABLE

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
    - General Informations about winforms I am searching for informations related to the creation of apps using winforms : i have to create a very nice appearance like the classic winamp or qcd. any links to tuto, guide, samples, or advices would be helpful ! Thanks. ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: TABLE Tag: 87088
  - 2
    - CREATE A DATASET Hi, I would like to add three table to a DataSet: these three tables have tha same structure (columns name and type) but contains different records. When I try to add them, at the second table, I receive an error: "This table belongs already to another DataSet" Could you please help me to solve the problem Tag: TABLE Tag: 87087
  - 3
    - Build a DataSet Hi, in my SQL Server Database I've a table named Customer with the following column: CustomerID: primary key CompanyName: name of the customer Type: customer can be of type ROOT, BRANCH, COST_CENTER OwnerID: the key number (CustomerID) to which the customer belongs This table contains 3 types of customer: ROOT, BRANCH and COST_CENTER. A ROOT can have many Branches and Cost_Centers A Branch can have many Cost_Centers. The column OwnerID allows to identify to which that customer belongs: if the customer is a ROOT, this column has the same number of CustomerID. My question is: how can I create a DataSet with three table in relation, namely: ROOT, BRANCH and COST_CENTER relationed with column CustomerID and OwnerID The three table should show the tree like this: ROOT with its BRANCHES and COST_CENTERS for each BRANCHES its COCST_CENTERS Is it a problem if the table have the same structure for the three new? Thank you. Tag: TABLE Tag: 87085
  - 4
    - Adjust scrollbarvalue of TreeView Hi, I have 2 TreeViews. When i scroll one of them the other one must scroll also, so there are synchronized. Does somebody knows how to read out the scrollbar value of a TreeView and how to put a new value in? Thanx Tag: TABLE Tag: 87082
  - 5
    - Dutch User Group Conference, International Speakers!!! Please check this out: Software developers conference may 30-31th may Papendal/Arnhem The Netherlands 90 session covering C#, VB.NET, ASP.NET, Delphi 32 and Delphi.NET www.sdc.nl Software Developer Network www.sdn.nl The Software Developer Network is usergroup run by software developers for software developers. The goal of the Software Developer Network is to further the knowledge of its members and to form a network of developers. The SDN counts a total of 2000 developers. regards, Erik Visser Tag: TABLE Tag: 87081
  - 6
    - Currently position my windows form Hi How can i set Currently position of my window form. for example: x = this.Location.X; y = this.Location.Y; //(x=199, y =200); //i want to set my windows form in x(10,20)???? Thanks!! Tag: TABLE Tag: 87079
  - 7
    - howto create a simple boundable property I want to create a usercontrol usable in a winform. This usercontrol has some textbox and 1 simple property called MyValue. It's code is : private int myValue; public int MyValue{ get{ return myValue; } set{ myValue = value; } } I want to bind my Textbox and this property to dataset columns. Unfortunatly MyValue property cause adding new row in the dataset to fail. (BindingContext never position to the added row). My question: Is there anything to do to make this simple property bindable ? Thanks for any help. Tag: TABLE Tag: 87078
  - 8
    - DataGrid: Update datasource when closing form Hi, The situation is the following: A user is editing a cell in a DataGrid, and hasn't pressed <return> or <enter>, so the value is being edited. The user then closes the form. I would like to update the value to the data source if it is valid, or prevent closing the form if the edited value is invalid. Actually, all I need for this to accomplish are the following two functions: (1) A function that tells me whether or not the user is actually editing a cell's contents. (2) A function that tries to end the edit operation, and returns whether ending the operation succeeded. Ending the edit operation should fail if the value being edited is invalid (not valid). I haven't found these yet. About (1): I've checked DataRowView's IsEdit member, but I tested it and it seems to return true even if a user isn't editing a cell in that row. About (2) DataGrid has an EditEdit method. Sadly it returns false when no cell is being edited, so I can't make the distinction between an invalid entry or the fact that the cell isn't being edited. So using (2) alone doesn't work. Thanks for any help -- Tom Tempelaere. Tag: TABLE Tag: 87076
  - 9
    - ActiveX controls causing multiple calls to UserControl's OnLoad If I host ActiveX controls on a UserControl, the designer inserts calls to the controls' EndInit methods into the UserControl's InitializeComponent method. Every time EndInit is called (once for each ActiveX control), the containing UserControl's OnLoad method is called. Is this by design? If so, how am I supposed to deal with it? If I host the same controls on a Form, the Form's OnLoad is only called once, even though EndInit is called for each control. I posted about this a few days ago; still puzzling over it. http://groups-beta.google.com/group/microsoft.public.dotnet.framework.windowsforms/messages/3e6859dfbd8a4ecb,e2b3a9fdc23b41ec,73c8eafc4da4abb9?thread_id=8fcf88093bfceaf6&mode=thread&noheader=1&q=OnLoad+UserControl#doc_3e6859dfbd8a4ecb Tag: TABLE Tag: 87069
  - 10
    - major challenge : strange problem with drag&drop of Outlook2003 msg to vb.net form Hi, I'm desperatly trying to find how I can use drag and drop for an Outlook 2003 msg towards a VB.Net Windows application. Normally you should use Dim theSteam As Stream = CType(e.Data.GetData("FileGroupDescriptor", True), Stream) to capture the filename (which works great) and use Dim ms As MemoryStream = CType(e.Data.GetData("FileContents", True), MemoryStream) which returns nothing. The strange thing is that e.Data.GetDataPresent("FileContents") returns true. I also tried to copy an msg file to the clipboard and tried to download the message from the clipboard into my vb.net application but same behaviour. I also tested the same thing in c# but no changes. Can someone please advice what's wrong ? Is this a bug gentlemen from Microsoft ??? Thx for some feedback !!! Tag: TABLE Tag: 87068
  - 11
    - NUnit, NMock and DataBinding Hi all, Can anyone share their experiences (at a high level) mocking a database that fills a Dataset that is bound to controls in a UI? I'm finding the task rather daunting. Cheers, WNC Tag: TABLE Tag: 87063
  - 12
    - databinding issue Hi, I've got the following problem with databinding: If I bind a column of a dataset e.g. on the Text property of a Textbox, everything acts as expected, i.e. if you don't make any changes to the text in the textbox, the rowstate of the bound row stays unchanged. On the contrary, when you bind e.g. the Tag property of the Textbox, instead of the text property, the rowstate turns to modified when leaving the textbox (or by calling the bindingmanager.endcurrentedit method), even if you haven't changed a thing. This is very inconveniant because it causes unnecessary updates of the database. It seems that binding on the non default property (which is Text) causes changes of the underlying dataset. I assume it has somtehing to do with adding attributes to the properties ? or not ? How can we avoid this ??? Thanks !!! Tag: TABLE Tag: 87062
  - 13
    - How to close a form in C# I'm trying to close a form in C#. I have a vb background, so the question may sound dumb. In vb it is just me.close(). I've tried a bunch of ways to close the form but C# is acting pretty dumb also. I can't find a way to close it. Here are some of the things I've tried: private void button1_Click(object sender, System.EventArgs e) { // Form1 frmI = new Form1(); // DialogResult dr = frmI.ShowDialog(); Form1.Quit(); // this.Hide(); } The new form seems to recreate the form - that is a total nightmare. Hide doesn't end the program and Close just gets a message that says close is not defined. -- Regards, Jamie Tag: TABLE Tag: 87049
  - 14
    - Several bugs and workarounds In the course of writing my application, I have come across several = issues that seem to be Microsoft bugs. Following is a summary and possible workarounds. Jeffrey Tan, if you are reading this, please verify. Also, I'd like to know how to request fixes for these issues. 1) Sometimes the designer decides to spontaneously rearrange the tabs in = a TabControl. Status: Verified "known issue" - "Tab control TabPage order is = randomized" Workaround #1, suggested by Herfried K. Wagner Make sure you have always the first tab selected when recompiling Workaround #2: Delete and recreate the tabs after the call to = InitializeComponent() // Sample pages =3D new TabPage[] { pageOne, pageTwo, pageThree, pageFour, = pageFive }; myTabControl.Controls.Clear(); myTabControl.Controls.AddRange(pages); 2) BeginUpdate/EndUpdate does not work correctly when adding a single = item to a sorted ListBox Status: Verified "known issue" Workaround #1: Check the number of items to update and only perform = BeginUpdate/EndUpdate if >1. if (items.Count > 1) myList.BeginUpdate(); myList.Items.AddRange(items); if (items.Count > 1) myList.EndUpdate(); Workaround #2: Toggle the Sorted property. // Sample myList.BeginUpdate(); bool bug_workaround =3D myList.Sorted; myList.Sorted =3D false; myList.Items.AddRange(items); myList.Sorted =3D bug_workaround; myList.EndUpdate(); 3) A DataGrid leaves text on the screen after deleting a row containing = a selected (highlighted) cell. Happens when the columns are set to read-only, mostly visible when = deleting the last row. Status: Verified "known issue" Workaround: Set the read-only property of the whole DataGrid to true and = the read-only properties of the individual DataGridTextBoxColumn items to false. Don't know about cases when only some columns need to be read-only. 4) A DataGrid on a TabPage loses the data binding if the is deleted from = the TabControl. Since the only way to hide tab pages is to remove them, it is relevant. Status: Happens on my machine... Workaround: un-bind and re-bind the DataGrid when removing & re-adding = the tab page. Those are the bugs that I encountered. If you know of more, please post. --=20 Address email to user "response" at domain "alexoren" with suffix "com" Tag: TABLE Tag: 87044
  - 15
    - ANN: Dialog Workshop .NET 1.4.1 released Hello, Dialog Workshop .NET ver. 1.4.1 released! Using Dialog Workshop components you can speed up the creation of customized standard dialogs (based on the Windows Common dialogs) in your .NET applications without using WinAPI and resource editors! Many really powerful features are available: - extend your dialogs using your WinForms without writing a line of code; - custom dialog items captions; - customized dialog startup position; - custom file list view styles, etc. in Open/Save dialogs; - OpenFile dialog with MRU files tab; - design-time support, etc. Also Dialog Workshop for VCL.NET (Delphi.NET) is available now. Please visit our homepage for details: http://www.componentage.com Sergey Novogilov COMPONENTAGE Software http://www.componentage.com Tag: TABLE Tag: 87039
  - 16
    - Creating a scrollable container control I would like to create a custom container control which can scroll its child controls. I know that the AutoScroll property of ScrollableControl can mimic this functionality, but AutoScroll causes some behavior which is EXTREMELY obnoxious to my users, and I haven't been able to find a workaround. Consequently, I would like to be able to scroll a control without using the AutoScroll property. Is there any way to accomplish this? I've created the appropriate scrollbars, and now I just need to get the child controls to move. The SetDisplayRectLocation() function sounded like exactly what I needed, but it doesn't seem to work unless AutoScroll is enabled. Tag: TABLE Tag: 87033
  - 17
    - Windows Form in Shared Add-in not reading App.config settings Good Morning, I am developing an Outlook Shared Add-in using VB.Net. A Windows form has been added to the project, but is not reading the values in the app.config file during testing. The code (Sub Main) is below and displays "Blank connection string" is the label. It is called by an Outlook command button click event: Private Sub btnCTXNotesHistory_Click(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean) Handles btnCTXNotesHistory.Click Dim frmNotesHistory As New frmCTXNotesHistory frmNotesHistory.Main() frmNotesHistory.Show() End Sub Sub Main() Dim sqlconCTXControl As New SqlClient.SqlConnection sqlconCTXControl.ConnectionString = ConfigurationSettings.AppSettings("sqlconCTXControl.ConnectionString") lblErrorMsg.Text = sqlconCTXControl.ConnectionString.ToString If lblErrorMsg.Text.Length = 0 Then lblErrorMsg.Text = "Blank connection string" End If End Sub Thanks. Tag: TABLE Tag: 87031
  - 18
    - InvalidCastException: (DataSet) DataGrid.DataSource I need some help please. Say you have a DataGrid and a DataSet, and you create a dataview to handle sorting and filtering and then you assign the dataview to DataGrid.DataSource. Once you did that you will get InvalidCastException if you do this: DataSet dataSet = (DataSet) dataGrid.DataSource; But I need to do that because I need to get the DataGrid's dataentries in a dataset and use XmlDataDocument to load the dataset and then write it to an xml file. Maybe my first design decision to assign dataview to the datasource should be reviewed. I don't know. Any comment will really help. Thank you. Tag: TABLE Tag: 87030
  - 19
    - Transparent UserControl I'm going Mad! Has anyone been able to give a UserControl a transparent Background I've tried... this.SetStyle(ControlStyles.SupportsTransparentBackColor, true); this.BackColor = Color.Transparent; this.UpdateStyles(); ... but it does not work. Tag: TABLE Tag: 87027
  - 20
    - Changing grid cells programatically I have a DataGrid and I'm changing the value in one of the cells programatically. Problem is, my change isn't being picked up (and saved in the underlying data source), unless I manually tab off the cell in the grid. I've tried calling BeginEdit and EndEdit around the code that populates the cell, to no avail. What am I missing? Tag: TABLE Tag: 87023
  - 21
    - TLSStream object problem I have an application that needs to send a HttpWebRequest to a secure server via https on a non-standard SSL port, I need to use port 5004. The error I get an the stack is shown below. The code works fine using the standard SSL port, but fails using port 5004, not a firewall issue. ERROR: Cannot access a disposed object named "System.Net.TlsStream". Object name: "System.Net.TlsStream". at System.Net.TlsStream.InnerWrite(Boolean async, Byte[] buffer, Int32 offset, Int32 size, AsyncCallback asyncCallback, Object asyncState) at System.Net.TlsStream.BeginWrite(Byte[] buffer, Int32 offset, Int32 size, AsyncCallback asyncCallback, Object asyncState) at System.Net.Connection.BeginWrite(Byte[] buffer, Int32 offset, Int32 size, AsyncCallback callback, Object state) at System.Net.ConnectStream.BeginWrite(Byte[] buffer, Int32 offset, Int32 size, AsyncCallback callback, Object state) at System.Net.ConnectStream.Write(Byte[] buffer, Int32 offset, Int32 size) Code: Errors out on the Poststream.Write line of code. Is there any way to Overload the webrequest object to force it to see the certificate. In debugging I am apply to query the certificate object and have not problem viewing its properties. Any and all help would be greatly appreciated. Thanks. Private Sub btnTest_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTest.Click Dim TransactionString As String = "" Dim Response As String = "" Dim VitalUri As New Uri("https://ssltest.tnsi.com:5004/") Dim RequestUri As New Uri(VitalUri, "test.php") Dim WRequest As HttpWebRequest 'For quick Connectivity Test use this abbreviated test record TransactionString = "D4.999995" & Chr(3) Dim LRC As String = LongitudinalRedundancyCheck(TransactionString) 'Dim htmlrequest As New HTMLRequest 'Response = htmlrequest.getRequest(requestUri, Chr(2) & TransactionString & LRC, "x-Visa-II/x-auth") Try ServicePointManager.CertificatePolicy = New TrustAllCertificatePolicy WRequest = CType(WebRequest.Create(RequestUri), HttpWebRequest) WRequest.Method = "POST" WRequest.ContentType = "x-Visa-II/x-auth" WRequest.ContentLength = TransactionString.Length + 2 'convert the transaction string to a Stream object Dim byteArray As Byte() = Encoding.UTF8.GetBytes(Chr(2) & TransactionString & LRC) Dim Poststream As Stream = WRequest.GetRequestStream Dim bob As String = WRequest.ServicePoint.Certificate.GetRawCertDataString Poststream.Write(byteArray, 0, TransactionString.Length + 2) Poststream.Close() 'assign the response object of WRequest to a WebResponse variable Dim WResponse As WebResponse = WRequest.GetResponse Dim ResponseStream As Stream = WResponse.GetResponseStream Dim StreamReader As New StreamReader(ResponseStream) Response = StreamReader.ReadToEnd ResponseStream.Close() StreamReader.Close() WResponse.Close() Catch ex As Exception Response = "ERROR: " & ex.Message & vbNewLine & ex.StackTrace End Try Me.txtResponse.Text = Response End Sub Private Function LongitudinalRedundancyCheck(ByVal Message As String) As String Dim sLRC As String = "" Dim iXor As Integer = 0 Dim Value1 As Integer = 0 Dim Value2 As Integer = 0 Dim Position As Integer = 0 Try If Message.Length >= 2 Then Value1 = Asc(Message.Substring(0, 1)) Value2 = Asc(Message.Substring(1, 1)) iXor = Value1 Xor Value2 Position = 1 Do While Position < Message.Length - 1 Position = Position + 1 Value1 = iXor Value2 = Asc(Message.Substring(Position, 1)) iXor = Value1 Xor Value2 Loop sLRC = Chr(iXor) Else sLRC = Message End If Catch ex As Exception sLRC = "" End Try Return sLRC End Function End Class Public Class TrustAllCertificatePolicy Implements System.Net.ICertificatePolicy Public Function CheckValidationResult(ByVal srvPoint As System.Net.ServicePoint, ByVal certificate As System.Security.Cryptography.X509Certificates.X509Certificate, ByVal request As System.Net.WebRequest, ByVal certificateProblem As Integer) As Boolean Implements System.Net.ICertificatePolicy.CheckValidationResult Return True End Function End Class Public Class RequestState Public request As HttpWebRequest Public requestDocument As String Public Sub New() request = Nothing requestDocument = "" End Sub End Class Public Class HTMLRequest 'Handler to synchronize with main thread Private allDone As New ManualResetEvent(False) Private _requestDocument As String Private _responseDocument As String Private _web As HttpWebRequest Private Sub ReadCallback(ByVal asynchronousResult As IAsyncResult) Dim result As String = "" Try 'get the information to pass on from the Async Object Dim myRequestState As RequestState = CType(asynchronousResult.AsyncState, RequestState) Dim myWebRequest2 As HttpWebRequest = CType(myRequestState.request, HttpWebRequest) Dim requestDocument As String = myRequestState.requestDocument 'get the stream to write the request to Dim streamResponse As Stream = myWebRequest2.EndGetRequestStream(asynchronousResult) Dim bytArray() As Byte = System.Text.Encoding.ASCII.GetBytes(requestDocument) streamResponse.Write(bytArray, 0, requestDocument.Length) streamResponse.Close() 'tell the main thread that writing stream is complete allDone.Set() Catch e As WebException result = e.Message Catch ex As Exception result = "Error: " & ex.Message allDone.Set() End Try End Sub Private Sub retrieve() Try Dim objWebResponse As WebResponse = _web.GetResponse Dim objStream As StreamReader objStream = New StreamReader(objWebResponse.GetResponseStream, System.Text.ASCIIEncoding.ASCII) _responseDocument = objStream.ReadToEnd 'close the objects objWebResponse.Close() objStream.Close() Catch ex As Exception _responseDocument = "ERROR retrieve: " & ex.Message End Try End Sub Private Sub send() Try 'Prepare objects to pass int async call Dim myRequestState As New RequestState myRequestState.request = _web myRequestState.requestDocument = _requestDocument Dim r As IAsyncResult = CType(_web.BeginGetRequestStream(AddressOf ReadCallback, myRequestState), IAsyncResult) 'wait till asychro is done allDone.WaitOne() Catch ex As Exception End Try End Sub Public Function getRequest(ByVal requestUri As Uri, ByVal requestText As String, ByVal sContentType As String) As String ServicePointManager.CertificatePolicy = New TrustAllCertificatePolicy _requestDocument = requestText _web = CType(WebRequest.Create(requestUri), HttpWebRequest) With _web .ContentType = sContentType .Method = "POST" .KeepAlive = False .ContentLength = requestText.Length .Timeout = 10000 End With Try send() retrieve() Return _responseDocument Catch ex As Exception Return "ERROR getRequest: " & ex.Message End Try End Function End Class Tag: TABLE Tag: 87022
  - 22
    - DataGrid: Custom ComboBox column problem Hay there, I'm writing my own DataGridComboBoxColumn because .NET 1.1 does not have one (I hope .NET 2.0 supplies one). I based it on this article: http://msdn.microsoft.com/msdnmag/issues/03/08/DataGrids/default.aspx I have a problem when there are two DataGrid's on one form, and when I switch focus from one grid to the other. To be more precise, when I'm editing a combo box column in one grid, and then click in the combo column of another grid an exception is thrown stating "The ListManager's position must be equal to rowNum. Parameter name: rowNum". I will post the code if anyone feels like digging into it. Anyway, perhaps someone has a better link with a how-to? Notes about the code: * The only thing that the PropertyEditorTable is used for in this context is for setting the DataSource of the ComboBox that edits the value. * The exception occurs when executing SetColumnValueAtRow in the comboBox_Leave event handler internal class PropertyComboBoxColumn : DataGridTextBoxColumn { protected PropertyEditorTable pe; private ComboBox comboBox; private CurrencyManager cm; private int iCurrentRow; public ComboBox ComboBox { get { return comboBox; } } public PropertyComboBoxColumn( PropertyEditorTable pe ) { this.pe = pe; this.cm = null; this.comboBox = new ComboBox(); this.comboBox.DropDownStyle = ComboBoxStyle.DropDown; this.comboBox.Leave += new EventHandler( comboBox_Leave ); } protected override void Edit ( CurrencyManager source, int rowNum, Rectangle bounds, bool readOnly, string instantText, bool cellIsVisible ) { base.Edit( source, rowNum, bounds, readOnly, instantText, cellIsVisible ); if( !readOnly && cellIsVisible ) { iCurrentRow = rowNum; cm = source; DataGridTableStyle.DataGrid.Scroll += new EventHandler( DataGrid_Scroll ); comboBox.Parent = TextBox.Parent; comboBox.Location = DataGridTableStyle.DataGrid.GetCurrentCellBounds().Location; comboBox.Size = new Size( TextBox.Size.Width, comboBox.Size.Height ); pe.SetDataSourceForPropertyCombo( rowNum, source, comboBox ); int foundIndex = comboBox.FindStringExact( TextBox.Text ); if( foundIndex == -1 ) comboBox.Text = TextBox.Text; else comboBox.SelectedIndex = foundIndex; comboBox.Show(); comboBox.BringToFront(); comboBox.Focus(); } } private void DataGrid_Scroll(object sender, EventArgs e) { comboBox.Hide(); } private void comboBox_Leave( object sender, EventArgs e ) { SetColumnValueAtRow( cm, iCurrentRow, comboBox.Text ); Invalidate(); comboBox.Hide(); DataGridTableStyle.DataGrid.Scroll -= new EventHandler( DataGrid_Scroll ); } } Thanks, -- Tom Tempelaere Tag: TABLE Tag: 87018
  - 23
    - Data Grid: Adding new Rows Hi There is a databound grid that is being used in one of my Master - Detail form there I need to keep two columns hidden and assign Autogenerated values once a user adds a new record through the grid. can somebody please tell me how to do this; as i couldn't find a single event that is fired once a new row is added to the grid; and also i have tried quite a bit of fruite less methods like medling with the data source etc. can somebody please help me on this. thankx in advance Tag: TABLE Tag: 87010
  - 24
    - Want to check condition before switching between child forms In My MDI Application (One Mdi Parent and around 50 mdi child forms). On each child form is a database driven form, it means user can add,update etc. record in the database. i want to check certain condition before switching between mdi child forms, if condition is true then user should be allowed to move another mdi child form otherwise not. Steps to duplicate. 1. Open first child form1 2. Open second child form2 3. Press add child form2 4. now user tries to move on form1, and i want to validate (if operation is complete : Want to complete) if yes then focus should not be moved to form1 else it should be move to form1 I was able to acheive this in vb6 but not in vb.net , can you please suggest which event should i use? i tried with leave,enter and validating but could succeed. Dharmesh Parekh Tag: TABLE Tag: 87009
  - 25
    - changing a data type for a field on a report, using VS 2K3 and CR Hello, I have an app that uses Crystal Reports for .Net. I needed to change a data type of a field in the database and on the report. I thought it would work fine, however now the field is always blank on the report. The field is actually a fomula field based on a Date/Time datatype. I am assuming that because the field is no longer a Date/Time datatype in the database that this showing up blank. Does anyone know how to reslove this type of issue? Also does anyone know of any good books/reference material for using Crystal Reports bundled within .Net? Thanks, Chris Tag: TABLE Tag: 87008
- Next
  - 1
    - Interactive tooltips I want to extend the tooltip control to handle interactions with the user via clickable links within the text. It should work a bit like this example : http://www.dyn-web.com/dhtml/tooltips/hover-tip.html but of course I want this in windows forms not ASP.NET. Any guidance anybody ? Can it be done ? Tag: TABLE Tag: 87005
  - 2
    - ToolTip question How do I make a tooltip remain visible until the user moves the mouse ? Currently it stays visible for a few seconds and then disappears. Tag: TABLE Tag: 87003
  - 3
    - The object is currently in use elsewhere I have a splash screen that is displayed as the application starts. The splash screen has text dynamically added to it to indicate the authorisation mechanism and start-up progress. Due to the nature of the splash screen graphic we have to draw the text onto the splash screen instead of assigning text directly to each labels text property. Internittently, one of our XP Pro SP2 test machines gets the following error when displaying the splash screen that displays itself in a .NET Framework invoked dialog: Exception of type 'System.InvalidOperationException' The object is currently in use elsewhere. Stack Trace: at System.Drawing.TextureBrush..ctor(Image image, WrapMode wrapMode) at System.Windows.Forms.Control.PaintBackground(PaintEventArgs e, Rectangle rectangle) at System.Windows.Forms.Control.OnPaintBackground(PaintEventArgs pevent) at System.Windows.Forms.Control.InvokePaintBackground(Control c, PaintEventArgs e) at System.Windows.Forms.Control.PaintTransparentBackground(PaintEventArgs e, Rectangle rectangle) at System.Windows.Forms.Control.PaintBackground(PaintEventArgs e, Rectangle rectangle) at System.Windows.Forms.Control.OnPaintBackground(PaintEventArgs pevent) at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean disposeEventArgs) at System.Windows.Forms.Control.WmPaint(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.Label.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) The splash screen invokes itself on a separate thread via its ShowSplash method: /// <summary> /// Initializes and shows a new <see cref="SplashForm"/>. /// </summary> /// <param name="localisedApplicationName">The localised application name.</param> /// <param name="versionedAssembly">An <see cref="Assembly"/> from which version information can be extracted.</param> /// <param name="localisedCopyright1">A first line of copyright message.</param> /// <param name="localisedCopyright2">A second line of copyright message.</param> /// <param name="localisedSplashBackdropImage">The splash backdrop image.</param> public static SplashForm ShowSplash( string localisedApplicationName, Assembly versionedAssembly, string localisedCopyright1, string localisedCopyright2, Image localisedSplashBackdropImage ) { const string THREAD_NAME = "SplashScreen"; sShownInstance = new SplashForm( localisedApplicationName, versionedAssembly, localisedCopyright1, localisedCopyright2, localisedSplashBackdropImage ); // Create the thread and start it; when the instance is // closed, this thread will stop automatically... sThread = new Thread(new ThreadStart( DoSplashScreen ) ); sThread.Name = THREAD_NAME; sThread.Start(); // Return the shown instance return sShownInstance; } The label's paint event calls DrawSmearedText: private void lblNotice_Paint(object sender, System.Windows.Forms.PaintEventArgs e) { DrawSmearedString( mNotice, lblNotice, Brushes.SteelBlue, Brushes.Red, e ); } private void lblBuildNumberAndDate_Paint(object sender, System.Windows.Forms.PaintEventArgs e) { DrawSmearedString( BuildNumberAndDate, lblBuildNumberAndDate, Brushes.White, Brushes.Red, e); } private void lblPrerelease_Paint(object sender, System.Windows.Forms.PaintEventArgs e) { DrawSmearedString( mPrerelease, lblBuildNumberAndDate, Brushes.White, Brushes.Red, e); } private void lblProgress_Paint(object sender, System.Windows.Forms.PaintEventArgs e) { using ( SolidBrush smearBrush = new SolidBrush( Color.FromArgb( 64, 255, 255, 255 ) ) ) using ( SolidBrush textBrush = new SolidBrush( lblProgress.ForeColor ) ) { DrawSmearedString( mProgress, lblProgress, smearBrush, textBrush, e ); } } The DrawSmearedString method is as follows: private static void DrawSmearedString( string text, System.Windows.Forms.Label label, System.Drawing.Brush smearColour, System.Drawing.Brush overwriteColour, System.Windows.Forms.PaintEventArgs e) { // Our background colour changes from light to dark, so we can't draw // a single text colour across it. So, we do some shadow drawing by // smearing the text around in one colour, and then overwriting it in another. if ( text != null && text.Length > 0 ) { const int OFFSET = 2; for ( int x = 0; x <= OFFSET; x++ ) { for ( int y = 0; y <= OFFSET; y++ ) { // Assume the label has more than one row and create an offset rectangle on which to draw the smeared text RectangleF drawRect = new RectangleF( x, y, label.Width, label.Height); e.Graphics.DrawString( text, label.Font, smearColour, drawRect ); } } e.Graphics.DrawString( text, label.Font, overwriteColour, label.ClientRectangle ); } } I have managed to produce this error once on a W2K machine but not when using VS 2003 IDE. We are using .NET Framework v1.1 with appropriate service packs applied. Any ideas? Regards, Ian Rowland Tag: TABLE Tag: 87002
  - 4
    - NotifyIcon and Minimize Hello, I have a form with a notifyicon. I have set ShowInTaskbar to false. When I minimize the form, the form minimize, but there is a symbol on the windows desktop for the minimized form. This symbol is the same as for child windows which are minimized to its mdi-form. What I make wrong. Thanks Albert Krüger Tag: TABLE Tag: 87001
  - 5
    - How to give initial focus? Hi, I've programmed a simple form having some panes and one button. There is a basic thing I can't find a solution for: 1) I gave the button a TabIndex of 0. The main pane has a TabIndex of 1. Still the button doesn't get the focus when the form opens. Why? I tried to give focus to the button at Form_Load(), but CanFocus is false at that time. TIA, Axel Dahmen Tag: TABLE Tag: 87000
  - 6
    - How to set Form.Height > screen height? I have a irregular form having height > 600 pixel which can be moved when any part of it is clicked and dragged. Under resolution 800 x 600, the form will appear "truncated" when i move it upward... Later I found that the Height property will be automatically set to a number slightly larger than screen height (probably screen height + title height, sth like that) whenever a set a large value to it. Is there any way i can keep a large Height even under low resolution? Thanks!! Tag: TABLE Tag: 86997
  - 7
    - Need good design for startup project I'm building a winforms app using vb.net 1.1 and have 3 basic tiers on the client side. the UI, BLL and DAL. Currently everything is in one project and at some point I'll parse it out to a separate project for each Tier. Currently the startup object is Sub Main in the form called frmMain. frmMain is open through the life of the application session. What happens is from Sub Main it runs this code to get things started correctly: Shared Sub Main() Try System.Windows.Forms.Application.EnableVisualStyles() System.Windows.Forms.Application.DoEvents() System.Windows.Forms.Application.Run(New frmMain) Catch ex As Exception ErrLog(ex) End Try End Sub Then the Load event opens the login form before frmMain has a chance to be visible. If the login succeeds, then frmMain continues to open. If the login is canceled, then frmMain exits and the application quits. ============================ What I want to do is parse the login form into a new project and make that the startup project. Then as the user logs in it can check for updates and more easily replace any of the other DLLs (UI, BLL or DAL) with out having to replace its self (if I left the login form as part of the UI exe then I think it would be more difficult to upgrade the UI exe as it would have to replace itself.). I know there are new things coming available like no touch deployment, but I'm thinking that this design will still make things easier down the road when I use a better technology for automatic updates. So my question is: Can anyone give some advise on this strategy and; if frmMain is in the UI dll rather than being in the startup project, how can I make the login form go away and have frmMain persist as the main form through out the application session? Thanks. -- moondaddy@nospam.nospam Tag: TABLE Tag: 86992
  - 8
    - Could not deactivate CTRL+F4(close window) Despite setting controlbox property to false, CTRL+F4 shortcut is still working. Anyone can help me to disable CTRL+F4? Raj kumar Tag: TABLE Tag: 86990
  - 9
    - How to use c# creat dns server zone ? HI I try it code only creat DNS ResourceRecord,How to creat dns zone? thanks! this code: public void CreateRR(string zoneName, string rrTextRep) { if ( zoneName == null ) throw new ArgumentNullException("zoneName", "zoneName is null."); if ( rrTextRep == null ) throw new ArgumentNullException("rrTextRep", "rrTextRep is null."); InvokeMethodOptions options = new InvokeMethodOptions(); options.Timeout = new TimeSpan(0,0,0,5); ManagementClass rrClass = new ManagementClass(@"\\"+ System.Environment.MachineName +@"\root\MicrosoftDNS","MicrosoftDNS_ResourceRecord",null); //Get an input parameters object for this method ManagementBaseObject inParams = rrClass.GetMethodParameters("CreateInstanceFromTextRepresentation"); //Fill in input parameter values inParams["DnsServerName"] = null; //Don't need. inParams["ContainerName"] = zoneName; inParams["TextRepresentation"] = rrTextRep; //Execute the method try { ManagementBaseObject outObject = rrClass.InvokeMethod ("CreateInstanceFromTextRepresentation", inParams, null); PropertyDataCollection outProperties = outObject.Properties; foreach (PropertyData outProperty in outProperties) { Console.WriteLine("Property = " + outProperty.Name); } } catch { throw new ApplicationException ("CreateInstanceFromTextRepresentationmethod failed."); } } // End CreateInstanceFromTextRepresentation Method. Tag: TABLE Tag: 86983
  - 10
    - Opening a Word Document Hello, I have an application that opens a word document like so: With WrdApp .Documents.Open(System.Windows.Forms.Application.StartupPath + "\Template.doc", missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing) .Selection.Paste() .Visible = True .Activate() End With This works great but when I close word the application says This file is in use by aother application or user. (.......\Normal.dot) When I click OK I get a "Save As" Dialog Box that wants me to save the normal.dot When I click CANCEL and try to exit Word the following message is displayed: Changes have been made that affect the global template, Normal.dot. Do you wnat to save those changes? How do I make this stop doing this. I just want to open a document from a .NET application. Thanks, Chuck Tag: TABLE Tag: 86980
  - 11
    - Simple question: Updating a datasource This might be a simple question, but I havent found a solution anywhere: I do some stuff, and fill a DataSet from a database. After the tables have been processed (rows inserted/deleted/updated) I want to write the DataSet back to the database. My DataTable shall replace the table in the database. Consider the original DataAdapter disposed. My current workaround is to create a new DataAdapter and new DataSet, fill the new DataSet as I did from the start, replace ALL table rows with the rows from the first table, and finally call the Update() method to write back the changes. This strikes me as not the proper way to do things. I don't see the point in retrieving all rows from the database if all I want to do is overwrite the table. Can't I create a new DataAdapter and simply tell it to update the target table with my DataTable? Secondly, how do I insert a single row into the target Table? Is the proper way to write an SQL command and put it in an OleDbCommand object? Thanks! - Peder - Tag: TABLE Tag: 86979
  - 12
    - About Trim What is the best practice Trim (myStringvar) or myStringvar.Trim thks Tag: TABLE Tag: 86978
  - 13
    - Can't exit Windows after removing a control from a form This problem occurs on Windows 2000 but NOT on Windows XP: If you programmatically remove a control from the Controls collection of a panel on another form, then that form's default WndProc will return FALSE to the WM_QUERYENDSESSION message! Is there anything that can be done to fix this other than overriding the WndProc (which I don't want to do for performance reasons)? Please help! To reproduce: (on Win 2000 obviously) VS.Net 2003, Framework 1.1 w/ service packs: In VS.Net, create a C# win forms application with two Forms (e.g. Form1 and Form2): On Form1, drop two buttons. On Form2, drop a panel, drop a button inside the panel. In Form2 code, make panel1 be public. In Form1, add a Form2 private variable (e.g. call it "form2"), then write the first button's click handler: if (this.form2 == null) this.form2 = new Form2(); this.form2.Show(); The second button's click handler: this.form2.panel1.Controls.RemoveAt(0); Then run it... click the first button, click the second button. You should see the button disappear from the panel of form2. Then try to exit Windows (or, a bit nicer, write something to FindWindow of the Form2 window and send it WM_QUERYENDSESSION). Thanks!, Greg Patrick Tag: TABLE Tag: 86975
  - 14
    - Reflection Hi, In order to display multiple lines in a column, i am creating creating a new column style deriving from the DataGridTextBoxColumn. To get the height of each row i am using the following code in one of the methods of this custom columnstyle class. MethodInfo mi = t.GetMethod("get_DataGridRows",BindingFlags.FlattenHierarchy | BindingFlags.IgnoreCase | BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Static); DataGrid dg = this.DataGridTableStyle.DataGrid; Array dgRowArray = (Array)(mi.Invoke(dg,null)); Heights = new ArrayList(); foreach (object dgRowHeight in dgRowArray) { if (dgRowHeight.ToString().EndsWith("DataGridRelationshipRow") == true) { Heights.Add(dgRowHeight); } } The above code works perfectly if use this column style in System.Windows.Forms.DataGrid control. I am also creating a custom datagrid deriving from the System.Windows.Forms.DataGrid class . If i use the above code in the custom DataGrid class, the MethodInfo mi = t.GetMethod("get_DataGridRows",BindingFlags.FlattenHierarchy | BindingFlags.IgnoreCase | BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Static); statement returns null. Is it not possible to obtain the method information of a base class?? Thanks for the help. Magesh Tag: TABLE Tag: 86968
  - 15
    - XmlElement.SelectNodes: Need help with accessing xml nodes Any help will be really appreciated. When I use XmlNodeList nodeList; XmlElement root = doc.DocumentElement; nodeList = root.SelectNodes("/bookstore/book"); to select nodes matching the XPath string, from XML file below, I get one node which is OK. BUT, if I remove the ":bk" from the attribute of <bookstore> node, I will not get any nodes. WHY? I want to be able to do that. Thank you for your help. <?xml version="1.0" encoding="utf-8" ?> <bookstore xmlns:bk="urn:samples"> <book> <title>Pride And Prejudice</title> <author> <first-name>Jane</first-name> <last-name>Austen</last-name> </author> <price>24.95</price> </book> </bookstore> Tag: TABLE Tag: 86967
  - 16
    - Bulk Load text into dataset? I have a non-delimited fixed-field text file with a record length of 5919 bytes long that I need to load into an existing empty dataset with 159 columns. Currently I am building a mapping like this: Do While sr.Peek() >= 0 dr = dt.NewRow dt.Rows.Add(dr) Dim nLine As String = sr.ReadLine() dt.Rows(iRow).Item("HH") = nLine.Substring(0, 2) dt.Rows(iRow).Item("MM") = nLine.Substring(2, 2) dt.Rows(iRow).Item("District") = nLine.Substring(4, 4) dt.Rows(iRow).Item("Exchange") = nLine.Substring(8, 8) dt.Rows(iRow).Item("Remote") = nLine.Substring(16, 8) dt.Rows(iRow).Item("Company") = nLine.Substring(24, 3) '''' ETC, ETC, ETC for 159 columns!.................................. Loop Is there some sort of 'bulk load' the data? This seems awfully cumbersome. Thanks in advance to all, Marc Tag: TABLE Tag: 86966
  - 17
    - Moving a window I stripped off the frame from a window but I still want the user to be able to move it. If the user click on the background and moves the mouse around I have some code that hooks into that and does the move but the window keeps trying to redraw itself and it greats really crazy. Is there an nice way to do this? Hook into the default moving stuff without any custom code type thing? Thanks -Cam Tag: TABLE Tag: 86959
  - 18
    - Windows application Icon Hi, I've modified the Windows application icon (App.ico) and now I can't see it when the application is in runtime and especially I cant't see it as icon of the file myapplication.exe... What should I do to restore the situation? I precise that in Visual Studio, when I open App.ico, I can see it. Thanks Tag: TABLE Tag: 86957
  - 19
    - C# Balloon Tooltip from Sys Tray Icon How can I display a balloon tooltip from a system tray icon?? I can find plenty of examples on how to do this from C++ or even Visual Basic by calling the Shell_NotifyIcon function, but I can't find how to do this from inside C#. Tag: TABLE Tag: 86953
  - 20
    - Windows Forms Panel Hi! We're developing a Windows Application kind of project under the Visual Studio .NET 2003 platform. This application has 3 main parts: - Element explorer developed with TreeView - Group of elements that show certain data - Document Viewer In the previous sections we show data from a codified XML file. This XML file is compound by static data and a group of MHT documents Base64 codified. These MHT documents are the documents viewed in the "Viewing" Section. It is in this section where we find the problem we want to ask about. In order to view this MHT document, we first transform them into HTML text, this HTML text is the one that's going to be viewed in the section. This section is formed with these elements: - Main Panel - Title Label - Controls Container Panel: in this panel the controls are added depending on the elements number in the XML file. - To show the title we use the Control Label - To show the MHT content(converted to MHT) the Activex AxDHTMLEDLib.AxDHTMLEdit is used. As we go through the data in the XML file we add the controls we just described, and also we have in mind the positions of the controls we added before, for example: Label1 X=0 Y=0 Height=30 Label2 X=0 Y=35 Height=30 Label3 X=0 Y=70 Height=30 DHTMLEdit1 X=0 Y=105 Height=60 The problem arises when we include a DTHMLEdit control. The problem is the DHTMLEdit added element does not respect the coordinates established in the code, appearing at any place in the containing panel. In the "Elements Explorer with TreeView" section there's a button placed half the way of the dark bar that collapse that section. The moment we collapse that section, the bad placed control, is placed in the right place and it gets correctly the coordinates we established previously. The error happens again when: - We start the application - We right click over the tree second node and we select "copy" - We right click over the tree first node, we select "paste all". The moment when it add the elements to the viewer, all the elements are out of place. - We right click over tany tree node save the first one, we select "add...". When the empty element is added to the Containing Panel and realocate all the elements in the Panel with valid coordinates, the Panel doesn't respect these coordinates and place the element in a non valid place. Same way when DHTMLEdit controls are wrongly placed, if we click on the arrow image in the scroll bar, those controls get placed correctly in the indicated places. For example, with the labels that are also included in the container panel, this problem doesn't appear, getting all of them rightly placed in their position. Thanks Julián Sanz García Tag: TABLE Tag: 86952
  - 21
    - Installing dll in the Global Assembly Cache Hello, I would like to do the following: Place my own DLL file on a server, install it in the GAC of some cliënt computers and use the DLL file in a VB.NET program that is also located on the cliënt computers. When I make a small change to the dll on the server, every cliënt program should use this updated dll directly, without having to rebuild and redistribute the program. I was told that this could be done my placing the dll on a server and install it in the GAC of each cliënt. I have created a strong name for the dll and I use a fixed versionnumber for it. I have installed the dll in the GAC, but when I make a change to the dll, the executable program still shows results from the 'old' dll. Does anyone know what to do about this, so my program automatically uses the new version from the dll? Greetings, Chris. *** Sent via Developersdex http://www.developersdex.com *** Tag: TABLE Tag: 86950
  - 22
    - Leave/Enter events Hi All, Is there a way to find out, on the leave-event, which control that is about to receive focus? Rgds Egil Winther ShipNet AS Tag: TABLE Tag: 86948
  - 23
    - Logged in user's first name using active directory i want to get the first name of the logged in user on the current machine, windows application i used the following code but i get System.NullReferenceException when it reaches the Console.Writeline line string myADSPath = "LDAP://myadelaide.com/CN=Users,DC=myadelaide,DC=com" ; DirectoryEntry myDirectoryEntry = new DirectoryEntry(myADSPath); DirectoryEntry mySearchRoot = new DirectoryEntry(myADSPath); DirectorySearcher myDirectorySearcher =new DirectorySearcher(mySearchRoot); myDirectorySearcher.Filter="(objectClass=user)"; SearchResult mySearchResult = myDirectorySearcher.FindOne(); myDirectoryEntry.Name if ( mySearchResult != null ) { myDirectoryEntry =mySearchResult.GetDirectoryEntry(); Console.WriteLine(myDirectoryEntry.Properties["First name"].Value.ToString() ); } though i can get the DirectoryEntry.Name but any other- DirectoryEntry.Properties["Property name"]- dosen't work though the property count is 35 when i put DirectoryEntry.Properties into quick watch. any help please Tag: TABLE Tag: 86946
  - 24
    - problems with restoring minimized MDI child form Hi Everybody, I've got a strange problem: While searching the newsgroups for something else, I've come across a post that discusses a bug with restoring MDI child forms. (for any body who is interested, the post is in microsoft.public.dotnet.framework.windowsforms by Scott Abel, the title is 'Form Message Question', from 2003-08-12 09:43:42 PST ) Briefly, the problem is that if you use Form.WindowStyle to restore a minimized MDI child that was maximized when it was minimized, the form will be restored as maximized (as it should) but then when you click on the restore button of the from it will be restored to the minimized size. That post also included a workaround for this bug (to use SendMessage to send a SC_RESTORE message to the form instead of using Form.WindowState). I have implemented this in my application. However, I've run into a strange problem: I have several child forms in my application. Some are opened using a menu, and some have buttons in a toolbar to open them. For some reason, this work around works when the code is called from a menu, but does NOT work when the code is called from the event handler of a button in the toolbar. I even created a menu item that calls the event handler of the toolbar button. When clicking on the menu item the form is restored, when clicking on the button it is NOT restored. Later on, I will try to reproduce this in a small application and will post the code. If anybody have any ideas why this happens or how to fix it, please let me know. Thanks Nadav Tag: TABLE Tag: 86944
  - 25
    - Datagrid combobox.. problem Hi, I need to to have a combobox column on the grid. The problem is when the user selects a value from the combo , when the user clicks the combo in another row i need to remove the previously selected value from the combo list. So the user has only the left available values to be selected. I added an event in the DataGridComboBoxColumn that when user enters combobox an event is raised and in this event i am removing the items. In the DataGridComboBoxColumn class i have added a function which removes the item. And i call this function in the comboentered event i had subscribed...it works.i am able to remove item..but after removing the item..the previous row which i had selected the item.that column displays blank. anyone faced such a problem.. please help!! Tag: TABLE Tag: 86938

Hi,
my code is:

DataTable dt = myDataSet.Tables[0];
newDataSet.Tables.Add(dt);

This code generate an error... "tha table dt already belongs to a dataset"...
is there a solution to this problem? namely, I would like to reach this
aim... is there another solution code?

Thanks

Top

Re: TABLE by Norman

Norman
Fri Apr 22 10:18:46 CDT 2005

See comment inline.

"Siu" <Siu@discussions.microsoft.com> wrote in message
news:B5D31EC6-85F9-4E80-ADDF-A87449D4DEA7@microsoft.com...
> Hi,
> my code is:
>
> DataTable dt = myDataSet.Tables[0];

DataTabledt=myDataSet.Tables[0].Copy() //Or
myDataSet.Tables[0].Clone(), if you only need the same table structure, not
the data

> newDataSet.Tables.Add(dt);
>
> This code generate an error... "tha table dt already belongs to a
dataset"...
> is there a solution to this problem? namely, I would like to reach this
> aim... is there another solution code?
>
> Thanks
>

Top