Whiteangel Posted March 3, 2014 at 10:06 PM Report #547447 Posted March 3, 2014 at 10:06 PM Boas pessoal, Tenho uma datagridview e pesquiso pelo nome os dados dos campos numa textbox, mas está me a duplicar o nome dos campos da tabela na datagridview, e nao sei porquê... Dim contr As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Acer\Desktop\Base de Dadosmdf;Integrated Security=True;Connect Timeout=30;User Instance=True" ' Cria uma nova ligação à base de dados Dim db As New SqlConnection(contr) If db.State = ConnectionState.Open Then db.Close() Dim ds As New DataSet Dim dt As New DataTable Dim clientes As New SqlDataAdapter("Select * from Categoria where Nome like'%" + Txtnome.Text + "%' ", db) clientes.Fill(ds, "Categoria") dt = ds.Tables(0) DataGridView1.DataSource = ds.Tables("Categoria")
Diego Fernandes Posted March 5, 2014 at 02:56 AM Report #547551 Posted March 5, 2014 at 02:56 AM Whiteangel... teoricamente esta certo o código... eu o aconselho a ver no banco de dados pois no código não vejo erro
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now