Read Database and send send Data from VB.NET to Excel

Windows Forms Data Controls and Databinding

- Previous
  - 1
    - totally newbie question about deploying software I have a windows form application developed with .net 2.0 c#. I am using visual c# express If i use the clickonce deployment, i cant have a destop icon, have the user specify an installation directory, show an end user licence agreement, or make entries to the registry. But i need the functionality that the where it checks for the .net framework and downloads from vendor if not present. Does anyone have any suggestions, is there another installer tool that can be installed with visula c# express thanks Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 2
    - How-to Start .Net executable with parameters? You can always get the command line with Environment.CommandLine. But you can get them i you Main method as well: using System; class Sample { public static void Main( string [] args ) { foreach ( string arg in args ) { Console.WriteLine( "Argument: " + arg ); } } } When get it out of the args parameter in you main method, the parameters are nicelly splitted. Environment.CommandLine gives you the whole commandline and you need to split it yourself. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 3
    - Open Form, Close last form Bump, any help would be greatly appreciated Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 4
    - Results from a worker thread into main thread? The code is okay although the ISynchronizeInvoke cast is unnecessary. The most likely reason for this problem: it takes time for the call to be marshaled to the UI thread. By the time it is ready to execute, the NewDataSet instance is probably already cleared or disposed. Use the Clone() method to avoid this problem. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 5
    - MDIContainer inside another MDIContainer. You guessed right. You might want to review your UI design. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 6
    - TreeNodeCheckChanged and SelectedNodeChanged of TreeView dosen't fire TreeNodeCheckChanged and SelectedNodeChanged events of TreeView in ASP.NET 2 dosent fire when a chack is made or removed. Is there any fix Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 7
    - need help with Datagrid's Captiontext Sorry, I thought you were talking about Datagridview. Check the below link. http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridcolumnstyle.headertext(vs.71).aspx Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 8
    - ToolStripSplitButton ImageAlign TextAlign Is there a work around for the text alignment bug in ToolStripSplitButton To replicate, Create a toolstrip on a form Add a SplitButton Set button text to "Hello" Set the image. Set ImageAlign middle left Set TextAlign to middle right Set AutoSize to false Set Width to something such as 150 Run and text is NOT aligned left, but instead looks ugly crammed up against the image. Thanks Mark Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 9
    - how to save datagrid into a file? check this link Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 10
    - help with BackGroundWorker Try isolating the usage of the member variable m_db by locking it before every usage in each thread such as Code Snippet // Use the actual object to do the lock or create a new object to lock. // or create a member variable object such as object _sync = new object(); // the lock that such as lock(_sync); lock (m_db) { m_db.Add .... } That way you can remove any possible threading issues Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 11
    - Regarding collection of cells in a single column hi how we can get collection of all cells in a particular datagridviewcheckbox column It seems there is no function exists like that. So how can we get the collection of all cells Thanks, Santhosh. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 12
    - Windows Installer condition :Microsoft Visual Basic 2005 Hello, Thanks for the replies, I am indeed using RemovePreviousVersions which would explain the removal then reinstalling of the DBs. What I should point out is that the first version of this application went out with no conditions (lets call it Version1.0.0); on the DB files and this build I am installing is an update (lets call this Version 1.0.1). If I install 1.0.1 over 1.0.0 the DB modifications are lost from the first install, am I right in assuming this is because when installed, 1.0.0 had no condition flags set on the DBs If I build a 1.0.2 and install that over 1.0.1 then the databases are left in tact, Im assuming this is because both versions in this case have the "Not Installed" condition set. And finally, for the elite guru I have a last note: Using 5 separate PCs in a test environment, different Dell models but same build; Windows XP SP2, .Net 2.0 (including my machine that I build the project on). My machine and another will leave the DBs intact installing from 1.0.0 to 1.0.1 yet all the rest will uninstall the DBs and then install the blank ones. Again any help would be appreciated Phil Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 13
    - Delete Hi hrubesh, Thank you. You are right. When working with data relations, this method won’t work. But we can get all the Foreign Keys using the following statement Code Snippet select a . name as constraint_name , a . parent_obj , b . name as parent_table_name from sysobjects a join sysobjects b on a . parent_obj = b . id where a . type = ' F ' Delete the foreign key constraint first. Code Snippet alter table [table_name] drop constraint [contraint_name] Then delete all tables. Best regards. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 14
    - foreach(Form f in AllformsOfApplication) I knew the first answer was the way to go, but since I'm not really the expert I searched on the forum and found this: List<Form> allForms = new List<Form>(); Assembly asm = Assembly.GetExecutingAssembly(); foreach (Type t in asm.GetTypes()) { if(t is Form) { allForms.add(t); } } I've been fighting with it all afternoon, but I won't work. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 15
    - Error: Access denied I have a client, who is trying to install our click once application and when they hit .application page they are getting access denied. Does any one know why would they get access denied I asked them to check if the firewall is blocking and they told me there is no filters in the firewall server. I checked the trusted sites and my site is there as a trusted site. I am unable reproduce the problem at my end. In the publish.htm, when they hit setup.exe, it does launch and installs the pre-requisites correcly. But when it launches the .application thats when they are gettting this error. Thanks. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 16
    - dual core processors I am building a real time data processing application consisting of two main processes, and I'm having trouble getting things to run fast enough. I believe that if the processes always ran on seperate processors of the dual core processor, the system will run fast enough. How can I guarantee that the processes will always load and execute in seperate processor cores Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
- Next
  - 1
    - create multi child froms in multithread i tried to Invoke a method in the main form that creates a child form from a separate thread. and it does not work can any one help me by a demo code Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 2
    - Datagridview dynamically added cell contents removed after sorting Do the assignment work in cellFormatting event, then it won't disappear when sorting. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace Samples { public partial class DgvImageCol : Form { public DgvImageCol() { InitializeComponent(); } private void DgvImageCol_Load( object sender, EventArgs e) { DataSet bitmapSet = new DataSet (); bitmapSet.ReadXml( "bitmaps.xml" ); dataGridView1.DataSource = bitmapSet; dataGridView1.DataMember = "bitmap" ; DataGridViewImageColumn bitmapColumn = new DataGridViewImageColumn (); bitmapColumn.Name = "bitmapColumn" ; bitmapColumn.HeaderText = "Bitmap" ; dataGridView1.Columns.Add(bitmapColumn); dataGridView1.Columns.Add( "widthColumn" , "Width" ); dataGridView1.Columns.Add( "heightColumn" , "Height" ); } private void dataGridView1_CellFormatting( object sender, DataGridViewCellFormattingEventArgs e) { if (e.RowIndex >= 0 && e.RowIndex < this .dataGridView1.Rows.Count-1) { Image img = Image .FromFile( this .dataGridView1.Rows[e.RowIndex].Cells[ "Filename" ].Value.ToString()); if (e.ColumnIndex == 1) //the image column's index { e.Value = img; } if (e.ColumnIndex == 2) { e.Value = img.Width; } if (e.ColumnIndex == 3) { e.Value = img.Height; } } } } } Hope it helps. Regards,. Ye Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 3
    - Caret in text box focus Hi, I tried it in a quick test form I knocked up quickly and it worked perfectly, but on the actual form on the project I'm working on, it doesn't work at all - I'll have to investigate further. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 4
    - Losing DataGridView style Hi. Yesterday, timvw helped me to remove specific selected columns from a custom DataGridView which worked great (see here ). The form in question has two Combo Boxes and a DataGridView (which is programmed to set specific cell styles and to handle a Transposed DataSet/DataTable from a SQL server database (so the columns have to be added manually - limited to just over 65,000 columns instead of the normal limit of 655 columns). When I close the form, everything is fine. My routine which reads the columns and converts them back into the correct SQL storage statement, performs correctly (does not use the DataSet/DataTable in this instance). However, I realised I need to adjust the DataSet/DataTable too because if I wanted to browse to another table in the DataSet and come back again, I was going to lose all the changes I made because the DataSet wasn't updated. I added the extra line of code to remove the columns from the DataSet/DataTable also and thought it would be OK, but the DataGridView is resetting the display to the plain DataGridView, thus losing all my programmed formatting! Is there a way to stop the DataGridView losing the formatting when the DataSet is modified The DataSet/Table is the DataSource in this case. Thanks in advance. Sean Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 5
    - Save in treeView1, Load from treeView1 Hi, Actually, in such a case, you don't need to generate xml file. Just plain text file (*.txt) can do. Well, I know you are beginner, so the example follows: To save text in a file example(use StreamWriter ): Code Snippet using (StreamWriter sw = new StreamWriter(@"D:\Results.txt")) { sw.WriteLine("whatever you want it to be"); } In this way, you can save the result. To get the results into tree view example: Code Snippet using (StreamReader sr = new StreamReader(@"D:\Results.txt")) { treeView1.Nodes.Add(sr.ReadLine()); } These example can do the function, and more you must do the logical work yourself, since that is your design. Good luck! Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 6
    - Timer problem I have the timer properties as enabled = true, when I load the form I set it to enabled = false, later on in the form the timer is enabled = true but it never works. I have tried timer.Start but it never hits the timer_Tick event. I want the timer_Tick event to work when I am running another method Is that possible Any one got a clue why the timer isn't working Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 7
    - Working with windows forms activation event? Here I am working with windows forms and i have written a code in windows form activation event like shown in below. Private Sub frmSelectEmp_Activated( ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase .Activated Dim IntResponse As Short If lstEmp.Items.Count = 0 Then IntResponse = MsgBox( "No Emps, list will close" ) Me .Close() End If End Sub Here when I run this form iam getting this form and it is giving the messagebox and when i click Ok button on that messagebox everytime pointer is going to the Form activation event so that it is always giving the messagebox . Here my intention is when i click on the OK button on the Messagebox i need to close that dialog window( frmSelectEmp). please Check this code and give the solution. Thanks' Sudhakar.V Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 8
    - Programmatically display a balloon tooltip. Hello again, Now I have another issue... The code you provide in your answer display the tooltip positioned by the top-left corner of the balloon. Is there any way to position it by the balloon pointer I saw that I can get the balloon dimensions in the popup event, but I can't determine the orientation of the balloon neither reposition it based on the tooltip size. Any ideas and/or suggestions are again very welcomed !!! Cheers, Rodrigo. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 9
    - Error Datagridview binding with Date Hi all. My problem is I'm having a datagridview that bind to table that has date format field. I have manage to show the correct date, but when I edit or add new row, each time i leave the date column, it give error. The error is because my current culture set short date with "MM-dd-yyyy", so i have to input the date like it. But for showing i use e.Value = CDate(e.Value).ToString("dd-MM-yyyy") so datagridview show the data like it. I want to make the input is also accept the "dd-MM-yyyy" format, and don't have to change the control panel regional setting. How could I do that. I try to use this code on Initialize the form: Code Snippet Dim dfi As DateTimeFormatInfo = New CultureInfo("en-US", False).DateTimeFormat dfi.ShortDatePattern = "dd-MM-yyyy" Thread.CurrentThread.CurrentCulture.DateTimeFormat = dfi It give error: Instance is read-only. on Thread.CurrentThread.CurrentCulture.DateTimeFormat = dfi Any Suggestion Thank you Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 10
    - Printing and multithreading problem And I forgot to say that these are all small documents (1 to 2 pages). Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 11
    - change Usercontrol's behaviour to get full view After more research on this, I figure out a better approach, which is to host the MonthCalendar control into a ToolStripControlHost object, then add the ToolStripControlHost object into the Items collection of a ToolStripDropDown . So, the sample code would be something like this: Code Snippet public partial class ZhixinYeCalendarControl : UserControl { public ZhixinYeCalendarControl() { InitializeComponent(); this .Load += new EventHandler (CalendarControl_Load); } private bool canDropDown; private TextBox textBox1; private Button button1; private MonthCalendar calendar; ToolStripDropDown popup; void CalendarControl_Load( object sender, EventArgs e) { this .canDropDown = true ; this .calendar = new MonthCalendar (); this .calendar.DateSelected += new DateRangeEventHandler (calendar_DateSelected); popup = new ToolStripDropDown (); popup.Margin = Padding .Empty; popup.Padding = Padding .Empty; ToolStripControlHost host = new ToolStripControlHost ( this .calendar); host.Margin = Padding .Empty; host.Padding = Padding .Empty; popup.Items.Add(host); this .Width = this .calendar.Width; this .Height = 21; this .textBox1 = new TextBox (); this .textBox1.Left = 0; this .textBox1.Top = 0; this .textBox1.Width = this .Width - 20; this .textBox1.Height = 21; this .textBox1.Text = DateTime .Today.ToString(); this .Controls.Add( this .textBox1); this .button1 = new Button (); this .button1.Left = this .textBox1.Width; this .button1.Top = 0; this .button1.Width = 20; this .button1.Height = 21; this .button1.Paint += new PaintEventHandler (button1_Paint); this .button1.Click += new EventHandler (button1_Click); this .Controls.Add( this .button1); } void calendar_DateSelected( object sender, DateRangeEventArgs e) { this .textBox1.Text = e.Start.ToString(); this .canDropDown = true ; this .popup.Hide(); } void button1_Paint( object sender, PaintEventArgs e) { ControlPaint .DrawComboButton(e.Graphics, this .button1.ClientRectangle, ButtonState .Normal); } private void button1_Click( object sender, EventArgs e) { if (canDropDown) { Point location; location = this .Parent.PointToScreen( this .Location); location = this .FindForm().PointToClient(location); location.Y = location.Y + this .Height; this .popup.Show( this .FindForm(),location); } else { this .popup.Hide(); } canDropDown = !canDropDown; } } Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 12
    - Suddenly I'm getting this error: The form referred to itself during construction from a default instance From the exception message it seems as if you (in the constructor itself) create an instance of the form or call the constructor over and over again. Is that happening. If so, remove that part and use "Me" to reference to the current instance of the form. Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 13
    - Deploying/Publishing my VB express application issue Hi I get pretty confusing about what the Publish button do to my application. After looking thru the deploy-related posts on this forum I managed to publish my application with MS Installer and .net framework 2.0 buddled on a CD-ROM/DVD. The project in my case is deployed to C:\myProject Now there are folllowing filess in the myProject folder: myProject_1_0_0_1 [folder] --- inside has the xyz.dll.deploy , myProject.exe.deply and database.mdb.deploy <-- how come they are end with .deploy dotnetfx windowinstaller3_1 autorun.inf myProject.application myProject_1_0_0_1.application Copy of myProject.xml setup.exe I logically ran setup.exe and expect my application will get installed on my PC (same pc I use to develop software so it has already .net framework 2.0 ). Looks nice , and it execute my program after installation was completed. But, I wanna see where is my exe , dll and mdb is isntalled to........... when I go to "Start"->"Programe files"-> myProject , I see there is a shortcut to my project , frankly, that shortcut points to my deployment folder which is C:\myProject !!: Content of the shortcut: file:///C:/myProject/deploy/myProject.application#myProject.application , Culture=en-AU, PublicKeyToken=d65fc15b2749af0a, processorArchitecture=msil Confusing enough, I go and delete what is in C:\myProject and click on that shortcut icon again.... my program runs without problem. Where is my program installed to Thanks Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 14
    - Char-toggled checkbox? Bob and Zhixin, Great...thanks for the most helpful sample code. This is exactly what I need to do and it will help a lot. Cheers, Sturdy Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 15
    - MessageBox enter key activates form controls. Can you process KeyDown event in the TextBoxes instead of KeyUp event to make it act as a Tab I think that will solve the problem... Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms
  - 16
    - Need help hilighting the correct row on the datagridview control. You can use a Tag to note the dragged row, set it to be selected. Something like this: Code Snippet public partial class Form2 : Form { public Form2() { InitializeComponent(); } private void Form2_Load( object sender, EventArgs e) { this .dataGridView1.Columns.Add( "c1" , "c1" ); DataGridViewRow dr = new DataGridViewRow (); dr.CreateCells( this .dataGridView1, "aa" ); this .dataGridView1.Rows.Add(dr); DataGridViewRow dr1 = new DataGridViewRow (); dr1.CreateCells( this .dataGridView1, "cc" ); dr1.Tag = "dragged" ; this .dataGridView1.Rows.Add(dr1); DataGridViewRow dr2 = new DataGridViewRow (); dr2.CreateCells( this .dataGridView1, "bb" ); this .dataGridView1.Rows.Add(dr2); this .dataGridView1[0, 0].Selected = false ; } private void button1_Click( object sender, EventArgs e) { foreach ( DataGridViewRow row in this .dataGridView1.Rows) { if (row.Tag != null && row.Tag.ToString() == "dragged" ) { row.Selected = true ; } } } } Tag: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel Windows Forms

nbk5533

I have a VB.Net application setup to pull Data from a Database using checkboxes. i.e. the user would select the checkboxes and it will read the Data from the Database. Question is, how do I store all of this data, and then export the columns of data it into Excel spreadsheet

Thanks,

Wallace

Top

Re: Windows Forms Data Controls and Databinding Read Database and send send Data from VB.NET to Excel

Gavin Jin - MSFT

Hi，I am not quite clear your first question.But to your second question,I have some articles can help you.

http://www.codeproject.com/office/excel_using_oledb.asp

This article shows how to export GridView to Excel, render cells, add WordArt, and fill a custom template .

http://www.codeproject.com/office/XML_in_Excel.asp

Hope it helps

Regards

Top