é¦å
ï¼æ们å¨ç¨åºä¸å¨æå°å建SQL Serveræ°æ®åºã
æ们å°æ°æ®åºå建å¨C:\mysqlç®å½ä¸ï¼æ以读è
è¦ç»ä¹ 该å®ä¾çè¯å¾å
å¨C:ä¸å建ä¸ä¸ªå为mysqlçæ件夹ï¼å¦åä¼åºéï¼å建æ°æ®åºçå
³é®æ¯å½æ°ä¸çsql对象ï¼éè¿è¯¥å¯¹è±¡æ们æå®äºæ°æ®åºæ件çä¸äºåºæ¬å±æ§ãä¹åï¼æ们æ°å建äºä¸ä¸ªSqlCommand对象ï¼éè¿è¯¥å¯¹è±¡æ们 å°±å®é
å®æäºå¯¹æ°æ®åºçæä½ãå½æ°çå®ç°å¦ä¸ï¼
private void button1_Click(object sender, System.EventArgs e)
{
// æå¼æ°æ®åºè¿æ¥
if( conn.State != ConnectionState.Open)
conn.Open();
string sql = "CREATE DATABASE mydb ON PRIMARY"
+"(name=test_data, filename = 'C:\\mysql\\mydb_data.mdf', size=3,"
+"maxsize=5, filegrowth=10%) log on"
+"(name=mydbb_log, filename='C:\\mysql\\mydb_log.ldf',size=3,"
+"maxsize=20,filegrowth=1)";
cmd = new SqlCommand(sql, conn);
try { cmd.ExecuteNonQuery(); }
catch(SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
}
å
¶æ¬¡ï¼æ们éè¿CREATE TABLEè¯å¥å建åºæ¬è¡¨ï¼å¹¶å该表ä¸æ·»å 4æ¡æ°æ®ãå½æ°çå®ç°å¦ä¸ï¼
private void button2_Click(object sender, System.EventArgs e)
{
// æå¼æ°æ®åºè¿æ¥
if( conn.State == ConnectionState.Open)
conn.Close();
ConnectionString ="Integrated Security=SSPI;" + "Initial Catalog=mydb;" + "Data Source=localhost;";
conn.ConnectionString = ConnectionString;
conn.Open();
sql = "CREATE TABLE myTable"+ "(myId INTEGER CONSTRAINT PKeyMyId PRIMARY KEY,"
+ "myName CHAR(50), myAddress CHAR(255), myBalance FLOAT)";
cmd = new SqlCommand(sql, conn);
try {
cmd.ExecuteNonQuery(); // å表ä¸æ·»å è®°å½
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+ "VALUES (1001, 'Puneet Nehra', 'A 449 Sect 19, DELHI', 23.98 ) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName,myAddress, myBalance) "+ "VALUES (1002, 'Anoop Singh', 'Lodi Road, DELHI', 353.64) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+ "VALUES (1003, 'Rakesh M', 'Nag Chowk, Jabalpur M.P.', 43.43) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+ "VALUES (1004, 'Madan Kesh', '4th Street, Lane 3, DELHI', 23.00) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery(); }
catch(SqlException ae) { MessageBox.Show(ae.Message.ToString()); }
}
å®ææ¤æä½åï¼æ们å¯ä»¥æå¼SQL SERVERçä¼ä¸ç®¡çå¨ï¼æ¥çæ¯å¦ææ们å建çæ°æ®åºååºæ¬è¡¨ã
温馨提示:答案为网友推荐,仅供参考