public bool GetDataFromWebSite() { bool myReturnBool = true; try { System.Net.WebRequest webRequest = System.Net.WebRequest.Creat... //-------------------------... // how to get your proxy from Internet Explorer // open Internet Explorer // Menu: Tools -> Internet Options // Connections Tab -> Lan Settings Button // copy and paste from "Address" text box e.g. < proxyServer.com > //-------------------------...

Normalization 1. A table should have an identifier. A table should store only data for a single type of entity. A table should not have repeating values or columns 4. A table should avoid nullable columns Choosing a SQL Server Monitoring Tool SQL Profiler Enables you to monitor server and database activity (for example, number of deadlocks, fatal errors, tracing stored procedures and Transact-SQL statements, or login activity). You can capture SQL Profiler data to a SQL Server table or a file for...

Reference and value types Structs are value types, while classes are reference types Stack What is executing Heap Heap -> pointers to ref types Value Types – · if a field, -> stack, else (part of an object), -> heap: · box value type to reference type In C#, all the "things" declared with the following list of type declarations are Value types (because they are from System.ValueType): bool , byte , char , decimal , double , enum , float , int , etc Reference Types · Heap · Unbox box reference...

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="DeleteProduct" InsertMethod="Insert" SelectMethod="GetData" TypeName="Claims_Particular... UpdateMethod="Update" OldValuesParameterFormatStr... <DeleteParameters> <asp:Parameter Name="Id" Type="Int64" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Id" Type="Int64" /> <asp:Parameter Name="Merchandise" Type="String" /> <asp:Parameter Name="Quantity" Type="Int32"...

Encapsulation – Only nececesary portions of class fields and methods should be publicly accessible. Hide inner workings of an object. Inheritance – ability of derived class to inherit the properties & methods from base class. The derived class can add to and override base class behavior. Polymorphism – the ability for related classes to have the methods or functions with the same name and signatures but different implementations. Aggregation/Composition - groups of objects being used to make...

using System; using System.Data.OleDb; using System.IO; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace Excel_Payment_Detail_Report... { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnGetFile_Click(object sender, EventArgs e) { //Stream myStream; //-------------------------...

from paul.swanson@cit.com Exploring LINQ, SQLMetal and SqlTac 15 March 2007 by Steven R. McCabe http://www.simple-talk.com/...