carallot's questions

I have a Database, in which I need to clean the spaces of a specific field in all the tables of the database. This field is called delegate in your table and idDelegado in your foreign ones. For example, if the code for a delegate is ' DEL012 'I need to do a Trim()on all tables where there is a idDelegado. To consult all the tables where I have a iDdelegadoI do it like this:

Select TABLE_NAME,COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'idDelegado' AND TABLE_NAME NOT like 'VIS_%'
ORDER BY COLUMN_NAME

And it occurs to me to go through the result of the query with a cursor and do the corresponding Trim(), but I doubt that this is the best solution. Is there a better way to do it?

I don't know what I'm doing wrong, I have an extremely simple Json, but I can't deserialize it, I just don't know what else to try. the JSON is this:

{"value":[{"Id":"2b0af0d7-2a7b-4489-a205-8cb9aef88a1b","Code":"1","Name":"Empresa Pripal"},{"Id":"39e415d3-d971-404a-b5ca-fc7f039dd859","Code":"3","Name":"Empresa 3 "},{"Id":"b8405286-a3d1-4d40-9a64-ec8fde498342","Code":"75","Name":"Empresa pruevas"},{"Id":"ec624692-5383-44a8-822a-3493ff177c02","Code":"99","Name":"Empresa 99"}]}

the entity is:

public class Empresas
{
    [JsonPropertyName("value")]
    IEnumerable<Empresa> value { get; set; }
}

public class Empresa
{
    public string Id { get; set; }
    public string Code { get; set; }
    public string Name { get; set; }
}

And I try to deserialize the Json like so:

Empresas tryObject = JsonSerializer.Deserialize<Empresas>(data);

But tryObject is always null. It is obvious that I am doing something wrong, can you help me please.

Thank you very much.

I am generating some labels, with various barcodes. The structure is assembled from some controls previously located in a form.

   psettings.PrinterName = MapPrinters.Printers.GetPrinter(this.form.printer.PrinterSettings.PrinterName);
        pd.PrinterSettings.PrinterName = psettings.PrinterName;
        pd.PrinterSettings.DefaultPageSettings.Landscape = true;

        pd.PrintPage += new PrintPageEventHandler((object o, PrintPageEventArgs e) =>
        {
            for (int i = pageCount; i < data.Rows.Count; i++)
            {
                //e.Graphics.TranslateTransform(panel.Width/2,panel.Height/2,System.Drawing.Drawing2D.MatrixOrder.Append);
                //Impresió en vertical
                if (((CheckBox)Controls["chkPrint"]).Checked)
                {
                    e.Graphics.RotateTransform(90,System.Drawing.Drawing2D.MatrixOrder.Append);
                    e.Graphics.TranslateTransform(291, 5, System.Drawing.Drawing2D.MatrixOrder.Append);
                }
                PrintLines(form, e);
                lData.ForEach((x =>
                {
                    e.Graphics.DrawString(GetCellData(x.Text, data.Rows[i], x), x.Font, Brushes.Black, ObtainRectangle(x,0,0,offsetY), Alineament(x));
                }));
                lLabel.ForEach((x =>
                {
                    e.Graphics.DrawString(x.Text, x.Font, Brushes.Black, ObtainRectangle(x, 0, 0, offsetY), Alineament(x));
                }));
                lBarCode.ForEach((x =>
                {
                    if (GenerateBarcode(x.Text, data.Rows[i], x) != null)
                        e.Graphics.DrawImage(GenerateBarcode(x.Text, data.Rows[i], x), ObtainRectangle(x, 5, 10,offsetY));
                }));
                if (panel != null)
                    e.Graphics.DrawRectangle(new Pen(Color.Black, 1), new Rectangle(panel.Location.X, panel.Location.Y -offsetY, panel.Width, panel.Height));
                if (pageCount == data.Rows.Count - 1)
                    e.HasMorePages = false;
                else
                {
                    e.HasMorePages = true;
                    pageCount++;
                    return;
                }
            }

        });
        
        form.printer.Document = pd;
        try
        {
            // MessageBox.Show(pd.PrinterSettings.ToString());
            if (((CheckBox)Controls["chkPrint"]).Checked)
                pd.DefaultPageSettings.PaperSize = new PaperSize("label", 291, 826);
            else
                pd.DefaultPageSettings.PaperSize = new PaperSize("label", 826, 291);
            pd.Print();
            lcOK = true;
        }
        catch (Exception ex)
        {
            lcOK = false;
            MessageBox.Show(ex.Message);
        }
        return lcOK;

The barcode is generated with the IronBarCod library

        private Image GenerateBarcode(string text, DataRow dataRow, TextBox ctrl)
    {
        string toData = text.Replace('[', ' ').Replace(']', ' ').Trim();
        if (dataRow.Table.Columns.Contains(toData))
        {
            if (dataRow[toData].ToString().Trim() != String.Empty)
            {
                try
                {
                    return BarcodeWriter.CreateBarcode(dataRow[toData].ToString(), BarcodeEncoding.Code128).ToBitmap();
                }
                catch (Exception e)
                {
                    return new Bitmap(1, 1);
                }
            }
            else return null;
        }
        else return null;
    }

although I have tried with BarCodeLib and GenCode128 with identical result.

The thing is that if I print by default in horizontal mode, everything works perfectly, the problem is that the print can be horizontal and vertical, for which I do a Graphics.rotatetransform(90) and this is when the label is printed correctly , but the barcode lines are printed a bit shaded, enough that the reader doesn't understand them anymore.

Can you give me a hand please?

Thank you very much in advance.

I have set the first column of a DataGridViewas CheckBoxColumn, when activating the checkBox, I would like it to paint the whole row, in fact it works for me, but it doesn't seem to apply the changes until I exit that row. I leave you the code that I have to see if you can give me a cable, I have tried with dataGrid.Refresh()and .Update(), but I don't get anything. Thank you very much.

private void dgvComandes_MouseUp(object sender, MouseEventArgs e)
{
    dgvComandes.EndEdit();
}
private void dgvComandes_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
    if(e.ColumnIndex == dgvComandes.Columns["colCheck"].Index)
    {
        bool sel = (bool)dgvComandes.Rows[e.RowIndex].Cells["colCheck"].Value ;
        if(sel)
        {
            dgvComandes.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.FromArgb(106, 174, 144);
            dgvComandes.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
        }
        else
        {
            dgvComandes.Rows[e.RowIndex].DefaultCellStyle.ForeColor = dgvComandes.DefaultCellStyle.ForeColor;
            dgvComandes.Rows[e.RowIndex].DefaultCellStyle.BackColor = dgvComandes.DefaultCellStyle.BackColor;
        }
    }
}

Good afternoon, can you give me a hand please? I need to generate a list that returns me, given a range of dates or order numbers, a list of the items and total units that are in these orders: I achieve this with this query:

select DE.ARTICULO, DE.DEFINICION,SUM(UNIDADES)
from detalle_pedido as DE INNER JOIN cabecera_pedido as CA
ON DE.NUMERO = CA.NUMERO AND DE.LETRA = CA.LETRA
WHERE DE.NUMERO='  20000014' OR DE.NUMERO= '  20000023' 
GROUP BY DE.ARTICULO,DE.DEFINICION 
HAVING SUM(UNIDADES)>0

The problem is that the ERP where I launch this query separates the exercises by database, so this query will only work for a specific exercise. It gives me that the solution would be with a UNION ALL, and join the result to the same query in another exercise, but in this way the articles that are in orders of different exercises will be duplicated. How could I regroup and add the units of the result of the UNION ALL? Thank you very much.

I have to compare the records of a DataTablewith the objects of a list, the , let's say it only has a " codedatatable " column , the article object, has several fields, id , name , description , price and stock . I would like to get the objects with the same common id . The most I have come to is:

var result = allp.Select(x => x.id).Except(dt.AsEnumerable().Select(y => y["codigo"]));

But it is obvious that I am not doing something right because I am not getting the desired result. Can someone help me please?

Good I have a big mess with asynchronous programming. When I query the API of an online store, I always use the await. When I implement these in a method, I always return the result with Task<T>. However, when I try to do the same thing with queries to a database, I get the error:

Error CS1061 "int" does not contain a definition for "GetAwaiter" or an accessible extension method "GetAwaiter" that accepts a first argument of type "int" (are you missing a using directive or an assembly reference?) An example of what i try to do:

public async Task<Int32> ObteNumFills()
{
    Int32 nRegs = 0;
    string connectionString = Cconnexio.RetornaCadenaConnexio(BddParams);
    string query= "Select COUNT(codigo) FROM empleados where edad > 24;
    using (SqlConnection cn = new SqlConnection(connectionString))
    {
        cn.Open();
        SqlCommand cmd = new SqlCommand(query, cn);
        try
        {
            nRegs = await(Int32)cmd.ExecuteScalar();
        }
        catch (Exception e)
        {

            nRegs = 0;
        }
    }
    return nRegs;
}

This query is very simple and shouldn't take more than a few milliseconds, but how could I perform this task asynchronously?

I have a dataGridwith 2 columns " code " and " description " and when setting the sizes, I don't know how to tell the " description " column that its width occupies the rest of the datagrid. Nothing I have read has worked for me. Can you give me a cable please?

Good afternoon, I have a list of strings that contains the codes to add to an SQL query in an in: Example:

 List<string> container = new List<string>();
    container.Add("2");
    container.Add("3");
    container.Add("5");
    container.Add("12");
    container.Add("214");
    container.Add("A324");
    container.Add("SD3434");

    string cIn = string.Join(",", container);
  
    string lcSql = "SELECT articulo from ofertas WHERE articulo in(" +cIn + ")";

This gives me: SELECT articulo from ofertas WHERE articulo in(2,3,5,12,214,A324,SD3434) but article is a field of type char(10), so I would need to quote all the values ​​of the result of string.Joinbut I can't find a way to do it. Can I do this using this method, or am I looking for another way? Thanks.

I have a column with a series of 6-digit numbers and I need to insert 2 zeros from the 3rd position:

484783 -> 48400783 653923 -> 65300923 etc.. I have tried with \d{4}+00 but I think I am too far away can you help me please ?

I don't know if I've been too clear with the title so I apologize if I haven't. I put an example of what I mean, very simple, but I imagine that it will be extensible to any Windows Forms control. I create a textBoxin a "textBox1" form , now by code, I instantiate a textBoxand Textassign the value "test" to its property:

textBox cajaTextoDinamica = new textBox();
cajaTextoDinamica.Text = "prueba";

In my head, it made sense that if I typed : textBox1 = cajaTextoDinamica;the one on textBox1the form would be replaced by the dynamically generated one, but it doesn't. However, even though such a control is not displayed on the form, the property textnow txtBox1has the value "test" even though it does not display it. I hope I have explained myself well enough and I would appreciate it if you could tell me what I am doing wrong.

I am practicing with LINQ in C# and SQL SERVER and I wanted to write this query in LINQ:

SELECT Employees.FirstName, COUNT(Orders.OrderID) AS Orders
FROM  Employees INNER JOIN
Orders ON Employees.EmployeeID = Orders.EmployeeID
GROUP BY Employees.FirstName

But I am not able, neither in from format nor with lambda expression, can you give me a hand please?

I am exporting some tables DBFthrough CSVlibreoffice. This in the headers, it exports the name of the header plus characters that refer to the data type and length for example, the NNUMALB column , it exports it to me as NNUMALB,N,7,0 and I want to do a massive replacement that eliminates me everything from the first comma. Can you give me a cable? Thank you very much.

In a course that I am following on SQL server, I have seen the use of round() to check the decimals of a specific field; This field is called haber, and they use it in the following way haber-round(haber,2)At first, despite not understanding that use, I thought it was equivalent to round(haber,2)dry, but you return me a number of different records. I have searched for information about it, but nothing. Can you give me a cable? Thank you very much.

I would like to make a query or procedure that would look for all the fields with a specific name in a database and if the size of the field was less than N , it would establish a new value. That is, set all named fields articuloof a database Varchar(8)to Varchar(15). Can someone guide me on how to do it? Thank you very much.

It's MSSQL Server, sorry for not specifying it, I thought Transact-sql in the tags was enough, sorry.