Guest User

Untitled

a guest
Nov 21st, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using System.Data.SqlClient;
  10. using MySql.Data.MySqlClient;
  11.  
  12. namespace WindowsFormsApplication11
  13. {
  14. public partial class save : Form
  15. {
  16. public save()
  17. {
  18. InitializeComponent();
  19. }
  20.  
  21. private void button1_Click(object sender, EventArgs e)
  22. {
  23. string myConnection = "datasource=localhost;port=3306;username=root;Password=root";
  24. string query = "insert into store_data.item_details (item_id,item_name,item_qty,item_price) values('" + this.id_txt.Text + "','" + this.name_txt.Text + "','" + this.qty_txt.Text + "','" + this.price_txt.Text + "');";
  25. MySqlConnection connection = new MySqlConnection(myConnection);
  26. MySqlCommand cmdsave = new MySqlCommand(query, connection);
  27.  
  28. MySqlDataReader dataReader;
  29.  
  30. try
  31. {
  32. connection.Open();
  33. dataReader = cmdsave.ExecuteReader();
  34. MessageBox.Show("your Data has been saved ");
  35.  
  36. while (dataReader.Read())
  37. {
  38. }
  39.  
  40. connection.Close();
  41. }
  42. catch (Exception excep)
  43. {
  44. MessageBox.Show(excep.Message);
  45. }
  46. }
  47. }
  48. }
  49.  
  50. save_Load(object sender, EventArgs e) {
  51.  
  52. }
Add Comment
Please, Sign In to add comment