Snipplr

(C#) Check SqlDataReader Column Is Exists (extension method) - emregulcan

Wed, 11 May 2011 08:30:49 UTC

This snippet is "extension method" for IDataReader. You can use this snippet below ; I assume you have datareader like that SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.IsColumnExists("columnName")) { //do something } and also you should validation null value control if you work critical datas if (dataReader.IsColumnExists("columName")) { if (dataReader["columName"] != DBNull.Value) { //do something } }

(SQL) SQL Inserted Trigger - emregulcan

Wed, 09 Feb 2011 14:09:14 UTC

This trigger returns a resultset that includes last inserted record's guid info (uniqueidentifier) If your column is uniqueidentifier and its default value is newid() , you can't get last record id (guid) with @@identity . So, I write a trigger on my table to get last record guid info ;)

(SQL) sql Raiserror with parameters - emregulcan

Fri, 04 Feb 2011 11:48:41 UTC

You can see details on http://msdn.microsoft.com/en-us/library/ms178592.aspx , but I try to explain how you throw error with "uniqueidentifier" type parameters. I convert uniqueidentifier to string (nvarchar(50)) and set a variable. "%s" is equal to "string"

(SQL) SQL Trim Function - emregulcan

Sat, 11 Dec 2010 11:06:27 UTC

Today I need Trim() function in sql, but in Sql 2005 there is no function. Because of that I wrote this user (scalar) fuction. It's very basic; -First; it's Right Trim (RTrim()) string - And then Left Trim (LTrim())

(SQL) Find string anywhere in Sql Database - emregulcan

Mon, 02 Aug 2010 16:55:37 UTC

(SQL) Timezone database - emregulcan

Fri, 23 Jul 2010 17:43:02 UTC

You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)

(SQL) Clean SQL Injection from your tables - emregulcan

Tue, 29 Jun 2010 22:58:49 UTC

This snippet just updates your tables which infected "" code blocks. You must update all columns one by one.

(C#) String to Hex - Hex to String Convert - emregulcan

Tue, 29 Jun 2010 18:34:44 UTC

You can convert a string to hex or vice-versa with this methods. Example for real world; You want set / get some data from URL, but if your data has some special chars (like ^$ %) it'll be problem... In this case, you can use this methods and convert your data to hex.

(SQL) Clean Injection from Database Tables - emregulcan

Tue, 15 Jun 2010 08:21:53 UTC

You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '','')

(ASP) Set your Twitter status via API (without oAuth) - emregulcan

Tue, 27 Apr 2010 07:04:38 UTC

This script works good condition, and not use "oAuth". Your should get username and password with cleartext (standart html controls) without authentication and just add them into variables in your code... (twitter_username and twitter_password) And also get status from textbox and set variable named "new_status"

(SQL) Find Tables in Database (SQL Query) - emregulcan

Tue, 20 Apr 2010 03:56:52 UTC

(C#) Get Countries List - emregulcan

Tue, 30 Mar 2010 16:53:07 UTC

You can get all countries list by this method. Also you can find some details for countries like; - original name, - three letter ISO region name, - three letter WINDOWS region name, - currency symbol etc..

(C#) Convert special Turkish chars to international Latin chars - emregulcan

Tue, 30 Mar 2010 16:48:08 UTC

(C#) How to Bind An Enum Name and Value to an ASP.NET DropDownList - emregulcan

Fri, 05 Mar 2010 01:41:29 UTC

(C#) TimeZones available on your machine using C# - emregulcan

Fri, 05 Mar 2010 01:27:59 UTC

(C#) Convert LowerCase and UpperCase to TitleCase in .NET - emregulcan

Fri, 05 Mar 2010 01:24:08 UTC

(C#) Change "Eval" Value - emregulcan

Wed, 03 Mar 2010 03:57:31 UTC

You can change your dynamic binding eval text with this method. This method should be in same codebehind