C#

// the item class:
class cbi {
	public int i;
	public string text;
	public cbi(int i, string text) { this.i=i; this.text=text; }
	public override string ToString() { return text+" "+i; }
}

// inside the Form class:
public Form1() {
	InitializeComponent();
	cb.Items.Add(new cbi(1, "a"));
	cb.Items.Add(new cbi(2, "b"));
	cb.Items.Add(new cbi(3, "c"));
	cb.SelectedIndexChanged+=new EventHandler(cb_SelectedIndexChanged);
}
 
void log(string s) {Console.WriteLine(s);}
 
void cb_SelectedIndexChanged(object sender, EventArgs e) {
	cbi item=(cbi)cb.SelectedItem;
	// now you can access any member/property of item:
	if(item==null) log("item=null");
	else log("item i="+item.i);
}

class cbi {
	private int val;     public int    MyVal  { get { return val; } }
	private string name; public string MyName { get { return name; } }
 
	public cbi(int i, string text) { this.val=i; this.name=text; }
}
 
public Form123() {
	InitializeComponent();
	ArrayList list=new ArrayList();
	list.Add(new cbi(1, "a"));
	list.Add(new cbi(2, "b"));
	list.Add(new cbi(3, "c"));
	cb.DataSource=list;
	cb.DisplayMember="MyName";
	cb.ValueMember="MyVal";
	cb.SelectedIndexChanged+=new EventHandler(cb_SelectedIndexChanged);
}
 
void log(string s) {Console.WriteLine(s);}
 
void cb_SelectedIndexChanged(object sender, EventArgs e) {
	cbi item=(cbi)cb.SelectedItem;
	if(item==null) log("null");
	else {
		int i=(int)cb.SelectedValue;
		log("i="+i);
	}
}

SELECT fields FROM table WHERE someField LIKE '%someThing%'

Mohammed Gouda wrote:

I imagined that there is Adapter.Clear(DataSet) or anything similar

class MyClass
{
  static void MyMethod()
  {
    StackFrame sf = new StackFrame();
    MethodBase mb = sf.GetMethod();
    Debug.WriteLine("Currently in "+mb.DeclaringType.ToString()+"."+mb.Name+"()"); 
  }
}