<div>
You can store the brandIs in a different table and store their curresponding ids in the Client table <br />
<br />
Table &nbsp;Brands (BrandID int identity, BrandName varchar(120) &nbsp;)<br />
Table &nbsp;ClientInfo (ClientId int, BrandID int ) 
</div>


You can store the brandIs in a different table and store their curresponding ids in the Client table

Table  Brands (BrandID int identity, BrandName varchar(120)  )
Table  ClientInfo (ClientId int, BrandID int )

<div>
If let say i have a client sell few brand then how to store?
</div>


If let say i have a client sell few brand then how to store?

<div>
You should create a new table with the customer ID and the brand. Then you make a inner join to get all the brands for each customer.<br />

</div>


You should create a new table with the customer ID and the brand. Then you make a inner join to get all the brands for each customer.


<div>
Hi jpaulino,<br />
<br />
can i have saome sample how this sample look like.<br />

</div>


Hi jpaulino,

can i have saome sample how this sample look like.


<div>
<div class="content wysiwyg-content">
I have vb.net customer database. there is some client sell many brand like HP,IBM,NEC and etc.<br />
shoud i store all those brand into 1 column like HP,IBM,NEC <br />
or<br />
use diffrence column for 1 brand.<br />
<br />
i need to search let say HP. so all those client who sell HP will show up from the dataset.
</div>
</div>


I have vb.net customer database. there is some client sell many brand like HP,IBM,NEC and etc.
shoud i store all those brand into 1 column like HP,IBM,NEC 
or
use diffrence column for 1 brand.

i need to search let say HP. so all those client who sell HP will show up from the dataset.

DB Design Search data

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,