WLC_Programming Knowledge

3 Responses so far.

1. 

   Unknown , 14 August 2014 at 03:41

   insert လေးပါ လုပ်ချ်ငသည်..လက်နဲ. manul မဖြည့်ပဲ program က နေလုပ်တာ အဆင်မပြေဘူးဗျို...ဆက်ရေးပေးပါ အစ်ကိုရေ
   private void btnSave_Click(object sender, EventArgs e)
   {
   
   OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\EnToMM.accdb");
   con.Open();
   string Eng = txtEng.Text;
   string Type = txtType.Text;
   string Mya = txtMya.Text;
   
   
   OleDbCommand cmd = new OleDbCommand();
   
   cmd.Connection = con;
   
   cmd.CommandText = "INSERT INTO tblData([English],[Type],[Myanmar]) VALUES (@English,@Type,@Myanmar)";
   
   cmd.Parameters.AddWithValue("@English", Eng);
   cmd.Parameters.AddWithValue("@Type", Type);
   cmd.Parameters.AddWithValue("@Myanmar", Mya);
   
   
   int result = cmd.ExecuteNonQuery();
   con.Close();
   if (result > 0)
   {
   MessageBox.Show("Inserted Successfully");
   }
   }

   
2. 

   ေတဇာလင္း , 17 August 2014 at 06:24

   This comment has been removed by the author.
3. 

   ေတဇာလင္း , 17 August 2014 at 06:28

   ေအာက္က Command Line ေလးအတိုင္း ေရးၾကည့္လုိက္ပါဗ်ာ။ က်ေနာ္ SQL Query ႏွစ္ခုန႔ဲ ရွင္းထားပါတရ္။ ပထမ တစ္ခုကေတာ့ English Word ကို Primary Key သေဘာထားၿပီး က်ေနာ္တို႔ Insert လုပ္တဲ့ Data ဟာ Database ထဲမွာ ရွိ/မရွိဆိုတာကို စစ္ထားတာပါ။ ရွိခဲ့ရင္ေတာ့ ထပ္ၿပီး insert လုပ္ခြင့္မေပးပဲ Already Exist ဆိုၿပီး ျပေပးမွာပါ။ မရွိခဲ့ရင္ေတာ့ Insert into Query ကို လုပ္ခိုင္းၿပီး Database ထဲမွာ သိမ္းဆည္းခြင့္ ေပးလိုက္မွာျဖစ္ပါတရ္ဗ်ာ။
   private void btnInsert_Click(object sender, EventArgs e)
   {
   if (txtEng.Text != "")
   {
   OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\EnToMM.accdb Persist Security Info=False");
   OleDbCommand cmmd = new OleDbCommand("SELECT * FROM tblData WHERE English='"+txtEng.Text+"' ",conn);
   conn.Open();
   OleDbDataReader reader = cmmd.ExecuteReader();
   int count = 0;
   while(reader.Read()){
   count++;
   }
   conn.Close();
   if (count == 1)
   {
   MessageBox.Show("This Word is already exist.", "Insert Data");
   }
   else {
   OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\EnToMM.accdb Persist Security Info=False");
   string Query = "INSERT INTO tblData (English,Type,Myanmar) VALUES('"+txtEng.Text+"','"+txtType.Text+"','"+txtMyanmar.Text+"' ";
   conn.Open();
   OleDbCommand cmd = new OleDbCommand(Query, conn);
   cmd.ExecuteNonQuery();
   conn.Close();
   MessageBox.Show("Successful Insert Contact.", "Insert Data");
   }
   
   }
   else {
   MessageBox.Show("Insert Data into TextBox.","Insert Data");
   }
   }
   
   အဆင္ေျပႏိုင္ပါေစဗ်ာ