Geeks With Blogs


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done July 2007 Entries
Get and Validate XML from WebSite and convert to Dataset
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. < > //-------------------------... ......

Posted On Tuesday, July 31, 2007 4:04 AM

SQL Server
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 ......

Posted On Tuesday, July 31, 2007 3:18 AM

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 ......

Posted On Tuesday, July 31, 2007 2:00 AM

ObjectDataSource - Substitute parameter data from a control
<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" ......

Posted On Saturday, July 21, 2007 1:39 PM

Object Oriented
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 ......

Posted On Friday, July 20, 2007 3:14 AM

Read CSV into Dataset
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; //-------------------------... ......

Posted On Friday, July 13, 2007 1:14 AM

Exploring LINQ, SQLMetal and SqlTac
from Exploring LINQ, SQLMetal and SqlTac 15 March 2007 by Steven R. McCabe ......

Posted On Tuesday, July 10, 2007 4:40 AM

Copyright © Rodney Vinyard | Powered by: