14,025 Topics
![]() | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
Hello, Here is the scenario : I have the follwoing sales return from in my software:  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 … | |
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 … | |
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> | |
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" … | |
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 … | |
![]() | 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 … |
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) … | |
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 … | |
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 … | |
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 … | |
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 … | |
guys can i ask something, what kind of server or database is good for Microsoft Visual Studio 2008, or VB.net thanks.. | |
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 … | |
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 … ![]() | |
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 … | |
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 … | |
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 … | |
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 … | |
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. | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 | |
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 … | |
<?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() { $( … ![]() | |
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 & … |
The End.