Alejandro Ricotti's questions

I'm trying to make an HTTP POST request, I'm having problems adding an authorization in the header that has special characters like / and =

The code I use is the following

HttpRequestMessage request = new HttpRequestMessage(method, requestUri);

foreach (var h in headers)
        {
             request.Headers.Add(h.Key, h.Value);
        }

And the exception I get

The format of value 'kAw4dhLDTHY8HvEZWZmv7k6/PHw=' is invalid."

StackTrace " at System.Net.Http.Headers.HttpHeaderParser.ParseValue(String value, Object storeValue, Int32& index)\r\n at System.Net.Http.Headers.HttpHeaders.ParseAndAddValue(HeaderDescriptor descriptor, HeaderStoreItemInfo info, String value) \r\n at System.Net.Http.Headers.HttpHeaders.Add(HeaderDescriptor descriptor, String value)\r\n at System.Net.Http.Headers.HttpHeaders.Add(String name, String value)\r\n

I tried several ways but I did not find a solution

I hope you can help me

Thank you very much

Cheers

A query

I need to make an sp that receives three string parameters that are used to filter in the where

The doubt I have is that only one can come with data and the other two empty like the three with data

What had occurred to me is to make a string and concatenate depending on whether the variable it receives as a parameter is empty or not.

Is there any other way to do it?

For example if var1 = "test", var2 ="", var3 ="" In the where only var1 should go

On the other hand, if all three have data, all three should go. It may be the case that var2 has data and the other two do not, such as var3 having data and the others not or var2 and var3 having data

Thank you very much

Cheers

In a function in SQL Server is there a way to create a table and assign the value of a query to it, something like

CREATE TABLE AuxAlumnos
(
   Id       int,
   Nombre   varchar (10),
   Apellido varchar(10)
);

And to that table assign the value of aSELECT * FROM Alumnos

I have a function that receives parameters and returns a result, the following way works fine:

DECLARE @var varchar (10)
EXEC @var = GetLinea '','','', '' , ''
SELECT @var

But when I want to fill the values ​​that I send by parameter with an CASEerror:

DECLARE @var varchar (10)
EXEC @var = GetLinea '', CASE WHEN '11' = '11' THEN 'SI' ELSE 'SI NO' END ,'', '' , ''
SELECT @var

The error that appears is:

Incorrect syntax near the keyword 'CASE'.

As if I was misusing the CASE.

The code that I pass is in test mode, I must execute the function in a view.

This is the true case, the others are tests I used

SELECT 
IdOferta, 
Location,
PRO, 
Toneladas, 
Espesor, 
Ancho, 


CASE WHEN Location<>''
        THEN 'MP_' + location
     WHEN CHARINDEX('PREPI', clase_desc)>0 Or CHARINDEX('CINCA', clase_desc)>0
        THEN 'REV_CA'
     ELSE 
        GetLinea
             parametro1,
             CASE WHEN Null = parametro2 THEN '' ELSE parametro2 END,
             CASE WHEN Null = parametro3 THEN '' ELSE parametro3 END,
             CASE WHEN Null = parametro4 THEN '' ELSE parametro4 END,
             parametro5
     END
AS Linea_Final

I am migrating a query from Access to SQL Server, the problem is that Access allows INNER JOIN in the UPDATE

UPDATE (Aux_Nodos INNER JOIN Nodos_NULL_Titular ON Aux_Nodos.Necesidad = Nodos_NULL_Titular.Necesidad)
INNER JOIN Out_Arcos ON Aux_Nodos.Id_Nodo = Out_Arcos.Id_Nodo_Destino 
SET Out_Arcos.Id_Nodo_Destino = Nodos_NULL_Titular.Id_Nodo

In StackOverFlow in English I saw that something like this had to be done, but it throws me an error

UPDATE dbo.Aux_Nodos SET Out_Arcos.Id_Nodo_Destino = Nodos_NULL_Titular.Id_Nodo
FROM Aux_Nodos 
INNER JOIN Nodos_NULL_Titular ON Aux_Nodos.Necesidad = Nodos_NULL_Titular.Necesidad
INNER JOIN Out_Arcos ON Aux_Nodos.Id_Nodo = Out_Arcos.Id_Nodo_Destino

The error that appears is "The multi-part identifier "dbo.Out_Arcos.Id_Nodo_Destino" could not be bound.", it does not recognize it in the SET, obviously that table and column exist.

I have for example this stored procedure

ALTER PROCEDURE dbo.PersonaDoc
@cDocumento varchar (20)
AS
SELECT Ruta_Line 
FROM Persona
WHERE (documento= @cDocumento)

What difference would it make to consume it in C# using ExecuteNonQuery, ExecuteScalar or ExecuteReader (depending on the case the values ​​you want to return) if the stored procedure is

ALTER PROCEDURE dbo.PersonaDoc
@cDocumento varchar (20)
@resultado int OUTPUT
AS
SELECT SET@resultado = nombre
FROM Persona
WHERE (documento= @cDocumento)

What is not clear to me is the difference between consuming the data that the stored procedure brings directly or using an output value for it, I suppose that in the first case the advantage would be that I can bring several values ​​and with the OUTPUT only one, but assuming i just want a return value is it the same?

I have this method to execute stored procedures

    public void EjecutarSP(string sp)
    {
        try
        {
            SqlCommand cmd = new SqlCommand(sp, ConexionBD.con);
            cmd.CommandType = CommandType.StoredProcedure;
            ConexionBD.Conectar();
            cmd.ExecuteNonQuery();
            ConexionBD.Desconectar();
        }
        catch (Exception ex)
        {
            throw new Exception(" Error al ejecutar procedimiento almacenado ", ex);
        }
    }

This method serves me generically when the stored procedures do not receive or return any value, I wanted to know if there is any way to make them generic for when the stored procedure receives and returns parameters, I think that for the return part I can use ExecuteReader that returns a table and then work on it in the application, but for the part of sending parameters I don't know if something generic can be done since not all stored procedures receive the same number of parameters

I have a check in the DataGridView, I wanted to know if it is possible that every time a value is added it automatically appears as checked

I have my application in C# , I need to be able to fill three fields in another application, I am using this code to raise the other application and send sendkeys

 [DllImport("user32.dll")]
        public static extern IntPtr FindWindow(string className, string windowTitle);

        [DllImport("user32.dll")]
        [return: MarshalAs(UnmanagedType.Bool)]
        static extern bool ShowWindow(IntPtr hWnd, ShowWindowEnum flags);

        [DllImport("user32.dll")]
        private static extern int SetForegroundWindow(IntPtr hwnd);

        [DllImport("user32.dll")]
        [return: MarshalAs(UnmanagedType.Bool)]
        static extern bool GetWindowPlacement(IntPtr hWnd, ref Windowplacement lpwndpl);

        private enum ShowWindowEnum
        {
            Hide = 0,
            ShowNormal = 1, ShowMinimized = 2, ShowMaximized = 3,
            Maximize = 3, ShowNormalNoActivate = 4, Show = 5,
            Minimize = 6, ShowMinNoActivate = 7, ShowNoActivate = 8,
            Restore = 9, ShowDefault = 10, ForceMinimized = 11
        };

        private struct Windowplacement
        {
            public int length;
            public int flags;
            public int showCmd;
            public System.Drawing.Point ptMinPosition;
            public System.Drawing.Point ptMaxPosition;
            public System.Drawing.Rectangle rcNormalPosition;
        }

        public void TraerVentanaAlFrente(string proceso)
        {
            IntPtr wdwIntPtr = FindWindow(null, proceso);

            //Obtener el hWnd del proceso
            Windowplacement placement = new Windowplacement();
            GetWindowPlacement(wdwIntPtr, ref placement);

            // Verificar si la ventana esta minimizada
            if (placement.showCmd == 2)
            {
                //Si la ventana esta minimizada restaurarla
                ShowWindow(wdwIntPtr, ShowWindowEnum.Restore);
            }

            //Hacer foco en la ventana
            SetForegroundWindow(wdwIntPtr);
        }

This part works fine, with the code I can raise and focus on the other application, the problem is that the other application has two different windows, and it always focuses on window 1 and I need it to focus on window 2

This is the error that appears on some computers when I run my application, I have the libraries SQLite.Interop.dlland System.Data.SQLite.dllin the same directory as the executable.

I also tried copying the two libraries to C:\windows\system32andC:\windows\SysWOW64

As references in the project I have System.Data.SQLite, I wanted to add the other one to test and it appears:

I am trying to make a connection from my local project to a SQL database that I made and uploaded to a server, the server gives me the connection string to use, but when I use open it throws me an error

 SqlConnection cn = new SqlConnection("workstation id=BDInstant.mssql.somee.com;packet size=4096;user id=XXXXXXX;pwd=XXXXXXX;data source=BDInstant.mssql.somee.com;persist security info=False;initial catalog=BDInstant");
cn.Open();

The error that appears to me is the following

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

When creating a Web Service with Asp.net C# I get the following

[WebService(Namespace = "http://tempuri.org/")]

Then when I'm using it it shows me the message:

This web service is using http://tempuri.org/ as its default namespace

Recommendation: Change the default namespace before the XML Web service is made public.

What is the function of namespace because I don't see that it varies at all to the web service. Is it necessary to change it, what should I put?

I wanted to know if it was possible to include the dll in the executable in such a way that everything is included in a single executable file in Visual Studio 2012 with C #

I have the following Database

CREATE TABLE [Request] (
[IDRequest] INTEGER PRIMARY KEY NOT NULL,
[RequestID] VARCHAR(10) NULL,
[ReceivedDate] VARCHAR(20) NULL,
[RequestStatus] VARCHAR(20) NULL,
[ExpirationStatus] VARCHAR(15) NULL,
[ResponseStatus] VARCHAR(20) NULL,
[StatusMessage] VARCHAR(20) NULL
)

To connect I use the following

private SQLiteConnection dbconnection;
        

        public DAOConexion (string directory)
        {
            this.dbconnection = new SQLiteConnection(@"Data Source=" + directory + ";Version=3;");
        }

        
        public void Connect()
        {
            dbconnection.Open();
        }

        public bool doInsert(string sql)
        {
            //Create and run the query
            SQLiteCommand sqlcommand = new SQLiteCommand(sql, dbconnection);

            if (sqlcommand.ExecuteNonQuery() > 1)
            {
                sqlcommand.Dispose();
                return false;
            }
            else
            {
                sqlcommand.Dispose();
                return true;
            }
        }

The implementation that I am using as a test is the following

conBD.doInsert ("INSERT INTO Request (RequestID, ReceivedDate, RequestStatus, ExpirationStatus ,ResponseStatus, StatusMessage)VALUES ('1', 'asd', '32', 'California', '20000.00', 'sadsa' );") ;

The problem is that it's throwing me

sqlite error

no such table: Request

The table is created and if I use the same query in the database it works.

I am trying to automate a web page using the gecko engine, it is similar to the webBrowser that Visual Studio has built-in. I am using the event

navegador.DocumentCompleted += (senderx, ex)=>

To wait for the page to complete, I'm fine with everything except an input that sometimes fills it for me and sometimes passes it by, I read it as follows

Gecko.DOM.GeckoInputElement input = (Gecko.DOM.GeckoInputElement)document.GetElementsByName("txtorderNo")[0];
input.SetAttribute("value", "aKl8_Sbl");
input.Value = "aKl8_Sbl";

To avoid skipping it I want to pause, the issue is that I'm having a problem with it, poor different things and nothing works for me

• The IsBusy and IsAjaxBusy methods always return false.
• The "System.Threading.Thread.Sleep" doesn't work for me because it slows down the loading of the browser so it's as if nothing

• Using this code makes me wait but I get the following error.

  {"Specified argument was out of the range of valid values.\r\nParameter name: index"}

  public void Esperar(int tiempo)
  {
      DateTime reloj = DateTime.Now;
      reloj = reloj.AddSeconds(tiempo);
  
      while (reloj > DateTime.Now)
      {
          Application.DoEvents();
      }
  }
  

• The other two that I use are these but they don't work for me either

      async Task Delay()
      {
          await Task.Delay(100000);
  
      }
  
      public void Wait(double seconds)
      {
          Timer timer = new Timer();
          timer.Interval = (int)(seconds * 1000);
          timer.Tick += (s, o) =>
          {
              timer.Enabled = false;
              timer.Dispose();
          };
          timer.Enabled = true;
      }
  

If anyone has an answer I hope you can help me, greetings

I'm navigating pages in VisualStudio 2012 with C#, the problem is that I can't tell when the page finished loading completely, it WebBrowserhas an event called DocumentCompletedbut it goes through that event several times before it finishes loading the page.

Is there a way to know when the page is fully loaded?