Alexis Gonzalez's questions

I have the following Trigger, what happens is that when wanting to retrieve the IP of the client machine, it takes the IP of the Application Server, someone who can help with a way to retrieve that IP, not the one of the application server.

ALTER trigger [dbo].[InsertLoginControl]
on [dbo].[Attendance]
for insert 
as

declare @noEmpleado varchar(5)
DECLARE @IP_Address varchar(255)
declare @name varchar(50)
declare @pass varchar(50)
declare @LastCon datetime

select top 1 @noEmpleado = EmpNo from Attendance order by idAttendance desc

SELECT @IP_Address = 
convert(varchar(20),CONNECTIONPROPERTY('client_net_address'))
select top 1 @name = NameDisplay from Login_empl where 
EmployeeNo=@noEmpleado
select top 1 @pass = UserPAss from Login where Emp_Number=@noEmpleado

select top 1 @LastCon=DateLogout from logincontrol where 
empNumber=@noEmpleado order by id desc

if exists(select empNumber from LoginControl where empNumber= @noEmpleado) 
begin 

if(@LastCon is null)
begin
    update LoginControl set DateLogout=getdate() where empNumber=@noEmpleado
    insert into LoginControl 
 values(@IP_Address,getdate(),null,@noEmpleado,@name,
ENCRYPTBYPASSPHRASE('BCPPlus2019', @pass))
end

else
begin
    insert into LoginControl 
 values(@IP_Address,getdate(),null,@noEmpleado,@name,
ENCRYPTBYPASSPHRASE('BCPPlus2019', @pass))
end

end
else
begin 

    insert into LoginControl 
values(@IP_Address,getdate(),null,@noEmpleado,@name, 
ENCRYPTBYPASSPHRASE('BCPPlus2019', @pass))

end

I have a project but it is in Windows Form and I am a beginner in that environment. I have the following code to try to read data from an RFID proximity card reader and show the ID of said card in a textbox, the reader is connected by USB, I would like to know if someone can help me.

    namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {

        private SerialPort RFID;

        public Form1()
        {
            InitializeComponent();

            SerialPort serialPort = new SerialPort();
            RFID = serialPort;
            RFID.PortName = "COM1";
            RFID.BaudRate = 9600;
            RFID.DataBits = 8;
            RFID.Parity = Parity.None;
            RFID.StopBits = StopBits.One;
            RFID.Open();
            RFID.DataReceived += new SerialDataReceivedEventHandler(RFID_DataReceived);
            prueba();
        }


        private void prueba()
        {
            textBox2.Text = "test";
        }

        private void RFID_DataReceived(object sender, SerialDataReceivedEventArgs e)
        {
            MessageBox.Show("Inica Componentes");
            string data = RFID.ReadExisting();
            textBox2 .Text = "77777";
        }

       }
    }

Today I come with this question, in a project that works with ASP.net, classic ASP I use the following code to open a secondary window of ASP.net

dim strSearch  : strSearch  = request.querystring("search")
pick = " onclick='window.open('/dana/Proyectall/Engineering/form_PickList/Default.aspx?WorkOrder=" &work&"&Assembly="&strSearch& "','', 'scrollbars=yes,width=1500px,height=900px,return false,resizable=YES');'"

The problem is that, for example, when I access the interface by IP "192.168.1.120" everything is displayed fine but when I access by domain it blocks many things or does not take them into account (it does not show scrollbars, they cannot modify the size of the window , the navigation bar disappears), none of this happens when I access by IP. Any idea why the above happens?

I have this little inconvenience. In a program that I am modifying, 2 parameters are sent as a QueryString and they are retrieved.

dim WorkOrder  : WorkOrder  = request.querystring("workorder")
dim CustomerPO : CustomerPO = request.querystring("customerpo")

I want that when clicking a search button these variables disappear or leave them as empty string(""). I'm trying to use javascript to do this, to detect when that button is pressed:

response.write vbcrlf & "</script>"
response.write vbcrlf & "function recibir(){"
response.write vbcrlf & " var prueba = 
document.getElementById('txtWorkOrder').value;"
response.write vbcrlf & "console.log(prueba);"
response.write vbcrlf & "}"
response.write vbcrlf & "</script>"

but I don't have much experience with classic ASP, can someone help me? Thank you

my problem is that I have a form in ASP.NET in VB and I have events declared in that program, now I need to know how to execute those events from javascript. visual event

Protected Sub Cargar()
PanelSearch.Visible = False
End Sub

javascript:

Function CargarDatos(){
document.getElementById("Button1").click();
};

The javascript code works for me but only when the "button1 is visible and as you can see I need to hide it, and when I hide it it no longer works. And it has to be that way because I need it to work with the javascript. Thanks for your time.

I have problems with a form in ASP.net in VB, this form created dynamic texboxes and I have a button to add the textboxes. Now this button when adding the new textbox row saves what has a row before in the DB. Now the question is how can I make it so that when I press the "Enter" key, it executes the onclick event of my button. I tried the DefaultButton property but it only works when the page is refreshed, after clicking on another part of the interface it stops working. I've seen that it can be recognized when the "Enter" key is pressed from javascript, but I don't know how to execute the event code.

That is the code that I have in the botton the name of the event is "AddTextBox" in the Onclick event

    <asp:Button ID="btnAdd" runat="server" Text="Add and Save " 
OnClick="AddTextBox" />  

This would be the CodeBing that contains this button

Protected Sub AddTextBox(sender As Object, e As EventArgs)
    'primer panel'
    Dim index As Integer = PNLNoNotes.Controls.OfType(Of TextBox)().ToList().Count + 1 'crea una lista que contendra los nombres de los txt dinamicos de panel 1
    Me.CreateTextBox("txtPnl1" & index) 'txtPnl1 es el nombre de los txt del panel 1
    For Each textBox As TextBox In PNLNoNotes.Controls.OfType(Of TextBox)()
        If (textBox.ID = "txtPnl1" + Convert.ToString(index)) Then
            textBox.Text = index
            algo = index
        End If
    Next
RecuperarDatos(index)
end sub

Ok now I need to know how I can 1st, detect when the "Enter" key is pressed and secondly know how to call or execute this event when the "Enter" key is pressed