Kalra on ASP.net 2.0

RSS Feed Homepage

Articles: 1, 2

Creating an ActiveX Control in Visual Studio 2005
2007-12-03 12:12:00
There have been misconceptions on technologies upon the arrival of .Net. Many programmers believe that the arrival of .Net means the scrapping of all previous technologies. Or in other word the COM technology. COM or ActiveX technology has been around us for very long. So it?s not quite easy to scrap a long-time proven technology. Some also believed that the .Net technology replaces the ActiveX in all applications. Well, sadly this is not true. I was awakened by this reality when I handled a code conversion project. It was a conversion from Visual Basic 6 to Visual Basic 8 (VB2005). The Visual Basic 6 project was a dll-based project with an ActiveX Document as its user interface. As we all know, user documents are controls that is embedded to a web page.
More About: Visual Studio , Creating , Studio , Control

Writing an ActiveX control in C#
2007-12-03 11:45:00
http://dotnetslackers.com/articles/csharp /Writing AnActiveXControl InCSharp.aspx An ActiveX control is an object that supports a customizable programmatic interface. Using the methods, events and properties exposed by the control, web developers can automate their web pages to give the functionality which is equivalent to that of a desktop application.

Remaining Part of Dynamic SQL
2007-09-21 14:33:00
declare @a nvarchar(1024),@b nvarchar(256) set @a = 'rulename' set @b ='stauts =N' + quotename('true','''& #39; ) print @a set @a = 'select ' + @a + ' from [Rule]' + 'where' + ' ' +@b exec (@a)     set @a = ' select varname + N' + quotename(' ', '''') + ' + operation + N' + quotename(' ', '''') + ' + varvalue + N' + quotename(' ', '''') + 'as Condition , Connector from rulevariables where ruleid=20' exec(@a)-- Regards,Munish Kalra
More About: Part , Dynamic , Nami

Concatenating Columns in SQL SERVER TO SINGLE ROW . BUILDING BLOCK FOR SEAR
2007-09-21 14:31:00
DECLARE @temp varchar(150) SELECT @temp= COALESCE(@temp + ' ','' )+ varname + '' + operation + '' + varvalue +' ' + isnull (connector,'') FROM RuleVariables WHERE (RuleID = 20) print @temp-- Regards,Munish Kalra
More About: Building , Columns , Server , Single , Block

ALTERNATIVE OF GRID VIEW
2007-09-04 13:58:00
HtmlTable tb = new HtmlTable();      ;       tb.Border = 2;      &nb sp;     for (int i = 0; i < 20; i++)      & nbsp;     {      &nbs p;      &nb sp;  HtmlTableCell tc = new HtmlTableCell();    & nbsp;            tc.VAlign = "top";         ;      &nbs p;  tc.InnerText = "abc"+i.ToString();           ;       tc.BgColor = "#C0B88C";   &nb sp;      &n bsp;     HtmlTableCell tc1 = new HtmlTableCell();    & nbsp;         &...
More About: Alternative , Grid , View , Alter , Native

DIGEST METHOD
2007-07-19 08:03:00
Function GetDigest (tamperProofParams as String) as String Dim Digest as String = String.Empty Dim input as String = String.Concat(SecretSalt, tamperProofParams, SecretSalt) 'The array of bytes that will contain the encrypted value of input Dim hashedDataBytes As Byte() 'The encoder class used to convert strPlainText to an array of bytes Dim encoder As New System.Text.UTF8Encoding 'Create an instance of the MD5CryptoServiceProvider class Dim md5Hasher As New System.Security.Cryptography.MD5CryptoSer viceProvider 'Call ComputeHash, passing in the plain-text string as an array of bytes 'The return value is the encrypted value, as an array of bytes hashedDataBytes = md5Hasher.ComputeHash(encoder.GetBytes(in put)) 'Base-64 Encode the results and strip off ending '==', if it exists Digest = Convert.ToBase64String(hashedDataBytes).T rimEnd("=".ToCharArray()) Return DigestEnd Function-- Regards,Munish Kalrahttp://kalraonaspnet.b...
More About: Method

Xml serialisation
2007-07-15 21:39:00
http://weblogs.asp.net/cazzu/archive/2004 /01/23/62141.aspx-- Regards,Munish Kalra http://kalraonaspnet.blogspot.comhttp://m unishmca.co.nr
More About: Lisa , Rial , Serial , Alisa

Xml mapping advanced
2007-07-15 21:34:00
http://msdn.microsoft.com/msdnmag/issues/ 03/06/XMLFiles/-- Regards,Munish Kalra http://kalraonaspnet.blogspot.comhttp://m unishmca.co.nr
More About: Ping , Mapping , Vance

Xml serialisation
2007-07-15 21:27:00
http://www.hanselman.com/blog/XmlFragment WriterOmitingTheXmlDeclarationAndTheXSDAn dXSINamespaces.aspx -- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Lisa , Rial , Serial , Alisa

How to handle events
2007-07-15 21:01:00
http://aspnetresources.com/blog/shortest_ event_handler_syntax.aspx   Submit.Click += new EventHandle r(Submit_Click); ? void Submit_Click(object sender, EventArgs e) { // Handle the click } In 2.0, anonymous delegates come in handy when event handlers are short enough.Submit.Click += delegate (object sender, EventArgs evt) { // Handle the click }; is the same isSubmit.Click += delegate { // Handle the click }; But I slapped myself on the forehead when I saw this "shorthand" syntax, which is equivalent to the first example:Submit.Click += Submit_Click; ? void Submit_Click(object sender, EventArgs e) { // Handle the click }-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Events , Vent

Cheat sheet of client side events
2007-07-15 20:08:00
http://aspnetresources.com/blog/ms_ajax_c lient__life_cycle_events_cheat_sheet.aspx In Microsoft AJAX, the order of events on the client side always confused me. There were various objects involved in the client life cycle, and I didn't understand which events fired when. I distilled whatever documentation I found into a "cheat sheet" to illustrate the flow of events -- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Cheat , Events , Sheet , Side , Cheat Sheet

LINQ PROJECT
2007-07-11 05:51:00
* What's New in .NET 3.5 It is recommended to read first 'What's New in C# 3.0' ASP.NET Support for enabling existing ASP.NET 2.0 pages for AJAX Creation of ASMX & WCF based web services and consuming them from AJAX Library ASP.NET server side application services like authentication, roles management exposed as web services ASP.NET Merge Tool - a new tool for merging pre-compiled assemblies New ListView control which supports edit, insert, delete, sorting & paging ASP.NET integrated with core IIS 7.0 which makes ASP.NET services like authentication & caching available for other content types also. Microsoft AJAX Library to support AJAX based web development Base Classes & CLR Support for CSharp 3.0 including LINQ. HashSet : A high performance collection of type set. Time Zone Improvements : to develop applications which operate in multiple time zones Minor Improvements in Threading, Reflection and controlling the GC behavior Other...
More About: Project

Special tools
2007-07-10 21:05:00
http://www.colinneller.com/blog/PermaLink ,guid,40aced4b-d554-4bec-997b-57ead66add7 e.aspx   http://community.bartdesmet.net/blogs/bar t/archive/tags/Visual+Studio+2005/default .aspx?PageIndex=2   -- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Tools , Special

Problem by Refresh buttons
2007-07-09 00:35:00
http://jarednevans.typepad.com/technoblog /2005/01/jareds_techno_b.html public class Page : System.Web.UI.Page{private bool _refreshState;private bool _isRefresh ; public bool IsRefresh{get{return _isRefresh;}} protected override void LoadViewState(object savedState){object[] allStates = (object[]) savedState;base.LoadViewState(allStates[0 ]);_refrehState = (bool) allStates[1];_isRefresh = _refreshState == (bool) Session["__ISREFRESH"]; } protected override object SaveViewState(){Session["__ISREFRESH "] = _refreshState;object[] allStates = new object[2];allStates[0] = base.SaveViewState();allStates[1] = !_refreshState;return allStates; }}}-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Problem , Butt , Buttons

Creating a Web Custom Control
2007-07-08 21:36:00
http://www.15seconds.com/issue/040422.htm -- Web custom controls exhibit several advantages over user controls. User controls are not ideal for re-use, as their ASCX and class files must be copied into each project that consumes them. They are also handicapped by a lack of designer support in Visual Studio .NET. Drop one on a Web form and you'll see what I mean; they are represented by a generic, grey box, and the IDE offers no help in determining the control's properties. The main benefit of user controls is that they are very easy to create, and this promotes rapid application development. Web custom controls, on the other hand, can be quite appealing. There is no ASCX file for a Server Control , so they are very easy to re-use. You need only set a project reference to the DLL, and you're off to the races. Web custom controls can also be added to your VS .NET Toolbox for ultra-simple re-use. You can even install a Web custom control in the Global Assembly Cache, but a ...
More About: Creating , Custom , Eating

Using Page Data Source
2007-06-24 19:15:00
protected void Page _Load(object sender, EventArgs e){System.Data .SqlClient.SqlDataAdapter ada = new System.Data.SqlClient.SqlDataAdapter(&quo t;select * from employees",System.Web.Configuration. WebConfigurationManager.ConnectionStrings ["NorthwindConnectionString"].C onnectionString);DataTable dt = new DataTable();ada.Fill(dt);PagedDataSource objPage = new PagedDataSource();objPage.DataSource = dt.DefaultView;objPage.AllowPaging = true;objPage.PageSize = 1;objPage.CurrentPageIndex = 4;GridView1.DataSource = objPage;GridView1.DataBind();}-- Regards,Munish Kalra http://kalraonaspnet.blogspot.comhttp://m unishmca.co.nr

http://wiki.civicrm.org/confluence/display/CRMDOC/Google+Checkout+Configura
2007-06-02 05:01:00
To setup Googl e Checkout Merchant-Accounts you can use the following links:TEST Merchant Account : http://sandbox.google.com/checkout/sell LIVE Merchant Account :  http://checkout.google.com/sell Google Checkout does not allow you to use the same account as both the customer and the merchant for a transaction. Therefore you will need to create both a Merchant Account and a Customer Account for testing purposes. You can create your TEST Customer Account(s) at http://sandbox.google.com/checkout . Adhere to the following guidelines when setting up your test accounts:  Skip any sections that ask for your bank account information. Enter any name and address as long as the State field contains a valid two-letter abbreviation for a U.S. state and the Zip Code field contains a five-digit or nine-digit zip code. (You do not need to enter the correct zip code for the address.) Enter any 10-digit phone number for the Phone Number field. Use one of the credit card numbe...
More About: Display , Http , Wiki

http://ruscoe.net/blog/2006/07/whats-in-googles-sandbox.asp
2007-06-02 04:07:00
sandbox.google.comSince Googl e Checkout was released earlier this year, that subdomain has been serving up what appears to be the Google Checkout pages. However, anyone who has tried to login would've noticed that they wouldn't have been able to sign in using their usual Google Account. Furthermore, if anyone creates a new account from within these pages, it's not a 'real' Google Account ? it's actually some kind of test account.(Just try to sign in to the 'sandbox' pages using your normal account and it won't work. Similarly, try signing in to the real Google Accounts pages with your 'sandbox' login and that won't work either.)It appears that the 'sandbox' subdomain and associated Google Accounts are used for the development and testing of new or experimental Google services. So, using the same methods I used to find new service code names before ? e.g. Weaver / M Scrapbook, Google RS2, SSD, Mobile Download Console and Google LH2 ? I managed to find and add the fo...
More About: Blog , Http , Hats , Googles

http://sqljunkies.com/HowTo/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk
2007-05-27 02:43:00
PLAYING WITH SQL DATES-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Howto , Http , Junk , Junkie , Junkies

http://www.codeproject.com/webservices/webservicestesting.asp
2007-05-19 22:40:00
What are web services ? In the past, if you wanted to book a holiday over the Internet you would browse to a travel agent's web site, select a holiday and book it. If you were lucky, you'd be able to book car hire and possibly even check on the weather. Behind the scenes, the web server (the computer and software that the web site lives on) would be accessing data in a proprietary format in some sort of database, or would be communicating, again in a proprietary fashion, to back-office systems to get information about your holiday. This is all set to change with the concept of web services. A web service is a system which sits somewhere on a network and all it ever does is service specific requests from clients. These clients aren't real people browsing the internet from their desks; they're other computers. When you book a holiday, you'll still browse to your travel agent's web site but behind the scenes something different will happen. To find flight detai...
More About: Sting , Test , Http , Vice , Este

http://www.sqlservercentral.com/columnists/dPriyankara/userdefineddatatypes
2007-05-19 01:09:00
User defined data types  in SQL SERVER 2005     http://www.sqlservercentral.com/columnist s/dPriyankara/userdefineddatatypesinsqlse rver2005.asp -- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Http , Central , Columnists , Types , Fine

How to upload XML doc into sql server 2005 using openxml
2007-05-19 00:22:00
This XML file is used to store in database in table with fields company and ph   <ROOT><ShipperRec Company="ABC Shippers" Ph="(503) 555-9191" /></ROOT>   Code given below is used to determine the levels use control struct to give your each document valid inputs handlers.      SELECT *FROM OPENXML (@idoc, '/ROOT/ShipperRec',1)WITH (Company varchar(80),Ph varchar(48))     Code is pure in sql queries . just make a stored procedure pass your document to parse and done. if you find any problem .  i am here to serve you .     This is a very simple example illustrating how we can use OPENXML as a rowset provider in conjunction with SELECT T-SQL statement: DECLARE @idoc int // Document handlerDECLARE @doc varchar (1000) SET @doc ='<ROOT><ShipperRec Company="ABC Shippers" Ph="(503) 555-9191" /></ROOT>' // XML DOC USED--Create an internal representatio...
More About: Server , Sing , Load , Upload , Serve

XSD SCHEMA
2007-05-18 16:07:00
http://support.microsoft.com/kb/307379 http://support.microsoft.com/kb/317940 Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Chem

http://wpf.netfx3.com/photos/articles/images/1714/original.aspx
2007-05-17 16:11:00
http://wpf.netfx3.com/photos/articles/ima ges/1714/original.aspx   XAML architecture-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Articles , Photos , Original , Images , Image

http://blogs.msdn.com/denisruc/
2007-05-16 03:44:00
Typed XML in SQL Server 2005 Denis Ruckebusch's blog on typed XML in SQL Server 2005.-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.com http://munishmca.co.nr
More About: Blogs , Http , Logs

http://www.westinkriebel.com/Public/RSS20.xsd
2007-05-16 03:24:00
RSS SCHEMA 2.0-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Public , Http

http://www.thearchitect.co.uk/schemas/
2007-05-16 03:23:00
RSS SCHEMAS-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Http , Archi , Architect , Chem , Thea

http://aspnet.4guysfromrolla.com/articles/092706-1.aspx#postadlink
2007-05-16 02:58:00
The XmlDataSource control makes accessing, filtering, and transforming XML data a simple, code-free process. Additionally, the XPath() and XPathSelect() databinding methods added to ASP.NET 2.0 make displaying particular XML values or binding entire XML nodesets just as easy. And the XML data accessed can be from a local file or automatically downloaded from a specified URL. In this article we will examine how to use the XmlDataSource control and the XPath() and XPathSelect() databinding methods, displaying the results in a variety of data Web controls.-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.com http://munishmca.co.nr
More About: Articles , Guys , Http , Artic

Reading WORD DOCUMENTS FOR ASP.net
2007-05-07 23:49:00
using Word ; using System.Reflection; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { DocToHtml(@"c:a.doc", @"c:a.html"); } void DocToHtml(string docPath, string htmlPath) { Application app = new Application (); app.Visible = false; Object o = Missing.Value; object docFile = docPath; _Document doc = app.Documents .Open(ref docFile, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o); object fileName = htmlPath; object format = 8;//Html doc.SaveAs(ref fileName, ref format, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o); object t = true; app.Quit(ref t, ref o, ref o); } }-- Regards,Munish Kalrahttp://kalraonaspnet.blogspot.comhtt p://munishmca.co.nr
More About: Reading

HOW to read word document in .net(untested yet)
2007-05-07 22:41:00
1.The First Step is that you'll need to add a COM reference to your project by right clicking in the solution explorer on References->Add Reference. Click on the COM tab and look for the Microsoft Word 9.0 Object Library. Click Select and OK. In Form_Load write this code:- 2.private void Form1_Load(object sender, System.EventArgs e) { Word.Application app = new Word.ApplicationClass(); object nullobj = System.Reflection.Missing.Value; object file = @"C:SuneethaQues.doc"; Word.Document doc = app.Documents.Open( ref file, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj); doc.ActiveWindow.Selection.WholeStory(); doc.ActiveWindow.Selection.Copy(); IDataObject data = Clipboard.GetDataObject(); string text = data.GetData(DataFormats.Text).ToString() ; Console.WriteLine(text); doc.Close(ref nullobj, ref nullobj, ref nullobj); app.Quit(re...
More About: Read , Test , Este