Smart Coder: 2010

Sunday, November 28, 2010

Bulk Inser in Sql from CSV

/* CSV to SQL */
create table UserTable(
UserName varchar(50),
UserPassword varchar(50)
)

BULK
INSERT UserTable
FROM 'D:\Usertable.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
___________

[ Using Procedure ]
In Code behind
-------------

Dbconn.connection();

cmd = new SqlCommand("bulkinsert",Dbconn.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Path",SqlDbType.VarChar,50));
cmd.Parameters["@Path"].Value = FileUpload2.PostedFile.FileName;
cmd.ExecuteNonQuery();
----

Procedure
---------
CREATE Procedure [dbo].[bulkinsert]
@Path Varchar(50)
As
Declare @Str Varchar(2000)
Begin
Set @Str=''BULK INSERT waybill_register FROM ''
Set @Str=@Str+''''''''
Set @Str=@Str+@Path
Set @Str=@Str+''''''''
Set @Str=@Str+'' WITH (FIELDTERMINATOR = '''','''',ROWTERMINATOR = ''''\n'''')''
Exec(@Str)
End

Thursday, November 25, 2010

Important Link

0 comments

/* Free Text Box */

http://jhtmlarea.codeplex.com/

http://jhtmlarea.codeplex.com/releases/view/30759

_____________

/* Jquery Web control for asp.net */

http://dj.codeplex.com/

_____________
/* Jquery Chat */

http://aspnetjquerychat.codeplex.com/

__________

/* Jquery toolkit */

http://jquerytoolkit.codeplex.com/
_________________

/* Char using jquery */

http://www.codeproject.com/KB/webforms/ms-chart-with-jquery.aspx
__________

/* Jquery Image galery */

http://notesforgallery.codeplex.com/
_____________

/* Important DLL free Download */

http://dll.downloadatoz.com/

_______________

/* Telleric */

http://www.telerik.com/community/forums/aspnet/splitter/position-of-sliding-window-when-page-scrolls.aspx

___________

/* Image Slider */

http://mediaeventservices.com/blog/2007/11/15/ajax-image-gallery-powered-by-slideflow-like-cover-flow/

_________

/* Important Jquery */

http://docs.jquery.com/Tutorials:Live_Examples_of_jQuery

___________
/* Jquery for drag drop */

http://code.google.com/p/jsmarty/source/browse/trunk/samples/shared/scripts/jquery-ui-personalized-1.6rc2.js?r=444
_________

/* nicer swiping / ajax examples */

http://leodruker.theorydesign.ca/about/#2

http://visuallightbox.com/lightbox-mac-style-demo.html

http://nooshu.com/recreate-iphone-swipe-effect-using-jquery/
http://nooshu.com/explore/jquery-iphone-animation/
________

Monday, September 20, 2010

Important All Code

0 comments

/* SharePoint Tutorial */

http://www.deitel.com/ResourceCenters/Software/SharePoint/Tutorials/tabid/2783/Default.aspx

________

http://www.queness.com/post/356/create-a-vertical-horizontal-and-diagonal-sliding-content-website-with-jquery

_________________

File upload
--------

try
{
if (Updfile.FileName.Length > 0)
{
a = Updfile.FileName.Split('.');
fileName = Convert.ToString(System.DateTime.Now.Ticks) + "." + a.GetValue(1).ToString();
FilePath = Server.MapPath(@"~\MDAFile");
Updfile.SaveAs(FilePath + @"\" + fileName);
//if (strMode == "EDIT")
//{
// File.Delete(FilePath + @"\" + hdFile.Value);
//}
}
else
{
fileName = hdFile.Value;
}
}
catch
{
fileName = hdFile.Value;
}

___________________________

Work Log

1.Enable auto post back to work in selected index change.
2.Session: Session["Mode"] = "0";

Why use Sp?
a. It works/executes fast as it is in precompiled mode.
b. As it is in the database so if the BL gets leaked there is no chance of leaking the database… so security..

Query String..
Put this code to your submit button event handler.
private void btnSubmit_Click(object sender, System.EventArgs e)
{
Response.Redirect("Webform2.aspx?Name=" +
this.txtName.Text + "&LastName=" +
this.txtLastName.Text);
}
Put this code to second page page_load.
private void Page_Load(object sender, System.EventArgs e)
{
this.txtBox1.Text = Request.QueryString["Name"];
this.txtBox2.Text = Request.QueryString["LastName"];
}

To view a date in a gridview frm table.

To fetch a int data from a gridview select event….
Convert.ToInt32(gvEmp.SelectedRow.Cells[1].Text);

RegEx
Numeric- “\d+\.?\d*”
Email- "\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
Fileuploader=".*(\.txt|\.TXT)$"
String
String two =3D "12";
Int one =3D int.Parse(two.Substring(0,1));
Int two =3D int.Parse(two.Substring(1,1));
Int both =3D int.Parse(two.Substring(0,2));

Work with date time
DateTime tmp=Convert.ToDateTime(dr.ItemArray.GetValue(2));
txtYear.Text = tmp.Year.ToString();
ddlDay.SelectedIndex = Convert.ToInt32(tmp.Day.ToString())-1;
ddlMonth.SelectedIndex = Convert.ToInt32(tmp.Month.ToString()-1);

Using the Regex Class

Add a using statement to reference the System.Text.RegularExpressions namespace.
Call the IsMatch method of the Regex class, as shown in the following example.
// Instance method:
Regex reg = new Regex(@"^[a-zA-Z'.]{1,40}$");
Response.Write(reg.IsMatch(txtName.Text));

// Static method:
if (!Regex.IsMatch(txtName.Text,
@"^[a-zA-Z'.]{1,40}$"))
{
// Name does not match schema
}

Making a CheckAll functionality
To add a check-all functionality in the GridView, simply add a HTML CheckBox to the header template of the checkbox column.

runat="server" type="checkbox" />

SelectAllCheckboxes JavaScript method:

Show Data in formated way data [format{0:dd-MMM-yyyy}] in greidview

Declare a boolean column

CAST('True' AS bit) AS L

Regex for 0, decimal, integer…
^[0-9.\d+]{1,40}$

GET GRIDVIEW ROW
GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int CustId = Convert.ToInt32(GvDisp.DataKeys[row.RowIndex].Value.ToString());

OFFLINE DATATABLE SORTING AND SAVING
dataview v=dt.defaultview;
v.sort="columnName DESC";
dt=v.toTable();

TRY CATCH IN SQL SERVER
BEGIN TRY
BEGIN TRAN
SELECT * FROM Advertisement
COMMIT TRANSACTION

END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() ErrorNBR, ERROR_SEVERITY() Severity,
ERROR_LINE () ErrorLine, ERROR_MESSAGE() Msg
ROLLBACK TRANSACTION
END CATCH

Getting password in edit

txtPassword.Text = ManagePassword.strDecrypt(objUsr.Password, "vtpl2006", "vtpl2009");
ViewState["MyPassword"] = txtPassword.Text;
txtPassword.Attributes.Add("value", ViewState["MyPassword"].ToString());

lblPrice.Text = String.Format("{0:c}", price);
lblTime.Text = String.Format("{0:T}", rightNow);
lblDate.Text = String.Format("{0:d}", rightNow);
lblBigInt.Text = String.Format("{0:#,###}", bigNumber);

For editing a password field

txtPassword.Text = ManagePassword.strDecrypt(objUsr.Password, "vtpl2006", "vtpl2009");
ViewState["MyPassword"] = txtPassword.Text;
txtPassword.Attributes.Add("value", ViewState["MyPassword"].ToString());

public string ConvertSize ( decimal ip )
{
decimal op = ip / 1024;
string strUnit = "";

if ( ip >= 1073741824 )
{
op = ip / 1073741824;
strUnit = "GB";
}
else if ( ip >= 1048576 )
{
op = Convert.ToDecimal ( ip / 1048576 );
strUnit = "MB";
}
else if ( ip >= 1024 )
{
op = Convert.ToDecimal ( ip / 1024 );
strUnit = "KB";
}
else if ( ip > 0 )
{
op = ip;
strUnit = "Bytes";
}
else
{
op = 0.00M;
strUnit = "0";
}

return op.ToString (

SEND MAIL
public void ExecuteHtmlSendMail(string FromAddress, string ToAddress, string BodyText, string Subject)
{
MailMessage mailMsg = new MailMessage();
mailMsg.From = new MailAddress(FromAddress);
mailMsg.To.Add(new MailAddress(ToAddress));
mailMsg.Subject = Subject;
mailMsg.BodyEncoding = System.Text.Encoding.GetEncoding(”utf-8?);
System.Net.Mail.AlternateView plainView = System.Net.Mail.AlternateView.CreateAlternateViewFromString
(System.Text.RegularExpressions.Regex.Replace(BodyText, @”<(.|\n)*?>”, string.Empty), null, “text/plain”);
System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(BodyText, null, “text/html”);
mailMsg.AlternateViews.Add(plainView);
mailMsg.AlternateViews.Add(htmlView);
// Smtp configuration
SmtpClient smtp = new SmtpClient();
smtp.Host = “smtp.gmail.com”;
smtp.Credentials = new System.Net.NetworkCredential(”username”, “password”);
smtp.EnableSsl = true;
smtp.Send(mailMsg);
}
Read Word Doc
protected void Page_Load(object sender, EventArgs e)
{
Microsoft.Office.Interop.Word.ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
object file = "D:\\test1.doc"; // Specify path for word file
object nullobj = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Word.Document doc = wordApp.Documents.Open(ref file, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj, ref nullobj);

Microsoft.Office.Interop.Word.Document doc1 = wordApp.ActiveDocument;
string mContent = doc1.Content.Text;

Response.Write(mContent);
}

Message Show
System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(PagerButtons), "Session Timeout", "alert('Your active session has been expired please login again')", true);

GET PRIVIOUS PAGE NAME
System.IO.Path.GetFileName(Request.ServerVariables["HTTP_REFERER"]) == "inbox_interests.aspx"

JAVASCRIPT NEW WINDOW
','','width=400,height=250,status=no,location=no,menubar=no,%20left=0,%20top=0,%20scrollbars=1');%20%20sub.parent.history.back();">

Javascript Message
With update panel
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript",
"alert('Registration Successfull')", true);

Without update panel
Page.ClientScript.RegisterStartupScript(this,this.GetType(), "alert", "alert('Registration Successfull')", true);

Return data from SP
SqlConnection conn=new SqlConnection();
conn.ConnectionString = @"Data Source=SERVER1\SQLEXPRESS;Initial Catalog=MarryAnNri;Persist Security Info=True;User ID=sa;Password=sa@1234;connection timeout = 2000";
SqlCommand cmd=new SqlCommand("spTest",conn);
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds=new DataSet();
da.Fill(ds);

__________________

/* Show different type of icon in grid view button */

DataView dv = new DataView();
vw_favourite objFav = new vw_favourite();
objFav.SqlLoad("select * from vw_favourite where UserId='" + ((UserDetails)Session["LoggedUserDetails"]).ID + "'");
dv = objFav.DefaultView;

GVFavourite.DataSource = dv;
GVFavourite.DataBind();
foreach (GridViewRow row in GVFavourite.Rows)
{
Label lbl = (Label)row.FindControl("lbl");
Image img = (Image)row.FindControl("imgBtn");
string filename = lbl.Text;
string ext = filename.Substring(filename.Length - 3);
if ( ext.ToLower() == "txt")
{
img.ImageUrl = "~/images/txt.png";//E:\LinearTech\images
}
else if (ext.ToLower() == "pdf")
{
img.ImageUrl = "~/images/pdf.jpg";
}
else if (ext.ToLower() == "doc")
{
img.ImageUrl = "~/images/doc_icon.jpg";
}
___________________________--

/* Graph Charts */

http://www.codeproject.com/KB/web-image/ZedGraphWebAp1.aspx

__________________

/* Mailing and SMS systems */

http://www.codeproject.com/KB/aspnet/EasySMTP_package.aspx
http://www.aspfree.com/c/a/ASP.NET/Creating-Your-Own-Online-Email-System-in-ASP-NET-2-0/

_________________

---------- search page----------------

---------------- google adsence---------------------

________________________

/* Charts , barchart, piechart */

http://www.amcharts.com/download

____________

/* Invoice Format */

http://www.vertex42.com/ExcelTemplates/excel-invoice-template.html

_____________

______________
/* Solving of IIS problem */

http://www.west-wind.com/weblog/posts/698097.aspx

_____________
/* important JavaScript */
http://www.dotnetspider.com/resources/Category545.aspx
______________

/* All column names with table name in another table */
/* It saves every column name with table name in dbo.translations, a new table */

SELECT t.name AS tableName,
SCHEMA_NAME(schema_id) AS [schema],
c.name AS columnName,
CAST(null as varchar(200)) as translation into dbo.translations
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
ORDER BY tableName
________________

What are the differences between stored procedure and functions in SQL Server 2000?
Answer

1) functions are used for computations where as procedures
can be used for performing business logic
2) functions MUST return a value, procedures need not be.
3) you can have DML(insert, update, delete) statements in a
function. But, you cannot call such a function in a SQL
query..eg: suppose, if u have a function that is updating a
table.. you can't call that function in any sql query.-
select myFunction(field) from sometable; will throw error.
4) function parameters are always IN, no OUT is possible
5) EXEC command can't be used inside a Function where it
can be used inside an sproc

_____________

/* SharePoint Tutorial */

http://www.deitel.com/ResourceCenters/Software/SharePoint/Tutorials/tabid/2783/Default.aspx
__________
http://forums.asp.net/p/1209470/2126993.aspx
---------------------------------------
TargetControlID="TextBox1"
WatermarkText="Type First Name Here"
WatermarkCssClass="watermarked" />
----------------------------------
http://www.codeproject.com/KB/aspnet/SendingSMS.aspx

http://forums.asp.net/t/1191703.aspx

--------------------------------
/* Regular Expressions */

ControlToValidate="txtName"
ErrorMessage="ID must be 6-10 letters."
ValidationExpression="[a-zA-Z]{6,10}" />

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

ControlToValidate="txtPWord"
ErrorMessage="Password must contain one of @#$%^&*/."
ValidationExpression=".*[@#$%^&*/].*" />
ControlToValidate="txtPWord"
ErrorMessage="Password must be 4-12 nonblank characters."
ValidationExpression="[^\s]{4,12}" />
------------------------

/* Google absence */

http://ctrlf5.net/?p=159

______________________________

/* Custom Control */

/* Scheduler, Gantt Chart */
http://www.codeproject.com/KB/custom-controls/schedule.aspx
http://demos.telerik.com/aspnet-ajax/scheduler/examples/webservice/defaultcs.aspx

___________________

/* Youtube */

File Upload

0 comments

protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
try {
FileUpload1.SaveAs("C:\\Uploads\\" + FileUpload1.FileName);
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.";
}

Grid Check box

0 comments

protected void Button1_Click(object sender, EventArgs e)
{
Label lb1 = new Label();
CheckBox chk1 = new CheckBox();
foreach (GridViewRow grd in GridView1.Rows)
{
chk1 = (CheckBox)grd.FindControl("CheckBox1");
if (chk1.Checked == true)
{
lb1 = (Label)grd.FindControl("Label1");
}
TextBox1.Text = lb1.Text.ToString();
}
}

Grid View Check box with link button click

0 comments

CheckBox chk1;
for (int k = 0; k < gvPackageCourses.Rows.Count; k++)
{
chk1 = ((CheckBox)gvPackageCourses.Rows[k].Cells[2].FindControl("chkBoxCourses"));
chk1.Checked = false;
}
LinkButton sel = ((LinkButton)sender);int rowindex = Int32.Parse(sel.CommandArgument);

Label lblId;
vw_enqueryreg objvw = new vw_enqueryreg();
//objvw.FlushData();
objvw.LoadSql("select courseid from vw_enqueryreg where StudentId='"+rowindex+"'");
////objvw.Where.StudentId.Value = rowindex;
////objvw.Where.StudentId.Operator = VTPLfx.WhereParameter.Operand.Equal;////objvw.Query.Load();int rowno = objvw.DefaultView.ToTable().Rows.Count;
CheckBox chk;
for (int i = 0; i < gvPackageCourses.Rows.Count; i++)
{
chk = ((CheckBox)gvPackageCourses.Rows[i].Cells[2].FindControl("chkBoxCourses"));
//////if(objvw.DefaultView.ToTable().Rows[i][0]==)
for (int j = 0; j < rowno; j++)
{
lblId = ((Label)gvPackageCourses.Rows[i].Cells[0].FindControl("lblprimaryKey"));
long id = long.Parse(lblId.Text);
if (id.ToString() == objvw.DefaultView.ToTable().Rows[j][0].ToString())
{
chk.Checked = true;
}
}
//chk.Checked = true;
}
//int rowIndex = Int32.Parse(link1.CommandArgument);
//for (int i = 0; i < gvEnquiryList.Rows.Count; i++)//{
// int temp = Convert.ToInt32(gvEnquiryList.Rows[i].Cells[2].Text.ToString());
//}

Session Check

0 comments

if (!Page.IsPostBack)
{
if (Session["SessionName"] == null)
{
Response.Redirect("Default.aspx");
}

Catching Html textbox value

0 comments

HTML declaration:
C# Code:string strValue = Page.Request.Form["name of the control"].ToString();

Code Behind Binding of Dropdown

0 comments

DropDownlist1.DataSource = ds;
DropDownlist1.DataTextField = "Name";
DropDownlist1.DataValueField = "ID";
DropDownlist1.DataBind();
ListItem li = new ListItem("--- Select ----", "-1");
DropDownlist1.Items.Insert(0, li);

Calculation of date Of birth

0 comments

// get the difference in yearsint years = DateTime.Now.Year - BirthDate.Year;
// subtract another year if we're before the
// birth day in the current year
if (DateTime.Now.Month < BirthDate.Month (DateTime.Now.Month == BirthDate.Month && DateTime.Now.Day < BirthDate.Day))
years--;

Red Green Button in gridview (true, False)

0 comments

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
// take the data in to dataset called ds
ImageButton ibtnSt = (ImageButton)e.Row.FindControl("ImageButton1");
int temp= int.Parse(ibtnSt.CommandArgument);
if (ds.tables[0].rows[0][3]== true)
{
ibtnSt.ImageUrl = @"image" + @"/iconGreen.gif";
}
else
{
ibtnSt.ImageUrl = @"image" + @"/iconRed.gif";
}
}
}

Row as column

0 comments

CREATE TABLE dbo.tblCars(RecordID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,DealerID INT NOT NULL,Make NVARCHAR(50),MakeYear SMALLINT,CarsSold INT)select * from information_schema.tablesselect * from tblcars
INSERT INTO dbo.tblCars SELECT 1, 'Honda', 2003, 100INSERT INTO dbo.tblCars SELECT 2, 'Toyota', 2003, 500INSERT INTO dbo.tblCars SELECT 2, 'Honda', 2003, 200INSERT INTO dbo.tblCars SELECT 1, 'Honda', 2004, 200INSERT INTO dbo.tblCars SELECT 1, 'Toyota', 2004, 600INSERT INTO dbo.tblCars SELECT 2, 'Honda', 2004, 300INSERT INTO dbo.tblCars SELECT 2, 'Toyota', 2005, 50
SELECT Make, [2003], [2004], [2005] FROM(SELECT Make, CarsSold, MakeYear FROM dbo.tblCars) tblCarsPIVOT (SUM(CarsSold) FOR MakeYear IN ([2003],[2004], [2005])) tblPivot

/* catching btn argument value */

0 comments

/* catching btn argument value */

long lCasteId = long.Parse(((ImageButton)sender).CommandArgument);

/* Generating Random number using system function */

0 comments

Random reportID = new Random();
int val = reportID.Next(100000);
Random reportID = new Random();
int val = reportID.Next(100000);
string rId = "CII-" + val.ToString() + "";

/* Textbox to dorpdownlist*/

0 comments

//string[] arr;
////arr = Convert.ToString(TextBox1.Text);
//arr = TextBox1.Text.Split(',');
string abc = TextBox1.Text;
foreach (char a in abc)
{
DropDownList1.Items.Add(a.ToString());
}
//for (int i = 0; i < arr.Length; i++)
//{
// DropDownList1.Items.Add(arr[i]);
//}

Data base CASE

0 comments

CASE WHEN dbo.vwForwardingLetter.ChalanDate = '01/01/1900' THEN NULL ELSE dbo.vwForwardingLetter.ChalanDate END

CASE WHEN dbo.vwSchemeAmntRecv.SchemeType = 'R' THEN 'Recurring' ELSE CASE WHEN dbo.vwSchemeAmntRecv.SchemeType = 'F' THEN 'Fixed' ELSE 'MIS' END END

Query string

0 comments

"MoneyReceiptBill.aspx?PayId=" + Eval("PayId")

----------------
if (Page.Request.QueryString["PayId"] != null)
{

payId = Convert.ToInt64(Page.Request.QueryString["PayId"].ToString());

/ Convert to Ms word and Excel in one click /

0 comments

protected void btntoword_Click(object sender, EventArgs e)
{
//Response.Clear();
//Response.Buffer = true;
Response.ContentType = "Application/vnd.ms-excel"; // for excel only this line
Response.ContentType = "application/msword";// for word only this line

//Response.ContentEncoding = System.Text.Encoding.Default;
//Response.AddHeader("Content- Disposition", "attachment;filename=Rpt.doc");
//EnableViewState = false;
//System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
//System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
//pnMyPanel.RenderControl(oHtmlTextWriter);
//Response.Write(oStringWriter.ToString());
//Response.Flush();
//Response.Close();

}

/ Eneble false a gridview image field ***/

0 comments

protected void gvBranch_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
AddSortDirectionImage(gvBranch, e.Row);
else
if (e.Row.RowType == DataControlRowType.DataRow)//.Footer)&&(e.Row.RowType != DataControlRowType.EmptyDataRow))
if (Session["UType"].ToString() != "SuperAdmin")
{

ibtnED = (ImageButton)e.Row.FindControl("ibtnEdit");
ibtnED.Enabled = false;

ibtnDel = (ImageButton)e.Row.FindControl("ibtnDelete");
ibtnDel.Enabled = false;
}
}

/* call calculator from .net */

0 comments

System.Diagnostics.Process.Start("calc");

/* Generate Random Numer with a certain range */

0 comments

Random RandomClass = new Random()
int RandomNumber = RandomClass.Next(4, 14);

/* String Format For datetime */

0 comments

String Format for DateTime [C#]

This example shows how to format DateTime using String.Format method. All formatting can be done also using DateTime.ToString method.
Custom DateTime Formatting

There are following custom format specifiers y (year), M (month), d (day), h (hour 12), H (hour 24), m (minute), s (second), f (second fraction), F (second fraction, trailing zeroes are trimmed), t (P.M or A.M) and z (time zone).

Following examples demonstrate how are the format specifiers rewritten to the output.
[C#]

// create date time 2008-03-09 16:05:07.123
DateTime dt = new DateTime(2008, 3, 9, 16, 5, 7, 123);

String.Format("{0:y yy yyy yyyy}", dt); // "8 08 008 2008" year
String.Format("{0:M MM MMM MMMM}", dt); // "3 03 Mar March" month
String.Format("{0:d dd ddd dddd}", dt); // "9 09 Sun Sunday" day
String.Format("{0:h hh H HH}", dt); // "4 04 16 16" hour 12/24
String.Format("{0:m mm}", dt); // "5 05" minute
String.Format("{0:s ss}", dt); // "7 07" second
String.Format("{0:f ff fff ffff}", dt); // "1 12 123 1230" sec.fraction
String.Format("{0:F FF FFF FFFF}", dt); // "1 12 123 123" without zeroes
String.Format("{0:t tt}", dt); // "P PM" A.M. or P.M.
String.Format("{0:z zz zzz}", dt); // "-6 -06 -06:00" time zone

You can use also date separator / (slash) and time sepatator : (colon). These characters will be rewritten to characters defined in the current DateTimeFormatInfo.DateSeparator and DateTimeFormatInfo.TimeSeparator.
[C#]

// date separator in german culture is "." (so "/" changes to ".")
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9/3/2008 16:05:07" - english (en-US)
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9.3.2008 16:05:07" - german (de-DE)

Here are some examples of custom date and time formatting:
[C#]

// month/day numbers without/with leading zeroes
String.Format("{0:M/d/yyyy}", dt); // "3/9/2008"
String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

// day/month names
String.Format("{0:ddd, MMM d, yyyy}", dt); // "Sun, Mar 9, 2008"
String.Format("{0:dddd, MMMM d, yyyy}", dt); // "Sunday, March 9, 2008"

// two/four digit year
String.Format("{0:MM/dd/yy}", dt); // "03/09/08"
String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

Standard DateTime Formatting

In DateTimeFormatInfo there are defined standard patterns for the current culture. For example property ShortTimePattern is string that contains value h:mm tt for en-US culture and value HH:mm for de-DE culture.

Following table shows patterns defined in DateTimeFormatInfo and their values for en-US culture. First column contains format specifiers for the String.Format method.
Specifier DateTimeFormatInfo property Pattern value (for en-US culture)
t ShortTimePattern h:mm tt
d ShortDatePattern M/d/yyyy
T LongTimePattern h:mm:ss tt
D LongDatePattern dddd, MMMM dd, yyyy
f (combination of D and t) dddd, MMMM dd, yyyy h:mm tt
F FullDateTimePattern dddd, MMMM dd, yyyy h:mm:ss tt
g (combination of d and t) M/d/yyyy h:mm tt
G (combination of d and T) M/d/yyyy h:mm:ss tt
m, M MonthDayPattern MMMM dd
y, Y YearMonthPattern MMMM, yyyy
r, R RFC1123Pattern ddd, dd MMM yyyy HH':'mm':'ss 'GMT' (*)
s SortableDateTimePattern yyyy'-'MM'-'dd'T'HH':'mm':'ss (*)
u UniversalSortableDateTimePattern yyyy'-'MM'-'dd HH':'mm':'ss'Z' (*)
(*) = culture independent

Following examples show usage of standard format specifiers in String.Format method and the resulting output.
[C#]

String.Format("{0:t}", dt); // "4:05 PM" ShortTime
String.Format("{0:d}", dt); // "3/9/2008" ShortDate
String.Format("{0:T}", dt); // "4:05:07 PM" LongTime
String.Format("{0:D}", dt); // "Sunday, March 09, 2008" LongDate
String.Format("{0:f}", dt); // "Sunday, March 09, 2008 4:05 PM" LongDate+ShortTime
String.Format("{0:F}", dt); // "Sunday, March 09, 2008 4:05:07 PM" FullDateTime
String.Format("{0:g}", dt); // "3/9/2008 4:05 PM" ShortDate+ShortTime
String.Format("{0:G}", dt); // "3/9/2008 4:05:07 PM" ShortDate+LongTime
String.Format("{0:m}", dt); // "March 09" MonthDay
String.Format("{0:y}", dt); // "March, 2008" YearMonth
String.Format("{0:r}", dt); // "Sun, 09 Mar 2008 16:05:07 GMT" RFC1123
String.Format("{0:s}", dt); // "2008-03-09T16:05:07" SortableDateTime
String.Format("{0:u}", dt); // "2008-03-09 16:05:07Z" UniversalSortableDateTime

/* String Format for Int */

0 comments

String Format for Int [C#]

Integer numbers can be formatted in .NET in many ways. You can use static method String.Format or instance method int.ToString. Following examples shows how to align numbers (with spaces or zeroes), how to format negative numbers or how to do custom formatting like phone numbers.
Add zeroes before number

To add zeroes before a number, use colon separator „:“ and write as many zeroes as you want.
[C#]

String.Format("{0:00000}", 15); // "00015"
String.Format("{0:00000}", -15); // "-00015"

Align number to the right or left

To align number to the right, use comma „,“ followed by a number of characters. This alignment option must be before the colon separator.
[C#]

String.Format("{0,5}", 15); // " 15"
String.Format("{0,-5}", 15); // "15 "
String.Format("{0,5:000}", 15); // " 015"
String.Format("{0,-5:000}", 15); // "015 "

Different formatting for negative numbers and zero

You can have special format for negative numbers and zero. Use semicolon separator „;“ to separate formatting to two or three sections. The second section is format for negative numbers, the third section is for zero.
[C#]

String.Format("{0:#;minus #}", 15); // "15"
String.Format("{0:#;minus #}", -15); // "minus 15"
String.Format("{0:#;minus #;zero}", 0); // "zero"

Custom number formatting (e.g. phone number)

Numbers can be formatted also to any custom format, e.g. like phone numbers or serial numbers.
[C#]

String.Format("{0:+### ### ### ###}", 447900123456); // "+447 900 123 456"
String.Format("{0:##-####-####}", 8958712551); // "89-5871-2551"

/* String Format for Double */

0 comments

String Format for Double [C#]

The following examples show how to format float numbers to string in C#. You can use static method String.Format or instance methods double.ToString and float.ToString.
Digits after decimal point

This example formats double to string with fixed number of decimal places. For two decimal places use pattern „0.00“. If a float number has less decimal places, the rest digits on the right will be zeroes. If it has more decimal places, the number will be rounded.
[C#]

// just two decimal places
String.Format("{0:0.00}", 123.4567); // "123.46"
String.Format("{0:0.00}", 123.4); // "123.40"
String.Format("{0:0.00}", 123.0); // "123.00"

Next example formats double to string with floating number of decimal places. E.g. for maximal two decimal places use pattern „0.##“.
[C#]

// max. two decimal places
String.Format("{0:0.##}", 123.4567); // "123.46"
String.Format("{0:0.##}", 123.4); // "123.4"
String.Format("{0:0.##}", 123.0); // "123"

Digits before decimal point

If you want a float number to have any minimal number of digits before decimal point use N-times zero before decimal point. E.g. pattern „00.0“ formats a float number to string with at least two digits before decimal point and one digit after that.
[C#]

// at least two digits before decimal point
String.Format("{0:00.0}", 123.4567); // "123.5"
String.Format("{0:00.0}", 23.4567); // "23.5"
String.Format("{0:00.0}", 3.4567); // "03.5"
String.Format("{0:00.0}", -3.4567); // "-03.5"

Thousands separator

To format double to string with use of thousands separator use zero and comma separator before an usual float formatting pattern, e.g. pattern „0,0.0“ formats the number to use thousands separators and to have one decimal place.
[C#]

String.Format("{0:0,0.0}", 12345.67); // "12,345.7"
String.Format("{0:0,0}", 12345.67); // "12,346"

Zero

Float numbers between zero and one can be formatted in two ways, with or without leading zero before decimal point. To format number without a leading zero use # before point. For example „#.0“ formats number to have one decimal place and zero to N digits before decimal point (e.g. „.5“ or „123.5“).

Following code shows how can be formatted a zero (of double type).
[C#]

String.Format("{0:0.0}", 0.0); // "0.0"
String.Format("{0:0.#}", 0.0); // "0"
String.Format("{0:#.0}", 0.0); // ".0"
String.Format("{0:#.#}", 0.0); // ""

Align numbers with spaces

To align float number to the right use comma „,“ option before the colon. Type comma followed by a number of spaces, e.g. „0,10:0.0“ (this can be used only in String.Format method, not in double.ToString method). To align numbers to the left use negative number of spaces.
[C#]

String.Format("{0,10:0.0}", 123.4567); // " 123.5"
String.Format("{0,-10:0.0}", 123.4567); // "123.5 "
String.Format("{0,10:0.0}", -123.4567); // " -123.5"
String.Format("{0,-10:0.0}", -123.4567); // "-123.5 "

Custom formatting for negative numbers and zero

If you need to use custom format for negative float numbers or zero, use semicolon separator „;“ to split pattern to three sections. The first section formats positive numbers, the second section formats negative numbers and the third section formats zero. If you omit the last section, zero will be formatted using the first section.
[C#]

String.Format("{0:0.00;minus 0.00;zero}", 123.4567); // "123.46"
String.Format("{0:0.00;minus 0.00;zero}", -123.4567); // "minus 123.46"
String.Format("{0:0.00;minus 0.00;zero}", 0.0); // "zero"

Some funny examples

As you could notice in the previous example, you can put any text into formatting pattern, e.g. before an usual pattern „my text 0.0“. You can even put any text between the zeroes, e.g. „0aaa.bbb0“.
[C#]

String.Format("{0:my number is 0.0}", 12.3); // "my number is 12.3"
String.Format("{0:0aaa.bbb0}", 12.3); // "12aaa.bbb3"

/* Sorting Arrays */

0 comments

Sorting Arrays [C#]

This example shows how to sort arrays in C#. Array can be sorted using static method Array.Sort which internally use Quicksort algorithm.
Sorting array of primitive types

To sort array of primitive types such as int, double or string use method Array.Sort(Array) with the array as a paramater. The primitive types implements interface IComparable, which is internally used by the Sort method (it calls IComparable.CompareTo method). See example how to sort int array:
[C#]

// sort int array
int[] intArray = new int[5] { 8, 10, 2, 6, 3 };
Array.Sort(intArray);
// write array
foreach (int i in intArray) Console.Write(i + " "); // output: 2 3 6 8 10

or how to sort string array:
[C#]

// sort string array
string[] stringArray = new string[5] { "X", "B", "Z", "Y", "A" };
Array.Sort(stringArray);
// write array
foreach (string str in stringArray) Console.Write(str + " "); // output: A B X Y Z

Sorting array of custom type using delegate

To sort your own types or to sort by more sophisticated rules, you can use delegate to anonymous method. The generic delegate Comparison is declared as public delegate int Comparison (T x, T y). It points to a method that compares two objects of the same type. It should return less then 0 when X < x =" Y"> Y. The method (to which the delegate points) can be also an anonymous method (written inline).

Following example demonstrates how to sort an array of custom type using the delegate to anonynous comparison method. The custom type in this case is a class User with properties Name and Age.
[C#]

// array of custom type
User[] users = new User[3] { new User("Betty", 23), // name, age
new User("Susan", 20),
new User("Lisa", 25) };

[C#]

// sort array by name
Array.Sort(users, delegate(User user1, User user2) {
return user1.Name.CompareTo(user2.Name);
});
// write array (output: Betty23 Lisa25 Susan20)
foreach (User user in users) Console.Write(user.Name + user.Age + " ");

[C#]

// sort array by age
Array.Sort(users, delegate(User user1, User user2) {
return user1.Age.CompareTo(user2.Age); // (user1.Age - user2.Age)
});
// write array (output: Susan20 Betty23 Lisa25)
foreach (User user in users) Console.Write(user.Name + user.Age + " ");

Sorting array using IComparable

If you implement IComparable interface in your custom type, you can sort array easily like in the case of primitive types. The Sort method calls internally IComparable.CompareTo method.
[C#]

// custom type
public class User : IComparable
{
// ...

// implement IComparable interface
public int CompareTo(object obj)
{
if (obj is User) {
return this.Name.CompareTo((obj as User).Name); // compare user names
}
throw new ArgumentException("Object is not a User");
}
}

Use it as you sorted the primitive types in the previous examples.
[C#]

// sort using IComparable implemented by User class
Array.Sort(users); // sort array of User objects

Take Sql Backup from code behind

0 comments

http://www.codeproject.com/KB/database/SQL_Server_2005_Database.aspx

Replace query in sqlserver

0 comments

DECLARE @TT TABLE (Phone varchar(15))
INSERT INTO @TT VALUES
('(100)-111-2222'),
('(101)111-2222'),
('111-111-2222'),
('(110)-100-2222'),
('(111)111-2222'),
('112-111-2222'),
('(121)111-2222')

-- QUERY
SELECT
REPLACE(
REPLACE(
REPLACE(
Phone,
'(', '' ),
')-', '-' ),
')', '-' ) as Phone
FROM @TT

/ Seperate with Comma in DB ******/

0 comments

select substring (( select ', ' + JRNo from JnMBJobSp where LedNo='JNMB3575' FOR XML path('')), 2,500) as JRNo

Imp Sqlquery /* SQL QUERY */

0 comments

create procedure udf_Weekdays(@Weekday int,@BeginDate datetime,@EndDate datetime)
as
begin

--@Weekday: 1 = Monday , ... ,7 = Sunday

select datediff(week,@BeginDate,@EndDate) + case when (@@datefirst + datepart(weekday,@BeginDate)) % 7 + case when (@@datefirst + datepart(weekday,@BeginDate)) % 7 = 0 then 7 else 0 end > @Weekday % 7 + 1 then 0 else 1 end - case when (@@datefirst + datepart(weekday,@EndDate)) % 7 + case when (@@datefirst + datepart(weekday,@EndDate)) % 7 = 0 then 7 else 0 end >= @Weekday % 7 + 1 then 0 else 1 end

end

Exec udf_Weekdays 7,'05/01/2010','05/31/2010'

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

Select DATENAME(DAY,DATEADD(DAY,-1,DATEADD(Month,1,'February 2012')))

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

select distinct AttendanceDate from dbo.AttendanceRegister where datename(dw,AttendanceDate) = 'Sunday' and month(AttendanceDate)='06'

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

dynamic gridview and table

0 comments

fhttp://www.codedigest.com/Articles/ASPNET/168_Create_Dynamic_GridView_Control_in_C_ASPNet.aspx

http://www.dotnetcurry.com/ShowArticle.aspx?ID=135&AspxAutoDetectCookieSupport=1

Last entered row in sqlserver

0 comments

Select * from table_name where id=IDENT_CURRENT('table_name')

MixedTrick

0 comments

http://www.dotnetspider.com/resources/Category528.aspx

http://viratsarswat.blogspot.com/2009/04/group-by-on-dataset-using-dataview.html?zx=9fee7d41e2a09e38
------------------------------------------------------

Validate Email Using Java Script
-----------------------------------

function validate()
{
//Validate Email.....

validRegExp = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/i;
strEmail = document.getElementById("txtEmail").value;
if (strEmail.search(validRegExp) == -1)
{
alert(" A valid E-mail is required");
document.getElementById("txtEmail").focus();
return false;
}
}
______________________________________________________________________

How to Validate Indian Phone Number
----------------------------------

Concepts Used:

1. Namespace: System.Text.RegularExpressions for pattern creation and matching.
2. KeyPress event of TextBox to check characters by KeyChar property.
3. Calling event handler of Check button from Textbox KeyPress event handler.

Code Snippet:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Text.RegularExpressions; //namespace to be used to match patterns

namespace dsn_PhoneNumberValidation
{
public partial class Form1 : Form
{
//Defining a regular expression and pattern
Regex phoneRegex = new Regex("^\\+[9][1][-][\\d]{10}$");

public Form1()
{
InitializeComponent();
}

private void btnCheck_Click(object sender, EventArgs e)
{
string strPhone = txtPhone.Text;

Match getMatch = phoneRegex.Match(strPhone);

if (getMatch.Success)
{
lblInfo.ForeColor = System.Drawing.Color.Blue;
lblInfo.Text = "MESSAGE: Absolutely correct phone number!";
}
else
{
lblInfo.ForeColor = System.Drawing.Color.Red;
lblInfo.Text = "MESSAGE: Wrong phone number.Phone number \nshould be 10 digit and format as +91-1234567890.";
}

}

private void txtPhone_KeyPress(object sender, KeyPressEventArgs e)
{
if (txtPhone.Text != String.Empty)
{
//KeyChar(45) for hypen key
//KeyChar(13) for Enter key
//KeyChar(8) for Backspace key
if ((e.KeyChar <> 57) && e.KeyChar != 8 && e.KeyChar != 45 && e.KeyChar!=13)
{
lblInfo.ForeColor = System.Drawing.Color.Red;
lblInfo.Text = "ONLY DIGITS ALLOWED. LETTERS NOT PERMITTED!";
}
else
{
lblInfo.Text=String.Empty;
}
}

//Calling btnCheck_Click event handler on Enter key pressed
if (e.KeyChar == 13)
{
btnCheck_Click(this, EventArgs.Empty);
}
}
}
}

Regular Expression Pattern Explained:

^\\+[9][1][-][\\d]{10}$

^ - Front anchor
\\+ - For checking + in begining of phone number
[9] - Next number should be 9 only
[1] - Next number should be 1 only
[\\d] - Later there should be digits only
{10} - Digits should be ten in numbers
$ - Ending anchor

___________________________________

Date Validation using Regular Expression
----------------------------------------

ControlToValidate="txtFrom" SetFocusOnError="true" ValidationExpression="^(((0?[1-9]|1[012])/(0?[1-9]|1\d|2[0-8])|(0?[13456789]|1[012])/(29|30)|(0?[13578]|1[02])/31)/(19|[2-9]\d)\d{2}|0?2/29/((19|[2-9]\d)(0[48]|[2468][048]|[13579][26])|(([2468][048]|[3579][26])00)))$"
Display="None">

_______________________________

/* Open Page in New Windowin C# */

OnClick="btnNewEntry_Click" OnClientClick="aspnetForm.target ='_blank';"/>

protected void btnNewEntry_Click(object sender, EventArgs e)
{
Response.Redirect("New.aspx");
}

___________________________________

/* Send Email */

http://www.aspsnippets.com/Articles/Send-SMTP-Emails-using-System.Net-Class-in-C.aspx
______________________________________________________

/* Generate Random Numer with a certain range */

Random RandomClass = new Random()
int RandomNumber = RandomClass.Next(4, 14);
________________________________________________________

/* String Format For time */

String Format for DateTime [C#]

This example shows how to format DateTime using String.Format method. All formatting can be done also using DateTime.ToString method.
Custom DateTime Formatting

There are following custom format specifiers y (year), M (month), d (day), h (hour 12), H (hour 24), m (minute), s (second), f (second fraction), F (second fraction, trailing zeroes are trimmed), t (P.M or A.M) and z (time zone).

Following examples demonstrate how are the format specifiers rewritten to the output.
[C#]

// create date time 2008-03-09 16:05:07.123
DateTime dt = new DateTime(2008, 3, 9, 16, 5, 7, 123);

String.Format("{0:y yy yyy yyyy}", dt); // "8 08 008 2008" year
String.Format("{0:M MM MMM MMMM}", dt); // "3 03 Mar March" month
String.Format("{0:d dd ddd dddd}", dt); // "9 09 Sun Sunday" day
String.Format("{0:h hh H HH}", dt); // "4 04 16 16" hour 12/24
String.Format("{0:m mm}", dt); // "5 05" minute
String.Format("{0:s ss}", dt); // "7 07" second
String.Format("{0:f ff fff ffff}", dt); // "1 12 123 1230" sec.fraction
String.Format("{0:F FF FFF FFFF}", dt); // "1 12 123 123" without zeroes
String.Format("{0:t tt}", dt); // "P PM" A.M. or P.M.
String.Format("{0:z zz zzz}", dt); // "-6 -06 -06:00" time zone

You can use also date separator / (slash) and time sepatator : (colon). These characters will be rewritten to characters defined in the current DateTimeFormatInfo.DateSeparator and DateTimeFormatInfo.TimeSeparator.
[C#]

// date separator in german culture is "." (so "/" changes to ".")
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9/3/2008 16:05:07" - english (en-US)
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9.3.2008 16:05:07" - german (de-DE)

Here are some examples of custom date and time formatting:
[C#]

// month/day numbers without/with leading zeroes
String.Format("{0:M/d/yyyy}", dt); // "3/9/2008"
String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

// day/month names
String.Format("{0:ddd, MMM d, yyyy}", dt); // "Sun, Mar 9, 2008"
String.Format("{0:dddd, MMMM d, yyyy}", dt); // "Sunday, March 9, 2008"

// two/four digit year
String.Format("{0:MM/dd/yy}", dt); // "03/09/08"
String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

Standard DateTime Formatting

In DateTimeFormatInfo there are defined standard patterns for the current culture. For example property ShortTimePattern is string that contains value h:mm tt for en-US culture and value HH:mm for de-DE culture.

Following table shows patterns defined in DateTimeFormatInfo and their values for en-US culture. First column contains format specifiers for the String.Format method.
Specifier DateTimeFormatInfo property Pattern value (for en-US culture)
t ShortTimePattern h:mm tt
d ShortDatePattern M/d/yyyy
T LongTimePattern h:mm:ss tt
D LongDatePattern dddd, MMMM dd, yyyy
f (combination of D and t) dddd, MMMM dd, yyyy h:mm tt
F FullDateTimePattern dddd, MMMM dd, yyyy h:mm:ss tt
g (combination of d and t) M/d/yyyy h:mm tt
G (combination of d and T) M/d/yyyy h:mm:ss tt
m, M MonthDayPattern MMMM dd
y, Y YearMonthPattern MMMM, yyyy
r, R RFC1123Pattern ddd, dd MMM yyyy HH':'mm':'ss 'GMT' (*)
s SortableDateTimePattern yyyy'-'MM'-'dd'T'HH':'mm':'ss (*)
u UniversalSortableDateTimePattern yyyy'-'MM'-'dd HH':'mm':'ss'Z' (*)
(*) = culture independent

Following examples show usage of standard format specifiers in String.Format method and the resulting output.
[C#]

String.Format("{0:t}", dt); // "4:05 PM" ShortTime
String.Format("{0:d}", dt); // "3/9/2008" ShortDate
String.Format("{0:T}", dt); // "4:05:07 PM" LongTime
String.Format("{0:D}", dt); // "Sunday, March 09, 2008" LongDate
String.Format("{0:f}", dt); // "Sunday, March 09, 2008 4:05 PM" LongDate+ShortTime
String.Format("{0:F}", dt); // "Sunday, March 09, 2008 4:05:07 PM" FullDateTime
String.Format("{0:g}", dt); // "3/9/2008 4:05 PM" ShortDate+ShortTime
String.Format("{0:G}", dt); // "3/9/2008 4:05:07 PM" ShortDate+LongTime
String.Format("{0:m}", dt); // "March 09" MonthDay
String.Format("{0:y}", dt); // "March, 2008" YearMonth
String.Format("{0:r}", dt); // "Sun, 09 Mar 2008 16:05:07 GMT" RFC1123
String.Format("{0:s}", dt); // "2008-03-09T16:05:07" SortableDateTime
String.Format("{0:u}", dt); // "2008-03-09 16:05:07Z" UniversalSortableDateTime

_______________________________________________________________________________

/* String Format for Int */

String Format for Int [C#]

Integer numbers can be formatted in .NET in many ways. You can use static method String.Format or instance method int.ToString. Following examples shows how to align numbers (with spaces or zeroes), how to format negative numbers or how to do custom formatting like phone numbers.
Add zeroes before number

To add zeroes before a number, use colon separator „:“ and write as many zeroes as you want.
[C#]

String.Format("{0:00000}", 15); // "00015"
String.Format("{0:00000}", -15); // "-00015"

Align number to the right or left

To align number to the right, use comma „,“ followed by a number of characters. This alignment option must be before the colon separator.
[C#]

String.Format("{0,5}", 15); // " 15"
String.Format("{0,-5}", 15); // "15 "
String.Format("{0,5:000}", 15); // " 015"
String.Format("{0,-5:000}", 15); // "015 "

Different formatting for negative numbers and zero

You can have special format for negative numbers and zero. Use semicolon separator „;“ to separate formatting to two or three sections. The second section is format for negative numbers, the third section is for zero.
[C#]

String.Format("{0:#;minus #}", 15); // "15"
String.Format("{0:#;minus #}", -15); // "minus 15"
String.Format("{0:#;minus #;zero}", 0); // "zero"

Custom number formatting (e.g. phone number)

Numbers can be formatted also to any custom format, e.g. like phone numbers or serial numbers.
[C#]

String.Format("{0:+### ### ### ###}", 447900123456); // "+447 900 123 456"
String.Format("{0:##-####-####}", 8958712551); // "89-5871-2551"

_______________________________________________________________
/* String Format for Double */

String Format for Double [C#]

The following examples show how to format float numbers to string in C#. You can use static method String.Format or instance methods double.ToString and float.ToString.
Digits after decimal point

This example formats double to string with fixed number of decimal places. For two decimal places use pattern „0.00“. If a float number has less decimal places, the rest digits on the right will be zeroes. If it has more decimal places, the number will be rounded.
[C#]

// just two decimal places
String.Format("{0:0.00}", 123.4567); // "123.46"
String.Format("{0:0.00}", 123.4); // "123.40"
String.Format("{0:0.00}", 123.0); // "123.00"

Next example formats double to string with floating number of decimal places. E.g. for maximal two decimal places use pattern „0.##“.
[C#]

// max. two decimal places
String.Format("{0:0.##}", 123.4567); // "123.46"
String.Format("{0:0.##}", 123.4); // "123.4"
String.Format("{0:0.##}", 123.0); // "123"

Digits before decimal point

If you want a float number to have any minimal number of digits before decimal point use N-times zero before decimal point. E.g. pattern „00.0“ formats a float number to string with at least two digits before decimal point and one digit after that.
[C#]

// at least two digits before decimal point
String.Format("{0:00.0}", 123.4567); // "123.5"
String.Format("{0:00.0}", 23.4567); // "23.5"
String.Format("{0:00.0}", 3.4567); // "03.5"
String.Format("{0:00.0}", -3.4567); // "-03.5"

Thousands separator

To format double to string with use of thousands separator use zero and comma separator before an usual float formatting pattern, e.g. pattern „0,0.0“ formats the number to use thousands separators and to have one decimal place.
[C#]

String.Format("{0:0,0.0}", 12345.67); // "12,345.7"
String.Format("{0:0,0}", 12345.67); // "12,346"

Zero

Float numbers between zero and one can be formatted in two ways, with or without leading zero before decimal point. To format number without a leading zero use # before point. For example „#.0“ formats number to have one decimal place and zero to N digits before decimal point (e.g. „.5“ or „123.5“).

Following code shows how can be formatted a zero (of double type).
[C#]

String.Format("{0:0.0}", 0.0); // "0.0"
String.Format("{0:0.#}", 0.0); // "0"
String.Format("{0:#.0}", 0.0); // ".0"
String.Format("{0:#.#}", 0.0); // ""

Align numbers with spaces

To align float number to the right use comma „,“ option before the colon. Type comma followed by a number of spaces, e.g. „0,10:0.0“ (this can be used only in String.Format method, not in double.ToString method). To align numbers to the left use negative number of spaces.
[C#]

String.Format("{0,10:0.0}", 123.4567); // " 123.5"
String.Format("{0,-10:0.0}", 123.4567); // "123.5 "
String.Format("{0,10:0.0}", -123.4567); // " -123.5"
String.Format("{0,-10:0.0}", -123.4567); // "-123.5 "

Custom formatting for negative numbers and zero

If you need to use custom format for negative float numbers or zero, use semicolon separator „;“ to split pattern to three sections. The first section formats positive numbers, the second section formats negative numbers and the third section formats zero. If you omit the last section, zero will be formatted using the first section.
[C#]

String.Format("{0:0.00;minus 0.00;zero}", 123.4567); // "123.46"
String.Format("{0:0.00;minus 0.00;zero}", -123.4567); // "minus 123.46"
String.Format("{0:0.00;minus 0.00;zero}", 0.0); // "zero"

Some funny examples

As you could notice in the previous example, you can put any text into formatting pattern, e.g. before an usual pattern „my text 0.0“. You can even put any text between the zeroes, e.g. „0aaa.bbb0“.
[C#]

String.Format("{0:my number is 0.0}", 12.3); // "my number is 12.3"
String.Format("{0:0aaa.bbb0}", 12.3); // "12aaa.bbb3"

_________________________________________________________________

/* Indent String with Spaces */

Indent String with Spaces [C#]

This example shows how to indent strings using method for padding in C#. To repeat spaces use method String.PadLeft. If you call „hello“.PadLeft(10) you will get the string aligned to the right: „ hello“. If you use empty string instead of the „hello“ string the result will be 10× repeated space character. This can be used to create simple Indent method.

The Indent method:
[C#]

public static string Indent(int count)
{
return "".PadLeft(count);
}

Test code:
[C#]

Console.WriteLine(Indent(0) + "List");
Console.WriteLine(Indent(3) + "Item 1");
Console.WriteLine(Indent(6) + "Item 1.1");
Console.WriteLine(Indent(6) + "Item 1.2");
Console.WriteLine(Indent(3) + "Item 2");
Console.WriteLine(Indent(6) + "Item 2.1");

Output string:

List
Item 1
Item 1.1
Item 1.2
Item 2
Item 2.1

__________________________________________________________________

/* Sorting Arrays */

Sorting Arrays [C#]

This example shows how to sort arrays in C#. Array can be sorted using static method Array.Sort which internally use Quicksort algorithm.
Sorting array of primitive types

To sort array of primitive types such as int, double or string use method Array.Sort(Array) with the array as a paramater. The primitive types implements interface IComparable, which is internally used by the Sort method (it calls IComparable.CompareTo method). See example how to sort int array:
[C#]

// sort int array
int[] intArray = new int[5] { 8, 10, 2, 6, 3 };
Array.Sort(intArray);
// write array
foreach (int i in intArray) Console.Write(i + " "); // output: 2 3 6 8 10

or how to sort string array:
[C#]

// sort string array
string[] stringArray = new string[5] { "X", "B", "Z", "Y", "A" };
Array.Sort(stringArray);
// write array
foreach (string str in stringArray) Console.Write(str + " "); // output: A B X Y Z

Sorting array of custom type using delegate

To sort your own types or to sort by more sophisticated rules, you can use delegate to anonymous method. The generic delegate Comparison is declared as public delegate int Comparison (T x, T y). It points to a method that compares two objects of the same type. It should return less then 0 when X < x =" Y"> Y. The method (to which the delegate points) can be also an anonymous method (written inline).

Following example demonstrates how to sort an array of custom type using the delegate to anonynous comparison method. The custom type in this case is a class User with properties Name and Age.
[C#]

// array of custom type
User[] users = new User[3] { new User("Betty", 23), // name, age
new User("Susan", 20),
new User("Lisa", 25) };

[C#]

// sort array by name
Array.Sort(users, delegate(User user1, User user2) {
return user1.Name.CompareTo(user2.Name);
});
// write array (output: Betty23 Lisa25 Susan20)
foreach (User user in users) Console.Write(user.Name + user.Age + " ");

[C#]

// sort array by age
Array.Sort(users, delegate(User user1, User user2) {
return user1.Age.CompareTo(user2.Age); // (user1.Age - user2.Age)
});
// write array (output: Susan20 Betty23 Lisa25)
foreach (User user in users) Console.Write(user.Name + user.Age + " ");

Sorting array using IComparable

If you implement IComparable interface in your custom type, you can sort array easily like in the case of primitive types. The Sort method calls internally IComparable.CompareTo method.
[C#]

// custom type
public class User : IComparable
{
// ...

// implement IComparable interface
public int CompareTo(object obj)
{
if (obj is User) {
return this.Name.CompareTo((obj as User).Name); // compare user names
}
throw new ArgumentException("Object is not a User");
}
}

Use it as you sorted the primitive types in the previous examples.
[C#]

// sort using IComparable implemented by User class
Array.Sort(users); // sort array of User objects

___________________________________________________________

/* youtube downloader */

http://keepvid.com/
_______________________________

/* Download from Web */

This example shows how to download files from any website to local disk. The simply way how to download file is to use WebClient class and its method DownloadFile. This method has two parameters, first is the url of the file you want to download and the second parameter is path to local disk to which you want to save the file.
Download File Synchronously

The following code shows how to download file synchronously. This method blocks the main thread until the file is downloaded or an error occur (in this case the WebException is thrown).
[C#]

using System.Net;

WebClient webClient = new WebClient();
webClient.DownloadFile("http://mysite.com/myfile.txt", @"c:\myfile.txt");

Download File Asynchronously

To download file without blocking the main thread use asynchronous method DownloadFileAsync. You can also set event handlers to show progress and to detect that the file is downloaded.
[C#]

private void btnDownload_Click(object sender, EventArgs e)
{
WebClient webClient = new WebClient();
webClient.DownloadFileCompleted += new AsyncCompletedEventHandler(Completed);
webClient.DownloadProgressChanged += new DownloadProgressChangedEventHandler(ProgressChanged);
webClient.DownloadFileAsync(new Uri("http://mysite.com/myfile.txt"), @"c:\myfile.txt");
}

private void ProgressChanged(object sender, DownloadProgressChangedEventArgs e)
{
progressBar.Value = e.ProgressPercentage;
}

private void Completed(object sender, AsyncCompletedEventArgs e)
{
MessageBox.Show("Download completed!");
}

________________________________________________________

/* Distinct in Datatable */

DataTable distinctTable = originalTable.DefaultView.ToTable( /*distinct*/ true);

__________________________________

/* Take Sql Backup from code behind */

http://www.codeproject.com/KB/database/SQL_Server_2005_Database.aspx

__________________________________

/* Webservice Calling */

http://www.codeguru.com/csharp/csharp/cs_webservices/tutorials/article.php/c5477

http://www.west-wind.com/presentations/dotnetwebservices/DotNetWebServices.asp

________________________________

/* Group by in data table */

http://viratsarswat.blogspot.com/2009/04/group-by-on-dataset-using-dataview.html?zx=9fee7d41e2a09e38

http://arstechnica.com/civis/viewtopic.php?f=20&t=250424
___________________________________________________

/* Search a domain name */

in google : who is lookup

_____________________________________

/* Datatable Datarow */

DataTable dtDest = new DataTable();
dtDest = dsActivity.Tables[0].Clone();
foreach(DataRow dr in dsSrc.Tables[0].Rows)
{
DataRow newRow = dtDest .NewRow();
newRow.ItemArray = dr.ItemArray;
dtDest.Rows.Add(newRow);
}

________________________________

DataTable dt1 = ds.Tables[0];

DataTable dt2 = new DataTable();

dt2 = dt1.Clone();

foreach(DataRow row in dt1.Rows){

if(row["Column1"] == 10){

// Import the Row into dt2 from dt1
dt2.ImportRow(row);

}

}

________________________________________

http://mcablindia.com/

/********* Chart using asp.net ********/

http://www.codeproject.com/KB/aspnet/Creating3DBarChart.aspx
http://www.asp101.com/articles/jayram/exceldotnet/default.asp
http://wiki.asp.net/page.aspx/685/export-image-to-excel-using-c/
http://www.spreadsheetgear.com/support/samples/charting.aspx

VVI

http://www.411asp.net/home/tutorial/howto/graphics/charts
http://www.codeproject.com/KB/aspnet/Creating3DBarChart.aspx
____________________________________________________________________

http://www.adrive.com/home/downloadfile/314788597

____________________________________________________________

Target Blank

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

Performance Report

___________________________________________________________________________________________--

/********** validation false with a particular button ********/

causevalidation=false //in button

___________________________________________________________________________

/* Calender */

ValidationExpression="((31(?!\ (Feb(ruary)?|Apr(il)?|June?|(Sep(?=\b|t)t?|Nov)(ember)?)))|((30|29)(?!\ Feb(ruary)?))|(29(?=\ Feb(ruary)?\ (((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00)))))|(0?[1-9])|1\d|2[0-8])\ (Jan(uary)?|Feb(ruary)?|Ma(r(ch)?|y)|Apr(il)?|Ju((ly?)|(ne?))|Aug(ust)?|Oct(ober)?|(Sep(?=\b|t)t?|Nov|Dec)(ember)?)\ ((1[6-9]|[2-9]\d)\d{2})"
SetFocusOnError="True" Display="None" ControlToValidate="txtDateFrom">

TargetControlID="regvDateFrom">

________________________________________________________________________________

/* List Search Extender */

AutoPostBack="True" TabIndex="3">

___________________________________________________________________________________________

/* Data table */

http://msdn.microsoft.com/en-us/library/y06xa2h1(VS.80).aspx

______________________________________________________________________________

/* Erp Reports Sale Purchase Based */

http://software.informer.com/getfree-excel-stock-report-format/
http://www.eresourceerp.com/eresourceerpweb/UI/ProductsByCategory.aspx?Category=9
http://www.exinfm.com/free_spreadsheets.html

__________________________________________________

Payroll excel (.xls)
----------------

http://www.citehr.com/128383-complete-payroll-administration.html

________________________________________________________________________

/* Web Service Video */

http://www.asp.net/learn/videos/video-280.aspx

http://download.microsoft.com/download/3/3/d/33d335e7-6a4f-4d6e-91f7-1ccf13dc331a/WinVideo-ASP-SimpleWebService.wmv

_____________________________________________________________________

SELECT distinct TOP (100) PERCENT L1, L1Pos, L2, L2Pos, L3, L3Pos, L4, AcctId, ValueDr, ValueCr, CASE WHEN (ValueDr - ValueCr) > 0 THEN (ValueDr - ValueCr)
ELSE 0 END AS NetValueDr, CASE WHEN (ValueDr - ValueCr) < 0 THEN (ValueDr - ValueCr) * - 1 ELSE 0 END AS NetValueCr
FROM (SELECT TOP (100) PERCENT 'Sundry Creditors' AS L1, 2 AS L1Pos, 'Sundry Creditors' AS L2, 1 AS L2Pos, 'Sundry Creditors' AS L3, 1 AS L3Pos,
dbo.AcctMaster.AcctAlias AS L4, dbo.AcctMaster.AcctId, CASE WHEN
(SELECT SUM(LedAmount) AS Expr1
FROM dbo.Ledger AS Ledger_1
WHERE (LedDrCr = 'true') AND (AcctId = dbo.AcctMaster.AcctId) AND cast(dbo.Ledger.LedDate as datetime) >= convert(varchar,'1/4/2010',103)) IS NULL THEN 0 ELSE
(SELECT SUM(LedAmount) AS Expr1
FROM dbo.Ledger AS Ledger_1
WHERE (LedDrCr = 'true') AND (AcctId = dbo.AcctMaster.AcctId) AND cast(dbo.Ledger.LedDate as datetime) >= convert(varchar,'1/4/2010',103)) END AS ValueDr,
CASE WHEN
(SELECT SUM(LedAmount) AS Expr1
FROM dbo.Ledger AS Ledger_1
WHERE (LedDrCr = 'false') AND (AcctId = dbo.AcctMaster.AcctId) AND cast(dbo.Ledger.LedDate as datetime) >= convert(varchar,'1/4/2010',103)) IS NULL THEN 0 ELSE
(SELECT SUM(LedAmount) AS Expr1
FROM dbo.Ledger AS Ledger_1
WHERE (LedDrCr = 'false') AND (AcctId = dbo.AcctMaster.AcctId) AND cast(dbo.Ledger.LedDate as datetime) >= convert(varchar,'1/4/2010',103)) END AS ValueCr
FROM dbo.Ledger INNER JOIN
dbo.AcctMaster ON dbo.Ledger.AcctId = dbo.AcctMaster.AcctId
WHERE (dbo.AcctMaster.AcctType = 'SC') AND (dbo.AcctMaster.AcctGroup = 2) AND (cast(dbo.Ledger.LedDate as datetime) BETWEEN convert(varchar,'1/4/2010',103) AND convert(varchar,'1/4/2010',103))
GROUP BY dbo.AcctMaster.AcctAlias, dbo.AcctMaster.AcctId, dbo.Ledger.LedDate) AS QSC

_________________________________________________________________________

/* Group sum in datatable*/

public static DataTable GroupBy(DataTable table, string[] aggregate_columns, string[] aggregate_functions, Type[] column_types, string[] group_by_columns)
{
DataView view = new DataView(table);
DataTable grouped = view.ToTable(true, group_by_columns);
for (int i = 0 ; i < aggregate_columns.Length ; i++)
{
grouped.Columns.Add(aggregate_columns[i], column_types[i]);
}
foreach (DataRow row in grouped.Rows)
{
List filter_parts = new List &l;string> ();
for (int i = 0; i < group_by_columns.Length; i++)
{
filter_parts.Add(string.Format("[{0}] = '{1}'", group_by_columns[i], row[group_by_columns[i]].ToString().Replace("'", "''")));
}
string filter = string.Join(" AND ", filter_parts.ToArray());
for (int i = 0; i < aggregate_columns.Length; i++)
{
row[aggregate_columns[i]] = table.Compute(aggregate_functions[i], filter);
}
}
return grouped;
}

And you should use something like

string[] column_names = new string[] { "number", "avg_price", "total" };
string[] column_functions = new string[] { "count(products)", "avg(price)", "sum(charge)" };
Type[] column_types = new Type[] { typeof(int), typeof(decimal), typeof(decimal) };
string[] group_by = new string[] { "order_id" };
DataTable grouped = GroupBy(data, column_names, column_functions, column_types, group_by);

Which will be the equivilant of the SQL command:

select order_id, count(products) as number, avg(price) as avg_price, sum(charge) as total from data group by order_id
it may need some extra handling to account for DBNull values in the columns that you are grouping by.

_________________________________________________________-

/* Sql injection */

username: any
password: hi' or 1=1--

___________________________________

/* Last Entered Row in sqlserver */

Select * from table_name where id=IDENT_CURRENT('table_name')

Smart Coder

Sunday, November 28, 2010

Bulk Inser in Sql from CSV

Thursday, November 25, 2010

Important Link

Monday, September 20, 2010

Important All Code

File Upload

Grid Check box

Grid View Check box with link button click

Session Check

Catching Html textbox value

Code Behind Binding of Dropdown

Calculation of date Of birth

Red Green Button in gridview (true, False)

Row as column

/* catching btn argument value */

/* Generating Random number using system function */

/* Textbox to dorpdownlist*/

Data base CASE

Query string

/ Convert to Ms word and Excel in one click /

/ Eneble false a gridview image field ***/

/* call calculator from .net */

/* Generate Random Numer with a certain range */

/* String Format For datetime */

/* String Format for Int */

/* String Format for Double */

/* Sorting Arrays */

Take Sql Backup from code behind

Replace query in sqlserver

/ Seperate with Comma in DB ******/

Imp Sqlquery /* SQL QUERY */

dynamic gridview and table

Last entered row in sqlserver

MixedTrick

Total Pageviews

Blog Archive