Darshan Marathe's Blog

Installing DOTNETNUKE On a remote shared hosting environment

2011-07-16T10:58:00.000-07:00

Installing DOTNETNUKE On a remote shared hosting environment

Create A DB On the Remote Server
Add Right Portal Alias to the local db with the help DotNetNuke CMS
Upload Installation files with the FTP Client
Copy Schema with Sql compare
Copy Data With Sql Data Compare
Manually Copy the PortalLocalisation Records
Change the connectionString of the Website and test

1> Create the DB with your Control panel create a user on the same

2> Add Portal Alias with the Help of Host Account in DotNetnuke CMS Admin >> Site Settings >> Advance Settings >> Add new portal Alias

3> Connect your website with the help of FTP and Upload All files then go on and delete the files from Remote Server Portals\0\Cache\Modules\

4> Copy Schema With Sql Compare

5> Copy Data With SQL Compare

(You can restore the backup on your server if you know how to do it but to save time you can use sql compare)

(Also to use SQL Compare your remote sql server port should be open)

5> Manually Copy the Records In PortalLocalisation Table And Any Other table Which is Failed in SQL Data Compare

7> Change the connection String And Walla you are good to go

AspNet 4.0 Samples Released

2011-07-15T04:52:00.000-07:00

I have released a new project on codeplex which shows many example of ASP.NET 4.0 Features
All Examples have code snippets and you can download and immediately get started.

Just download from

http://aspnet40samples.codeplex.com/

And Enjoy learning the best of ASP.net Webform Features

Chart Controls
Meta Data (SEO)
Permant Redirect
URL Routing With Coding
URL Routing With Declaring
URL Routing Outbound
Auto start
Clean Web.Config files
Predictable ClientIDS
Selective ViewState
Htm The HtmlEncoder Utility Medthod
New Rendering Option for Check Box and Radio Button Lists
Persistent GridView Row Selection
Table Free Templated Controls
Easy State Compression
Tableless Menu Control
Imperative JavaScript Syntax
The ScriptLoader
jQuery Syntax for Microsoft Ajax
AJAX Data Templates
Hidden Field Divs
Disabled Control Styling
Managing ViewState with ViewStateMode

2010-01-18T06:58:00.001-08:00

Hi Friends

Short URL Starter kit released on Web

Just released a new tool for creating short url web sites
It has great features just plug your design and you are ready to go

Codeplex page
http://shorturl.codeplex.com/

Download page
http://shorturl.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=38480

And the great roadmap from here
http://shorturl.codeplex.com/Thread/View.aspx?ThreadId=80404

The Current version is Alfa 2

Check it out and own your own
tinyurl or shrinkster like website

JQuery Master Class Syllabus

2009-10-07T00:57:00.000-07:00

Chat Application Based On SQLITE

2009-07-30T06:21:00.001-07:00

Wanted to have my small AJAX based application which can be deployed
anywhere so created that in application in asp.net Microsoft AJAX +
Session And Application objects

Worked fine but then i though it
will add additional load on the server as it uses the Application
object Also i was using the Asp.Net AJAX Update Panel for the same
which was not a good idea at all for a slick AJAX application

So.........
did some re-thinking of on this application and changed the way to
store the chat i used the sqLite DB for storing the chat log and to
slick down the AJAX call i used AJAX.Net pro i have not provided the
links cause i want you guys to google it a bit

This chat application Includes a Captcha Control Also to avoid machine attacks

The Demo you can see on
www.saket.somee.com

And Download the same from
www.saket.somee.com/ChatClient.zip

Final List of tools used to create this chat application

Asp.net 2.0
Ajax.net Pro
Jquery
Jquery ScrollTo PlugIn
Sqlite db
Firefox Sqlite Manager Add on
Sqlite DB provider

Great Javascript IDE Aptana

2009-07-28T03:45:00.000-07:00

Hi folks

I Would love to share this info on a great IDE which is eclipse based

http://www.aptana.com/

Download it and use it for many purpose

the coolest feature which i like that it tells me that this javascript will work on IE or FF It include many popular js libs like JQuery

you can also use it for
PHP
Ruby On rails
Python
Adobe Air
And IPhone Development

Regards
Darshan Marathe

AppSettings in sql database

2007-08-22T00:28:00.000-07:00

Solving Cross db Query db Name Issue
Maintain the db names in a custom Appsettings table

Introduction

sometimes you need to attach your databases as db_test or something which is other than original db name.

Workaround in vb days
Picking db Name from Ini

Workaround in .net days
Picking db Name from config files

But now we are also taking advantage of database programetibilty and we have queries like this
dbname.dbo.tableName

Workaround

1> Add a Setting Table in each database

Create Table dbSettings
(
key Nvarchar(10) Primary Key,
Value Nvarchar(30)

)

2> Insert the values

Insert Into dbSettings values('Brochure','Brochure_TT')
Insert Into dbSettings values('FIt','Fit_TT')
Insert Into dbSettings values('MIS','MIS_TT')
Insert Into dbSettings values('Invoice','Invoice_TT')
Insert Into dbSettings values('Presets','Presets_TT')
Insert Into dbSettings values('mydb','mydb_TT')

3> Add Function to get thease values

CREATE FUNCTION dbo.getdbSettings

(

@Key as Nvarchar(10)

)

RETURNS Nvarchar(30)

AS

BEGIN

Declare @Result as Nvarchar(30)
Select @Result = Value From dbSettings Where Key = @db
Return @Result

END

Now While Writing the Stored procedure

Replace
mydb.dbo.TableName

With
"+ dbo.getdbSettings('mydb') +".dbo.TableName

It works fine

Please suggest any other workarounds

Regards
Darshan Marathe