DataTable to Database

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
    - VB.Net & C# WIndows application exe size Hi I have created a simple application in both vb.net and c# Both apps display a hello in a messagebox in the form load event When compiled: the vb exe is 10KB the C# exe is 20KB Why the difference? Tag: DataTable to Database Tag: 94367
  - 2
    - Control.Region performance Hi, I am building a control library and I am doing code profiling on it using DevPartner. I am shocked to see that about 20 percent of my CPU performance is caused by the assignment of the Control.Region property. The situation is as follows: I have a worst-case scenario with a lot of controls on my form. Since the controls are non-rectangular, I set a Region onto them. The region is quite complex and created from a bitmap's alpha channel. Whenever the form is resized, the region is re-calculated by doing some transformations on the original regions. I would have expected this re-calculation to be the bottleneck, but the profiler points to the actual assignment of the Control.Region property as the performance bottleneck. Questions: -why is this assignment this expensive? Does it have anything to do with the disposal of old regions? -Is the use of complex regions, like regions that were build from 100 small rectangles, more expensive than a simple region that consists of only one rectangle? Thanks, Jelle Tag: DataTable to Database Tag: 94366
  - 3
    - Another reflection question: Given the string name of a property (eg. "BackColor"), how do I get and set the current value of that property for a given Control instance ? Tag: DataTable to Database Tag: 94364
  - 4
    - Problem in Dot Net 2.0 Hello, I am developing an application in C#, which was previously in .Net 2005 Beta, then it was working perfectly fine, but from the time I have upgraded it to .Net 2005 Professional, its continously giving me error on the following line, transaction = Connection.BeginTransaction(); System.Data.SqlClient.SqlException: New transaction is not allowed because there are other threads running in the session. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction) at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlInternalConnection.BeginTransaction(IsolationLevel iso) at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction() Any kind of help would be welcome. regards, Beenish Sahar Khan Tag: DataTable to Database Tag: 94363
  - 5
    - SizeGripStyle.Auto behaviour Can someone explain the behaviour of SizeGripStyle.Auto which is a value for the Form.SizeGripStyle property? According to the MSDN doc it just says "The sizing grip is automatically displayed when needed." What are those "When needed?" situations. In the doc for Form.SizeGripStyle it says "You can set this property to display the sizing grip or have it automatically displayed based on the setting of the FormBorderStyle property" But setting the FormBorderStyle property to either Sizable or SizableToolWindow doesnt bring up the SizeGrip on the form. How is the FormBorderStyle related to the SizeGripStyle.Auto property.? Tag: DataTable to Database Tag: 94355
  - 6
    - Register Window Message Hi All, Here it is what I want to do . I have a Windows Form application (app1) which at a certain moment sends a registered windows message to other Windows Form application (app2) which only listen for this window message. When app2 catches the message it performs some task and then wait again for the message. All fine by now. Because the app2 does not expose any interaction with the user (the main window of app2 is minimized to sys tray) I'd like to have the app running as a .NET Windows service. Is it possible somehow to have a Windows service application listening to a registered window message? Thanks, Mircea Tag: DataTable to Database Tag: 94352
  - 7
    - Reflection question : finding the exposed properties of a Control Given a generic Control object, how can I iterate through all the properties exposed by the control ? Different classes of control expose different properties. Ideally I'd like to find all the properties that are exposed within the "Appearance" and "Layout" categories of the form designer's property grid. I imagine I can do this via reflection but I don't really know where to start. Any pointers ? Tag: DataTable to Database Tag: 94351
  - 8
    - Transforming mouse coordinates Hi Thanks for taking the time to check this post. Any help/suggestions are appreciated. I have an owner drawn (GDI+) document generation application that is made up of embedded objects. The document acts simply as a layout container and delegates painting to the embedded items. The document supports scaling and rotation of these items. This is handled using transformations to hide to implementation of this functionality from the embedded items. The problem I am struggling to resolve is that some of the embedded items give user feedback based on the position of the cursor (this is passed to the paint method of the items). If the item has been rotated, it still stores any internal hotspot coordinates in the none rotated form and the cursor position no longer matches (it has no knowledge of the transformation). ie ... the cursor triggers the hotspot feedback when it is placed on the document in the place the hotspot would be without any rotation. Is there a simple way to transpose the coordinates. I have the angle of rotation, the origin and the start point .... I need the mouse position relative to the item as if it had not been rotated. Any ideas. Ideally, I would prefer not to have to do the maths the old fashioned way, as I would like to support more transformations at a later time. Thanks for leaving your thoughts. Tag: DataTable to Database Tag: 94350
  - 9
    - axWebBrower: how to simulate a click over an item of a java applet? Hi, There is anyone that have a sample of how is possibile to "simulate" a click over an item of a java applet running into a webBrowser embedded into a c# application? Any help will be apreciated! Thank you Tag: DataTable to Database Tag: 94349
  - 10
    - a simple task... with errors I use this simple code to get a Date and a Text from DateTimePicker and TextBox as Multiline into an ArrayList (utente.listaProblemasPassivos) and then show it in a DataGridView (dgListaProblemasPassivos) ----------------------------------------------------------------------------- Dim sData As String = LProb_DataPassivos.Value.ToShortDateString.toString Dim sDesc As String = LProb_DescricaoPassivos.Text utente.listaProblemasPassivos.Add(sData) utente.listaProblemasPassivos.Add(sDesc) dgListaProblemasPassivos.DataSource = Nothing dgListaProblemasPassivos.DataSource = utente.listaProblemasPassivos ----------------------------------------------------------------------------- And I alwys get this Error: "Object reference not set to an instance of an object" in the first ADD line I can't give a new instance to the utente.listaproblemaspassivos ArrayList cause it's an ArrayList from my own Class and it could have values when it gets here, and I can't erase them.... It's kind of a session variable, always the same (with add item and erase item) until the user save the work. -- Bruno Alexandre (Sintra, PORTUGAL) Tag: DataTable to Database Tag: 94345
  - 11
    - datagrid edit not saved on exit I have a bound datagrid on a form, with a close button. All the close button does is call me.close. If I edit a cell, then click my close button, the edit can be seen in the grid, as expected, when I enter my form_closing event code. However if I edit a cell then click the "X" in the top right corner of the form, the form_closing event fires, but the grid shows the "old" value of the cell, thus the change to the cell is not saved. I am working around this currently by preventing the user form using the "X" to close the form, but there must be a better way ? Tag: DataTable to Database Tag: 94344
  - 12
    - ActiveX ruins Validation events. Hi. I am using an ActiveX control in a .NET application which I put on a form. I have another .NET control on that form that handles the Validating event. The method that handles the Validating event, shows a message box and sets e.Cancel = True. When I click any other control in the form, the message box shows and the focus returns to the control that handled the Validating event. The problem happens when I click on the ActiveX control. The ActiveX control gets the focus and the focus doesn't return to the validated control and no message box is displayed. With a different ActiveX control the message was displayed, but the focus didn't return to the validated control. I reproduced the bug in a small application. In that application I wrote an ActiveX in VB 6 that has an edit box. In a c# .NET application I put on a form the ActiveX and 2 text boxes. One text box is validated and is called textBoxValidated and the other one is not vaildated and is called textBoxRegular (the regular text box is used to demonstrate regular validating behaviour) . In this form, the first time you click on the ActiveX, it works ok, but the 2nd time it doens't work ok Here is the code of the form: " using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; namespace WindowsApplication5 { /// <summary> /// Summary description for Form1. /// </summary> public class Form1 : System.Windows.Forms.Form { private AxProject1.AxUserControl1 axUserControl11; private System.Windows.Forms.TextBox textBoxValidated; private System.Windows.Forms.TextBox textBoxRegular; /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel.Container components = null; public Form1() { // // Required for Windows Form Designer support // InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // } /// <summary> /// Clean up any resources being used. /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1)); this.textBoxValidated = new System.Windows.Forms.TextBox(); this.axUserControl11 = new AxProject1.AxUserControl1(); this.textBoxRegular = new System.Windows.Forms.TextBox(); ((System.ComponentModel.ISupportInitialize)(this.axUserControl11)).BeginIniÂt(); this.SuspendLayout(); // // textBoxValidated // this.textBoxValidated.Location = new System.Drawing.Point(448, 72); this.textBoxValidated.Name = "textBoxValidated"; this.textBoxValidated.TabIndex = 2; this.textBoxValidated.Text = "validated text box"; this.textBoxValidated.Validating += new System.ComponentModel.CancelEventHandler(this.textBox1_Validating); // // axUserControl11 // this.axUserControl11.Enabled = true; this.axUserControl11.Location = new System.Drawing.Point(128, 160); this.axUserControl11.Name = "axUserControl11"; this.axUserControl11.OcxState = ((System.Windows.Forms.AxHost.State)(resources.GetObject("axUserControl11.OÂcxState"))); this.axUserControl11.Size = new System.Drawing.Size(320, 240); this.axUserControl11.TabIndex = 3; // // textBoxRegular // this.textBoxRegular.Location = new System.Drawing.Point(544, 152); this.textBoxRegular.Name = "textBoxRegular"; this.textBoxRegular.Size = new System.Drawing.Size(88, 20); this.textBoxRegular.TabIndex = 4; this.textBoxRegular.Text = "Regular text box"; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(824, 470); this.Controls.Add(this.textBoxRegular); this.Controls.Add(this.axUserControl11); this.Controls.Add(this.textBoxValidated); this.Name = "Form1"; this.Text = "Form1"; ((System.ComponentModel.ISupportInitialize)(this.axUserControl11)).EndInit(Â); this.ResumeLayout(false); } #endregion /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main() { Application.Run(new Form1()); } private void textBox1_Validating(object sender, System.ComponentModel.CancelEventArgs e) { MessageBox.Show("DAN:("); e.Cancel=true; } private void button1_Click(object sender, System.EventArgs e) { Application.Exit(); } } } " Does any one know how to overcome this bug? Thanks , Dan & Zeev. Tag: DataTable to Database Tag: 94342
  - 13
    - Get XML using NetworkCredential Hi, I'm developing a windows application in C# which gets a xml string from another website. To get the xml I'm using the following lines of code. <cut> XmlUrlResolver resolver = new XmlUrlResolver(); NetworkCredential myCred = new NetworkCredential("myusername", "mypassword", "http://del.icio.us/api/tags/get?"); CredentialCache myCache = new CredentialCache(); myCache.Add(new Uri("http://del.icio.us/api/tags/get?"), "Basic", myCred); //resolver.Credentials = CredentialCache.DefaultCredentials; resolver.Credentials = myCache; XmlTextReader rdr = new XmlTextReader("http://del.icio.us/api/tags/get?"); rdr.XmlResolver = resolver; // Set the resolver. </cut> The code works fine, but when I try to get the xml I receive an error: "authorization required". This is because the visual studio application identifies itself other than a normal browser. Is it possible to set the user agent for my program? Thanks, Aart Tag: DataTable to Database Tag: 94341
  - 14
    - Creating a Paint Screen Hi guys, I'm builing this nice Clinic Register for Doctors, and one of the things they asked me is a property that I can't know how to implement... They want me to show a paint board (kind like MSN Messenger but simpler) with a pencil and a rubber, so they can design the family tree of the pacient... I already serched Google with no luck in such property.... Does anyone have ideias? -- Bruno Alexandre (Sintra, PORTUGAL) Tag: DataTable to Database Tag: 94340
  - 15
    - sorting a list view Hi, Is the technique for sorting a list view by columns in VS 2005 the same as in VS 2003? In VS 2003 I used this excellent paper: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwinforms/html/listviewsort.asp If not, where can I find a similar paper explaining how to implement it? Thanks, Ohad Tag: DataTable to Database Tag: 94335
  - 16
    - problem in context menu Hi, I'm using a context menu on a treeview control in VS 2003. The problem happens when displying the context menu for the first time, the tree node for which to display the context menu needs to be right clicked twice (not a double click but two distinct right clicks). After the first time a single right click is enough for any tree node. Any ideas how to fix it? Another problem, when right clicking a tree node that is not in focus the context menu won't open. It first must be in focus by left clicking it. How can I force it to open? (like the behavior of windows explorer). Thanks in advance, Ohad Tag: DataTable to Database Tag: 94334
  - 17
    - OnKeyPress & return key in the OnKeyPress event method of SWF.Control e.KeyChar = '\r' when the user press ENTER is it to be expected? -- Regards, Lloyd Dupont NovaMind development team NovaMind Software Mind Mapping Software <www.nova-mind.com> Tag: DataTable to Database Tag: 94333
  - 18
    - Create custom cursors in vs2005 Hello, I've tried to find something on this in the newsgroups but came up with nada: I'm trying to create a custom cursor in VS2005. I have a .cur file that I have put in my "Resources" folder. The resource manager does not recognize the .cur extension and puts it under the generic "Files" category (vs. "Images", "Icons", "Strings", etc.) When I try to refer to the cursor, like: Properties.Resources.arrowTrans, apparently it comes out to a byte[]. How can I convert this into a Cursor object? I used to have code in 2003 that used the GetManifestResourceStream method, but that doesn't work. And how does the "BaseApplicationManifest" option work in the "Build Action" item (vs. "None", "Embedded Resource", "Compile", and "Content") in the file Properties window? Thanks, Jon Tag: DataTable to Database Tag: 94331
  - 19
    - A quick question about DataGrid Hello How can I bind a column's value to another table? All tables are in the dataset already, I just have two tables and I bind table1 to the datagrid eg) table1 column....,level_id, level2_id,... level_id is a FK to table2, I want to show the level_name instead of level_id. How can I show table2's level_name according to each record's level_id? Thank you very much! -- Best Regards! Sowen Zhang http://com.angGoGo.com http://www.angGoGo.com http://biz.angGoGo.com Tag: DataTable to Database Tag: 94330
  - 20
    - URGENT: VS2005 Text Rendering Issue First up, sorry for cross-posting. I have what is (to me, at least, an urgent issue) with the look/feel of my applications. I have been using VC# EE Beta2 until about a week ago and I have just bought VS2005 Professional RTM. All programs I've written in VC# EE now do not render text correctly. The labels and controls render much the same way as they do with .NET1.X, ugly and about 1.5 spaced. New projects look fine, like a native Windows program and don't suffer the rendering issue. For my upgraded VC B2 apps I've made sure that UseCompatibleTextRenderer = false and I've done a clean build. Can some one *please* help me with this problem. Thanks in advance, Annette. Tag: DataTable to Database Tag: 94327
  - 21
    - Folder Viw, File View ??? I need to display a treeview with a checkbox to allow me to select certain folders / files. Is there no folder view or file view in Studio .NET 2005? How can this be accomplished without a third party control? Thanks. Tag: DataTable to Database Tag: 94322
  - 22
    - DataGridView Scheduler Hi, Can anyone help me with the following? Using the new DataGridView in .NET 2.0, can the look be configured so that the days of the week are headers and the rows are subdivided into 30 min. time intervals much like Outlook allows you to schedule appointments. I'd like the same look and feel. As an option, I'd like to be able to add multiple "Customer" objects to any given cell and click on a single customer to bring up his history/appointments, etc... For example, cell at location 5,4 may contain 4 "Customer" objects, and clicking on one of the objects in that cell would bring up another for with customer information, etc... Regards, Giovanni Tag: DataTable to Database Tag: 94318
  - 23
    - How to change color of title bar? Hi, How can I change the color of the title bar on my winform application? (without regard to the desktop display settings) Any suggestions? Thanks. Tag: DataTable to Database Tag: 94317
  - 24
    - Application window gets smaller than MinimumSize Hello, I am writing an application in Visual Studio .NET, C#. Application is set to maximize after start. I set in Form properties MinimumSize to 800; 600. Everything is OK - I can't resize application window to be smaller than 800 x 600. But, when I set screen resolution to 800 x 600, set task bar to be always visible (and also has height of a few heights of standard task bar height - that working area of the desktop is maybe 800 x 500), application window is smaller than 800 x 600 (which was set as minimum). Application window fit working area of screen (screen size minus area of always visible task bar) which is smaller than minimum size set in Form properties. When I click on Maximize Box, application window gets bigger and fits all the screen size (some area of my application's window is then under task bar) -- it is what I want. I tried to manually set form Height to 600 on Resize event, but it did not help. How to cause that application window is always not smaller than 800 x 600 ? Thanks in advance, Robot Tag: DataTable to Database Tag: 94316
  - 25
    - TimeLine Control Greetings, Anyone have a good suggestion for a timeline control for .NET? This is something which should be zoomable in and out and fully customizable for the various entries which would be displayed on the horizontal bars (such as responding to click events on the various items, etc...). Michae Tag: DataTable to Database Tag: 94314
- Next
  - 1
    - Load form in a tab panel? Hi there, Is there a way to display a form onto a tab panel dynamically? I am trying to supply a form from within a referenced component to the main application dynamically at runtime. I want the same tab panel to be able to display any form residing within or outside its assembly. Is there a way to do this? Thanks in advance! AM Tag: DataTable to Database Tag: 94310
  - 2
    - How would I persist a DataGridView's selected row after a sort? (Using VB .NET 2.0 release) Does anyone have a suggestion for the subject question? Looking at the MSDN2 documentation for the DataGridView.Sorted event I found the note "the current cell is not automatically persisted when sorting". I have unfortunately not been able to find any reference on how to change this default behavior. Thanks, Nate Tag: DataTable to Database Tag: 94308
  - 3
    - creating a property in a Class to avoid DBNull Hi guys, I created a Class to my program, and it runs fine except one little detail... when the Database Value is Null I always get an Error when using it user.name = trim(reader.item("tName")) How can I avoid this? I have public class user (...) private strName as string = "" property name() as string get return strName end get set(byval value as string) strName = value end set end property (...) end class how can I test the value for System.DBNull ? I always get error messages saying that I can't use If Value.IsNullorEmpty Then (...) -- Bruno Alexandre (Sintra, PORTUGAL) Tag: DataTable to Database Tag: 94306
  - 4
    - "invalid attempt to read when no data is present" Hi guys... I'm stuck! I'm devoloping this program and everything was doing fine, until now! This is what happends. <my VB.NET 2.0 code> Sub getUtenteIntoVariables(ByVal idUtente As String) Dim conn As New SqlClient.SqlConnection(connString) Dim cmd As New SqlClient.SqlCommand Dim reader As SqlClient.SqlDataReader Dim strSQL As String Try strSQL = "SELECT tnome FROM utiUtentes" With cmd .CommandText = strSQL .CommandType = CommandType.Text .Connection = conn End With conn.Open() reader = cmd.ExecuteReader() ' Data is accessible through the DataReader object here. Uten_Nome.Text = reader.Item("tnome").ToString conn.Close() Catch ex As Exception MsgBox("Error: " & vbCrLf & ex.Message & vbCrLf & vbCrLf & "SQL Query: " & vbCrLf & strSQL & vbCrLf & vbCrLf) Finally 'Beep() End Try End Sub </my VB.NET 2.0 code> When it gets into this line Uten_Nome.Text = reader.Item("tnome").ToString the program breaks and shows me this message: "invalid attempt to read when no data is present" I know that I have date in it, I can see with GetOrdinal("columnname") method.... What am I doing wrong? -- Bruno Alexandre (Sintra, PORTUGAL) Tag: DataTable to Database Tag: 94301
  - 5
    - Controlling/running Excel from a vb.Net App I know you can do it. Just need some slick code to 1. Create an excel App, WorkBook worksheet or range 2. Post amounts to a cell 3. Print 4. Save the sheet 5. Exit the excell App. Thanks in advance jwc *** Sent via Developersdex http://www.developersdex.com *** Tag: DataTable to Database Tag: 94299
  - 6
    - CCeDocListDocTemplate on Windows Mobile 5.0 Problems Hello all, I am currently using the CCeDocListDocTemplate class, however, I'm having problems with it on a Dell Axim 51, which uses Windows Mobile 5.0. When the widget is used, it displays the list of files in a mangled format. The format appears to be the first character of the filename followed by the creation date of the file: So for a file named "survey.srv" it would show up as: "s11/12/17". This works fine on the Dell Axim 50, which does not use Mobile 5.0. Are there any known issues with this? Should I be using something else for the Dell Axim 51? Here's the relevant snippet of code: CString m_strDefaultFolder = CString(_T("All Folders")); CString m_strFilterList = CString(_T("Survey Data|*.srv")); pDocTemplate = new CCeDocListDocTemplate( IDR_MAINFRAME, RUNTIME_CLASS(CFSDoc), RUNTIME_CLASS(CMainFrame), // main SDI frame window RUNTIME_CLASS(CFSView) // ); ,m_strFilterList, m_strDefaultFolder); Any help is much appreciated! Thanks, Ryan Tag: DataTable to Database Tag: 94296
  - 7
    - ClickOnce Install returns XML .... I have deployed an application with ClickOnce Publish wizard to a web site. But when I click web page Install button the web server just returns the content of the .application file as XML to the browser on my own client. I made a quick try on two other clients and it seems that they are capable to interpret the web page correct ..... My Client: Win2000 SP4 well patched, VS2003, VS2005 Server: Win2003 version 5.2, .application MIME type added, directory configured as virtual directory or application. NO Framework 2.0. I followed instructions on: http://www.windowsforms.net/FAQs/default.aspx?PageID=3&CategoryID=24&SubCategoryID=26&tabindex=2 But the second advice I'm afraid I don't understand: "..... Second, you may need to configure your server to unblock any restricted file extensions used by your app, such as .exe, .dll, .config., manifest, etc. ...." Should I add more MIME-types? This article on changes in VS2005 Beta 2 mentions four MIME-types: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/ClickOnceVS05.asp Tag: DataTable to Database Tag: 94294
  - 8
    - Send RTF formatted e-mails with outlook Hello, I want to send an RTF formatted e-mail with Outlook. I read somewhere that just assigning some rtf-code to the Mail.Body property won't work. So I tried the code that I found on http://www.outlookcode.com/d/formatmsg.htm#wordmail (I added this code at the end of this message) Making a new RTF-formatted e-mail works just fine, but the receiver of the message always sees the e-mail as plain text (no matter which e-mail format (plain text, rtf or html) he/she selected). Does anyone know how to send RTF e-mails, so that the receiver also sees the e-mail as RTF? Greetings, Chris Code: Dim objSession, objMessage, objMessageFilter As Object Dim MessageID, cRTF As String Dim bRet As Integer Set objSession = CreateObject("MAPI.Session") objSession.Logon ' Read the first message in the Inbox Set objMessage = objSession.Inbox.Messages(1) objMessage.Update ' to get a permanent Entry ID MessageID = objMessage.ID ' We must initialize the string variable we are passing ' to a string of the maximum length we want to read cRTF = Space(500) bRet = ReadRTF(objSession.Name, objMessage.ID, _ objMessage.StoreID, cRTF) If Not bRet = 0 Then MsgBox "RTF Not Written Successfully" Else MsgBox "RTF Text: " & Chr(13) & cRTF End If Set objMessage = Nothing objSession.Logoff Set objSession = Nothing *** Sent via Developersdex http://www.developersdex.com *** Tag: DataTable to Database Tag: 94285
  - 9
    - Drawing Vertical Text Does anyone know how to render text vertically? I need text to appear on the left of my screen reading from bottom to top and on the right reading from top to bottom. Tag: DataTable to Database Tag: 94280
  - 10
    - Picture click event Hi all, How to set the specific area in the picture to become a click event? What control i need to use? In vb 6, i can use image control because it's transparent when no src is attached. In vb.net, i have out of ideaa.. My objective is to develop a interactive map. For example, user click on the specific area, it will shows data. Please advice.thank you in advance. Best regards, Ocurnos. Tag: DataTable to Database Tag: 94272
  - 11
    - Toolstripmenu and -items don't use menu system color setting I've got a customer who has set his menu text to white on black. When using a new VS2005 toolstripmenu (tsm) we run into all sorts of problems, because the tsm doesn't automatically use the menu system backcolor. The menu's all have white text on light grey backgrounds and are totally unreadable. Is this a bug? Seems like it, since they *do* take over the menu text system color as forecolor. I've tried using a small routine to walk over all toolstripmenuitems (and since they're not members of the forms controls that's tedious as well) and set their backcolors, and it works, but now the highlight color and the checkmarks remain stubbornly purple. It looks awful and annoyingly there are no properties available to set those. This way the entire toolstripmenu becomes utterly useless. Has anybody got a clue how to fix this? Tag: DataTable to Database Tag: 94264
  - 12
    - TabPage Alignment property change at runtime problems/bug Hi! When TabPage.Alignment property is changed at runtime tabs are not displayed correctly i.e. text is not displayed and visual style changes to something not seen with any of the available styles. It has been reported many times by different users. After googling for some time (can I use this word on MS forums?) I found short explanation for a reason. Setting Alignment property causes control to be destroyed and recreated with new handle and setting it with container causes the whole mess. However, I have not found any hints on solution to this problem. Are there any KB articles describing this issue or is there any solution to that problem? Tag: DataTable to Database Tag: 94260
  - 13
    - Question about IComponentChangeService - OnComponentAdded() I am trying to create a service that will hook to the events fired by the IComponentChangeService. I will use this new service to automatically position controls based on their size and location, the controls have to stay for example within an area of 300, 300. So if anyone created a control outside this area the control will automatically be moved to the new location within the 300, 300 area. When you listen to the event ComponentChanged of the IComponentChangeService you get the components name, the property that changed, the new and the old value of the property. Thus when a user changes the location of a component or the size and its bounds are outside the 300, 300 area I can successfully roll back to the old property value. But now for new components you can hook to the ComponentAdded event but there is one big problem. When this event is fired the component does NOT have the location property set yet. Therefore I am wondering where or when is the Location property actually set? And why doesn't the ComponentChanged event get fired when the location property is set afterwards because that would have also fixed my problem. Gabriel Lozano-Morán Real Software Tag: DataTable to Database Tag: 94259
  - 14
    - Master/Detail Binding TabControl hallo! kann mir jemand sagen wie ich detaildatens=E4tzen von einem dataset in einem TabControl(Tabpages) darstellen kann. ich m=F6chte eine Form erstellen mit der ich die Kundenstammdaten verwalten kann (Name, Adresse usw.). Beim Programmstart f=FClle ich ein dataset mit den entsprechenden Tabellen und Realtionen. Klappt auch alles soweit, nur da in der anwendung vorgesehen ist, dass jeder Kunde mehrere Adressen angeben kann, wollte ich die Adressdatens=E4tze zu einem ausgew=E4hlten Kunden der =FCbersichthalber in einem TabControl darstellen. Sprich, die Tabpages werden zur Laufzeit generiert und die Textboxes erhalten alle ein Binding in der Art: txtOrt.DataBindings.Add("Text", this._ds.Tables["tblKunde.KundenAdressen"], "Adr_Ort"); - es gibt ein Tabelle Kunde mit Name und eine Tabelle Adressen mit 1:n beziehung. KundenAdressen ist die Relation - wird jetzt eine Tabpage selektiert setze ich die entsprechende Position mittels CurrencyManager fest, sodass der richtige datensatz angezeigt wird. alles ok, aber beim zur=FCck schreiben der daten in die datenbank mit der methode Update() wird nur der Datensatz gespeichert der zu dieser zeit sichtbar ist. Ich hoffe es gibt hierzu eine sinnvollere L=F6sung mittels Binding oder =E4hnlichem. habe gestern den ganzen tag damit verbracht ein ensrechendes posting zu finden. aber leider ohne erfolg. w=E4re super, wenn mir jemand helfen k=F6nnte, ihr wisst ja wie das ist. gr=FC=DFe pato Tag: DataTable to Database Tag: 94258
  - 15
    - How do you limit a Form's container area without changing the sze? Basically I have a form that is 400w and 400h in pixels. I want all children added (either by the designer or programatically) to be layed out within say a 300w x 300h sub area, so that the outlying 100x100 pixels are ignored as a container but still available for me to paint on. Make sense? I basically want to create the concept of client size but within the client area, so a sub-client area.. Tag: DataTable to Database Tag: 94250
  - 16
    - Use Running App All - I have used mtux to check for a running app and close it down if it a previous app instance is running. Now, when a user double clicks on one of the saved application files, I'd like for the existing instance of the application to come to the front and use the file the user double clicked. I have no issues doing this when no instance of the app is running but if it is already running, how do I go about this? Thanks, Brian Tag: DataTable to Database Tag: 94246
  - 17
    - Every 5th Datagrid Line a different colour Hello, Can someone tell me how to change the 5th datagrid line colour? I can change all of them, but not only the fifth ones. Any help much appreciated! Cheers G Tag: DataTable to Database Tag: 94245
  - 18
    - How do I simplify this code I have a select case which opens various forms as ShowDialog. Notice the repetition; \\ Case "btnManageJobs" Dim f As New f010Jobs Me.Visible = False f.ShowDialog() Me.Visible = True Case "btnSeqOfOper" Dim f As New f050SqOO Me.Visible = False f.ShowDialog() Me.Visible = True Case "btnViewer" Dim f As New f060View Me.Visible = False f.ShowDialog() Me.Visible = True // How can I take the code... \\ Me.Visible = False f.ShowDialog() Me.Visible = True // ... and put it after the select case block? IOW is there any way to declaire "f" before the select case block and give it the form name within the select case and then run the "f.ShowDialog" after the block. Orrrrr is there a simpler way to do this? thank you, dbuchanan Tag: DataTable to Database Tag: 94244
  - 19
    - listbox multiselect madness Hey all, On a windows form, I have a databound listbox with multiselect. All I want to is spin through the selected items and find the value for each. I've been everywhere and still haven't found a way to do this. Please don't show me thee xample with listitem. There are no listitems in windows forms. Little help... Tag: DataTable to Database Tag: 94239
  - 20
    - How do I determine which button was clicked I have added handlers handlers to direct all buttons to one method like this; 'Add handlers for buttons AddHandler btnManageJobs.Click, AddressOf Button_Click AddHandler btnSeqOfOper.Click, AddressOf Button_Click AddHandler btnViewer.Click, AddressOf Button_Click AddHandler btnScfmCalculationTool.Click, AddressOf Button_Click AddHandler btnAdminSetup.Click, AddressOf Button_Click How do I determine which button was clicked? I think I use "sender" but do not know how. Can someone help me? Thank you, dbuchanan Tag: DataTable to Database Tag: 94235
  - 21
    - windows.Forms.Application.CompanyName is blank Hi Everyone, I am using Visual Studio 2005. I have converted my solution from VS 2003. I am set and everything is working. However, the code that ran fine under VS 2003 throws a run time error. The system.Windows.Forms.Application.CompanyName and ProductionName are empty. They worked find under VS 2003. Has anyone run into the same problem? I would appreciate anyone's insight into this. The code is below. Thanks, Craig Adams Vivus Software, Inc. Public Shared Function DefaultFileName() As String Dim fn As String = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) fn &= "\" & System.Windows.Forms.Application.CompanyName & "\" & System.Windows.Forms.Application.ProductName & "\Preferences.dat" Return fn End Function Tag: DataTable to Database Tag: 94220
  - 22
    - System.Drawing - SafeNativeMethods . GdipFillRectangleI method causes a lot of page faults We just profiled our application and noticed that SafeNativeMethods.GdipFillRectangleI method (called by Graphics.FillRectangle) in System.Drawing causes 88% of all of our -soft- page faults. We are soft faulting on an order of 2000 spfs/sec with 10 charts - with one charts we are to 600 SPFs/sec. Both numbers are high. We are a charting intensive, real-time trading .NET application that plots real time trading data on a high frequency basis. Does anyone know of any performance issues with GDI drawing functions in .NET framework...? Tag: DataTable to Database Tag: 94218
  - 23
    - PropertyGrid painting Is there a way to paint a different color for the title of each property in a property grid -- i.e. to have the title background be different from the edit field background for the property? Tag: DataTable to Database Tag: 94215
  - 24
    - PropertyGrid Is there a way to programmatically set the location of the PropertyGrid's splitter bar. Often there is too much white space to the right of my property titles and I would like to be able to move the splitter bar over. Tag: DataTable to Database Tag: 94214
  - 25
    - DataGridView Update Hi All, I am using VS 2005 and would like to accomplish the following: Assuming I have 3-4 grids on a given Windows Form. I would like to update these grids individually on a specified timer interval without blocking the UI thread. When the info is available for a specific grid, it is updated with the latest values from the SQL Server 2000 database backend. What would be the best way to do this? I think I'd need to start a new thread for each grid's Update/Refresh method or maybe even use the new BackgroundThreadWorker object. Any ideas, hints, code tips (VB.NET). Regards, Giovanni P. Tag: DataTable to Database Tag: 94212

Hi guys,

I have a dataTable with 2 columns and several rows...

How can I pass this into the Database?
How can I read row by row so I can insert it in Database, somthing like

for each dataTable.row

col1 = .column("date").toString
col2 = .column("desc").toString

sSQL = "INSERT INTO tblTable (t1, t2) VALUES ('" & col1 & "', '" & col2
& "')"

next

--

Bruno Alexandre
(Sintra, PORTUGAL)

Top