ASP Dot Net Solutions
Monday, January 11, 2010
Split single column into multiple columns
›
DECLARE @testvar VARCHAR(MAX) SELECT @testvar = Coalesce(@testvar + ', ', '') + ColumnName FROM YourTableName D...
1 comment:
Sunday, January 10, 2010
List of modified objects in SQL Server
›
-- tables modified today SELECT [ name ] , create_date , modify_date FROM sys . objects WHERE modify_date > DATEADD ( day ,- 1 , GETDA...
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...
3 comments:
Sunday, October 4, 2009
Left Outer Join in LINQ
›
LINQ Query var query = ( from p in dc.GetTable Person >() join pa in dc.GetTable PersonAddress >() on p.Id equals pa.PersonId i...
Wednesday, September 9, 2009
Fill a DataSet or a DataTable from a LINQ query resultset
›
MyDataContext db = new MyDataContext (); IEnumerable DataRow > query = ( from order in db . Orders . AsEnumerable () ...
5 comments:
Tuesday, September 8, 2009
Read excel data into dataset
›
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Data\\Book1.xls;Extended Properties="...
Sunday, August 9, 2009
Handle master page click events in content page
›
Step 1 : Define the property in the Master Page for the LinkButton lnkbtnFromMasterPage Public LinkButton lnkbFromMasterPage(){ Get { Ret...
›
Home
View web version