.NET General Forum RSS Feed

Cannot open Excel File from VB2005

Tue, 07 Feb 2012 17:12:23 -0800

Hi, I need help!!!

I developed a program in VB 2005 which opens an Excel file using Interop, and I call it from an SQL Stored Procedure using xp_cmdshell. Everything works fine when I am working under Windows 2003 Server. The problem is when I try to call my program the same way, but under Windows 2008 Server. It throws an exception at the moment my programs tries to open the Excel file. I assumed it was an authentication issue, so I changed the login for the SQL Server Service to an administrator account, and I granted Full Control to Everybody over the folder where the Excel file resides, but the problem persists.

The error message says that the Excel file cannot be accessed because either the file is in use by another program (which it isn't) or the user doesn't have enough privileges.

Same problem happens under Windows 7.

I am using "Microsoft Excel 12.0 Object Library" in my Project.

By the way, I tried to run my program with a double click in windows explorer and it opened the Excel file with no problem. The problem is when I call my program from an SQL Server Stored Procedure using xp_cmdshell.

Any ideas?

Thanks in any advance for your help.

Giovanni @ Guatemala.

Issue with ASP.net when moving web server

Tue, 07 Feb 2012 02:10:08 -0800

Hello,

I have just had to move our website to a new host and the ASP.net part of the web site now fails with the following error - HTTP Error 404.17 - Not Found
The requested content appears to be script and will not be served by the static file handler.

The original host was ASP.net 2, II6 and classic mode the new one is ASP.net 2, II7 and classic mode.

The new hosting company said that it is to do with web.config and I have attached a screen shot they sent me of the handlers.

I program in PHP and I don't have any experience in ASP.net but I am desperate the sort this issue out.

Is there anyone who could possibly tell me what I would need to change in my web.config based on the attachment.

If you require any further information like the web.config file please ask.

I would really appreciate any help here.

Kind Regards

Issue with ASP.net when moving web server

Tue, 07 Feb 2012 02:08:17 -0800

WCF Data Contract

Sun, 05 Feb 2012 00:06:49 -0800

Hi,

I want to send some complex types in WCF response message.
Can any one please help me in finding out a solution for this.

Thanks & regards,

Afreen

WCF Data Contract

Sat, 04 Feb 2012 23:51:51 -0800

Hi,

I want to send some complex types in WCF response message.
Can any one please help me in finding out a solution for this.

Thanks & regards,

Afreen

Digital Image Processing vb.net

Sat, 14 Jan 2012 09:03:09 -0800

I am trying to develop a image processsing application that will analyse some grayscale images, the images in question are basically biological photographs(PCR GEL Photographs) that have some bands which are lighter in shades, and these bands are arranged in some pattern( Mostly linear), Till now, i had suceeded to programatically identify those bands which are distinct and clearly seperated from other band, but the band, which are close, could not be identified as seperate band.
more over my algorithms fails miserably in case case of color photographs,and i am clueless for a better approach.

i will be grateful if somebody out there had any previous experience,to help me out

Digital Image Processing

Sat, 14 Jan 2012 08:58:23 -0800

Wrap text in a column while printing

Sun, 08 Jan 2012 12:37:53 -0800

Hi,

I found a very good piece of code for printing the data gridview. But i am unable to wrap the data in a column if it is too long. Can any one please help me in letting me know what I am missing or how to wrap the data in a column or hide a column

Font fnt = dataGridView.Font;
Pen pen = new Pen(Color.FromArgb(0, 0, 0));
Graphics gfx = e.Graphics;
gfx.PageUnit = System.Drawing.GraphicsUnit.Display;

SolidBrush foreBrush = new SolidBrush(this.dataGridView.DefaultCellStyle.Fore Color);
SolidBrush selectedRowBrush = new SolidBrush(Color.White);

int yMargin = 0;
int xMargin = 0;
int intRowHeight = this.dataGridView.Columns[0].HeaderCell.Size.Heigh t;
int xPoint = xMargin;
int yPoint = yMargin;

int[] colPositions = new int[dataGridView.Columns.Count + 1];
int intCount = 0;
SizeF CaptionSize = gfx.MeasureString(dataGridView.Columns[0].HeaderTe xt, fnt);
Size s = new Size((Convert.ToInt32(CaptionSize.Width) + 1), Convert.ToInt32(CaptionSize.Height));
Rectangle rect = new Rectangle(new Point(xMargin, yMargin), s);
yPoint += s.Height;
yMargin += s.Height;

Font headerFont = new Font(fnt, FontStyle.Bold);
SolidBrush selectedHeaderBrush = new SolidBrush(Color.LightGray);

//Header loop
foreach (DataGridViewColumn dgvc in dataGridView.Columns)
{
if (xPoint < dataGridView.Bounds.Width && xPoint < e.MarginBounds.Right - 100)
{
colPositions[intCount] = xPoint;
Rectangle rectColumn = new Rectangle(xPoint, yMargin, dgvc.Width, fnt.Height);
if (dgvc.Width > 0 && dgvc.HeaderText != string.Empty)
{
gfx.FillRectangle(selectedHeaderBrush, new Rectangle(xPoint, yMargin, dgvc.Width, dgvc.HeaderCell.Size.Height));
xPoint += dgvc.Width;
//Draw Vertical Line of column
gfx.DrawLine(pen, colPositions[intCount], yPoint, colPositions[intCount], yPoint + intRowHeight);
rectColumn = new Rectangle(colPositions[intCount], yPoint + 2, dgvc.Width + 2, fnt.Height + 1);

}

//Prints the column header text.
gfx.DrawString(dgvc.HeaderText, headerFont, Brushes.Black, rectColumn, StringFormat.GenericDefault);
intCount++;
}
else
break;
}
colPositions[intCount] = xPoint;

//end vertical line
gfx.DrawLine(pen, colPositions[intCount], yPoint, colPositions[intCount], yPoint + intRowHeight);

//Draw the first horizontal line.
gfx.DrawLine(pen, xMargin, yPoint, xPoint, yPoint);
yPoint += this.dataGridView.Columns[0].HeaderCell.Size.Heigh t;

//Draw the second horizontal line. After this line data gets printed
gfx.DrawLine(pen, xMargin, yPoint - 1, xPoint, yPoint - 1);
intRowHeight = this.dataGridView.Rows[0].Height;

//Data loop
for (int row = 0; m_gridRowsCount < dataGridView.Rows.Count; row++, m_gridRowsCount++)
{
if (row >= MAXROWSTOPRINT)
{
break;
}
intCount = 0;
foreach (DataGridViewCell dgvc in dataGridView.Rows[m_gridRowsCount].Cells)
{
if (colPositions[intCount] < dataGridView.Bounds.Width && colPositions[intCount] < e.MarginBounds.Right - 100)
{
Rectangle rectColumn = new Rectangle(colPositions[intCount], yPoint, dgvc.Size.Width, fnt.Height);
if (dgvc.Size.Width > 0)
{
gfx.FillRectangle(selectedRowBrush, new Rectangle(colPositions[intCount], yPoint, dgvc.Size.Width, fnt.Height + 4));

//Draw Vertical Line of column
gfx.DrawLine(pen, colPositions[intCount], yPoint, colPositions[intCount], yPoint + intRowHeight);
rectColumn = new Rectangle(colPositions[intCount], yPoint + 2, dgvc.Size.Width + 2, fnt.Height + 1);
}
if (dgvc.ValueType.Equals(typeof(DateTime)) && dgvc.Value != DBNull.Value)
gfx.DrawString(Convert.ToDateTime(dgvc.Value).ToSt ring("dd/MM/yyyy"), fnt, Brushes.Black, rectColumn, StringFormat.GenericDefault);
else
//Prints the column header text.
gfx.DrawString(Convert.ToString(dgvc.Value), fnt, Brushes.Black, rectColumn, StringFormat.GenericDefault);
intCount++;
}
else
break;
}
//Draw the last vertical line.
gfx.DrawLine(pen, colPositions[intCount], yPoint, colPositions[intCount], yPoint + intRowHeight);

yPoint += dataGridView.Rows[m_gridRowsCount].Height;

//if (intCount < colPositions.Length)
//Draw the first horizontal line.
gfx.DrawLine(pen, xMargin, yPoint - 1, colPositions[intCount], yPoint - 1);
}

gfx.Dispose();
e.Graphics.Dispose();
m_noOfPagesToPrint--;
if (m_noOfPagesToPrint <= 0)
{
m_gridRowsCount = m_noOfPagesToPrint = m_printedRows = 0;
m_noOfPagesToPrint = dataGridView.Rows.Count / MAXROWSTOPRINT;
if (dataGridView.Rows.Count % MAXROWSTOPRINT > 0)
m_noOfPagesToPrint++;

e.HasMorePages = false;
}
else
e.HasMorePages = true;

I really miss my mum right now :(:(?

Sat, 07 Jan 2012 22:19:34 -0800

im 15 and i havent seen my mum in nearly 5 years and it feels like forever i cant stop crying. she just didnt come home one night and she didnt phone or try and speak to me or my brother, she was addicted to drugs, that says it all really but i really miss her sometimes (like now) but when anyone asks i say i dont care, i cant talk to anyone or say how im feeling i just want her to tell me shes safe but i dont know how i could find her and its really killing me having to keep this inside me and crying to myself thats why im writing this not that anybody cares i just wanted somewhere no one knows me to put how im feeling

Canada Goose 4565M

Interesting article on Access Control in Multitenant-Applications

Wed, 04 Jan 2012 04:03:39 -0800

Defining "Who sees what" and "who does what" are the two important aspects of access control in any software application.
"Security" is a much larger subject, but this article focuses on just the access control aspects of Security in a software application.

The Older Paradigm - Roles and Page level access controls

When you build a custom application for a specific customer, the access control policies of the organization are often defined upfront as part of the requirements phase. Depending on the vertical, domain and the specific organizational structure of the business, first the roles are defined. And then each role is given access to a set of screens, forms, pages and reports. What role A sees might be different from what role B sees. What role A can do could be different from what role B is allowed to do. Of course, certain areas in the application can be accessed by multiple roles. While building software products (used by several customers), the roles are often generalized and predefined. The various access control policies of the product are often hard coded in to the roles. The customer will be able to assign one or more roles to their users.

The new paradigm - Privilege based Access Controls

In the new paradigm, before doing any action (including showing something on the screen - which is the View action), you check / demand for the privilege to view that information or do a certain action. It could be standard actions such as view, edit and delete or special privileges such as "Access to History Data" or "Access to information or content created by people other than myself. In the new paradigm, a user / roles privileges are resolved during run time - not hard coded at design time. This allows the product developer to complete the development just by demanding the necessary privileges at each step, without having to worry about the users and roles in the system.

Mapping Privileges to Roles

By enumerating the various privileges (entity wise or form wise standard privileges as well as special privileges) in an administration screen, we can allow the end customer to map the privileges to any specific role, during run time. This takes care of dynamic changes in organizational policy. This also allows the end customer to create completely new roles (not originally envisaged by the product designer) dynamically during actual usage and map a set of privileges to these new roles using an admin screen.
For example in a HR product, the product might have default roles such as "Employee" and "Manager" whereas a customer may create a new role called "Team Leader" or "Mentor".

Subsequently, users can be assigned with one or more roles (including new custom roles). So when a user is using the system, the application can resolve who the user is, what his or her role is, what the privileges of the role are - all during run time. So before a particular action, the application can simply check whether the required privilege is available for the user and proceed. While this may seem little challenging from the software design/development front, it will bring in lot of flexibility for the customers.

Relationship based Privileges

Many a time, mapping privileges to roles and assigning roles to users is also not adequate. Let us illustrate this with an example:
userx@abc.com has logged in to a performance management product. She has been assigned the role of a "Manager" and a set of Privileges have been assigned to this role. For example she can add certain new skills in the skills master, which another user with an "Employee" role cannot do.

But the real challenge however is in defining what she can and cannot see and what she can and cannot do with respect to the performance appraisal ratings of various employees.

Out of the 300 people in the organization, userX, is a "Primary Manager" for 4 employees, "Co-Manager for 5 employees", "Mentor" for 5 employees, "Department Head for 40 employees", and "Peer" for 15 employees. She is not related to the rest of the employees in the organization (in the context of performance management)

The privileges of what each of these "Relationships" can and cannot do is different. For example, a Mentor can view performance ratings but cannot edit them. A Primary Manager can edit ratings, but cannot approve them. And a Department head can approve/disapprove ratings, but cannot edit them.
How can we allow userX to login in once, view all the employees related to her in a single grid, but restrict her access depending on the relationship between her and the employee on whom she is performing the action?

Step 1: Define relationships in a master: This could be added / edited by the end customer.
Step 2: Map each privilege to a set of relationships who are to be given this privilege.
Step 3: Resolve the relationship between the user and the employee during run time and accordingly deduce whether the user has or does not have the privilege to do an action.

Static Data Scope

Apart from defining what a role can or cannot do / see, we often also want to restrict the boundaries of the data that the user has access to. For example, "Can edit employee profile information - but - only for people in his division / department", "Can see salary details - but only for employees reporting to her or to her down the line reports". Another example is to say that the Sales manager can access leads / customers only from his territory.
These datascopes should not be hard coded in the product, but should be configurable by an end customer. For each role and privilege mapping, the data scope can also be mapped.

The meanings of these datascopes are defined as "Meta data" which are nothing but Filter conditions. These filter conditions should be dynamically applied on the data set being accessed during run time, depending on the role-privilege-data scope resolved for the user context.

Dynamic Data Scope

This is an extended form of Data scope, where the variable being defined for the data scope is itself defined dynamically.
For example : "HR Administrator" role assigned to "User A" should administer for employees in "Location, P, Q and R" and "HR Administrator" role assigned to "User B" should administer for employees in "Location S, T and V" - where the location itself is user defined by the end customer in a Location Master.

Or , Finance Manager should be able see the books of Divisions "A, B, C and D" where the Divisions itself is user defined by the end customer in a Division master.

Multi-tenant Access Control

When the roles, relationships, privileges, static and dynamic data scopes are user definable by the end customer, and when the sample application serves multiple customers / tenants (from a single instance of the application), then we need to store all these access control configurations - tenant wise. So during run time, we should not only resolve the data scopes-privileges-roles-users, but also apply the tenant context and look up the appropriate tenant specific access control settings, before deciding to allow or disallow a particular action in the application.

Privilege mapping should be possible at the field Level, entity Level, form Level and page Level, so that the end customer / tenant has absolute control and flexibility in defining and modifying "Who sees what" and "Who can do what" in the system.

Tying in Subscription/ License Control with Access Control

Different tenants/ customers/ user groups should be given access or denied access to different modules and features in the product. This depends on the package that they have bought (in a SaaS product) or based on the Organizational Policy (in a Private/ Internal SaaS product).

These modules and features have to be first defined as Meta data and the corresponding page level access controls have to be mapped to them. This will allow the product to hide or show certain menu items and links to users depending on the tenant context and the packages enabled for that tenant/ user group.

Usage Based Quota and Access Control

Many a times tenants are allowed to use the product for a specific no. of users or for a specified quota of usage (For example can do XXX no. of market surveys). These transactions and events have to be metered in the product, and once the defined quota is exceeded, the access control system should deny access to any user belonging to that tenant / user group.

Summary

The Access Control Paradigm of a Multi - tenant Application/ SaaS Product, should enlarge its frame of reference to include extensive customizability and configurability to suit different customers and organizations while still maintaining a single instance and code base.
The engineering stack of a Multi - tenant SaaS product, should have a robust and flexible Access Control layer, so that all the dynamic and run time capabilities are handled at the framework level. The developer then can focus on building the business functions, follow the guidelines provided by the underlying framework and demand a privilege before doing any significant action.

Ramkumar R S
Director – Product Management
About author
Ramkumar is the Founder and Director of Mango DVM, a venture capital funded company in the digital music space, currently going through a third round of funding. He is also the Director of Product Management at Asteor Software Inc, where he was instrumental in incubating and bringing to market two new software products (Techcello & Synergita). He is also the Director of RSR Innovations, a consultancy firm specializing on Strategic Marketing, Innovation and Leadership Development. Before becoming an entrepreneur, Ramkumar had spent over two decades in various corporates; in functions such as Automation Engineering, Project management, Product management, Marketing and General management.

Transperancy key not working properly

Tue, 20 Dec 2011 16:51:44 -0800

Hi All,

I am having a problem with creating a tranperent background color for my form.
I used the transperency key with the same color as the background color of my form, but there is a known microsoft bug on this issue.
When working with color depth greater the 24bit -> it won't work all the time.
I have a windows XP with 32bit that does not support the transperancy. When changing it to 16bit - works. On another XP, it works fine with 32bit.
Microsoft published a known bug and workaround that does not seem to work for me:
http://support.microsoft.com/kb/822495

Found another post that I found, which says that he found a solution, missing some explanation:
http://www.megasolutions.net/cSharp/Windows-forms-with-Transparent-Backgrounds-53797.aspx

Did someone experienced this issue as well or can make out the solution from the second post ?

Thanks in advance
Calanit

This post has been deleted.

Tue, 20 Dec 2011 16:49:50 -0800

This post has been deleted.

Please Help - Convert This Excel Code To VB.NET

Thu, 15 Dec 2011 18:05:27 -0800

Hello All,

I have an application I am writing. I have been searching for a solution to what I am doing. I ran across this code for Excel. It does on a Cell, what I need on a string. Can anyone show how this code would look for VB.NET 2010 and for a sting, not a cell.

Function ExtractNumber(rCell As Range, _
     Optional Take_decimal As Boolean, Optional Take_negative As Boolean) As Double

    

Dim iCount As Integer, i As Integer, iLoop As Integer

    Dim sText As String, strNeg As String, strDec As String

    Dim lNum As String

    Dim vVal, vVal2

     

     ''''''''''''''''''''''''''''''''''''''''''

     'Written by OzGrid Business Applications

     'www.ozgrid.com

     

     'Extracts a number from a cell containing text and numbers.

     ''''''''''''''''''''''''''''''''''''''''''

    sText = rCell

    If Take_decimal = True And Take_negative = True Then

        strNeg = "-" 'Negative Sign MUST be before 1st number.

        strDec = "."

    ElseIf Take_decimal = True And Take_negative = False Then

        strNeg = vbNullString

        strDec = "."

    ElseIf Take_decimal = False And Take_negative = True Then

        strNeg = "-"

        strDec = vbNullString

    End If

    iLoop = Len(sText)

        

            For iCount = iLoop To 1 Step -1

            vVal = Mid(sText, iCount, 1)

            

    

                If IsNumeric(vVal) Or vVal = strNeg Or vVal = strDec Then

                    i = i + 1

                    lNum = Mid(sText, iCount, 1) & lNum

                        If IsNumeric(lNum) Then

                            If CDbl(lNum) < 0 Then Exit For

                        Else

                          lNum = Replace(lNum, Left(lNum, 1), "", , 1)

                        End If

                End If

                 

                If i = 1 And lNum <> vbNullString Then lNum = CDbl(Mid(lNum, 1, 1))

            Next iCount

        

     

    ExtractNumber = CDbl(lNum)

     

End Function

Thank You All In Advance

This post has been deleted.

Thu, 15 Dec 2011 18:03:36 -0800

This post has been deleted.

"Version 2.0 is not a compatible version" from VB host

Tue, 29 Nov 2011 12:34:15 -0800

We are taking steps to upgarde our very large project to from VC++ 6.0 and VB 6.0 to .Net. One of the first steps was to replace a COM module with .Net assembly. To avoid having to rewrite the many calling programs, the COM module was also rewritten as a thin wrapper around the .Net libary.

The COM object (written with VC++ 2008), which is a thin wrapper around a .Net assembly (C# 2008, .Net 3.5) runs correctly from a C++ 6.0 host program but will not load from a VB 6.0 host program, immediately producing a "Version 2.0 is not a compatible version" error instead.

Any ideas why the language of the host program matters and what causes a "Version 2.0 is not a compatible version" error?

Even a better description of a "Version 2.0 is not a compatible version" error could be helpful.

"Version 2.0 is not a compatible version" from VB

Tue, 29 Nov 2011 12:30:44 -0800

Webinar : Building Multi-tenant SaaS Applications

Wed, 09 Nov 2011 00:08:02 -0800

Webinar : Building Multi-tenant SaaS Applications
Brought to you by Symphony Services and Techcello

November 16, 2011 at 10:00 AM PST

Registration : https://www1.gotomeeting.com/register/419842065

A multi-tenant architecture is the core of a SaaS (Software-as-a-service) application. However the success of a SaaS application relies on the way it is engineered, deployed and managed.

Symphony has partnered with TechCello to bring multi-tenancy frameworks for .NET-based SaaS migrations that cut down migration and development cycles by 30 - 40%, further accelerating the time to market for these applications. Learn how organizations can use TechCello's CelloSaaS framework combined with Symphony's product engineering services to quickly migrate to a contemporary SaaS platform.

Attendees of this webinar will learn about:

• Product engineering considerations of SaaS applications
• Deploying SaaS applications in the cloud
• Solving technical challenges involved with multi-tenancy
• Benefiting from multi-tenant frameworks

multiple mouse emulation for vb.net

Thu, 27 Oct 2011 15:46:09 -0800

anyone know of a way to emulate multiple mouses in vb.net?
my purpose is to create add/create pointers for mouse mischief and wish to move them around and getting them to left click.
Im want to do this for my kinectmultipoint project which soon i will implement in my soon.
The project is for emulating each person on the kinect as a mouse so they can use mouse mischief without the mouse devices being plugged in.

multiple mouse emulation for vb.net

Thu, 27 Oct 2011 15:44:18 -0800

ping g20 driver

Wed, 19 Oct 2011 01:56:40 -0800

Geoff Ogilvy has been very difficult today. [url=http://www.chinadiscountgolf.com/ping-g20-driver_p17653.html]ping g20 driver[/url] Former U.S. Open champion in the flint most likely hole: the par-five second time behind only two, but 35 feet from the hole he has appeared four-putt, and bogeyed the last row, [url=http://www.chinadiscountgolf.com/mizuno-mp69-irons-39-p_p18126.html]mizuno mp-69 irons[/url] to produce 70, after two rounds the score was only 138, two under par, tied for 27th. Lee Westwood has got psychological guidance of Bob Rotella and putting tips of Dave Stockton, [url=http://www.chinadiscountgolf.com/titleist-ap2-712-irons-2012_p17671.html]Titleist 712 AP2 Irons[/url] he had also in the ranks of the title race, but the last 6 He lost four holes, after the surrender of 71, [url=http://www.chinadiscountgolf.com/taylor-made-r11-driver_p17633.html]TaylorMade R11 Driver[/url] and dropped to tied 27th. Saturday's starting time will be in advance, because the weather forecast said there will be thunderstorms possible. [url=http://www.chinadiscountgolf.com/ping-k15-fairway-woods_p17465.html]Ping K15 Fairway Wood[/url] In other words, Saturday is estimated that in the end take a long time to determine who can win the dominant position in the Bridgestone Invitational - PGA Championship. [url=http://www.chinadiscountgolf.com/callaway-razr-x-irons-39-ps_p17422.html]callaway razr x irons[/url] Well, in front of his players immediately have to start the sprint. Into the weekend, four distributed within the range of 24 athletes, [url=http://www.chinadiscountgolf.com/taylormade-r11-irons-49-psa_p17665.html]taylormade r11 irons[/url] including U.S. Open champion Michael Roy and Steve Stricker. They are only just behind the leader 3.

ping g20 driver

Wed, 19 Oct 2011 01:54:49 -0800

Text file reading

Mon, 10 Oct 2011 01:54:53 -0800

Hi,

I have one text file having the data in the below format

AA| 12
BB | 15
CC| 10
AA|20
...
...
...
...

in this format first value(AA) is some name and second value (12) is count . so in my requirement i want to read that text file and want to check with the first column in the first line with all other lines in the first column ,if any match is found then the count of the first column shouuld be added to the match column's count.i.e.
AA in first line value is matched with fourth line first column then count of the second column in the first line will be 32 (12 +20).

please help me out for the solution,.

Thanks.

Text file reading

Mon, 10 Oct 2011 01:53:03 -0800

Hi,

I have one text file having the data in the below format

AA| 12
BB | 15
CC| 10
AA|20
...
...
...
...

in this format first value(AA) is some name and second value (12) is count . so in my requirement i want to read that text file and want to check with the first column in the first line with all other lines in the first column ,if any match is found then the count of the first column shouuld be added to the match column's count.i.e.
AA in first line value is matched with fourth line first column then count of the first column will be 32 (12 +20).

please help me out for the solution,.

Thanks.

How to compare two Date values in two different columns of a table

Wed, 21 Sep 2011 01:24:10 -0800

Hi,

My application is in VS2008 coded in vb.net.I have a table with three columns

FromDate,Todate and Schedule.FromDate and ToDate will have date values whereas Schedule will have a any of these values(weekly,Monthly,Yearly)

In my Form i have given some provision to the user to check the records.My requirement is The currentdate that is Today's date should be compared with the values of Fromdate and ToDate.First it should be check whether Schedule value is Weekly or Monthly or Yearly.If it is weekly than it should check the record in between fromDate to ToDate with a increment of one week.That means it should first check the first value of fromDate than add 7 days to the value and then again check from fromDate and this should continue till it reaches Todate.

Im trying something like this but its not giving me good logic.

 If Schedule = "Weekly" Then
 While Today >= FromDate And Today<= ToDate
 If Today = fromDate Then
  My application Code here
  End If
  fromDate.AddDays(7)
  End While
  End If

I dont think its making any sense.

Please Guide at the earliest.

Technical Stacks of a Multi-tenant SaaS product - Webinar (2 Hours)

Fri, 09 Sep 2011 22:28:45 -0800

Advanced 2 hour session for Architects and CTOs (Asia Pacific)

Thursday 15th Sep 2011, 10 AM to 12 Noon IST (GMT + 5.30)

A Multi-tenant application architecture allows a single instance of the application and database to serve multiple tenants / customers / user groups. A True Multi-tenant architecture not only isolates data between tenants, but also allows extensive customization and configuration of the product to suit different customers / user groups without having to change the underlying code base.

Multi-tenancy Maturity Models
Multi-tenancy at different layers : Infrastructure, Database and Application
Technical Challenges
Development Stacks
Multi-tenant Plumbing Stack
Multi-tenant Data Connection Abstraction
Multi-tenant Security : Authentication, Encryption, Audit Trail
Multi-tenant Security : Access Control, Role and Privileges Management
Multi-tenant Customization : Views, Data models, Custom Fields
Multi-tenant Customization : Business rules and Workflows
Multi-tenant Customization : Adhoc builders for Reports, Charts, Widgets
Multi-tenant Notification and Schedulers
Multi-tenant Feature / Package / Subscription Management
Metering, Billing and Price Book Management
Tenant and User Management
Bulk Import, Export and Data Management utilities
Multi-tenant SaaS Framework: Build vs Buy