Skip to main content

create stoared procedure in C#


Following is the project in C# which creates a stoared procedure in mysql database.
for that we created a class library and we import this in one windows project.



using MySql.Data.MySqlClient;
using System.Data;

namespace stored_proc_db_disp_dll
{
    public class Class1
    {
        MySqlConnection con = new MySqlConnection("server=localhost;uid=root;pwd=root;database=test");
        MySqlCommand cmd=null;

        MySqlDataReader dr;

        public Boolean createprocedure(String str)
        {
            bool b = true;
            try
            {
                cmd.CommandText = str;

                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                b = false;
            }
            return b;
        }
}
}




using stored_proc_db_disp_dll;

namespace create_procedure_demo
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Class1 c1 = new Class1();
            if (c1.createprocedure(textBox1.Text))
            {
                MessageBox.Show("Procedure created ");
            }
            else
            {
                MessageBox.Show("Can not creaye procedure");
            }

        }
}
}

Comments

Popular posts from this blog

Add, remove, search an item in listview in C#

Below is the C# code which will help you to add, remove and search operations on listview control in C#. Below is the design view of the project: Below is the source code of the project: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace Treeview_control_demo {     public partial class Form2 : Form     {         public Form2()         {             InitializeComponent();             listView1.View = View.Details;                   }         private void button1_Click(object sender, EventArgs e)         {             if (textBox1.Text.Trim().Length == 0)...

MULTIPLEXER , Design & Implement the given 4 variable function using IC74LS153. Verify its Truth-Table

TITLE: MULTIPLEXER   AIM: Design & Implement the given 4 variable function using IC74LS153. Verify its Truth-Table.   LEARNING OBJECTIVE: ·        To learn about IC 74153 and its internal structure. ·        To realize 8:1 MUX and 16:1 MUX using IC 74153.   COMPONENTS REQUIRED: IC 74153, IC 7404, IC 7432, CDS, wires, Power supply. IC PINOUT:            1)     IC 74153 2)      IC 7404:                                              3) IC 7432 THEORY:   ·        Multiplexer is a combinational circuit that is one of the most widely used in digital design. ·        The multiplexer is a data selector which gates one out of several inputs to a sin...

Excel to PDF converter in Selenium with java Demo

package excel2pdfDemo; import java.io.FileInputStream; import java.io.*; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.ss.usermodel.*; import java.util.Iterator; import com.itextpdf.text.*; import com.itextpdf.text.pdf.*; public class Excel2pdf {          public static void main(String[] args) throws Exception{                 FileInputStream input_document = new FileInputStream(new File("D:\\APCH.xls"));                 // Read workbook into HSSFWorkbook                 HSSFWorkbook my_xls_workbook = new HSSFWorkbook(input_document);                 // Read worksheet into HSS...