473,671 Members | 2,430 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Setting listbox items

I have a string that I read from my database: 1|8|5620|541

These are all values in my ListBox. I want to select each of these items (4
of them - but could be many more). At the moment I am doing the following:

Dim a() As String
Dim j As Integer
a = JobCategoriesSe lected.Split("| ") ' Where
JobCategoriesSe lected is set to 1|8|5620|541
For j = 0 To a.GetUpperBound (0)
trace.warn("str ing = " & a(j))
for each item as ListItem in JobCategories.i tems
if item.value = a(j) then
item.selected = true
end if
next
Next

The problem is that for each Item I am selecting, I am having to go through
the list to find the value that matches the one I want to set. In this
case, it would have to go through the list 4 times.

Is there some kind of a way to do it in one line where you say something
like set the listitem that is equal to my value to selected?

Thanks,

Tom
Nov 19 '05 #1
8 1888


dim item as ListItem = jobCategories.I Tems.FindbyValu e(a(j))
if not item is nothing then
item.selected = true
end if
Btw, why bother using a relationa database (assuming) if you are gonna use
values which are split like that?

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl...
I have a string that I read from my database: 1|8|5620|541

These are all values in my ListBox. I want to select each of these items (4 of them - but could be many more). At the moment I am doing the following:
Dim a() As String
Dim j As Integer
a = JobCategoriesSe lected.Split("| ") ' Where
JobCategoriesSe lected is set to 1|8|5620|541
For j = 0 To a.GetUpperBound (0)
trace.warn("str ing = " & a(j))
for each item as ListItem in JobCategories.i tems
if item.value = a(j) then
item.selected = true
end if
next
Next

The problem is that for each Item I am selecting, I am having to go through the list to find the value that matches the one I want to set. In this
case, it would have to go through the list 4 times.

Is there some kind of a way to do it in one line where you say something
like set the listitem that is equal to my value to selected?

Thanks,

Tom

Nov 19 '05 #2
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:e8******** ******@TK2MSFTN GP09.phx.gbl...


dim item as ListItem = jobCategories.I Tems.FindbyValu e(a(j))
if not item is nothing then
item.selected = true
end if

I knew there was a better way.

Btw, why bother using a relationa database (assuming) if you are gonna use
values which are split like that?
What I am doing is storing the string in a field that shows which choices
the user made to a ListBox (could have many). I am collecting the values
and separating them by "|". The Job Categories are themselves in a table
("text and value"). But each user can have many search records (each of
which can have a different set of Job Categories). This seemed like the
best way to save it.

Thanks,

Tom
Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl...
I have a string that I read from my database: 1|8|5620|541

These are all values in my ListBox. I want to select each of these items

(4
of them - but could be many more). At the moment I am doing the

following:

Dim a() As String
Dim j As Integer
a = JobCategoriesSe lected.Split("| ") ' Where
JobCategoriesSe lected is set to 1|8|5620|541
For j = 0 To a.GetUpperBound (0)
trace.warn("str ing = " & a(j))
for each item as ListItem in JobCategories.i tems
if item.value = a(j) then
item.selected = true
end if
next
Next

The problem is that for each Item I am selecting, I am having to go

through
the list to find the value that matches the one I want to set. In this
case, it would have to go through the list 4 times.

Is there some kind of a way to do it in one line where you say something
like set the listitem that is equal to my value to selected?

Thanks,

Tom


Nov 19 '05 #3
Seems like a join table is the best way
UserId, JobId

1,1
1,3
1,5
2,4
5,1
5,6

....

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:Os******** ******@tk2msftn gp13.phx.gbl...
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:e8******** ******@TK2MSFTN GP09.phx.gbl...


dim item as ListItem = jobCategories.I Tems.FindbyValu e(a(j))
if not item is nothing then
item.selected = true
end if


I knew there was a better way.

Btw, why bother using a relationa database (assuming) if you are gonna use values which are split like that?


What I am doing is storing the string in a field that shows which choices
the user made to a ListBox (could have many). I am collecting the values
and separating them by "|". The Job Categories are themselves in a table
("text and value"). But each user can have many search records (each of
which can have a different set of Job Categories). This seemed like the
best way to save it.

Thanks,

Tom

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl...
I have a string that I read from my database: 1|8|5620|541

These are all values in my ListBox. I want to select each of these items
(4
of them - but could be many more). At the moment I am doing the

following:

Dim a() As String
Dim j As Integer
a = JobCategoriesSe lected.Split("| ") ' Where
JobCategoriesSe lected is set to 1|8|5620|541
For j = 0 To a.GetUpperBound (0)
trace.warn("str ing = " & a(j))
for each item as ListItem in JobCategories.i tems
if item.value = a(j) then
item.selected = true
end if
next
Next

The problem is that for each Item I am selecting, I am having to go

through
the list to find the value that matches the one I want to set. In this
case, it would have to go through the list 4 times.

Is there some kind of a way to do it in one line where you say

something like set the listitem that is equal to my value to selected?

Thanks,

Tom



Nov 19 '05 #4

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:eO******** *****@TK2MSFTNG P10.phx.gbl...
Seems like a join table is the best way
You lost me on that one.

What I am doing is allowing the user to save different types of searches
based on Job Categorys, Dates, Zip codes etc. They can save this in a
table. One record for each search they want to save. They may want to save
10 different searches so that they don't have to keep putting in all the
different search criteria each time they come back.

One of the search criterea is Job Categories, which they pick from a list
box which as the name of the Job Category as well as the value (which is a
numeric value).

So if they pick 10 different Criteria, I need to store those numbers
somewhere. So I just put the numbers together in a string separated by "|".

When they come back to run another search, they can pick from their stored
searches and I then need to get all the ten (or however many categories
they picked) categories and use them in the search.

Thanks,

Tom

UserId, JobId

1,1
1,3
1,5
2,4
5,1
5,6

...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:Os******** ******@tk2msftn gp13.phx.gbl...
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:e8******** ******@TK2MSFTN GP09.phx.gbl...
>
>
> dim item as ListItem = jobCategories.I Tems.FindbyValu e(a(j))
> if not item is nothing then
> item.selected = true
> end if
>


I knew there was a better way.
>
> Btw, why bother using a relationa database (assuming) if you are gonna use > values which are split like that?


What I am doing is storing the string in a field that shows which choices
the user made to a ListBox (could have many). I am collecting the values
and separating them by "|". The Job Categories are themselves in a table
("text and value"). But each user can have many search records (each of
which can have a different set of Job Categories). This seemed like the
best way to save it.

Thanks,

Tom
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind.net/ - New and Improved (yes, the popup is
> annoying)
> http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
> come!)
> "tshad" <ts**********@f tsolutions.com> wrote in message
> news:OX******** ******@tk2msftn gp13.phx.gbl...
>> I have a string that I read from my database: 1|8|5620|541
>>
>> These are all values in my ListBox. I want to select each of these items > (4
>> of them - but could be many more). At the moment I am doing the
> following:
>>
>> Dim a() As String
>> Dim j As Integer
>> a = JobCategoriesSe lected.Split("| ") ' Where
>> JobCategoriesSe lected is set to 1|8|5620|541
>> For j = 0 To a.GetUpperBound (0)
>> trace.warn("str ing = " & a(j))
>> for each item as ListItem in JobCategories.i tems
>> if item.value = a(j) then
>> item.selected = true
>> end if
>> next
>> Next
>>
>> The problem is that for each Item I am selecting, I am having to go
> through
>> the list to find the value that matches the one I want to set. In
>> this
>> case, it would have to go through the list 4 times.
>>
>> Is there some kind of a way to do it in one line where you say something >> like set the listitem that is equal to my value to selected?
>>
>> Thanks,
>>
>> Tom
>>
>>
>
>



Nov 19 '05 #5
Tom:
Not sure how else to explain it...

If user1 can have his search 1 which has job 1, 4, 5 and 6
user 1 can have his search 2 which has jobs 1, 2 and 3

user2 can have her search 1 which has jobs 3

user 7 can have her search 3 which has jobs 1,3
user 7 can have her search 2 which has jobs 4,5
I'd do a table with 3 columns:

UserId, SearchId, JobId
//first case
1, 1, 1
1, 1, 4
1, 1, 5
1, 1, 6
//second case
1,2,1
1,2,2
1,2,3
//third case
2,1,3
//forth case
7,3,1
7,3,3
//fifth case
7,2,4
7,2,5

then when you say, "I want all the jobs for user 7 for the her 3rd saved
search", you do:

select JobId from UserSearchJob
where UserId = 7 and SearchId = 3

and you end up with
1
3

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:eu******** ******@TK2MSFTN GP12.phx.gbl...

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:eO******** *****@TK2MSFTNG P10.phx.gbl...
Seems like a join table is the best way
You lost me on that one.

What I am doing is allowing the user to save different types of searches
based on Job Categorys, Dates, Zip codes etc. They can save this in a
table. One record for each search they want to save. They may want to

save 10 different searches so that they don't have to keep putting in all the
different search criteria each time they come back.

One of the search criterea is Job Categories, which they pick from a list
box which as the name of the Job Category as well as the value (which is a
numeric value).

So if they pick 10 different Criteria, I need to store those numbers
somewhere. So I just put the numbers together in a string separated by "|".
When they come back to run another search, they can pick from their stored
searches and I then need to get all the ten (or however many categories
they picked) categories and use them in the search.

Thanks,

Tom


UserId, JobId

1,1
1,3
1,5
2,4
5,1
5,6

...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:Os******** ******@tk2msftn gp13.phx.gbl...
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:e8******** ******@TK2MSFTN GP09.phx.gbl...
>
>
> dim item as ListItem = jobCategories.I Tems.FindbyValu e(a(j))
> if not item is nothing then
> item.selected = true
> end if
>

I knew there was a better way.

>
> Btw, why bother using a relationa database (assuming) if you are gonna
use
> values which are split like that?

What I am doing is storing the string in a field that shows which

choices the user made to a ListBox (could have many). I am collecting the values and separating them by "|". The Job Categories are themselves in a table ("text and value"). But each user can have many search records (each of which can have a different set of Job Categories). This seemed like the best way to save it.

Thanks,

Tom
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind.net/ - New and Improved (yes, the popup is
> annoying)
> http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to > come!)
> "tshad" <ts**********@f tsolutions.com> wrote in message
> news:OX******** ******@tk2msftn gp13.phx.gbl...
>> I have a string that I read from my database: 1|8|5620|541
>>
>> These are all values in my ListBox. I want to select each of these

items
> (4
>> of them - but could be many more). At the moment I am doing the
> following:
>>
>> Dim a() As String
>> Dim j As Integer
>> a = JobCategoriesSe lected.Split("| ") ' Where
>> JobCategoriesSe lected is set to 1|8|5620|541
>> For j = 0 To a.GetUpperBound (0)
>> trace.warn("str ing = " & a(j))
>> for each item as ListItem in JobCategories.i tems
>> if item.value = a(j) then
>> item.selected = true
>> end if
>> next
>> Next
>>
>> The problem is that for each Item I am selecting, I am having to go
> through
>> the list to find the value that matches the one I want to set. In
>> this
>> case, it would have to go through the list 4 times.
>>
>> Is there some kind of a way to do it in one line where you say

something
>> like set the listitem that is equal to my value to selected?
>>
>> Thanks,
>>
>> Tom
>>
>>
>
>



Nov 19 '05 #6
I thought that was what you meant. The problem is why have all those
records suppose each search option has 15 Job Categories. That's a lot of
records just to handle one field and a lot more work for Sql to do.

Maybe, you are thinking that there is only one field in the record.

Actually, the whole records is:

CREATE TABLE [dbo].[Searches] (
[ClientID] [varchar] (20) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL ,
[email] [varchar] (45) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[SearchID] [int] IDENTITY (1, 1) NOT NULL ,
[SearchName] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[KeyWords] [varchar] (80) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL ,
[EmailNewJobs] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[EmailNewJobsAdd ress] [varchar] (45) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS
NULL ,
[EmailNewJobsFre quency] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS
NULL ,
[CompanyName] [varchar] (45) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[FullTime] [bit] NULL ,
[PartTime] [bit] NULL ,
[Temporary] [bit] NULL ,
[Contract] [bit] NULL ,
[Seasonal] [bit] NULL ,
[WagesMin] [money] NULL ,
[WagesMax] [money] NULL ,
[WagesType] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByState] [varchar] (3) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByCity] [varchar] (30) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[Miles] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ZipCode] [varchar] (9) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByKeyword] [bit] NULL ,
[ByDate] [bit] NULL ,
[ByWages] [bit] NULL ,
[ViewBrief] [bit] NULL ,
[ViewDetailed] [bit] NULL ,
[JobCategories] [varchar] (8000) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL
,
[DatePosted] [datetime] NULL ,
[DateModified] [datetime] NULL
) ON [PRIMARY]

This would mean that if you have 10 Job categories you have 10 identical
records, except for the one field. An awful lot of wasted space (I would
think). Maybe I'm wrong.

I assume you are normalizing the table.

Tom

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
Tom:
Not sure how else to explain it...

If user1 can have his search 1 which has job 1, 4, 5 and 6
user 1 can have his search 2 which has jobs 1, 2 and 3

user2 can have her search 1 which has jobs 3

user 7 can have her search 3 which has jobs 1,3
user 7 can have her search 2 which has jobs 4,5
I'd do a table with 3 columns:

UserId, SearchId, JobId
//first case
1, 1, 1
1, 1, 4
1, 1, 5
1, 1, 6
//second case
1,2,1
1,2,2
1,2,3
//third case
2,1,3
//forth case
7,3,1
7,3,3
//fifth case
7,2,4
7,2,5

then when you say, "I want all the jobs for user 7 for the her 3rd saved
search", you do:

select JobId from UserSearchJob
where UserId = 7 and SearchId = 3

and you end up with
1
3

Karl

--
MY ASP.Net tutorials
http://www.openmymind. net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:eu******** ******@TK2MSFTN GP12.phx.gbl...

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:eO******** *****@TK2MSFTNG P10.phx.gbl...
> Seems like a join table is the best way


You lost me on that one.

What I am doing is allowing the user to save different types of searches
based on Job Categorys, Dates, Zip codes etc. They can save this in a
table. One record for each search they want to save. They may want to

save
10 different searches so that they don't have to keep putting in all the
different search criteria each time they come back.

One of the search criterea is Job Categories, which they pick from a list
box which as the name of the Job Category as well as the value (which is
a
numeric value).

So if they pick 10 different Criteria, I need to store those numbers
somewhere. So I just put the numbers together in a string separated by

"|".

When they come back to run another search, they can pick from their
stored
searches and I then need to get all the ten (or however many categories
they picked) categories and use them in the search.

Thanks,

Tom
>
>
> UserId, JobId
>
> 1,1
> 1,3
> 1,5
> 2,4
> 5,1
> 5,6
>
> ...
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind. net/ - New and Improved (yes, the popup is
> annoying)
> http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ (more to
> come!)
> "tshad" <ts**********@f tsolutions.com> wrote in message
> news:Os******** ******@tk2msftn gp13.phx.gbl...
>> "Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME
>> net>
>> wrote in message news:e8******** ******@TK2MSFTN GP09.phx.gbl...
>> >
>> >
>> > dim item as ListItem = jobCategories.I Tems.FindbyValu e(a(j))
>> > if not item is nothing then
>> > item.selected = true
>> > end if
>> >
>>
>> I knew there was a better way.
>>
>> >
>> > Btw, why bother using a relationa database (assuming) if you are gonna > use
>> > values which are split like that?
>>
>> What I am doing is storing the string in a field that shows which choices >> the user made to a ListBox (could have many). I am collecting the values >> and separating them by "|". The Job Categories are themselves in a table >> ("text and value"). But each user can have many search records (each of >> which can have a different set of Job Categories). This seemed like the >> best way to save it.
>>
>> Thanks,
>>
>> Tom
>> >
>> > Karl
>> >
>> > --
>> > MY ASP.Net tutorials
>> > http://www.openmymind. net/ - New and Improved (yes, the popup is
>> > annoying)
>> > http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ (more to >> > come!)
>> > "tshad" <ts**********@f tsolutions.com> wrote in message
>> > news:OX******** ******@tk2msftn gp13.phx.gbl...
>> >> I have a string that I read from my database: 1|8|5620|541
>> >>
>> >> These are all values in my ListBox. I want to select each of these
> items
>> > (4
>> >> of them - but could be many more). At the moment I am doing the
>> > following:
>> >>
>> >> Dim a() As String
>> >> Dim j As Integer
>> >> a = JobCategoriesSe lected.Split("| ") ' Where
>> >> JobCategoriesSe lected is set to 1|8|5620|541
>> >> For j = 0 To a.GetUpperBound (0)
>> >> trace.warn("str ing = " & a(j))
>> >> for each item as ListItem in JobCategories.i tems
>> >> if item.value = a(j) then
>> >> item.selected = true
>> >> end if
>> >> next
>> >> Next
>> >>
>> >> The problem is that for each Item I am selecting, I am having to go
>> > through
>> >> the list to find the value that matches the one I want to set. In
>> >> this
>> >> case, it would have to go through the list 4 times.
>> >>
>> >> Is there some kind of a way to do it in one line where you say
> something
>> >> like set the listitem that is equal to my value to selected?
>> >>
>> >> Thanks,
>> >>
>> >> Tom
>> >>
>> >>
>> >
>> >
>>
>>
>
>



Nov 19 '05 #7
Tshad...
I didn't look at your table. I just wanted to offer an alternative. The old
saying I've used is "Normalize 'til it hurts, denormalize 'til it works".
Your space conerns are certainly valid...and if that's what drove your
design decision, it's very valid. However, unless you can draw from similar
past experience, you typically shouldn't assume. It's far better to start
off with cleaner code and improve it as your testing/profiling indicates,
than start off with an "optimized" version which is less readable and who's
value you never really know.

I have no doubt that your solution, while seemingly very efficient, is far
uglier and difficult to maintain. Not knowing your system, I'll leave it to
you to figure out what tradeoffs are necessary, but I certainly hope that
you'll go through due deligence and not make assumptions. Every day of my
life lately I'm stuck in a world where someone else made decisions based on
assumptions which (a) proved to be uterly flawed and (b) resulted in
millions of dollars worth of code being thrown out.

I certainly don't wish to preach or come off sounding all high and mighty.
But the cost of hard of the extra hard drive room probably equals about 4
hours of your salary.....it's pretty obvious which should be the driving
factor between maintainabilty and disk usage...(again, these rules certainly
have valid exceptions....)

Cheers!
Catch you on the flip side (I don't know what that means)

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:ei******** ******@TK2MSFTN GP10.phx.gbl...
I thought that was what you meant. The problem is why have all those
records suppose each search option has 15 Job Categories. That's a lot of
records just to handle one field and a lot more work for Sql to do.

Maybe, you are thinking that there is only one field in the record.

Actually, the whole records is:

CREATE TABLE [dbo].[Searches] (
[ClientID] [varchar] (20) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL ,
[email] [varchar] (45) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[SearchID] [int] IDENTITY (1, 1) NOT NULL ,
[SearchName] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[KeyWords] [varchar] (80) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL ,
[EmailNewJobs] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[EmailNewJobsAdd ress] [varchar] (45) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS
NULL ,
[EmailNewJobsFre quency] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS
NULL ,
[CompanyName] [varchar] (45) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[FullTime] [bit] NULL ,
[PartTime] [bit] NULL ,
[Temporary] [bit] NULL ,
[Contract] [bit] NULL ,
[Seasonal] [bit] NULL ,
[WagesMin] [money] NULL ,
[WagesMax] [money] NULL ,
[WagesType] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByState] [varchar] (3) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByCity] [varchar] (30) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[Miles] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ZipCode] [varchar] (9) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByKeyword] [bit] NULL ,
[ByDate] [bit] NULL ,
[ByWages] [bit] NULL ,
[ViewBrief] [bit] NULL ,
[ViewDetailed] [bit] NULL ,
[JobCategories] [varchar] (8000) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[DatePosted] [datetime] NULL ,
[DateModified] [datetime] NULL
) ON [PRIMARY]

This would mean that if you have 10 Job categories you have 10 identical
records, except for the one field. An awful lot of wasted space (I would
think). Maybe I'm wrong.

I assume you are normalizing the table.

Tom

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
Tom:
Not sure how else to explain it...

If user1 can have his search 1 which has job 1, 4, 5 and 6
user 1 can have his search 2 which has jobs 1, 2 and 3

user2 can have her search 1 which has jobs 3

user 7 can have her search 3 which has jobs 1,3
user 7 can have her search 2 which has jobs 4,5
I'd do a table with 3 columns:

UserId, SearchId, JobId
//first case
1, 1, 1
1, 1, 4
1, 1, 5
1, 1, 6
//second case
1,2,1
1,2,2
1,2,3
//third case
2,1,3
//forth case
7,3,1
7,3,3
//fifth case
7,2,4
7,2,5

then when you say, "I want all the jobs for user 7 for the her 3rd saved
search", you do:

select JobId from UserSearchJob
where UserId = 7 and SearchId = 3

and you end up with
1
3

Karl

--
MY ASP.Net tutorials
http://www.openmymind. net/ - New and Improved (yes, the popup is annoying) http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:eu******** ******@TK2MSFTN GP12.phx.gbl...

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:eO******** *****@TK2MSFTNG P10.phx.gbl...
> Seems like a join table is the best way

You lost me on that one.

What I am doing is allowing the user to save different types of searches based on Job Categorys, Dates, Zip codes etc. They can save this in a
table. One record for each search they want to save. They may want to

save
10 different searches so that they don't have to keep putting in all the different search criteria each time they come back.

One of the search criterea is Job Categories, which they pick from a list box which as the name of the Job Category as well as the value (which is a
numeric value).

So if they pick 10 different Criteria, I need to store those numbers
somewhere. So I just put the numbers together in a string separated by

"|".

When they come back to run another search, they can pick from their
stored
searches and I then need to get all the ten (or however many categories they picked) categories and use them in the search.

Thanks,

Tom
>
>
> UserId, JobId
>
> 1,1
> 1,3
> 1,5
> 2,4
> 5,1
> 5,6
>
> ...
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind. net/ - New and Improved (yes, the popup is
> annoying)
> http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ (more to > come!)
> "tshad" <ts**********@f tsolutions.com> wrote in message
> news:Os******** ******@tk2msftn gp13.phx.gbl...
>> "Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME
>> net>
>> wrote in message news:e8******** ******@TK2MSFTN GP09.phx.gbl...
>> >
>> >
>> > dim item as ListItem = jobCategories.I Tems.FindbyValu e(a(j))
>> > if not item is nothing then
>> > item.selected = true
>> > end if
>> >
>>
>> I knew there was a better way.
>>
>> >
>> > Btw, why bother using a relationa database (assuming) if you are

gonna
> use
>> > values which are split like that?
>>
>> What I am doing is storing the string in a field that shows which

choices
>> the user made to a ListBox (could have many). I am collecting the

values
>> and separating them by "|". The Job Categories are themselves in a

table
>> ("text and value"). But each user can have many search records (each
of
>> which can have a different set of Job Categories). This seemed like

the
>> best way to save it.
>>
>> Thanks,
>>
>> Tom
>> >
>> > Karl
>> >
>> > --
>> > MY ASP.Net tutorials
>> > http://www.openmymind. net/ - New and Improved (yes, the popup is
>> > annoying)
>> > http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ
(more to
>> > come!)
>> > "tshad" <ts**********@f tsolutions.com> wrote in message
>> > news:OX******** ******@tk2msftn gp13.phx.gbl...
>> >> I have a string that I read from my database: 1|8|5620|541
>> >>
>> >> These are all values in my ListBox. I want to select each of

these > items
>> > (4
>> >> of them - but could be many more). At the moment I am doing the
>> > following:
>> >>
>> >> Dim a() As String
>> >> Dim j As Integer
>> >> a = JobCategoriesSe lected.Split("| ") ' Where
>> >> JobCategoriesSe lected is set to 1|8|5620|541
>> >> For j = 0 To a.GetUpperBound (0)
>> >> trace.warn("str ing = " & a(j))
>> >> for each item as ListItem in JobCategories.i tems
>> >> if item.value = a(j) then
>> >> item.selected = true
>> >> end if
>> >> next
>> >> Next
>> >>
>> >> The problem is that for each Item I am selecting, I am having to go >> > through
>> >> the list to find the value that matches the one I want to set. In >> >> this
>> >> case, it would have to go through the list 4 times.
>> >>
>> >> Is there some kind of a way to do it in one line where you say
> something
>> >> like set the listitem that is equal to my value to selected?
>> >>
>> >> Thanks,
>> >>
>> >> Tom
>> >>
>> >>
>> >
>> >
>>
>>
>
>



Nov 19 '05 #8
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:uA******** ******@TK2MSFTN GP15.phx.gbl...
Tshad...
I didn't look at your table. I just wanted to offer an alternative. The
old
saying I've used is "Normalize 'til it hurts, denormalize 'til it works".
Your space conerns are certainly valid...and if that's what drove your
design decision, it's very valid. However, unless you can draw from
similar
past experience, you typically shouldn't assume. It's far better to
start
off with cleaner code and improve it as your testing/profiling indicates,
than start off with an "optimized" version which is less readable and
who's
value you never really know.
Not just space concerns, but that is one of them. I just don't think that
you normalize for normalizing sake (and I know many would disagree - and
there positions are also valid). If I were going to sort this field, I
would agree with you, but it it takes just a couple lines of code to split
out the different numbers versus the amount of space and work for SQL to do
that is really unnecessary (at least in my mind).

Another example of normalization that I would have a problem with would be
phone numbers.

If I have an employee record with 4 phone numbers (home,work,fax and cell),
I would put the phone numbers on the employee record.

Someone else might set up a Phone table with 3 fields

Create table Phone(
PhoneID int,
EmployeeID int,
PhoneType int,
PhoneNumber)

Then you would need a table for Phone types:

Create Table PhoneTypes(
PhoneType int,
PhoneDescriptio n)

A little much, if you ask me.
I have no doubt that your solution, while seemingly very efficient, is far
uglier and difficult to maintain. Not knowing your system, I'll leave it
to
you to figure out what tradeoffs are necessary, but I certainly hope that
you'll go through due deligence and not make assumptions. Every day of
my
life lately I'm stuck in a world where someone else made decisions based
on
assumptions which (a) proved to be uterly flawed and (b) resulted in
millions of dollars worth of code being thrown out.
As you say, efficient. And easy to maintain.

I agree on decision that need to be made. And these need to be made based
on valid assumptions. And you're right, many times you have to make changes
as assumptions change. That can happen to valid assumptions, as well.

There are no guarantees and you can't assume that things won't change.

We just finished a discussion on code/behind/beside/inside models (I don't
want to get into the discussion again as that was pretty well hashed out).
There were various reasons for each and all valid based on the situation.
But I feel you are making a mistake to stick strictly to a model just for
the models sake, if it doesn't fit the situation. Asp.net 2.0 may change
the way code/behind is used for a lot of people who use (and swear by it)
now.

I certainly don't wish to preach or come off sounding all high and mighty.
But the cost of hard of the extra hard drive room probably equals about 4
hours of your salary.....it's pretty obvious which should be the driving
factor between maintainabilty and disk usage...(again, these rules
certainly
have valid exceptions....)
I have no problem with your opinion. I learn a lot listening to everyones
opinion. It helps me shape mine. Sometimes it changes mine, other times
(even if the opinion is opposite of mine) it will reinforce mine.

I was told once that if you have to know the rules and then break them,
that's one thing.
To not know the rules and break them is just ignorance.

Tom.

Cheers!
Catch you on the flip side (I don't know what that means)

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"tshad" <ts**********@f tsolutions.com> wrote in message
news:ei******** ******@TK2MSFTN GP10.phx.gbl...
I thought that was what you meant. The problem is why have all those
records suppose each search option has 15 Job Categories. That's a lot
of
records just to handle one field and a lot more work for Sql to do.

Maybe, you are thinking that there is only one field in the record.

Actually, the whole records is:

CREATE TABLE [dbo].[Searches] (
[ClientID] [varchar] (20) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL
,
[email] [varchar] (45) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[SearchID] [int] IDENTITY (1, 1) NOT NULL ,
[SearchName] [varchar] (50) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[KeyWords] [varchar] (80) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL
,
[EmailNewJobs] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[EmailNewJobsAdd ress] [varchar] (45) COLLATE
SQL_Latin1_Gene ral_CP1_CI_AS
NULL ,
[EmailNewJobsFre quency] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS
NULL ,
[CompanyName] [varchar] (45) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[FullTime] [bit] NULL ,
[PartTime] [bit] NULL ,
[Temporary] [bit] NULL ,
[Contract] [bit] NULL ,
[Seasonal] [bit] NULL ,
[WagesMin] [money] NULL ,
[WagesMax] [money] NULL ,
[WagesType] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByState] [varchar] (3) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByCity] [varchar] (30) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[Miles] [char] (1) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ZipCode] [varchar] (9) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[ByKeyword] [bit] NULL ,
[ByDate] [bit] NULL ,
[ByWages] [bit] NULL ,
[ViewBrief] [bit] NULL ,
[ViewDetailed] [bit] NULL ,
[JobCategories] [varchar] (8000) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS

NULL
,
[DatePosted] [datetime] NULL ,
[DateModified] [datetime] NULL
) ON [PRIMARY]

This would mean that if you have 10 Job categories you have 10 identical
records, except for the one field. An awful lot of wasted space (I would
think). Maybe I'm wrong.

I assume you are normalizing the table.

Tom

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
> Tom:
> Not sure how else to explain it...
>
> If user1 can have his search 1 which has job 1, 4, 5 and 6
> user 1 can have his search 2 which has jobs 1, 2 and 3
>
> user2 can have her search 1 which has jobs 3
>
> user 7 can have her search 3 which has jobs 1,3
> user 7 can have her search 2 which has jobs 4,5
>
>
> I'd do a table with 3 columns:
>
> UserId, SearchId, JobId
> //first case
> 1, 1, 1
> 1, 1, 4
> 1, 1, 5
> 1, 1, 6
> //second case
> 1,2,1
> 1,2,2
> 1,2,3
> //third case
> 2,1,3
> //forth case
> 7,3,1
> 7,3,3
> //fifth case
> 7,2,4
> 7,2,5
>
> then when you say, "I want all the jobs for user 7 for the her 3rd
> saved
> search", you do:
>
> select JobId from UserSearchJob
> where UserId = 7 and SearchId = 3
>
> and you end up with
> 1
> 3
>
> Karl
>
>
>
> --
> MY ASP.Net tutorials
> http://www.openmymind. net/ - New and Improved (yes, the popup is annoying) > http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ (more to
> come!)
>
>
> "tshad" <ts**********@f tsolutions.com> wrote in message
> news:eu******** ******@TK2MSFTN GP12.phx.gbl...
>>
>> "Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME
>> net>
>> wrote in message news:eO******** *****@TK2MSFTNG P10.phx.gbl...
>> > Seems like a join table is the best way
>>
>> You lost me on that one.
>>
>> What I am doing is allowing the user to save different types of searches >> based on Job Categorys, Dates, Zip codes etc. They can save this in a
>> table. One record for each search they want to save. They may want
>> to
> save
>> 10 different searches so that they don't have to keep putting in all the >> different search criteria each time they come back.
>>
>> One of the search criterea is Job Categories, which they pick from a list >> box which as the name of the Job Category as well as the value (which is >> a
>> numeric value).
>>
>> So if they pick 10 different Criteria, I need to store those numbers
>> somewhere. So I just put the numbers together in a string separated
>> by
> "|".
>>
>> When they come back to run another search, they can pick from their
>> stored
>> searches and I then need to get all the ten (or however many categories >> they picked) categories and use them in the search.
>>
>> Thanks,
>>
>> Tom
>> >
>> >
>> > UserId, JobId
>> >
>> > 1,1
>> > 1,3
>> > 1,5
>> > 2,4
>> > 5,1
>> > 5,6
>> >
>> > ...
>> >
>> > Karl
>> >
>> > --
>> > MY ASP.Net tutorials
>> > http://www.openmymind. net/ - New and Improved (yes, the popup is
>> > annoying)
>> > http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ (more to >> > come!)
>> > "tshad" <ts**********@f tsolutions.com> wrote in message
>> > news:Os******** ******@tk2msftn gp13.phx.gbl...
>> >> "Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME
>> >> net>
>> >> wrote in message news:e8******** ******@TK2MSFTN GP09.phx.gbl...
>> >> >
>> >> >
>> >> > dim item as ListItem = jobCategories.I Tems.FindbyValu e(a(j))
>> >> > if not item is nothing then
>> >> > item.selected = true
>> >> > end if
>> >> >
>> >>
>> >> I knew there was a better way.
>> >>
>> >> >
>> >> > Btw, why bother using a relationa database (assuming) if you are
> gonna
>> > use
>> >> > values which are split like that?
>> >>
>> >> What I am doing is storing the string in a field that shows which
> choices
>> >> the user made to a ListBox (could have many). I am collecting the
> values
>> >> and separating them by "|". The Job Categories are themselves in a
> table
>> >> ("text and value"). But each user can have many search records (each > of
>> >> which can have a different set of Job Categories). This seemed
>> >> like
> the
>> >> best way to save it.
>> >>
>> >> Thanks,
>> >>
>> >> Tom
>> >> >
>> >> > Karl
>> >> >
>> >> > --
>> >> > MY ASP.Net tutorials
>> >> > http://www.openmymind. net/ - New and Improved (yes, the popup is
>> >> > annoying)
>> >> > http://www.openmymind. net/faq.aspx - unofficial newsgroup FAQ (more > to
>> >> > come!)
>> >> > "tshad" <ts**********@f tsolutions.com> wrote in message
>> >> > news:OX******** ******@tk2msftn gp13.phx.gbl...
>> >> >> I have a string that I read from my database: 1|8|5620|541
>> >> >>
>> >> >> These are all values in my ListBox. I want to select each of these >> > items
>> >> > (4
>> >> >> of them - but could be many more). At the moment I am doing the
>> >> > following:
>> >> >>
>> >> >> Dim a() As String
>> >> >> Dim j As Integer
>> >> >> a = JobCategoriesSe lected.Split("| ") ' Where
>> >> >> JobCategoriesSe lected is set to 1|8|5620|541
>> >> >> For j = 0 To a.GetUpperBound (0)
>> >> >> trace.warn("str ing = " & a(j))
>> >> >> for each item as ListItem in JobCategories.i tems
>> >> >> if item.value = a(j) then
>> >> >> item.selected = true
>> >> >> end if
>> >> >> next
>> >> >> Next
>> >> >>
>> >> >> The problem is that for each Item I am selecting, I am having to go >> >> > through
>> >> >> the list to find the value that matches the one I want to set. In >> >> >> this
>> >> >> case, it would have to go through the list 4 times.
>> >> >>
>> >> >> Is there some kind of a way to do it in one line where you say
>> > something
>> >> >> like set the listitem that is equal to my value to selected?
>> >> >>
>> >> >> Thanks,
>> >> >>
>> >> >> Tom
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>



Nov 19 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2261
by: yamne | last post by:
I have a problem. When I click in edit datagrid button I show two listbox and two button. I use two button to move data between two listbox. My problem is that I can't call the listbox in the button_click function because the only way to find the listbox is: (listbox)e.item.findcontrol What s the solution to this problem?
7
10065
by: 00_ChInkPoIntD12 | last post by:
Can anyone confirm there isn't a Sort() method for WebControl Listbox in Asp.net? It is rather simple to write a method to do the sorting, but just wondering I shouldn't invent the wheel if there is already one. C.P.
5
1999
by: Paul | last post by:
Hi I have a listbox and have the selection mode set to multiple in the property box. I am trying to set multiple selected values in code but it only seems to use the last one. listbox.SelectedValue = 1 listbox.SelectedValue = 2 thanks. only 2 gets set above. -- Paul G
0
2649
by: David J | last post by:
Hi, I am strugling with the propertygrid and a listbox. I am using the universaldropdowneditor from the codeproject (code below). However I am populating the listbox via a datasource. The problem I am having is that when I have a value in the propertygird and edit that, I want the listbox to have the selectvalue equal to the value that is being edited. Just to make it clearer: PropgridVal = Germany Datasource=
2
4075
by: Hitesh | last post by:
I have a listbox and the values get selected (highlighted) from code. I can highlight the corresponding list box items, but they do not show in the listbox I have to scroll through the list box to find them. How can I setFocus on the highlighted data items in the listbox after they are highlighted. The selection mode is set to multiple for the listbox -- Thanks
3
2292
by: Ali Chambers | last post by:
Hi, I have created a listbox called "dtlist1" on my VB.NET form. I call a procedure as follows: Private Sub openfile(flname As String) dtlist1.Items.Clear() etc..
7
17424
by: =?Utf-8?B?UmVraGE=?= | last post by:
Hi, I am trying to change the font color for the items in a dropdownlist control at run time using ASP.NET 2.0. DropDownList1.Items.Attributes.Add("style", "color:red"); But when I run the application, I don't see any color change. I am using Visual Studio 2005, ASP.NEt 2.0.
1
4021
by: Sunray | last post by:
I have a form called the sales form and i have 2 sets of listboxes So what happens is. i add items form the bottom set of list boxes which are bound to a data base to the top set of list boxes which are not bound, I select from the bottom set and add to the top set which works fine, but now i decide to remove an item from the top set. when i tried to use a remove item code it worked fine, it did delete the item form the list but it added...
0
1255
by: waldedg | last post by:
I have a ListBox set as Multiselect. I am populating the table thruough asp.net code. But I am using another dataset to get the items that should be selected. The only item that ends up selected is the last item in the dataset. The code I am using for setting the selected items is: DataSet ds1 = SqlHelper.ExecuteDataset(ConnStr, "StoredProd", Parm); lbRequestTime.SelectionMode = ListSelectionMode.Multiple; ...
0
8481
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8672
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7441
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4227
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4412
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2817
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1814
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.