0

anyone know about viewing an item from database but you only need to view is
for ex.
Name|Address|
Juan|Juan Luna Benita St.|

thats the table and item in your database NOW
you want to see it from your dataGridview but the 9 letters only...

ex.
DataGridView1
Name|Address|
Juan|Juan Luna|

thats the output.. anyone can know?
sorry for my english.. please some help!

2
Contributors
5
Replies
13
Views
4 Years
Discussion Span
Last Post by xLuFeT
0

this is my code sir...

conn="SELECT * FROM tblSample "

    OleDBDR = OleDBC2.ExecuteReader
    If OleDBDR.HasRows Then
        While OleDBDR.Read

            dgvclients.Rows.Add()
            dgvclients.Item(0, c).Value = OleDBDR.Item(0)
             dgvclients.Item(1, c).Value = OleDBDR.Item(1)
         end while
    end if

When I used this code this is the result...
Datagridview1
Name|Address|
Juan|Juan Luna Benita St.|

i really want want see is this
Name|Address|
Juan|Juan Luna|
9 Letters only can be appear in datagridview...
that is possible sir????

0

9 Letters only can be appear in datagridview...

What you mean about 9 letters only?
You mean only first 9 records from your database?

0

Example
You add data into your database the table name is Table1 the field name is Address the data you add is Juan Luna Benita St. if you can see the characters or letters I add is 20 included space.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.