如何在数据库中添加IP? [英] how can i add ip in my data base?

问题描述

你好朋友，


我有一个问题，我有两个文本框，一个是startno，另一个是endno
我想在这些文本框中插入ip，然后单击添加"按钮，然后在数据库中添加所有IP，例如从[1.1.1.1]到[1.1.1.5]，然后单击添加所有ip形式1至5在数据库中.

我找到了最后一位数字，并且正在使用for循环，但是我不知道如何在ipno中递增，任何人都可以引导我吗?

hello friend,


i have an problem i have two textbox one is startno and another is endno
and i want insert ip in these text box and when i am click on add button then add all ip in my database for example from [1.1.1.1] to [1.1.1.5] and when on click on add all ip form 1 to 5 in the database.

i am find the last digit and i am using for loop but i dont know how can i increment in ipno can any one guide me??

推荐答案

假设您的文本框中包含完整的IP地址:"nnnn"，那么首先要做的就是将它们从字符串转换为可以使用的IP地址.为此有一个.NET方法: IPAddress.解析方法 [ ^ ]

Assuming that your text box contains complete IP addresses: "n.n.n.n" then the first thing to do is convert them from strings to IP addresses you can work with. There is a .NET method for this: IPAddress.Parse Method[^]

string s = "1.1.1.2";
IPAddress i = IPAddress.Parse(s);
byte[] bytes = i.GetAddressBytes();
for (int count = 0; count < 5; count++)
    {
    bytes[3]++;
    i = new IPAddress(bytes);
    Console.WriteLine(i.ToString());
    }

感谢格里夫，我的问题是解决，我正在使用此

thank griff my problem is solve i am using this

<pre lang="cs">string myString = Txtfrom.Text.ToString();<br />
       char[] separator = new char[] { ''.'' };<br />
       string[] colorList = myString.Split(separator);</pre><br />

多亏了 OriginalGriff 这部分，完整/动态的解决方案是:

Hi,

Thanks to OriginalGriff for the part, the complete / dynamic solution would be:

string address1 = "192.168.1.1";
string address2 = "192.168.5.254";

IPAddress startAddress = IPAddress.Parse(address1);
IPAddress endAddress = IPAddress.Parse(address2);

byte[] startAdrArr = startAddress.GetAddressBytes();
byte[] endAdrArr = endAddress.GetAddressBytes();

for (byte octet1 = startAdrArr[0]; octet1 <= endAdrArr[0]; octet1++)
{
	for (byte octet2 = startAdrArr[1]; octet2 <= endAdrArr[1]; octet2++)
	{
		for (byte octet3 = startAdrArr[2]; octet3 <= endAdrArr[2]; octet3++)
		{
			for (byte octet4 = startAdrArr[3]; octet4 <= endAdrArr[3]; octet4++)
			{
				string currentAddress = string.Format(
								CultureInfo.CurrentCulture,
								"{0}.{1}.{2}.{3}",
								octet1,
								octet2,
								octet3,
								octet4);
				/* process the address */
			}
		}
	}
}

希望对任何人有帮助:)

致以诚挚的问候，祝您编程愉快，
停止

Hope this helps anyone :)

Best regards and happy coding,
Stops

这篇关于如何在数据库中添加IP?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！