Sunday, January 17, 2010

MYSQL & C# 2

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace Mysql2
{
class Program
{
static void Main(string[] args)
{
MySqlConnection con = new MySqlConnection("datasource=localhost;username=root;password=indusstar;database=mysql");
con.Open();

MySqlDataAdapter da = new MySqlDataAdapter("select * from courses", con);
//need table with primary key
MySqlCommandBuilder cmdBuilder = new MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "courses");

DataRow drow = ds.Tables[0].Rows[3];

//updating

drow[0] = 4;
drow[1] = "Gambas.Net";
drow[2] = 5;
drow[3] = 8000;

da.Update(ds, "courses");

con.Close();

}
}
}

No comments:

Post a Comment