Saturday, 24 March 2012

Dynamically passing table name in select query in vb.net

Today I tried to pass table name dynamically to select query  as

 cmd = New OdbcCommand ("select * from '" & table_name & "' where id=" & i & "", con)
But it failed. Then fortunately got the correct one....

cmd = New OdbcCommand("select * from [" & table_name & "] where id=" & i & "", con)

Similarly avoid single quotes while using number.
eg: use  id=" & i & "  instead  id=' " & i & " ' ,when id is number type. 

Thursday, 22 March 2012

Happy to Work.

Really I'm very happy to work while studying. Gained lot of knowledge from my company. Its very interesting to face multiple goals concurrently. Night works, new goals, targets, new technologies, compact tools more than this a good friendly environment. Becoming crazy to code. 

Thanks to vmtechsolutions

Thursday, 8 March 2012

Really I'm a dash...

Really I'm a stupid.... To remove a single error ("want to remove a single quotation ") utilized 4 days hardly...

Decided to clear basic concepts of technologies....