Here You Go!!!!!!

To check column name in a database

2012-02-10T15:10:00.000-08:00

If you know column name but to find out which table has that
Do this:
Select Name from sysobjects where id in (select id from syscolumns where name like '%userid%')

Telerik Error Creating Control

2011-05-11T20:53:00.000-07:00

Error Creating Control ....

PublicKeyToken=121fae78165ba3d4'

On visual studio if you are not able to view the Telerik controls and if it shows the above follow these steps

1) Copy Telerik.Web.design.dll to the Bin folder of your application. No need to add a reference to the web application just copy it.

2) Search ProjectAssemblies folder under C:\Documents and settings\\ and delete the folder or If Vista or Win7 search it under c:\Users\

3) Restart Visual studio

RadtreeView Nodes Font size Font size increases when Expanding

2011-02-24T07:13:00.000-08:00

When you click on the expand button to view the child nodes the font of the child nodes are increased for each node. And you dont want to display in the increasing order and everythign should be in xx-small,
Ex:
Root(xx-small)
- Child1(x-small)
-Child1-1(Small)
- child1-1-1(Medium)


< style="FONT-SIZE: xx-small">
< id="rtvTreeView" runat="server" checkboxes="true" size="XX-Small" onnodeexpand="rtvTreeView_NodeExpand" enabledraganddrop="True" enabledraganddropbetweennodes="True" onnodedrop="rtvTreeView_NodeDrop">
< type="InQuint" duration="100">< /collapseanimation>
< type="None" duration="100">< /expandanimation>
< /telerik:radtreeview>
< /div>

Even if you give the Font-size XX-small in div or inside the telerik :radtreeview tag it wont take it.So assignt the Font size before binding to the each node.


Telerik.Web.UI.RadTreeNode subnode = new Telerik.Web.UI.RadTreeNode(fullname, userid.ToString());
                subnode.Attributes.Add("nodetype", "user");
                subnode.ExpandMode = Telerik.Web.UI.TreeNodeExpandMode.ServerSideCallBack;
                subnode.Checkable = false;
                subnode.Font.Size= FontUnit.xx-small;
                parentnode.Nodes.Add(subnode);

Ltrim Rtrim not working

2010-10-11T14:30:00.000-07:00

In Sql server when you find ltrim and rtrim is not working.Then it must be some ascii characters added to it.
You can find the ascii characters

DECLARE @Val VARCHAR(50)
DECLARE @i INT

SET @Val = 'Pastehere '
SET @i = 0

WHILE @i <= DATALENGTH(@Val)
BEGIN
PRINT SUBSTRING(@Val, @i, 1) + ' : ' + CAST(ASCII(SUBSTRING(@Val, @i, 1)) AS VARCHAR(3))
SET @i = @i + 1
END

Once you find the ascii characters replace it with space '' or char(32)
update REPLACE(City,CHAR(160),''),City from tblAddress where id=140
Then
Trim it
update ltrim(rtrim(City))from tblAddress where id=140

How to Download a report without opening the report viewer-Sql Server Reporting 2005

2010-05-10T14:35:00.000-07:00

If you are displaying your reports in aspx page
you should know the following
1) Report Server name
2) Report Path
3) Report Name
4) Parameters


<a href="http://reportservername/ReportsServer?folder%20name/reportname/rs:Command=Renderrs:format=EXCELparameter=parametervalue">Download</a>

Function to return start of the week

2010-03-05T12:50:00.001-08:00

You might wonder how to get the start of the week.
You have a datetime column value and you want to get get the start week of that date
Say for e.g:
today is march 5th 2010 and the week starts from 1st of march 2010 which is Monday
In order to do that create one function and call this function in your store procedure
code


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create FUNCTION [dbo].[fn_startweek]
(@REPORT_DATE DATETIME)
RETURNS varchar(30)
AS
BEGIN
DECLARE @WEEK_BEGINING VARCHAR(10)

DECLARE @WEEK_START_DATE DATETIME, @WEEK_END_DATE DATETIME
--GET THE WEEK START DATE
SELECT  @WEEK_START_DATE = @REPORT_DATE - (DATEPART(DW,  @REPORT_DATE) - 1)

--GET THE WEEK END DATE
SELECT  @WEEK_END_DATE = @REPORT_DATE + (7 - DATEPART(DW,  @REPORT_DATE))

return CONVERT(VARCHAR, @WEEK_START_DATE,101)
end

To call this function:

select dbo.fn_startweek ('2010-03-05 14:51:47.840') //pass the datetime value or a.datecolumnStartdate

Windows cannot load the device driver for this hardware. The driver may be corrupted or missing. (Code 39)

2010-01-11T10:19:00.000-08:00

If you have a Creative WebCam Vista webcamera and you come across this error message

"Windows cannot load the device driver for this hardware. The driver may be corrupted or missing. (Code 39)"

Delete the UpperFilters and LowerFilters registry values, follow these steps:

1. Start Registry Editor (Regedit.exe).
START > RUN > (Type) REGEDIT (and hit ENTER)

2. Locate the UpperFilters and LowerFilters value under the following key in the registry
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Class\{6BDD1FC6-810F-11D0-BEC7-08002BE2092F}

3. On the Edit menu, click Delete, and then click OK.

Goto Device Manager in Windows XP > IMAGING DEVICES > CREATIVE WEBCAM LIVE! ULTRA then right mouseclick and chose DISABLE.Right mouse click again and chose ENABLE.

It will work and it worked for my friend.

How to find the .Net version Programatically

2010-01-05T08:54:00.000-08:00

You might come across how to find the .Net version programatically.

You can find it by :

Response.Write(Environment.Version.ToString)

Adding date to filename in report subscription

2009-12-28T13:43:00.000-08:00

In report Subscription,i.e sending the report as an email at specific time or uploading the report file in ftp server,you might add custom filename or Custom subject in an email.
Like ReportName executed on 1-1-2010
reportName1-1-2010.xls

In order to achieve this you can add @timestamp next to the Filename

Report Delivery Options

Specify options for report delivery.

Delivered by:

Filename :reportName@timeshare

If it is in Subject of the email then you have to update here

Report Delivery Options

Specify options for report delivery.

Delivered by:

To:

Cc:

Bcc:

(Use (;) to separate multiple e-mail addresses.)

Reply-To:

Subject:

Include Report

Render Format:

Include Link

Excel Delimited file

2009-12-17T09:02:00.000-08:00

This is a common technique Developers.Testers.DB admin come across most of the time.

You got a delimited files with a comma or a space or a Tab and you want to make that to a separate column.
Open the text file in Excel.Excel->Open->View all files and select the file.If it is Excel 2007 it will automatically pops up a window that says Text Import Wizard Mode.

otherwise if it is older excel version Click on Data->Text to Columns
It will open a Wizard Select it as Delimited and Click on Next and Select the Delimiters and click Next and Finish.The final conversion will be the values in delimited file are seperated as Column.

How to check the Server Time

2009-12-09T13:52:00.000-08:00

If You want to know is the local time of a server.

type in your command prompt


NET TIME \\servername

C# - A Musical History!

2009-11-01T14:11:00.000-08:00

In music, the symbol # is placed after the name of a note in the key signature, or before a note on the staff to indicate that the note is to be played a semitone higher.

C# was initially called COOL for C-like Object Oriented Language. It was renamed C# because it is a step above C/C++

· # (sharp) means a semi-tone above in music

· can also be viewed as a stacked 4 pluses so C++++

Get Start with SQL Server and Reporting in 5 minutes

2009-10-16T10:36:00.000-07:00

If you are using Sql server 2000..To open Query analyser from Run..
Use this Start->Run->isqlw->enter

Sql server 2005 and Sql server 2008 comes with Management Studio similar to Enterprise Manager in Sql server 2000.
These Management studio are free to download.
So if you dont have Visual Studio and Sql server installed in your system but you know you can access SQL server in your network you can download this and connect to SQL server

http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx

Reporting:
For reporting you need Business Intelligence which comes with installation of SQL server advanced tool kit for free download.So this will install Visual studio which is only for Reporting.

Filename:SQLEXPR_ADV

Reporting needs an Reporting server and Sql server

In Reporting Server where you will host all your reports and it can be accesses via URL.These reports are deployed to the reporting server through Business Intelligence visual studio solution.

like http://reportingServer.domainName/reportsfolder/reportFilname.rdl

Open Business Intelligence Solution similar to Visual studio solution icon but it will be placed in SQl server Installed folder (Start->All programs->Microsoft Sql server 2005->Sql server Business Intelligencedevelopment Studio)

Create a new Solution ,add a new data source .This datasource will be your database where your reports data are there.And this datasource is deployed to reporting server.
Right click on the Solution->Properties->Deployment->
Target Data source Folder:Data Sources
TargetReportFolder:reportsfolder/
TargetServerURL:http://reportingServer.domainName

Create a new Report which has file format .rdl
Now do all modifications in your report ,hook the store procedure,display those column name which returned from these storeproc...If you want to add parameters you can do that in Report parameter..

Now build the report and if it is succeeded right click on that report and properties->Deploy

This wll deploy the report to the reporting server where we mentioned on the Solution properties..

Here you go!!! Reporting for you in 5 minutes

Find the Column Name in a Table which is in a database

2009-10-16T10:29:00.000-07:00

You might encounter this problem...You forget the tablename where a column recides...
Inorder to search the column name where it is in a table
use this in SQL Server


SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like '%employeeId%' )

This will search the current database and returns all the rows of sysobject (tables,views,storeproc,function etc., )which has this columnname employeeId.

How you write a StoreProc with "Where in" clause

2009-09-23T10:20:00.000-07:00

This is usual store procedure we will write to get particular userid by passing single Userid as parameter

create Procedure [dbo].[procName]
(@Userid int)
AS select * from users where UserId =@Userid

If you want to pass a List of values to fetch the userId's
like
select * from users UserId in (101,102,103);

How we will pass these list of values in storeProc?

Modify the StoreProcedure like this



Create Procedure [dbo].[procName]
(@Userid varchar(500))

AS

BEGIN
SET NOCOUNT ON

DECLARE @SQL varchar(600)

SET @SQL =

'select  * from users
where UserId IN (' + @Userid + ')'

EXEC(@SQL)
END

Now pass the input parameter as Varchar @Userid varchar(500)
DECLARE @SQL varchar(600)
Now Use the @SQL as a String so the Value of the string will be 'select * from users where UserId IN ('+ @Userid + ')'
Now Execute sql by EXEC(@SQL)

Now in Your C# Code you can get the List values and convert to values with comma seperated


  List<int> someVal = new List<int>()
            {
                101,102,103,104,105
            };
         
            string Val="";
            string finalVal;
            foreach (var i in someVal)
            {
                Val = Val+i + ",";
            }
            finalVal = Val.TrimEnd(',');

DataTable dt=GetUserData(finalVal );

public DataTable GetUserData(string userID)
    {
        SqlConnection conn = null;
        SqlDataReader rdr = null;
        DataTable dt1 = new DataTable();

        // create and open a connection object
        conn = new
            SqlConnection("Server=(local);DataBase=Northwind;Integrated Security=SSPI");
        conn.Open();

        // 1.  create a command object identifying
        //     the stored procedure
        SqlCommand cmd = new SqlCommand("procName", conn);

        // 2. set the command object so it knows
        //    to execute a stored procedure
        cmd.CommandType = CommandType.StoredProcedure;

        // 3. add parameter to command, which
        //    will be passed to the stored procedure
        cmd.Parameters.Add(
            new SqlParameter("@Userid", Userid));

        // execute the command
        rdr = cmd.ExecuteReader();

        dt1.Load(rdr);

        return dt1;

    }

Adding a column to DataSet ....Wherever you want it..

2009-09-18T13:47:00.000-07:00

I hope atleast one person other than me finds this useful :)

Normally, When we want to add an extra column to a dataset

DataSet ds = new DataSet();

DataColumn column = new DataColumn("extraCol", System.Type.GetType("System.String"));
ds.Tables[j].Columns.Add(column);

Suppose we fill the dataset from a database and this dataset has 4 columns. The above two statements will add a 5th column called "extraCol" to the ds.

But this addition will always happen at the end. I mean, after the 4 original columns, you will have this extraCol.

What if you want this "extraCol" column to be added in the 3rd position??
Here's what I did ( And it works!!)

First I get a count of columns from the dataset and subtract the position which will get me the exact column number:

int columnNo = ds.Tables[j].Columns.Count - 1;

this will get the column No as 3. ( total number of columns in ds: 4). Subtract 1, you get 3.

Then do:

column.SetOrdinal(columnNo);

That's all. You now have the column "extraCol" at position 3.
Here's the code:


DataSet ds = new DataSet();
DataColumn column = new DataColumn("extraCol", System.Type.GetType("System.String"));
ds.Tables[j].Columns.Add(column);
int columnNo = ds.Tables[j].Columns.Count - 1;
column.SetOrdinal(columnNo);

For more info on the SetOrdinal Method see this link:
http://msdn.microsoft.com/en-us/library/system.data.datacolumn.setordinal.aspx

I hope this is useful.

Proxy

2009-09-11T08:21:00.000-07:00

How to view some websites which are not viewable in other countries.
Say for example you want to watch some videos in BBC website
you might come across this message

Non-UK users
Unfortunately you are unable to access this content. This is offered only to audiences in the UK.

Inorder to solve this ,

Install Firefox latest version http://www.mozilla.com/en-US/firefox/personal.html
Install add-on foxy proxy http://foxyproxy.mozdev.org/downloads.html
Once you install the add on foxyproxy to the Firefox,Search for Proxy list in Google,you will get many proxy sites with their ip address and port number.
If you see on the right side corner of your firefox screen,FoxyProxy disabled with red strike on it.Just click on it and give name and move to the next tab and copy paste the ip address and port number of the proxy list.Click ok ,you get a message ignore it and click OK
Now try to access the BBC site or anyother website which you want to gain access to it.

Note:Since you add the foxy proxy to the firefox browser ,the proxy will work only for this...If you are using IE or Chrome it will give your actual Ip address not the proxy Ip address
Check it through whatismyip.com

Telerik RadToolBar

2009-09-04T11:38:00.000-07:00

RadToolBar has Items,If the Items are RadtoolBarButton and if the user clicks on the button it has to goto the URL which you have already specified

You can try like this


<telerik:radtoolbar id="radToolBarID" runat="server" cssclass="toolbar">
  <items>
      <telerik:radtoolbarbutton navigateurl="~/default.aspx" postback="false" text="Goto Default Page" causesvalidation="false">
      <telerik:radtoolbarbutton navigateurl="~/HomePage.aspx" postback="false" text="Goto Home Page" causesvalidation="false">
  </items>
</telerik:radtoolbar>

If you want to use the INLINE code in NavigateURl from codebehind file..it wont work ..see this example for asp:Hyperlink


 <asp:HyperLink runat="server" ID="hmURL" NavigateUrl='<%#this.homePageURL%>' Text="Home"></asp:HyperLink>

In codebehind.cs

   protected void Page_Load(object sender, EventArgs e)
   {
   
           homePageURL = "~/projectFolder/homePage.aspx";
   }

<%#this.homePageURL%> this is the inline code used to get the value from the codebehind but samething cant be used in Telerik RadToolBar's radtoolbarbutton->NavigateURL
So we have to use it in the codebehind like this and in the aspx file remove the navigateURL


<telerik:radtoolbar id="radToolBarID" runat="server" cssclass="toolbar">
 <items>
     <telerik:radtoolbarbutton navigateurl="~/default.aspx" postback="false" text="Goto Default Page" causesvalidation="false">
     <telerik:radtoolbarbutton postback="false" text="Goto Home Page" causesvalidation="false">
 </telerik:radtoolbarbutton>
</telerik:radtoolbarbutton>

codeBehind.cs

public string homePageURL; 
protected void Page_Load(object sender, EventArgs e)
{
 homePageURL = "~/projectFolder/homePage.aspx";
   Telerik.Web.UI.RadToolBarButton radToolBarBtn = (Telerik.Web.UI.RadToolBarButton)radToolBarID.FindItemByText("Goto Home Page");
   radToolBarBtn.NavigateUrl = homePageURL;  
}

Is null == null?

2009-09-03T14:04:00.001-07:00

This is a classic question that every developer has faced. Well I guess it depends on how we define null. Theoretically null is definitely not equal to another null. But pragmatically it is considered so in many cases. Databases will not allow direct comparison of null. We will have to use the statement "is null" to do check for null values from a database point of view.

Try the following java code snippet:
System.out.println(null == null); //Evaluates to true
Object a = null;
Object b = null;
System.out.println(a == b); //Evaluates to True
System.out.println(a.equals(b)); //Null Pointer Exception

When we use == operator for objects, it looks whether both objects point to the same reference (In this case which Java accepts as true based on our previous test). Whereas when we call equals, it checks to see if the references to the object are the same. The references are null, so we get a Null Pointer Exception.

Viewstate Decoder & Reflector

2009-09-02T14:36:00.000-07:00

Did you ever thought to get the data in the Textbox or dropdown of an aspx page once it is processed.If the controls are server control then you cannot get the data as easy as html page -right click View source...All the values are passed as Viewstate with junk values and not readable...
To get those Viewstate Data download this software and give the URL it will get all the viewstate details ...

http://www.pluralsight.com/community/media/p/51688.aspx

To get the code from DLL :
DLL is a processed single file of thousand or more pages of code written in an application.With this single file you can get the whole functionality of a complete application .How to get the source code from these DLL files.Use this Reflector software you will get the class file structure and many more..

http://www.red-gate.com/products/reflector/

A network-related or instance-specific error occurred while establishing a connection to SQL Server

2009-09-02T14:02:00.000-07:00

If you com across this error which accessing your web application
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Check your network connection
Check whether you have given proper SQL server instance name
Check your Sql server it might gone down or SQL service might be stopped.

Detailed article is here ...

http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/

Gmail Down

2009-09-01T12:59:00.000-07:00

Server Error
The server encountered a temporary error and could not complete your request.

Please try again in 30 seconds.

Google Gmail Site Went Down around 2.55Pm Sep 1st...Yahoooooooooo!!!

Error 1 An object reference is required for the non-static field, method, or property

2009-08-31T09:43:00.000-07:00

When you are creating a Console application you might come across this error message.
And most of the time,if you are not instantiating the object of the class and calling the function you might get this error.

In console application, The initial method called by CLR is static void Main()
Since the method is static, you dont need to create object to instantiate the class....when you are trying to access a method from static class (here class name is Program ) you will get an error Error 1 An object reference is required for the non-static field, method, or property


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace ConsoleApplication1
{
class Program
{
   private void func(string someName)
   {
 
       try
       {
           for (int i = 1; i <= tot; i++)
           {
               ......
           }
       }
       catch (Exception ex)
       {
           Console.WriteLine(ex.Message);
       }
   }
   static void Main(string[] args)
   {
       string someName;
       try
       {
           func(someName);//It will throw error here
       }
       catch (Exception ex)
       {
           Console.WriteLine(ex.Message);
       }
       finally
       {
           Console.WriteLine("The End");
       }
   }
}
}

So use like this


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace ConsoleApplication1
{
class Program
{
   private void func(string someName)
   {
    try
       {
           for (int i = 1; i <= tot; i++)
           {
               ......
           }
        }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
    }
   }
   static void Main(string[] args)
   {
       string someName;
       Program classObj=new Program(); //Instantiate
       try
       {
           classObj.func(someName); //If you dont want create an object for your class you can use  func(someName) and change the function definition to private static void func(string someName)
       }
       catch (Exception ex)
       {
           Console.WriteLine(ex.Message);
       }
       finally 
       {
           Console.WriteLine("The End");
       }
   }
}
}

If you dont want create an object for your class you can use func(someName) and change the function definition to private static void func(string someName)

How to use COM object in C#.NET Visual studio 2008

2009-08-26T18:33:00.000-07:00

Use COM object in Your project?

What COM? legacy com .com+...Phew!!!!

Its easy to use COM object in your project.

If you have a dll which says it cannot be added as reference to your Project...So Register it using regsvr32 dllname.dll

Goto start->Run->regsvr32 dllname.dll

Once you register the com object dll ,now you can add as a reference by going to the COM tab in the Add reference Dialog box.
Right click on Reference->Add Refernce->COM tab->search for the dll name which u registered

Thats it you added com components to your project.Now you can access the COM object by adding


Using comClassName; // Add this mostly it will same as the dll name

and instantiate an object for that

comClassName obj=new comClassName;
string returnsValofComFunc =obj.funcInComDLL();

Thats it now you can use the functions are properties inside the com component dll directly instantiating the class.

What is instantiating?
className obj =new className(); // creating an Object for a Class is called instantiating.

What is Class?
Skeleton structure of a component


Class Car
{
   int carWheels;
   int carDoors;
   string engine;

   public int func()
   {
    carWheels=4;
    return carWheels;
   }
}

//Now if you instantiate this class you can get the class Car details
//Do you want to findout how many wheels in the car

Car carObj=new Car();
int noWheels=carObj.func();

.chm files Page cannot be displayed

2009-08-25T21:48:00.000-07:00

Most of them have encountered this Message when you open any .chm files "The Page Cannot Be displayed".

If you are a C# developer and keeps your ebooks inside "c#" folder name ..there you go thats why its not opening the pages...Change the folder name remove the '#' and rename it and open the .chm file .
Bingo!!!!
Avoid special characters like +,? ,& in the folder name...

In XP i encountered the same issue couple of years before ...Right click on the chm file Properties Click on Unblock and click apply& ok and try to open it again..It will open..

Telerik Controls

2009-08-25T09:08:00.000-07:00

If you system is not installed with the 3rd party tools,How to get that in your MS visual studio...

To get telerik control in Your toolbox or any controls you can just drag drop the dll to the MS visual studio Toolbox.
I created a new toolbox menu by Right clicking on it ToolBox->Right click->Add Tab->Give ur control toolbox Name->Drag drop the Dll of the 3rd party tools like telerik or infragistics you can find that in the installed directory or existing application bin folder.Here im using Telerik.Web.UI.dll.

Most of the Telerik Web tools are Ajax enabled.So if you just drag drop your tool to your aspx page it gives an error message like this

Error message "The control with ID '[ControlID]' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it."

So use this code Ajax etension in your master page or the aspx page you are using .

<asp:ScriptManager ID="ScriptManager1" runat="server" />

How to get the Ip address of the client

2009-08-16T07:19:00.000-07:00

You might wonder how Whatismyip.com gets your actual Ip address and displaying it.
How to get the ip address of the client Pc who is accessing a website in server.
First we have to understand

IP address are unique for every system if it is connected in Internet.(So that's why through IP address we can find the location of a person )
Your website is deployed in a server and you will be provided specific Ip address for that
If you get an Internet connection with static IP address(you need to pay extra amount for this ,Ip address wont change)you can run your website from your home PC

say for example i have a .Net web application running in a server. People are trying to access the website using the URL .But we need to restrict the Users accessing website and we need specific Users who registered their Ip address with our .net web application.
How to do that:
Use Request.ServerVariables["REMOTE_ADDR"]
You will get the client Ip!!!

How to:Deserialize XML with Namespace and no proper Schema(XSD)

2009-08-14T07:29:00.000-07:00

Consider this XML


<?xml version="1.0" encoding="utf-16"?>
<ns1:Root xmlns:ns1="http://someWebsite.com/foldername/schemaFile" xmlns:ns2="http://someWebsite.com/foldername/BaseschemaFile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://someWebsite.com/foldername/schemaFile file:/C:/xsd/schemaFile.xsd">
  <ns1:Root1 val1="abcd" val2="2008-05-04T18:13:51.0Z" />
  <ns1:Root2 r2val1="16" r2val2="1234" r2valcompanyName="Jing Company" r2valcontactName="Jinga" r2valcontactPhone="123-456-7890" r2val3status="A">
    <ns1:Address streetAddress1="jing jung  " streetAddress2="juck" city="jinjunakka" state="ji" zipCode="12345" />
  </ns1:Root2>
</ns1:Root>

If you see this XML ,You can see different things like ns1,url for Webiste and Schema file location.

If you try to deserialize using normal deserialization method you will get many errors like

" was not expected."

"was not expected" message error - deserialized xml

Use name Space in all the Attribute and Element declaration you can get that from xsd file


[Serializable()]
[XmlRoot("Root", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public sealed class RootClass
{

[XmlElement("Root1", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public Root1Class Root1 = new Root1Class();

[XmlElement("Root2", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public Root2Class Root2 = new Root2Class();
}

[Serializable()]
[XmlRoot("Root1", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public sealed class Root1
{
[XmlAttribute("val1", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string val1 = string.Empty;

[XmlAttribute("val2", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string val2 = string.Empty;

}

[Serializable()]
[XmlRoot("Root2", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public sealed class Root2
{
[XmlAttribute("r2val1", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string r2val1 = string.Empty;


[XmlAttribute("r2val2", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string r2val2 = string.Empty;

[XmlAttribute("r2valcompanyName", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string r2valcompanyName = string.Empty;

[XmlAttribute("r2valcontactPhone", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string r2valcontactPhone = string.Empty;

[XmlAttribute("r2val3status", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string r2val3status = string.Empty;

//Check here
[XmlElement("Address", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public Address address = new Address();

}



[Serializable()]
[XmlRoot("Address", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public sealed class Address
{
[XmlAttribute("streetAddress1", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string streetAddress1 = string.Empty;

[XmlAttribute("streetAddress2", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string streetAddress2 = string.Empty;

[XmlAttribute("city", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string city = string.Empty;

[XmlAttribute("state", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string state = string.Empty;

[XmlAttribute("zipCode", Namespace = "http://someWebsite.com/foldername/schemaFile")]
public string zipCode = string.Empty;
}

Write the Values to XML element

2009-08-12T14:55:00.000-07:00

Creates a XML From Dataset

Populate the DataTable values from Storeproc
Serialize
Write to XMl
Close the writing File

Enter Values to XML

Create a XmlElement as Root
Create a XmlElement below root
Create XmlText which will be the value for XmlElement
Append Child
Save the File

Get the Element Value from XML

Read the XML
Deserilize the object so XML values are now populated to the DataTable
Close the Read
Instantiate xmlDoc
Load it with the XML file
Create a Node
Goto the Node by using GetElementsByTagName("val1")[0];
Get the values of that node by xNode.InnerText


#region Create XML
//Uncomment following lines to create XML

 int val1 =1; // Initialize to an appropriate value
expected = className.FuncReturnsStoreProc(val1);
////Serialization
XmlSerializer xs = new System.Xml.Serialization.XmlSerializer(expected.GetType());
TextWriter  tw=new StreamWriter(strFilename);
xs.Serialize(tw, expected);
tw.Close();

////Create Input values  to the XML Element

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(strFilename);
if (File.Exists(strFilename))
{

    XmlElement elmRoot = xmlDoc.DocumentElement;
    elmRoot = xmlDoc.DocumentElement;

    XmlElement elmVal = xmlDoc.CreateElement("val1");
    XmlText valToXML = xmlDoc.CreateTextNode(val1.ToString());
    elmRoot.AppendChild(elmVal);
    elmRoot.LastChild.AppendChild(valToXML);

    xmlDoc.Save(strFilename);
}

//Uncomment ends
#endregion

#region Get XML data

//Deserialization
XmlSerializer xs = new System.Xml.Serialization.XmlSerializer(expected.GetType());
TextReader tr = new StreamReader(strFilename);
expected = (ObjectName)xs.Deserialize(tr); //Convert to the ObjectName
tr.Close();

//////Reads Input parameter and pass it to the actual
int val1; //  Gets the Input parameter value from XML
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(strFilename);
XmlNode xNode;
xNode = xmlDoc.GetElementsByTagName("val1")[0];
val1 = Convert.ToInt32(xNode.InnerText);

#endregion

Thanks :http://www.functionx.com/csharp/xml/Lesson03.htm

XML to DataTable and viceversa

2009-08-12T12:46:00.000-07:00

If you want to get an XML data to Dataset you need following things

.xsd Xml schema file
.xml XML file


using System.Xml;
string tableName = "tableName";
string fileName = "fileName ";
expected.TableName = tableName;
expected.ReadXmlSchema("\\" + fileName + ".xsd");
expected.ReadXml("\\" + fileName + ".xml");

This wil create a XML and XSD file for DataTable values which is fetched from Database using storeproc.



  string tableName = "GetUsersBySalesOrg";
  DataTable expected = new DataTable(); //Initialize to an appropriate value
  expected = className.StoreProcReturnsDatatable(val1, val2);
  expected.TableName = tableName;
  expected.WriteXml("\\"+tableName+".xml");
  expected.WriteXmlSchema("\\" + tableName + ".xsd");

Convert Visual studio Test to NUnit

2009-08-12T12:37:00.000-07:00

As per my previous post You can create a unit test using Visual studio 2008 now you want this test solution to run in Nunit GUI.

Uncomment using Microsoft.VisualStudio.TestTools.UnitTesting;
Add Reference nunit framework (install latest nunit ) dll will be here "C:\Program Files\NUnit 2.5.1\bin\net-2.0\nunit.framework.dll" framework to your test project
Add nunit reference using NUnit.Framework;
Change [TestMethod()] to [Test]
Change [TestClass()] to [TestFixture]
Comment function TestContext
Comment //private TestContext testContextInstance;
Build the solution open Nunit GUI ->Open the testing project dll which is created

Voila!! MS Test in Nunit

Visual Studio Unit test in fly

2009-08-12T12:11:00.000-07:00

Unit testing:

Visual Studio 2008 automatically generates test script for your project.

If you have any project which is free of errors and build successfully and you want to write a unit test for that,you can do that easily in Visual studio 2008.

Add a New test project from the Solution (Right click on Solution->New Project)
Select Test project from Templates
or Right Click on the function which you want to write a test script->Select Create Unit tests.. It will display the Classes and below that all the functions associated to it.. Just select the functions you want to test and click Ok.
It will create a new File in the Test project with code for that functions.
Now Initialize an appropriate value for the expected and actual results.
Build the project and you can Debug only this particular function in the solution by placing the cursor on the function and click on Debug Tests in Current Contest button .

Javascript to Login a Webpage

2009-08-12T11:46:00.001-07:00

If you have a username and password for a webpage and you want to login the website without clicking login button.

Small Hack:


<script language="javascript" type="text/javascript">
   document.forms[0]._some_junkvalues_txtLoginId.value = "username";
   document.forms[0]._some_junkvalues_txtPassword.value = "password";
   document.forms[0]._some_junkvalues_btnLogin.click();
</script>

Goto the webpage right click ->View Source ->search for txt box which accepts login & password,usually these id's are preceded with "_" values so copy that and paste it in your script.
Same do a search for login button and use click() function to activate login button event.

Here document.form[0].submit; wont work.

Post Codes in blog

2009-08-12T09:33:00.000-07:00

Thanks http://thoughtsomething.blogspot.com/2008/11/display-html-javascript-code-in-blogger.html

Edit the Blog Layout->Edit HTML->IN the Edit Template add this CSS and add the code as HTML

In CSS:

.postCode{ background:lightyellow none repeat scroll 0 0; border:1px inset orange; height:150px; margin:10px; overflow:auto; padding:6px; text-align:left;}

Now Goto your post and EditHTML add this with your code


<pre class="postCode">
YOUR CODE
</pre>

Using statement .NET

2009-08-12T09:15:00.000-07:00

Whoever working in C# come across using Directive using System ;
What about using Statement ? what it does is...

The using statement ensures that Dispose is called even if an exception occurs while you are calling methods on the object

You can achieve the same result by putting the object inside a try block and then calling Dispose in a finally block; in fact, this is how the using statement is translated by the compiler.



{
  Font font1 = new Font("Arial", 10.0f);
  try
  {
    byte charset = font1.GdiCharSet;
  }
  finally
  {
    if (font1 != null)
      ((IDisposable)font1).Dispose();
  }
}
Solution:You can use like this

using (Font font1 = new Font("Arial", 10.0f))
{
    byte charset = font1.GdiCharSet;
}

Thanks:MSDN
http://msdn.microsoft.com/en-us/library/yh598w02.aspx

{"There is no Unicode byte order mark. Cannot switch to Unicode."}

2009-08-12T09:05:00.000-07:00

If you have an XML with encoding="utf-16" trying to deserialize it using MemoryStream
Encoding.ASCII it will throw this error=>{"There is no Unicode byte order mark. Cannot switch to Unicode."}

Solution:

                                                           
public static T DeserializeObject(string xml)                                 
{                                                                                
   using (TextReader reader = new StringReader(xml))                             
   {                                                                             
       XmlSerializer xs = new XmlSerializer(typeof(T));                          
       return (T)xs.Deserialize(reader);                                         
   }                                                                             
}

Deserialize XML to object which has encoding ="utf-8"

                                                           
public static T DeserializeObject(string xml)                                 
{                                                                                
    XmlSerializer xs = new XmlSerializer(typeof(T));                             
    MemoryStream memoryStream = new MemoryStream(StringToASCIIByteArray(xml));   
    XmlTextWriter xmlTextWriter = new XmlTextWriter(memoryStream, Encoding.ASCII);
    return (T)xs.Deserialize(memoryStream);                                      
}