| excel and c# (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| I am using the following code to read an excel file and display the data on a data grid Code: string strconn; strconn "Provider Microsoft.Jet.OLEDB.4.0;" "Data Source c:\\\\test.xls;" "Extended Properties Excel 8.0;"; OleDbConnection oConn new OleDbConnection (); oConn.ConnectionString strconn; oConn.Open (); //create new OledbCommand to return data from worksheet OleDbDataAdapter da new OleDbData... |
|
| Excel automation (VIP replies) |
| microsoft.public.dotnet.framework.aspnet |
| I'd like to know if there is a way to read the worksheet name of an excel file. Here is my code: foreach(Excel.Worksheet sheet in thisworkbook.Sheets) { Response.Write (sheet.Name); } This code works if the names are like Sheet1, Sheet2, etc.. But if I change the sheet1 to testsheet, it still dispays as Sheet1. Can someone helps me? Thanks. |
|
| Excel Automation (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| Hi, Can anyone help? I am creating an Excel file in asp.net and when I set the PageSetup.Orientation I get the following error. Unable to set the Orientation property of the PageSetup class Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception De... |
|
| Exception error thrown when trying to read a file (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| I am trying to read a file in with the following code and I am getting a system.nullreferenceexception error. The error is â œobject reference not set to an instance of an objectâ . This is my code below and I canâ t figure out what I am doing wrong. I have used this before and know it worksâ .there is no reason for this not too. Help, please. Private strPhraseFile As String Private intPhrases As ... |
|
| Exception from SqlConnection.Close (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| Exception from SqlConnection.Close "Object reference not set to an instance of an object" Web app running on a web farm ..NET 1.1 / ASP.NET / ADO.NET Exception occurs approximately 4 times per day. Extensive single web client testing did not reveal this exception. Does this particular exception indicate a bug within the SqlConnection class? Any suggestion about how to deal with it? Larry |
|
| Exception in DataTable.Select (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| I receive the following error when I try to select data rows from a data table in c# using the method DataTable.Select.... Exception: Object reference not set to an instance of an object. Stack: System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.Select... |
|
| Exception thrown when filling a dataset (VIP replies) |
| microsoft.public.dotnet.framework |
| I have a very very simple project that contains just a form and a typed dataset (Customers from the Northwind database). The form contains an instance of the aforementioned dataset (called DatasetCustomers1), a datagrid (bound to the dataset) and a button (to refresh the dataset). The dataset gets filled by the FillDataSet member shown below and this gets called from both Form Load and Button Clic... |
|
| Execute code after form is visible (VIP replies) |
| microsoft.public.dotnet.framework.windowsforms |
| I am using a hosted ActiveX control within a Windows Forms application. I can not properly activate the ActiveX control because the control's GUI can be initialized only when the form has completed the loading of it's GUI. How can I get the control to activate properly? I have tried to use the Activated event in the Winform, however, this does not appear to work. I have also tried initializing the... |
|
| execute public sub on other form (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| i have 2 forms: form1 with 1 button Dim f As New Form2 Private Sub Button1 Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click f.Show() End Sub Public Sub sven() MsgBox("dd") End Sub form2 with 1 button Dim f As Form1 Private Sub Button1 Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click f.sven() Me.Hide() End Sub Why does th... |
|
| executenonquery(); timeout error (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I' m a calling a SQL SP from ASP.net that executes a DTS package (which runs in around 10 minutes). I'm getting a timeout error. The DTS package is setup to send an email once the job completes, so I would like for the ASP to simply execute the DTS job, not attempt to wait for the job to complete. Any help would be greatly appreciated. David Jones |
|
| ExecuteReader: Connection property has not been initialized. (VIP replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Copied from [aspngfreeforall] to [ngfx sqlclient] by James Avery javery@deluxeeng.com can someone pls help me on this one. below is the err message im getting. what does "ExecuteReader: Connection property has not been initialized" mean? TIA, rOnNeL Server Error in '/PortalVSVB' Application. ExecuteReader: Connection property has not been initialized. Description: An unhandled exception occurred d... |
|
| Executing a program while displaying a model window (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| I have searched in vain for what seems like something that should be simple to accomplish. I have a Windows application written in C# that scans a driver's license. While it's scanning I want to display a "Scanning..." progress bar window until the scanning is complete or the user clicks cancel. All is fine as long as I use "form.visible" to display the window with the progress bar. I use another ... |
|
| Executing Methods on a Different Form (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| Form1 is a PUBLIC class with a button, a label, and a PUBLIC method called AddText(). Form2 is a PUBLIC class with a button. When Form1.button is pressed it opens Form2 using the Show method. The button on Form2 should execute the AddText() method on Form1 which simply adds some text to the label. I would have thought that I could just write something like this in the Form2 Button Click event hand... |
|
| expert help needed converting vb6 (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| Hello, I am trying to convert a project from vb6 to vb.net. The code is a sample from an sdk for Canon digital camera's. I have gotten most of the issues resolved, but there are some that I am lacking knowledge in. I would appreciate any help give with this. The main errors have to deal with the VarPtr and AddressOf expression. Unfortunetly I do not have much experience with delegates. Below is so... |
|
| Exponentiation (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| What is happening here ? long longg 5; longg longg (2 ^ 8); the answer should be 5 256 or 261 but at the end of the above operation C# returns longg 5 10 or 15 What's going on here ? What is the correct syntax for Exponentiation ? Thanks, Jim |
|
| Export data to Excel (VIP replies) |
| microsoft.public.dotnet.framework.aspnet |
| is it possible to export excel directly from ASP.NET to Excel? My requirement is that the data on the datagrid is exported to MS Excel file after user clicks the button on the web page. Excel will be open automatically with imported data. If so, is need to add any additional controls or tools? Million Thanks.. Eric Yum |
|
| Export Data to Spreadsheet (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| I have data that I need to either put in a spreadsheet, or use in a listview to view it. I would rather use the listview but I don't understand how to put my data into it. Here is the code I have, currently I am just display all the data in a label and it sucks. Private Sub btnGetDoubles Click(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesbtnGetDoubles.Click Dim colors(9) As S... |
|
| Export datagrids to Excel (VIP replies) |
| microsoft.public.dotnet.framework.aspnet |
| I have a web page written in asp.net that has multiple datagrids on it that would need to be exported to Excel. Each of the datagrids would be a subset of what the datagrid above it was. Thus far, I've had no luck in finding anything to work reliably. Some of the files I've saved (using a radio button click event), will open fine in Excel, others give me an "Unable to open file" message. Any help ... |
|
| Exporting DataGrid to Excel (VIP replies) |
| microsoft.public.dotnet.framework.aspnet |
| Hi, I'm currently exporting my datagrid to excel, taking advantage of the fact that excel can render html, the problem is that when i click the button to export it opens in browser, I want the button to launch Excel and leave the browser as is. Any help appreciated p.s. I know that this can be achieved by changing the settings on the client machine and de selecting the 'browse in same window' for ... |
|
| Expression Columns with Dates (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| I was wondering if someone could enlighten me about using date/time variables in column expressions. I am trying to setup a timesheet style form. The datatable that holds the information is filled by code, no database interaction. I'm aware of the DateDiff function in SQL, but I can't get it to work in an expression column. Is there another function that I should be using, or do I have to do a wor... |
|
| Extended Control viewed as .NET Framework control (VIP replies) |
| microsoft.public.dotnet.framework.compactframework |
| Iam extending the .NET Compact Framework textbox control in order to create an advanced textbox control. I have successfully compiled it and I was able to add it to the ToolBox. Here comes the tricky part: When I create one of this controls in the designer it doesn't look like a Compact Framework textbox, instead it looks like .NET Framework textbox. The weird thing is that it just looks like a .N... |
|
| Extending Textbox colors (VIP replies) |
| microsoft.public.dotnet.languages.vb.controls |
| I recently tried to create an extended Textbox control for VB.Net. I was trying to create a control where I had more control over the colors in disabled and read only mode. I went to some examples on different websites. Changing the color (text and background) is fairly easy. I just inherited from textbox, overrode the OnPaint event and used Graphics.Drawstring. I had a little problem with centere... |
|
| Extract text from a Word doc (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| How can I open a word doc and extract the text as text without any formatting characters?? Barry Fitzgerald |
|
| Extracting DataRow from DataSet (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| How do I get a datarow from a dataset? I have a datagrid and want to pass the selected datagrid row selected for update to another class to do validation. I get the following exception: There is no row at position 0. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originate... |
|
| Extracting Image from database & displaying in picture box (VIP replies) |
| microsoft.public.dotnet.general |
| I want to display the image from database to picture box through ado.net and vb.net? I have some images present in a sql server 2000 table stored under 'image' datatype. I want to extract and display them in a picture box present in a vb.net form. I appreciate any help on this. Thanks, PS |
|
