asadullahabkari

Copyright Law: 12 Dos and Don’ts

2011-07-14T06:36:00.001-07:00

As the blogging phenomenon expands, copyright concerns become quite important. Technology makes it really easy to copy, modify and share information, whether we talk about text, images, audio or video. The problem is that the vast majority of people do not have a clear understanding of the Copyright Law, which might result in illegal and costly mistakes. Below you will find 12 Do’s and Dont’s that will clarify what you can and what you can not do as an online publisher:
DOS
1. Do use material under public domain: you are free to use any work that is in public domain. This includes federal government documents, materials produced before 1923 and materials produced before 1977 without a copyright notice.
2. Do quote something you find interesting: the Copyright Act defines that short quotations for the purpose of criticism, commentary or news reporting are considered “fair use”. Notice that the quote should involve only a small portion of the work, and it should not replicate the “heart” of the material.
3. Do use facts and ideas: Copyright Law protects the expression of facts and ideas. That is the form, combination and structure of documents and not the facts themselves. You are free to use facts and ideas reported on articles or websites.
4. Do use other materials that are not subject to copyright: apart from facts and ideas there are many other classes of materials that can not be protected under the Copyright Law. Those materials include names, familiar symbols, listings of ingredients or contents, short phrases, titles, slogans and procedures (notice that some of those materials might be protected by trademark, though).
5. Do use a company name or logo if you are talking about it: trademarks should protect a company from people trying to use its name or logo to deceive customers. If you are criticizing or analyzing a company, however, you can use its name or logo under a “nominative fair use”.
6. Do use a company name on your domain: as mentioned on the previous item you can use a company’s name as long as you are not trying to deceive people that you speak on behalf of this company or that you are related to it in any way. This right applies to domain names. Someone could create a website to complain about a company, say Microsoft, and use a domain name that contains the name of this company, say microsoftsucks.com.
DON’TS
7. Don’t assume that if you credit the author there is no copyright infringement: a lot of people wrongly think that if they credit the author of an article or image they are not violating the copyright law. You can only use copyrighted material if you have explicit permission from the author to do so (or if you make fair use of it, as explained before).
8. Don’t copy material just because it does not show a copyright message: the Copyright Law required a copyright notice to protect works until 1977. In 1978, however, the law changed and abolished the requirement for copyright notice. This means that every published work (be it on paper or digital media) automatically gets copyright protection, whether expressed with a notice or not.
9. Don’t equate Creative Commons with “free for grab”: while Creative Commons licenses are less restrictive then standard copyright they should not be interpreted a “free for grab”. In order to understand what you can or can not do with Creative Commons material you should check what kind of license it is using. Certain licenses will require you to credit the original author, while others will require that you release any modifications of the document under the same license.
10. Don’t copy material just because you are not making a commercial use: while making commercial use of copyrighted material might make it easier for the author to claim damages against you the commercial use per se is not a requirement for copyright infringement. Even if you are not making a commercial use of the material you are still infringing the law if you do not have a permission from the author.
11. Don’t assume that if you remove the copyrighted material you will be out of trouble: a lot of people copy images and text around the Internet thinking that in the worst of the cases they will receive a take down notice from the author and remove the material from the website. The removal of the copyrighted material will not remove the copyright infringement at all. Should the author decide to go after you in count you will be in trouble all the same.
12. Don’t copy material just because you can’t find a copyright holder: the fact that a copyright holder can not be identified does not imply that the material can be freely copied. Similarly if you locate the copyright holder, email him asking permission and receive no answer back you would still be infringing the law if you use the material.
This article was not written by a lawyer and it does not intend to constitute legal advice.

8 Ways To Promote Your Blog On Facebook

2011-07-14T06:13:00.000-07:00

Written by Rajeev Edmonds | Tags: Social Media Marketing
Facebook is one of the most popular social networking sites in the world. It has millions of members with a large user base of professionals, readers, bloggers, intellects and casual readers. Recently, facebook has revamped its interface and provides immense opportunities to promote your online business. There are several techniques to promote your blog or website on facebook.

Make Your Profile Visible

Make sure you do not restrict your facebook profile from getting indexed in search engines. Update the privacy settings and make it open for everyone, including the whole facebook community.

Add Blog Info To Profile

Needless to say, adding your blog information to your facebook profile is one of the most important settings in your profile. Add your blog URL to your basic information section and make it visible to all.

Use 3rd Party Apps

There are tons of 3rd party applications for facebook that can be easily integrated with your profile. You can browse the categorized application catalog and can use the selective applications that can promote and highlight your blog. Most famous are RSS aggregators and social media services mash up applications.

Publish RSS Feeds

Use RSS feed aggregator applications like Simplaris Blogcast and Blog RSS Feed Reader to publish your blog feed in your facebook profile. Customize it according to your needs and integrate it with your profile page.

Join Relevant Groups

This is one more method to give more exposure to your blog. Browse through various groups on facebook and take membership of those groups that provide promotion of blogs, social networking and social media marketing services to members.

Make a Facebook Page

Facebook page is an excellent strategy to promote your online business. With page application you can create a dedicated page for your blog and fill it with tons of added sections. People can subscribe and become fan of your facebook page, and can take part in polls, discussions, forum posting, photo uploading and tagging and much more.

Advertise On Facebook

Running a PPC campaign on facebook is one more option to give good exposure to your blog. You can get low cost advertising solutions with ad customization and filtering targeted readers for your ad.

Socialize and Network

And last but not the least, create a strong network of friends and keep your profile updated. Spend time in sharing and posting things on your wall, and interact with communities.

Over To You

Do you use Facebook as one of your blog promotion strategies? How much time you spend each day on facebook? What other techniques you use on facebook for promoting your online presence?

Image Credit: Facebook

Original Article :

http://www.mintblogger.com/2008/10/8-ways-to-promote-your-blog-on-facebook.html

Tutorial on Getting Web Site Traffic in Less Than One Day!

2011-07-13T04:53:00.001-07:00

Every web site owner has wanted to drive additional traffic to their web site – and of course we’re all in a big hurry to do it. But have you ever thought about the fact that any webmaster can drive great qualified traffic to their site in less than one day? That’s right – you can literally set up an entire traffic driving campaign and see the traffic coming to your site even in the same day! Here’s how:

Harness the Power of Targeted Search with Google

The absolute fastest way to get really serious targeted traffic to your web site is to use the power of Google. You know, Google - the guys that get, oh say, over 50% of all searches conducted on the Internet today. Yeah Google - the guys who figured out how to produce relevant search results. Google - the guys who went public and made like 20 zillion dollars. That Google.

They have a brain-dead easy-to-use advertising product called Google AdWords – and you can set up an account, create keywords, have them appear on the relevant search terms in the Google search engine, and see real live qualified traffic to your web site in the space of a few hours.

Setting Up a Google AdWords Account Step-by-Step

Okay, take a deep breath. Settle into the chair in front of your computer and get ready to go. Follow these steps exactly:

1. Navigate your browser to: https://adwords.google.com/select and click on the ‘Sign Up Now’ area.

2. Select the appropriate language and gepgraphical targeting – ‘Regions and cities’ if you are a local business, ‘Global or nationwide’ if you serve all regions (we’ll use this setting for our example). Click the ‘Save and Continue’ button.

3. Next you choose your countries. If you are a North American business, I highly recommend selecting ‘United States’ only. To do this – go to the right hand box entitled ‘Selected Countries’ and highlight ‘All Countries’ with your mouse. Then click the ‘Remove’ button. The ‘Selected Countries’ box will now be empty. Go to the left column and highlight ‘United States’ – then click the ‘Add’ button. Click the ‘Save and Continue’ button.

4. Now you name your ad group and create your first online ad. Don’t worry – you can always go back and edit your ad at anytime. Just have fun with it for now! To get started, think up a name that you want to call your first group of ads. Type this name into the box labeled: ‘Name this Ad Group’.

Now go to section ‘A: Create Ads’ just below. You simply fill in the boxes and Google does this cool ‘automatic update’ that shows you what your ad will look like as you are filling in the boxes. When you have an ad that you like - click the ‘Save and Continue’ button.

5. Choose the keywords that will trigger your ad. If you sell ‘tennis rackets’ then start with that keyword. If you sell ‘palm pilots’ then start with that. Once you have typed in a search term, you can always use the ‘Keyword Suggestion Tool’ link on the same page to expand your list. Google will automatically suggest words that may expand your traffic. Be sure to do a reality check against this list – it’s automated and some terms may not be appropriate for your business. Once you have a list of keywords, click the ‘Save Keywords’ button to continue.

6. Choose your maximum bid. I always set this to $.05 (five cents) to start. This is Google’s minimum bid amount. You can always change it later if you need more traffic. Type in .05 and click the ‘Calculate Estimates’ button. Ignore the resulting estimates – they are almost always wrong. Simply click the ‘Save and Continue’ button. At this step Google will ask if you want to create another ad group – simply bypass this step by clicking the ‘Continue to Step 3’ button.

7. Now you specify you daily budget. I suggest being conservative here as well. You can always increase this later. For now – figure out how much you can spend each month for traffic and divide by 30. Put in an amount that is this number or even lower. I usually start with $5 per day as a maximum. When you’ve decided, simply click the ‘Save and Continue’ button.

8. Entering your contact information and password. This step requires you to give Google a valid email address that you can check – in order to send you to the final confirmation and billing step. Fill in your email and pick a password that you can remember – preferably one that has at least 1 numeral and is difficult to duplicate easily.

When you’ve filled in your information, click the ‘I agree – Create my AdWords account’ button.

At this point you should see the following message: “Thank you for signing up with AdWords. Please check your email (you@youremail.com) for a message from Google containing a link to our verification program.” Follow the link in that message to confirm that we have your correct email address.

9. Check your email and finish setting up your account. Go to your eamil and retireve the Google email. Follow the link inside – this will verify that your email is valid. Then simply login to your AdWords account using the email address and password that you supplied in the last step.

10. Once you log in you will see the following message: “Note: Your account hasn't been activated. Payment information is required in order to run your ads. Please provide your payment information on the Billing Preferences page in the "My Account" section. Typically, your ads will begin running almost immediately after you submit this information.” Simpy follow the ‘Billing Prefences’ link and enter your credit card information. When complete click the ‘Save Changes’ button.

11. Your AdWords account is now live! You will see traffic from your ads coming to your site almost immediately if you have selected popular keywords.

Then entire process described above can easily be completed in less than 2 hours. I just did it myself in less than an hour. Good luck and remember if you ever have any problems with the account running through too much cash – you can simply ‘pause’ the account giving you time to reduce your bids, or delete keywords. While you won’t become an AdWords expert from this start up guide, you will begin to see highly targeted web traffic come to your site in less than one day!

Case-insensitive string compare in .NET

2011-07-06T06:02:00.001-07:00

string.Equals("string number 1", "String NUMBER 1", StringComparison.CurrentCultureIgnoreCase)

Merging two Datatables

2011-07-05T07:01:00.002-07:00

Code for Merging two datatable is given below

DataTable dt = dsSearch.Tables[0];
DataTable dt1 = dsSearch2.Tables[0];

dt.Merge(dt1);

First you must have two databale of same columns name i repeat both of them must have same column name like

datatable 1 colname sno , name , email address
datatable 2 colname sno , name , email_address

but if you merge them output will be

sno , name , email address ,email_address

but if
datatable 1 colname sno , name , email address
datatable 2 colname sno , name , email_address

then after merging

sno , name , email address

C# Transpose DataTable

2011-07-05T07:01:00.001-07:00

private DataTable GenerateTransposedTable(DataTable inputTable)
{
DataTable outputTable = new DataTable();

// Add columns by looping rows

// Header row's first column is same as in inputTable
outputTable.Columns.Add(inputTable.Columns[0].ColumnName.ToString());

// Header row's second column onwards, 'inputTable's first column taken
foreach (DataRow inRow in inputTable.Rows)
{
string newColName = inRow[0].ToString();
outputTable.Columns.Add(newColName);
}

// Add rows by looping columns
for (int rCount = 1; rCount <= inputTable.Columns.Count - 1; rCount++)
{
DataRow newRow = outputTable.NewRow();

// First column is inputTable's Header row's second column
newRow[0] = inputTable.Columns[rCount].ColumnName.ToString();
for (int cCount = 0; cCount <= inputTable.Rows.Count - 1; cCount++)
{
string colValue = inputTable.Rows[cCount][rCount].ToString();
newRow[cCount + 1] = colValue;
}
outputTable.Rows.Add(newRow);
}

return outputTable;
}

If you are going to transporse a datatable means converting rows into column than you have to copy this method and use it

private DataTable GenerateTransposedTable(DataTable inputTable)
{
DataTable outputTable = new DataTable();

// Add columns by looping rows

// Header row's first column is same as in inputTable
outputTable.Columns.Add(inputTable.Columns[0].ColumnName.ToString());

// Header row's second column onwards, 'inputTable's first column taken
foreach (DataRow inRow in inputTable.Rows)
{
string newColName = inRow[0].ToString();
outputTable.Columns.Add(newColName);
}

// Add rows by looping columns
for (int rCount = 1; rCount <= inputTable.Columns.Count - 1; rCount++)
{
DataRow newRow = outputTable.NewRow();

// First column is inputTable's Header row's second column
newRow[0] = inputTable.Columns[rCount].ColumnName.ToString();
for (int cCount = 0; cCount <= inputTable.Rows.Count - 1; cCount++)
{
string colValue = inputTable.Rows[cCount][rCount].ToString();
newRow[cCount + 1] = colValue;
}
outputTable.Rows.Add(newRow);
}

return outputTable;
}

A guide to study visa of Canada

2011-07-02T06:27:00.001-07:00

Obtaining a study permit of Canada is a quick and easy method to get Canadian Immigration. If you are thinking to apply for a study permit for Canada, you have to read following steps for submission of appication for study permit in Canada.

First of all you have to obtain study permit forms in your country of origin at the Canadian Embassy, High Commission or Canadian Education Centre. The application for a student visa is also available online at cic website

http://www.cic.gc.ca/english/information/applications/student.asp

Necessary documentation for student visas canada:
It is critical that students submit all necessary documentation along with their applications of study permit to Canada. Missing documentation will cause delay the approval process of canadian student visa.

The documents listed below are generally needed bearing your application, local requirements may also apply for study permit in Canada.

1. Proof of identity:
This includes photocopies of a valid passport two recent passport-size photos (2" x 2.5") for each family member, with the date of birth and full name written on the backside of each photo.

2. Proof of financial support:
You have to prove that you have enough funds to fulfill your tuition and living costs in Canada. The living costs in Canada are approx $10,000 CDN (extra funds are required if there are other family members going with you).
You can prove your financial position by showing your own bank statements for the past four to six months, a Canadian bank account or a bank draft in convertible currency, or proof of payment of tuition and residence fees. (Tip: $10,000 CDN in addition to tuition fees per academic year are normally viewed as enough)

3. Medical examination:
Medical exams are necessary if your stay in Canada as a student is longer than six months and you come from a country with far above the ground health risks. The processing of medical will add quite a few weeks to the time essential to obtain a study permit. In rare cases, you may require a medical examination although your course is less than six months in duration.

4. Acceptance letter by an approved educational institution:
You have to add a proof of an acceptance letter from a recognized institute of Canada. The following information ought to be included in letter of acceptance:
· Name of the student.
· Date of Birth of the student.
· Mailing address of student.
· The course in which the student has been enrolled.
· The estimated duration of the course.
· Date on which the course begins.
· Last date on which the student must register for the course.
· The academic year which the student will be entering.
· Whether the course is full or part-time.
· Tuition fee.
· Any conditions of acceptance.
· Clear classification of the educational institution.
· Licensing information (In case private institutions)

This letter has to be signed by an official representative of the institution.

5. A proof of custodianship in Canada:
If you are a minor (less than 18 years of age), you must provide a notarized statement signed by your parents or legal guardian in the country of your origin in addition to a notarized statement signed by the guardian in Canada stating that sufficient preparations have been made for the guardian in Canada to act on behalf of a parent in times of urgent situation, for instance when medical attention is required.
Once you have finished the application forms and have collected the necessary documentation for student visa canada, go on to the visa office nearby you and submit the required information along with a fee of student visa canada.

After evaluation of your study visa application, a visa officer must be convince that you meet the requirements of the Canadian Immigration Act and Regulations and that your intension to get a student visa canada is just for study and live in Canada temporarily.

Once the visa officer is contented that you are a genuine student and all legal requirements are met, you will be issued a document which is required to be shown to an immigration officer at the port of entry in Canada in order to get a study permit there.

As your study permit will usually be valid for the period of your course, please make sure that your passport is also valid for that same period of time.
Posted by Sheikh Muhammad Haris at 12:56 AM 0 comments Links to this post
Labels: Canada, guide, study visa

How to avoid getting banned by Google

2011-07-02T06:26:00.001-07:00

If you wake up and find one day that your website isn’t showing anymore in Google, you have been a victim of a Google Ban. This is the worst thing that can happen to your website, especially if you are running a business through your site. Several factors can trigger a Google Ban. Here is a list of ways you can keep your website on Google’s good side.

1. Make sure your have the best uptime possible for your website. This means you must have reliable web hosting. If Google visits your website and it is not up, you may risk Google banning you site.

2. Do not use spamming techniques to promote your website. This will almost definitely lead to condemnation of your website for at least 6 months. Never use “black hat” methods like doorways, hidden text or cloaking. You are only setting yourself up for disaster.

3. Make sure your content is original and relevant. Websites that duplicate content are punished with lower rankings and even bans. Your content should always be made for human consumption and relate to your website’s theme.

4. Linking is a two way street. Not only should the links going out of your website be quality, but be certain that the links that lead to your website are from Google respected locations as well. Avoid link farms and any paid linking service. Also, excessive linking is a red flag for Google. When you add internal links on your own sites, make sure you do it in moderation and with purposeful intent.

5. Be sure your site is Google friendly. Build your website so that Google is able to index every page. Include a sitemap. Be sure all your pages are working and that there are no broken links.

If you follow the Google “Tips for Optimizing” you will be fine. Don’t try to fool Google with tricky tactics. The price you will pay is far worse than the effort it takes to do things the right way!
Posted by Sheikh Muhammad Haris at 9:17 PM 0 comments Links to this post
Labels: Avoid, Banned, Google

All Check Boxes check of Respective inner repeater

2010-12-22T04:18:00.001-08:00

Step : 1

function CheckAllRoleCheckBoxesParent(obj)
{
//alert(2);
//debugger;
chk = document.documentElement.getElementsByTagName('input');
var Parent=obj.attributes['Parent'].nodeValue;

for(var i=0; i {
if(chk[i].attributes["type"].nodeValue == "checkbox")
{
if(chk[i].attributes['Parent1'] != null)
{
//alert('checkbox');
if(chk[i].attributes['Parent1'].nodeValue==Parent)
{
//alert(chk[i].attributes['rolecode'].nodeValue + '=' + rc);
//chk[i].checked=obj.checked;
chk[i].click();
}
}

}

}
}

Strep : 2

<input id="chk" runat="server" type="checkbox" value='<%#Eval("Location")%>'
onclick="javascript:CheckAllRoleCheckBoxesParent(this);" Parent='<%#Eval("id")%>'/>
<%#Eval("Location")%>

Step:3

protected string Parent1;

Step :4

On Item Databound ofParent

Parent1 = DataBinder.Eval(e.Item.DataItem, "id").ToString();

Select Distinct from DataTable

2010-09-16T23:24:00.000-07:00

public DataSet ds = new DataSet();

DataTable dtDate = SelectDistinct("aaa", dt, "Date");

public DataTable SelectDistinct(string TableName, DataTable SourceTable, string FieldName)
{
DataTable dt = new DataTable(TableName);
dt.Columns.Add(FieldName, SourceTable.Columns[FieldName].DataType);

object LastValue = null;
foreach (DataRow dr in SourceTable.Select("", FieldName))
{
if (LastValue == null || !(ColumnEqual(LastValue, dr[FieldName])))
{
LastValue = dr[FieldName];
dt.Rows.Add(new object[] { LastValue });
}
}
if (ds != null)
ds.Tables.Add(dt);
return dt;
}
private bool ColumnEqual(object A, object B)
{

// Compares two values to see if they are equal. Also compares DBNULL.Value.
// Note: If your DataTable contains object fields, then you must extend this
// function to handle them in a meaningful way if you intend to group on them.

if (A == DBNull.Value && B == DBNull.Value) // both are DBNull.Value
return true;
if (A == DBNull.Value || B == DBNull.Value) // only one is DBNull.Value
return false;
return (A.Equals(B)); // value type standard comparison
}

Impersonation webconfig

2010-09-16T00:30:00.000-07:00

<system.web>
<identity impersonate="true" username="Domain\username" password="password">
</system.web>

Impersonation Programmatically

2010-09-16T00:27:00.000-07:00

public const int LOGON32_LOGON_INTERACTIVE = 2;
public const int LOGON32_PROVIDER_DEFAULT = 0;

WindowsImpersonationContext impersonationContext;

[DllImport("advapi32.dll")]
public static extern int LogonUserA(String lpszUserName,
String lpszDomain,
String lpszPassword,
int dwLogonType,
int dwLogonProvider,
ref IntPtr phToken);
[DllImport("advapi32.dll", CharSet = CharSet.Auto, SetLastError = true)]
public static extern int DuplicateToken(IntPtr hToken,
int impersonationLevel,
ref IntPtr hNewToken);

[DllImport("advapi32.dll", CharSet = CharSet.Auto, SetLastError = true)]
public static extern bool RevertToSelf();

[DllImport("kernel32.dll", CharSet = CharSet.Auto)]
public static extern bool CloseHandle(IntPtr handle);

private bool impersonateValidUser(String userName, String domain, String password)
{
WindowsIdentity tempWindowsIdentity;
IntPtr token = IntPtr.Zero;
IntPtr tokenDuplicate = IntPtr.Zero;

if (RevertToSelf())
{
if (LogonUserA(userName, domain, password, LOGON32_LOGON_INTERACTIVE,
LOGON32_PROVIDER_DEFAULT, ref token) != 0)
{
if (DuplicateToken(token, 2, ref tokenDuplicate) != 0)
{
tempWindowsIdentity = new WindowsIdentity(tokenDuplicate);
impersonationContext = tempWindowsIdentity.Impersonate();
if (impersonationContext != null)
{
CloseHandle(token);
CloseHandle(tokenDuplicate);
return true;
}
}
}
}
if (token != IntPtr.Zero)
CloseHandle(token);
if (tokenDuplicate != IntPtr.Zero)
CloseHandle(tokenDuplicate);
return false;
}

private void undoImpersonation()
{
impersonationContext.Undo();
}

BindData()

{

if (impersonateValidUser("abc", "abc", "abc"))
{

//work
undoImpersonation();

}
}

Conversion of Datarow [] to Datatable

2010-09-16T00:25:00.000-07:00

dt = new DataTable();
dt.Columns.Add("Industries", typeof(string));
dt.Columns.Add("Project", typeof(string));
dt.Columns.Add("FolderName", typeof(string));
dt.Columns.Add("FolderPath", typeof(string));
dt.Columns.Add("Date", typeof(string));

foreach (DataRow dr in dto)
{
dt.ImportRow(dr);
}
dt.AcceptChanges();

dt.Select(Date Filter)

2010-09-16T00:24:00.000-07:00

string filter = "[Date] >= '" + Convert.ToDateTime(txtTo.Text).ToShortDateString() + "' AND [Date] <= '" + Convert.ToDateTime(txtFrom.Text).ToShortDateString() + "'";

DataRow[] dto = notDownloaded.Select(filter);
//DataRow[] dto = notDownloaded;

CSV to DataTable Conversion

2010-06-17T02:22:00.000-07:00

public static DataTable csvToDataTable(string file, bool isRowOneHeader)
{

DataTable csvDataTable = new DataTable();

//no try/catch - add these in yourselfs or let exception happen
String[] csvData = File.ReadAllLines(HttpContext.Current.Server.MapPath(file));

//if no data in file ‘manually’ throw an exception
if (csvData.Length == 0)
{
throw new Exception(”CSV File Appears to be Empty”);
}

String[] headings = csvData[0].Split(’,');
int index = 0; //will be zero or one depending on isRowOneHeader

if(isRowOneHeader) //if first record lists headers
{
index = 1; //so we won’t take headings as data

//for each heading
for(int i = 0; i < headings.Length; i++)
{
//replace spaces with underscores for column names
headings[i] = headings[i].Replace(” “, “_”);

//add a column for each heading
csvDataTable.Columns.Add(headings[i], typeof(string));
}
}
else //if no headers just go for col1, col2 etc.
{
for (int i = 0; i < headings.Length; i++)
{
//create arbitary column names
csvDataTable.Columns.Add(”col”+(i+1).ToString(), typeof(string));
}
}

//populate the DataTable
for (int i = index; i < csvData.Length; i++)
{
//create new rows
DataRow row = csvDataTable.NewRow();

for (int j = 0; j < headings.Length; j++)
{
//fill them
row[j] = csvData[i].Split(’,')[j];
}

//add rows to over DataTable
csvDataTable.Rows.Add(row);
}

//return the CSV DataTable
return csvDataTable;

}

Check Box Click Enable Disable Row Elements

2010-06-11T00:50:00.000-07:00

Step :1 (JavaScript)

function EnableDisableTextBox(objCheckBox, objName,objName2)
{
try
{
var chk = document.getElementById(objCheckBox);
var CategoryName = document.getElementById(objName);
var CategoryName2 = document.getElementById(objName2);
//var CategoryABBR = document.getElementById(objABBR);

if(chk.checked)
{
clr="FFFFFF";
CategoryName.Enabled = true;
CategoryName.removeAttribute('disabled');
CategoryName.style.background=clr;
CategoryName.focus();

CategoryName2.Enabled = true;
CategoryName2.removeAttribute('disabled');
CategoryName2.style.background=clr;

//CategoryABBR.Enabled = true;
//CategoryABBR.style.background=clr;
// CategoryABBR.removeAttribute('disabled');

}
else
{
//clr="D4D0C8";
clr="F6F6F6";

CategoryName.setAttribute('disabled','disabled');
CategoryName.style.background=clr;
CategoryName.Enabled = false;
CategoryName.value='';
CategoryName2.setAttribute('disabled','disabled');
CategoryName2.style.background=clr;
CategoryName2.Enabled = false;
CategoryName2.value='';
// CategoryABBR.setAttribute('disabled','disabled');
// CategoryABBR.style.background=clr;
// CategoryABBR.Enabled = false;
}

}
catch(e)
{
}

}

Step:2 (CS File)

protected void rptLinks_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
HtmlInputCheckBox chkFunctions = HtmlInputCheckBox)e.Item.FindControl("chkFunctions");
chkFunctions.Attributes.Add("onclick", "EnableDisableTextBox('" + chkFunctions.ClientID + "','" + txtQuantity.ClientID + "','" + txtTo.ClientID + "')");
}

}

Step 3(aspx)

<input id="chkFunctions" runat="server" type="checkbox" />

Clear all the fields

2010-06-03T07:59:00.000-07:00

var elements = document.getElementsByTagName("input");
for (var ii=0; ii < elements.length; ii++) {
if (elements[ii].type == "text") {
elements[ii].value = "";
}
}

Multiple Fields Search Stored Procedure

2010-06-03T00:46:00.000-07:00

ALTER PROCEDURE XPS_TemplateSearch
@Template_Name varchar(100) = null,
@TemplateType_Code int = null,
@Subject varchar(200) = null
AS
BEGIN
--select * from [XPS_Template] where Template_Name=@Template_Name or TemplateType_Code=@TemplateType_Code or Subject=@Subject is_Active=1

IF(@Template_Name = '')
SET @Template_Name = null
IF(@TemplateType_Code = -1)
SET @TemplateType_Code = null
IF(@Subject = '')
SET @Subject = null

--DECLARE @Qry VARCHAR(1000)
--SET @Qry = 'select * from [XPS_Template] where is_Active=1 and ( Template_Name like ''%'+@Template_Name+'%'' or TemplateType_Code ='+convert(varchar(20),@TemplateType_Code)+' or Subject Like ''%'+@Subject+'%'')'
--select @Qry
--print @Qry

select *
from [XPS_Template]
where is_Active=1
and Template_Name like case when @Template_Name is not null then @Template_Name
when @Template_Name is null then Template_Name end
and TemplateType_Code = case when @TemplateType_Code is not null then @TemplateType_Code
when @TemplateType_Code is null then TemplateType_Code end
and [Subject] like case when @Subject is not null then @Subject
when @Subject is null then [Subject] end

/*and (
Template_Name like ISNULL(@Template_Name,Template_Name)
or TemplateType_Code = ISNULL(@TemplateType_Code,TemplateType_Code)
or [Subject] like ISNULL(@Subject,[Subject])
)
*/

END

Dynamic Query Like

2010-06-03T00:30:00.001-07:00

--SET @Qry = 'select * from [XPS_Template] where is_Active=1 and ( Template_Name like ''%'+@Template_Name+'%'' or TemplateType_Code ='+convert(varchar(20),@TemplateType_Code)+' or Subject Like ''%'+@Subject+'%'')'
--select @Qry
--print @Qry

dynamic Query For any Colum name and Value

2010-06-02T23:49:00.001-07:00

CREATE PROCEDURE [dbo].[Display_Select_Student]
(
@Col_Name varchar(500)=null,
@Col_Value varchar(500)=null
)

AS
BEGIN
SET NOCOUNT ON;

DECLARE @Qry VARCHAR(1000)
SET @Qry = 'SELECT * FROM [Student] WHERE '+@Col_Name+'='''+@Col_Value+''''

EXEC(@Qry)

SET NOCOUNT OFF;
END

SQL SERVER – DBCC RESEED Table Identity Value – Reset Table Identity

2010-05-28T13:05:00.000-07:00

DBCC CHECKIDENT can reseed (reset) the identity value of the table. For example, YourTable has 25 rows with 25 as last identity. If we want next record to have identity as 35 we need to run following T SQL script in Query Analyzer.

DBCC CHECKIDENT (yourtable, reseed, 34)

If table has to start with an identity of 1 with the next insert then table should be reseeded with the identity to 0. If identity seed is set below values that currently are in table, it will violate the uniqueness constraint as soon as the values start to duplicate and will generate error.

Image Uploader

2010-05-28T01:27:00.000-07:00

private void UploadLogo(string LogoFileName)
{
if (FileUpload1.HasFile)
{
string fileExt =
System.IO.Path.GetExtension(FileUpload1.FileName);

try
{

if (Directory.Exists(Server.MapPath("..\\AssociateLogos")))
{
//string path = "\\images\\";
string path = "..\\AssociateLogos\\";

int a = LogoFileName.LastIndexOf("/");
string fileName = LogoFileName.Substring(a+1);
string Serverpath = Server.MapPath(path);
FileUpload1.SaveAs(Serverpath +
fileName);
Label1.Text = "File name: " +
FileUpload1.PostedFile.FileName + "
" +
FileUpload1.PostedFile.ContentLength + " kb
" +
"Content type: " +
FileUpload1.PostedFile.ContentType;
}
else
{
Directory.CreateDirectory(Server.MapPath("..\\AssociateLogos"));
string path = "..\\AssociateLogos\\";
string Serverpath = Server.MapPath(path);
FileUpload1.SaveAs(Serverpath +
LogoFileName);
Label1.Text = "File name: " +
FileUpload1.PostedFile.FileName + "
" +
FileUpload1.PostedFile.ContentLength + " kb
" +
"Content type: " +
FileUpload1.PostedFile.ContentType;
}
}
catch (Exception ex)
{
Label1.Text = "ERROR: " + ex.Message.ToString();
}

}
else
{
Label1.Text = "You have not specified a file.";
}
}

Splitting CSV

2010-05-27T21:38:00.000-07:00

#region "Splitting CSV"
private int[] commaStrToArray(string strIntComma)
{ string [] strArray; strArray = strIntComma.Split(new char[] {','}); int [] intArray = new int [strArray.Length]; for (int i = 0; i < strArray.Length; i++) intArray[i] = int.Parse(strArray[i]); return intArray; }

#endregion

Drop Down List Select All

2010-05-24T05:32:00.000-07:00

ddlKeywords.Items.Insert(0, new ListItem("--All--", "-1"));

Temp Table Creation Insertion and Display

2010-05-24T02:03:00.000-07:00

declare @table table(id int identity(1,1),userid int, Fullname varchar(250),DepartmentName)
insert into @table(userid,Fullname,DepartmentName)
select distinct a.userid , fullname ,deptname from table1
select * from @table