Export datagrid to excel and access

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
    - Newbie Help How do I perform an undo in a datagrid? Below is the code that I am trying to work with and it is not working. School11 is my dataset, Student is a table in an access db. I am using a Windows Form with a datagrid1. Can someone please give me a hand? Private Sub btnUndo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUndo.Click School11.Tables("Student").RejectChanges() DataGrid1.Refresh() End Sub() Tag: Export datagrid to excel and access Tag: 80082
  - 2
    - using Webbrowser control (SHDocVw) to navigate file system This is not a problem itself by using: AxWebBrowser1.Navigate("C:\Documents and Settings\Calvin Ouyang\My Documents\My Pictures"). However sinceI am browsing the My pictures folder, I want to show the thumbnail view. Is a way I can control that by using this webbrowser control (SHDocVw)? Thhanks a lot. Calvin Tag: Export datagrid to excel and access Tag: 80077
  - 3
    - updating winform Hi, I am having issue w/ threading. I have a datagrid and I want to run FillDG() in different thread and once it finishes, I want to bind the data. private void button1_Click(object sender, System.EventArgs e) { Thread t = new Thread(new ThreadStart(FillDG)); t.Start(); // I don't know what to put here to wait for t to finish // I tried t.Join(); but this locked up the win form, i.e. I can't move the form around myDataGrid.SetDataBinding(myDataSet, "myDataTable"); } Please advice, thanks! -P Tag: Export datagrid to excel and access Tag: 80074
  - 4
    - hWnd question... I am not sure that I understand what the Control.Handle value represents. The MSDN documentation say that it is "the window handle that the control is bound to." Does this mean that the handle is for the control itself or for the control's parent form? I am trying to call a Win32 API metohd that will set the scroll position of UserControl. The method requires an hWnd, and I am wondering if the control's base.Handle would give me that value. Any insight would be appreciated. Thanks! Tag: Export datagrid to excel and access Tag: 80070
  - 5
    - OpenFileDialog box problem Hello, I am using an OpenFileDialog box to upload a file into my program. It works, unless the user clicks on the My Documents folder. If you go through the c: listing, you can access the My Documents folder. However, if you click the button on the left side of the dialog box or try to click directly to My Documents without going through the c:, the entire program freezes. Any ideas what is happening? Thanks Tag: Export datagrid to excel and access Tag: 80065
  - 6
    - Can ShowHelp handle a url that targets a name containing spaces? Hi, I have a helpfile where there happens to be name anchors containging spaces, e.g. <a name="name with space"> Can I pass my arguments to ShowHelp in a way that will navigate to the name? I tried something like this: string file= @"C:\path with space\myhelp.chm"; string topic="html/concepts.htm#concept name"; Help.ShowHelp(this, file, HelpNavigator.Topic, topic); The file shows up with the correct page (concepts.htm", but it doesn't navigate to the name. I know it is bad practice to have spaces in names, but I am not in power to change this. Is there any way I can get the help up correctly? Greatful for any hints. Anna Neiderud (Also, I am trying to do the same thing with javascript in a different setting - any input on that would also be appreciated) Tag: Export datagrid to excel and access Tag: 80058
  - 7
    - Datagrid - set backcolour on individual cells? How do I set the background colour on an individual cell in a datagrid? All I want to do is iterate through all the cells and if a cell has a certain text value ('Unbooked') colour the background in red... Chris Tag: Export datagrid to excel and access Tag: 80057
  - 8
    - DataGrid ReadOnly Column BUG ! I´ve found a weird behaviour in the DataGrid: Scenario: ---------- I use a TableStyle with several standard TextBoxColumns within. One of that columns have the ReadOnly property set to true. In execution, select the text or a part of it in a cell inside the ReadOnly column. Then, do something that force the DataGrid to loose the focus and afterwards something else that changes its contents (DataSource changed, parent datagrid´s selected row changed, whatever...) After that, the text of the cell you selected is not refreshed, so it still appears in the DataGrid, even if all the rows of the DataGrid disappeared, the text is still there, by itself, looking at me and laughing. The text is refreshed if you give focus to the DataGrid again (by clicking on it or by manually calling .Focus() ). Im afraid I´m not using the correct terms to to search in the groups couse I couldn´t find much about the issue. I think it´s important enough to fix this, you guys out there ;) Thanks in advance. Regards, Iñaki. Tag: Export datagrid to excel and access Tag: 80056
  - 9
    - Datagrid doubleclick event in cells? How do I make the doubleclick event fire when a user double clicks in a datagrid cell? It only seems to work when they click on the border or columns. Tag: Export datagrid to excel and access Tag: 80055
  - 10
    - searching in a listbox explorer style Hi If you have multiple items in a listbox, click into the listbox, then type for instante the letter "p", the first item whose text property starts with "p" will be selected. Pressing "p" again will jump to the next item starting with "p", etc. In Windows explorer, you can type multiple letters after each other, and if you're fast enough, they'll be taken as a search term together. For instance pressing "p" then "e" then "a" would lead to the first folder/file whose name starts with "pea" being selected. Is there any way to achieve this functionality in a Listbox as well? Regards Stephan Steiner Tag: Export datagrid to excel and access Tag: 80045
  - 11
    - Custom Focus Is there some interface I have to implement to make a custom control recieve focus (and be recognized as recieving focus)? Thanks everyone. -- === Phil (Auckland | Aotearoa) Tag: Export datagrid to excel and access Tag: 80042
  - 12
    - OpenFileDialog and DataSet WriteXML strange problem Hi, I have a very strange problem which i hope someone can help shed light on. I have a Windows Forms application which provides data-entry UI. Data inputted is then stored into a DataSet which will be persisted into a XML file using the WriteXML method. The Dataset which contains a Filename data column (type = string); A user selects a file using the OpenFileDialog component. The file name is displayed in a textbox until the user clicks on the Save button. PROBLEM: If the file is selected using the OpenFileDialog.ShowDialog() method, the file name is added to the dataset, but it is not written to the XML file. However, if the filename is manually typed into the textbox, saving to XML file succeeds. Further tests shows that this problem only shows up in WinXP system. Machines running 2000 saves the XML file just fine. In the event of failure, no exceptions nor errors are shown. This is a very strange problem, any help will be very much appreciated! Thanks, nick Tag: Export datagrid to excel and access Tag: 80034
  - 13
    - 2 Datagrids AllowNew Hi Have two Datagrids in a Master Detail relationship, used the example from syncfusion to bind to a currency manager and set the allowNew to false, but it does not work for my child datagrid. Any help would be great. thanks dave. here is some code // Connection Adapters CBAdapter = new OleDbDataAdapter("Select * From tblCashBook", CBConnect) ; CBAdapterSplit = new OleDbDataAdapter("Select * From tblCashBookSplit", CBConnect) ; CBDataset = new DataSet(); CBConnect.Open() ; CBAdapter.Fill(CBDataset, "tblCashBook") ; CBAdapterSplit.Fill(CBDataset, "tblCashBookSplit") ; // Setting up datagrid columnstyles DGCashBook_SetupColumnStyles(); DGCashBookSplit_SetupColumnStyles(); CBDataset.Relations.Add("CashBookToSplit", CBDataset.Tables ["tblCashBook"].Columns["SplitNumber"], CBDataset.Tables["tblCashBookSplit"].Columns["SplitNumber"]); this.DGCashBook.DataSource = CBDataset.Tables["tblCashBook"]; this.DGCashBookSplit.DataSource = CBDataset.Tables["tblCashBook"]; this.DGCashBookSplit.DataMember = "CashBookToSplit"; this.DGCashBook.AllowNavigation = false; CBCmdBuilder = new OleDbCommandBuilder(CBAdapter); CBCmdBuilderSplit = new OleDbCommandBuilder(CBAdapterSplit); // Bind CM to Parent Datagrid cm = (CurrencyManager)this.BindingContext[DGCashBook.DataSource]; ((DataView)cm.List).AllowNew = false; // Bind CM2 to Child Datagrid cm2 = (CurrencyManager)this.BindingContext[this.DGCashBookSplit.DataSource, this.DGCashBookSplit.DataMember]; ((DataView)cm2.List).AllowNew = false; // tried navigate navigate handler for both datagrids but still does not work this.DGCashBook.Navigate += new NavigateEventHandler(DGCashBook_Navigate); CBConnect.Close(); Tag: Export datagrid to excel and access Tag: 80029
  - 14
    - Refresh current form to reflect culture change Hi everybody, I want to add localization support into my windows forms application. Basically, I create a menu item where users can choose a language of their choice. When users choose their preferred language, I want to update all the texts/labels on the current form UI to the new culture, instantaneously. For this, I have created a .resx file for each supported culture and in the event handlers for menu item's Click event, I change the CurrentUICulture property to the corresponding culture as follow: System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en-US"); However, when the program runs, nothing happens. So, I guess I must somehow force the form to reload itself. I've tried all the methods like Form.Update(), Form.Refresh(), Form.Invalidate(), ... but unsuccessful so far. Does anybody know the solution to this scenario ? Thanks a lot SuperKinhLuan Tag: Export datagrid to excel and access Tag: 80028
  - 15
    - Is Any person know how to set a hotkey for command button? Dear all, I have no idea to set a hot key for the command button in my VB window application program. Do any person know how to do it? Thank you miyakejess Tag: Export datagrid to excel and access Tag: 80025
  - 16
    - Get system currently selected text Hi all, I'm facing a problem with my Windows Forms app. When my main Form is activated, I want to capture the currently selected text from any other programs (Word, IE, Notepad, ...) for further processing. How could I do that ? I guess I have to rely on P/Invoke, but no idea how to do it. Anybody can help me ? Thanks in advance Dotnetjunky Tag: Export datagrid to excel and access Tag: 80021
  - 17
    - Panel controls autoscroll not working I have been having problems with a panel control since installing Windows XP SP2 and .Net framework 1.1 sp1. I have several forms in an application which contains several panels. One of the panels contains a panel which has controls added to it at runtime with the autoscroll property set to true. Some of the controls added are outside the visible range of the panel. Before the service packs the panel would have a scroll bar. Also when a child control outside of the visible range gained focus, the panel would autoscroll so that the control was visible. After the service packs, the panel scroll bar will not show up for controls added during runtime. If I add a control at design time outside the visible range of the panel, the scroll bar will appear. However, when the control gains focus the panel autoscroll position go to 0 instead of what is necessary to keep the active control in view. Has anyone had similar problems and/or know how to fix this problem? Thank you in advance. Tag: Export datagrid to excel and access Tag: 80011
  - 18
    - Input Box This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C4C320.A00B4740 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 C# has MessageBox which is convenient to use. Does C# has Input Box? = Even though it's easy to create, if there is one in C#, why shouldn't I = use it. Thanks, Dennis ------=_NextPart_000_0006_01C4C320.A00B4740 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>Hi, </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>C# has MessageBox which is convenient to use. Does = C# has=20 Input Box? Even though it's easy to create, if there is one in C#,=20 why shouldn't I use it.</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Thanks,</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Dennis</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C4C320.A00B4740-- Tag: Export datagrid to excel and access Tag: 80010
  - 19
    - MDI scroll bars appear onresize around mdichild Hello, I have an MDI form with a child form that opens on load window state set normal on MDI. I want resize the child on the MDI onresize event. I run the app (form) then drag an edge of the MDI larger than its start up size and scroll bars appear arround the mdichild that is resizing with it. If the MDI window state is set to maximize this does not occur. What am I missing? Seems like a simple thinhg to do. Private Sub f_main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'MDI not maximized Dim f As New f_menu f.Width = Me.Width - 50 f.Height = Me.Height - 50 f.MdiParent = Me f.Show() End Sub Protected Overrides Sub OnResize(ByVal e As System.EventArgs) If Me.MdiChildren.Length > 0 Then Dim f As Form f = Me.ActiveMdiChild f.Width = Me.Width - 50 f.Height = Me.Height - 50 End If End Sub Thanks for looking... Brian Tag: Export datagrid to excel and access Tag: 80008
  - 20
    - Inherit ListView Column Header Hi All, I have been looking at this for a little while now and can't figure it out. I was hoping someone could help. I needed to have an aditional property for the ColumnHeader object contained in the ListView Columns collection. I needed this property to map ListView columns to DataTable columns for a suedo databinding function. I though perhaps inherit from the listview and ColumnHeader objects. Here are the steps and code: STEP 1: Create a ColumnHeader object that inherits from ColumnHeader with the additional property Public Class DataBoundColumnHeader Inherits ColumnHeader Private m_BoundColumn As String 'new property Public Sub New() MyBase.New() End Sub <Category("Data")> _ Public Property BoundColumn() As String Get Return Me.m_BoundColumn End Get Set(ByVal Value As String) Me.m_BoundColumn = Value End Set End Property End Class STEP 2: Create a ColumnHeaderCollection object that inherits from ColumnHeaderCollection and shadows functions which assign and retrieve my custom DataBoundColumnHeader object Public Class DataBoundColumnHeaderCollection Inherits ListView.ColumnHeaderCollection Public Sub New(ByVal Owner As ListView) MyBase.New(Owner) End Sub Default Public Shadows ReadOnly Property Item(ByVal Index As Integer) As DataBoundColumnHeader Get Return CType(MyBase.Item(Index), DataBoundColumnHeader) End Get End Property Public Shadows Function Add(ByVal Column As DataBoundColumnHeader) As Integer Return MyBase.Add(Column) End Function Public Shadows Function Add(ByVal Text As String, ByVal width As Integer, _ ByVal TextAlign As HorizontalAlignment) As DataBoundColumnHeader Return CType(MyBase.Add(Text, width, TextAlign), DataBoundColumnHeader) End Function 'This should be public: but a conversion type error occurs Private Shadows Sub AddRange(ByVal Values() As DataBoundColumnHeader) MyBase.AddRange(Values) End Sub End Class STEP 3: Create a ListView object that inherits from ListView shadowing the Columns property to accept my ColumnHeaderCollection Public Class DataBoundListView Inherits System.Windows.Forms.ListView Private m_DataBoundColumns As New DataBoundColumnHeaderCollection(Me) <Category("Behavior"), _ DesignerSerializationVisibility(DesignerSerializationVisibility.Content)> _ Public Shadows ReadOnly Property Columns() As DataBoundColumnHeaderCollection Get Return m_DataBoundColumns End Get End Property End Class THE PROBLEM: PROBLEM 1: This will not work unless the shadowed function AddRange is private and not public: The error is a typeconversion error PROBLEM 2: When I add the DataBoundListViewControl to a form and add some columns I get the following automatically generated code: 'Notice the System.Windows.Forms.ColumnHeader object Me.DataBoundListView1.Columns.AddRange(New System.Windows.Forms.ColumnHeader() {Me.DataBoundColumnHeader9, Me.DataBoundColumnHeader10}) Me.DataBoundListView1.Location = New System.Drawing.Point(72, 104) Me.DataBoundListView1.Name = "DataBoundListView1" Me.DataBoundListView1.TabIndex = 0 Me.DataBoundListView1.View = System.Windows.Forms.View.Details The automatic code generator creates an array of new ColumnHeader objects but assigns DataBoundColumnHeader ojects to items in that array. This is a little confusing. I really prefer it creates an array of DataBoundColumnHeader objects and then I could make my Private AddRange, Public. Thanks in advance, Demetrio Tag: Export datagrid to excel and access Tag: 80007
  - 21
    - tablet input devices Does .NET SDK have support for tablet input devices, like Wacom? Handling of pen pressure? Thanks, - Jim Robertson Tag: Export datagrid to excel and access Tag: 80006
  - 22
    - Disappearing Window in Word Addin I am developing an addin for Word using C#. When the addin is activated, an always-on-top window is created with which the user interacts while editing a document. Sometimes, this window disappears. That is, you can no longer see the window, but it still exists. I have checked this through the debugger. The Visible property is still set to true, the size does not change, etc, but you can no longer see/interact with the window. The window disappears after closing a MessageBox that was created by the addin, but not always in the same place. This behavior occurs on Windows 2000 or Windows 2000 Server systems with Office 2000 installed. It does not occur on Windows 2000 or Windows XP systems with Office 2003 installed. Does this behavior sound familiar to anyone? Any help would be greatly appreciated. Tag: Export datagrid to excel and access Tag: 80005
  - 23
    - create chart? How to make advanced charts in vb.net which tool to use to draw charts using data from sql server 2000. Chart in Crystal reports are not good they don't have enough features for my use. Any better control or something better? thx -- ----------------------------------------------------------------------------------------------------------------------- Dzemal Tipura (Dzemo) - MCP Tag: Export datagrid to excel and access Tag: 80000
  - 24
    - Beginner's question about binding textboxes and adding records I've created an extremly simple form for testing. I want to add records using bound textboxes. I've created a connection by dragging a SQLdataAdapter on to the form and using the Wizard with no special conditions. (Just select * from a single table.) I've bound a few textboxes to the fields (4 boxes and a DateTimePicker to be exact). I fill the dataset on form load and I know I'm getting data then. My problem is this: Nothing I do will create a new row. I'm trying to add a record with what I thought were the usual means. Me.BindingContext(Me.DataSet31, "OrderH").EndCurrentEdit() Me.BindingContext(Me.DataSet31, "OrderH").AddNew() (The number of rows in the table does not increase and when I go to the Update call there is no row with DataRowState = Added.) What am I forgetting? Tag: Export datagrid to excel and access Tag: 79998
  - 25
    - Swapping controls in windows forms Hello, Quite a simple one, however I don't know where to start. In my form I have a treeview, splitter and some free space on the right of my windows form. Depending on which node in the tree is clicked I need to show different things. i.e. either a list view, another form, text boxes etc... Can anyone suggest the best way of achieving this? Thanks in advance Tag: Export datagrid to excel and access Tag: 79997
- Next
  - 1
    - vpn credentials we have a c# windows application that grabs a users netowork credentails. we now need to allow users to run the application over VPN (on non domain machines) we have given the users domain accounts for the VPN. I need to grab the VPN credentials rather than the machines credentials. Thoughts? thanks, Kevin Tag: Export datagrid to excel and access Tag: 79996
  - 2
    - Newbie datagrid help I am using the following code to update my datagrid in a win form that is the front end to an Access DB. Me.BindingContext(School11, "Student").AddNew() OleDbDataAdapter1.Update(School11) My question is how do I have the datagrid select the new record after it updates? Tag: Export datagrid to excel and access Tag: 79991
  - 3
    - Forms designer load error. I added my own property (a double) to a derived component which can be edited in the property browser and is serializable. When I enter a small number such as .00001, the code generated in InitializeComponent() looks like this: this.StartTime.Increment = 1E-05; This compiles and runs fine, but the forms designer barfs and won't open the form. If I change the initialization to this: this.StartTime.Increment = 1.0E-05; then the form is happy. The form designer doesn't seem to understand and exponent without a decimal point. Any ideas? Here's what I'm using to get/set the value. protected double increment = 1.0E-6;; ... [Category("Misc"), Description("Gets or sets the numeric control increment value."), DefaultValueAttribute(1.0E-6), DesignerSerializationVisibility(DesignerSerializationVisibility.Visible), TypeConverterAttribute(typeof(DoubleConverter))] override public object Increment { get { return increment; } set { increment = Convert.ToDouble(value); } } Tag: Export datagrid to excel and access Tag: 79989
  - 4
    - user authentication i have a menu program, that does the user login, then lets the user to click on a link and executes other programs. how can i pass the user information from the menu program to the newly created process? i really want to make the menu a stand alone program. thankx a lot. Tag: Export datagrid to excel and access Tag: 79987
  - 5
    - Help - XP Taskbar Grouping Causes Blank App Name Hi When My Application goes to the number of windows in xp that the user sets for tasbar grouping, the Identifacation in the taskbar goes blank (no name and no icon). I'm sure i've given the solution a project name and everything that it should be, am i missing something. Thanks. Tag: Export datagrid to excel and access Tag: 79984
  - 6
    - Having derived forms recognizing the docking property of objects in the base form I have a base form where I docked a panel control across the header to act as a custom menu/tool bar. If I were to dock another control in the base form to the left side, it would recognize the first panel docked on the header, and therefore the 2nd panel would stretch from the bottom of the form to bottom of the 1st panel (1st panel being the one docked to the top which stretches from the left to the right side of the form). Ok that all works as expected. now I remove the 2nd panel from the base form as it was just a test to see that the docking was working correctly. Now I build the project and go to a form that's derived from this base form and I dock a control to the left side of the form. Instead of this left-docked control stretching from the bottom of the header panel (which is part of the base form and docked on top) to the bottom of the form, it stretches all the way to the top of the form and overlays my custom header (which is part of the base form). Is there anyway to change this behavior for a control docking in a derived form and recognizing the docking of a control in the base form? Thanks. -- moondaddy@nospam.com Tag: Export datagrid to excel and access Tag: 79983
  - 7
    - Datagrid Border disappears The inital datagrid looks fine, but when I fill it the border turns white. Not sure what property is controlling the border color. Tag: Export datagrid to excel and access Tag: 79982
  - 8
    - How to change the backcolor of a MDI form I'm writing an app in vb.net 1.1 and need to change the backcolor of an MDI form. I saw in another posting in this user group which referred to a link <URL:http://vbaccelerator.com/article.asp?id=4306> which had a good example, however, it was in C# and I wasn't able to get through it. Can anyone refer a good vb example? Thanks. -- moondaddy@nospam.com Tag: Export datagrid to excel and access Tag: 79981
  - 9
    - VB.NET Application on File Share Cannot Be Updated I have a VB.NET application that I have deployed via UNC file share. Everything works fine after the users run the small MSI that sets the appropriate trust level for the URL. The problem I am running into, however, is that I cannot push updates out to the server. When I attempt to copy a newer version of an assembly, I get a File Sharing Violation error. What gives? I thought (and verified) that the EXE is downloaded and run in a local process on the user's machine? When I look in task manager on my machine, the application shows up (it does not on the server with the file share). I used ProcessExplorer on the server, and it seems that there are 3 references and 1 handle to each of the assemblies that comprise the application. Doesn't matter how many users are currently running the application. It always shows 3 references and 1 handle. Again, this makes no sense to me and my understanding of how NTD is supposed to work. Maybe my understanding is wrong? I have read everything I could find on deploying applications via file share, and I have not seen anything about problems copying updated assemblies out to the share. Any insight that anyone might have is greatly appreciated. I have some critical updates that I need to get moved out as soon as possible. Thanks, Ken Tag: Export datagrid to excel and access Tag: 79979
  - 10
    - numeric up down control - whidbey if I manually delete the value in the text box in a numeric up down control, the Value property does not change, and following this, programmatic changes to the Value property do not get reflected in the UI although the property does actually get set. Has anyone else experienced this problem? Can anyone give me any ideas as to how I can get around this. Or is it just a bug with Whidbey? Thanks Jag Tag: Export datagrid to excel and access Tag: 79977
  - 11
    - How to yield the primary thread to some other task? Hi, I'm trying to create a method on my windows form that starts a multi-threaded task, waits for it to finish, and then returns. To be more precise: the form has a LoadUrl() method. This method calls the Navigate() method on the form's embedded WebBrowser control, and then does a WaitOne() on a ManualResetEvent. This ManualResetEvent will be Set() from WebBrowser's DocumentComplete handler when loading is done. So, what happens is this: when Navigate() is called, the web browser starts the download in a secondary thread and returns, thus jumping to my WaitOne() call where I wait for it to finish. While downloading, the browser wants to update the UI, which has to be done from the primary thread. But no dice, the WaitOne() call is blocking it. Now, I must do some kind of Wait() on the primary thread because I want to return from the method only when the operation is complete. But, I somehow have to wait without blocking this thread. Is this possible? It seems that the windows form has a solution to this. How does the form manage this primary thread so it knows how to do BeginInvoke, for example? Do I need to use the message loop or something? Any hint is welcome. Thanks in advance! -- Boris Drajer <boris.drajer@do.not.s.p.a.m.micro-bs.com> Tag: Export datagrid to excel and access Tag: 79976
  - 12
    - DataGrids, Datasets and ListBoxes Hello, I have a windows.forms application in VB.NET which has a DataGrid. I started simple and so programmed the Grid to appear by Default when the application opened and show a default dataSet. Now that I have done this I want to extend the program's capabilities. Instead of one dataSet I have 6 ( dataSetxxx, dataSetyyy, etc) and a listbox with 6 items in( xxx, yyy, etc) I populated the Listbox by... me.listbox.items.add("xxx") and so on When the application opens I want to show a picture but when the user selects one of the options from the ListBox, the corresponding dataSet is shown in the DataGrid form. All the dataSets are in XML format. I'm pretty new to VB.NET and have tried all sorts of different ways of doing this without any success. Can anyone help? Can someone tell me how to make the cells in the dataSet readonly? Thanks in advance, James Tag: Export datagrid to excel and access Tag: 79973
  - 13
    - Vertical text in datagrid cell trying to display vertical text in a .Net winform datagrid cell.... anybody can help me ?? : User submitted from AEWNET (http://www.aewnet.com/) Tag: Export datagrid to excel and access Tag: 79972
  - 14
    - MDI Application Help I have an MDI VB.NET application. When I select forms from the mdi menu each child form opens further down and to the right on the screen than the previous one. It gets to the point where the forms look unprofessional and untidy and half of the information is off of the screen. How can I influence specifically where the child gets postioned when being opened from the menu? I don't just want to maximise the forms when opening. -- Thanks Bill Partridge Tag: Export datagrid to excel and access Tag: 79971
  - 15
    - Reading & Writing Pictures to sqlserver using vb .net I do not know that how to store a picture and then retrieve it from database i.e. sqlserver 2000, in vb .net. in vb 6.0 field.getchunk was used to read the picture what in vb .net thanks for ur help --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: Export datagrid to excel and access Tag: 79966
  - 16
    - New Forum Needs a Lift! We Need Programmers! This is a multi-part message in MIME format. ------=_NextPart_000_021A_01C4C2B2.1171BB90 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi everyone, www.webdesignmagic.com.au/forum.asp <BLOCKED::BLOCKED::BLOCKED::BLOCKED::http://www.webdesignmagic.com.au/fo rum.asp> I am trying to get a new Programming and Website Design forum in Australia up and running. I am looking for new members who may be able to help others in programming related issues and web site design issues. Please visit <BLOCKED::BLOCKED::BLOCKED::BLOCKED::http://www.webdesignmagic.com.au/fo rum.asp> www.webdesignmagic.com.au/forum.asp and introduce yourself or maybe see if someone needs help! I am not using this for marketing purposes, simply wish to repay the favours others have done for me when I needed help. Thanks Daren Hawes MCAD.NET, MCSD.NET --------- Web Design Magic Home of the "The Help Desk" Programming Forum. http://www.webdesignmagic.com.au/TheHelpDesk ------=_NextPart_000_021A_01C4C2B2.1171BB90 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD> <BODY> <DIV><FONT face=3DArial size=3D2> <DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3DArial size=3D2><SPAN=20 class=3D241442204-04112004>Hi everyone,</SPAN></FONT></DIV> <DIV> <DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D241442204-04112004></SPAN></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D241442204-04112004><A=20 href=3D"BLOCKED::BLOCKED::BLOCKED::BLOCKED::http://www.webdesignmagic.com= .au/forum.asp">www.webdesignmagic.com.au/forum.asp</A></SPAN></FONT></DIV= > <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D241442204-04112004></SPAN></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D241442204-04112004>I am = trying to get a=20 new Programming and Website Design forum in Australia up and=20 running.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D241442204-04112004></SPAN></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D241442204-04112004>I am = looking for new=20 members who may be able to help others in programming related issues and = web=20 site design issues.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D241442204-04112004></SPAN></FONT> </DIV> <DIV><SPAN class=3D241442204-04112004><FONT face=3DArial size=3D2>Please = visit=20 </FONT><A=20 href=3D"BLOCKED::BLOCKED::BLOCKED::BLOCKED::http://www.webdesignmagic.com= .au/forum.asp"><FONT=20 face=3DArial = size=3D2>www.webdesignmagic.com.au/forum.asp</FONT></A><FONT = face=3DArial=20 size=3D2> and introduce yourself or maybe see if someone needs=20 help!</FONT></SPAN></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D241442204-04112004></SPAN></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D241442204-04112004>I am = not using this=20 for marketing purposes, simply wish to repay the favours others have = done for me=20 when I needed help.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D241442204-04112004></SPAN></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D241442204-04112004>Thanks = Daren=20 Hawes</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN = class=3D241442204-04112004>MCAD.NET,=20  MCSD.NET</SPAN></FONT></DIV></DIV></DIV></DIV></FONT></DIV> <DIV align=3Dleft><FONT face=3DArial size=3D2>---------</FONT></DIV> <DIV align=3Dleft><FONT face=3DArial size=3D2>Web Design Magic<BR>Home = of the "The=20 Help Desk" Programming Forum.<BR><A=20 href=3D"http://www.webdesignmagic.com.au/TheHelpDesk">http://www.webdesig= nmagic.com.au/TheHelpDesk</A></FONT></DIV> <DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_021A_01C4C2B2.1171BB90-- Tag: Export datagrid to excel and access Tag: 79962
  - 17
    - AcceptButton closes Form on Failure Hi! I have an AcceptButton on my Form. With pressing this Button some checks are performed and only when they are all okay, then the Form should close. Can I set this up in some way? E.g. abort the Closing-Process of the Form... Thank U very much, Christian Tag: Export datagrid to excel and access Tag: 79955
  - 18
    - How to remove all rows in datagrid? This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C4C289.CB075520 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Do you know how to remove all rows in datagrid? datagrid.TableStyles.Clear() seem does not work to me. Thanks, Dennis ------=_NextPart_000_000A_01C4C289.CB075520 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2><FONT size=3D2> <P>Hi,</P> <P>Do you know h<FONT size=3D1>ow to remove all rows in datagrid?</P> <P></FONT>datagrid.TableStyles.Clear() seem does not work to me.</P> <P>Thanks,</P> <P>Dennis</P></FONT></FONT></DIV></BODY></HTML> ------=_NextPart_000_000A_01C4C289.CB075520-- Tag: Export datagrid to excel and access Tag: 79951
  - 19
    - Emailing from a Visual Studio.NET Application (Basic) I'm sending eMail messages from my Visual Basic.NET application. Creating a System.Web.Mail.MailMessage and sending it with SmtpMail.Send works fine, but I'd like to take it a step further and hook up with the correct Mail Server automatically, or, even better, deliver the message into the clientÂ´s actual eMail application so he can use his address book to select the recipient, etc. Can anyone point me in the right direction? At least as far as telling me how to get the name of the Mail Server, if any, that the user is hooked up with. As far as plugging into the Mail-client the user is using, perhaps that's a lot of bother since the different clients ,Outlook, Outlook Express, and (I shudder to mention it) Non-Microsoft mail clients may not accept the same type of Message-object. Still, I'd be grateful for any input. -- Gudmundur Karlsson Iceland Tag: Export datagrid to excel and access Tag: 79938
  - 20
    - Transparent Label I have a form that has a picture box with an image. I will also me placing labels on this form in front of the picture box. I want the picture to show through the labels. I would like the labels to be transparent. I have tried setting the background color of the label to transparent, but all it shows is the background color and you can not see the image behind it. Is there any way to do this? Thanks, -- Eric Renken Demiurge Software LLC http://www.demiurge.us Tag: Export datagrid to excel and access Tag: 79937
  - 21
    - problem printing on a roll paper OK After two month of development.. my App is ready.It is a client lotery system and it is going to be deployed in many places around the city.The App is going to use Tickets printers (I dont know the exact name) the problem is that there are a lot kind of printers, when I made the printing test with an EPSON TM-U200PD I notice that if I print a very long ticket, the printer stop at an specific page size... I want to print a Roll of information continue NO matter what I did configuring the page size it did not print continue I dont want to think the worst : I have to program an interface.. because there are so many types of printers where can I start to looking for the problem? Tag: Export datagrid to excel and access Tag: 79936
  - 22
    - MDI Form Click Event Detection Hi, I use Vb.Net with the Framework 1.1. I am coding a MDI form. I want to show a context menu when the user right-clicks in the gray area of the mdi form. The event MdiForm_Click doesn't fire. Why? Is there a workaround? Thanks, C. Tag: Export datagrid to excel and access Tag: 79933
  - 23
    - New Problem with Always on Top Thank you for you help with the Always on Top issue previously posted. It worked great. But, I have noticed that when I call a different form using "ShowDialog" that the clipboard is still on top but I cannot access it. Is there a way to make MyClipboard not effected by the other forms that are displayed using "ShowDialog". I am looking to copy information from Frm2.ShowDialog into MyClipboard and paste it into Frm3.ShowDialog from MyClipboard... Thanks. Chuck Tag: Export datagrid to excel and access Tag: 79930
  - 24
    - textbox maxlength Hi, I looked everywhere for a reference to this, and I'm surprised that no one else (apparently) has run into this problem. I am using a textBox to collect/display messages as they are created in my system. I append them to the current Text contents using the AppendText() method. I never had problems with this until I moved to studio 2003 with SP2. Now, no matter what I set my maxlength to (0, 500K, etc ...), the AppendText() stops working once the buffer size reaches 32k. I'm sure it has something to do with the SP2 patches related to overflowing buffers, but I have no idea how to fix this (I definitely want to be able to put more than 32k into the textbox) Any ideas ? thanks, mark Tag: Export datagrid to excel and access Tag: 79929
  - 25
    - Always on Top Hello, I am creating a clipboard that is always on top of my application. How can I make my form (MyClipboard) always on top?? Thanks, Chuck Tag: Export datagrid to excel and access Tag: 79923

Hi,

Does anyone know how to export a Windows forms datagrid to Access and excel.
I have a datagrid and want to click a button an export the data to excel and access.

Thanks

Top