Friday, September 11, 2009

Tutorial using MySQL with Asp.Net

· 0 comments

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.

Read More......

Wednesday, September 9, 2009

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

· 0 comments

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


Read More......

Tuesday, September 1, 2009

Inserting Data Into Table Using Select Query

· 0 comments

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..



Read More......