private string parseinput(string str)
    {
        
        Boolean boolvalue;
        Int32 intvalue;
        float realvalue;
        DateTime datevalue;
        Guid guidvalue;
        if (Boolean.TryParse(str, out boolvalue))
            return "bit";
        else if (Int32.TryParse(str, out intvalue))
            return "int";
        else if (float.TryParse(str, out realvalue))
            return "real";
        else if (DateTime.TryParse(str, out datevalue))
            return "datetime";
        else if (Guid.TryParse(str, out guidvalue))
            return "Guid";
        else
            return "nvarchar";
       
    }

        private void searchdb()
        {
            listBox3.Items.Clear();
            int tablecount = comboBox1.Items.Count;
            for(int i=0; i<tablecount; i++)
            {
                comboBox1.SelectedIndex = i;
                int columncount = listBox1.Items.Count;
                for(int j=0; j < columncount; j++)
                {
                    listBox1.SelectedIndex = j;
                    listBox2.SelectedIndex = j;
                    string tablename = comboBox1.SelectedItem.ToString();
                    string columnname = listBox1.SelectedItem.ToString();
                    string datatype = parseinput(textBox1.Text.ToString());
                    if(listBox2.SelectedItem.ToString( )== datatype)
                    {
                        if (datatype != "int")
                        {
                            cmd.CommandText = "select " + columnname.ToString() + " from " + tablename.ToString() + " where " + columnname.ToString() + " Like '%" + textBox1.Text.ToString() +"%'";
                        }
                        if(datatype == "Guid")
                        {
                            cmd.CommandText = "select " + columnname.ToString() + " from " + tablename.ToString() + " where " + columnname.ToString() + "='" + textBox1.Text.ToString() +"'";
                        }
                         cn.Open();
                         dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        listBox3.Items.Add(dr[0].ToString()+" Column Name:"+columnname.ToString()+"From Table:"+tablename.ToString());
                        Application.DoEvents();
                        listBox4.Items.Add(cmd.CommandText.ToString());
                    }

                }
                cn.Close();

  private string parseinput(string str)
    {
        
        Boolean boolvalue;
        Int32 intvalue;
        float realvalue;
        DateTime datevalue = new DateTime();
        Guid guidvalue = Guid.NewGuid();
        // Create an array of string representations of the GUID.
        string[] stringGuids = { guidvalue.ToString("B"),
                               guidvalue.ToString("D"),
                               guidvalue.ToString("X") };

        // Parse each string representation.
        Guid newGuid;
        foreach (var stringGuid in stringGuids)
        {
            if (Guid.TryParse(stringGuid, out newGuid))
                str += String.Format("Converted {0} to a Guid\n", stringGuid);
            else
                str += String.Format("Unable to convert {0} to a Guid\n",
                                  stringGuid);
        }                            
       
        if (Boolean.TryParse(str, out boolvalue))
            return "bit";
        else if (Int32.TryParse(str, out intvalue))
            return "int";
        else if (float.TryParse(str, out realvalue))
            return "real";
        else if (DateTime.TryParse(str, out datevalue))
            return "datetime";
        else if (Guid.TryParse(str, out guidvalue))
            return "Guid";

        else
            return "nvarchar";
       
    }

myConnection.Open();
SqlCommand myCommand = new SqlCommand("your Procedure Name", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@orgid", SqlDbType.UniqueIdentifier).Value = orgid;
myCommand.Parameters.Add("@statid", SqlDbType.UniqueIdentifier).Value = statid;
myCommand.Parameters.Add("@read", SqlDbType.Bit).Value = read;
myCommand.Parameters.Add("@write", SqlDbType.Bit).Value = write;
// Mark the Command as a SPROC

myCommand.ExecuteNonQuery();

myCommand.Dispose();
myConnection.Close();

     private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection cn = new SqlConnection("Data Source=ADMIN;Initial Catalog=AdventureWorks2012;Persist Security Info=True;User ID=sa;Password=Password11");
            SqlCommand cmd = new SqlCommand("select * from Sales.Store where rowguid = @id", cn);
         
            textBox1.Text = Guid.NewGuid().ToString();
            cmd.Parameters.Add("@id", SqlDbType.UniqueIdentifier).Value = textBox1.Text;               
                
            cn.Open();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
        
            DataSet ds = new DataSet();
            da.Fill(ds);

            dataGridView1.DataSource = ds.Tables[0];
            cn.Close();
        }

private string parseinput(string str)
        {
            Boolean boolvalue;
            Int32 intvalue;
            float realvalue;
            DateTime datevalue = new DateTime();
            Guid guid = new Guid();                             

            if (Boolean.TryParse(str, out boolvalue))
                return "bit";
            else if (Int32.TryParse(str, out intvalue))
                return "int";
            else if (float.TryParse(str, out realvalue))
                return "real";
            else if (DateTime.TryParse(str, out datevalue))
                return "datetime";
            else if (Guid.TryParse(str, out guid))
                return "Guid";
            else
                return "nvarchar";

        }

        private void button1_Click(object sender, EventArgs e)
        {
            string datatype = parseinput(textBox1.Text.ToString());
            SqlConnection cn = new SqlConnection("Data Source=ADMIN;Initial Catalog=AdventureWorks2012;Persist Security Info=True;User ID=sa;Password=Password11");
            if (datatype == "Guid")
            {
                SqlCommand cmd = new SqlCommand("select * from Sales.Store where rowguid = @id", cn);

                cmd.Parameters.Add("@id", SqlDbType.UniqueIdentifier).Value = textBox1.Text;

                cn.Open();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                dataGridView1.DataSource = ds.Tables[0];
                cn.Close();
            }
        }