C#

Case 0:<br />
Case 1:<br />
   status = "Single"<br />
   break;<br />
case 2:

namespace ExerciseInt
{
    public partial class Form1 : Form
    {
      int newNumber;
        
        public Form1()
        {
            InitializeComponent();
           
        }

        public void button1_Click(object sender, EventArgs e)
        {
            Random myRandom = new Random
            myNumber = myRandom.Next(1,10);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            MessageBox.Show(myNumber.ToString());
        }
    }
}

		public clsLimitValue oValue { get; set; }<br />
		private BindingSource oBS = new BindingSource();<br />
<br />
		private void frmNewLimit_Load(object sender, EventArgs e)

SqlConnection con = new SqlConnection("your connection string");
SqlDataReader dr;
string str = "your query";
SqlCommand cmd = new SqlCommand(str, con);
dr = cmd.ExecuteReader();
if (dr.HasRows== false)
{
    //insert new row
}

odbcConnection con = new odbcConnection("your connection string");
odbcDataReader dr;
string str = "your query";
odbcCommand cmd = new odbcCommand(str, con);
dr = cmd.ExecuteReader();
if (dr.HasRows== false)
{
    //insert new row
}

if (dr.HasRows == false)
{
    //insert new row
}

if (!dr.Read())
{
    MessageBox.Show("No records");
}
else
{
    MessageBox.Show("Records Found");
}