

Lbl_R_Status.Text = DataGridView2.Item(1, i).ValueĬnString = "datasource=localhost username=root password= database=spidernews Character Set=utf8" Lbl_R_Heading.Text = DataGridView2.Item(2, i).Value Lbl_R_archiveid.Text = DataGridView2.Item(0, i).Value Query_tblrundownnames = "Select id,mosactive,rundown_names,rundown_time from tblrundownnames where mosactive = 'ONAIR'"ĭa = New MySqlDataAdapter(query_tblrundownnames, conn)ĭim cb As MySqlCommandBuilder = New MySqlCommandBuilder(da)ĭa.Fill(ds, "tblrundownnames a tblcurrentrundown b")ĭataGridView2.DataMember = "tblrundownnames a tblcurrentrundown b" '''''''' SECOND GRID FOR GETTING ID OF MOS ACTIVE, BUT SHOULD PRINT ON LABELSĬnString = "datasource=localhost username=root password= database=spidernews charset=utf8 " The Connector use for database in VB.NET:ĬnString = "datasource=localhost username=root password= data base=xyz charset=utf8 "

Which show URDU TEXT, from data base here is the problem with DATA GRID and TEXT BOX. I have a datagrid, on clicking any row I got the TEXT in details in TextBox, One section of it is designed on Visual Studio.NET 2010 in which Retrieving URDU Data from MY SQL 5.5.8 running on wamp server with PHP is OK,Īnd the soft ware is only for Internal use not web base! I have a field storytext, (data collected in URDU language UTF-8) detail are:Ĭollation:utf8_unicode_ci (I tried all given collation in my phpadmin) I need your help, I am working on a project, MYSQL and PHP based,with WAMP SERVER.
