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

Dear All, I hope every one worked with this control before with .net, yesterday i just use with DNN and i want to share this with you to use the Multiview controller with the control files. Step1:  Register your controls <%@ Register Src="~/DesktopModules/BV Admin GenerateForm/Admin_GenerateForm_01_SelectCustomer.ascx" TagName="step1" TagPrefix="ke" %> <%@ Register Src="~/DesktopModules/BV Admin GenerateForm/Admin_GenerateForm_02_AddParent.ascx" TagName="step2" TagPrefix="ke" %> <%@ Register Src="~/DesktopModules/BV Admin GenerateForm/Admin_GenerateForm_03_AddChild.ascx" TagName="step3" TagPrefix="ke" %> <%@ Register Src="~/DesktopModules/BV Admin GenerateForm/Admin_GenerateForm_04_formPreview.ascx" TagName="step4" TagPrefix="ke" %> <%@ Register Src="~/DesktopModules/BV Admin GenerateForm/Admin_GenerateForm_05_SucessMessage.a

Dear Users, 1. Close Captivate 2. Run 'command prompt (cmd)' in Admin mode 3. Go to the directory where Captivate-4 is installed 4. Run 'regsvr32 NSAudio.dll' 5. You should get a message 'registration of dll successful' 6. Now launch Captivate-4 again and execute your test. Regards  Rashid Imran Bilgrami  http://www.bestvisualization.com  

Dear Readers, Today i share a code which may be help you out once in a blue, last few days back i found i request from my customer about duplicating the record in to new case for saving the time. I have done this through query and i want to share this with you, I hope it will save your time. INSERT INTO Table_Name ( field1, field2, field3,...) SELECT top(1) field1, filed2, filed3, ...  FROM Table_Name  WHERE primaryKey = yourvariable Make sure do not include the primary key + autonumber field in this query. Also you need to make sure the sequence of the inserting field (field1, field2, field3...) will be in same sql field sequence If you want to add any variable in the field here is the sample query Declare @var1 int Declare @var2 int Set @var1 = 1 Set @var2 = 2 insert into Table_Name(field1, field2, field3,...) select * Column_Name, @var1, @var2  from second_table where condition I hope it save your time Regards Rashid Imran Bilgrami http://www.bestvisualiz

Dear All Here is a code for datalist with image / link button control. Also you can get the value of record id when you click on the button under the datalist item Your Ascx file  <asp:DataList ID="DataList1" runat="server" Width="100%" OnItemCommand="Your_Function_Name" >   <ItemTemplate>  <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="/DesktopModules/Tarahum Admin CP - Add New Case/images/deleteNew.png" CommandName="del"   CommandArgument='<%#Eval ("recID") %>' />   </ItemTemplate> Note: Command Arugement is the value that you need to pass on button click and command name is a unique name of this control for code behind ********** Code Behind Function **********  protected void  Your_Function_Name (object source, DataListCommandEventArgs e)         {             if (e.CommandName == "del")             { string

Dear All I normally use this item command for enabling the editing through the Datalist control, right now i spend 4 hours because i didn't get why the itemcommand is not working when i click on the delete button under the Item template then i found the solution I have done the stupid mistake  if (!IsPostBack)             {                 // your loading function             } else             {  // My silly mistake i reload the datalist so remove this from your code it will work fine } Regards Rashid Imran Bilgrami http://www.bestvisualization.com

Dear All Just now i got one error that arrives on clicking on the button under the item template A critical error has occurred. Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation. Here is the solution Add the following line under web.config page <pages enableEventValidation="false"/> if you are using dnn then change the page line with the below line i change true to false     <pages validateRequest="false" enableViewStateMac="true" enableEventValidation="

Dear All, It's a small thing but may be it helps you out, In the below example you did not want to go on code behind to set the value of hidden field just set the value directly through the ASCX databind option I consider you already bind the data in your data list, here is an example for binding the recID value in controller    <ItemTemplate> <asp:HiddenField ID="hfReserved" runat="server" Value='<%#Eval ("recID") %>' /> <asp:ImageButton ID="imgbtnSeat" runat="server" ImageUrl="Images/idlechair.png" CommandArgument='<%#Eval ("recID") %>' CommandName="Change" />                                     </ItemTemplate> Regards Rashid Imran Bilrgrami CEO Best visualization http://www.bestvisualization.com

Dear Friends If you facing the issue regarding to Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list in your .net 4.0 frame based  please run this command to get rid of above mentioned error For 64 bit windows %windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i If I had been on a 32 bit system, it would have looked like the following: %windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i Note: Make sure you can run the command prompt with Administrative right.  Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com 

Dear All, This created goes to one of my new join employee name Fahad Asghar, he find the new thing in dnn that makes the life easy for making the multi pages in one go.. Here is the solution 1) Login with your DNN website 2) Click on the Page Link at the top bar 3) Write all page name under the page management text area here is the criteria for the pages Root Page 1 Root Page 2 >Sub Page 1 Root Page 2 >Sub Page 2 Root Page 2 >>Sub Page 1 of Sub Page 2 >>Sub Page 2 of Sub Page 2 and so on, so you can made different page hierarchy  in one go with dnn Thanks again for Fahad Regards Rashid Imran Bilgrami CEO http://www.bestvisualization.com

This method is very simple as compared to previous one <!-- Graph Script Strat--> <!-- Call Google API -->  <script type="text/javascript" src="http://www.google.com/jsapi"></script>   // Create graph package     <script type="text/javascript">         google.load('visualization', '1', { packages: ['corechart'] });     </script>     <script type="text/javascript"> //  Write my own function         function drawVisualization() {             // Create and populate the data table.           var data = google.visualization.arrayToDataTable([           ['Required Money', 'Number Of People'], //  assigning the value from the code behind           ['Up to 500 SAR', <asp:Literal ID="v1" runat="server"></asp:Literal>],           ['Up to 500 to 1,000 SAR', <asp:Literal ID="v2" runat="se

Hi friends, Today i am sharing how you create a multi chart with Google API  in single page. The code is defined below: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html>     <head>         <title>Google Charts Tutorial</title>         <style type="text/css">             #eventsExample {                 position: relative;             }             #details0, #details1, #details2, #details3 {                 visibility:hidden;                 background: #FFFF7F;                 border: solid 1px;                 width: 350px;                 padding: 5px;                 font-size:smaller;                 position:absolute;                 top: 250px;             }         </style>         <!-- load Google AJAX API -->         <script type="text/javascript" src="http://www.google.com/jsapi"></script>

Hi every one I do the following code for accessing the user control in datalist header Here is the code for you Control HeaderTemplate = DataList1.Controls[0].Controls[0]; DropDownList myDropdown = HeaderTemplate.FindControl("DropDownList1") as DropDownList; myDropdown.SelectedValue.ToString() Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com

Hi every one, If you want to load the js or css file after the page load or after the document.readystate then you must follow the following underneath functions To load a .js or .css file dynamically, in a nutshell, it means using DOM methods to first create a swanky new "SCRIPT" or "LINK" element, assign it the appropriate attributes, and finally, use element.appendChild() to add the element to the desired location within the document tree. It sounds a lot more fancy than it really is. Lets see how it all comes together: function loadjscssfile(filename, filetype){  if (filetype=="js"){ //if filename is a external JavaScript file   var fileref=document.createElement('script')   fileref.setAttribute("type","text/javascript")   fileref.setAttribute("src", filename)  }  else if (filetype=="css"){ //if filename is an external CSS file   var fileref=document.createElement("link")   filer

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";             field[1] = "@endDate";             field[2] = "@searchType";             field[3] = "@keyWord";             field[4] = "@status";                           fieldValue[0] = startDate;             fieldValue[1] = endDate;          

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 database within your instance

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 your own

Dear All After restore the database if your pages are not working then you must login with host and remove the friendly URL option under the DNN host settings Regards Rashid Bilgrami CEO Best visualization http://www.bestvisualization.com  

Dear All, In last days, i spend allot of time in identify the solution of assigning custom schema in sql server, specially when you restore any database which have a custom schema you face lot of problems here is the solution 1) Take a back of your database from online server 2) Restore in to destination place 3) Create a new user in SQL server (in Global security section) 4) Provide login name in Login Name section 5) Provide the password as you need 6) Select the default database that you restore 7) Click on the user map  (Left side 3rd menu) 8) In the restore db row select user under the user column and select schema under the schema column 9) save and close as well as disconnected 10) login with the new created user your schema will work Regards Rashid Bilgrami CEO Best visualization http://www.bestvisualization.com

Dear All I used IIS and PHP from long time but today i just find one issue when i tried to display the PHP error in IIS it's show me blank page, if you face this issue use this  command and check your local php ini settings Open your CMD (command or dos prompt) Make your directory location to C:\ and copy past the below line %windir%\system32\inetsrv\appcmd.exe set config -Section:system.webServer/httpErrors -errorMode:Detailed Restart IIS IN PHP INI error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT display_errors = On and if you logged these error log_errors = On I hope who are using PHP with IIS may be this post helpful for them One more thing make sure when you are writing the code with IIS in PHP you must define Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com

Dear All, Today i got a solution for a very simple solution, may be it save your time. How to Enable Upload Image / Document option under the DNN Text / HTML editor for Register Members or Non register Members Please follow following steps 1) Login with your host account 2) Go to Admin > File Manager 3) At the bottom of the page you will find the permission options 4) Allow write file to ALL Role or Register member Role Login with the normal user and test it you will see the image upload option for every register member or non register member Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  

Replace html pattern to the below line  @"<(.|\n)*?>" Object  <% #Regex.Replace("Your String/ Your Text / Your DB Value" , html pattern, string.Empty)%> Live usage  <%#Regex.Replace(DataBinder.Eval(Container.DataItem, "descriptionVal").ToString(), @"<(.|\n)*?>", string.Empty) %> I hope it helps you allot Regards Rashid Imran Bilgrami CEO Best visualization  http://www.bestvisualization.com

Add the following line with your class name System.Web.SessionState.IRequiresSessionState Example public class UploadHandler : IHttpHandler, System.Web.SessionState.IRequiresSessionState for getting the session value use this context.Session["yourstring"].toString(); I hope it helps you 

Dear  All As per promise i found the solution how to get the latest facebook feeds you need the access token from this url https://developers.facebook.com/tools/access_token/ Get the Graph URL https://graph.facebook.com/Your Page Name/feed?access_token=Your Access token&limit=5 Replace your page name with your facebook page name appears in the URL Access token with your access token that you will generate from the above URL and limit options to show the top 5 records I hope it helps you allot Regards Rashid Imran Bilgrami CEO Bestvisualization http://www.bestvisualization.com

Dear All Facebook update the timeline interface and its really hard now to get the facebook page id before that it was in the URL now because of URL rewriting you can't get it. Today i found the way how you get the facebook page id and lot of things https://developers.facebook.com/docs/reference/fql/page/ FBL is the right place from where you can get your page ID through  Example  https://api.facebook.com/method/fql.query?query=Y our Query You will get the ID ;) Enjoy  My next post will be soon in which you will study how to get the latest facebook updated comments in your website  Regards  Rashid Imran Bilgrami  Best Visualization http://www.bestvisualization.com  

Dear All, This issue i have resolved long time back but forgot to enter in my blog, today i face this issue so i am writing it here to save your time :) If you want to allow your dnn register member to create new blog under the blog module then the solution is very simple 1) Deploy Blog module 2) Once you deploy you will find lot of modules on the page, Go to the "New Blog" Module settings 3) Unchecked the inherit setting under the permissions 4) Check register member as view and edit Now log out with host and logged in as register member to see the create blog link :) Have a nice day Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  

Dear All Today i am telling you how easily you add the facebook like button in your own website. Go to this URL https://developers.facebook.com/docs/reference/plugins/like/ and do the following steps 1) Provide URL 2) Set width 3) Set color scheme 4) Get code Past this code in your HTML head tag between and your like button is ready Regards Rashid Imran Bilgrami http://www.bestvisualization.com 

Dear All, May be lot of people know about it.. I just get the info and share with you guys Regards Rashid Imran Bilgrami http://www.bestvisualization.com

Dear All If you are facing a problem to update the DNN survey module template, then the solution is very simple Just update the latest release 4.7.01  the problem will resolve [This problem only arrive so far in dnn 6.x portals] http://dnnsurvey.codeplex.com/releases/view/71226 Best regards Rashid Imran Bilgrami http://www.bestvisualization.com 

Dear All If you are looking for the translation of dnn container title then there are two solution 1) You can go with the appolo module which helps you to localize the HTML module title (for this see my prior post  http://bestvisualization.blogspot.com/2011/06/multi-language-website-in-dnn-or.html ) 2) If you are developing you own module then use (Specially thanks for Psturdee answer get through dnn forum your module's Page_Init method: protected void Page_Init(object sender, EventArgs e) { this.ModuleConfiguration.ModuleTitle = "Whatever you want your module title to be"; } You can use Resource files to provide the strings with something like this: protected void Page_Init(object sender, EventArgs e) { this.ModuleConfiguration.ModuleTitle = Localization.GetString("ModuleTitle", Localization.GetResourceFile(this, "YourModule.ascx"); } then define in your resource files, "YourModule.ascx.[lang].resx", a name, "Modul

Dear All Today My friend Mr. Furqan tell me about the superb resource for programmer check it out http://www.c-sharpcorner.com/ Regards Rashid Imran Bilgrami http://www.bestvisualizaiton.com 

Dear All It's a small stuff but it make you crazy :) when you tried to copy selected fonts from the windows folder its allow you to copy but when you tried to past in the destination folder the past option will be disable the solution i found is very simple Click on Edit under tool bar and select Copy to folder option All selected fonts will be coping in new destination as well Regards Rashid Bilgrami http://www.bestvisualization.com 

Dear All I found the great SAP abap programming blog the guy did the great job http://www.saphub.com/abap-tutorial/ i hope it help all of those who are looking to work in abap Regards Rashid Imran Bilgrami http://www.bestvisualization.com

Dear All Today i tried to work with the flicker photos to save and retrive the pics from there and i got one great API but when i execute the code it gave me the error "Flickr error 2: Unknown user": After a google research, i wasn't able to find any thing i used my yahoo id there but its also not working then i found one another id which you will see in the right side section of below link use this id and your code will work http://www.flickr.com/services/api/explore/flickr.photos.search make sure your id looks like some number with @N00 this is correct id I hope this will help you in your project Regards Rashid Imran Bilgrami http://www.bestvisualization.com 

I have read some articles written about how some products like Office 2010 by default support not only Hijri Date but also support UmAlQura Date and this good news. This article show you some points related to Arabic language (which is my mother tongue) with Sql Server. In general Sql server deals with any language in the same way except some issues become different from language to other language. So let's begin by Collation and see how Sql Server stored data and retrieve data in Arabic language. What is a Collation? A collation determines the rules SQL Server uses to compare and sort character data and determines which characters can be stored in non-Unicode character data types. Collation can be specified at the instance level, database, column level or clause level. So let's begin by this example to make the points clear: 01.CREATE TABLE [dbo].[Test]( 02.--here stored data as ASCII char 03.[Name_Char_Latain] [char](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

Dear All, I have face the issue yesterday. The problem was at server the full text search was gray out and i am unable to click it Solution:  You update your sql server to advance option and during installation select the full text search option. Regards 3ART.tech http://w ww.3art.tech

Dear All; Ref URL: 3ART Technologies Support Services URL Full Text Index helps to perform complex queries against character data.  These queries can include word or phrase searching. We can create a full-text index on a table or indexed view in a database. Only one full-text index is allowed per table or indexed view. The index can contain up to 1024 columns. Software developer  Monica  who helped with screenshots also informed that this feature works with RTM (Ready to Manufacture) version of SQL Server 2008 and does not work on CTP (Community Technology Preview) versions. To create an Index, follow the steps: Create a Full-Text Catalog Create a Full-Text Index Populate the Index 1)  Create a Full-Text Catalog Full – Text can also be created while creating a Full-Text Index in its Wizard. 2) Create a Full-Text Index 3)  Populate the Index As the Index Is created and populated, you can write the query and