Best Visualization Technical Blogs For DNN, PHP, ASP, .net

Hi, If you want to return two tables under one dataSet its very easy, Create procedure yourProcedureName AS Begin Select * from your tableName Select * from your anotherTableName End Regards Rashid Imran Bilgrami CEO Best Visualization http://www.bestvisualization.com

Dear All, The simplest way of create nested datalist with parent child table relation is given below:  protected void loadData()         {            //Note: For Define your connection string i am not writing it because it is in my web.config and i load it through my internal class              DataSet ds = new DataSet();           // my private class that contains sql execute funtions, I pass the SQL parameters and Values through array             UDF myudf = new UDF();             string spName = "bvs_payInvoice";                       string[] field = new string[5];             string[] fieldValue = new string[field.Length];             field[0] = "@startDate"; ...

Hi Every one! Today i found a new experiences, my IIS suddenly crashed and  it gives me the error The Windows Process Activation Service encountered an error trying to read configuration data from file ‘\\?\C:\Windows\system32\inetsrv\config\applicationHost.config’, line number ’0′. The error message is: ‘Configuration file is not well-formed XML’ What i can do simple these step to get rid of this issue The error made because applicationHost.config files are corrupted. First you can copy the backup files from C:\inetpub\history\get the latest history folder copy the file a ) administration.config b) applicationHost.config and past is in to this location C:\Windows\System32\inetsrv\config Restart IIS with your dos command iisreset and your problem will resolved Regards Rashid Bilgrami CEO Best visualization http://www.bestvisualization.com

Dear All Now convert you .ttf font to .svc, oet and .ttf format through online website free http://www.font2web.com/ for converting the font form any font extenshion to ttf use this site http://www.freefontconverter.com/index.php Regards Rashid Imran Bilgrami CEO Best Visualization http://www.bestvisualization.com

Original Post http://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/ Problem Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks.  One of these tasks may be the need to backup all databases on your server.   This is not a big deal if you have a handful of databases, but I have seen several servers where there are 100+ databases on the same instance of SQL Server.  You could use Enterprise Manager to backup the databases or even use Maintenance Plans, but using T-SQL is a much simpler and faster approach. Solution With the use of T-SQL you can generate your backup commands and with the use of cursors you can cursor through all of your databases to back them up one by one.  This is a very straight forward process and you only need a handful of commands to do this.  Here is the script that will allow you to backup each d...

Dear All please check out the HTML 5 demos here  http://html5demos.com/ Regards Rashid Imran Bilgrami CEO Bestvisualization.com http://www.bestvisualization.com 

Dear All If you are facing the problem in login after restoring database the reason is the machine key is not matching. This problem arrived because you are restore the whole website from server to workstations so because of this you will face two problems 1) Login accounts not working 2) Pages will not show for 2nd problem please check my previous blog http://bestvisualization.blogspot.com/2012/05/pages-are-not-accessing-after-restoring.html for login you need to resolve it like this 1) Register with the normal user 2) Open the database table users 3) Assign this user as super host  (Please read this post if you don't know about this step  http://bestvisualization.blogspot.com/2009/11/how-to-reset-dot-net-nuke-dnn-host.html ) 4) Close the database 5) Login with the new user 6) Go to admin > user accounts 7) Click on the pencil and click on password manager 8) Click on the Reset password (system generated random one) 9) Once it done you can assign you...