Storing structure Data into SQLServer database

Hot Topic

HELP: Accidently deleted an important project and i need it back!
Custom shaped Form?
File Renaming
Error 0x80501001
TeamBuild fails due to NUnit custom task.
Find deleted Items / Search for checked out items by user
ADO.NET DATASET
Foreign Key Fields in wrong order
Grey subfolders in Team Explorer
Usercontrol

VS Team System

how some help fix my code?
How to compile a .cpp file in Visual studio
Making Webrowser
Replacing Text with Text from another form
VB 2005 Express and activation
How can I merge an outside source tree into a version controlled copy of the source tree?
Textbox problem?
Docking a Web Browser
Unit tests not running in parallel on agents
External WIT ID

Storing structure Data into SQLServer database

hi,
Can anybody explain me to how to store the Structure data to SQlServer database.I have created a Structure data type that contains three members text,font and color.I have to store all these information into the database under a single column.I think,have to create a new type in SQlserver.But,I don't know how to create a new type in sql server from vb.net.can anybody please explain me.Thanks

sheeja




Answer this question

Storing structure Data into SQLServer database

  • cues7a

    Thanks for the reply.I have to store all that information as a text.I would like to create a new Datatype that contain three members(font,color and Text).In VB,Ihave create a stucture to store these information and i need to create a datatype in sql serever to store this structured information.so explain me some ideas about how to create a new datatype in sqlserver.tthanks



  • grouper

    All created datatypes in SQL are nothing more than customizations and mergers of existing datatypes..so the first step is to find out how you want to store the information in the single column...text, binary, etc....

  • Storing structure Data into SQLServer database
Answer this question