How to pass XML content as Parameter to back end in asp.net? 2008-08-29 04:34:00 How to pass XML
content as Parameter
to back end in asp.net?here strXML is input parameter. here we are going to write XML content into Sql server 2005. protected void XMLWRITER(string strXML) { try { string strCon = "server=myServer;database=myDB;User ID=vbtc;Password=vbtc"; string strSql = "UPDATE Sites SET Categories = @Categories where SNo = @SNo";
How to iterate SortedList values one by one? 2008-08-29 04:30:00 How to iterate SortedList values one by one in ASP.netusing System.Collections; ---> Namespace must be added;objL ---> a SortedList with values. IDictionaryEnumerator ide = objL.GetEnumerator(); while (ide.MoveNext()) { string strVal = ide.Value.ToString(); }
Adding all selected Items from CheckBox List to SortedList 2008-08-29 04:28:00 Adding all selected Items
from CheckBox List to SortedList in ASP.net 2.0chkSubCategories --> A CheckBoxList Control which is already populated with some values.using System.Collections; SortedList objL = new SortedList(); for (int i = 0; i < chkSubCategories.Items.Count; i++) { if (chkSubCategories.Items[i].Selected == true) { objL.Add(chk
How to display a confirm box while deleting an item in Gridview? 2008-08-29 03:36:00 Confirm delete for GridView's Link Button using JavaScript Here is the code using Asp.net 2.0<script type="text/javascript">function confirm_delete(){if (confirm("Are you sure you want to delete the contact?")==true)return true;elsereturn false;}</script><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDel
How to Display Date in mm/dd/yyyy format in sql server? 2008-08-29 01:25:00 Displaying Date in yyyy/mm/dd format
in Sql Server 2005SELECT CONVERT(VARCHAR(19),CreatedDate,111)AS [Created Date] FROM tblSampleselect convert(varchar(19),getdate(),111)Displaying Date in mm/dd/yyyy format in Sql Server 2005select CONVERT (CHAR(19),CreatedDate,101) AS [Created Date] FROM tblSampleselect convert(varchar(19),getdate(),101)Enjoy SQL Coding.. Read more:Display
, server
Dinamalar - Computer Malar 2008-08-29 00:30:00 Dinamalar - Computer
Malar:Computing Special Edition in Tamil - Tips, Tricks, Word, Hard Drive, Disk Access, Password, Microsoft, Protect, SecurityMany Interesting things about Computer, Latest Technology and Trends are available in this Computer Malar from Dinamalar.Enjoy Reading Technologies..Click Here to View
How to display Top 10 commentators in your blog? 2008-08-28 23:35:00 Hi.How to display Top 10 commentators in your blog?Here is the javascript code for displaying top 10 commentators with number of comments.<script type="text/javascript">function pipeCallback(obj){document.write("<ol>");for (var i = 0; i < parseInt(obj.count) ; i++){var href = "'" + obj.value.items[i].link + "'";var item = "<li>" + "<a href=" + href + ">" + obj.value.item
Converting VARCHAR to FLOAT in SQL Server 2005 2008-08-28 06:10:00 How to Convert from VARCHAR into FLOAT in Sql Server 2005?In many places we are converting one dataype into different data type.Here is the example code for converting VARCHAR into FLOAT datatype.SELECTCONVERT(decimal(17,7),varcharField)FROMsampleTableDECLARE @Y VARCHAR(20)SELECT @Y = convert(decimal(17,11),Code) FROM TestTablePRINT @Y --I want Y to be 521698.98999999999Enjoy SQL
Coding... Read more:SQL Server
How to Display a Random Post in your Blog? 2008-08-27 10:11:00 When a User Clicks on an Image, It will load a Random
Post.Just add the following Script in your Blog.<div id="myLuckyPost"></div> <script type="text/javascript"> function showLucky(root){ var feed = root.feed; var entries = feed.entry || []; var entry = feed.entry[0]; window.location = entry.link[0].href;} function fetchLuck(luck){ script = document.createEle Read more:Display
Comma Separated Values using COALESCE function in Sql Server 2005 2008-08-27 01:15:00 Comma SeparatedValues
using COALESCE function
in Sql Server 2005DECLARE @ItemList VARCHAR(MAX)SELECT @ItemList = COALESCE(cast(@ItemList as varchar(max)) + ', ', '') + cast(Ratings.RatingType as VARCHAR(100)) + ':' + cast(SiteRating.Count as VARCHAR(100) )FROM Ratings INNER JOIN SiteRating ON Ratings.RatingID = SiteRating.RatingID INNER JOIN Site
Step By Step Procedure for Full Text Search in Sql Server 2005 2008-08-27 01:05:00 Step By Step Procedure
for Full Text Search
in Sql Server 2005Step 1: Enable Full Text SearchEXEC sp_fulltext_database 'enable'Step 2: Create a CatalogCREATE FULLTEXT CATALOG mySitesStep 3: Create Full Text Index for columnsCREATE FULLTEXT INDEX ON Sites(SiteName,Categories,Address1,Address2)KEY INDEX PK_Sites ON mySitesWITH CHANGE_TRACKING AUTOStep 4: Example for CONTAINS search...SELECT SiteName
Sharepoint Interview Questions 2008-09-17 08:37:00 What is Microsoft Windows SharePoint Services? How is it related to Microsoft Office SharePoint Server 2007?Windows SharePoint Services is the solution that enables you to create Web sites for information sharing and document collaboration. Windows SharePoint Services — a key piece of the information worker infrastructure delivered in Microsoft Windows Server 2003 — provides additional functio Read more:Sharepoint
Recommend Site To A Friend
