tag:blogger.com,1999:blog-40438702994526829532024-03-05T21:23:11.863+05:30sudeshSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-4043870299452682953.post-41666572543414527432022-09-05T22:12:00.004+05:302022-09-05T22:12:58.104+05:30Asp.net core app creatoin and publishing to Azure App Service
<a href="https://docs.microsoft.com/en-us/aspnet/core/getting-started/?view=aspnetcore-6.0&tabs=windows">https://docs.microsoft.com/en-us/aspnet/core/getting-started/?view=aspnetcore-6.0&tabs=windows</a>
<a href="https://docs.microsoft.com/en-us/azure/app-service/quickstart-dotnetcore?tabs=net60&pivots=development-environment-vscode">https://docs.microsoft.com/en-us/azure/app-service/quickstart-dotnetcore?tabs=net60&pivots=development-environment-vscode</a>
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-6791943929007442"
crossorigin="anonymous"></script>Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-38716952976588574992019-08-07T16:21:00.000+05:302019-08-07T16:21:41.345+05:30<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<script>
(adsbygoogle = window.adsbygoogle || []).push({
google_ad_client: "ca-pub-6791943929007442",
enable_page_level_ads: true
});
</script>
Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-39745457464477384752010-10-18T23:34:00.001+05:302010-10-18T23:34:55.117+05:30passing uploaded document as a steam to a webservice from a sharepoint eventhandlerpublic override void ItemAdded(SPItemEventProperties properties)<br /> {<br /><br /> //SPFile file1 = properties.ListItem.File;<br /><br /> SPSite site = new SPSite("http://win-ofut34hh848:33738");<br /> using (SPWeb web = site.OpenWeb())<br /> {<br /> SPFolder folder = web.GetFolder("http://win-ofut34hh848:33738/TestDocLib");<br /><br /> int a = properties.AfterUrl.IndexOf('/') + 1;<br /> int b = properties.AfterUrl.Length - (properties.AfterUrl.IndexOf('/') + 1);<br /> SPFile file = folder.Files[properties.AfterUrl.Substring(a,b) ];<br /> //byte[] buffer = new byte[];<br /> //file.SaveBinary(buffer);<br /> Stream m = file.OpenBinaryStream();// new MemoryStream(buffer);<br /><br /> ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();<br /> sc.GetData(m);<br /> }<br /><br /> <br /> //}<br /> }Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-58321679760271995272010-10-18T20:48:00.002+05:302010-10-18T20:56:05.077+05:30Calling a web service from a SharePoint event handlerHigh level steps are as follows:<br /><br />1. Create the Envent reciver for the list using the Visual Studio templete.<br />2. Add a web reference to WCF Service.<br />3. Deploy the Event handler.<br />4. Register the Event handler.<br />5. Copy the WebReference folder into Site Virtual Directory in C:\inetpub\wwwroot\wss\VirtualDirectories\[port]<br />6. Add the App.config code inthe web.config fileSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-53784023528285698072010-10-17T14:28:00.000+05:302010-10-17T14:30:19.225+05:30SharePoint Document Library display of documents with pathclass Program<br /> {<br /> static void Main(string[] args)<br /> {<br /> SPSite site = new SPSite("http://win-ofut34hh848:33738");<br /> using (SPWeb web = site.OpenWeb())<br /> {<br /> //SPList list = web.GetList("/TestDocLib");<br /> //SPListItemCollection folders = list.Folders;<br /> SPFolder folder = web.GetFolder("http://win-ofut34hh848:33738/TestDocLib");<br /> <br /> //if (folder.Folder == SPFo)<br /> foreach (SPFolder f in folder.SubFolders)<br /> {<br /> //foreach (SPFolder sf in f.SubFolders)<br /> //{ <br /> Console.WriteLine(folder.Name + " \\ " + f.Name + " \n"); //+ sf.Name + "\n" ); <br /><br /> foreach (SPFile file in f.Files)<br /> {<br /> Console.WriteLine(" :::: " + file.Name); <br /> }<br /> Console.WriteLine();<br /> <br /> //}<br /> <br /> } <br /> <br /> }<br /><br /> Console.Read();<br /> <br /> }<br /> }Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-77119005943667678482010-05-27T22:34:00.000+05:302010-05-27T22:35:38.064+05:30MessagingMessageQueue myMQ;<br /><br /> public Form1()<br /> {<br /> InitializeComponent();<br /> }<br /><br /> private void button1_Click(object sender, EventArgs e)<br /> {<br /> myMQ = new MessageQueue(@".\Private$\InteropQueue");<br /><br /> if (myMQ != null && !MessageQueue.Exists(myMQ.Path))<br /> {<br /> myMQ = MessageQueue.Create(@".\Private$\InteropQueue");<br /><br /> }<br /><br /> System.Messaging.Message msg = new System.Messaging.Message();<br /> msg.Body = "Test";<br /><br /> myMQ.Send(msg);<br /> }<br /><br /><br /> MessageQueue mq;<br /> System.Messaging.Message msg;<br /> private void button2_Click(object sender, EventArgs e)<br /> {<br /> mq = new MessageQueue(@".\Private$\InteropQueue");<br /> <br /> Type[] types = new Type[1];<br /> types[0] = typeof(String);<br /> mq.Formatter = new XmlMessageFormatter(types);<br /><br /> try<br /> {<br /> // Call receive on queue<br /> msg = mq.Receive(new TimeSpan(0, 0, 100)); // 5 is wait time in seconds<br /> // Assign to variable<br /> MessageBox.Show(msg.Body.ToString());<br /> }<br /> catch( Exception ex)<br /> {<br /> MessageBox.Show(ex.Message);<br /> }Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-67590775202705280262009-12-06T17:12:00.000+05:302009-12-06T17:13:03.593+05:30CTE SQL Server 2WITH TestCTE (ID<br /> ,Name<br /> ,ParentId<br /> ,Level)<br /> AS<br /> (<br /> SELECT ID<br /> ,Name<br /> ,ParentId<br /> ,0 Level<br /> FROM dbo.MyFirends F1P<br /> UNION ALL <br /> SELECT F.ID<br /> ,F.Name<br /> ,F.ParentId<br /> ,Level - 1<br /> FROM dbo.MyFirends F<br /> INNER JOIN TestCTE CTE ON F.ID = CTE.ParentId<br /> )<br /><br /> select ID<br /> ,Name<br /> ,ParentId<br /> ,-1*Level <br /> from TestCTE CSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-89640052002312306142009-12-06T17:11:00.003+05:302009-12-06T17:16:52.816+05:30CTE SQL Serverhttp://msdn.microsoft.com/en-us/library/ms190766.aspx<br /><br /><br />CREATE TABLE [dbo].[MyFirends](<br /> [ID] [int] NULL,<br /> [Name] [nchar](10) NULL,<br /> [Date] [date] NULL,<br /> [Address] [nchar](100) NULL,<br /> [ParentId] [int] NOT NULL<br />) ON [PRIMARY]<br /><br />-------------------------------------------------------------<br /><br /><br />WITH TestCTE (ID<br /> ,Name<br /> ,ParentId<br /> ,Level)<br /> AS<br /> (<br /> SELECT ID<br /> ,Name<br /> ,ParentId<br /> ,0 Level<br /> FROM dbo.MyFirends F1P<br /> WHERE ParentId = 0 <br /> UNION ALL <br /> SELECT F.ID<br /> ,F.Name<br /> ,F.ParentId<br /> ,Level + 1<br /> FROM dbo.MyFirends F<br /> INNER JOIN TestCTE CTE ON F.ParentId = CTE.ID<br /> )<br /><br /> select ID<br /> ,Name<br /> ,ParentId<br /> ,Level <br /> from TestCTE CSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-39468276105325905972009-05-24T19:03:00.006+05:302009-05-24T19:26:08.773+05:30Real time refreshing charts in WPF<span style="font-weight:bold;">Charts in WPF </span><br /> There are sample applications and UI controls both commercial and freely available. Below 1) and 2) supports real time updating. Except the 1) and 2); with rest of the other tools the real time refreshing need to happen from the application by loading the chart periodically.<br /> <br />Visfire supports both windows and web applications with built in real time updating support. Both open source and commercial version (with customer support and many features) is available.<br /><br /><br /><br /><br /><span style="font-weight:bold;">1) A WPF Sample application for a live updating line graph</span><br /><br /> Below sample application was downloaded and tested. It contains few user controls and custom classes written from scratch with tickers and lines for generating a ticking line graph.<br />http://decav.com/blogs/andre/archive/2007/08/25/live-updating-line-graph-in-wpf.aspx<br /><br /> <a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcwuVWoZ5cozudYSZBqC4Tq-59nIsXpqzRaV1rjVSe3x2_1HDfu_PW9vSPDtDeGfhK3ebLcHchztDhjJLU8wAvXWzIJt6Kq08W4A8bz0qDQWVV7x9Or8nkN53xv29L7oS_Euyw_OtfAB_F/s1600-h/visifire.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 192px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcwuVWoZ5cozudYSZBqC4Tq-59nIsXpqzRaV1rjVSe3x2_1HDfu_PW9vSPDtDeGfhK3ebLcHchztDhjJLU8wAvXWzIJt6Kq08W4A8bz0qDQWVV7x9Or8nkN53xv29L7oS_Euyw_OtfAB_F/s320/visifire.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5339383288930589218" /></a><br /><br /><br /><br /><br /><span style="font-weight:bold;">2) Visifire </span><br /><br />Visifire is an open Source data visualization component which can be used to create charts very quickly. <br />http://visifire.com/<br /><br /> <br /> Single API to both Silverlight & WPF<br />Possible to use with desktop applications (WPF), Silverlight and WPF browser applications<br /> Embed into Desktop or Web Applications in minutes<br /> Real time Charts / Live Update<br />Any property of Visifire charts can be updated in realtime. Visifire 2.0 supports realtime update from both javascript & managed code.<br /> http://code.google.com/p/visifire/<br /> http://visifire.com/silverlight_charts_gallery.php<br /> Tiny footprint<br /> Enterprise grade features<br /> Microsoft Expression Blend compatible<br />Chart look and feel can be customized. Visifire charts can be designed in Microsoft Expression Blend.<br /> Dual License - Open Source & Commercial<br />Open Source GPL 3.0 license <br /> Commercial license with customer support and many features<br />Features: http://visifire.com/visifire_features.php<br />Samples are available with visifire downloads. In order to chart to get updated data points should be created programmatically and added to the chart.<br /> <br /><br /><br /><br /><span style="font-weight:bold;">3) Swordfish Charts</span><br /><br />http://johnstewien.spaces.live.com/blog/cns!E6885DB5CEBABBC8!444.entry<br /><br />This is an initial level project at sourceforge. Sample code is available for downloading.<br />http://sourceforge.net/projects/swordfishcharts<br />licensed under A Public Domain dedication<br /> <br /><br /><br /><br /><span style="font-weight:bold;">4) Telerik UI Controls for reporting </span><br /><br /> Telerik is a commercially available set of UI controls for reports. UI controls are available for WPF and Silverlight for reporting. Demos, online forums and documentation with great customer support are provided.<br />http://www.telerik.com/<br />Below sample application is for WPF chart using Telerik Rad controls for WPF. A lot of look and feel customizations and themes are possible with these UI controls.<br />http://blogs.telerik.com/manoldonev/posts/09-01-06/WPF_Customizing_the_chart_series_appearance_in_RadChart.aspx<br /> <a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_xVlLDPgxPnQmUJwOoA8eXGQ0FFw44y6Xv6a5wvyIYchQK_4asp3BX3cCRUVEQCjxjj7SbgGu7oLSgl1xoQvFn-AJ-w4d3A6y60DpaW4P6tmDZwQRSwJsemZU-AmUhKYkThGm_5PxsWAk/s1600-h/telerik.jpg"><img style="cursor:pointer; cursor:hand;width: 320px; height: 148px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_xVlLDPgxPnQmUJwOoA8eXGQ0FFw44y6Xv6a5wvyIYchQK_4asp3BX3cCRUVEQCjxjj7SbgGu7oLSgl1xoQvFn-AJ-w4d3A6y60DpaW4P6tmDZwQRSwJsemZU-AmUhKYkThGm_5PxsWAk/s320/telerik.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5339384049973469522" /></a><br /><br /><br /><br /><br /><span style="font-weight:bold;">5) Essential Chart for WPF</span><br /><br />http://www.syncfusion.com/products/wpf/chart?gclid=CKS4oo3i0ZoCFQogegodBR9rDw<br />http://www.syncfusion.com/products/wpf/chart/line-chartsSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com1tag:blogger.com,1999:blog-4043870299452682953.post-71480100896648720892009-04-23T21:35:00.000+05:302009-04-23T21:37:48.908+05:30pet<div style="width:360px;height:360px;text-align:right;background-color:white;border:1px solid white;-moz-border-radius:10px;-webkit-border-radius:10px;overflow:visible"> <a href="http://www.foopets.com" style="font-size:10px;font-family:helvetica,sans-serif;display:block;position:relative;text-align:right;width:100%;text-decoration:none;color:#aaaaaa;line-height:1em;margin:4px 0 0 0;" title="Get your free virtual puppy or kitten at FooPets.com, the most realistic online pets and pet games" target="_blank">Virtual Pet by FooPets.com </a><script type="text/javascript" src="http://widget.foopets.com/widget/v1?pet_id=4915347&width=360&height=270"></script></div>Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-56988916464794383342009-03-31T15:33:00.004+05:302009-03-31T15:44:55.447+05:30How to view Sinhalese Unicode characters in Windows XP SP2<span style="font-weight: bold;">How to view Sinhalese Unicode characters in Windows XP SP2</span><br /><br /> Control Panel -> Date, Time, Language, and Regional Options -> Regional and Language Options<br /> Select Languages tab<br /> In The supplemental language support select the below two options.<br /> 1) Install files for complex script and right-to-left languages (Including Thai)<br /> 2) Install files for East Asian languages<br /><br /> You may prompt for SP2 CD. Provide the appropriate CD and proceed with the installation.<br /><br /><br /> Install sinhala enabling kit from below URL:<br /> http://www.siyabas.lk/sinhala_how_to_install.html#winSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-70073468698384463572009-03-29T22:48:00.002+05:302009-03-29T22:52:00.002+05:30SQL Server table partitioning for performanceSQL Server 2005<br /><a href="http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx">http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx</a><br /><br />SQL Server 2008 Provides wizard for partitioning:<br /><a href="http://msdn.microsoft.com/en-us/library/dd578580.aspx">http://msdn.microsoft.com/en-us/library/dd578580.aspx</a>Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-67757986695115813482009-03-01T09:39:00.004+05:302009-03-01T09:51:20.333+05:30File System Encryption for Windows (Free)<span style="font-family:verdana;font-size:85%;"><br /></span><div><span style="font-family:verdana;"><span style="font-size:85%;"><strong>EFS (Encrypting File System)</strong> </span></span></div><br /><div><span style="font-family:verdana;font-size:85%;"></span></div><br /><div><span style="font-family:verdana;font-size:85%;">EFS aviable with windows provides file encryption for free and works transparently with the os.</span></div><br /><div><span style="font-family:verdana;font-size:85%;"></span></div><div><span style="font-family:verdana;font-size:85%;"></span></div><div><br /><span style="font-family:verdana;font-size:85%;">1) Open Windows Explorer and select the file you want to encrypt<br />2) Right-click the chosen file and select Properties from the context menu.<br />3) Select the Advanced button to enable EFS.<br />4) Encrypt the file by selecting the Encrypt contents to secure data check box as shown in Figure below. Click OK.<br /></span><a id="ctl00_rs1_mainContentContainer_ctl04" onclick="javascript:Track('ctl00_rs1_mainContentContainer_ctl00ctl00_rs1_mainContentContainer_ctl04',this);" href="http://technet.microsoft.com/en-us/library/Bb457065.crypt02_big(en-us,TechNet.10).gif"></a></div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitdkRJL19kiOmiIhJRihxLQTupncDNDmHa30eOoNgtXrccilZht8ljljuiIXt8C90fK_wGVCumsD4hPwpq7mLlKqHgFeSlISmRfeCO4Z1G6quaKImx3QKrXw-No9l2BRxn3qrdXg2PDX86/s1600-h/encryption.gif"><span style="font-family:verdana;font-size:85%;"><img id="BLOGGER_PHOTO_ID_5308069162416768578" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 259px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitdkRJL19kiOmiIhJRihxLQTupncDNDmHa30eOoNgtXrccilZht8ljljuiIXt8C90fK_wGVCumsD4hPwpq7mLlKqHgFeSlISmRfeCO4Z1G6quaKImx3QKrXw-No9l2BRxn3qrdXg2PDX86/s320/encryption.gif" border="0" /></span></a><br /><div><span style="font-family:verdana;font-size:85%;"></span></div><br /><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div><span style="font-family:verdana;font-size:85%;"></span> </div><div> </div><div> </div><div><a href="http://technet.microsoft.com/en-us/library/bb457065.aspx"><span style="font-family:verdana;font-size:85%;">http://technet.microsoft.com/en-us/library/bb457065.aspx</span></a></div><br /><div><span style="font-family:verdana;font-size:85%;"></span></div><br /><div><span style="font-family:verdana;font-size:85%;"></span></div><br /><div><span style="font-family:verdana;font-size:85%;"></span></div><br /><div><span style="font-family:verdana;font-size:85%;"></span></div>Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-84252949682074699902009-02-22T16:49:00.003+05:302009-02-22T16:54:34.229+05:30JavaScript client for e-jabberd (Open Source chat server - chat client)Below are open source chat server and client suitable for enterprise usage.<br /><br />Chat Server : ejabberd<br />http://www.ejabberd.im/<br /><br />Chat Client : jwchat<br />http://blog.jwchat.org/jwchat/<br /><br />Below url explains how to configure ejabberd with jwchat.<br />http://www.ejabberd.im/jwchat-localserverSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-58828111932282760922009-02-21T22:48:00.000+05:302009-02-21T22:49:53.788+05:30my home<iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.com/maps/ms?ie=UTF8&hl=en&msa=0&ll=7.012053,79.961197&spn=31.509065,56.601563&lci=lmc:panoramio,lmc:youtube,lmc:wikipedia_en&msid=107010786629699685982.000463709ffd37df1401b&output=embed&s=AARTsJpTKjhYww1H7UJztFfkBuYf3BShFA"></iframe><br /><small><a href="http://maps.google.com/maps/ms?ie=UTF8&hl=en&msa=0&ll=7.012053,79.961197&spn=31.509065,56.601563&lci=lmc:panoramio,lmc:youtube,lmc:wikipedia_en&msid=107010786629699685982.000463709ffd37df1401b&source=embed" style="color:#0000FF;text-align:left">View Larger Map</a></small>Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-55779931647084726202009-02-07T15:27:00.002+05:302009-02-07T15:28:27.282+05:30<iframe style="width: 500px; height: 375px;" src="http://www.popfly.com/users/sudesh/photos.small" allowtransparency="true" frameborder="no"></iframe>Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-9754353246518753242009-02-01T12:33:00.000+05:302009-02-01T12:35:17.744+05:30Call a WCF Service from Classic ASPDim wsdl, moniker, obj<br /><br />wsdl = GetWsdlFromUrl("http://localhost:8731/Design_Time_Addresses/WcfServiceLibrary1/Service1/?wsdl")<br /><br />moniker = "service:wsdl=" & wsdl & ", "<br />moniker = moniker + "address=http://localhost:8731/Design_Time_Addresses/WcfServiceLibrary1/Service1/,"<br />moniker = moniker + "contract=IService1, "<br />moniker = moniker + "contractNamespace=http://tempuri.org/, "<br />moniker = moniker + "binding=WSHttpBinding_IService1, "<br />moniker = moniker + "bindingNamespace=http://tempuri.org/"<br /><br /><br />Set objProxy = GetObject(moniker)<br /><br />Dim str<br />str = objProxy.GetData("2")<br />Response.Write(str)<br /><br /><br /><br /><br />Function GetWsdlFromUrl(strUrl)<br /><br /> Dim winHttpReq, resp<br /><br /> Set winHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1")<br /> resp = winHttpReq.Open("GET", strUrl, False)<br /> winHttpReq.Send<br /><br /> GetWsdlFromUrl = winHttpReq.ResponseText<br /> <br />End FunctionSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com1tag:blogger.com,1999:blog-4043870299452682953.post-55186303633793365072009-01-18T18:37:00.005+05:302009-02-01T11:03:34.815+05:30<div style="text-align: left;"><br /><b>My Virtual Rainforest</b><br /><br /><br /><a style="text-decoration: none;" href="http://apps.facebook.com/plantyourtree/forest_view/1390?forest_prefix=owned"><br /><br /><img alt="loading..." src="http://74.63.11.97/forestimage/show_owned/1390/?scale=0.5&session_id=1312e41801919a77cfa289f4c57b4541&r=11404" style="text-align: center; vertical-align: middle; width: 403px; height: 382px;" /><br /><b>(33 trees)</b><br /></a><br /><br /><br /> <a href="http://apps.facebook.com/plantyourtree/plant_trees/1390">Plant some trees for me</a><br /><br /></div>Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-20132911577958310452009-01-14T09:40:00.000+05:302009-01-14T09:51:13.658+05:30<span style="color: rgb(51, 51, 255); font-family: verdana;font-size:130%;" >send mail using gmail smtp server</span><br /><br /><div style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-family: verdana;"><br /><span style="font-style: italic;"> try</span><br /><span style="font-style: italic;"> {</span><br /><br /><span style="font-style: italic;"> MailMessage mm = new MailMessage(From.Trim(),To);</span><br /><span style="font-style: italic;"> mm.BodyEncoding = Encoding.UTF7;</span><br /><span style="font-style: italic;"> mm.Subject = Subject.Trim();</span><br /><span style="font-style: italic;"> mm.Body = MessageTxt.Trim() + "\n";</span><br /><span style="font-style: italic;"> mm.Priority = MailPriority.High;</span><br /><span style="font-style: italic;"> mm.IsBodyHtml = false;</span><br /><br /><span style="font-style: italic;"> </span><br /><br /><span style="font-style: italic;"> if (FileSt != "")</span><br /><span style="font-style: italic;"> {</span><br /><span style="font-style: italic;"> Attachment msgAtt = new Attachment(FileSt);</span><br /><span style="font-style: italic;"> mm.Attachments.Add(msgAtt);</span><br /><span style="font-style: italic;"> }</span><br /><br /><span style="font-style: italic;"> SmtpClient sc = new SmtpClient();</span><br /><span style="font-style: italic;"> </span><br /><span style="font-style: italic;"> sc.Credentials = new System.Net.NetworkCredential("sudesh.withanage", "priyanka");</span><br /><span style="font-style: italic;"> sc.Port = 587;</span><br /><span style="font-style: italic;"> sc.Host = "smtp.gmail.com";</span><br /><span style="font-style: italic;"> sc.EnableSsl = true;</span><br /><span style="font-style: italic;"> // sc.SendCompleted +=new SendCompletedEventHandler();</span><br /><br /><br /><span style="font-style: italic;"> sc.Send(mm);</span><br /><span style="font-style: italic;"> </span><br /><span style="font-style: italic;"> MessageBox.Show("success");</span><br /><br /><span style="font-style: italic;"> }</span><br /><span style="font-style: italic;"> catch (Exception ex)</span><br /><span style="font-style: italic;"> {</span><br /><span style="font-style: italic;"> MessageBox.Show(ex.Message);</span><br /><span style="font-style: italic;"> }</span><br /><br /></div><br /><span style="color: rgb(51, 102, 255); font-family: verdana;font-size:130%;" >gmail pop</span><br /><br /><div style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-family: verdana;"><br />pop.gmail.com<br /><br />995<br /></div><br /><br /><span style="color: rgb(51, 102, 255); font-family: verdana;font-size:130%;" >gmail smtp</span><br /><br /><div style="background: silver none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-family: verdana;"><br />587<br />smtp.gmail.com<br /></div>Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-41879557890333222462008-01-22T21:16:00.001+05:302008-01-22T21:16:39.687+05:30SQL CLRusing System;<br />using System.Data;<br />using System.Data.SqlTypes;<br /><br />public class MyCLRFunc<br />{<br /> [Microsoft.SqlServer.Server.SqlFunction]<br /> public static SqlString MyCLRHelloFunction()<br /> {<br /> return new SqlString("Hello everybody, I'm form SQLCLR!");<br /> }<br />};<br /><br /><br /><br />Create assembly MyUDFCLR from 'K:\Users\Sudesh\Desktop\MyCLRFunc.dll'<br /><br />create function MyCLRHelloFunction()<br /> Returns nvarchar(50)<br /> External name MyUDFCLR.MyCLRFunc.MyCLRHelloFunction;<br />Go<br /><br />select dbo.MyCLRHelloFunction()Sudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com0tag:blogger.com,1999:blog-4043870299452682953.post-6926506283161842742008-01-22T18:20:00.000+05:302008-01-22T18:24:16.122+05:30Crystal Reports changing logon infomationImports CrystalDecisions.CrystalReports.Engine<br />Imports CrystalDecisions.Shared<br /><br />' this is the class for connecting crystal reports to database<br />' applies logoninfo<br /><br />Public Class Creports<br /><br />'returns a ReportDocument after applying logoninfo for the passed report<br />Public Function connect(ByVal rpt5 As ReportDocument) As ReportDocument<br /><br />Dim tbCurrent As Table<br />Dim tbLogOnInfo As TableLogOnInfo<br /><br />Try<br />'apply LogOn info for each table of the report document<br />For Each tbCurrent In rpt5.Database.Tables<br />tbLogOnInfo = tbCurrent.LogOnInfo<br /><br />With tbLogOnInfo.ConnectionInfo<br />.ServerName = mod_1.serverName<br />.UserID = mod_1.userName<br />.Password = mod_1.password<br />.DatabaseName = mod_1.dataBaseName<br />End With<br /><br />tbCurrent.ApplyLogOnInfo(tbLogOnInfo)<br />'tbLogOnInfo = tbCurrent.LogOnInfo<br />'tbLogOnInfo.ConnectionInfo.ServerName = serverName<br />'tbLogOnInfo.ConnectionInfo.UserID = userName<br />'tbLogOnInfo.ConnectionInfo.Password = password<br />'tbLogOnInfo.ConnectionInfo.DatabaseName = databaseName<br />'tbCurrent.ApplyLogOnInfo(tbLogOnInfo)<br />Next tbCurrent<br /><br />Return rpt5<br /><br />Catch lsExp As LoadSaveReportException<br />MessageBox.Show(lsExp.Message)<br />Catch ex As Exception<br />MessageBox.Show(ex.Message)<br />End Try<br /><br />End Function<br /><br />End ClassSudeshhttp://www.blogger.com/profile/06030218653674919602noreply@blogger.com1