Useful Information For Developers

find the table in different Store procedure

2012-03-27T00:51:00.002-07:00

how we know, selected table is used in how much store procedure.

SELECT DISTINCT OBJECT_NAME(id) FROM syscomments WHERE [text] LIKE '%aaaa%'

Find files in folder or directory

2012-01-25T05:17:00.000-08:00

use to find out the files in folder or directory and compare it with database and not comparable are inserted into temp table and at last will show on gird view.

DataTable dt = new DataTable();
dt.Columns.Add("ImageName");
dt.Columns.Add("ImagePath");

DataSet ds = Utils.GetImageFolderNames();
DataSet dsImage = Utils.GetAllImages();
DataTable dtImages=dsImage.Tables[0];
DataView dv = new DataView(dsImage.Tables[0]);

if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count>0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
string folderPath=Server.MapPath(ResolveUrl("~/images/" + row["folderName"]+"/"));
if (Directory.Exists(folderPath))
{
DirectoryInfo mydir = new DirectoryInfo(folderPath);
if (mydir.Exists)
{
FileInfo[] fil = mydir.GetFiles();
foreach (FileInfo fl in fil)
{
dv.RowFilter = "FileName='" + fl.Name + "' or " + "ThumbNailImageName='" + fl.Name+"'";
if (dv.Count <= 0)
{
DataRow dr = dt.NewRow();
dr["ImageName"] = fl.Name;
dr["ImagePath"] = fl.FullName;
dt.Rows.Add(dr);
dt.AcceptChanges();
}
}
}
}
}
}

gvData.DataSource = dt;
gvData.DataBind();

File Upload

2012-01-09T05:12:00.000-08:00

Demo : http://blueimp.github.com/jQuery-File-Upload/
Source Link https://github.com/blueimp/jQuery-File-Upload

http://www.freshdesignweb.com/10example-ajax-upload-file-with-php.html

http://blogs.bigfish.tv/adam/examples/swfupload-jquery-plugin/examples/02%20-%20multiple%20uploaders.html

Show default Text in textbox asp.net

2011-12-01T05:49:00.001-08:00

you can use this functionality to set default text of textbox

<asp:TextBox ID="txtMinSearch" runat="server"
ForeColor="GrayText" Text="Enter property name, address or GENIE ID."
onClick="if(this.value=='Enter property name, address or GENIE ID.')this.value='';"
onBlur="if(this.value=='')this.value='Enter property name, address or GENIE ID.';"
ControlToValidate="txtMinSearch" ClientIDMode="Static">
</asp:TextBox>

if you provide validation on textbox by using its default functionality then you controlToValidate property and in CS you should apply regex for validation.

Regex.IsMatch(txtMinSearch.Text, @"^\d+([,][\s]\d+)*$")

How to get lat long of address

2011-12-01T05:42:00.001-08:00

This is google api which is used to get lat long of address directly. it return XML data .

http://maps.googleapis.com/maps/api/geocode/xml?sensor=false&address=%22%20+%20HttpContext.Current.Server.UrlEncode(2000,Town%20Center%20,48075,Southfield,MI,USA);

CS code

LatLng latLong = GoogleMaps.GetLatLong(address.ToString().TrimEnd(','));
if (latLong.Latitude != 0 && latLong.Longitude != 0)
{

txtLatitude.Text = latLong.Latitude.ToString();
txtLongitude.Text = latLong.Longitude.ToString();
}

create a class and past this code

/// <summary>
/// Perform a geocode lookup of an address
/// </summary>
/// <param name="addr">The address in CSV form line1, line2, postcode</param>
/// <param name="output">CSV or XML</param>
/// <returns>LatLng object</returns>
public static LatLng GetLatLong(string addr)
{
//var url = "http://maps.google.co.uk/maps/geo?output=csv&key=" +
//var url = "http://maps.google.com/maps/geo?output=csv&key=" +
// It can return xml with json if required.
var url = "http://maps.googleapis.com/maps/api/geocode/xml?sensor=false&address=" + HttpContext.Current.Server.UrlEncode(addr);//=1600+Amphitheatre+Parkway,+Mountain+View,+CA
//this.API_KEY + "&q=" + HttpContext.Current.Server.UrlEncode(addr);

var request = WebRequest.Create(url);
var response = (HttpWebResponse)request.GetResponse();

if (response.StatusCode == HttpStatusCode.OK)
{

var ms = new MemoryStream();
var responseStream = response.GetResponseStream();

var buffer = new Byte[2048];
int count = responseStream.Read(buffer, 0, buffer.Length);

while (count > 0)
{
ms.Write(buffer, 0, count);
count = responseStream.Read(buffer, 0, buffer.Length);
}

responseStream.Close();
ms.Close();

var responseBytes = ms.ToArray();
var encoding = new System.Text.ASCIIEncoding();

string coords = encoding.GetString(responseBytes);
//string[] parts = coords.Split(',');

//return new LatLng(
// Convert.ToDouble(parts[2]),
// Convert.ToDouble(parts[3]));
return GetLatLongFromXML(coords);
}

return null;
}
private static LatLng GetLatLongFromXML(string xmlInput)
{
//string latLong = string.Empty;
XPathNavigator nav;
XPathDocument docNav;
XPathNodeIterator NodeIter;
String strExpressionLat;
String strExpressionLng;
StringReader reader = new StringReader(xmlInput);

docNav = new XPathDocument(reader);
nav = docNav.CreateNavigator();

// This expression uses standard XPath syntax.
strExpressionLat = "/GeocodeResponse//location/lat/text()";
strExpressionLng = "/GeocodeResponse//location/lng/text()";
//string latitude = nav.Evaluate(strExpressionLat).ToString();
//string longitude = nav.Evaluate(strExpressionLng).ToString();
double lat = 0.0;
double lng = 0.0;
NodeIter = (XPathNodeIterator)nav.Evaluate(strExpressionLat);
if (NodeIter.MoveNext())
{
double.TryParse(NodeIter.Current.Value, out lat);
}

NodeIter = (XPathNodeIterator)nav.Evaluate(strExpressionLng);

if (NodeIter.MoveNext())
{
double.TryParse(NodeIter.Current.Value, out lng);
}

//double.TryParse(oString(), out lat);
//double.TryParse(nav.Evaluate(strExpressionLng).ToString(), out lng);

//string str=string.Empty;
//while (NodeIter.MoveNext())
//{
// str += "," + NodeIter.Current.Value;
//};

//return latitude + "," + longitude;
return new LatLng(lat, lng);
}

The "/default.aspx" has not precomplied

2011-10-06T23:29:00.000-07:00

To solve this issue you should check the framework version of your web site in IIS and make it same as in web application i.e. you have created your website in Framework 4 then you should select framework 4 in IIS from Application Pool and also move the default.aspx page on the top from default document of your web site in IIS.

xml Serialization c#

2011-10-05T01:22:00.000-07:00

C# Tutorial - XML Serialization

A long while ago we posted a tutorial on how to serialize objects to a binary file. While this is very useful, unfortunately the resulting file is not very human readable. In this tutorial, I'm going to demonstrate how to serialize your own objects to and from an XML file.

Since .NET can use reflection to get property names, basic serialization is unbelievably simple. It only gets slightly difficult when you want to name your XML tags differently than your property names (but still not very hard). If you've ever used an XML serialization package in C++ like boost, tinyXML, or libXML2, you'll see how comparatively easy C# is to use.

Let's start with a basic example. Below is an object that stores some information about a movie.

public class Movie

{

  public string Title

  { get; set; }

  public int Rating

  { get; set; }

  public DateTime ReleaseDate

  { get; set; }

}

All right, now that we have an object, let's write a function that will save it to XML.

static public void SerializeToXML(Movie movie)

{

  XmlSerializer serializer = new XmlSerializer(typeof(Movie));

  TextWriter textWriter = new StreamWriter(@"C:\movie.xml");

  serializer.Serialize(textWriter, movie);

  textWriter.Close();

}

The first thing I do is create an XMLSerializer (located in the System.Xml.Serialization namespace) that will serialize objects of type Movie. The XMLSerializer will serialize objects to a stream, so we'll have to create one of those next. In this case, I want to serialize it to a file, so I create a TextWriter. I then simply call Serialize on the XMLSerializer passing in the stream (textWriter) and the object (movie). Lastly I close the TextWriter because you should always close opened files. That's it! Let's create a movie object and see how this is used.

static void Main(string[] args)

{

  Movie movie = new Movie();

  movie.Title = "Starship Troopers";

  movie.ReleaseDate = DateTime.Parse("11/7/1997");

  movie.Rating = 6.9f;

  SerializeToXML(movie);

}

static public void SerializeToXML(Movie movie)

{

  XmlSerializer serializer = new XmlSerializer(typeof(Movie));

  TextWriter textWriter = new StreamWriter(@"C:\movie.xml");

  serializer.Serialize(textWriter, movie);

  textWriter.Close();

}

After this code executes, we'll have an XML file with the contents of our movie object.

<?xml version="1.0" encoding="utf-8"?>

<Movie xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

   xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <Title>Starship Troopers</Title>

  <Rating>6.9</Rating>

  <ReleaseDate>1997-11-07T00:00:00</ReleaseDate>

</Movie>

If you noticed, all of the XML tag names are the same as the property names. If we want to change those, we can simply add an attribute above each property that sets the tag name.

public class Movie

{

  [XmlElement("MovieName")]

  public string Title

  { get; set; }

  [XmlElement("MovieRating")]

  public float Rating

  { get; set; }

  [XmlElement("MovieReleaseDate")]

  public DateTime ReleaseDate

  { get; set; }

}

Now when the same code is executed again, we get our custom tag names.

<?xml version="1.0" encoding="utf-8"?>

<Movie xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

   xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <MovieName>Starship Troopers</MovieName>

  <MovieRating>6.9</MovieRating>

  <MovieReleaseDate>1997-11-07T00:00:00</MovieReleaseDate>

</Movie>

Sometimes, in XML, you want information stored as an attribute of another tag instead of a tag by itself. This can be easily accomplished with another property attribute.

public class Movie

{

  [XmlAttribute("MovieName")]

  public string Title

  { get; set; }

  [XmlElement("MovieRating")]

  public float Rating

  { get; set; }

  [XmlElement("MovieReleaseDate")]

  public DateTime ReleaseDate

  { get; set; }

}

With this code, MovieName will now be an attribute on the Movie tag.

<?xml version="1.0" encoding="utf-8"?>

<Movie xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

   xmlns:xsd="http://www.w3.org/2001/XMLSchema" 

   MovieName="Starship Troopers">

  <MovieRating>6.9</MovieRating>

  <MovieReleaseDate>1997-11-07T00:00:00</MovieReleaseDate>

</Movie>

Let's move on to something a little more interesting. Let's create another movie and serialize a List of them to our XML file. Here's the modified code to do just that:

static void Main(string[] args)

{

  Movie movie = new Movie();

  movie.Title = "Starship Troopers";

  movie.ReleaseDate = DateTime.Parse("11/7/1997");

  movie.Rating = 6.9f;

  Movie movie2 = new Movie();

  movie2.Title = "Ace Ventura: When Nature Calls";

  movie2.ReleaseDate = DateTime.Parse("11/10/1995");

  movie2.Rating = 5.4f;

  List<Movie> movies = new List<Movie>() { movie, movie2 };

  SerializeToXML(movies);

}

static public void SerializeToXML(List<Movie> movies)

{

  XmlSerializer serializer = new XmlSerializer(typeof(List<Movie>));

  TextWriter textWriter = new StreamWriter(@"C:\movie.xml");

  serializer.Serialize(textWriter, movies);

  textWriter.Close();

}

Now we have XML that looks like this:

<?xml version="1.0" encoding="utf-8"?>

<ArrayOfMovie xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

   xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <Movie MovieName="Starship Troopers">

    <MovieRating>6.9</MovieRating>

    <MovieReleaseDate>1997-11-07T00:00:00</MovieReleaseDate>

  </Movie>

  <Movie MovieName="Ace Ventura: When Nature Calls">

    <MovieRating>5.4</MovieRating>

    <MovieReleaseDate>1995-11-10T00:00:00</MovieReleaseDate>

  </Movie>

</ArrayOfMovie>

Ok, so you can see how easy it is to get your objects into an XML document. Let's now look at how to read an XML document back into our objects - deserialization. The process of deserializing is very similar to what we did for serialization.

static List<Movie> DeserializeFromXML()

{

   XmlSerializer deserializer = new XmlSerializer(typeof(List<Movie>));

   TextReader textReader = new StreamReader(@"C:\movie.xml");

   List<Movie> movies;

   movies = (List<Movie>)deserializer.Deserialize(textReader);

   textReader.Close();

   return movies;

}

Just like before, we first create an XmlSerializer that can deserialize objects of type List<Movie>. The XmlSerializer also deserializes from a stream, so we create a file stream from our XML file. We then simply call Deserialize on the stream and cast the output to our desired type. Now the movies List is populated with objects that we previously serialized to the XML file.

The deserializer is very good at handling missing pieces of information in your XML file. Let's say the second movie didn't have the MovieName attribute on the Movie tag. When the XML file is deserialized, it simply populates that field with null. If MovieRating wasn't there, you'd receive 0. Since a DateTime object can't be null, if MovieReleaseDate was missing, you'd receive DateTime.MinValue (1/1/0001 12:00:00AM).

If the XML document contains invalid syntax, like say the first opening Movie tag was missing, the Deserialize call will fail with an InvalidOperationException. It will also be kind enough to specify the location in the file where it encountered the error (line number, column number).

One thing to remember is that the basic XML serialization won't maintain references. Let's say I populated my movies list with the same movie reference multiple times:

Movie movie = new Movie();

movie.Title = "Starship Troopers";

movie.ReleaseDate = DateTime.Parse("11/7/1997");

movie.Rating = 6.9f;

List<Movie> movies = new List<Movie>() { movie, movie };

Now I have a list containing two of the exact same movie reference. When I serialize and deserialize this list, it will be converted to two separate instances of the movie object - they would just have the same information. Along this same line, the XMLSerializer also doesn't support circular references. If you need this kind of flexibility, you should consider binary serialization.

There's still a lot to cover when it comes to XML serialization, but I think this tutorial covers enough of the basics to get things rolling. If you've got questions or anything else to say, leave us a comment.

reference website:http://www.switchonthecode.com/tutorials/csharp-tutorial-xml-serialization

How to create web service in asp.net 2010

2011-10-03T22:55:00.000-07:00

How to create simple web service in VS2010, NOT WCF service

I had the same issue, however I needed .Net 4.0. The way I created a WebService "Hello World" project using Visual Studio 2010 with .Net 4.0 is as follows:

1. File -> New -> Project

2. Temporarily Select .NET Framework 3.5 from the dropdown list at the top center of the New Project Dialog Box.

3. Select Template "ASP.NET Web Service Application - OK

4. In the Solution Explorer right click on the WebService1 project within the Solution WebService1 - select Properties on the bottom

5. On the Application Tab change the Target framework back to .NET Framework 4.0

6. Confirm all the warning that you'll have to manuall change things, etc.

7. press F5 to start the Hello World App

What should you see:

8: A browser launches with http://localhost:4001/Service1.asmx as the URL with a link named HelloWorld which is the WebMethod

9: Click the HelloWorld Link and click Invoke

10: Output:

<?xml version="1.0" encoding="utf-8" ?>

<string xmlns=http://tempuri.org/>Hello World</string>

Hello World is the return value of the HelloWorld method

You're off and running.. Have Fun.

Share UseFul links

2011-10-03T04:59:00.000-07:00

http://share-useful-links-here.blogspot.com/

the above link contain useful information for developer.

Remove Different part of string within string by using Two Dimensional Array

2011-09-28T02:04:00.000-07:00

This is use to remove the string just like From index To index functionality.

You just need to send the Original text with list of string array two dimensional where Ist dimension contain the row number and second one contain the column number.i.e. original string is ="abcdefghijklmnop" listToRemove[0,0]="cd" , listToRemove[0,1]="ghi"
it means that you want to remove from "cd" to "ghi" (i.e. cdefghi)
so your result will be "abjklmnop"

/// <summary>
/// wajid shah
/// </summary>
/// <param name="OriginalStr">Original String</param>
/// <param name="listToRemove">Two dimensional String list to be remove from the original string </param>
/// <param name="Counter">Number of item in list. This is use for loop purpose. i.e. string[9,2] then you should send counter value to 9</param>
/// <returns></returns>
public static string RemoveSubStringFromString(string OriginalStr, string[,] listToRemove, int Counter)
{
string FinalStr = string.Empty;
bool Flag = false;
string[] FirstStr;
string[] LastStr;

for (int i = 0; i <= Counter-1; i++)
{

if (OriginalStr.Contains(listToRemove[i, 0].ToString()))
{
if (!Flag)
{
Flag = true;

FirstStr = OriginalStr.Split(new string[] { listToRemove[i, 0] }, StringSplitOptions.RemoveEmptyEntries);

LastStr = FirstStr[1].ToString().Split(new string[] { listToRemove[i, 1] }, StringSplitOptions.RemoveEmptyEntries);

FinalStr = FirstStr[0].ToString() + LastStr[1].ToString();
}
else
{
FirstStr = FinalStr.Split(new string[] { listToRemove[i, 0] }, StringSplitOptions.RemoveEmptyEntries);

LastStr = FirstStr[1].ToString().Split(new string[] { listToRemove[i, 1] }, StringSplitOptions.RemoveEmptyEntries);

FinalStr = FirstStr[0].ToString() + LastStr[1].ToString();
}
}
}
return FinalStr;
}

use like
OriginalString ="<SaveSearch><MajorMarketAreaID>147</MajorMarketAreaID><PropertyDirection>N</PropertyDirection><City>southfield</City><State>michigan</State><Latitude>42.4733688</Latitude><Longitude>-83.2218731</Longitude><Radius>3</Radius><PropertyType>1</PropertyType><TransactionSpaceType>0</TransactionSpaceType></SaveSearch>"

string[,] str=new string[8,2];

str[0, 0] = "<TenantStreetNumberFrom>";
str[0, 1] = "</TenantStreetNumberFrom>";

str[1, 0] = "<TenantStreetNumberTo>";
str[1, 1] = "</TenantStreetNumberTo>";

str[2, 0] = "<PropertyDirection>";
str[2, 1] = "</PropertyDirection>";

str[3, 0] = "<TenantStreetName>";
str[3, 1] = "</TenantStreetName>";

str[4, 0] = "<City>";
str[4, 1] = "</City>";

str[5, 0] = "<County>";
str[5, 1] = "</County>";

str[6, 0] = "<State>";
str[6, 1] = "</State>";

str[7, 0] = "<Zip>";
str[7, 1] = "</Zip>";

//str[8, 0] = "<Radius>";
//str[8, 1] = "</Radius>";

string Query1=RemoveSubStringFromString(OriginalString, str,8);

Result String ="<SaveSearch><MajorMarketAreaID>147</MajorMarketAreaID><Latitude>42.4733688</Latitude><Longitude>-83.2218731</Longitude><PropertyType>1</PropertyType><TransactionSpaceType>0</TransactionSpaceType></SaveSearch>"

XML File to XML Schema or XML to XSD

2011-09-23T03:46:00.000-07:00

if you have xml file and want to create its xml schema or XSD then you just upload your file to this website and resultant you can see the xsd or xml schema.

http://www.flame-ware.com/products/xml-2-xsd/

same in the case for xsd to xml

Get User IP address in asp.net

2011-09-06T01:37:00.001-07:00

We have Request.UserHostAddress to get the IP address in ASP.NET, but this is usually the user's ISP's IP address, not exactly the user's machine IP address who for example clicked a link

HttpContext.Current.Request.UserHostAddress;
or
HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];

To get the IP address of the machine and not the proxy use the following code

HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];

private string getUserIPAddress()
{
string strHostName = System.Net.Dns.GetHostName();
string clientIPAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
return clientIPAddress;

}

Find arthimatic operator in string by Using Regex

2011-08-10T04:02:00.000-07:00

function ArthimaticOperation(val) {
//var str="45/52";
var patt1=/[-|*|/|+]{1}/g;
var operator=val.match(patt1);
var temp = new Array();
temp = val.split(val.match(patt1));
var firstVal=temp[0];
var secVal=temp[1];
if(operator=='*')
return firstVal*secVal;
else if(operator=='-')
return firstVal-secVal;
else if(operator=='+')
return firstVal+secVal;
else if(operator=='/')
return firstVal/secVal;
else
return val;

}

Using Regex for Arthimatic operator in string

2011-08-10T03:58:00.001-07:00

Could not load file or assembly

2011-08-04T04:41:00.000-07:00

(HRESULT: 0x80070057 (E_INVALIDARG)) on debug

Issue:
When trying to debug an ASP.net website in Visual Studio you get the following error message:

Could not load file or assembly 'your project' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))

Solution:
Clear out the temporary framework files for your project in:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\

Update:

For Windows 7, the path is:
C:\Users\[username]\AppData\Local\Temp\Temporary ASP.NET Files\

For 64 bit systems with 'Framework' in the path the full path is:
C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\

ASP.Net Interview Question Answer

2011-08-03T22:46:00.000-07:00

ASP.NET 3.5 interview question
http://aspnet2008.blogspot.com/

Introduction to Object Oriented Programming Concepts (OOP) and More
http://www.codeproject.com/KB/architecture/OOP_Concepts_and_manymore.aspx#Interface

C# Interview Questions
http://lionalblog.blogspot.com/

CLR split function return in two column Table format

2011-07-21T03:22:00.000-07:00

This function return Two Column Table for comma separated values.

create a new SQL type project named fn_split
assign a database where you want to use this CLR.
now create a class named fn_split
past the below code
after that build and deploy the code.
now you can use this function in sql
i.e. select * from fn_split('q,w,re,t,y',',')

output :
1 q
2 w
3 re....

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Collections;

public partial class UserDefinedFunctions
{
private class stringiter : IEnumerator
{
string _str;
char delim;
int _start_ix;
int _end_ix;
int _listpos;

public string str
{
get
{
return this._str;
}
}

public int start_ix
{
get
{
return this._start_ix;
}
}

public int end_ix
{
get
{
return this._end_ix;
}
}

public int listpos
{
get
{
return this._listpos;
}
}

public stringiter(SqlString str, SqlString delimiter)
{
this._str = str.IsNull ? "" : str.Value;
this.delim = delimiter.IsNull ? '\0': delimiter.Value.ToCharArray(0, 1)[0];
Reset();
}

public bool MoveNext()
{
this._start_ix = this._end_ix + 1;
if (delim == ' ')
{
while (this._start_ix < this._str.Length && this.str[this._start_ix] == ' ') { this._start_ix++; } } if (this._start_ix >= this._str.Length)
{
return false;
}

this._end_ix = this.str.IndexOf(this.delim, this._start_ix);
this._listpos++;
if (this.end_ix == -1)
{
this._end_ix = this._str.Length;
}
return true;
}

public Object Current
{
get
{
return this;
}
}

public void Reset()
{
this._start_ix = -1;
this._end_ix = -1;
this._listpos = 0;
}
}
[SqlFunction(FillRowMethodName = "CharlistFillRow",TableDefinition="idx int,item nvarchar(4000)")]
public static IEnumerator fn_split(SqlString str, SqlString delimiter)
{
return new stringiter(str, delimiter);
}

public static void CharlistFillRow(object obj,out int listpos,out string str)
{
stringiter iter = (stringiter)obj;
listpos = iter.listpos;
str = iter.str.Substring(iter.start_ix, iter.end_ix - iter.start_ix);
str = str.Trim();
}
};

on sql server query prompt right this to create the assembly and function

CREATE ASSEMBLY fn_split FROM 'C:\somewhere\fn_split.dll'
go
CREATE FUNCTION fn_split (@list nvarchar(MAX), @delim nvarchar(50) = N',')
RETURNS TABLE (str nvarchar(4000))
AS EXTERNAL NAME fn_split.fn_split

Enable CLR using SQL SERVER

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

check

CLR split function for comma separated values and return result in table format

2011-07-21T03:18:00.000-07:00

create a new SQL type project named fn_split
assign a database where you want to use this CLR.
now create a class named fn_split
past the below code
after that build and deploy the code.
now you can use this function in sql
i.e. select * from fn_split('q,w,re,t,y',',')

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Collections;

public partial class UserDefinedFunctions
{
[Microsoft.SqlServer.Server.SqlFunction(FillRowMethodName = "CharlistFillRow", TableDefinition = "item nvarchar(4000)")]
public static IEnumerable fn_split(SqlString str, SqlString delimiter)
{
return str.Value.Split(new string[] { delimiter.Value.ToString() }, StringSplitOptions.None);
}
public static void CharlistFillRow(object row, out SqlString item)
{
item = new SqlString(row.ToString());
//str = str.Trim();
}
};

on sql server query prompt right this to create the assembly and function

CREATE ASSEMBLY fn_split FROM 'C:\somewhere\fn_split.dll'
go
CREATE FUNCTION fn_split (@list nvarchar(MAX), @delim nvarchar(50) = N',')
RETURNS TABLE (str nvarchar(4000))
AS EXTERNAL NAME fn_split.fn_split

Enable CLR using SQL SERVER

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

check

Asynchronous client script callbacks

2011-07-14T03:17:00.001-07:00

the following link contain some useful information about Asynchronous client script callbacks.
Asynchronous client script callbacks

ASP.NET 4.0 Features

2011-07-14T03:15:00.000-07:00

Please read the article in below link for ASP.net 4.0 features
ASP.net 4.0 features

Convert Html to Pdf using iTextSharp

2011-06-09T00:50:00.000-07:00

This is iTestSharp 4.1.2 version and in Asp.net(C#)

Add the iTestSharp dll by adding it as Add Reference into your project and then you create a aspx,ascx page and write the below code into a function and call it from any event or add this function name into page_load event.

using System;
using System.IO;
using System.Configuration;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Collections;
using iTextSharp.text;
using System.Data;
using iTextSharp.text.html;
using iTextSharp.text.pdf;
using System.Web;

private void GeneratePdf()

{

Console.WriteLine("Report");

MemoryStream m = new MemoryStream();

//Response.ContentType = "application/pdf";

//Response.AddHeader("content-disposition", "attachment;filename=VisualROOF Inspection.pdf");

//Response.Cache.SetCacheability(HttpCacheability.NoCache);

// step 1: creation of a document-object

Document document = new Document();

try
{
// step 2

// we create a writer that listens to the document

// and directs a PDF-stream to a file

//PdfWriter writer = PdfWriter.GetInstance(document, Response.OutputStream); PdfWriter writer = PdfWriter.GetInstance(document, m);

writer.CloseStream = false;
// step 3:

// we Add a Footer that will show up on PAGE 1

para.Add(Environment.NewLine);

para.Font =FontFactory.GetFont(FontFactory.HELVETICA, 8, iTextSharp.text.Font.NORMAL,new Color(237,28,36));

para.Add("This document is not a certification");

HeaderFooter footer = new HeaderFooter(para, false);

footer.Alignment = Element.ALIGN_CENTER;

document.Footer = footer;
// we open the document

document.Open();
// we rotate the page and add background image, starting from PAGE 2 document.SetPageSize(PageSize.A4.Rotate());

document.SetMargins(10f,10f,10f,10f);
// step 4: we Add content to the document

// PAGE 1

//add image into pdf

Image pdfImage = Image.GetInstance(Server.MapPath("/images/reports/inspection/InspectionReportImage.jpg"));

pdfImage.ScaleToFit(3500, 845);

pdfImage.Alignment = iTextSharp.text.Image.UNDERLYING; pdfImage.SetAbsolutePosition(2, -5);

document.Add(pdfImage);
// Empty table for spacing

PdfPTable emptytable = new PdfPTable(3);

emptytable.TotalWidth = 560f;

emptytable.HorizontalAlignment = Element.ALIGN_CENTER;

emptytable.LockedWidth = true;

PdfPCell cell1 = new PdfPCell();

cell1.Padding = 60;

cell1.Colspan = 3;

cell1.Border = 0;

emptytable.AddCell(cell1);

document.Add(emptytable);

///actual table for data

/// PdfPTable table = new PdfPTable(3);

table.TotalWidth = 400f;

table.HorizontalAlignment = Element.ALIGN_CENTER;

table.LockedWidth = true;

float[] widths = new float[] { 30f, 50f,50f };

//set the column widths

table.SetWidths(widths);

// Report No header name for cell
PdfPCell cell = new PdfPCell(new Phrase("Report No:", new Font(fBoldHeading, 10, 0, new Color(102, 45, 25))));

cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right

cell.Border = 0;

table.AddCell(cell);
// header Prepared Exclusively for cell

cell = new PdfPCell(new Phrase("Prepared Exclusively for:", new Font(fBoldHeading, 10, 0, new Color(102, 45, 25))));

cell.HorizontalAlignment =1; //0=Left, 1=Centre, 2=Right

cell.Border = 0;

table.AddCell(cell);
cell = new PdfPCell(new Phrase(ReportNo, new Font(fBoldHeading, 10, 0, new Color(0, 0, 0))));

cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right

cell.Border = 0;

table.AddCell(cell);
// Prepared Exclusively Value for cell

cell = new PdfPCell(new Phrase(objInspMgt.PreparedFor, new Font(fBoldHeading, 10, 0, new Color(0, 0, 0))));

cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right

cell.Border = 0;

table.AddCell(cell);
//Add table to Document for First Page

document.Add(table);
//we remove the footer and new footer for page 2

document.ResetFooter();

// we reset the page numbering

//document.ResetPageCount();
// we Add a Footer that will show up on PAGE 2

string spce = " ";

footer = new HeaderFooter(para1, false);

footer.Alignment = Element.ALIGN_CENTER;

footer.Border = Rectangle.TOP_BORDER;

footer.BorderWidthTop = 2;

footer.BorderColorTop = new Color(58, 38, 5);

footer.Bottom = 20f;

document.Footer = footer;
// set page size for all pages

document.SetPageSize(PageSize.A4);

document.SetMargins(10f, 10f, 0f, 10f);
// we trigger a page break Table OF CONTENT

document.NewPage();

// we Add some more content

}
catch (DocumentException de)
{
Console.Error.WriteLine(de.Message);
}
catch (IOException ioe)
{
Console.Error.WriteLine(ioe.Message);
}
// step 5: we close the document

document.Close();

// step 6: Write pdf bytes to outputstream

//Response.Write(document);

//Response.End();

Response.ContentType = "application/pdf";

Response.OutputStream.Write(m.GetBuffer(), 0, m.GetBuffer().Length); Response.OutputStream.Flush();

Response.OutputStream.Close();

m.Close();

}

Change the readmore link text in joomla

2011-06-08T22:36:00.001-07:00

To change the "read more" text

Follow these steps:

-Go to language folder

-Open the en-GB folder

-Find the respective file name like "en-GB.mod_newsflash.ini" or any other, in which the "readmore" link exists.

-Find the read more text in this file and replace it.

Note : In this method its only effect on the module or component you selected, not the whole application.

good luck

Add a new field in com_contact administrator view

2011-06-08T22:35:00.007-07:00

how we add a new field in com_contact administrator?

Ans:

the below files are exist in Administrator Folder ->components->com_contact

"/com_contact/admin.contact.html.php"

Added just above contact position around line 355

Code:

< class="key" valign="top">

< for="region">< ?php echo JText::_( 'Region' ); ?>:< /label>< /td>

< class="inputbox" type="text" name="region" id="region" size="60" maxlength="255" value="">region; ?>" />

< /td>

< /tr>

"/com_contact/tables/contact.php"

Added just under "alias" string:

code:

"var $region = null;

/** @var string */"

In MySQL:

Code:

"mysql> ALTER TABLE jos_contact_details ADD region VARCHAR(60) AFTER alias;"

2011-06-08T22:35:00.005-07:00

how we add a new field in com_contact administrator?

Ans:

the below files are exist in Administrator Folder ->components->com_contact

"/com_contact/admin.contact.html.php"

Added just above contact position around line 355

Code:

< class="key" valign="top">

< for="region">< ?php echo JText::_( 'Region' ); ?>:< /label>< /td>

< class="inputbox" type="text" name="region" id="region" size="60" maxlength="255" value="">region; ?>" />

< /td>

< /tr>

"/com_contact/tables/contact.php"

Added just under "alias" string:

code:

"var $region = null;

/** @var string */"

In MySQL:

Code:

"mysql> ALTER TABLE jos_contact_details ADD region VARCHAR(60) AFTER alias;"

Convert Html to Pdf using iTextSharp

2011-06-08T22:35:00.003-07:00

This is iTestSharp 4.1.2 version and in Asp.net(C#)

private void GeneratePdf()

{

Console.WriteLine("Report");

MemoryStream m = new MemoryStream();

//Response.ContentType = "application/pdf";

//Response.AddHeader("content-disposition", "attachment;filename=VisualROOF Inspection.pdf");

//Response.Cache.SetCacheability(HttpCacheability.NoCache);

// step 1: creation of a document-object

Document document = new Document();

try
{
// step 2

// we create a writer that listens to the document

// and directs a PDF-stream to a file

//PdfWriter writer = PdfWriter.GetInstance(document, Response.OutputStream); PdfWriter writer = PdfWriter.GetInstance(document, m);

writer.CloseStream = false;
// step 3:

// we Add a Footer that will show up on PAGE 1

para.Add(Environment.NewLine);

para.Font =FontFactory.GetFont(FontFactory.HELVETICA, 8, iTextSharp.text.Font.NORMAL,new Color(237,28,36));

para.Add("This document is not a certification");

HeaderFooter footer = new HeaderFooter(para, false);

footer.Alignment = Element.ALIGN_CENTER;

document.Footer = footer;
// we open the document

document.Open();
// we rotate the page and add background image, starting from PAGE 2 document.SetPageSize(PageSize.A4.Rotate());

document.SetMargins(10f,10f,10f,10f);
// step 4: we Add content to the document

// PAGE 1

//add image into pdf

Image pdfImage = Image.GetInstance(Server.MapPath("/images/reports/inspection/InspectionReportImage.jpg"));

pdfImage.ScaleToFit(3500, 845);

pdfImage.Alignment = iTextSharp.text.Image.UNDERLYING; pdfImage.SetAbsolutePosition(2, -5);

document.Add(pdfImage);
// Empty table for spacing

PdfPTable emptytable = new PdfPTable(3);

emptytable.TotalWidth = 560f;

emptytable.HorizontalAlignment = Element.ALIGN_CENTER;

emptytable.LockedWidth = true;

PdfPCell cell1 = new PdfPCell();

cell1.Padding = 60;

cell1.Colspan = 3;

cell1.Border = 0;

emptytable.AddCell(cell1);

document.Add(emptytable);

///actual table for data

/// PdfPTable table = new PdfPTable(3);

table.TotalWidth = 400f;

table.HorizontalAlignment = Element.ALIGN_CENTER;

table.LockedWidth = true;

float[] widths = new float[] { 30f, 50f,50f };

//set the column widths

table.SetWidths(widths);

// Report No header name for cell
PdfPCell cell = new PdfPCell(new Phrase("Report No:", new Font(fBoldHeading, 10, 0, new Color(102, 45, 25))));

cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right

cell.Border = 0;

table.AddCell(cell);
// header Prepared Exclusively for cell

cell = new PdfPCell(new Phrase("Prepared Exclusively for:", new Font(fBoldHeading, 10, 0, new Color(102, 45, 25))));

cell.HorizontalAlignment =1; //0=Left, 1=Centre, 2=Right

cell.Border = 0;

table.AddCell(cell);
cell = new PdfPCell(new Phrase(ReportNo, new Font(fBoldHeading, 10, 0, new Color(0, 0, 0))));

cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right

cell.Border = 0;

table.AddCell(cell);
// Prepared Exclusively Value for cell

cell = new PdfPCell(new Phrase(objInspMgt.PreparedFor, new Font(fBoldHeading, 10, 0, new Color(0, 0, 0))));

cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right

cell.Border = 0;

table.AddCell(cell);
//Add table to Document for First Page

document.Add(table);
//we remove the footer and new footer for page 2

document.ResetFooter();

// we reset the page numbering

//document.ResetPageCount();
// we Add a Footer that will show up on PAGE 2

string spce = " ";

footer = new HeaderFooter(para1, false);

footer.Alignment = Element.ALIGN_CENTER;

footer.Border = Rectangle.TOP_BORDER;

footer.BorderWidthTop = 2;

footer.BorderColorTop = new Color(58, 38, 5);

footer.Bottom = 20f;

document.Footer = footer;
// set page size for all pages

document.SetPageSize(PageSize.A4);

document.SetMargins(10f, 10f, 0f, 10f);
// we trigger a page break Table OF CONTENT

document.NewPage();

// we Add some more content

}
catch (DocumentException de)
{
Console.Error.WriteLine(de.Message);
}
catch (IOException ioe)
{
Console.Error.WriteLine(ioe.Message);
}
// step 5: we close the document

document.Close();

// step 6: Write pdf bytes to outputstream

//Response.Write(document);

//Response.End();

Response.ContentType = "application/pdf";

Response.OutputStream.Write(m.GetBuffer(), 0, m.GetBuffer().Length); Response.OutputStream.Flush();

Response.OutputStream.Close();

m.Close();

}