If you want to make a guestbook or other kind of messaging system for a web application, and you don't have a database available like MySQL with PHP or with ASP, then I have this free solution for you. You can use Excel as a database, it's not supposed to serve as database for a web application, but technically it is possible.
[Code]...
I have a WPF application, that I want to convert to an application running from the browser. The reason is that WPF doesnt run on Mac/Linux, and Silverlight is not an option because of it's security restrictions.
The basic idea is to turn the app into a webserver-like application, and handle the UI completely in html/ajax. This 'webserver' doesn't rely on WPF/Winforms, so can run on Mono as well. And you can even control the app from your Android/iOS device while on the road.
My question is: is it possible to create this user interface using .NET? The code for the webserver-part is not a problem, but i'm struggling with the actual html that is being served. For example, when someone clicks a button, I need to bind an event to that. I have to write lots of javascript for all those little 'events', for simple controls like listboxes, progress bars, etc. It would be so much easier if I could design the web-interface from VS. While it has support for ASP, I cannot use it's page designer, because the end-user will not have an ASP server running on their desktop PC.
So what would be the best approach to design those dynamic pages using .NET?
EDIT: To make it more clear, it's not an internet application. The user runs the server-part locally, and connects to 127.0.0.1:80 to view the User Interface of the app.
EDIT II: Because their seems lots of confusion, let me give an example of a similar application: SABnzbd. It's a binary newsgrabber, that you install as a 'Windows Service', and can be controlled through your webbrowser. It's multi-platform, and written in Python. I want to take the same approach, only using (VB).NET
In an electric company where I was hired temporarily, we have to implement an upgrade of the billing and payments system ( the current system is a dbaseIII system). The company's programmer and I have decided to use VB.Net and MySQL.
The company served several towns and have billing and payments centers in selected towns. Every billing period, the meter readers would read the readings for every electric meters and then write the readings in the sheet. Every 5 pm, an employee from the centers would collect the sheets and then travel to the main center where the readings are encoded.
[Code]...
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
1. First off, how do I make my path to my database relative? The path is currently absolute and is: Data Source=J:/College/AS_DSFinalDatabase1.accdb
2. Second of all, where do I save my database in the project? I want it to be included in like project folders...kind of like the App_Data folder in ASP.Net.
3. I'm recieving an error whenever I try to populate more than 1 DataGridView upon form load for some reason...I've tried 5 different ways of writing the code, and I get the same error...there's no error description, so does anyone know what the issue is? Here's the error:
How to make a border in excel from VB.net?
View 4 Repliesof code to transfer from a datagridview to Excel.I used to convert to adodb and do it that way, but I'm trying to get away from activex.o... I made the following method: It takes about 45 seconds to run. It also locks out my application's gui thread for that time period and it would be nice to also run this as a seperate thread...Can this go any faster? The background colors are important to the person I'm doing this for
Public Shared Sub toExcel(ByRef DGV As DataGridView, ByVal Name As String, ByVal lastSaved As String)
Dim rowNo1 As Integer
[code].....
vb.net
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
[code].....
I am trying to make a program that goes to an excel file, copies the given range and pastes (Values!!) to another excel file. I am doing it in a loop because information from 12 different files gotta be in this one workbook. this is what i got so far
For intCounter As Integer = 0 To 11
With appXL
.Visible = False
[Code]....
It does the job, but every time I close the Roll Up file it gives me an error "A formula in this worksheet contains one or more invalid references." I guess it is because it copies the formulas as well...
I am trying the whole day to make an excel-macro run through VB2008. The macro in excel calls another file and extracts two values in order to draw a graph. The VB code should run the excel macro everytime and import the graph. However, I have a problem with this line : oExcel.Run("Macro1")
[Code]....
I have searched all the code here I can find. I have added a bunch of code that some said should fix the problem. but it persists.
Given the code below, I open a small .xml file and then try to save it as a .XLS file. Should work just fine. When I monitor Task manager, the instance of Excel shows up immediately. But despite all the code I have added, it still won't go away, even if I exit the application. And if I run the process twice, I get multiple copies of Excel in task manager.
If the instance of Excel in the task manager went away when I exited my app, I would assume that there was some reference that was instantiated (behind the scene maybe) that persists until then. But this is not the case.[code]...
I am working on an Excel report and I would like the top rows to be empty to allow for an image to be inserted. However, I do not want the image size to change the width of the columns and would rather the data below do that.
This is what I have so far:
If ComDset.Tables(0).Rows.Count > 0 Then
Try
[code].....
I have an application in which i have to load the grid using MS Excel and save that excel to Sql Server.
View 2 RepliesJust tried out a new Excel component. (Spire.Xls)I make a reference to the DLL and write my code to create an excel workbook. Everything seems fine but when i compile my program i got this warningWarning1The referenced assembly "Spire.XLS" could not be resolved because it has a dependency on "System.Web, Version=4.0.0.0, Culture=neutral, ublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project.Mix-kasse
View 2 RepliesI tried to make a class to manage the communication with Excel, but I am having problems.
View 18 RepliesI am trying to essentially convert an Excel spreadsheet into a Windows Form. On the first worksheet I have setup an IF statement to work as a search function =IF(C10="","",VLOOKUP(C10,'Price List'!$A$2:$D$40008,2,FALSE)) to read a price list on a separate worksheet. It works by taking a partnumber then puts the description in the next column (description column) and then the price in the "price each" column then finally totalling the row based of the quantity selected (see below).[code]...
View 11 Repliesi what to make spread sheet program like excel and i what it to be able read spread sheets and create them
View 1 RepliesI m writing my first ever application.I want to make a data search engine exactly same as the excel sheet has.The search form is a owned form and has one combobox to specify the search criteria that in which column of the database table i want to search and a textbox to write the search item.What i want is when i type 'A' in the textbox and click the findAll button the search result should display the first matched record in the textbox of owner form and then if i click findNext button the search result should display the next matched record.Same like excel Find and Replace Window.
View 1 RepliesI was thinking about writing some VB 2005 code that would be able to open an excel file and keep it open while I do things in separate functions/subs basically just check boxes, so each check box is its own sub but HOW do I do that with out opening and closing the excel file for every check box sub, since every time I make a check box the sub comes up as private?
View 9 Replieshave a Visual Basic 2008 project with references to Microsoft.Office.Interop.Excel and Microsoft.Office.Interop.Access for Office 12/Office 2007. I also have Office 2007 installed on my PC. I tried running my program on a PC which has Office 2003installed (i installed the compatibility pack to open .xlsx files) and the Access Database Engine for .accdb Databases.It does not have VS2008 installed but has .Net Framework 3.5 SP1 installed.
View 10 Repliesi making a website for trading in which trading feed coming from a source in excel sheet. i have to show data from excel sheet to gridview. but when i make connection it will lost due to rapidly data( in excel sheet each cell change value 1-3 times in one second).Am using Ajax Timer of interval 1000.
View 1 Repliesi have a datagrid view, how can i use this or another item from toolbox to import and make excel files? if possible, include some coes that will make it work,I like...Understandable Answers
1 2 3 4 5
- - - - - Rate yourself And Have A Kitkat
5 5 5 5 5
I have made a little bit of code which forces a naturally diverging iteration loop to converge to the value I need, excellent, but it currently is controlled by a button which I click to execute it. What I want to do is to automatically run the module when one of the input parameters changes, to find the new equilibrium value. Forgive me if this is really simple stuff, but I just can't figure out how to do it.
View 8 RepliesI have created a database to house a lot of data. I have created a front end application to allow the users to enter the data and it gets checked and then written to the database. The problem I am having is the users have a lot of data that has been kept in Excel sheets and they are wanting to import the data to the database without having to reenter all the data. I have been reading through the different posts trying to find one that will fit my needs and haven't been able to. The old way of putting the data into Excel has now been turned into a few different tables in the database. The database is created off a national standard so it can't be changed. What I am needing to know is how to take data from these Excel sheets and import either into my application and then find a way to covert the data over to where it can go into all the tables that need it or to create something that will write the data directly to the database into the different tables. I am not sure if this is possible but thought this would be the best place to ask the questions.
View 10 RepliesI have created a database to house a lot of data. I have created a front end application to allow the users to enter the data and it gets checked and then written to the database. The problem I am having is the users have a lot of data that has been kept in Excel sheets and they are wanting to import the data to the database without having to reenter all the data.I have been reading through the different posts trying to find one that will fit my needs and haven't been able to. The old way of putting the data into Excel has now been turned into a few different tables in the database. The database is created off a national standard so it can't be changed. What I am needing to know is how to take data from these Excel sheets and import either into my application and then find a way to covert the data over to where it can go into all the tables that need it or to create something that will write the data directly to the database into the different tables.
View 2 RepliesI've found an easy way to import data from excel file to a table in sql server 2000.[code]
View 1 RepliesI would like to upload a excel file to window form and enable to edit and save into mysql database.
I have the problem which unable upload excel file which data consist character ,and it will show form with empty column. It also can not upload the first row data.
[Code]...
I am googling and googling and still can't find right solution for this
View 11 Replies1.) error on saving the data into excel sheet when the program is execute nonquery the bold line below
Try
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim myCommand As New System.Data.OleDb.OleDbCommand
[code].....