c#怎么表示？？？

[believe007]

DBCommand = New OleDbDataAdapter _
("Select FriendlyName as [Name], " _
& "StoreAddress as [Address], " _
& "StoreDirections as [Directions] " _
& "From StoreLocations Where " _
& "ZipCode = '" & ddlZipCode.SelectedItem.Text _
& "' Order By FriendlyName " _
, DBConn)

[sanniko]

OleDbDataAdapter MyDataAdapter=new OleDbDataAdapter(sql语句,DBConn);
MyDataAdapter.ExecuteNonequery();//这里好象是这么写，没vs.net我记不的.后面的具体拼写

[开心就好]

直接加一个“+"就完了：（
你至少得问清楚问题呀

[believe007]

OleDbDataAdapter DBCommand =new OleDbDataAdapter ("select FriendlyName as Name ,"+"StoreAddress as Address,"+" StoreDirections as Directions," +"from StoreLocations Where ZipCode="+ddlZipCode.SelectedItem.Text +"Order By FriendlyName",DBConn);

这样写也是错误的，请问应该用c#怎么写了？

[cuckoo_7]

OleDbDataAdapter DBCommand = New OleDbDataAdapter ("Select FriendlyName as [Name],StoreAddress as [Address],StoreDirections as [Directions] From StoreLocations Where ZipCode = '" + ddlZipCode.SelectedItem.Text + "' Order By FriendlyName ", DBConn)