There are three parts in any LINQ Query
a. Data Source - Could be an array collection, Database TAble, Object Collection, Etc...
b. Creating Query - The LINQ Query Creation
c. Executing Query - Query created doesn't get executed immedietly. It gets executed only during enumeraing the result
Sample
class SampleLINQ
{
static void Main()
{
// 1. Getting Data source.
int[] intarray = new int[5] { 3, 1, 9, 63, 17};
// 2. Query creation.
var intenumQuery =
from num in intarray
where (num % 3) == 0
select num;
// 3. Query execution.
foreach (int intvalue in intenumQuery )
{
Console.Write("{0,1} ", num);
}
}
}
CODE GUIDE
ASP.NET, C#, VB.NET, SQL SERVER, SILVERLIGHT, AJAX, JAVA SCRIPTS, CSS, HTML, WCF, WPF,WIX, APEX and More...
Monday, October 29, 2012
Wednesday, October 24, 2012
Getting HTML from aspx page and save to file
This post gives the sample code to download the html of an aspx and save in to a file
Add reference to System.Net. namespace.
protected void Download_Click(object sender, EventArgs e)
{
WebClient mydwdClient = new WebClient();
string currentUrl = Request.Url.ToString(); // The page which needs to be downloaded
string webpageinHTML = String.Empty;
byte[] bytHTML;
UTF8Encoding utfenc= new UTF8Encoding();
bytHTML = mydwdClient.DownloadData(currentUrl );
webpageinHTML = utfenc.GetString(bytHTML);
Response.Write(webpageinHTML );
}
Another method which i found in asp.net forum is
protected override void Render(HtmlTextWriter writer)
{
StringBuilder sbOut = new StringBuilder();
StringWriter swOut = new StringWriter(sbOut);
HtmlTextWriter htwOut = new HtmlTextWriter(swOut);
base.Render(htwOut);
string sOut = sbOut.ToString();
// Send sOut as an Email
writer.Write(sOut);
}
Add reference to System.Net. namespace.
protected void Download_Click(object sender, EventArgs e)
{
WebClient mydwdClient = new WebClient();
string currentUrl = Request.Url.ToString(); // The page which needs to be downloaded
string webpageinHTML = String.Empty;
byte[] bytHTML;
UTF8Encoding utfenc= new UTF8Encoding();
bytHTML = mydwdClient.DownloadData(currentUrl );
webpageinHTML = utfenc.GetString(bytHTML);
Response.Write(webpageinHTML );
}
Another method which i found in asp.net forum is
protected override void Render(HtmlTextWriter writer)
{
StringBuilder sbOut = new StringBuilder();
StringWriter swOut = new StringWriter(sbOut);
HtmlTextWriter htwOut = new HtmlTextWriter(swOut);
base.Render(htwOut);
string sOut = sbOut.ToString();
// Send sOut as an Email
writer.Write(sOut);
}
Saturday, September 15, 2012
Interview Questions
Here are some of the interview questions:
It is mixture of asp.net, C#, Vb.Net, OOPS, WebServices, WCF, SQL Server, SSRS, SSIS
a. What is the architecture of Ajax in asp.net (How it actually works)
b. How a asp.net page is processed
c. How to debug asp.net application, SQL Query
d. How to find the Stored Procedures property (what command)
e. DBCC - What for it is used
f. How to take and restore SQL Server Backup
g. How to find SQL Server property
h. What are asp.net page members and methods
i. How to deploy a SSRS report
j. What is delegate
k. What is the difference between delegate and Event
l. How to create cookies
m. What is WCF
n. Difference between WCF and Web Services
o. What is inner exception
p. What is IDisposable Interface
q. What is IEnumerable Interface
.......Will Keep Adding
It is mixture of asp.net, C#, Vb.Net, OOPS, WebServices, WCF, SQL Server, SSRS, SSIS
a. What is the architecture of Ajax in asp.net (How it actually works)
b. How a asp.net page is processed
c. How to debug asp.net application, SQL Query
d. How to find the Stored Procedures property (what command)
e. DBCC - What for it is used
f. How to take and restore SQL Server Backup
g. How to find SQL Server property
h. What are asp.net page members and methods
i. How to deploy a SSRS report
j. What is delegate
k. What is the difference between delegate and Event
l. How to create cookies
m. What is WCF
n. Difference between WCF and Web Services
o. What is inner exception
p. What is IDisposable Interface
q. What is IEnumerable Interface
.......Will Keep Adding
Subscribe to:
Posts (Atom)