473,749 Members | 2,464 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Save a complex structure's instance to SQL Server DataBase

I have defined a complex structure with vb.net. One instance of it will be
about 32KB. Is it possible to save it to a SQL Server database and how to do
it?

Thanks in advance.

Peter
Nov 21 '05 #1
7 1553
Serialise it and store it as a string

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

"Peter" <zl*****@sina.c om> wrote in message
news:uL******** ******@TK2MSFTN GP12.phx.gbl...
I have defined a complex structure with vb.net. One instance of it will be
about 32KB. Is it possible to save it to a SQL Server database and how to do it?

Thanks in advance.

Peter

Nov 21 '05 #2
Thank you
"One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> дÈëÏûÏ¢ÐÂÎÅ
:uu************ **@TK2MSFTNGP11 .phx.gbl...
Serialise it and store it as a string

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

"Peter" <zl*****@sina.c om> wrote in message
news:uL******** ******@TK2MSFTN GP12.phx.gbl...
I have defined a complex structure with vb.net. One instance of it will be about 32KB. Is it possible to save it to a SQL Server database and how
to do
it?

Thanks in advance.

Peter


Nov 21 '05 #3
Thanks a lot
"One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> дÈëÏûÏ¢ÐÂÎÅ
:uu************ **@TK2MSFTNGP11 .phx.gbl...
Serialise it and store it as a string

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

"Peter" <zl*****@sina.c om> wrote in message
news:uL******** ******@TK2MSFTN GP12.phx.gbl...
I have defined a complex structure with vb.net. One instance of it will be about 32KB. Is it possible to save it to a SQL Server database and how
to do
it?

Thanks in advance.

Peter


Nov 21 '05 #4
Peter,

I think it is really not needed with Terry to overdo it, he is (very) glad
with one thank you.

(And does as me not like people who give not any reply).

:-))))

Cor
Nov 21 '05 #5
I'm not sure if I have send the first "Thank you", so I sended it again. I
think you are very humourous.

"Cor Ligthert" <no************ @planet.nl>
wrote:#F******* *******@TK2MSFT NGP11.phx.gbl.. .
Peter,

I think it is really not needed with Terry to overdo it, he is (very) glad
with one thank you.

(And does as me not like people who give not any reply).

:-))))

Cor

Nov 21 '05 #6
> I'm not sure if I have send the first "Thank you",

Did you expect I was thinking something else, however we know in this
newsgroup how Terry reacts (and I agree with him) when there is no attention
at all or somebody else get that.

So this was my change to add too that fact.

You did it fine.

Cor
Nov 21 '05 #7
English is not my native languge, sometime I could not express my meanings
clearly. In fact, I want to send a kindly praise to you. I've got many help
from you all,and I'm very proud of you. I think I'm lucky to join with you.
"Cor Ligthert" <no************ @planet.nl>
wrote:#L******* *******@TK2MSFT NGP12.phx.gbl.. .
I'm not sure if I have send the first "Thank you",
Did you expect I was thinking something else, however we know in this
newsgroup how Terry reacts (and I agree with him) when there is no

attention at all or somebody else get that.

So this was my change to add too that fact.

You did it fine.

Cor

Nov 21 '05 #8

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

Similar topics

9
2088
by: T. Earle | last post by:
To list, I'm trying to figure out the best approach to the following problem: I have four variables: 1) headlines 2) times 3) states 4) zones
1
4111
by: Dennis Gavrilov | last post by:
Hi, All! I have two questions: strategic and technical. Technical one first: I need to share an array of objects (implemented as hashes, having references to other objects and hashes, sharing done after blessing) between all of the mod_perl2 threads. The structure can grow quite big - tenths of thousands of array elements. It can grow as system operates (not possible to construct at apache startup). Sharing array is OK, but inserting...
0
1575
by: AL | last post by:
Hello, working on an xsd schema, I'd like it to have a node of which I don't know the content at design time: I want the document instance to identify such node contents, where content should have a complex structure (complex type). Probably xs:anytype is what I need, but I miss something... In the following schema, I define a "genericchild" node, which I'd want to be able to contain any (complex type) node I want to put in there: :...
11
2114
by: Sven Neuberg | last post by:
Hi, I have been handed the task of updating and maintaining a web application, written in ASP and Javascript, that takes complex user inputs in HTML form and submits them to server-side ASP pages for processing. The problem is, the user inputs can become very complex, and the way this application was developed, the inputs are all concatenated into monstrously long strings of text that are then submited as <hidden> inputs in HTML forms...
116
7537
by: Mike MacSween | last post by:
S**t for brains strikes again! Why did I do that? When I met the clients and at some point they vaguely asked whether eventually would it be possible to have some people who could read the data and some who couldn't but that it wasn't important right now. And I said, 'sure, we can do that later'. So now I've developed an app without any thought to security and am trying to apply it afterwards. Doh!, doh! and triple doh!
8
2962
by: Steve Jorgensen | last post by:
Mailing List management is a good example of a case where my conundrum arises. Say there is a m-m relationship between parties and groups - anyone can be a member of any combintation of groups. Now, let's say the user wants to be able to send mailings to people who have various combinations of membership and non-membership in those groups. Here's a medium-complex example: (Knitting Group or Macrame Group) and Active Contact and Mailing...
1
15988
by: Rudolf Bargholz | last post by:
Hi, We have created triggers to log modifications to tables in our application. The triggers work fine, just on one of the tables in our database the triggers fail with the error message <SQL0437W Performance of this complex query may be sub-optimal. Reason code: "1". SQLSTATE=01602>. The same trigger on other tables works fine (the triggers are autogenerated with the same structure for most of the tables used in our application). I...
2
1716
by: =?Utf-8?B?c2lwcHl1Y29ubg==?= | last post by:
Have a complex process where I need to Import a large amount of data then run some transformations on this data then import into DataBase. The transformation involves multiple fields and multiple process - so the data needs to be read in 1 record at a time then run thru the transformation that may create new data value then everything is imported into a db to store. I have multiple questions 1)we used to have an internal data structure...
3
7160
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this file but save it as an excel file. The data in this excel file will be imported into an Access database. The
0
8832
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9566
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
9388
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9254
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...
1
6800
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6078
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
4608
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
4879
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3319
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

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.