Avatar of LessIsMore
LessIsMore
Flag for United States of America asked on

insert IPAddress into SQL server through detailsview

I need to collect user IP addresses. I cannot figure out what to put into template field TextBox of DetailsView to insert the IP addresses into SQL server.

Dim hostname As String = Server.HtmlEncode(Request.UserHostName)    

Here is the DetailsView and Insert command
 InsertCommand="INSERT INTO [table] ([IPAddress]) VALUES (@IPAddress)"
          <InsertParameters>
              <asp:Parameter Name="IPAddress" Type="String" />
          </InsertParameters>

          <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False"
                  DataKeyNames="ID" DataSourceID="SqlDataSource1" DefaultMode="Insert"
                  EnableModelValidation="True" Height="50px" Width="125px">
                  <Fields>
                      <asp:TemplateField HeaderText="IPAddress" SortExpression="IPAddress">
                          <EditItemTemplate>
                              <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("IPAddress") %>'></asp:TextBox>
                          </EditItemTemplate>
                          <InsertItemTemplate>                        
   <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("IPAddress")">'/>                  
                            </InsertItemTemplate>
                          <ItemTemplate>
                              <asp:Label ID="Label1" runat="server" Text='<%# Bind("IPAddress") %>'></asp:Label>
                          </ItemTemplate>
                      </asp:TemplateField>
                      <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
                          ReadOnly="True" SortExpression="ID" />
                      <asp:CommandField ShowInsertButton="True" />
                  </Fields>
              </asp:DetailsView>
              <br />
ASP.NETMicrosoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
LessIsMore

8/22/2022 - Mon
Salah Eddine ELMRABET

Hi,

Your question is confused!! you want to collect the IP addresses witch mean query the SQL? or you want to update the IPs by insert??

Regards.

Salah
LessIsMore

ASKER
I am collecting IP addresses from users of aspx page and need to insert it into table.
Salah Eddine ELMRABET

Hi,

You mean you want to collect the IP addresses used by users when they access your ASP page?? if it's the case you need to code a script that will get the IP from users sessions and insert it to the SQL!

The example you provide is a form with text boxes witch mean, the IP values will be filled in the page and then inserted to the databse!

Please explain well your need.

Regards.

Salah
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
LessIsMore

ASKER
I get IP value with the first line of code. I just need the way to use this value in detailview to submit it to sql server table. I might not use detailsview but do not know how to use it in sql insert statement.
LessIsMore

ASKER
Here is the logic.
My user goes to the page. I am capturing his IP address by .
Dim hostname As String = Server.HtmlEncode(Request.UserHostName)    

 How to insert hostname in SQL server?
Salah Eddine ELMRABET

Hi,

Here is a sample where "Colums1" correpond to Hostname colums in your table and "hostname" is your variable defined by Dim:

Set objConn = ConnectDB()
    query       = "INSERT INTO table (Colums1,Colums2,Colums3,Columsx) VALUES ('"& hostname &"','"& variable2 &"','"& variable3 &"','"& variablex &"')"
    Set objs    = objConn.Execute(query)

Regards.

Salah
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
LessIsMore

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Salah Eddine ELMRABET

Hi,

This was just an example which you need to adapt to you script coding page, you can display the result first in the page in order to make sure the variable and script is providing output result correctly then change the code to insert values into DB with proper connection parameters you are working with.

Meanwhile, if your problem was solved please close the question.

Regards.

Salah
LessIsMore

ASKER
The provided by experts solutions did not work for me.