Reusable user control

Question

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 editclickeventdeleteclickevent but i am not able to do so as i need help as i am stuck on thisand 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 thatso please help me out need help.

Kailash Polai · Answer

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 Malik · Answer

try this code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace sqlparamater { public partial class Form1:Form { public Form1() { InitializeComponent(); } SqlConnectionconn; SqlCommandcomm; string connstr= database=student;server=.;user=sa;password=wintellect ; private void btnsave_Click( object senderEventArgse) { conn= new SqlConnection(connstr); comm= new SqlCommand(); conn.Open(); //creatinginstanceofSsqlParameter SqlParameterrollno= new SqlParameter( @rn SqlDbType.Int); SqlParametername= new SqlParameter( @n SqlDbType.VarChar); SqlParametercourse= new SqlParameter( @c SqlDbType.VarChar); SqlParametercity= new SqlParameter( @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(); } } private void btndelete_Click( object senderEventArgse) { conn= new SqlConnection(connstr); comm= new SqlCommand(); conn.Open(); SqlParameterrollno= new SqlParameter( @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(); } } private void btnsearch_Click( object senderEventArgse) { if (txtrollno.Text==  ) { MessageBox.Show( PleaseEnterRollNo.ofStudent ); } else { conn= new SqlConnection(connstr); comm= new SqlCommand(); conn.Open(); SqlParameterrollno= new SqlParameter( @rn SqlDbType.Int); SqlParametername= new SqlParameter( @n SqlDbType.VarChar); SqlParametercourse= new SqlParameter( @c SqlDbType.VarChar); SqlParametercity= new SqlParameter( @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(); } } } private void btnupdate_Click( object senderEventArgse) { conn= new SqlConnection(connstr); comm= new SqlCommand(); conn.Open(); SqlParameterrollno= new SqlParameter( @rn SqlDbType.Int); SqlParametername= new SqlParameter( @n SqlDbType.VarChar); SqlParametercourse= new SqlParameter( @c SqlDbType.VarChar); SqlParametercity= new SqlParameter( @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=@ncourse=@ccity=@ciwhererollno=@rn ; try { comm.ExecuteNonQuery(); MessageBox.Show( Updated.... ); txtcity.Clear(); txtcourse.Clear(); txtname.Clear(); txtrollno.Clear(); } catch (Exception) { MessageBox.Show( NotUpdated.... ); } finally { conn.Close(); } } private void Form1_Load( object senderEventArgse) { } } } for more detail follow this link http://www.c-sharpcorner.com/UploadFile/718fc8/save-delete-search-and-update-record-using-sqlparameter-cl/