SQL:
\n[code=sql]
\nselect * from test
\nupdate test set a=’b’ where a=’a’
\ndelete from test;
\n[\/code]
\nC#:
\n[code=c#]
\n protected void Page_Load(object sender, EventArgs e)
\n {
\n \/\/ Connect to the Database
\n MySqlConnection myConnection = new MySqlConnection(ConfigurationSettings.AppSettings[“SQLConnectionString”]);
\n string SQL_QUERY = “SELECT * FROM table”;
\n MySqlCommand myCommand = new MySqlCommand(SQL_QUERY, myConnection);
\n myConnection.Open();
\n rptRSS.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
\n rptRSS.DataBind();
\n myConnection.Close();
\n }
\n[\/code]
\nHTML:
\n[code=html]
\n