This question is the follow-up of a a desire to architect a simple spreadsheet API while keeping it user-friendly to those who know Excel well.
To sum it up, this question is related to these below two:
1. How to implement column self-naming from its index?;
2. How to make this custom worksheet initialization faster?.
[Code]...
I have a problem in this Routine(VB2008) :
Dim PubAry(2) As Object
Dim cc(2) As Double
cc(0) = 3.0 : cc(1) = 33.0 : cc(2) = 333.0
PubAry(0) = cc
[CODE]...
The result is:
- pubAry {Length=3} Object()
- (0) {System.Array} Object
- Double() {System.Array} Object
(0) 4.0 Double
(1) 44.0 Double
(2) 444.0 Double
- (1) {System.Array} Object
[CODE]...
Its like Excel Sheet Cells Relations !... Why?
I am trying to figure out how to dispay and print certain cells from an excel sheet into a vb program. i am not sure on where to start. It is a large spreadsheet but i need the ability to call a certain persons name and the information for that person then print it out.
View 5 RepliesBasically, i have to write a small application that just writes in certain cells of a set page of an excel sheet, the sheet will always be the same layout.
View 2 RepliesWith an excel file opened, i'm trying to:
Select a Range of Non-Contiguous Cells within a Column, then return the address of the last active cell.
Below, is what I have so far: Note the section maked:
' I can't get the next bit to work: '
To make it work, so far :(
1. Create a new Project using VS-2010.
2. By default, the form should be displayed as "Form1.vb".
3. Add a Label (No need to name or set anything).
4. Add two buttons (Again, No need to name or set anything).
5. Double click on the Form...
6. With the form code displayed, Select all, then paste the following.
'Option Strict Off
'Option Explicit On
Imports System.IO
[Code].....
I have been trying to find the last filled column row in a sheet using this.
clast = xlapp.ActiveSheet.Cells.Find("*", SearchOrder:=XlSearchOrder.xlByColumns, SearchDirection:=XlSearchDirection.xlPrevious).Column
rlast = xlapp.ActiveSheet.Cells.Find("*", SearchOrder:=XlSearchOrder.xlByColumns, SearchDirection:=XlSearchDirection.xlPrevious).Row
im looking for the method how can i copy from original sheet to my new sheet.
View 3 Replies[code] objExcelAppDataSheet is the excel application's object and strTemplatePath is the path of the excel file.This excel file is like a template that i am using in my application. In this file some cells are merged. After copying to the new sheet the formatting of the sheet does not remain same. Columns sizes are changing. Why this problems occurs? Is this MS office versions issue??
View 2 RepliesI need a code to read a omr sheet without using a specific omr sheet reader. i want to use normal scanner for this.
View 2 RepliesMy main goal is to have an excel spreadsheet that automatically plots the overall success of my stock portfolio over time (% change over time). I've been able to incorporate stock data into my spreadsheet by linking it to the web, but the trouble is the spreadsheet will keep no history of what the previous stock values were, so I can't graph how things change over time. This sounds like it might be too complicated to be built in to excel, so I was wondering if anyone knew how to program this in Visual Basic. Maybe something like this.... If refresh then new cell plus new time stamp. Another possibility would be to have a whole bunch of cells that refresh only once but at longer and longer intervals, e.g.,
[Code]...
I have a DataTable and want to connect the cells of one of its columns to cells in some other DataTables.
For example:
DataTable1.Rows(0).Item(2) is connected to DataTable2.Rows(4).Item(6)
DataTable1.Rows(1).Item(2) is connected to DataTable4.Rows(2).Item(3)
DataTable1.Rows(2).Item(2) is connected to DataTable3.Rows(11).Item(4)
...
How can I do this?
I was wondering does anyone know where i can find some good books and or articles covering the architecture and design of OOP applications. Also I need a book that explains how to structure an application as it relates to the data tier, business logic tier, and the front end.
View 6 RepliesIn the first comment (by J.W.) to this question: Using ObjectDataSource and DataObjectTypeName, How Do You Handle Delete Methods With Just An Id Parameter?, it is said that using ObjectDataSource is a bad design. What is considered good design for well-architected ASP.NET applications?
View 1 RepliesTo write a effecient Active Directory library to ease the work of technicals who are responsible to create access models into the domain controller's Active Directory. This library must allow the following:Basic operations: Add, Modify, Delete, List entries;An entry may either be an organizational unit, group or user (no further need required as of now);I thought about having a class which would represent the domain with which we want to work with.
public class Domain {
public Domain(string root) {
Root = root;
[code].....
We have a small visual basic 6.0 application with an Access DB that we would like to migrate to modern code and architecture. I am not technical, but I am believe this would be something like a .net framework with a SQL Server DB.What I am wondering about, is there any way to covert this code to a modern language/architecture? If so, what is the easist modern language to migrate to?
View 7 Replieswhat is a disconnected architecture in dot net?Why are the dataSets a disconnected architectures in dot net?
View 15 RepliesWhen trying to determine the Architecture of an OS, I ran across IntPtr.From reading the documentation, I saw this: Quote:The IntPtr type is designed to be an integer whose size is platform-specific. That is, an instance of this type is expected to be 32-bits on 32-bit hardware and operating systems, and 64-bits on 64-bit hardware and operating systems.
Since the size of IntPtr is intended to be the size of the architecture, would it be feasible to test the size and determine the OS by that? Or is there a better way?
I was thinking there might also be a way via WMI, but I don't want to use that for compatibility reason.
Is there a way to programatically determine if the OS Architecture is 32-bit or 64 -bit?
View 5 RepliesAre there any IP Address filters or masks available in Windows Forms as per following screenshot? A backslash shouldn't be allowed or it should be filtered somehow.
View 1 RepliesI need to write an app that that will iterate over our database, and perform various anaylsis on each record. In order to do this (partially for the learning exercise in creating plugin support) I want to use a Plugin model.
Currently, I have a simple Interface in my main app, which plugins can Implement. My app then loads all DLL's in a folder looking for ones implementing the Interface.
As you can see in the pseudo-code below, I have to keep performing a loop through all loaded plugins calling the process methods.
Sub ProcessData()
For Each Record In MyDataSet
For Each Plugin In MyPluginCollection
[Code].....
I am beginner in programming and developed an application of mine. Although, I am finished with the coding part, but I have to present my software architecture diagram. I am not a software engineer and so familiar with basics of software engineering, layering etc.I have used 1) .NET GDI Graphics in my application, 2) Text to Speech, 3) RichTextBox which retireives pictures etc. How do I proceed with the architecture diagram now?
View 1 RepliesI am working on a new domain model for an application that will have order processing for items built in (well, too keep it simple for this question anyway). I have a class "VendorItem" that represents items that can be ordered. Originally the "Order" class was going to have a list of VendorItems associated with it, but I have come across problems with it so far.
Let's say that the system has been creating orders for some time just fine. One day a user comes along and decides that a vendoritem has changed price or some other detail like packaging size. I wouldn't want the previous orders to be affected by such change. At first wash I was going to make a "OrderLine" class that is basically a copy of the "VendorItem" class, but that just feels (smells?) wrong in the OO sense. Is there a better way to refactor this so I don't have copies of classes and information in the domain model?
I have a large application that has always existed all in a single .NET project up until recently (200,000+ LOC). I'm finally getting to the point where I can fix this. I just started using the Entity Framework (4.1 using code first) and I believe this is a good time to start seperating my logic.
What I did is I separated my application into three subprojects:UI - Windows forms project Business - The POCO classes Data - Legacy data access code AND the DBContext class to connect my POCO classes to the database. I also have a Windows service project and will soon have a WCF project, but those concern me less.
The problem is that in this plan, the data layer depends on the business layer and vice versa causing a circular reference error. There is no way around this.So, my idea is to move my POCO classes into the data layer removing all business logic first (just keeping the database fields, basically). Then, I will inherit from those classes in the business layer adding back all the business rules. Then my data access layer will not rely on any other project, the business layer will rely just on the data access layer, and the interface layer will rely on both for now but eventually only on the business layer.
Does anyone see any problems with this, or a better way of doing things given my current circumstances?
Explain Singleton architecture of Remoting.
View 1 RepliesI need help in understanding this architecture. The person who wrote it is long gone and I'm stuck to figure it out. We are creating an object in some code from some random workflow in the web application (unimportant for my question). The object is being instantiated from a class found in a Designer.vb file. I couldn't initially see the file until I clicked the "show all files" in Solution Explorer in Visual Studio. There are 3 files linked together.. a *.xsd file, a *.Designer.vb file and a *.xsx file. The *.Designer.vb file looks to be auto-generated.
Goal:Get dbo.note.text from the dbo.note table column and place it in the dbo.exportnote.text column. I just don't understand how it's connecting to the database and getting the data from the dbo.note.text field. I want to make the query more specific (possibly put a where clause on it). But really I just want to understand how it's communicating with the database. Most of the code uses stored procedures. So I'm confused on the architecture. What would be really cool is if you can explain how this code was autogenerated. It appears that the *.xsd file is an XML file when I "View in Browser" from the Solution Explorer.Code to instantiate object of designer class:
[code]...
Using VB.NET 2008 I want to know what is 3 Tier Architecture for windows application? How to make a code for Inserting, Deleting, Updating in a database using 3 tier architecture.
View 5 RepliesSocketException was Unhandled: Only one usage of each socket address (protocol/network address/port) is normally permitted I get this error every time i click collect a second time.
[Code]...
Can anyone point me to some code which can help obtain the network address from the host IP and subnet mask?
View 3 RepliesI am in process of designing an architecture for an application. Following is the high level requirement.
1. The basic requirement is to convert a flat file into XML
2. The input flat file can have various formats, the delimiters, the data positions may vary.
3. The output XML format is predefined. There is a specification defined in a word format, which I think I need to define it as an XSL or XSD.
I am planning to follow some design pattern. Not decided yet. The architecture should be flexible to extend the input file formats and accommodate any changes in output specification.
Building a large application using 3 tier architecture in vb.net. Question: I am a vb.net developer. I have developed small and medium size application with 2 tier architecture. Now I am going to develop a large application. I have decided to develop that application using 3 tier architecture. So I studied about 3 tier. Now I know how what is 3 tier and how to develop a simple application. And also I studied about .Net Remoting and Web services. In my project, 7 modules are available. Each module has 3 layers. How can I manage in a Single Solution?
View 1 Replies