Kannabiran's Dot Net Development Zone

How to find the files from all the sub folders in C#.Net?

2011-06-27T23:39:00.000-07:00

using System.IO;

string[] filePaths = Directory.GetFiles(@"C:\Kanna\", "*.jpg", SearchOption.AllDirectories);

How to round the decimal values in C#.Net?

2011-06-27T23:25:00.000-07:00

string text = "19500.36";
decimal value;
if (decimal.TryParse(text, out value))
{
value = Math.Round(value);
text = value.ToString();
// Do something with the new text value
}
else
{
// Tell the user their input is invalid
}

How to find Gridview row?

2011-02-28T22:22:00.000-08:00

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ImageButton btn = (ImageButton)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;

string value = GridView1.Rows[row.RowIndex].Cells[0].Text;
Session["value"] = value;
}

What is C# Guid.empty() equivalent in Sql Server?

2011-02-16T05:07:00.000-08:00

C#
--
Guid.empty()

SQL
---
cast(cast(0 as binary) as uniqueidentifier)

How to make CD Autorun?

2010-09-19T22:13:00.001-07:00

For msi file. save as autorun.inf
=================================

[autorun]
ShellExecute=MyInstaller-1.0.0.msi
label=My CD Label
icon=MyIcon.ico

for exe file. save as autorun.inf
=================================

[autorun]
open=Test.exe
label=My CD Label
icon=MyIcon.ico

Often the program you want to run will not be located in the root directory of the CD. If that is the case you must include the path in autorun.inf:

[autorun]
open=folder1\folder1A\myfile.exe
icon=myicon.ico

Sometimes you may also need to pass an argument to the program to be auto played:

[autorun]
open=myprogram.exe /argument
icon=myicon.ico

To open the html file ‘index.htm’ would require:
===============================================

[autorun]
ShellExecute=index.htm
icon=index.htm

However, since some older versions of Windows do not support ‘ShellExecute’ a less elegant alternative would be:

[autorun]
open=command /c start index.htm
icon=index.htm

What is difference between DELETE & TRUNCATE commands?

2010-09-16T02:11:00.000-07:00

Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.

TRUNCATE

TRUNCATE is faster and uses fewer system and transaction log resources than DELETE.

TRUNCATE removes the data by deallocating the data pages used to store the table’s data, and only the page deallocations are recorded in the transaction log.

TRUNCATE removes all rows from a table, but the table structure and its columns, constraints, indexes and so on remain. The counter used by an identity for new rows is reset to the seed for the column.

You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY constraint.

It cannot activate a trigger.

TRUNCATE can not be Rolled back using logs.

TRUNCATE is DDL Command.

TRUNCATE Resets identity of the table.

DELETE

DELETE removes rows one at a time and records an entry in the transaction log for each deleted row.If you want to retain the identity counter, use DELETE instead. If you want to remove table definition and its data, use the DROP TABLE statement.

DELETE Can be used with or without a WHERE clause

DELETE Activates Triggers.

DELETE Can be Rolled back using logs.

DELETE is DML Command.

DELETE does not reset identity of the table.

What is normalization and their different forms?

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

Database normalization is a data design and organization process applied to data structures based on rules that help build relational databases. In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.

Types	Description
1NF	Eliminate Repeating Groups Make a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain.
2NF	Eliminate Redundant Data If an attribute depends on only part of a multi-valued key, remove it to a separate table.
3NF	Eliminate Columns Not Dependent On Key If attributes do not contribute to a description of the key, remove them to a separate table. All attributes must be directly dependent on the primary key
BCNF	Boyce-Codd Normal Form If there are non-trivial dependencies between candidate key attributes, separate them out into distinct tables.
4NF	Isolate Independent Multiple Relationships No table may contain two or more 1:n or n:m relationships that are not directly related.
5NF	Isolate Semantically Related Multiple Relationships There may be practical constrains on information that justify separating logically related many-to-many relationships.
ONF	Optimal Normal Form A model limited to only simple (elemental) facts, as expressed in Object Role Model notation.
DKNF	Domain-Key Normal Form A model free from all modification anomalies.
Remember, these normalization guidelines are cumulative. For a database to be in 3NF, it must first fulfill all the criteria of a 2NF and 1NF database.

What is View?

2010-09-16T00:04:00.001-07:00

A simple view can be thought of as a subset of a table. It can be used for retrieving data, as well as updating or deleting rows. Rows updated or deleted in the view are updated or deleted in the table the view was created with. It should also be noted that as data in the original table changes, so does data in the view, as views are the way to look at part of the original table. The results of using a view are not permanently stored in the database. The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables or even other views.

What is Index?

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

An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes, they are just used to speed up queries. Effective indexes are one of the best ways to improve performance in a database application. A table scan happens when there is no index available to help a query. In a table scan SQL Server examines every row in the table to satisfy the query results. Table scans are sometimes unavoidable, but on large tables, scans have a terrific impact on performance.

Clustered indexes define the physical sorting of a database table’s rows in the storage media. For this reason, each database table may have only one clustered index.
Non-clustered indexes are created outside of the database table and contain a sorted list of references to the table itself.

ASP.Net Page Life Cycle

2010-09-14T23:40:00.000-07:00

The events occur in the following sequence. Its best to turn on tracing(<% @Page Trace=”true”%>) and track the flow of events

PreInit	This event represents the entry point of the page life cycle. If you need to change the Master page or theme programmatically, then this would be the event to do so. Dynamic controls are created in this event.
Init	Each control in the control collection is initialized.
Init Complete*	Page is initialized and the process is completed.
PreLoad*	This event is called before the loading of the page is completed.
Load	This event is raised for the Page and then all child controls. The controls properties and view state can be accessed at this stage. This event indicates that the controls have been fully loaded.
LoadComplete*	This event signals indicates that the page has been loaded in the memory. It also marks the beginning of the rendering stage.
PreRender	If you need to make any final updates to the contents of the controls or the page, then use this event. It first fires for the page and then for all the controls.
PreRenderComplete*	Is called to explicitly state that the PreRender phase is completed.
SaveStateComplete*	In this event, the current state of the control is completely saved to the ViewState.
Unload	This event is typically used for closing files and database connections. At times, it is also used for logging some wrap-up tasks.
The events marked with * have been introduced in ASP.NET 2.0.

What is SubQuery and Correlated SubQuery in SQL Server?

2010-09-14T23:33:00.000-07:00

SubQuery :
In sub query the inner query is executed only once. Depeding upon the results of inner query outer query is evaluated.
Ex:
SELECT p.product_name FROM product p
WHERE p.product_id = (SELECT o.product_id FROM order_items o
WHERE o.product_id = p.product_id);

Correlated SubQuery :
In correlated subquery the inner query is evaluated once for each row processed by the parent statement or outer query.
Ex:
SELECT id, first_name FROM student_details
WHERE first_name IN (SELECT first_name FROM student_details WHERE subject= 'Science');

Implementing ProgressBar on Insertion using C#.Net (Windows)

2010-09-14T22:37:00.000-07:00

SqlConnection con = new SqlConnection("data source='';initial catalog='';user id='';password=''");
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adap = new SqlDataAdapter();

ProgressBar1.Visible = true;
ProgressBar1.Maximum = dsReadXML.Tables[0].Rows.Count;
ProgressBar1.Value = 0;

for (int i = 0; i < dsReadXML.Tables[0].Rows.Count; i++)
{
ProgressBar1.Value = ProgressBar1.Value + 1;
Application.DoEvents();
cmd.Connection = con;
cmd.CommandText = "insert into table values('dotnetkanna');";
cmd.ExecuteNonQuery();
}

Syntax for Cursor in SQL Server

2010-09-14T22:26:00.000-07:00

CREATE PROCEDURE sp_Test()
as

DECLARE @colA nvarchar(10)
DECLARE @colB nvarchar(10)
DECLARE @MyCursor CURSOR

SET @MyCursor = CURSOR FAST_FORWARD
FOR
Select colA,colB
From tableA

OPEN @MyCursor
FETCH NEXT FROM @MyCursor
INTO @ColA,@ColB

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @ColA
PRINT @ColB
FETCH NEXT FROM @MyCursor
INTO @ColA,@ColB
END

CLOSE @MyCursor
DEALLOCATE @MyCursor
GO

How to lock the system when it is an Idle on specific interval using C#.Net

2010-09-08T02:54:00.000-07:00

using System.Diagnostics;
using System.Runtime.InteropServices;

[DllImport("user32.dll")]
static extern bool GetLastInputInfo(ref LASTINPUTINFO plii);
internal struct LASTINPUTINFO
{
public uint cbSize;
public uint dwTime;
}

private void timer1_Tick(object sender, EventArgs e)
{
int systemUptime = Environment.TickCount;
int LastInputTicks = 0;
int IdleTicks = 0;

LASTINPUTINFO LastInputInfo = new LASTINPUTINFO();
LastInputInfo.cbSize = (uint)Marshal.SizeOf(LastInputInfo);
LastInputInfo.dwTime = 0;

if (GetLastInputInfo(ref LastInputInfo))
{
LastInputTicks = (int)LastInputInfo.dwTime;
IdleTicks = systemUptime - LastInputTicks;
}

long idlesec=IdleTicks / 1000;
long usersec = 1 * 60;//user defined values
if (idlesec == usersec)
Process.Start(Environment.SystemDirectory.ToString()+"\\rundll32.exe", "user32.dll,LockWorkStation");
}

How to find duplicate records in SQL Server?

2010-08-18T03:00:00.000-07:00

SELECT UserID FROM employee
GROUP BY userid
HAVING count(*) > 1

How to convert columns to a single Row in Sql Server?

2010-07-22T02:32:00.000-07:00

declare @Name VARCHAR(8000)
select @Name = Coalesce(@Name,'') + pat_name + ',' from pat_info where pat_name like 'P%'
select @Name[Name]

How to export Datatable to Excel in C#.Net Windows Application?

2010-07-20T04:46:00.000-07:00

Microsoft.Office.Interop.Excel.ApplicationClass exc = new Microsoft.Office.Interop.Excel.ApplicationClass();
Microsoft.Office.Interop.Excel.Application oXL;
Microsoft.Office.Interop.Excel.Workbook oWB;
Microsoft.Office.Interop.Excel.Worksheet oSheet;
Microsoft.Office.Interop.Excel.Range oRange;

// Start Excel and get Application object.
oXL = new Microsoft.Office.Interop.Excel.Application();

// Set some properties
oXL.Visible = true;
oXL.DisplayAlerts = false;

// Get a new workbook.
oWB = oXL.Workbooks.Add(Missing.Value);

// Get the active sheet
oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.ActiveSheet;
oSheet.Name = "NonMBSItems";

// Process the DataTable
// BE SURE TO CHANGE THIS LINE TO USE *YOUR* DATATABLE
System.Data.DataTable dt = dtNonMBSItems;

int rowCount = 1;
foreach (DataRow dr in dt.Rows)
{
rowCount += 1;
for (int i = 1; i < dt.Columns.Count + 1; i++)
{
// Add the header the first time through
if (rowCount == 2)
{
oSheet.Cells[1, i] = dt.Columns[i - 1].ColumnName;
}
oSheet.Cells[rowCount, i] = dr[i - 1].ToString();
}
}

oSheet.get_Range("A1", "H1").Font.Bold = true;
// Resize the columns
oRange = oSheet.get_Range(oSheet.Cells[1, 1],
oSheet.Cells[rowCount, dt.Columns.Count]);
oRange.EntireColumn.AutoFit();

// Save the sheet and close
oSheet = null;
oRange = null;
oWB.SaveAs(path, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value);
oWB.Close(Missing.Value, Missing.Value, Missing.Value);
oWB = null;
oXL.Quit();

// Clean up
// NOTE: When in release mode, this does the trick
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();

Error Handling in C#.Net?

2010-06-14T22:46:00.000-07:00

public static void WriteError(Exception errorMessage)
{
try
{
string strpath = "c:\\ErrorLog";
DirectoryInfo dir = new DirectoryInfo(strpath);
if (!dir.Exists)
dir.Create();

string path = strpath + "\\" + DateTime.Today.ToString("dd-MMM-yyyy") + ".txt";
if (!File.Exists(path))
{
File.Create(path).Close();
}
using (StreamWriter sw = File.AppendText(path))
{
string Line = errorMessage.StackTrace.Substring(errorMessage.StackTrace.ToString().LastIndexOf(":") + 1, errorMessage.StackTrace.ToString().Length - errorMessage.StackTrace.ToString().LastIndexOf(":") - 1);
int endind = errorMessage.StackTrace.ToString().ToLower().IndexOf("object sender");
string error = errorMessage.StackTrace.ToString().Substring(0, endind - 1);
int startind = error.LastIndexOf(".");
string Event = error.Substring(startind + 1);

string err = "Log Entry : " + DateTime.Now.ToString() + Environment.NewLine +
"Error Message : " + errorMessage.Message + Environment.NewLine +
"Event Name : " + Event + Environment.NewLine +
"Line No : " + Line + Environment.NewLine +
"Machine Name : " + Environment.MachineName;
sw.WriteLine(err);
sw.WriteLine("__________________________");
sw.Flush();
sw.Close();
}
}
catch (Exception ex)
{
}
}

SQL Server DatePart and Abbrevations

2010-06-14T22:21:00.000-07:00

The table lists date parts and abbreviations recognized by Microsoft SQL Server.

Datepart	Abbreviations
year	yy, yyyy
quarter	qq, q
month	mm, m
dayofyear	dy, y
day	dd, d
week	wk, ww
weekday	dw
hour	hh
minute	mi, n
second	ss, s
millisecond	ms

Eg:
SELECT DATEPART(m, 0), DATEPART(d, 0), DATEPART(yy, 0)

How to Calculate Median in SQL Server 2005?

2010-06-14T22:14:00.000-07:00

create table tblmedian(iSno int identity(1,1),iMedian int)

insert into tblmedian values(20)
insert into tblmedian values(21)
insert into tblmedian values(22)
insert into tblmedian values(23)
insert into tblmedian values(24)

create function [dbo].[UDF_Find_Median]()
returns int
as
begin
declare @Cnt int
declare @MidId1 int
declare @MidId2 int
declare @Result1 int
declare @Result2 int
declare @Retval int

select @cnt=count(*) FROM tblmedian;
if(@cnt%2=1)--odd number
begin
set @midid1=floor(round(cast(@cnt as float) / cast(2 as float),0))
select @retval=imedian from (SELECT ROW_NUMBER() OVER (ORDER BY imedian) AS RowID,floor(round(imedian,0)) as imedian FROM
tblmedian)Median where rowid=@midid1;
end
else
begin
set @midid1=floor(@cnt/2);
set @midid2=(@midid1+1);

select @result1=imedian from (SELECT ROW_NUMBER() OVER (ORDER BY imedian) AS RowID,floor(round(imedian,0)) as imedian FROM
tblmedian)Median1 where rowid=@midid1;

select @result2=imedian from (SELECT ROW_NUMBER() OVER (ORDER BY imedian) AS RowID,floor(round(imedian,0)) as imedian FROM
tblmedian)Median2 where rowid=@midid2;

set @retval=floor((@result1+@result2)/2);
end
return @retval;
end

select * from tblmedian

select [dbo].[udf_find_median]()

How to create Database,User Name and Password in Sql Server?

2010-05-20T23:27:00.000-07:00

if db_id('TestDB') is null
begin
create database [TestDB]
end

if DATABASE_PRINCIPAL_ID('[TestDB]') is null
begin
use [TestDB]
if DATABASE_PRINCIPAL_ID('testlogin') is null
CREATE LOGIN [testlogin]
WITH PASSWORD='testpwd',
DEFAULT_DATABASE=[TestDB],
DEFAULT_LANGUAGE=[us_english],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF
end

if DATABASE_PRINCIPAL_ID('testlogin') is null
begin
use [TestDB]
CREATE USER testlogin
Grant Insert,Update,Delete,Execute,Select,Create Procedure to testlogin
end

How to change the Date Format in SQL Server?

2010-05-20T23:11:00.000-07:00

To view the current format use the below query.
----------------------------------------------
select name ,alias, dateformat
from sys.syslanguages
where langid =
(select value from master..sysconfigures
where comment = 'default language')

To Change Date Format as DMY
-----------------------------
sp_configure 'default language', 23
reconfigure with override

To reset DMY to MDY replace 23 to 0

Note: It will affect only for the particular User login.

How to load an Assembly using Reflection?

2010-05-06T02:55:00.000-07:00

string dllName = @"D:\kanna\test.dll";
System.Reflection.Assembly myDllAssembly = System.Reflection.Assembly.LoadFile(dllName);
for (int i = 0; i < myDllAssembly.GetTypes().Length; i++)
{
if (myDllAssembly.GetTypes().GetValue(i).ToString().Contains("Forms")) //Forms is a folder name in a test.dll
{
Form MyDLLFormInstance = (Form)myDllAssembly.CreateInstance(myDllAssembly.GetTypes().GetValue(i).ToString());
MyDLLFormInstance.ShowDialog();
}
}

How to select Random RGB and QB Color using C#.Net?

2010-04-13T23:23:00.000-07:00

public Color RandomRGBColor()
{
Random m_Rnd =new Random();
return Color.FromArgb(255, m_Rnd.Next(0, 255), m_Rnd.Next(0, 255), m_Rnd.Next(0, 255));
}

public Color RandomQBColor()
{
int color_num = m_Rnd.Next(0, 15);
return Color.FromArgb(Information.QBColor(color_num) + 0xff000000);
}

How to Globalize the date format Using C#.Net?

2010-03-11T03:43:00.000-08:00

using System.Globalization;

CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone();
culture.DateTimeFormat.ShortDatePattern = "MM/dd/yyyy";
culture.DateTimeFormat.LongTimePattern = "";
System.Threading.Thread.CurrentThread.CurrentCulture = culture;

Tips:
Add the above code in Program.cs file.

Note:
Tested in windows application.
After include this No need to change anything at anywhere,it will works fine.

Instead of Application start event in Global.asax the below code will works, in ASP.Net

2010-03-11T03:27:00.000-08:00

As Like Application Start event the below code will works,but this will execute for each and every user login.

Copy and paste in a Class File
-----------------------------
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public class UrlRewrite : System.Web.IHttpModule
{
HttpApplication _application = null;
public UrlRewrite()
{
//
// TODO: Add constructor logic here
//
}

public void Init(System.Web.HttpApplication context)
{
context.BeginRequest += new EventHandler(context_UrlRewrite);
}

private void context_UrlRewrite(object sender, EventArgs e)
{
//Your Code
}

public void Dispose()
{
}

}

Add the below tag in a WebConfig
--------------------------------
<httpModules>
<add name="UrlRewrite" type="UrlRewrite,App_Code"/>
</httpModules>

Note: Make sure that given the Class Name.
<add name="ClassName" type="ClassName,App_Code"/>

How to add CSS effect to AJAX Calendar Extender Control?

2010-03-11T03:13:00.000-08:00


Calendar Stylesheet
====================
.Cal_Theme .ajax__calendar_container
{
 background-color: #EDCF81; border:solid 1px #cccccc;
}

.Cal_Theme .ajax__calendar_header
{
 background-color: #FFFFEA; margin-bottom: 4px;
} 

.Cal_Theme .ajax__calendar_title,
.Cal_Theme .ajax__calendar_next,
.Cal_Theme .ajax__calendar_prev
{
 color: #004080; padding-top: 3px;
}

.Cal_Theme .ajax__calendar_body
{
 background-color: #FFFFEA; border: solid 1px #cccccc;
}

.Cal_Theme .ajax__calendar_dayname
{
 text-align:center; font-weight:bold; margin-bottom: 4px; margin-top: 2px;
} 

.Cal_Theme .ajax__calendar_day
{
 text-align:center;
}

.Cal_Theme .ajax__calendar_hover .ajax__calendar_day,
.Cal_Theme .ajax__calendar_hover .ajax__calendar_month,
.Cal_Theme .ajax__calendar_hover .ajax__calendar_year,
.Cal_Theme .ajax__calendar_active
{
 color: #FFFFFF; font-weight:bold; background-color: #4A89B9;
}

.Cal_Theme .ajax__calendar_today
{
 font-weight:bold;
}

.Cal_Theme .ajax__calendar_other,
.Cal_Theme .ajax__calendar_hover .ajax__calendar_today,
.Cal_Theme .ajax__calendar_hover .ajax__calendar_title
{
 color: #000000;
}

---------------------------------------------------------------------------
Copy and paste the above stylesheet in one CSS file and Call to the control.

For Ex:
Add the below line in Head Section
<link href="../CSS/Calendar.css" rel="stylesheet" type="text/css" />

<cc1:CalendarExtender ID="txtdate_CalendarExtender" runat="server" Enabled="True"
CssClass="Cal_Theme" TargetControlID="txtdate">
</cc1:CalendarExtender>

Using Update Progress in another different way in AJAX Asp.net?

2010-02-16T04:01:00.000-08:00

< asp:UpdateProgress AssociatedUpdatePanelID="UP" DisplayAfter="1" ID="UPro" runat="server">
< ProgressTemplate>
< div class="TransparentGrayBackground">
< div class="PageUpdateProgress">
< table border="0" cellpadding="0" cellspacing="0" style="border: solid 1px #000000;
height: 30px;">
< tr>
< td>
< img src="../images/load.gif" />
< /td>
< td>
Processing..
< /td>
< /tr>
< /table>
< /div>
< /div>
< /ProgressTemplate>
< /asp:UpdateProgress>

CSS
===
.TransparentGrayBackground
{
position: fixed;
top: 0;
left: 0;
background-color: white;
filter: alpha(opacity=70);
opacity: 0.7;
height: 100%;
width: 100%;
min-height: 100%;
min-width: 100%;
}

.PageUpdateProgress
{
background-color: white;
color: Black;
width: 200px;
text-align: center;
vertical-align: middle;
position: absolute;
bottom: 50%;
left: 45%;
font-family: Verdana;
font-size: small;
}

Click Here To View and Download Loader Gif Images

How to clear asp.net fileupload control using javascript?

2010-02-16T03:55:00.000-08:00

Note: The below code will works in both IE and Firefox.

function Clear(elem)
{
var who =document.getElementById(elem.id);
who.value="";
var who2= who.cloneNode(false);
who2.onchange= who.onchange;
who.parentNode.replaceChild(who2,who);
document.getElementById(elem.id).select();
}

Filter files in fileupload control open dialog by file extensions using javascript?

2010-02-16T03:48:00.000-08:00

Note: As like windows .Net its not possible to show only specific file extensions,the only way is that we can validate it by manually as shown below.

function checkFileExtension(elem)
{
var filePath = elem.value;

if(filePath.indexOf('.') == -1)
return false;

var validExtensions = new Array();
var ext = filePath.substring(filePath.lastIndexOf('.') + 1).toLowerCase();

validExtensions[0] = 'pdf';
//validExtensions[1] = 'jpg';
//validExtensions[2] = 'txt';

for(var i = 0; i < validExtensions.length; i++)
{
if(ext == validExtensions[i])
{

return true;
}
}

alert('The file extension ' + ext.toUpperCase() + ' is not allowed,select PDF.');

return false;
}

--------------------------

FileUpload1.Attributes.Add("onchange", "return checkFileExtension(this);");

How to count the no.of pages in a PDF file using C#.Net?

2010-02-12T04:24:00.000-08:00

string PgCount = string.Empty;
string filename = @"D:\Kannabiran\Test.pdf";
System.IO.FileInfo fextension = new FileInfo(filename);
string extension = fextension.Extension;
if (extension == ".pdf" || extension == ".PDF")
{
FileStream fs = new FileStream(filename, FileMode.Open, FileAccess.Read);
StreamReader sr = new StreamReader(fs);
string pdf = sr.ReadToEnd();
Regex rx = new Regex(@"/Type\s/Page[^s]");
MatchCollection match = rx.Matches(pdf);
PgCount = match.Count.ToString();
}

How to find available users in a machine account using C#.Net?

2010-02-12T04:20:00.000-08:00

using System.DirectoryServices;

using (DirectoryEntry root = new DirectoryEntry("WinNT://"+ Environment.MachineName ))
{
foreach (DirectoryEntry child in root.Children)
{
if (child.SchemaClassName == "User")
{
Debug.WriteLine(child.Name);
}
}
}

How to Use Chart Control in Asp.net 3.5?

2010-02-04T01:20:00.000-08:00

< asp:Chart ID="RequestStatusChart" runat="server" Height="215px" Width="450px" BackImageTransparentColor="White"
BorderlineDashStyle="Solid">
< BorderSkin BorderColor="Transparent" BorderDashStyle="Solid" BorderWidth="0" PageColor="White"
SkinStyle="Emboss" />
< Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesTotal" Color="#26A3F3" XValueMember="RequestedOn"
YValueMembers="Total" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesApproved" Color="#1B8D01" XValueMember="RequestedOn"
YValueMembers="Approved" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series Name="SeriesPending" Color="#FED43F" XValueMember="RequestedOn" YValueMembers="Pending"
IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesAwaiting" XValueMember="RequestedOn"
YValueMembers="Awaiting" Color="#DF4ADD" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesRejected" XValueMember="RequestedOn"
YValueMembers="Rejected" Color="#F01027" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesTransferred" Color="#FC8700" XValueMember="RequestedOn"
YValueMembers="Transferred" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< /Series>
< ChartAreas>
< asp:ChartArea Name="ChartArea1" BackColor="Transparent">
< /asp:ChartArea>
< /ChartAreas>
< /asp:Chart>

//Call on Page Load
public void BindChart()
{
DataTable dtrptstatus = new DataTable();

RequestStatusChart.DataSource = null;
RequestStatusChart.DataBind();
dtrptstatus = objReport.GetStatusLogReport(Convert.ToDateTime(txtSelectDate.Text));
RequestStatusChart.DataSource = dtrptstatus;
//Set the series to named series and confgiure x and y axes
RequestStatusChart.Series["SeriesTotal"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesTotal"].YValueMembers = "Total";
RequestStatusChart.Series["SeriesAwaiting"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesAwaiting"].YValueMembers = "Awaiting";
RequestStatusChart.Series["SeriesApproved"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesApproved"].YValueMembers = "Approved";
RequestStatusChart.Series["SeriesPending"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesPending"].YValueMembers = "Pending";
RequestStatusChart.Series["SeriesRejected"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesRejected"].YValueMembers = "Rejected";
RequestStatusChart.Series["SeriesTransferred"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesTransferred"].YValueMembers = "Transferred";
RequestStatusChart.DataBind();
RequestStatusChart.Visible = true;
}

public DataTable GetStatusLogReport(DateTime dt)
{
DataTable dtrpt = new DataTable();
if (OpenConnection())
{
Cmd.Parameters.Clear();
Cmd.Connection = Constr;
Cmd.CommandText = "select Total,Awaiting,Approved, Pending , Rejected ,Transferred, Convert(varchar(6),Date,106) as RequestedOn from Tablename order by convert(datetime,Date) desc";
Cmd.CommandType = CommandType.Text;
Adp.SelectCommand = Cmd;
Adp.Fill(dtrpt);
CloseConnection();
}
return dtrpt;
}

Click Here To Download Chart Control

How to Export Gridview to PDF using C#.Net for Both AutoGenerate Column and Template Columns?

2010-02-03T02:22:00.000-08:00

public void ExportToPDF(string ReportName, GridView grdPDF, bool isLandscape,string Filename)
{
int noOfColumns = 0, noOfRows = 0;
DataTable tbl = null;
if (grdPDF.AutoGenerateColumns)
{
tbl = grdPDF.DataSource as DataTable; // Gets the DataSource of the GridView Control.
noOfColumns = tbl.Columns.Count;
noOfRows = tbl.Rows.Count;
}
else
{
noOfColumns = grdPDF.Columns.Count;
noOfRows = grdPDF.Rows.Count;
}
float HeaderTextSize = 8;
float ReportNameSize = 10;
float ReportTextSize = 8;
float ApplicationNameSize = 7;

// Creates a PDF document
Document document = null;
if (isLandscape == true)
{
// Sets the document to A4 size and rotates it so that the orientation of the page is Landscape.
document = new Document(PageSize.A4.Rotate(), 0, 0, 15, 5);
}
else
{
document = new Document(PageSize.A4, 0, 0, 15, 5);
}

PdfPTable mainTable = new iTextSharp.text.pdf.PdfPTable(noOfColumns);
// Sets the first 4 rows of the table as the header rows which will be repeated in all the pages.
mainTable.HeaderRows = 4;

// Creates a PdfPTable with 2 columns to hold the header in the exported PDF.
PdfPTable headerTable = new iTextSharp.text.pdf.PdfPTable(2);
iTextSharp.text.Image imgLogo = iTextSharp.text.Image.GetInstance(HttpContext.Current.Server.MapPath("../Images/medtech_logo.jpg"));
imgLogo.ScaleToFit(100, 25);

PdfPCell clApplicationName = new PdfPCell(imgLogo);
clApplicationName.Border = PdfPCell.NO_BORDER;
clApplicationName.HorizontalAlignment = Element.ALIGN_LEFT;

// Creates a phrase to show the current date at the right hand side of the header.
Phrase phDate = new Phrase(DateTime.Now.Date.ToString("dd-MMM-yyyy"), FontFactory.GetFont("Arial", ApplicationNameSize, iTextSharp.text.Font.NORMAL));
// Creates a PdfPCell which accepts the date phrase as a parameter.
PdfPCell clDate = new PdfPCell(phDate);
// Sets the Horizontal Alignment of the PdfPCell to right.
clDate.HorizontalAlignment = Element.ALIGN_RIGHT;
// Sets the border of the cell to zero.
clDate.Border = PdfPCell.NO_BORDER;

headerTable.AddCell(clApplicationName);
headerTable.AddCell(clDate);
headerTable.DefaultCell.Border = PdfPCell.NO_BORDER;

// Creates a PdfPCell that accepts the headerTable as a parameter and then adds that cell to the main PdfPTable.
PdfPCell cellHeader = new PdfPCell(headerTable);
cellHeader.Border = PdfPCell.NO_BORDER;
// Sets the column span of the header cell to noOfColumns.
cellHeader.Colspan = noOfColumns;
// Adds the above header cell to the table.
mainTable.AddCell(cellHeader);

// Creates a phrase which holds the file name.
Phrase phHeader = new Phrase(sApplicationnName, FontFactory.GetFont("Arial", ReportNameSize, iTextSharp.text.Font.BOLD));
PdfPCell clHeader = new PdfPCell(phHeader);
clHeader.Colspan = noOfColumns;
clHeader.Border = PdfPCell.NO_BORDER;
clHeader.HorizontalAlignment = Element.ALIGN_CENTER;
mainTable.AddCell(clHeader);

// Creates a phrase for a new line.
Phrase phSpace = new Phrase("\n");
PdfPCell clSpace = new PdfPCell(phSpace);
clSpace.Border = PdfPCell.NO_BORDER;
clSpace.Colspan = noOfColumns;
mainTable.AddCell(clSpace);

// Sets the gridview column names as table headers.
for (int i = 0; i < noOfColumns; i++)
{
Phrase ph = null;
if (grdPDF.AutoGenerateColumns)
ph = new Phrase(tbl.Columns[i].ColumnName, FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
else
ph = new Phrase(grdPDF.Columns[i].HeaderText, FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
mainTable.AddCell(ph);
}

// Reads the gridview rows and adds them to the mainTable
for (int rowNo = 0; rowNo < noOfRows; rowNo++)
{
for (int columnNo = 0; columnNo < noOfColumns; columnNo++)
{
if (grdPDF.AutoGenerateColumns)
{
string s = grdPDF.Rows[rowNo].Cells[columnNo].Text.Trim();
Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
mainTable.AddCell(ph);
}
else
{
string s = "";
if (grdPDF.Columns[columnNo] is TemplateField)
{
DataBoundLiteralControl lc = grdPDF.Rows[rowNo].Cells[columnNo].Controls[0] as DataBoundLiteralControl;
if (lc != null)
{
s = lc.Text.Trim();
}
else
{
for (int i = 0; i < grdPDF.Rows[rowNo].Cells[columnNo].Controls.Count; i++)
{
if (grdPDF.Rows[rowNo].Cells[columnNo].Controls[i].GetType() == typeof(TextBox))
{
s = (grdPDF.Rows[rowNo].Cells[columnNo].Controls[i] as TextBox).Text;
}
else if (grdPDF.Rows[rowNo].Cells[columnNo].Controls[i].GetType() == typeof(Label))
{
s = (grdPDF.Rows[rowNo].Cells[columnNo].Controls[i] as Label).Text;
}
else if (grdPDF.Rows[rowNo].Cells[columnNo].Controls[i].GetType() == typeof(System.Web.UI.WebControls.Image))
{
s = (grdPDF.Rows[rowNo].Cells[columnNo].Controls[i] as System.Web.UI.WebControls.Image).ToolTip;
}
}
}
Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
mainTable.AddCell(ph);
}
else
{
s = grdPDF.Rows[rowNo].Cells[columnNo].Text.Trim();
Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
mainTable.AddCell(ph);
}
}
}
mainTable.CompleteRow();
}

PdfWriter.GetInstance(document, HttpContext.Current.Response.OutputStream);
HeaderFooter pdfFooter = new HeaderFooter(new Phrase(), true);
pdfFooter.Alignment = Element.ALIGN_CENTER;
pdfFooter.Border = iTextSharp.text.Rectangle.NO_BORDER;
document.Footer = pdfFooter;
document.Open();
document.Add(mainTable);
document.Close();

HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename= "+ Filename +"_"+ DateTime.Now.ToString("dd_MMM_yyyy") +".pdf");
HttpContext.Current.Response.End();
}

Click Here to Download itextsharp DLL

How to kill the process using C#.Net?

2010-02-03T02:12:00.001-08:00

Process[] processes = System.Diagnostics.Process.GetProcessesByName("AcroRd32");
foreach (Process p in processes)
{
p.Kill();
p.Refresh();
}

How to write the PDF Binary files in C#.Net?

2010-02-03T01:38:00.000-08:00

System.Net.WebClient client = new System.Net.WebClient();
Byte[] buffer = client.DownloadData("D:\\Kannabiran\\dotnet.pdf");
if (buffer != null)
{
Response.Clear();
Response.ContentType = "application/pdf";
Response.AddHeader("content-length", buffer.Length.ToString());
Response.AddHeader("Content-Type", "application/pdf");
Response.BinaryWrite(buffer);
Response.End();
}

How to Convert Numbers to Words using Sql Server?

2010-01-11T05:14:00.000-08:00

SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
SET NOCOUNT ON
GO

CREATE FUNCTION dbo.udf_Num_ToWords (

@Number Numeric (38, 0) -- Input number with as many as 18 digits

) RETURNS VARCHAR(8000)

AS BEGIN

DECLARE @inputNumber VARCHAR(38)
DECLARE @NumbersTable TABLE (number CHAR(2), word VARCHAR(10))
DECLARE @outputString VARCHAR(8000)
DECLARE @length INT
DECLARE @counter INT
DECLARE @loops INT
DECLARE @position INT
DECLARE @chunk CHAR(3) -- for chunks of 3 numbers
DECLARE @tensones CHAR(2)
DECLARE @hundreds CHAR(1)
DECLARE @tens CHAR(1)
DECLARE @ones CHAR(1)

IF @Number = 0 Return 'Zero'

-- initialize the variables
SELECT @inputNumber = CONVERT(varchar(38), @Number)
, @outputString = ''
, @counter = 1
SELECT @length = LEN(@inputNumber)
, @position = LEN(@inputNumber) - 2
, @loops = LEN(@inputNumber)/3

-- make sure there is an extra loop added for the remaining numbers
IF LEN(@inputNumber) % 3 <> 0 SET @loops = @loops + 1

-- insert data for the numbers and words
INSERT INTO @NumbersTable SELECT '00', ''
UNION ALL SELECT '01', 'one' UNION ALL SELECT '02', 'two'
UNION ALL SELECT '03', 'three' UNION ALL SELECT '04', 'four'
UNION ALL SELECT '05', 'five' UNION ALL SELECT '06', 'six'
UNION ALL SELECT '07', 'seven' UNION ALL SELECT '08', 'eight'
UNION ALL SELECT '09', 'nine' UNION ALL SELECT '10', 'ten'
UNION ALL SELECT '11', 'eleven' UNION ALL SELECT '12', 'twelve'
UNION ALL SELECT '13', 'thirteen' UNION ALL SELECT '14', 'fourteen'
UNION ALL SELECT '15', 'fifteen' UNION ALL SELECT '16', 'sixteen'
UNION ALL SELECT '17', 'seventeen' UNION ALL SELECT '18', 'eighteen'
UNION ALL SELECT '19', 'nineteen' UNION ALL SELECT '20', 'twenty'
UNION ALL SELECT '30', 'thirty' UNION ALL SELECT '40', 'forty'
UNION ALL SELECT '50', 'fifty' UNION ALL SELECT '60', 'sixty'
UNION ALL SELECT '70', 'seventy' UNION ALL SELECT '80', 'eighty'
UNION ALL SELECT '90', 'ninety'

WHILE @counter <= @loops BEGIN

-- get chunks of 3 numbers at a time, padded with leading zeros
SET @chunk = RIGHT('000' + SUBSTRING(@inputNumber, @position, 3), 3)

IF @chunk <> '000' BEGIN
SELECT @tensones = SUBSTRING(@chunk, 2, 2)
, @hundreds = SUBSTRING(@chunk, 1, 1)
, @tens = SUBSTRING(@chunk, 2, 1)
, @ones = SUBSTRING(@chunk, 3, 1)

-- If twenty or less, use the word directly from @NumbersTable
IF CONVERT(INT, @tensones) <= 20 OR @Ones='0' BEGIN
SET @outputString = (SELECT word
FROM @NumbersTable
WHERE @tensones = number)
+ CASE @counter WHEN 1 THEN '' -- No name
WHEN 2 THEN ' thousand ' WHEN 3 THEN ' million '
WHEN 4 THEN ' billion ' WHEN 5 THEN ' trillion '
WHEN 6 THEN ' quadrillion ' WHEN 7 THEN ' quintillion '
WHEN 8 THEN ' sextillion ' WHEN 9 THEN ' septillion '
WHEN 10 THEN ' octillion ' WHEN 11 THEN ' nonillion '
WHEN 12 THEN ' decillion ' WHEN 13 THEN ' undecillion '
ELSE '' END
+ @outputString
END
ELSE BEGIN -- break down the ones and the tens separately

SET @outputString = ' '
+ (SELECT word
FROM @NumbersTable
WHERE @tens + '0' = number)
+ '-'
+ (SELECT word
FROM @NumbersTable
WHERE '0'+ @ones = number)
+ CASE @counter WHEN 1 THEN '' -- No name
WHEN 2 THEN ' thousand ' WHEN 3 THEN ' million '
WHEN 4 THEN ' billion ' WHEN 5 THEN ' trillion '
WHEN 6 THEN ' quadrillion ' WHEN 7 THEN ' quintillion '
WHEN 8 THEN ' sextillion ' WHEN 9 THEN ' septillion '
WHEN 10 THEN ' octillion ' WHEN 11 THEN ' nonillion '
WHEN 12 THEN ' decillion ' WHEN 13 THEN ' undecillion '
ELSE '' END
+ @outputString
END

-- now get the hundreds
IF @hundreds <> '0' BEGIN
SET @outputString = (SELECT word
FROM @NumbersTable
WHERE '0' + @hundreds = number)
+ ' hundred '
+ @outputString
END
END

SELECT @counter = @counter + 1
, @position = @position - 3

END

-- Remove any double spaces
SET @outputString = LTRIM(RTRIM(REPLACE(@outputString, ' ', ' ')))
SET @outputstring = UPPER(LEFT(@outputstring, 1)) + SUBSTRING(@outputstring, 2, 8000)

RETURN @outputString -- return the result
END
GO

GRANT EXEC on dbo.udf_Num_ToWords TO PUBLIC
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

--Example
select dbo.udf_Num_ToWords (4670)

How to sort it out Illegal Cross Threads in .Net?

2009-12-16T21:52:00.000-08:00

Solution:

=========

//Note: place it in constructor.

Control.CheckForIllegalCrossThreadCalls = false;

How to format auto id number to 0000001 in Sql Server?

2009-12-14T03:59:00.000-08:00

declare @num int
declare @fixed_size int

set @fixed_size = 10
set @num = 40

SELECT @num as [orig], RIGHT(REPLICATE('0',@fixed_size) + CAST(@num AS varchar(10)),@fixed_size) As [modif]

How to develop AutoComplete Text in windows Textbox using C#.Net?

2009-12-14T03:55:00.000-08:00

AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();

SqlDataReader dReader;
SqlConnection con = new SqlConnection("Data Source=idiot;Initial Catalog=INDIA;User ID=sa;Password=12345");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select givenname from patient";
con.Open();
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
namesCollection.Add(dReader["givenname"].ToString());

}
else
{
MessageBox.Show("Data not found");
}
dReader.Close();

textBox1.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox1.AutoCompleteCustomSource = namesCollection;

How to get all the primary key,unique,foreign key in a Sql Server database?

2009-12-14T03:54:00.001-08:00

SELECT A.TABLE_NAME, A.CONSTRAINT_NAME, B.COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS A, INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE B
WHERE CONSTRAINT_TYPE = 'PRIMARY KEY' AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
ORDER BY A.TABLE_NAME

How to remove special characters in a string using SQL Server?

2009-12-14T03:52:00.000-08:00

CREATE FUNCTION dbo.Fun_ParseAlphaChars
(
@string VARCHAR(8000)
)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @IncorrectCharLoc SMALLINT
SET @IncorrectCharLoc = PATINDEX('%[^0-9A-Za-z]%', @string)
WHILE @IncorrectCharLoc > 0
BEGIN
SET @string = STUFF(@string, @IncorrectCharLoc, 1, '')
SET @IncorrectCharLoc = PATINDEX('%[^0-9A-Za-z]%', @string)
END
SET @string = @string
RETURN @string
END
GO

Test
-----
SELECT dbo.Fun_ParseAlphaChars('123k@nn@/;')

Output:
-------
123knn

How to find the Particular Table dependent Table List in Sql Server?

2009-12-08T01:55:00.000-08:00

SELECT
   pt.COLUMN_NAME AS PrimaryField,
   c.CONSTRAINT_NAME AS KeyName,
   fk.TABLE_NAME AS ForeignTable,
   cu.COLUMN_NAME AS ForeignField
FROM
   INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c
   INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS fk ON
   c.CONSTRAINT_NAME = fk.CONSTRAINT_NAME
   INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ON
   c.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
   INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE cu ON
   c.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
   INNER JOIN (
   SELECT tc.TABLE_NAME, kcu.COLUMN_NAME
   FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
   INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu
   ON tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME
   WHERE tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
   ) pt ON pt.TABLE_NAME = pk.TABLE_NAME
   WHERE pk.TABLE_NAME = 'MyTableName'
ORDER BY foreignTable ASC;

How to write query for selecting the age using DOB in SQL Server?

2009-11-26T01:16:00.000-08:00

select datediff (year, convert (datetime, '01/12/1983'), getdate())--mm/dd/yyyy

How to make the string into Title Case?

2009-11-26T01:10:00.000-08:00

using System.Text.RegularExpressions;

string str = Regex.Replace("kannabiran", @"\b(\w)",delegate(Match m) { return

m.Groups[1].Value.ToUpper(); });

How to Prevent Dragging the Windows Form?

2009-11-15T23:01:00.000-08:00

protected override void WndProc(ref Message m)
{
const int WM_NCLBUTTONDOWN = 161;
const int WM_SYSCOMMAND = 274;
const int HTCAPTION = 2;
const int SC_MOVE = 61456;

if((m.Msg == WM_SYSCOMMAND) && (m.WParam.ToInt32() == SC_MOVE))
{
return;
}

if((m.Msg == WM_NCLBUTTONDOWN) && (m.WParam.ToInt32() == HTCAPTION))
{
return;
}

base.WndProc (ref m);
}

How to filter files from the folder?

2009-10-28T04:08:00.000-07:00

foreach (string file in Directory.GetFiles("d:\\dotnetkanna\\PDF", "*.pdf", SearchOption.TopDirectoryOnly))
{
listBox1.Items.Add(file);
}

How do I get a list of SQL Server tables and their row counts?

2009-10-22T02:00:00.000-07:00

SELECT
[TableName] = so.name,
[RowCount] = MAX(si.rows)
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype = 'U'
AND
si.id = OBJECT_ID(so.name)
GROUP BY
so.name
ORDER BY
2 DESC

How to select dropdownlist selecteditemtext using Javascript?

2009-09-06T23:52:00.001-07:00

function select_dropdownlist_text()
{
var drp = document.getElementById('Dropdownlist1');
alert(drp.options[drp.selectedIndex].text);
}

How to identiify whether the ASP.Net web page is valid or not?

2009-08-14T02:09:00.000-07:00

It can be achieved by both Client and Server side.

By Client Side....
function Client_Validate()
{
if(Page_ClientValidate)
alert("Invalid Page");
else
alert("Valid Page");
}

<asp:Button ID="btnsave" OnClientClick="Client_Validate();" runat="server" Text="Save" />
====================

By Server Side....
Protected Sub btnsave_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If Page.IsValid Then
'.
'.
Else
'.
'.
End If
End Sub

Drag And Drop as Like iGoogle Interface

2009-08-10T03:40:00.000-07:00

Click Here To Download Source

Courtesy:Nettuts

Some Alter Queries For SQL Server (Tested in SQL Server 2005)

2009-08-10T00:09:00.000-07:00

ABOUT WHAT	QUERIES
Adding Primary Key	ALTER TABLE Table_Name ADD PRIMARY KEY (Column_Name)
Adding Foreign Key with Cascade	ALTER TABLE child_name add CONSTRAINT constraint_name FOREIGN KEY (childtable column1, column2, ... column_n) REFERENCES parent_table(column1, column2, ... column_n) on update cascade;
Adding Unique Key	ALTER TABLE Table_Name ADD UNIQUE (Column_Name);
Adding New Column	ALTER TABLE Table_Name ADD NewCol VARCHAR(50);
Altering Column Type/Width	ALTER TABLE Table_Name ALTER COLUMN NewCol varchar(80) NOT NULL;
Addng Identity(Note:Table Should Be Empty)	ALTER TABLE Table_Name ALTER COLUMN ColName ADD CONSTRAINT IDENTITY(1,1);
Adding Default Value	ALTER TABLE Table_Name ADD CONSTRAINT Constraint_Name DEFAULT 'dotnetkanna' FOR Column_Name;
Drop Constraint	ALTER TABLE Table_Name DROP CONSTRAINT Constraint_Name;
Drop Column	ALTER TABLE Table_Name DROP Column Column_Name;
Rename The Table	SP_RENAME 'Old_TableName','New_TableName';
Rename The Column	sp_rename @objname = 'table_name.old_column_name', @newname = 'new_column_name', @objtype = 'COLUMN';
Rename The Database	sp_renamedb 'Old_DBName', 'New_DBName';

How to Identify which event cause Postback using VB.Net?

2009-08-09T23:55:00.000-07:00

Protected Function GetControlThatCausedPostBack(ByVal page As Page) As Control
Dim control As Control = Nothing
Dim ctrlname As String = page.Request.Params.[Get]("__EVENTTARGET")
If ctrlname IsNot Nothing AndAlso ctrlname <> String.Empty Then
control = page.FindControl(ctrlname)
Else
For Each ctl As String In page.Request.Form
Dim c As Control = page.FindControl(ctl)
If TypeOf c Is System.Web.UI.WebControls.Button OrElse TypeOf c Is System.Web.UI.WebControls.ImageButton Then
control = c
Exit For
End If
Next
End If
Return control
End Function

---------------------

Dim str As Control
str = GetControlThatCausedPostBack(Me)

How to Dynamically load the CSS using C#.Net?

2009-08-06T02:06:00.000-07:00

using System.Web.UI.HtmlControls;

protected void Page_Load(object sender, EventArgs e)
{
HtmlLink css = new HtmlLink();
css.Href = ResolveClientUrl("~/style/StyleSheet.css");
css.Attributes["rel"] = "stylesheet";
css.Attributes["type"] = "text/css";
css.Attributes["media"] = "all";
Page.Header.Controls.Add(css);
}

How to Restart the Window Services using VB.Net?

2009-08-05T01:39:00.001-07:00

Imports System.ServiceProcess.ServiceController

Function RestartService() As Boolean
Try
Dim controller As New ServiceProcess.ServiceController
controller.MachineName = "."
controller.ServiceName = "MSSQL$SQLEXPRESS"
Dim status As String = controller.Status.ToString
If status = "Running" Then
controller.Stop()
End If
controller.Start()
Return True
Catch ex As Exception
Return False
End Try
End Function

How to Read and Run the SQL Script file using VB.Net?

2009-08-03T02:09:00.000-07:00

Imports System.IO
Imports System.Text

Public Function ExecuteSQLScript() As Boolean
Dim conn As New SqlConnection("uid=test;pwd=test;database=test;server=kannaserver")
Try
Private fileUrl As String = ""
fileUrl = "D:\RunScript\ScriptFile.sql"

Dim request As Net.WebRequest = Net.WebRequest.Create(fileUrl)
Using sr As New StreamReader(request.GetResponse().GetResponseStream(),
System.Text.UTF8Encoding.Default)'it will read actual content what exist in the file.
conn.Open()
While Not sr.EndOfStream
Dim sb As New System.Text.StringBuilder()
Dim cmd As SqlCommand = conn.CreateCommand()
While Not sr.EndOfStream
Dim str As String = sr.ReadLine()
If str IsNot Nothing AndAlso str.ToUpper().Trim().Equals("GO") Then
Exit While
End If
sb.AppendLine(str)
End While
cmd.CommandText = sb.ToString()
cmd.CommandTimeout = 0 '0 means Infinity Time
cmd.ExecuteNonQuery()
End While
End Using
Return True
Catch ex As Exception
Return False
Finally
If conn.State = ConnectionState.Open Then
conn.Close()
End If
End Try
End Function

How to generate row number in SQL Server?

2009-07-31T04:45:00.000-07:00

SELECT (SELECT COUNT(i.ref_no) FROM student_information i
WHERE i.ref_no >= o.ref_no ) AS RowID, sname AS 'Name' FROM student_information o ORDER BY RowID;

How to Randomly select the records in SQL Server?

2009-07-31T04:40:00.000-07:00

select top 5 * from question_settings where class ='1' order by newid();

How to Clean your Database Records & Reset Identity Columns in Sql Server 2005?

2009-07-31T04:37:00.000-07:00

/*Disable Constraints & Triggers*/
exec sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
exec sp_MSforeachtable 'ALTER TABLE ? DISABLE TRIGGER ALL'

/*Perform delete operation on all table for cleanup*/
exec sp_MSforeachtable 'DELETE ?'

/*Enable Constraints & Triggers again*/
exec sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
exec sp_MSforeachtable 'ALTER TABLE ? ENABLE TRIGGER ALL'

/*Reset Identity on tables with identity column*/
exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'

How to prefetch content in an HTML document Using the HTML link/meta element?

2009-07-31T04:33:00.000-07:00

Using link
<head>
<link rel="prefetch" href="/images/big.jpg">
</head>

(or)

Using a meta header
<meta HTTP-EQUIV="Link" CONTENT="</images/big.jpg> ; rel=prefetch">

How to Install/Uninstall the Window Service?

2009-07-31T04:30:00.000-07:00

Build the service By Build--> Srevice Name

After that Get the service Path that is in Bin Folder.

open start--> visual studio 2005-->visual studio tools--> visual studio command prompt

in that

For Installation
C:\Program files\Microsoft Visual Studio 8\VC\>installutil

Example:
C:\Program files\Microsoft Visual Studio 8\VC\>installutil -i d:Testservice\debug\testservice.exe

For Uninstalltion
C:\Program files\Microsoft Visual Studio 8\VC\>installutil /u

Example:
C:\Program files\Microsoft Visual Studio 8\VC\>installutil /u d:Testservice\debug\testservice.exe

How to reset IIS?

2009-07-31T04:28:00.000-07:00

Start-->Run--> Type IISRESET -->Press Enter Key.

How to register asp.net with IIS?

2009-07-31T03:50:00.000-07:00

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>Aspnet_regiis.exe -i

aspnet_regiis -ir -enable - Installs ASP.NET version with root and enables it.
aspnet_regiis -s path - Registers script map for our Application.

if not registered then the user can able view the below screen..

How to Add/Retrieve/Delete keys from Reistry using C#.Net?

2009-07-30T01:27:00.001-07:00

//Adding New Key
RegistryKey key = Registry.LocalMachine.OpenSubKey("Software", true);
// Create a sub key
RegistryKey newSubKey = key.CreateSubKey("Sample RegSubkey");
// Set value of sub key
newSubKey.SetValue("Sample RegSubkey", "I have Created New VAlue");

// Retrieve data from other part of the registry
RegistryKey NewKey = Registry.LocalMachine;
NewKey = NewKey.OpenSubKey("HARDWARE\\\\DESCRIPTION\\\\System\\\\CentralProcessor\\\\0");
object val = NewKey.GetValue("VendorIdentifier");

// Delete the key value
RegistryKey delKey = Registry.LocalMachine.OpenSubKey("Software", true);
delKey.DeleteSubKey("Sample RegSubkey");

How to Rename Recycle Bin Name using C#.Net?

2009-07-30T01:25:00.001-07:00

using Microsoft.Win32;

Registry.ClassesRoot.OpenSubKey("CLSID\\{645FF040-5081-101B-9F08-00AA002F954E}", true).SetValue("LocalizedString", "Dust Bin");

How to know No.of records exists in all the Tables in Particular Database?

2009-07-30T00:50:00.000-07:00

SELECT SysObj.name [Table Name],MAX(SysInd.rows)[Rows]
FROM SYSOBJECTS SysObj INNER JOIN SYSINDEXES SysInd ON
SysObj.id = SysInd.id WHERE xtype = 'U'
AND OBJECTPROPERTY(SysObj.id,'IsUserTable')= 1
GROUP BY SysObj.name ORDER BY Rows DESC

How to configure Email settings in web config?

2009-07-21T01:56:00.000-07:00

< system.net>
< mailSettings>
< smtp from="feedback@dotnetkanna.com" >
< network host="smtp.dotnetkanna.com" defaultCredentials ="true" userName="feedback@dotnetkanna.com" port="25" password="12345" />
< /smtp>
< /mailSettings >
< /system.net>

To Access, this SMTP Mail Setting Programatically, you need to import below namespaces:

using System.Configuration;
using System.Web.Configuration;
using System.Net.Configuration;

The .NET Framework provides APIs for accessing settings in a configuration file. Below is how you access the SMTP mail settings of a web.config file in code:

Configuration config = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
MailSettingsSectionGroup settings = (MailSettingsSectionGroup)config.GetSectionGroup("system.net/mailSettings");
Response.Write("host: " + settings.Smtp.Network.Host + "< br />");
Response.Write("port: " + settings.Smtp.Network.Port + "< br />");
Response.Write("Username: " + settings.Smtp.Network.UserName + "< br />");
Response.Write("Password: " + settings.Smtp.Network.Password + "< br />");
Response.Write("from: " + settings.Smtp.From + "< br />");

How to Increase the Maximum Upload Size?

2009-07-21T00:20:00.000-07:00

The 4MB default is set in machine.config, but you can override it in you web.config. For instance, to expand the upload limit to 20MB, you'd do this:

< system.web>
< httpRuntime executionTimeout="240" maxRequestLength="20480" />
< /system.web>

How to delete the duplicate rows in SQL Server?

2009-07-14T21:32:00.000-07:00

set rowcount 1
delete from table_name where Ename='Gokul'

How to set permission to the folder programmatically using C#.Net?

2009-07-14T02:40:00.000-07:00

using System.IO;
using System.Security.AccessControl;
using System.Security.Principal;

string dirpath = "G:\\Web\\Kanna";
DirectoryInfo dirinfo = new DirectoryInfo(dirpath);
string users = @"NETWORK SERVICE"; //@"ASPNET" // @"EVERYONE"
if (dirinfo.Exists)
{
DirectorySecurity dirsec = dirinfo.GetAccessControl();
FileSystemAccessRule fsar = new FileSystemAccessRule(new NTAccount(users), FileSystemRights.FullControl, InheritanceFlags.ContainerInherit | InheritanceFlags.ObjectInherit, PropagationFlags.None, AccessControlType.Allow);
dirsec.AddAccessRule(fsar);
dirinfo.SetAccessControl(dirsec);
}

How to know the available free space in sql server?

2009-07-10T03:19:00.000-07:00

select name,filename, convert(decimal(12,2),round(a.size/128.000,2)) as FileSizeMB, convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)) as SpaceUsedMB,convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) as FreeSpaceMB from dbo.sysfiles a

How to disable ctrl key combinations using Javascript?

2009-07-07T01:33:00.000-07:00

IE8 can also act as IE7

2009-07-06T21:42:00.000-07:00

Add the below meta tag within the < head> section.
< meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7"/>

A detailed description avilable here..
http://www.microsoft.com/windows/internet-explorer/readiness/developers-new.aspx#dom

How to disable the button after click for avoiding duplicate entries?

2009-07-03T03:30:00.000-07:00

< head>
< style type="text/css">
.Normal
{
border: dashed 1px #000000;
background-color: #FFFFFF;
cursor: pointer;
}

.Progress
{
border: dashed 1px #000000;
background-color: #EEEEEE;
background-position: center center;
background-repeat: no-repeat;
cursor: wait;
}
</style>

</head>

Add one div tag,Open the div tag after the < form> tag and close the div tag before the </ form> tag get closed.

< form id="frm_maintenance" runat="server">
< div id="Container" class="Normal">
.
.
.
.
.
</div>
</form>

Add this script lines into a seperate javascript file and call after the </ScriptManager> tag.

< script language="javascript" type="text/javascript" src="../Javascript/Ajax.js" />

if(Sys != null)
{
var prm = Sys.WebForms.PageRequestManager.getInstance();
prm.add_initializeRequest(InitializeRequest);
prm.add_endRequest(EndRequest);
}

function InitializeRequest(sender, args)
{
$get('Container').className = 'Progress';
$get(args._postBackElement.id).disabled = true;
}

function EndRequest(sender, args)
{
$get('Container').className = 'Normal';
$get(sender._postBackSettings.sourceElement.id).disabled = false;
}

How to change the table owner name in sql server?

2009-07-02T23:33:00.000-07:00

exec sp_changeobjectowner 'tablename', 'dbo'

How to create Virtual Directory Programmaticlly using VB.Net?

2009-06-25T01:32:00.000-07:00

Private Sub CreateVirtualDir(ByVal WebSite As String, ByVal AppName As String, ByVal Path As String)
Dim IISSchema As New System.DirectoryServices.DirectoryEntry("IIS://" & WebSite & "/Schema/AppIsolated")
Dim CanCreate As Boolean = Not IISSchema.Properties("Syntax").Value.ToString.ToUpper() = "BOOLEAN"
IISSchema.Dispose()

If CanCreate Then
Dim PathCreated As Boolean
Try
Dim IISAdmin As New System.DirectoryServices.DirectoryEntry("IIS://" & WebSite & "/W3SVC/1/Root")
'make sure folder exists
If Not System.IO.Directory.Exists(Path) Then
System.IO.Directory.CreateDirectory(Path)
PathCreated = True
End If
'If the virtual directory already exists then delete it
For Each VD As System.DirectoryServices.DirectoryEntry In IISAdmin.Children
If VD.Name = AppName Then
IISAdmin.Invoke("Delete", New String() {VD.SchemaClassName, AppName})
IISAdmin.CommitChanges()
Exit For
End If
Next VD

'Create and setup new virtual directory
Dim VDir As System.DirectoryServices.DirectoryEntry = IISAdmin.Children.Add(AppName, "IIsWebVirtualDir")
VDir.Properties("Path").Item(0) = Path
VDir.Properties("AppFriendlyName").Item(0) = AppName
VDir.Properties("EnableDirBrowsing").Item(0) = False
VDir.Properties("AccessRead").Item(0) = True
VDir.Properties("AccessExecute").Item(0) = True
VDir.Properties("AccessWrite").Item(0) = False
VDir.Properties("AccessScript").Item(0) = True
VDir.Properties("AuthNTLM").Item(0) = True
VDir.Properties("EnableDefaultDoc").Item(0) = True
'Setting the startup page page.
VDir.Properties("DefaultDoc").Item(0) = "default.htm,default.aspx,default.asp"
VDir.Properties("AspEnableParentPaths").Item(0) = True
VDir.CommitChanges()
VDir.Invoke("AppCreate", 1)
Catch Ex As Exception
If PathCreated Then
System.IO.Directory.Delete(Path)
End If
Throw Ex
End Try
End If
End Sub

'Calling method
CreateVirtualDir("localhost", "BASHA", "D:\AJAXVBWEB")

How to write a query for selecting Today's Birthday Candidates using Sql Server?

2009-05-07T02:50:00.000-07:00

select * from TableName where day(convert(datetime,'12/01/2009',101))=day(getdate()) and month(convert(datetime,'12/01/2009',101))=month(getdate());

How to get the browser details using VB.Net?

2009-04-30T01:21:00.000-07:00

Dim s As String = ""
With Request.Browser
s &= "Browser Capabilities" & vbCrLf & "< br>"
s &= "Type = " & .Type & vbCrLf & "< br>"
s &= "Name = " & .Browser & vbCrLf & "< br>"
s &= "Version = " & .Version & vbCrLf & "< br>"
s &= "Major Version = " & .MajorVersion & vbCrLf & "< br>"
s &= "Minor Version = " & .MinorVersion & vbCrLf & "< br>"
s &= "Platform = " & .Platform & vbCrLf & "< br>"
s &= "Is Beta = " & .Beta & vbCrLf & "< br>"
s &= "Is Crawler = " & .Crawler & vbCrLf & "< br>"
s &= "Is AOL = " & .AOL & vbCrLf & "< br>"
s &= "Is Win16 = " & .Win16 & vbCrLf & "< br>"
s &= "Is Win32 = " & .Win32 & vbCrLf & "< br>"
s &= "Supports Frames = " & .Frames & vbCrLf & "< br>"
s &= "Supports Tables = " & .Tables & vbCrLf & "< br>"
s &= "Supports Cookies = " & .Cookies & vbCrLf & "< br>"
s &= "Supports VBScript = " & .VBScript & vbCrLf & "< br>"
s &= "Supports JavaScript = " & .JavaScript & vbCrLf & "< br>"
s &= "Supports Java Applets = " & .JavaApplets & vbCrLf & "< br>"
s &= "Supports ActiveX Controls = " & .ActiveXControls & vbCrLf & "< br>"
End With
Response.Write(s)

How to count No.of Tables,stored procedures,views,functions,triggers,primary keys,etc...

2009-04-28T00:58:00.000-07:00

SELECT
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='U') AS [TABLES],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='P') AS [STORED PROCEDURE],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='X') AS [EXTENDED STORED PROCEDURE],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='V') AS [VIEW],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='IF') AS [FUNCTIONS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='TR') AS [TRIGERS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='C') AS [CHECK CONSTRAINTS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='D') AS [DEFAULT CONSTRAINTS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='F') AS [FOREIGN KEY CONSTRAINTS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='PK') AS [PRIMARY KEY CONSTRAINTS],
(SELECT COUNT(*) FROM SYSOBJECTS WHERE XTYPE='UQ') AS [UNIQUE CONSTRAINTS]

Multiple File uploading using C#.Net?

2009-03-20T22:26:00.001-07:00

HttpFileCollection uploadFilCol = Request.Files;
for(int i=0;i<uploadFilCol.Count;i++)
{
HttpPostedFile file = uploadFilCol[i];
string fileExt = Path.GetExtension(file.FileName).ToLower();
string fileName = Path.GetFileName(file.FileName);
if(fileName != string.Empty)
{
try
{
if(fileExt == ".jpg" || fileExt == ".gif")
{
file.SaveAs(Server.MapPath("./Images/") + fileName);
this.ShowMessage(" " + fileName + " Successfully Uploaded",i);
}
else
{
file.SaveAs(Server.MapPath("./Others/") + fileName);
this.ShowMessage(" " + fileName + " Successfully Uploaded",i);
}
}
catch(Exception ex)
{
this.ShowMessage(" " + ex.Message, i);
}
}
}

Multiple File uploading using C#.Net?

2009-03-20T22:26:00.000-07:00

How to upload multiple files using ASP.Net?

2009-03-20T22:18:00.000-07:00

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Fileupload.aspx.vb" Inherits="Fileupload" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
< html>
< head>
< title>Multiple File Upload</title>
< /head>
< body>
< form id="Form1" method="post" enctype="multipart/form-data" runat="server">
< h1>
ASP.NET Multiple File Upload Example</h1>
< p>
Select the Files to Upload to the Server:
< br>
< input id="File1" type="file" name="File1" runat="server">
< /p>
< p>
< input id="File2" type="file" name="File2" runat="server"></p>
< p>
< input id="Btnupload" type="submit" value="Upload Files" name="BtnUpload" runat="server" >
< /p>
< /form>
< asp:Label ID="ResultMsg" runat="server" Visible="False" ForeColor="#ff0033">< /asp:Label>
< /body>
< /html>

=======================

Imports System.IO

Partial Class Fileupload
Inherits System.Web.UI.Page

Protected Sub Btnupload_ServerClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Btnupload.ServerClick

Dim ResultMessage As String = ""
Dim Filename As String
Dim extension As String

'Variable FolderName where the files will be saved
Dim FolderName As String = "D:/AJAXVBWEB/Temp/"
'Variable to hold the File
Dim objFile As HttpPostedFile
'Variable used in the Loop
Dim i As Integer
Try
'Loop Through the Files
For i = 0 To Request.Files.Count - 1

'Get the HttpPostedFile
objFile = Request.Files(i)
'Check that the File exists has a name and is not empty
If Not (objFile Is Nothing Or objFile.FileName = "" Or objFile.ContentLength < 1) Then

'Get the name of the file
Filename = objFile.FileName
Filename = Path.GetFileName(Filename)
extension = Path.GetExtension(Filename)

'Creates the folder if it does not exists
If (Not Directory.Exists(FolderName)) Then
Directory.CreateDirectory(FolderName)
End If

'Save each uploaded file
objFile.SaveAs(FolderName & Filename)

'Assign the File Name and File Type to Result
ResultMessage = ResultMessage & "Uploaded File: " & objFile.FileName & " of type " & objFile.ContentType & "
"

End If
Next

'If no files where selected provide a user friendly message
If ResultMessage = "" Then
ResultMessage = "Select atleast one file to upload."
End If

Catch errorVariable As Exception
ResultMessage = errorVariable.ToString()
End Try

'Unhide the Result Label
ResultMsg.Visible = True
'Assign the Result to ResultMsg Label Text
ResultMsg.Text = ResultMessage

End Sub
End Class

Creating windows service using C#.Net?

2009-02-09T03:00:00.000-08:00

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.ServiceProcess;
using System.Text;
using System.Threading;
using System.Data.SqlClient;

namespace TestService
{
public partial class Wind_Service : ServiceBase
{
public Wind_Service()
{
InitializeComponent();
}

public System.Threading.Timer stateTimer;
public TimerCallback delegateTimer;
SqlConnection con = new SqlConnection("MultipleActiveResultSets=True;Server=" + ".\\SQLEXPRESS;DataBase=db;Integrated Security=SSPI;");
SqlCommand cmd;
SqlDataAdapter adp = new SqlDataAdapter();

#region On Service Start
protected override void OnStart(string[] args)
{
delegateTimer = new TimerCallback(performAction);
stateTimer = new Timer(delegateTimer, null, 0, (1000 * 60 * 1)); //One second = 1000 miliseconds)
EventLog.WriteEntry("Service Exactly Started at : " + DateTime.Now.ToString());
}
#endregion

#region Body of the Code
public void performAction(object sender)
{
try
{
//Body of the code
}
catch (Exception ex)
{
EventLog.WriteEntry("Service having error : " + ex.Message);
}
}
#endregion

#region On Service Stop
protected override void OnStop()
{
EventLog.WriteEntry("Service Stopped Successfully at : " + DateTime.Now.ToString());
}
#endregion

}
}

How to find the selected value in dropdownlist using C#.Net?

2009-02-07T01:26:00.000-08:00

ListItem lt = Dropdownlist1.Items.FindByText("Evening");
if (lt != null) Dropdownlist1.SelectedValue = lt.Value;

How to clear the controls using VB.Net?

2009-02-06T02:23:00.000-08:00

Sub ClearControls(ByVal parent As Control)
For Each ChildControl As Control In parent.Controls
If (ChildControl.Controls.Count > 0) Then
ClearControls(ChildControl)
Else
If TypeOf ChildControl Is TextBox Then
DirectCast(ChildControl, TextBox).Text = String.Empty
ElseIf TypeOf ChildControl Is DropDownList Then
DirectCast(ChildControl, DropDownList).SelectedIndex = 0
ElseIf TypeOf ChildControl Is CheckBox Then
DirectCast(ChildControl, CheckBox).Checked = False
End If
End If
Next
End Sub

What are all Access Specifiers available in.Net?

2009-01-27T01:30:00.000-08:00

Access keywords define the access to class members from the same class and from other classes. The most common access keywords are:

Public	Allows access to the class member from any other class.
Private	Allows access to the class member only in the same class.
Protected	Allows access to the class member only within the same class and from inherited classes.
Internal	Allows access to the class member only in the same assembly.
Protected Internal	Allows access to the class member only within the same class, from inherited classes, and other classes in the same assembly.
Static	Indicates that the member can be called without first instantiating the class.

How to Encrypt/Decrypt the web.Config Connection String?

2009-01-27T01:29:00.001-08:00

using System.Web.Configuration;
using System.Web.Security;
using System.Configuration;

public void EncryptConnString()
{

Configuration config = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
ConfigurationSection section = config.GetSection("connectionStrings");
if (!section.SectionInformation.IsProtected)
{
section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
config.Save();
}
}

--------------

public void DecryptConnString()
{
Configuration config = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
ConfigurationSection section = config.GetSection("connectionStrings");
if (section.SectionInformation.IsProtected)
{
section.SectionInformation.UnprotectSection();
config.Save();
}
}

How to concatenate two values while binding in Gridview/Datagrid?

2009-01-27T01:22:00.001-08:00

You can only have 1 databinding expression ( <%# xxx %> ) so you have to concatenate it:
Text='<%# Eval("Views") + Eval("ViewsAll","({0})") %>'
or another way (which I personally prefer) is to let a code behing method deal with it:
Text='<%# FormatViews(Eval("Views"),Eval("ViewsAlL")) %>'
and then in code behind

protected string FormatViews(object views, object viewsAll)
{
return String.Format("{0} ({1})",views,viewsAll);
}

How to detect whether internet is availabe in a system or not using C#.Net?

2009-01-21T23:31:00.000-08:00

protected bool IsNetworkConnected()
{
bool connected = false;
System.Management.ManagementObjectSearcher searcher = new System.Management.ManagementObjectSearcher("SELECT NetConnectionStatus FROM Win32_NetworkAdapter");
foreach (System.Management.ManagementObject networkAdapter in searcher.Get())
{
if (networkAdapter["NetConnectionStatus"] != null)
{
if (Convert.ToInt32(networkAdapter["NetConnectionStatus"]).Equals(2))
{
connected = true;
break;
}
}
}
searcher.Dispose();
return connected;
}
----------------------------
OR
----------------------------

public bool IsConnectionAvailable()
{
System.Net.WebRequest objWebReq= System.Net.WebRequest.Create("http://www.kannabiranb.blogspot.com/");
System.Net.WebResponse objResp;
try
{
objResp = objWebReq.GetResponse();
objResp.Close();
objWebReq = null;
return true;
}
catch(Exception ex)
{
objResp = null;
objWebReq = null;
return false;
}
}

How to detect Capslock is On/Off using Javascript?

2008-12-26T23:40:00.000-08:00

<asp:TextBox ID="TextBox1" onkeypress="capsDetect(arguments[0]);" runat="server"></asp:TextBox>

<script language="javascript" type="text/javascript">
var capsError = 'WARNING:\n\nCaps Lock is enabled\n\nThis field is case sensitive';

function capsDetect( e ) {
if( !e ) { e = window.event; } if( !e ) { MWJ_say_Caps( false ); return; }
//what (case sensitive in good browsers) key was pressed
var theKey = e.which ? e.which : ( e.keyCode ? e.keyCode : ( e.charCode ? e.charCode : 0 ) );
//was the shift key was pressed
var theShift = e.shiftKey || ( e.modifiers && ( e.modifiers & 4 ) ); //bitWise AND
//if upper case, check if shift is not pressed. if lower case, check if shift is pressed
MWJ_say_Caps( ( theKey > 64 && theKey < 91 && !theShift ) || ( theKey > 96 && theKey < 123 && theShift ) );
}
function MWJ_say_Caps( oC ) {
if( typeof( capsError ) == 'string' ) { if( oC ) { alert( capsError ); } } else { capsError( oC ); }
}
</script>

Password Encryption and Decryption Using VB.Net

2008-12-26T23:24:00.000-08:00

Public Function EnCrypt(ByVal strCryptThis)
Dim key As String
key = "`*Y8+Y.UR(A8&T[JP9RW*6J.>LZO16-B/N<FO5:ZG<,B.C4ZZ*M>7VO$MLNV0??>_E1-ZTXH_L)@XW8MFT?PES\-Z(5BY=O3QJ]7MM9@+XC34-I'T*C<[HUEK,2768816E6M*Z.LH:/E@<<-(BL)>.K7@18`D*IB/Q-Z17H6[J[`@@`,^8LA,=OKZR9*GMU2]H3I&YZHG%=073J._'50(35M>+(:A\1H(D:BI?8L-`E[&MJ;/39%42$FA>2QK-I-#D;>SPJF`=SJFM4GKYE?/`/QR+@'J6]#"
Dim iKeyChar, iStringChar, i, strEncrypted, iCryptChar, g_Key
If Len(strCryptThis) > 0 Then
g_Key = Mid(key, 1, Len(strCryptThis))
For i = 1 To Len(strCryptThis)
iKeyChar = Asc(Mid(g_Key, i, 1))
iStringChar = Asc(Mid(strCryptThis, i, 1))
iCryptChar = iStringChar + iKeyChar
strEncrypted = strEncrypted & Chr(iCryptChar)
Next
EnCrypt = strEncrypted
Else
EnCrypt = strCryptThis
End If

End Function

Function DeCrypt(ByVal strEncrypted)
Dim key As String
key = "`*Y8+Y.UR(A8&T[JP9RW*6J.>LZO16-B/N<FO5:ZG<,B.C4ZZ*M>7VO$MLNV0??>_E1-ZTXH_L)@XW8MFT?PES\-Z(5BY=O3QJ]7MM9@+XC34-I'T*C<[HUEK,2768816E6M*Z.LH:/E@<<-(BL)>.K7@18`D*IB/Q-Z17H6[J[`@@`,^8LA,=OKZR9*GMU2]H3I&YZHG%=073J._'50(35M>+(:A\1H(D:BI?8L-`E[&MJ;/39%42$FA>2QK-I-#D;>SPJF`=SJFM4GKYE?/`/QR+@'J6]#"
Dim iKeyChar, iStringChar, i, g_Key, iDeCryptChar, strDecrypted

If Len(strEncrypted) > 0 And Not IsNumeric(strEncrypted) Then
g_Key = Mid(key, 1, Len(strEncrypted))
For i = 1 To Len(strEncrypted)
iKeyChar = (Asc(Mid(g_Key, i, 1)))
iStringChar = Asc(Mid(strEncrypted, i, 1))
If iStringChar = 32 Then iStringChar = 160
iDeCryptChar = iStringChar - iKeyChar
strDecrypted = strDecrypted & Chr(iDeCryptChar)
Next
DeCrypt = strDecrypted
Else
DeCrypt = strEncrypted
End If

End Function

How to shift the Listbox selected item, Left to Right and Right to Left?

2008-12-26T23:18:00.000-08:00

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Listbox Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListBox ID="LeftListBox" runat="server" SelectionMode="multiple" />
<asp:Button ID="RightBtn" runat="server" OnClick="MoveRight" Font-Bold="true" Text=" > " />
<asp:Button ID="LeftBtn" runat="server" OnClick="MoveLeft" Font-Bold="true" Text=" < " />
<asp:ListBox ID="RightListBox" runat="server" SelectionMode="multiple" />
</div>
</form>
</body>
</html>

========Code Behind========
public partial class _Default : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
BindData();
}

protected void MoveRight(object sender, EventArgs e)
{
while (LeftListBox.Items.Count > 0 && LeftListBox.SelectedItem != null)
{
ListItem selectedItem = LeftListBox.SelectedItem;
selectedItem.Selected = false;
RightListBox.Items.Add(selectedItem);
LeftListBox.Items.Remove(selectedItem);
}
}

protected void MoveLeft(object sender, EventArgs e)
{
while(RightListBox.Items.Count > 0 && RightListBox.SelectedItem != null)
{
ListItem selectedItem = RightListBox.SelectedItem;
selectedItem.Selected = false;
LeftListBox.Items.Add(selectedItem);
RightListBox.Items.Remove(selectedItem);
}
}
private void BindData()
{
LeftListBox.Items.Add(new ListItem("Kanna", "Kanna"));
LeftListBox.Items.Add(new ListItem("Ram", "Ram"));
LeftListBox.Items.Add(new ListItem("Gokul", "Gokul"));
}
}

Available Xtypes in SQL Server

2008-12-20T00:46:00.000-08:00

Select
Name,
'Object Type' = Case
When XType = 'C' Then 'Check Constraint'
When XType = 'D' Then 'Default or Default Constraint'
When XType = 'F' Then 'Foreign Key Constraint'
When XType = 'L' Then 'Log'
When XType = 'FN' Then 'Scalar Function'
When XType = 'IF' Then 'Inlined Table Function'
When XType = 'P' Then 'Stored Procedure'
When XType = 'PK' Then 'Primary Key Constraint'
When XType = 'RF' Then 'Replication Filter Stored Procedure'
When XType = 'S' Then 'System Table'
When XType = 'TF' Then 'Table Function'
When XType = 'TR' Then 'Trigger'
When XType = 'U' Then 'User Table'
When XType = 'UQ' Then 'Unique Constraint'
When XType = 'V' Then 'View'
Else 'Extended Stored Procedure'
End
From SysObjects
Group By Name, XType order by 'object type'

Available Date Formats in SQL Server

2008-12-20T00:41:00.001-08:00

ID	Date Formats
0 or 100	mon dd yyyy hh:miAM (or PM)
101	mm/dd/yy
102	yy.mm.dd
103	dd/mm/yy
104	dd.mm.yy
105	dd-mm-yy
106	dd mon yy
107	Mon dd, yy
108	hh:mm:ss
9 or 109	mon dd yyyy hh:mi:ss:mmmAM (or PM)
110	mm-dd-yy
111	yy/mm/dd
112	yymmdd
13 or 113	dd mon yyyy hh:mm:ss:mmm(24h)
114	hh:mi:ss:mmm(24h)
20 or 120	yyyy-mm-dd hh:mi:ss(24h)
21 or 121	yyyy-mm-dd hh:mi:ss.mmm(24h)
126	yyyy-mm-dd Thh:mm:ss.mmm(no spaces)
130	dd mon yyyy hh:mi:ss:mmmAM
131	dd/mm/yy hh:mi:ss:mmmAM

Uplaoding Resume to Sql server 2000 using c#.net

2008-11-18T01:08:00.000-08:00

CREATE TABLE [dbo].[tbl_documents]
(
document_id int IDENTITY (1, 1) NOT NULL ,
document image,
docContentType nvarchar (20),
docFileName nvarchar(255) ,
docFileSize nvarchar(7)
)

CREATE PROCEDURE [dbo].[uploadDoc]
(
@docContentType NVARCHAR(20),
@docFileName NVARCHAR(255),
@docFileSize NVARCHAR(7),
@document IMAGE
)

AS

INSERT INTO dbo.tbl_documents
(docContentType, docFileName, docFileSize,document)
VALUES
(@docContentType, @docFileName, @docFileSize,@document)
GO

GRANT EXEC ON [dbo].[uploadDoc] TO
GO

CREATE PROCEDURE [dbo].[downloadDoc]
(
@document_id INT,
)

AS

SELECT docContentType, docFileName, docFileSize,document)
FROM tbl_documents
WHERE document_id = @document_id

GO

GRANT EXEC ON [dbo].[downloadDoc] TO
GO

UPLOAD: (In button event handler)

string contenttype = "";
string filename = "";
int filesize = 0;
byte[] DocBuffer = null;
System.IO.Stream str;
//fuDoc is a fileupload control
if(this.fuDoc.HasFile)
{
contenttype = this.fuDoc.PostedFile.ContentType;
filename = this.fuDoc.PostedFile.FileName;
filesize = this.fuDoc.PostedFile.ContentLength;
DocBuffer = new byte[filesize];
str = this.fuDoc.PostedFile.InputStream;
str.Read(DocBuffer,0,filesize);
}
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["<storedconnectionstring>"].ToString());
SqlCommand cmdNewDocument = new SqlCommanduploadDoc",conn);
cmdNewDocument.CommandType = CommandType.StoredProcedure;
cmdNewDocument.Parameters.Add("@document_id", SqlDbType.Int);
cmdNewDocument.Parameters.Add("@docContentType", SqlDbType.NVarChar,20);
cmdNewDocument.Parameters.Add("@docFileName", SqlDbType.NVarChar,110);
cmdNewDocument.Parameters.Add("@docFileSize", SqlDbType.NVarChar,7);
cmdNewDocument.Parameters.Add("@document", SqlDbType.Image);
cmdNewDocument.Parameters["@document_id"].Value = DBNull.Value;
cmdNewDocument.Parameters["@docContentType"].Value = contenttype;
cmdNewDocument.Parameters["@docFileName"].Value = filename;
cmdNewDocument.Parameters["@docFileSize"].Value = filesize.ToString();
cmdNewDocument.Parameters["@document"].Value = DocBuffer;

try
{
conn.Open();
cmdNewDocument.ExecuteNonQuery();
}
catch (SqlException sqle)
{
//appropriate code
}
catch (Exception gen)
{
//appropriate code
}
finally
{
if (conn.State != ConnectionState.Closed)
conn.Close();
conn.Dispose();
}DOWNLOAD: (I put this code in a Page_Load Event)

Response.Buffer = true;
string docid = Request.QueryString["docid"];

SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["<storedconnectionstring>"].ToString();
SqlCommand cmdExport = new SqlCommand();
cmdExport.CommandType = CommandType.StoredProcedure;
cmdExport.CommandText = "downloadDoc";cmdExport.Connection = conn;

try
{
conn.Open();
SqlDataReader rdrExport = cmdExport.ExecuteReader();
if (rdrExport.HasRows)
{
rdrExport.Read();
string fileName = rdrExport.GetValue(rdrExport.GetOrdinal("docFileName")).ToString();
byte[] buffer = new byte[Convert.ToInt32(rdrExport.GetValue(rdrExport.GetOrdinal("docFileSize")).ToString())];
buffer = rdrExport.GetSqlBytes(rdrExport.GetOrdinal("document")).Buffer;
Response.ContentType = rdrExport.GetValue(rdrExport.GetOrdinal("docContentType")).ToString();
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName );
Response.AddHeader("Content-Length", rdrExport.GetValue(rdrExport.GetOrdinal("docFileSize")).ToString());

Response.BinaryWrite(buffer);
Response.Flush();
Response.End();
}
rdrExport.Close();
}
catch (SqlException sqle)
{
//appropriate code
}
catch (Exception gen)
{
//appropriate code
}
finally
{
if (conn.State != ConnectionState.Closed)
conn.Close();
conn.Dispose();
}

How to convert numbers to words using javascript?

2008-11-18T01:07:00.000-08:00

// American Numbering System
var th = ['','thousand','million', 'billion','trillion'];
// uncomment this line for English Number System
// var th = ['','thousand','million', 'milliard','billion'];

var dg = ['zero','one','two','three','four', 'five','six','seven','eight','nine'];
var tn = ['ten','eleven','twelve','thirteen', 'fourteen','fifteen','sixteen', 'seventeen','eighteen','nineteen'];
var tw = ['twenty','thirty','forty','fifty', 'sixty','seventy','eighty','ninety'];
function toWords(s)
{
s = document.getElementById(s.id).value; //Source Control
//s = s.toString();
s = s.replace(/[\, ]/g,'');
if (s != String(parseFloat(s)))
return 'not a number';
var x = s.indexOf('.');
if (x == -1) x = s.length;
if (x > 15)
return 'too big';
var n = s.split('');
var str = '';
var sk = 0;
for (var i=0; i < x; i++)
{
if ((x-i)%3==2)
{
if (n[i] == '1')
{
str += tn[Number(n[i+1])] + ' ';
i++; sk=1;
}
else if (n[i]!=0)
{
str += tw[n[i]-2] + ' ';
sk=1;
}
}
else if (n[i]!=0)
{
str += dg[n[i]] +' ';
if ((x-i)%3==0)
str += 'hundred ';
sk=1;
}
if ((x-i)%3==1)
{
if (sk)
str += th[(x-i-1)/3] + ' ';
sk=0;
}
}
if (x != s.length)
{
var y = s.length;
str += 'point ';
for (var i=x+1; i str += dg[n[i]] +' ';
}
document.getElementById('TxtWords').value=str.replace(/\s+/g,' ') +' ' + 'rupees only'; //TargetControl
//return str.replace(/\s+/g,' ');
}

How to remove white space,special characters and return only numbers using javascript

2008-11-18T01:04:00.000-08:00

How To Find Date Difference Using Javascript?

2008-11-18T01:03:00.000-08:00

function Date_Diff()
{
var dt1=document.getElementById('TextBox1').value;//Start Date
var dt2=document.getElementById('TextBox2').value;//End Date
dt1=dt1.split('/');
dt2=dt2.split('/');
var st=new Date(dt1[2],dt1[0],dt1[1]);
var ed=new Date(dt2[2],dt2[0],dt2[1]);
if (ed > st)
alert('True');
else
alert('False');
}

Handling Application Errors in Global.asax

2008-11-18T01:02:00.000-08:00

void Application_Error(object sender, EventArgs e)
{
Exception exception = Server.GetLastError();
try
{
HttpException httpException = (HttpException) exception;
int httpCode = httpException.GetHttpCode();
switch (httpCode)
{
case 403: Response.Redirect("~/Pages/Error/NoAccess.aspx");break;
case 404: Response.Redirect("~/Pages/Error/PageNotFound.aspx");break;
default: Response.Redirect("~/Pages/Error/Generic.aspx");break;
}
}
catch {}
Server.ClearError();
}

How to shutdown the system using VB.Net?

2008-09-05T02:48:00.000-07:00

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click

Dim t As Single
Dim objWMIService, objComputer As Object
'Now get some privileges
objWMIService = GetObject("Winmgmts:{impersonationLevel=impersonate,(Debug,Shutdown)}")

For Each objComputer In objWMIService.InstancesOf("Win32_OperatingSystem")
t = objComputer.Win32Shutdown(8 + 4, 0)
If t <> 0 Then
MsgBox("Error occurred!!!")
Else
'LogOff your system
End If
Next

End Sub