13 Topics

Member Avatar for
Member Avatar for JModak

The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) My Code is Private Function GetXlUsedRange(ByVal filePath As String) As Object(,) Dim xlApp As Excel.Application Dim xlWorkbooks As Excel.Workbooks Dim xlWorkbook As Excel.Workbook Dim xlSheets As Excel.Sheets Dim xlWorkSheet As Excel.Worksheet Dim xlRange As Excel.Range xlApp = New Excel.Application xlWorkbooks …

Member Avatar for tinstaafl
0
51
Member Avatar for Reverend Jim

Several people have asked how to export data to Excel. This code snippet shows how to export the data from a listview in details mode to a new Excel spreadsheet. Take note of the comments in the header to avoid having orphaned Excel.exe tasks eat up your system memory.

Member Avatar for Reverend Jim
7
9K
Member Avatar for hallianonline

Hello Friends I am facing a little problem that I want to sort my records according to date I mean to say I want to show the upcoming records based on dates on the top in ascending order I have a complete working code to fetch from the database but …

Member Avatar for Smith5646
0
247
Member Avatar for johnnyboy123

Hi everyone, I am quite new to vb.net. Recently, I've been learning about Oledb commands and it's ability to save records in a form to a database. So, I started a project and now I am stuck. Here's the scenario: The form comprises of several comboboxes, a listview box and …

Member Avatar for Reverend Jim
0
470
Member Avatar for vishal anand.s

Hi my name is vishal. For the past 1 week i been in the process of creating a dashboard using listview in c# windows forms with sql server 2008. I created listview named lstDashItems and populate it from a table named USERACTIVITIES in sql server 2008. The design of USERACTIVITIES …

Member Avatar for vishal anand.s
0
387
Member Avatar for Shodow

hi i have a code here that export my listview items to excel but i want to customize each cell size and i want to format the date and landscape environment Try Dim objExcel As New Excel.Application Dim bkWorkBook As Workbook Dim shWorkSheet As Worksheet Dim i As Integer Dim …

Member Avatar for G_Waddell
0
318
Member Avatar for zbzHenry

hello, i am trying to save data in my listview item to access database.. i am new to programming and i am currently working on a project i need to submit very soon, this is really urgent and i will be much happy if i could get assisted as soon …

Member Avatar for Dili1234
0
612
Member Avatar for ImZick

Hello its me again... sorry to keep on posting about my problem well here it goes.. If you see in the attached file. ![Sum](/attachments/large/4/Sum.jpg "Sum") I have an AM Ervielette, Marriane etc. now i need to add their Total Calls for Ervie and Total Visits same goes to the other.. …

Member Avatar for ImZick
0
280
Member Avatar for ImZick

Help i need to import excel to my listview using adodb or oledb but i dont know how? in vb6 i use adodb and the code is like here Dim lngI as Long Dim lvItem as listItem *'adodb connection goes here...* *'then this code will import all excel data in …

Member Avatar for ImZick
0
2K
Member Avatar for tet3828

I have a two forms that I created using the design view of Visual C# Express (Form1 & infoEntry). I set the properties to of the listview in Form1. public System.Windows.Forms.ListView toSend; I've invoked the second form and sent some data using code below. Works great. infoEntry dataWindow = new …

Member Avatar for TnTinMN
0
421
Member Avatar for IDC_Sharp
Member Avatar for emreozpalamutcu

Here is list of things I want to do: Display context menu strip only when mouse is over the item and right clicked on it, the code I have for that is this: [code]private void contextMenuStrip1_Opening(object sender, CancelEventArgs e) { if (listView1.SelectedItems.Count == 0) e.Cancel = true; } private void …

0
111
Member Avatar for Dorayaki

Hello, I got a problem, I can save my data to access database and in the access database field I set it to date/time. But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00 How to get the …

Member Avatar for Unhnd_Exception
-1
3K