I've created an application that will display the data of a given view in a datagridview control.
The whole application is ready: loading the data, the button to update and also the events load and activated .
Technologie...
In my app.config I have the following lines of code:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="ControleBD"...
What is the best way to set up a query in C #? Is it advisable to use concatenation with the + operator? For example:
query += " WHERE nome LIKE '%" + nome + "%'";
Here is a% w of% that I set as an example to illustrate the situat...
I would like to fetch a given string using LIKE in more than 1 table. Here is an example of how I did it, which will probably spend a lot of time or not fetch all tables:
string SQL1 = @"SELECT *
FROM TB_1
WHERE NOME LIKE '%' +...
There are a few possible places to store the string connection.
Leave tied inside code, app.config , configuration file and Windows registry.
What is the best place to store the string connection? Based on the requirements, security...
I created a search screen with textbox , button and gridview .
I would like the search results to appear in this Gridview but I can only do this with a Dataset . In this case, I needed to find a way to pass parame...
I'm having a problem, which would be a mistake saying that there is no parameter being passed to the procedure .
It is running the following code:
cmdProcedure.Parameters.AddWithValue("@id", 0);
Command:
public List<Models.Admin>...
I need to return a field that is of type bool :
public List<TB_USUARIO> ListarTodos()
{
var strQuery = "select * from tb_usuario";
using (contexto = new Contexto())
{
var retornoDataRead...
I am creating a C # project with MySQL, my connector follows the Singleton pattern and I use MySqlDataReader to retrieve the data from the table and popular a List so far so good.
My problem started when I had to recover data from one table b...