Retrieving Single Database/Cell from table mysql to Vb.net -
i'm making program in label text change according retrieved data. thing/command found retrieving data column or record. need single data/cell.
i know how connect , use sql commands in vb.net said earlier can't retrieve single data/cell.
i found function called mysql_fetch_array think it's php not vb or mistaken?
this !
- need limit command added query !
- better performance suggest using order !
dim conn mysqlconnection dim cmd mysqlcommand conn = new mysqlconnection("server=localhost;user id=root;password=;database=db_name;") conn.open() cmd = new mysqlcommand("select col_name table_name col_name='values' limit 1", conn)
Comments
Post a Comment