Import Excel file into dataGridView

Windows Forms General

- Previous
  - 1
    - form closing event and override question First a simple question, form closing override doesn't provide the CloseReason, but the Form_Closing event does - so is there a way to get close reason from the override Next question. I have a multithreaded application where my form is the GUI view of a certain backing object. The backing object exists on another thread and fires events to the form when it's changed so the form can display the new information. The form's event handlers must Invoke methods on the form since the form must modify itself and its InvokeRequired property is true in the event handlers, since those events are fired from the backing object's thread. The problem I'm having is that while I'm in the Form_Closing event handler, none of my Invokes are able to use the UI thread (because that thread is in the Closing handler). So it becomes very difficult to do anything which requires a recalculation of the backing object (which fires events which my form tries to handle). I want to be able to do this in order to check whether the backing object has changed, to prompt the user to save changes etc. The seemingly very simple way to handle this is to always cancel the form closing event, store the CloseReason, request an asynchronous recalculation of the backing object, and get a callback when that's complete. In that callback, I can do the real form_closing logic while I'm guaranteed that the backing object is fully ready. But this would force me to replicate all the CloseReasons in that callback method - in other words, if the system was shutting down, I'd have to shut down the system in code. If the ap was shutting down, I'd have to shut the ap down in that code. Etc. My question is, is this something to be undertaken lightly, or should I endeavor to just find a way to do what I need to do within the Form_Closing event handler I am hesitant to be shutting down the system in my own code. Thanks. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 2
    - Listview Get Subitem At Mouse Position Hi, I want to click on a listview item's subitem and change the subitem's backColor. There unfortunately is no listview.getSubitemAt() method. Here is my current code. Please advise. Thanks Code Snippet Private Sub lstSchedule_MouseDown( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles lstSchedule.MouseDown Dim item As ListViewItem = lstSchedule.GetItemAt(5, e.Y) End Sub I have the clicked item, but how to I get the exact subitem Thanks. Mike Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 3
    - Can't update database from datagrid Hi All; Can't insert into database from dataGridView in my winFormApp with C# can i get help thanks in advanced for fast response. waeldief@msn.com Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 4
    - C# 2003 - Windows Forms Events I am currently developing a windows application using C# .NET 2003. I have a form that contains a DataGrid of the Requests that have been entered into the application. When this datagrid has data there is a button that the user can click that will bring up a form (in front of the DataGrid form) to allow the user to assign the request to another user. When they have closed out of the form that allows them to assign the task to another user I want to refresh the DataGrid. I have tried the Enter event of the Form, but this does not get fired when I close the other form. When the assign form is closed it looks as though the Assign button on the DataGrid form has focus. I tried using the Enter event of the button, but this didn't work either. What event would fire on the DataGrid Form that I can use to refresh the grid Thanks in advance for your help. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 5
    - VS2005 Setup & Deployment Projects cannot build. Hello. I created vc++ windows service project then added setup & deployment project to solution. Set primary output setting on setup project. VS2005 compiled service project succesfully and then tried to compile setup project. It cannot build setup project. Output message is: "Error: Operation could not be completed. Boyle bir arabirim desteklenmiyor." Last sentence is turkish. It means "Interface is not supporting". Windows XP Pro SP2 Turkish Visual Studio 2005 Standard .NET Framework 2.0, 3.0 installed Windows Installer 3.1 installed Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 6
    - TableAdapter Problem. I am using VB.Net 2005, my windows application bind to two data tables which is member(memberId, name, phone, joinDate) and payment(paymentId, memberId, year). I need to implement the following SQL into tableadapter: SELECT memberId, joinDate, phone, name, FROM member WHERE (joinDate > ) AND (NOT EXISTS (SELECT 1 AS Expr1 FROM payment WHERE (humanId = member.memberId) AND ([year] LIKE ))) But when I finish created the tableadapter, it only accept one parameter, FillByFee,GetDataByFee(joinDate) What’s wrong What should I do How to create an tableAdapter that can accept two parameter Thank you very much! Best regards, Yee Boon Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 7
    - Half transparent d'n'd icons - how are they made? In my Win XP when I drag an icon on desktop, I have a half transparent icon under my cursor. How exactly is that made I know that is a hassle to make some half transparent components, sow is that made It s a cool feature to include it to an application. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 8
    - Form troubles-open child from parent form.. Hi, I have two forms and I'm loading one of the forms as a default. What I want to do is, in some event of the first form(parent), I want to open the second form(child) and close the parent form. I thought I could use the following code, Form1 parent = new Form1(); parent.Show(); this.Close(); Closing the parent will close the child also. Any idea on how I go about this. Thanx for any help. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 9
    - Quick DataGridView Question Is there a way to have multi leveled rows Cell 1 Cell2 Tom Jackson Cell 3 Cell4 12 .92 Cell 1 Cell2 Scott Blaine Cell 3 Cell4 13 .90 Cell 1 Cell2 Harry Jones Cell 3 Cell4 14 .95 Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 10
    - How to add DirectX 9 as prerequisite to GenerateBootstrapper msbuild task? How do I add DirectX 9 as prerequisite to the GenerateBootstrapper msbuild task All those tutorials on ClickOnce mention it is possible, but none show how. Wout Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 11
    - Custom UserControl's Property Window Hi all, I am creating a custom user control (inherited from System.Windows.Forms.UserControl) and I want to allow users to modify its properties from the designer view. I've provided public properties and so far they appear in the property window. However, I also need to support these two behaviors below: 1. When any of the custom control's properties is selected in the property window, the property's documentation must appear at the property window's bottom part, like what happens when the properties inherited from UserControl are selected. 2. Some of the custom control's properties are classes or structs. I need to be able to show an expandable item in the property window to allow the user to set the properties of these classes/structs. Currently, classes and structs properties appear on the propery window (with only their names appearing on the value cell) but are disabled. Do you guys have any idea on how to do it I hope I defined my problem clearly. Thank you very much. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 12
    - Reading from a csv or a txt file in Unicode format Hello there I have written a small code that is used to read records from a txt or a csv file, but when i try to read from a txt or csv file which is in unicode, i get the following error No value given for one or more required parameters........this error is recieved on the following line dtadpt.Fill(DataSet.Tables( "table2" )) The code for reading from a file is as follows Dim dtrow As DataRow Dim cmdtxt, file, fs, path Dim dtadpt As New System.Data.OleDb.OleDbDataAdapter Dim AccessCommand As System.Data.OleDb.OleDbCommand Dim AccessConn As System.Data.OleDb.OleDbConnection fs = CreateObject( "scripting.filesystemobject" ) file = fs.getfilename(TextBox1.Text) path = fs.getparentfoldername(TextBox1.Text) AccessConn = New System.Data.OleDb.OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & path & ";" & "Extended Properties=""text;HDR=YES;FMT=Delimited""" ) For Each dtrow In DataSet.Tables( "table1" ).Rows Dim id id = dtrow.Item( "id" ) cmdtxt = "Select * from " & file & " where id = " & id AccessCommand = New System.Data.OleDb.OleDbCommand(cmdtxt, AccessConn) dtadpt.SelectCommand = AccessCommand Next DataSet.Tables.Add( "table2" ) dtadpt.Fill(DataSet.Tables( "table2" )) this code works if i choose a a csv or txtfile which is in ANSI format. But i want to read from a unicode file because i have some information in that unicode format that i want to store any idea how this can be possible Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 13
    - two datagridviewcombobox columns in datagridview two datagridviewcombobox columns in datagridview, let's say one is called Code, the other is called SubCode, after Code is selected, I will have SubCode datasource to be filtered based on Code. The problem is if I select a different Code in 2nd datagridview row, because the SubCode in 1st datagridview row is not in the items of new filtered SubCode datasource, I will get an DatagridviewCell error message, and SubCode in 1st datagridview row will disappear. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 14
    - About Box Show Im working on a simple notepad for my friend how do I show an aboutbox in C# that is allready designed in a button click event Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 15
    - DataGridView Custom Columns. Hi, I am trying to implement a custom control that can exist in a DGV cell. I had the control already working at many places in my UI but its the DGV part thats tricky and difficult ..... Custom Control: A combo box that shows a mapped version of database values. So the database column would have B and S and the combo box would display to the user "BUY" and "SELL". It would display BUY or SELL depending whether the database has B or S resp. And when the user changes the value in the combobox its again changed back to the correct coding scheme before being stored. This combo box as independent control in a UI works perfect. Implementation: I create a custom class inherit from combo box and create a BINDABLE property called DBBoundTag and bind it to whatever column. depending on what the user selects i format the value and then set a variable in the control class. Lets say user selected "BUY" i will set variable to "B". When the underlying list wants to see the updated value it accesses the DBBoundTag property and its Get mothod returns "B" so the property so the correct thing gets stored in the database. DGV Implementation ---------------------------- This is where it gets tricky.. I don't set the datapropertyname of the column through the designer. Code Snippet Imports System.ComponentModel Imports System Imports System.Windows.Forms Public Class CustomComboBoxColumn Inherits DataGridViewColumn Public Sub New () MyBase .New( New CustomComboBoxCell()) End Sub Public Overrides Property CellTemplate() As DataGridViewCell Get Return MyBase .CellTemplate End Get Set ( ByVal value As DataGridViewCell) ' Ensure that the cell used for the template is a CalendarCell. If Not (value Is Nothing ) AndAlso _ Not value.GetType().IsAssignableFrom( GetType ( CustomComboBoxCell))_ Then Throw New InvalidCastException( "Must be a Combo Box Cell." ) End If MyBase .CellTemplate = value End Set End Property End Class Cell Class Code Snippet 'Each DataGridViewCell hosts an editing control, which is initilized by the InitializeEditingControl menthod. Imports System.Globalization Public Class CustomComboBoxCell Inherits DataGridViewTextBoxCell 'Attaches and initializes the hosted editing control. Public Overrides Sub InitializeEditingControl( ByVal rowIndex As Integer , ByVal initialFormattedValue As Object , _ ByVal dataGridViewCellStyle As DataGridViewCellStyle) Dim culture = New CultureInfo( "en-US" , True ) ' Set the value of the editing control to the current cell value. MyBase .InitializeEditingControl(rowIndex, initialFormattedValue, dataGridViewCellStyle) Dim ctl As CustomComboBoxEditingControl = CType (DataGridView.EditingControl, CustomComboBoxEditingControl) If (IsDBNull( Me .Value) OrElse ( Me .Value.ToString.Trim.Equals( "" ))) Then ctl.Text = "" Else ctl.Text = Me .Value End If End Sub 'Gets the type of the cell's hosted editing control. Public Overrides ReadOnly Property EditType() As Type Get ' Return the type of the editing contol that CalendarCell uses. Return GetType (CustomComboBoxEditingControl) End Get End Property 'Gets the type of the value of the cell Public Overrides ReadOnly Property ValueType() As Type Get Return GetType ( String ) End Get End Property 'Gets the default value for a cell in a newly created row. Public Overrides ReadOnly Property DefaultNewRowValue() As Object Get Return DBNull.Value End Get End Property End Class Custom Editing Control Class Code Snippet Class CustomComboBoxEditingControl Inherits CustomComboBox Implements IDataGridViewEditingControl Private dataGridViewControl As DataGridView Private valueIsChanged As Boolean = False Private rowIndexNum As Integer Public Sub New () 'This is the mapping implemented in the custom combo box MyBase .Tag = "B*BUY*S*SELL" 'Bind the DBBoundTag property to a column of the bindingsource. code here for simplicity. If ( Me .DataBindings.Count = 0) Then Me .DataBindings.Add( New System.Windows.Forms.Binding( "DbBoundTag" , My .Forms.Form2.AllocationQueueBindingSource, "TrType" , True )) End If End Sub Public Property EditingControlFormattedValue() As Object _ Implements IDataGridViewEditingControl.EditingControlFormattedValue Get Return Me .Text End Get Set ( ByVal value As Object ) If TypeOf value Is [String] Then Me .Text = CType (value, String ) End If End Set End Property Public Function GetEditingControlFormattedValue( ByVal context _ As DataGridViewDataErrorContexts) As Object _ Implements IDataGridViewEditingControl.GetEditingControlFormattedValue Return Me .Text End Function Public Sub ApplyCellStyleToEditingControl( ByVal dataGridViewCellStyle As _ DataGridViewCellStyle) _ Implements IDataGridViewEditingControl.ApplyCellStyleToEditingControl Me .Font = dataGridViewCellStyle.Font End Sub Public Property EditingControlRowIndex() As Integer _ Implements IDataGridViewEditingControl.EditingControlRowIndex Get Return rowIndexNum End Get Set ( ByVal value As Integer ) rowIndexNum = value End Set End Property Public Function EditingControlWantsInputKey( ByVal key As Keys, _ ByVal dataGridViewWantsInputKey As Boolean ) As Boolean _ Implements IDataGridViewEditingControl.EditingControlWantsInputKey End Function Public Sub PrepareEditingControlForEdit( ByVal selectAll As Boolean ) _ Implements IDataGridViewEditingControl.PrepareEditingControlForEdit End Sub Public ReadOnly Property RepositionEditingControlOnValueChange() _ As Boolean Implements _ IDataGridViewEditingControl.RepositionEditingControlOnValueChange Get Return False End Get End Property Public Property EditingControlDataGridView() As DataGridView _ Implements IDataGridViewEditingControl.EditingControlDataGridView Get Return dataGridViewControl End Get Set ( ByVal value As DataGridView) dataGridViewControl = value End Set End Property Public Property EditingControlValueChanged() As Boolean _ Implements IDataGridViewEditingControl.EditingControlValueChanged Get Return valueIsChanged End Get Set ( ByVal value As Boolean ) valueIsChanged = value End Set End Property Public ReadOnly Property EditingControlCursor() As Cursor _ Implements IDataGridViewEditingControl.EditingPanelCursor Get Return MyBase .Cursor End Get End Property Protected Sub OnValueChanged( ByVal eventargs As EventArgs) ' Notify the DataGridView that the contents of the cell have changed. valueIsChanged = True Me .EditingControlDataGridView.NotifyCurrentCellDirty( True ) End Sub 'The selected index change of the base class 'custom combo box' modifies the DB Bound property appropriately which is bound to a bindingsource Protected Overrides Sub OnSelectedIndexChanged( ByVal e As System.EventArgs) MyBase .OnSelectedIndexChanged(e) End Sub End Class Issues: The step through of this code seems to be working ok for the most part. But there are some things i dont understand and hence the implementation isnt working: 1. should i inherit the cell class from DGVComboBoxCell instead of DGVTextBoxCell 2. should i inherit the column class from DGVComboboxColumn intead 3. Also when i run this code the cell's do not populate. CLEARLY the thing that is BOUND is a property of the editing control which does not come to picture until the control is gets into editing stage How do i overcome this 4. When the user selects a value from the combo box after going into edit mode, the variable in the underlying control class IS getting set. But the underlying list is not accessing the DBBoundTag Property so when i leave the cell i dont see any updated values in the cell. 5. How do link the editingcontrol and the cell. seems like the data is not flowing from the editing control to the cell. PPHHLEASE HELP !! Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 16
    - Unit Test Case for Windows UI Hello There, I want to write unit test cases for windows UI (just like with NUnit I can write test cases for class library). Can anybody help me out for any free tools available for UI tests Thanks in advance Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
- Next
  - 1
    - insert rows to database by insert query hi all I use C# and Acess database file, after I add database from data menu --> add new data source my database name kal contain one table ( quest ), it have to column ( q_id , questions ) I added query using this procedures : opened kaldataset.xsd from it I made right click on questTableAdapter , and choose add query I configered insert query depend on this statment : INSERT INTO quest (questions) VALUES ( ) when I click on (exceute query) from (query biuled) window, and insert data in dialogbox it work very good it's really add data in my access database file; now I want using this query in my form I add commandbutton( butt1) and textbox ( TBox1) I want that when I click on butt1, the data in TBox1 store in my database file exactly like using (exceute query) button I don't know whats the code I have to write under butt1_click I opened the kalDataset.Desinger.cs to see the code to (exceute query) button I don't fond it ! I am also don't know the connectionstring plz help me Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 2
    - Databinding to types that asynchronously update If some type that implements INotifyPropertyChanged asynchronously updates one of its properties & fires PropertyChanged on a non-UI thread, do databound windows-forms controls (MS Framework) update themselves with Invoke Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 3
    - Threads, Sleep and unresponsive forms. Hello everyone. This time I have a problem with the form that stops responding when I run a thread that has Thread.Sleep() inside of it. By not responding I mean that you can't close it by clicking "X", menus are not available and buttons do not work. I know that it has something to do with Thread.Join(), because when I get rid of it or when it times out, form becomes alive again. but the problem is that I will have to wait for roughly 40 minutes for thread to either finish or to time out and not having a form alive for such a long period of time is not a good thing. OK. Here is a test code: Code Snippet private void btnTestOne_Click(object sender, EventArgs e) { newStop = new Stopwatch(); Thread t1 = new Thread(tck); newStop.Start(); t1.Start(); if (!t1.Join(10000)) { MessageBox.Show("timedout"); } } private void tck() { while (true) { txtBoxOne.Text = newStop.ElapsedSeconds.ToString(); txtBoxOne.Refresh(); if (txtBoxOne.Text == "40") return; Thread.Sleep(1000); } } So that is the problem. And the question is, can I use Sleep() in my child process, wait for the child to finish in calling process (while not infinently looping) and have the form alive in the same time Any help will be much appreciated. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 4
    - MDI and TopMost... I have an MDI Form that has 4 child forms that have TopMost = true; However when I set TopMost = false; These windows still stay on top within the MDI Form. Is there any other setting that could cause these forms to stay on top Thanks for your help! Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 5
    - disabling the mainmenu in a form Hi Does anyone know how to make the main menu in a form non responsive. I have this function which expects the user to pick a point on a pictureBox in the form with the mouse. Until this happens i want to stop the user selecting anything else on the form. The only thing he can selected at the moment is in the main menu that's why i want to make it non responsive for a while. Any ideas how to make this work. Much appreciate it. george Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 6
    - Combo Box Questin VB.net 2005 Item value and item text I have a list of items I need in a combo box, is there a way to put both the item ID value and the TEXT that is displayed. then they slelect one I get the ID Value not the text value Example my data ID TEXT 1 Texas 5 Illinois 16 New York I show them the TEXT but ID is the number I capture Dim objconn As New SqlConnection(Connstring) cboPN.Items.Clear() Dim ocomm As New SqlCommand( "Select rtN_Routename from tblRoutename order by 1" , objconn) objconn.Open() Dim myreader As SqlDataReader = ocomm.ExecuteReader Do While myreader.Read() cboRoute.Items.Add(myreader.Item( "rtN_Routename" )) Loop Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 7
    - About Box Show Im working on a simple notepad for my friend how do I show an aboutbox in C# that is allready designed in a button click event Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 8
    - How to use VBScript as a Custom Action DLL in .net setup ? I am trying to use VBScript as a Custom Action DLL in .net setup. The basic idea is to validate the Serial no.key. For this I have written VBScript with Session Variables to check the Serial No. But it gives the error : There is a problem with Windos Installer Package.A script required for this install to complete could not be run. Contact your support personal. Please if anyone know reply... Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 9
    - Problems with row error text. I'm using a DataGridView with a BindingSource and DataAdapter to let the user edit data in a single database table. I handle DataAdapter.RowUpdated() and DataGridView.DataError() to create error messages for rows with problematic data. If accessDataGridView_DataError() generates an error message (say, the user enters a letter in a numeric field), the error message displays correctly with the glyph on the correct row. However, after the user corrects the input and I update the data, thereby invoking theDataAdapter_RowUpdated(), the error message and the glyph still remain. I cannot get them to go away. How can I fix this My code: private void theDataAdapter_RowUpdated(object sender, OleDbRowUpdatedEventArgs args) { if(args.Status == UpdateStatus.ErrorsOccurred) { args.Status = UpdateStatus.SkipCurrentRow; args.Row.RowError = args.Errors.Message; } else if(args.Status == UpdateStatus.Continue) { // Try to clear the existing error message. args.Row.RowError = string.Empty; } } private void accessDataGridView_DataError(object sender, DataGridViewDataErrorEventArgs e) { DataGridView view = (DataGridView)sender; view.Rows[e.RowIndex].ErrorText = "Some kind of error message."; e.ThrowException = false; } Thanks for any suggestions, Mike Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 10
    - WebBrowser control in Winforms i am creating a winform and i want to display several tables in html. I have read up and the webbrowser seems to be the way to do this. I have managed to print out the tables once, however, the second time i try to update the webbrowser it just goes blank. The html in the webbrowser changes on the event of a combo box. I dont understand why it works the first time, but not the second and why are there no errors I would be grateful for any feedback, thankyou, Simon Graham Code: private void workoutPrintCombo_SelectedIndexChanged( object sender, EventArgs e) { object empty = System.Reflection. Missing .Value; axWebBrowser1.Navigate( "about:blank" , ref empty, ref empty, ref empty, ref empty); mshtml. IHTMLDocument2 doc = axWebBrowser1.Document as mshtml. IHTMLDocument2 ; doc.clear(); doc.writeln(createHTMLcode()); doc.close(); } Note i found this code on http://ryanfarley.com/blog/archive/2004/12/23/1330.aspx - it is not my own Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 11
    - How to achieve my contextMenuStrip look like 3d I need my contextMenuStrip to look with borders like 3d not like if it would have flat option in plane. Thank you. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 12
    - TaskVision Server install problem While i try to install Taskvision server on my computer, the installation progress aborted after pop up a message dialog which shows that the value is outof the range. would you please give me some advice about it The environment of my computer is: Operating System: Windows Server 2003 IIS: 6.0 SQL Server: SQL Server 2005 .NET Framework: 2.0 Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 13
    - Adding a ComboBox to a bound DataGridView Hi, How can you add a ComboBox to a bound DataGridView I know how to add a ComboBox if the DataGridView is NOT bound using something like: cbo = new DataGridViewComboBoxCell (); and then populating the ComboBox, construct other row columns and finally perfrom a dataGridViewx . Rows . Add ( dataGridRow ); This does not work if the DataGrid is bound - Hence my question. Thanks for your help. Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 14
    - Changing the look of ClickOnce install progress screen Is it possible to change the look and feel of the ClickOnce install screen Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 15
    - generation a typed dataset from a database How can I generate a typed dataset from a SQL database I know I can use visual studio to just drag the datatables from the server explorer onto the dataset designer but this has some undesired side effects: a settings file with a hardcoded connection string is generated (I do not want any settings in my assembly) foreach table a tableadapter component is generated (I do not want table adapter componants to be automatically generated) Is there a solution to this I would also be intrested on the workflow (how to update eveything) when I change something in the database (change columns of the database tables). Tag: Windows Forms General Import Excel file into dataGridView Windows Forms
  - 16
    - Conditional Compilation and the Windows Form Designer Hi, I have a program with a number of main controls. These controls are each held in a panel and have a corresponding PictureTab related to them. Each of these controls is a self contained piece of functionality within the program. What I want to be able to do is tailor the designer at compile time so that any number of these main controls can be built depending on a bunch of conditional attributes. i.e. #if ConditionalAttribute mainControl = new mainControl(); mainControlPanel = new mainControlPanel(); mainControlPictTab = new mainControlPictureTab(); #endif The above code would appear inside the InitializeComponent() method. Unfortunately I believe that if I do this, any time the Designer is re-generated I will lost all the conditionality that I have put in. Any ideas on other ways to go about solving this problem Thanks Malcolm Tag: Windows Forms General Import Excel file into dataGridView Windows Forms

dn8

Hi All,

I am trying to use the following code (from another post) to import excel into my application and then dislplay the results in a dataGridview

private void button1_Click(object sender, EventArgs e)
{
DataTable test = getDataFromXLS("c:\temp.xls");
if (test != null)
dataGridView1.DataSource = test;
}

private DataTable getDataFromXLS(string strFilePath)
{
try
{
string strConnectionString = "";
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strFilePath + "; Jet OLEDB:Engine Type=5;" +
"Extended Properties=Excel 8.0;";
OleDbConnection cnCSV = new OleDbConnection(strConnectionString);
cnCSV.Open();
OleDbCommand cmdSelect = new OleDbCommand(@"SELECT * FROM [Sheet1$]", cnCSV);
OleDbDataAdapter daCSV = new OleDbDataAdapter(); daCSV.SelectCommand = cmdSelect;
DataTable dtCSV = new DataTable();
daCSV.Fill(dtCSV);
cnCSV.Close();
daCSV = null;
return dtCSV;
}
catch (Exception ex)
{
return null;
}
finally { }
}

My problem is, it is doing absolutely nothing .. no errors no nothing ...

Do I need to register/enable OLEDB on my local machine Or is this included/enabled in the .Net framework...

any suggestions would be greatly appreciated...

thanks,

Paul

Re: Windows Forms General Import Excel file into dataGridView

H. Tony

well, it probably throws an exception that's caught and return null. why not debug into the code and see which line causes the problem

Re: Windows Forms General Import Excel file into dataGridView

dn8

shouldn't the line

catch (Exception ex)

throw and exception

I am running in debug and it is not showing any exceptions... however the data table is coming back as null

I changed the code from

if (test != null)

to

if (test == null) {

MessageBox.Show("nada");

}

and I am prompted with "nada"

so that is why I was wondering if the driver needed to be enabled/installed

Paul

Re: Windows Forms General Import Excel file into dataGridView

dn8

Figured it out .. something simple of course.. My "Sheet1" isn't name sheet one at all .. it's named testes!

-P