sitecoreweb.in

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: July 2009

http://firoz-aspdotnetsolutions.blogspot.com/2009_07_01_archive.html

ASP Dot Net Solutions. Monday, July 27, 2009. Read html of any web page. Create string type variable and assign function " readHtmlPage. To this, this function will take any web page URL of which sourcecode you want to read. String strResult = readHtmlPage("ANY web page url");. Create the function " readHtmlPage. Private String readHtmlPage(string url). WebRequest objRequest = System.Net.HttpWebRequest.Create(url);. ObjResponse = objRequest.GetResponse();. Using (StreamReader sr =. Links to this post.

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: Fill a DataSet or a DataTable from a LINQ query resultset

http://firoz-aspdotnetsolutions.blogspot.com/2009/09/fill-dataset-or-datatable-from-linq.html

ASP Dot Net Solutions. Wednesday, September 9, 2009. Fill a DataSet or a DataTable from a LINQ query resultset. I just discovered the website who writes about. If you want to know more here it is. Home based business opportunity. January 22, 2010 at 5:17 AM. As Xrumer experts, we secure been using [url=http:/ www.xrumer-seo.com]Xrumer[/url] for a long time things being what they are and remember how to harness the titanic power of Xrumer and build it into a Banknotes machine. This is making your put more...

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: December 2008

http://firoz-aspdotnetsolutions.blogspot.com/2008_12_01_archive.html

ASP Dot Net Solutions. Monday, December 29, 2008. Select DISTINCT on DataTable. In a project I'm doing I needed to basically do a DISTINCT on a couple fields in a DataTable that I had used earlier in code. Did some Google searching and came up with this MS KB. Private Shared Function createRowClone(ByVal sourceRow As DataRow, ByVal newRow As DataRow, ByVal fieldNames() As String) As DataRow For Each field As String In fieldNames newRow(field) = sourceRow(field) Next Return newRowEnd Function. Private sta...

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: Left Outer Join in LINQ

http://firoz-aspdotnetsolutions.blogspot.com/2009/10/left-outer-join-in-linq.html

ASP Dot Net Solutions. Sunday, October 4, 2009. Left Outer Join in LINQ. PFirstName, p.LastName, addresses.State });. SELECT [t0].[FirstName], [t0].[LastName], [t1].[State] AS [State]. FROM [dbo].[Person] AS [t0]. LEFT OUTER JOIN [dbo].[PersonAddress] AS [t1] ON [t0].[Id] = [t1].[PersonID]. Subscribe to: Post Comments (Atom). Mumbai, Maharashtra, India. View my complete profile. Asp Dot Net Solutions. Index DNN Forum content, Need to be sure the search feature works. Quotation of the Day.

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: February 2008

http://firoz-aspdotnetsolutions.blogspot.com/2008_02_01_archive.html

ASP Dot Net Solutions. Thursday, February 21, 2008. Storing the password in secure form and reading it back. Create the table which have fields UserName and Passwords and set Password field Varbinary. CREATE TABLE [dbo].[User] ([ID] [int] IDENTITY (1, 1) NOT NULL ,[UserName] [varchar] (50) COLLATE SQL Latin1 General CP1 CI AS NULL ,[Password] [varbinary] (255) NULL ,) ON [PRIMARY]GO. Now store UserName and Password by using new method. Now we will retrive this password usin method using the method. Unles...

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: October 2009

http://firoz-aspdotnetsolutions.blogspot.com/2009_10_01_archive.html

ASP Dot Net Solutions. Monday, October 5, 2009. Create DataTable and sort Programmatically in C#, ASP.NET. Create a DataTable instance. DataTable table = new DataTable();. Create 7 columns for this DataTable. DataColumn col1 = new DataColumn("ID");. DataColumn col2 = new DataColumn("Name");. DataColumn col3 = new DataColumn("Checked");. DataColumn col4 = new DataColumn("Description");. DataColumn col5 = new DataColumn("Price");. DataColumn col6 = new DataColumn("Brand");. Define DataType of the Columns.

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: Split single column into multiple columns

http://firoz-aspdotnetsolutions.blogspot.com/2010/01/split-single-column-into-multiple.html

ASP Dot Net Solutions. Monday, January 11, 2010. Split single column into multiple columns. SELECT @testvar = Coalesce(@testvar ', ', ' ) ColumnName. DECLARE @pos int,@pos2 int, @curruntLocation char(20),@curruntLocation2 char(20), @input varchar(2048). SELECT @input = @testvar. SELECT @input = @input ','. CREATE TABLE #tempTable1 (temp1 varchar(100),temp2 varchar(100) ). WHILE CHARINDEX(',',@input) 0. SELECT @pos=CHARINDEX(',',@input). SELECT @curruntLocation = RTRIM(SUBSTRING(@input,1,@pos-1). Index DN...

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: August 2009

http://firoz-aspdotnetsolutions.blogspot.com/2009_08_01_archive.html

ASP Dot Net Solutions. Sunday, August 9, 2009. Handle master page click events in content page. Define the property in the Master Page for the LinkButton lnkbtnFromMasterPage. Reference the Master Page as a casted object in the Content page.This can be done accessing the MasterPage object of the content page and casting it to the class for our Master Page. Here the class defined for the Master Page is CustomMasterPageCls. Of course I can! Click = New EventHandler( lnkbtnFromMasterPage. Links to this post.

firoz-aspdotnetsolutions.blogspot.com

ASP Dot Net Solutions: January 2010

http://firoz-aspdotnetsolutions.blogspot.com/2010_01_01_archive.html

ASP Dot Net Solutions. Monday, January 11, 2010. Split single column into multiple columns. SELECT @testvar = Coalesce(@testvar ', ', ' ) ColumnName. DECLARE @pos int,@pos2 int, @curruntLocation char(20),@curruntLocation2 char(20), @input varchar(2048). SELECT @input = @testvar. SELECT @input = @input ','. CREATE TABLE #tempTable1 (temp1 varchar(100),temp2 varchar(100) ). WHILE CHARINDEX(',',@input) 0. SELECT @pos=CHARINDEX(',',@input). SELECT @curruntLocation = RTRIM(SUBSTRING(@input,1,@pos-1).