Comments by Sheila Pontes (Top 35 by date)

I'm glad to help you.

HI,
What does the content in the variable str? What is the error?

Hi,

Could you enter your gridview code here?

Hi,

This article can help you.
Tutorial: Creating a Basic Chart

Thanks, Richard.

Que bom que funcionou. Eu vou atualizar a solução acima para refletir a solução exata do seu problema.

Glad it worked. I'll update a solution above to reflect an exact solution to your problem.

Coloca o update do Thomas no código acima que ele irá funcionar.
Assim.

string sqlQuery2 = @"UPDATE dbo.testenumserie SET ESTADO = '" + comboBox1.Text + "' WHERE NumSerie = '" + textBox2.Text + "'";

Pedro o campo ainda é chave primaria. Ele nunca vai deixar você colocar null neste campo.
Rode este comando para remover a constraint da chave, verifique se a chave primaria deixou de existir e veja se funciona o seu insert.
ALTER TABLE dbo.testenumserie DROP CONSTRAINT pk_testenumserie.

Pedro the field is still a primary key. It will never let you put null in this field.
Rotate this command to remove the constraint from the key, make sure the primary key no longer exists and see if it works your insert.
ALTER TABLE dbo.testenumserie DROP CONSTRAINT pk_testenumserie.

Verifica se não ficou nenhuma constraint no caminho proibindo você de colocar null no campo.
Uma outra opção seria excluir o campo e recriar ele de novo na tabela. Se falhar, exclui a tabela e cria de novo.
Um outro opção seria usar o identity do sql server neste campo ou colocar um valor default para o campo não ficar vazio.
Aqui eu uso oracle e fiz um teste no insert com select. Não houve problema.



Check if there is no constraint on the path forbidding you to put null in the field.
Another option would be to delete the field and recreate it again in the table. If it fails, delete the table and create it again.
Another option would be to use the identity of the sql server in this field or put a default value so the field is not empty.
Here I use oracle and did a test on insert with select. There was no problem.

O número de série é chave primaria? Se não.
Verifique se o campo numserie não tem alguma constraint como not null. Use o comando sp_help dbo.testenumserie no query analyser.

The NumSerie column is primary key? if not. Verify if your numserie column has not null constraint. Use the sp_help command.

Yes. I am from Brazil

Hi,
insert the value also in the numseries column.

 
string sqlQuery2 = @"INSERT into dbo.testenumserie(Estado, NumSerie) SELECT '" + comboBox1.Text + "', '" + textBox2.Text + '" from dbo.testenumserie WHERE NumSerie = '" + textBox2.Text + "'";

Hi,
To use the "where" clause in the insert, you need to use insert with select command. I change the code above correcting the insertion.
This article can help you undestand better.
https://technet.microsoft.com/pt-br/library/ms188263(v=sql.105).aspx

Adobe Read is free.

Hi,

Watch this video. It teach you how you open pdf in windows forms.

C# Tutorial - How to Open and Show a PDF file

Hi,
Test if the button is working.
To help you, I will change post above. I'll type the complete code in vb.
Copy this code and paste it into your test project and see how it works.

Hi.

See if this article help you. https://www.codeproject.com/Articles/42223/Easy-Customize-Title-Bar

Hi,

See this post https://www.codeproject.com/Answers/1196181/View-button-in-gridview-corresponding-to-a-user-ca#answer2.

I explain, how to use DataKeyNames in the gridview.

If the error continues, the problem is with Cadapter or its SELECT_SEARCH_COMPANY.
Add a breakpoint on line 30 and debug the code.
Somewhere, there is a null object.

I added the above correction.

I'm glad to help you.

Hi;

Don't install HtmlAgilityPack. Download version 1.4.6. Html Agility Pack, Unzip the file, add references in your project according to the version of the framework and add the namespace "using HtmlAgilityPack;"

Hi,
Tomorrow, when I get to work. I'll see this case for you.

Hi,

Install the reportviewer in your visual studio 2015. If the reportviewer already had install, install again.
Depending on the version of visual studio, the reportviewer does not install.
I had problem with visual studio 2012 express.

Download MICROSOFT® REPORT VIEWER 2015 RUNTIME from Official Microsoft Download Center

ReportViewer 2015 in Visual Studio 2015 | The ASP.NET Forums


This article is in Portuguese language but the google translation can help you.
This article teach you, how you install the reportviewer in the visual studio 2015
ReportViewer - Install in the Visual Studio 2015

I'm glad to help you.

Replace the datatable, "dt", that I created manually by result of your connection with database.

I'm glad to help you.

What is this user id that you do want? You said that you don't want the username, but the username is unique key in windows.
I found a post on how to get a unique ID from a logged-in user in the Windows session. Id changes every session. Is this?

Mahesh, hi

See the solution below that i wrote to you. See if it solves your problem.

Hi,

Do you have a input where the person type the id?