but dont you think i will change the column any time the xml schema change. that mean flexibility challange

Hi, am designing a database that expedite collection of data from the insurance companies by insurance body. members are required to upload daily transaction in xml format.the insurance policy no is the primary key but other information can change. the data will be query by users. should i store the data as xml datatype or in split the column as use cdc to audit the canges or plit the column with history table . like below Field Name Data Type Policy No Var Office_Code Var Vehicle_Reg_Number Var Vehicle_Chas_Number var Vehicle_Eng_Number Var Date_Policy_Start_Date Date Date_Policy_End_Date Date Date_of_Cancellation Date or policyno var policydata xml

Dim query As ObjectSet(Of customer) = context.customers Dim queryResult As ObjectResult(Of customer) = query.Execute(MergeOption.AppendOnly) how do i get ddlcust.selectedvalue= queryResult.customerid

i mean which onewill be better

modified on Wednesday, July 14, 2010 12:09 PM

i have an examination system that will be run twice a year. some of the tables are setup some are transactional. should i archive or backup at end of each processing

i have resolve. i need to check editing thanks

i bind a datagridview(window form) to a datable. but i added extra checkbox column from design . i notice it does not check whn i run it

Hi how do i make sql statement to page the rows six per result

Hi how do i make sql statement to page the rows six per result

i hv a clock application . how can make it show on desktop when user start computer. as in window vista

i hav a table with schema id int name varchar i declare trow as personrow i bind it to a gridview onselectedindexchange i got the row selected by user as dim row as gridviewrow = gridview1.selectedrow how can i cast row to personrow

explicitly set the update command

i have table A with field password varchar(15), am migtrating the data to password in another table datatype varbinary with script component transformation. i set the password to byte stream i have this code to encrypt the password so i can store it as varbinary Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) ' ' Add your code here ' Try Dim hashBytes As Byte() Dim encoding As New UnicodeEncoding hashBytes = encoding.GetBytes(Row.app) Dim sha As New SHA1CryptoServiceProvider Dim crpytPassword As Byte() = sha.ComputeHash(hashBytes) Row.passout = crpytPassword Catch ex As Exception End Try End Sub but am getting this error [AccountProfile New Destination [16]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid character value for cast specification". [AccountProfile New Destination [16]] Error: There was an error with input column "pass" (88) on input "OLE DB Destination Input" (29). The column status returned was: "The value could not be converted because of a potential loss of data.". thanks

thanks Dave am already storing key/value type/value information in the xml column in the database. i dont no much about custom serializer/deserializers. but the fact is that i only need to break this during report. i dont know if crytal report hav this ability to pull key/value type/value information from sql server

thanks a lot dave. i hv read it he say "Let's say our Products table might have ProductID, ProductName, ProductCategory and ProductAttributesXML. We would then use ProductCategory to decide what type of class we store in ProductAttributesXML. So for ProductCategory='Digital Cameras" we could define a class DigitalCameraAttributes with fields such as Pixels, MaximumZoom, StorageType, and a special user control to show these details. Likewise, a class called HardDiskAttributes for the Hard Disks category." now i want to allow user to specifies this fields from form cos i do not know at design time the product fields. so how can i define the class base on their input. i hope it make sense.

thanks a lot. i hv read it he say "Let's say our Products table might have ProductID, ProductName, ProductCategory and ProductAttributesXML. We would then use ProductCategory to decide what type of class we store in ProductAttributesXML. So for ProductCategory='Digital Cameras" we could define a class DigitalCameraAttributes with fields such as Pixels, MaximumZoom, StorageType, and a special user control to show these details. Likewise, a class called HardDiskAttributes for the Hard Disks category." now i want to allow user to specifies this fields from form. so how can i define the class base on their input thanks

yes David Skelly

thanks Dave Kreskowiak actually am looking for a way to break up this attribute so that i can have a report that look like ram size 256 maker seagate price 50 note that this value exit in database but size and maker are nodes in the (xml productattribute column)

i have a table with th schema productid int productname varchar productattribute xml where the productattribute is supply by user through form say (12seagate) how can i deserialize this on the fly so i can say product.productattribute.size =12

what do you mean by attribute template