ggoon's Code Collection

public partial class Form1 : Form     {         string strConn = "server=.\\SQLEXPRESS;database=example;uid=sa;pwd=12345";         SqlConnection Conn;         SqlDataAdapter dataAdapter;         DataSet dataSet;         SqlCommandBuilder cmdBuilder;         public Form1()         {             InitializeComponent();         }              private void Form1_Load(object sender, EventArgs e)         {             Conn = new SqlConnection(strConn);             dataAdapter = new SqlDataAdapter("SELECT * FROM tblEx01", Conn);                        dataSet = new DataSet();         ...

public partial class Form1 : Form     {         string strConn = "server=.\\SQLEXPRESS;database=example;uid=sa;pwd=12345";         SqlConnection Conn;         SqlDataAdapter dataAdapter;         DataSet dataSet;         public Form1()         {             InitializeComponent();         }         private void SqlCommandInit()         {             string strSelectSQL = "SELECT * FROM tblEx01";             dataAdapter.SelectCommand = new SqlCommand(strSelectSQL, Conn);                      string strInsertCommand = "INSERT INTO tblEx01 (name, age) VALUES (@name, @age)";             dataAdapter.InsertCommand = ne...