Archive

Archive for September, 2009

Tutorial using MySQL with Asp.Net

September 10, 2009 Leave a comment

If you want to use MySQL Database with Asp.net, then here is a link which explains:

http://www.15seconds.com/issue/050407.htm

  • Download of MySQL Server
  • MySQL Administrator
  • MySQL Query Browser
  • .Net Connector (For Asp.net Integration)

The above link has explained in detail, with proper screenshots, from where to download installers, how to install with step by step screens and explanations, and also how to create sample asp.net application with MySQL database, create MySQL database (schema), create MySQL Table, Insert Data, and populate that data in asp.net gridview.

Advertisements

Using String.Format(“{0}”, “formatting string”}; in Asp.net

September 9, 2009 Leave a comment

Many times we want to define formats for date, currency, number etc

For example if we want date in

” 09 September 2009″  – String.Format{0:D}

” 09 September 2009 12:30″  – String.Format{0:f}

Like this various formats for date, month, year, time, currency number etc can be seen at :

http://bit.ly/cctp

Inserting Data Into Table Using Select Query

September 1, 2009 Leave a comment

In SQL, sometimes we need to select some data from one table and insert data into another table, this can be done as follows with a simple sql query:

Insert into Table1 (c1, c2, c3, c4, c5)
(Select c1, c2, c3, c4, c5 from Table2)

But make sure that both the tables have same fields, data type..