NipeBon

Databse Function:: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data.SqlClient; using System.Configuration; using System.Data; using System.Diagnostics; namespace iterna {     public static class Utils     {         public static void Log(string text)         {             System.Diagnostics.Debug.WriteLine(" " + text);         }     }     public class DbCon     {         private SqlConnection con = null;         private string sqlConnStr = "";         private ConnectionState connectionState = ConnectionState.Closed;         ///         ///          ///         public DbCon()         {     ...

string [] format = new string []{ "yyyy-MM-dd HH:mm:ss" }; string value = "2011-09-02 15:30:20" ; DateTime datetime ; if ( DateTime . TryParseExact ( value , format , System . Globalization . CultureInfo . InvariantCulture , System . Globalization . DateTimeStyles . NoCurrentDateDefault , out datetime )) Console . WriteLine ( "Valid : " + datetime ); else Console . WriteLine ( "Invalid" );

 var dt = DateTime.Parse("2010-11-25");  string output = dt.ToString(@"yyyy-MMM", System.Globalization.CultureInfo.InvariantCulture);  content =  output ;

the use of hyperlink instead of button is easier to export Excel from the back-end. because in button need the ajax request. and it is cumbersome to produce file with Ajax request.  

        public DataTable createData() {             DataTable dt = new DataTable();             DataRow dr;             dt.Columns.Add("ID", typeof(string));             dt.Columns.Add("First Name", typeof(string));             dt.Columns.Add("Last Name", typeof(string));             for (int i = 0; i < 30; i++)             {                 dr = dt.NewRow();                 dr[0] = "id_" + i.ToString();    ...

 OnSubmitData="Store1_Submit"         var submitValue = function (grid, hiddenFormat, format, hiddenFormat1, format1 ) {             hiddenFormat.setValue(format);             grid.submitData(false, { isUpload: true });         };                             string format = this.FormatType.Value.ToString();

        public void button_click_Excel(object sender, EventArgs e) {             Response.Clear();             Response.ClearHeaders();             Response.ClearContent();             Response.ContentType = "application/force-download";             Response.AddHeader("content-disposition", "attachment; filename=Print.xls");             Response.Write(" ");             Response.Write(" ");             Response.Write("");             Response.Write(" ");             Response.Write(this.htmlData());             Response.Write(" ");            Response.Flush();         } ...