å建DBHelperç±»ï¼class DBHelper
{
private static String conString = "Data Source=æå¡å¨å;Initial Catalog=æ°æ®åºå;User ID=ç¨æ·å;Password=å¯ç ";
public static SqlConnection connection = new SqlConnection(conString);
}ç¼è¾ç¡®å®æé®çClickäºä»¶ï¼String sql = String.Format("insert into 表å(å段, å段) values("{0}", "{1}")", ç¨æ·åæ§ä»¶.text, å¯ç æ§ä»¶.text);int result = 0;
try
{
DBHelper.connection.Open();
SqlCommand cmd = new SqlCommand(sql, DBHelper.connection);
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper.connection.Close();
}if (result > 0)
{
MessageBox.Show("æ·»å æåï¼", "æ示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("æ·»å 失败ï¼", "æ示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}æä½æ°æ®åºè¦å using System.Data.SqlClient;åç»æ§ä»¶å 个é空éªè¯å°±OKäº
温馨提示:内容为网友见解,仅供参考