this is subquery concept 
update set table1.ei =( select table2.ei where table2.name=peter);
* check the syntax of update  

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;

http://forums.asp.net/t/1208420.aspx/1
http://stackoverflow.com/questions/6859248/binding-data-from-the-database-to-a-dropdown-list-in-net
protected void Page_Load(object sender, EventArgs e)
{
Populate1();

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;

     private void Matrixcheck()
            {
                int i, j, m, a = 0,d=1;
                int k, l, b = 0,rtn;
                int temp=1;

 private void Matrixcheck()
        {
            int i, j, m, a = 0,d=1;
            int k, l, n, b = 0,e=1,t=0;
            int temp;

hkkjllj;kb';b';

Declare int @a,int @b

While a< len(address)

#include<iostream.h>
int main()
{ 
cout<<"hello wolrd";