Select
COLUMNS.TABLE_SCHEMA,
COLUMNS.TABLE_NAME,
COLUMNS.COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
inner join
INFORMATION_SCHEMA.TABLES
on Tables.TABLE_CATALOG = Columns.TABLE_CATALOG
and Tables.TABLE_SCHEMA = Columns.TABLE_SCHEMA
and Tables.TABLE_NAME = COLUMNS.TABLE_NAME
and Tables.TABLE_TYPE = 'BASE TABLE'
//Create a list of random integers
List<int> myList = new List<int>();
Random random = new Random();
for (int i = 0; i < 1000; i++)
{
myList.Add(random.Next(0, 500));
}
//list is loaded
//find the values > 10, eliminate dups, and sort.
//now watch Linq in action
List<int> filteredList = myList
.Where<int>(r => r > 10)
.Distinct()
.OrderBy(r => (int)r).ToList();
int fullList = myList.Count();
int distinctList = filteredList.Count();
//pop up the counts
MessageBox.Show(string.Format("{0} records, {1} unique values.", fullList, distinctList));
//pop up the list
MessageBox.Show(string.Join(", ",filteredList.ToList()));
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<form id="thisform" action="HtmlPage.html" method="get">
<input id="Text1" type="text" />
<input id="Button1" type="submit" value="Post" />
</form>
</body>
</html>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" />
</div>
</form>
</body>
</html>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="E+wH9na5ksRkcpEtk56HJ50O8S2k8vu5dqruZeQtCdLxTdF9WHAcmxUsqAeaxzlLld9hLgv6LIwp+KFpLzzJEdyW2AOL2gz/b2NZ2SOhfx0=" />
//add a key
ViewState.Add("myKey", "myValue");
//store complex objects
DataSet myData = new DataSet();
ViewState.Add("data", myData);
//change a key
ViewState["myKey"] = "myNewValue";
//read a key
string data = (string)ViewState["myKey"];
//delete a key
ViewState.Remove("myKey");
ViewState.Remove("data");
//add a key
Session.Add("myKey", "myValue");
//store complex objects
DataSet mySessionData = new DataSet();
Session.Add("data", mySessionData);
//change a key
Session["myKey"] = "myNewValue";
//read a key
string data2 = (string)Session["myKey"];
//delete a key
Session.Remove("myKey");
Session.Remove("data");
//Special session methods
Session.Abandon();
Session.Clear();
if (Session.IsNewSession) { }
string s = Session.SessionID;
declare @tempIDs TABLE
(
pick_list_id integer
)
Simple enough, right? Just a long list of integers. But like I said the entire stored procedure was taking over 12 seconds to execute. In a database table, my first approach would be to make an index on the column. So that's what I did in my stored procedure. It turned out to be incredibly simple and improved performance from 12 seconds to 30 milliseconds. Looky!
declare @tempIDs TABLE
(
pick_list_id integer not null PRIMARY KEY
)
That's it! The rest of the stored procedure is exactly the same. That's a 40000% speed boost! Not bad for one modified line of code!EXECUTE sp_refreshview 'dbo.v_myViewName';
ALTER PROCEDURE [dbo].[StoredProcName]
-- Add the parameters for the stored procedure here
@customer varchar(10),
@PurchaseOrder varchar(15),
@Address1 varchar(40)
AS
public static void Import(MainForm parent)
{
parent.whatever();
}
But in my case I just didn't want to pass that handle around - and my application only had one form, so...
Application.OpenForms[0].Refresh();
 |
| Your Money is Being Sucked Down a Hole |
-- Back Up All Databases
-- by Bryan Valencia
--create temp table
declare @temp table(commands varchar(500), completed bit)
--load it with backup commands
insert into @temp (commands, completed)
(
SELECT DISTINCT 'EXEC sp_refreshview ''' + name + '''',0
FROM sys.objects AS so
INNER JOIN sys.sql_expression_dependencies AS sed
ON so.object_id = sed.referencing_id
WHERE so.type = 'V'
and is_schema_bound_reference = 0
)
--variable for the current command
declare @thisCommand varchar(500);
--loop through the table
while (select count(1) from @temp where completed=0)>0
begin
--find the first row that has not already been executed
select top 1 @thisCommand = commands from @temp where completed=0
--show the command in the "mesage" output window.
print @thisCommand
--execute the command
EXEC (@thisCommand);
--flag this row as completed.
update @temp set completed=1 where commands=@thisCommand
end
--show the user the rows that have been found.
select * from @temp
select 1, dbo.Function()
But alas, functions do not allow us to store (insert, update, delete) any data to the database and my stored procedure needs to do exactly that.
select orderID, dbo.StoredProcedure() from...
In my task, I had to insert the results of a stored procedure into a column in a table. The code example I show below creates a temporary lookup table, and uses it later for a list of inserts. try to follow this...
--creates a temp table for later use in joining (not shown)
declare @PickListNo table(OrderID varchar(20), PickListNo int, done bit);
--loads the temp table, except the column from the stored procedure
insert into @PickListNo (OrderID, done)
(
Select distinct AOO.[order number], 0 from uploads.open_orders AOO
)
--vars the stored procedure needs
declare @A int
declare @NextVal int
--while there are unprocessed rows...
while exists (select 1 from @PickListNo where PickListNo is null)
BEGIN
--execute the procedure and capture the return value
exec @A=dbo.NextPickListNo @NextVal OUTPUT
--update one row in the table
--I used Max(ID) to find a single row, but I might have used MIN, or Select top 1 as well.
update @PickListNo set PicklistNo = @A where OrderID=(select MAX(orderID) from @PickListNo where PickListNo is null)
END
This use of the while loop is my way of cheating and not using cursors. Cursors are nicely powerful but demand a lot of babysitting and resources (so I am told).
string toobig="This string is exactly 37 characters.";
string nottoobig = "13 characters";
//attempt to trim both to 20
string s;
s = toobig.Substring(0, 20);
Console.WriteLine(s);
s = nottoobig.Substring(0, 20);
Console.WriteLine(s);
System.ArgumentOutOfRangeException was unhandled
Message=Index and length must refer to a location within the string.
Parameter name: length
Source=mscorlib
ParamName=length
So we need a way to trim a string only if it's needed, i.e. a conditional trim. Normally this is written like this:
if (nottoobig.Length > 20) { s = nottoobig.Substring(0, 20); } else { s = nottoobig; };
s = nottoobig.Substring(0, Math.Min(20, nottoobig.Length));
where we substring to the min of the actual length and the desired length.
s = nottoobig.Length > 20 ? nottoobig.Substring(0, 20) : nottoobig;
This works just like excel iif():
condition ? first_expression : second_expression;
Condition must be true or false. If true, the first_expression is used, if false, the second_expression is.
static void Main(string[] args)
{
string toobig = "This string is exactly 37 characters.";
string nottoobig = "13 characters";
//attempt to trim both to 20
string s;
s = clip(toobig,20);
Console.WriteLine(s);
s = clip(nottoobig, 20);
Console.WriteLine(s);
}
private static string clip(string s, int max)
{
if (max < 0) max = 0;
return s.Length > max ? s.Substring(0, max) : s;
}
Failure sending mail.
using System.Collections.Generic;
using System.Net.Mail;
using System.Text;
namespace mailmessage_to_text
{
class MailtoText
{
private static string MailAddresstoString(MailAddress addy)
{
//"Russ Jansen" <RussJ@prosourceinc.com>
string answer = "";
if (addy != null)
{
if (string.IsNullOrEmpty(addy.DisplayName))
{
answer = string.Format("<{0}>", addy.Address);
}
else
{
answer = string.Format("\"{1}\" <{0}>", addy.Address, addy.DisplayName);
}
}
return answer;
}
private static string MailAddressCollectionToString(MailAddressCollection mc)
{
List<string> addies = new List<string>();
foreach (MailAddress addy in mc)
{
addies.Add(MailAddresstoString(addy));
}
return string.Join(", ", addies.ToArray());
}
/// <summary>
/// Convert a MailMesage to a string
/// </summary>
/// <param name="msg">the MailMessage to convert</param>
/// <returns>the MailMessage as a string</returns>
public static string MessageToString(MailMessage msg)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("FROM: {0}", MailAddresstoString(msg.From)).AppendLine();
sb.AppendFormat("TO: {0}", MailAddressCollectionToString(msg.To)).AppendLine();
sb.AppendFormat("CC: {0}", MailAddressCollectionToString(msg.CC)).AppendLine();
sb.AppendFormat("BCC: {0}", MailAddressCollectionToString(msg.Bcc)).AppendLine();
sb.AppendFormat("SUBJECT: {0}", msg.Subject).AppendLine();
sb.AppendFormat("BODY: {0}", msg.Body).AppendLine();
foreach (Attachment att in msg.Attachments)
{
sb.AppendFormat("Attachment: {0}", att.Name);
}
return sb.ToString();
}
}
}
FROM: "Bryan" <bryan@gmail.com>
TO: "Bob" <bob@gmail.com>, "Bill" <bill@gmail.com>, <some@yahoo.com>
CC: <bossman@cap.com>
BCC:
SUBJECT: New WebSite Contact
BODY: Blah has submitted the following on the CONCACT.ASPX page.
Name: Ruby
Email: Ruby@rails.com
<system.codedom>
<compilers>
<compiler
language="c#;cs;csharp"
extension=".cs"
compilerOptions="/unsafe"
type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</compilers>
</system.codedom>
using System;
using System.Runtime.InteropServices;
namespace CodeGenerator
{
internal class NativeMethods
{
[DllImport("kernel32.dll", SetLastError = true)]
public static extern IntPtr LoadLibrary(string dllToLoad);
[DllImport("kernel32.dll", SetLastError = true)]
public static extern IntPtr GetProcAddress(IntPtr hModule, string procedureName);
[DllImport("kernel32.dll")]
public static extern bool FreeLibrary(IntPtr hModule);
}
public class unlocker
{
[UnmanagedFunctionPointer(CallingConvention.Cdecl)]
private delegate IntPtr CreateCode2A(
int level,
string name,
string encrypt_template,
UInt32 hardwareID,
UInt16 otherinfo1,
UInt16 otherinfo2,
UInt16 otherinfo3,
UInt16 otherinfo4,
UInt16 otherinfo5
);
public static unsafe string CreateUnlockingCode(string regname, string encrypt_template, string HardwareID, string pathtoDLL)
{
string unlockingcode = "";
string sfp = HardwareID.Remove(4, 1);
UInt32 lfingerprint = Convert.ToUInt32(sfp, 16);
IntPtr pDll = NativeMethods.LoadLibrary(pathtoDLL); //attempt to load the library
int err1 = Marshal.GetLastWin32Error();
try
{
IntPtr pAddressOfFunctionToCall = NativeMethods.GetProcAddress(pDll, "CreateCode2A");
int err2 = Marshal.GetLastWin32Error();
CreateCode2A createCode2 = (CreateCode2A)Marshal.GetDelegateForFunctionPointer(
pAddressOfFunctionToCall,
typeof(CreateCode2A));
if (err1 == 0 && err2 == 0)
{
IntPtr unlockingcodeptr = createCode2(1, regname, encrypt_template, lfingerprint, 0, 0, 0, 0, 0);
unlockingcode = Marshal.PtrToStringAnsi(unlockingcodeptr);
}
else
{
unlockingcode = string.Format("Error Codes: {0} and {1}", err1, err2);
}
}
finally
{
bool result = NativeMethods.FreeLibrary(pDll);
}
return unlockingcode.ToString();
}
}
}
unlockingcode = CodeGenerator.unlocker.CreateUnlockingCode(regname, encrypt_template, fingerprint, pathtoDLL);
[DllImport(@"codegen64.dll")] public static extern string CreateCode2( int level, string name, string encrypt_template, Int64 hardwareID, int otherinfo1, int otherinfo2, int otherinfo3, int otherinfo4, int otherinfo5 );
There is the page global DLLImport function... and when I try to use it...try { unlockingcode = CreateCode2(1, regname, encrypt_template, lfp, 0, 0, 0, 0, 0); } catch (Exception ex) { unlockingcode = ""; }
[Window Title] Visual Studio Just-In-Time Debugger [Main Instruction] An unhandled win32 exception occurred in w3wp.exe [11016]. The Just-In-Time debugger was launched without necessary security permissions. To debug this process, the Just-In-Time debugger must be run as an Administrator. Would you like to debug this process? [^] Hide process details [Yes, debug w3wp.exe] [No, cancel debugging] [Expanded Information] Process Name: w3wp.exe User Name: NETWORK SERVICE
