Reusable user control

Atik Shaikh

I need to create an usercontrol like

ADD EDIT SAVE DELETE SEARCH PRINT

in my desktop based application.

i want it to be reusable as i can use the same control on my multiple form but i am not able to do the needfull as i dont know how to do that, i have designed the usercontrol but when i add that control to form, i want to allow different events like addclickevent, editclickevent,deleteclickevent but i am not able to do so as, i need help as i am stuck on this,and not able to think on how to make use of it ,

the other appraoch i think will be adding add/edit buttons to the form as will be able to write the events for the same, but i know that will be the wrong approach for that,so please help me out need help.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kailash Polai9y ago
Add events to UserControls
public partial class TransactionControl : UserControl
    {
        public event  EventHandler AddClicked;
        public event EventHandler EditClicked;
        public event EventHandler DeleteClicked;
        public event EventHandler SaveClicked;
        //similarly for other buttons

        public TransactionControl()
        {
            InitializeComponent();
        }

        private void btnADD_Click(object sender, EventArgs e)
        {
            this.AddClicked?.Invoke(this, e);
        }

        private void btnEDIT_Click(object sender, EventArgs e)
        {
            this.EditClicked?.Invoke(this, e);
        }

        private void btnDELETE_Click(object sender, EventArgs e)
        {
            this.DeleteClicked?.Invoke(this, e);
        }

        private void btnSAVE_Click(object sender, EventArgs e)
        {
            this.SaveClicked?.Invoke(this, e);
        }
    }
And use the usercontrol in newForm
public partial class newForm : Form
    {
        public newForm()
        {
            InitializeComponent();
            transactionControl1.AddClicked += transactionControl1_AddClicked;
            transactionControl1.EditClicked += TransactionControl1_EditClicked;
            transactionControl1.DeleteClicked += TransactionControl1_DeleteClicked;
            transactionControl1.SaveClicked += TransactionControl1_SaveClicked;
        }

        private void transactionControl1_AddClicked(object sender, EventArgs e)
        {
            //add your data here...
        }

        private void TransactionControl1_EditClicked(object sender, EventArgs e)
        {
            //edit your data here...
        }

        private void TransactionControl1_DeleteClicked(object sender, EventArgs e)
        {
            //delete your data here...
        }

        private void TransactionControl1_SaveClicked(object sender, EventArgs e)
        {
            //save your data here...
        }
    }
Ajay Malik10y ago
try this code
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
namespacesqlparamater
{
publicpartialclassForm1:Form
{
publicForm1()
{
InitializeComponent();
}
SqlConnectionconn;
SqlCommandcomm;
stringconnstr="database=student;server=.;user=sa;password=wintellect";
privatevoidbtnsave_Click(objectsender,EventArgse)
{
conn=newSqlConnection(connstr);
comm=newSqlCommand();
conn.Open();
//creatinginstanceofSsqlParameter
SqlParameterrollno=newSqlParameter("@rn",SqlDbType.Int);
SqlParametername=newSqlParameter("@n",SqlDbType.VarChar);
SqlParametercourse=newSqlParameter("@c",SqlDbType.VarChar);
SqlParametercity=newSqlParameter("@ci",SqlDbType.VarChar);
//AddingparametertoSqlCommand
comm.Parameters.Add(rollno);
comm.Parameters.Add(name);
comm.Parameters.Add(course);
comm.Parameters.Add(city);
//Settingvalues
rollno.Value=Convert.ToInt32(txtrollno.Text);
name.Value=txtname.Text;
course.Value=txtcourse.Text;
city.Value=txtcity.Text;
//addingconnectiontoSqlCommand
comm.Connection=conn;
//SqlStatement
comm.CommandText="insertintostudent_detailvalues(@rn,@n,@c,@ci)";
try
{
comm.ExecuteNonQuery();
MessageBox.Show("Saved");
txtcity.Clear();
txtcourse.Clear();
txtname.Clear();
txtrollno.Clear();
}
catch(Exception)
{
MessageBox.Show("NotSaved");
}
finally
{
conn.Close();
}
}
privatevoidbtndelete_Click(objectsender,EventArgse)
{
conn=newSqlConnection(connstr);
comm=newSqlCommand();
conn.Open();
SqlParameterrollno=newSqlParameter("@rn",SqlDbType.Int);
comm.Parameters.Add(rollno);
rollno.Value=Convert.ToInt32(txtrollno.Text);
comm.Connection=conn;
comm.CommandText="deletefromstudent_detailwhererollno=@rn";
try
{
comm.ExecuteNonQuery();
MessageBox.Show("Deleted....");
txtcity.Clear();
txtcourse.Clear();
txtname.Clear();
txtrollno.Clear();
txtrollno.Focus();
}
catch(Exception)
{
MessageBox.Show("NotDeleted....");
}
finally
{
conn.Close();
}
}
privatevoidbtnsearch_Click(objectsender,EventArgse)
{
if(txtrollno.Text=="")
{
MessageBox.Show("Please,EnterRollNo.ofStudent");
}
else
{
conn=newSqlConnection(connstr);
comm=newSqlCommand();
conn.Open();
SqlParameterrollno=newSqlParameter("@rn",SqlDbType.Int);
SqlParametername=newSqlParameter("@n",SqlDbType.VarChar);
SqlParametercourse=newSqlParameter("@c",SqlDbType.VarChar);
SqlParametercity=newSqlParameter("@ci",SqlDbType.VarChar);
comm.Parameters.Add(rollno);
comm.Parameters.Add(name);
comm.Parameters.Add(course);
comm.Parameters.Add(city);
rollno.Direction=ParameterDirection.Input;
name.Direction=ParameterDirection.Output;
course.Direction=ParameterDirection.Output;
city.Direction=ParameterDirection.Output;
name.Size=30;
course.Size=20;
city.Size=20;
rollno.Value=Convert.ToInt32(txtrollno.Text);
comm.Connection=conn;
comm.CommandText="select@n=name,@c=course,@ci=cityfromstudent_detailwhererollno=@rn";
try
{
comm.ExecuteNonQuery();
txtname.Text=name.Value.ToString();
txtcourse.Text=course.Value.ToString();
txtcity.Text=city.Value.ToString();
}
catch(Exception)
{
MessageBox.Show("NotFound");
}
finally
{
conn.Close();
}
}
}
privatevoidbtnupdate_Click(objectsender,EventArgse)
{
conn=newSqlConnection(connstr);
comm=newSqlCommand();
conn.Open();
SqlParameterrollno=newSqlParameter("@rn",SqlDbType.Int);
SqlParametername=newSqlParameter("@n",SqlDbType.VarChar);
SqlParametercourse=newSqlParameter("@c",SqlDbType.VarChar);
SqlParametercity=newSqlParameter("@ci",SqlDbType.VarChar);
comm.Parameters.Add(rollno);
comm.Parameters.Add(name);
comm.Parameters.Add(course);
comm.Parameters.Add(city);
rollno.Value=Convert.ToInt32(txtrollno.Text);
name.Value=txtname.Text;
course.Value=txtcourse.Text;
city.Value=txtcity.Text;
comm.Connection=conn;
comm.CommandText="updatestudent_detailsetname=@n,course=@c,city=@ciwhererollno=@rn";
try
{
comm.ExecuteNonQuery();
MessageBox.Show("Updated....");
txtcity.Clear();
txtcourse.Clear();
txtname.Clear();
txtrollno.Clear();
}
catch(Exception)
{
MessageBox.Show("NotUpdated....");
}
finally
{
conn.Close();
}
}
privatevoidForm1_Load(objectsender,EventArgse)
{
}
}
}
for more detail follow this link
http://www.c-sharpcorner.com/UploadFile/718fc8/save-delete-search-and-update-record-using-sqlparameter-cl/