14,025 Topics

Member Avatar for
Member Avatar for sundog1

Hi Guys.. Can any experts in Excel/C# Help me with this one? I think I'm nearly there. Currently I have a DGV on a windows form which pulls data from a Datasource. I want to export the findings to and Excel report template. I've managed to export the data into …

Member Avatar for Ketsuekiame
0
380
Member Avatar for robert99x

I previously used 32bit Python 2.7 on Windows Vista. My new PC is Windows8 and 64 bit. I would like Python to work with Microsoft Office Excel. Is the best / simplest way forward to stick with 32 bit Python and 32 bit Excel? Can you mix 32 bit Python …

Member Avatar for vegaseat
0
313
Member Avatar for chriswelborn

I've added the necessary registry key to have my app run when windows loads: [B]Hkey_Local_Machine\Software\Microsoft\Windows\CurrentVersion\Run[/B] [B]MyProgram[/B] = [B]c:\MyDir\MyProgram.exe[/B] [I]..I've also tryed adding it to the Programs\StartUp folder.[/I] My app still won't load when windows does. Other apps do, and I was wondering what might be preventing my app, and [U]only …

Member Avatar for chriswelborn
0
529
Member Avatar for adem87

string location = Environment.CurrentDirectory; string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + location + "\\harita.accdb"; // get records from the Shippers table string commandString = "Select x from map"; //create the data set command object and the DataSet OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString, connectionString); DataSet ds = new DataSet(); // fill …

Member Avatar for ddanbe
0
163
Member Avatar for Bull3t

Just to make sure before I delete these; [CODE]Logfile of HijackThis v1.99.1 Scan saved at 21:00:00, on 25/10/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe C:\WINDOWS\SOUNDMAN.EXE C:\WINDOWS\system32\RUNDLL32.EXE D:\Microsoft AntiSpyware\gcasServ.exe C:\Program Files\Common …

Member Avatar for caperjack
0
320
Member Avatar for silversurf

Hello, Here is the scenario : I have the follwoing sales return from in my software: ![sales_return1](/attachments/large/3/sales_return1.JPG "sales_return1") In the from I have tow listview control, the left is Listview and the right is Listview1. I have the following code in procedure : Dim xsprice As String Dim xsprice1 As …

Member Avatar for hyesin
0
1K
Member Avatar for x38class

I have found the following post re this issue does any body have any idea which is correct [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Comdlg32] "NoFileMru"=dword:00000001 2.HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Value Name: NoRecentDocsMenu Value Type: REG_DWORD Value Data: 0 or 1 0 = Yes, allow recent docs 1 = No, do not allow recent docs Value Name: ClearRecentDocsOnExit Value …

Member Avatar for x38class
0
865
Member Avatar for vprakashit

i am tyring to create new project nemmed as car parking system please help to get the password and check the name in database and display the already gathered displays ........please help me ...........<snip>

Member Avatar for <M/>
0
138
Member Avatar for raaif

I am trying to retrieve all the names of the mp3 files from my hard drive, heres the full code, what i am facing is "Access to the path 'D:\System Volume Information' is denied." error, but i have changed the manifest file as below [ICODE]<?xml version="1.0" encoding="utf-8"?> <asmv1:assembly manifestVersion="1.0" xmlns="urn:schemas-microsoft-com:asm.v1" …

Member Avatar for Reverend Jim
0
2K
Member Avatar for sundog1

Hi guys, I'm hoping you can help here with a problem I am having with regards to filling a Dataset. It was working fine but have had to amend the code to read a different data set and structure. Basics are 2 tables.. one customers, 1 orders. Joined on there …

Member Avatar for sundog1
0
339
Member Avatar for Lejan

Hi, Here is the code I’m trying to execute using MS Access database to return a dataset. And i get the error "No value given for one or more required parameters". Public Class Main_Form Dim conn As New OleDb.OleDbConnection Private Sub btnReset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles …

Member Avatar for Reverend Jim
1
266
Member Avatar for izzywizzy

Hello! I am currently developing a web interface that has access to an MS ACCESS database. However, I am unable to key in more than 6 Values into the database using the INSERT INTO sql code. Here are the codes that I am using: protected void bnAddPart_Click(object sender, EventArgs e) …

Member Avatar for IIM
0
187
Member Avatar for slasham

Hi, I have recently finished building my own computer and am wondering what operating system to get. I was thinking about getting Linux mint 14 because it's free and I like the layout. Ive also heard that there are very few viruses as well. The only thing is that I …

Member Avatar for CimmerianX
0
435
Member Avatar for PBubble

Good evening! I'm trying to figure out how to retrieve and display data from MS Access to my project's DataGridView. So far I have the codes to make the options for the CheckedListBox appear. SAMPLE: (Codes for other categories are not included since they're all basically the same) 'view client …

Member Avatar for tinstaafl
0
954
Member Avatar for Ayesha.Shahnawaz

I've got 2 flex grids in one VB form and I wanna connect both of these Flex Grids to 2 different tables in MS Access. This is how my form looks like: http://i213.photobucket.com/albums/cc228/rose_408/form_zps100c290c.png Here's the code for the service flex grid (FlexService): Private Sub Form_Load() Set conn = New ADODB.Connection …

Member Avatar for AndreRet
0
278
Member Avatar for kitschkath

Hi, it's me again.. I have this codes wherein I can export the data from the databse to Excel.. I get a **Notice: Undefined variable: aData** on one of the php files.. well two of them actually.. The weird thing is... The other page which I have modified - i …

Member Avatar for kitschkath
0
188
Member Avatar for LeunamP

guys can i ask something, what kind of server or database is good for Microsoft Visual Studio 2008, or VB.net thanks..

Member Avatar for riahc3
0
313
Member Avatar for mgunia

Hello, I want to re-arrange my existing macros in the excel file. I have a macro which goes to the specified sheet and checks column R if there are commas. If it finds the commas it replaces it to dots. Column R is called Email. But in some of documents …

Member Avatar for mgunia
0
338
Member Avatar for christie.smoot.3

Once I have logged in, the "loggedIn.aspx" page is to display: IP Address: Contact: Date: I am able to get the IP address to display, but really have no clue on how to show both the username and current date. This was a conversion from .asp to c#.net Here is …

Member Avatar for LastMitch
0
164
Member Avatar for toth.attila.7921

Hi! I want to make a CONVERTER. I designed it, so I just have to program some buttons. The problem that I have is weird. I programmed a button that says : CONVERT TO METER. After I build the program, I get ERROR C1075 : end of file found before …

Member Avatar for tinstaafl
0
849
Member Avatar for Ayesha.Shahnawaz

Ok, so my form displays an error saying "run time error. could not find installable ISAM." everytime i run it. And its pointing at "conn.Open" part of the code when i run it. heres my code: Dim conn As ADODB.Connection Dim rec As ADODB.Recordset Dim rec1 As ADODB.Recordset Dim rec2 …

Member Avatar for AndreRet
0
2K
Member Avatar for x38class

I have found the following post re this issue does any body have any idea which is correct 1. [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Comdlg32] "NoFileMru"=dword:00000001 2.HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Value Name: NoRecentDocsMenu Value Type: REG_DWORD Value Data: 0 or 1 0 = Yes, allow recent docs 1 = No, do not allow recent docs Value Name: ClearRecentDocsOnExit …

0
247
Member Avatar for mgunia

Hello. I would like to ask for a help. I deal with excel spread sheets and very often I need to amend specific column. The whole steps look like this: Step 1. Find the column name, Step 2. Mark the all populated rows in this column, Step 3. Proceed with …

0
146
Member Avatar for Skipind

connecting access 2003 database from remote computer .I have a vb2005 application which uses access2003 database. I want to connect to this database via remote computer connected via internet.

Member Avatar for savedlema
0
371
Member Avatar for mattster

Hi everyone, Heres my problem: I've installed Qt 4, and there is **no** qmysql.dll/.a in C:\Qt\4.8.4\plugins\sqldrivers\. I am running a MySQL database program and I get Database error: Driver not loaded. Theres not really a lot of help anywhere on google so hopefully DaniWeb will yet again prove itself as …

Member Avatar for mattster
0
398
Member Avatar for sundog1

Hi Guys, The reason for my message was to do with UPDATE and DELETE Statements from within C# when contacting a MDB file. I currently have the INSERT INTO SQL Query working perfectly The Code I used for this is below: else if (radioButton2.Checked == true) { //Creates new versions …

Member Avatar for ChrisHunter
0
192
Member Avatar for pritaeas

I want to have the following on SQL Azure: IF EXISTS(SELECT * FROM [sys].[databases] WHERE [name] = db_name() AND [compatibility_level] = 110) BEGIN ALTER PROCEDURE [dbo].[Test] AS BEGIN -- Omitted body containing lots of strings END END or a work-around that does something similar. What follows is what I'm trying …

Member Avatar for pritaeas
0
155
Member Avatar for atletico

Hello guys, I would appreciate if you could help my on the below issue. When i used an Excel object in my code, when closing this, the excel.xls applicataion remains opened at the task manager. i am copying below the test code for your reference, which i am using in …

Member Avatar for Reverend Jim
0
799
Member Avatar for l3ights

Hi guys, I am building a program which has 5 forms, 1 mainmenuform with 4 buttons and each of them buttons have a form corrisponding to that button and this program is connected to my access database. The problem I have is I've put all my code into my first …

Member Avatar for l3ights
0
139
Member Avatar for sundog1

Hi Guys, Right... I've managed to run select statements with associated Joins to show the data I want in DGV's which is great. Seems to be working fine. I'm not to the point where I need to be able to Insert, Update & Delete Rows in my Database. I am …

Member Avatar for sundog1
0
210
Member Avatar for desmondo

I tried to install Microsoft office 2003 on my computer but I get the error message saying setup cant continue installation source has been corrupted. I've tried updating the maximal parser file as advised by Microsoft website but still have the problem. I'm using windows 7

Member Avatar for jithinjohny
0
127
Member Avatar for pedders

I want to access some data in an Access MDB but I want to make sure that nothing can be accidentally altered. I have tried: conn = New OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB;Mode=adModeRead;") I've also used conn = New OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB;Mode=Read;") I then run a quick UPDATE WHERE query and it still alters …

Member Avatar for Ancient Dragon
0
1K
Member Avatar for bryann

Hi i am trying to write the contents of textboxes to a spreadsheet. The code i have does work but at the moment i have to specify what cells to write to. What i would like is for the text to get written to a different row each time but …

Member Avatar for bryann
0
1K
Member Avatar for ImZick

Hi everyone i have a connection to my sheet like this Dim da As New OleDbDataAdapter("Select * from [EBU 2 LOB$]", con) but i want to use this Dim Sheet1_EBU as string = "EBU 2 LOB$" so that the code will be something like this i think? Dim da As …

Member Avatar for deceptikon
0
150
Member Avatar for pittapat

hi there. have been a member for a long time, but have never really used the forum. our computer has started taking ages to open programs an pages, so I went into control panel to see what i could uninstall.......i have found a heap of files in there called microsoft …

Member Avatar for caperjack
0
136
Member Avatar for ImZick

Hi guys i have this code which insert the data in the textbox Dim FilePath As String = "C:\Users\ezekiels\Desktop\New Folder\EBU 6.mdb" Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & FilePath & "") conn.Open() Dim myadapter As New OleDbDataAdapter("SELECT * FROM Table_EBU6", conn) Dim dtset As New DataSet myadapter.Fill(dtset) myadapter.Dispose() Dim table …

Member Avatar for Begginnerdev
0
205
Member Avatar for hirenpatel53

hi all i am reading excel file from c# into dataset everything working fine but the problem is it takes first row of excel as header's of column and i have "TRANSACTION DATA FOR CDs MANAGED BY TCBILs FOR THE MONTH OF DECEMBER 2012" in first row of excel ant …

Member Avatar for remunance
0
217
Member Avatar for Lobster1071

OK, I've exhausted my searching, so if someone can point me to a link with a good example, that would be super. I'm simply trying populate a combobox with data from an Access table (it's a simple contact list with Name and Number). Every example I find and try, I …

Member Avatar for Lobster1071
0
1K
Member Avatar for Derek3191

I was trying to install windows on my MacBook and things weren't working during the windows side of the install. After restarting and going to the utility screen by pressing cmd + R, I tried to do a time machine restore, it isn't finding my Mac HD when it asks …

Member Avatar for macmad
0
338
Member Avatar for XEN0

Just wondering here what is a efficent way to communicate between a Windows Form project and a console application. So far im using Visual Studio 2012 and the System.IO.Pipes namespace,to send bytes between the application. In the windows form(as client) Dim pipes As NamedPipeClientStream pipes = New NamedPipeClientStream("A Digital Whirlwind …

Member Avatar for XEN0
0
362
Member Avatar for Greyhelm

I just setup a new Dell computer running Windows 7 64-bit copied over the data using Microsoft's Easy Transfer then installed Microsoft Office 2007. However, now when opening an existing Excel 2007 spreadsheet, Excel appears to hang for over a minute before any changes can be made. Are there specific …

Member Avatar for Greyhelm
0
296
Member Avatar for anisha.silva

hi, I have a sheet name 'rate' and another sheet name "master". rate sheet has data as below EmpCol1 rateCol1 a 1 b 2 c 3 etc... and master has data as empCol2 rateCol2 c a b What i want to do is to get the rateCol1 from rate sheet …

Member Avatar for TnTinMN
0
248
Member Avatar for Joe2

I have just tried to access http://blog.seorevolution.com/2013/01/24/5133/ and get the following: Forbidden You don't have permission to access /2013/01/24/5133/ on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_perl/2.0.5 Perl/v5.8.8 Server at …

Member Avatar for BigPaw
0
215
Member Avatar for RenanLazarotto

Hello people! I want to develop for Windows Phone (7.5/7.8). Can someone point me where I should start? I'm kinda familiar with C#, I need to know what changes from C# development on desktop and C# development on WP. Sorry for the vague question, I really don't know where to …

Member Avatar for peter_budo
0
105
Member Avatar for c_learner

Hi people, I would like to learn how to create database applications which store the data entered by multiple users, process the data, and provide the data as requested by the user. Is it possible to write such an application by using Microsoft SQL Server and Microsoft Visual C#? I'm …

Member Avatar for soethandar
0
208
Member Avatar for SpyrosMet

Hey everyone, so I have this project for windows phone i have to do and I have to put some pins on a bing map, but in order to do that I make an API request to google for google places. I get back an XML file and it's like …

Member Avatar for Ketsuekiame
0
3K
Member Avatar for hirenpatel53

can any body Please tell me how to start or call windows service installed on remote server from windows based application in c# Help will be apreaciate Thank you in advance

Member Avatar for Ketsuekiame
0
133
Member Avatar for deceptikon

Another quickie. This is a basic class for working with Windows path strings. It's based off of .NET's System.IO.Path class, but doesn't contain any API dependencies (and thus doesn't normalize the paths, it's all straight string handling). Methods that I've personally found to be useful are included. The class is …

Member Avatar for deceptikon
0
401
Member Avatar for AARTI SHRIVAS

<?php //session_start(); include("connection.php") ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Hedgeis-market</title> <link href="market css.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" type="text/css" href="jquery-ui.css"> <script src="jquery-1.8.3.js"></script> <script src="jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css" /> <!-- <link href="marnet_internal_css.css" rel="stylesheet" type="text/css" /> --> <script> $(function() { $( …

Member Avatar for diafol
0
559
Member Avatar for devianleong

As title show. I still not able to connect my ms.access login database . Please help me ~ Dim con As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\leong\Documents\Visual Studio 2010\Projects\WindowsApplication4\WindowsApplication4\coursework.accdb") ' Dim cmd As OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM AdminUser WHERE Username ='" & Usernametxt.Text & "' AND Password ='" & Passwordtxt.Text & …

Member Avatar for Begginnerdev
0
144

The End.