Store entries in DB

I have to get input from user in flat file format.then convert it to xml. T
hen, i have to store the entries into a datatable in the database. say 1,2,3 a,b,c be the user entries. it shall be stored into a table with 2 columns.how to do this?

I need to store more than 4k of bytes in my SQLCE 4 database. How can I do that with the ASP.NET Web Pages 1.0?

1: The Microsoft.Data provider fails when I try to populate a parameter with more than 4k bytes.2: Referencing SqlServerCe assembly and using SqlCeConnection/SqlCeCommand/SqlCeParameter throws exception: SQL Server Compact is not intended for ASP.NET development.

How can I somehow map the generic DbType, which does not have NText as an option, to the ntext column in my database? (SqlCeParameter supports DbSqlType, which has ntext, but see problem #2)

Can anyone tell me the best way of storing Japanese characters through ASP.NET.I have to put characters into a asp:textbox on one page, which saves it to an Access DB.On a second page I want to display the content in a asp:label.

Should I store the characters directly to the database or should they be encoded, andhow do I encode the characters?

Visual Basic .NET comes loaded with features not available in previous versions, including a new threading model, custom class creation, and data streaming. Learn how to take advantage of these features with an application that is designed to extract information from Web pages for indexing purposes. This article also discusses basic database access, file I/O, extending classes for objects, and the use of opacity and transparency in forms.

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.

(1) How to create MySite for one specific member with other or administrator's access?

(2) Scenario : Administrator have created one SP2007 site. now Administrator have created one calendar (Sample calendar). Administrator have added some entries in calendar. now one user entered in portal site ansd view the calendar and he click on MySite menu. so this sample calendar entries should enter in that user's mysite calendar. How this can be achieved?

I have an event receiver on ItemUpdated and ItemCheckedIn, which both writes custom SPAuditEntries. When CheckedIn occurs though - it comes with two update entries as well (one for added file, and one for a simple update to the list item I suspect).

I'd love to get rid of these entries. At first I thought it would be really simple, just put an if in the itemUpdated event receiver, and stop everything

if(SPListItem.CheckedOut = false) { //... do nothing }

However I couldn't find any way to ascertain the checkout-status of the listitem. My next thinking was, they hit almost at exactly the same time, so I could just crawl into the auditCollection, filter down to the specific listitem, user, and time (minus
a second) and delete the two entries. But, sadly I found out I couldn't delete auditentries.

i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field please let me know how to do this using file uploader.please give complete sample code.

Hello,I have been trying to store an xml attribute value to a string and I cannot seem to get it to work. I start off pulling an XML node from a SharePoint web service.
XmlNode user = usergrpService.GetUserInfo("domain\\user");
This seems to work because if I assign user.InnerXml to a text box then I can see the contents of the user. So then I try to get the value.I have tried a combination of the following with /'s, @'s, User/ID, User@ID, /User/ID, /User@ID, etc.
String userID = user.Attributes["ID"].Value;
String userID = user.SelectSingleNode("ID").Value;
Each time I get an "Object reference not set to an instance of an object" error. If I can read the InnerXml then why can I not get a single attribute?-Eric

Okay, so i created the following query
select a.cusip, SUM([UnitsHeld]) AS unitsSum From [GTC_PA_SQL2].[DW].[dbo].[HoldingsC] h
inner join [GTC_PA_SQL2].[DW].[dbo].[AssetsC] A ON h.securityID = a.securityID
Where cusip IS NOT Null AND MinSecClass In (9,10,58,59,60,64,65,69,70,79,80,85,87,215,216,220,229)
group by a.cusip
However, now i need i need to change this so that instead of a on the fly query, the values are stored and the query will run only once a quarter or so.
This is what i have so far:
update dbo.finance
set PAR= (select SUM([UnitsHeld]) AS unitsSum From [GTC_PA_SQL2].[DW].[dbo].[HoldingsC] h
inner join [GTC_PA_SQL2].[DW].[dbo].[AssetsC] A ON h.securityID = a.securityID
Where cusip IS NOT Null AND MinSecClass In (9,10,58,59,60,64,65,69,70,79,80,85,87,215,216,220,229)
group by a.cusip)
The table i need to store the UnitsSum value in the dbo.finance table under the field PAR which correlates with a PK of cusip, this table doesnt have any securityID reference. The issue with need these queries stems from the fact that i need a total
UnitsHeld for each security class which has a cusip9 attached to it. However the database right now stored the unitsheld for each portfolio and not as a total for reach cusip which i need.

(Posted this in Database Design, but then thought I should post here as well)
Hi All,
I am trying to figure out what would be the best method for storing xml documents in the db...if we should use an XML type field or if we should use the newly introduced FILESTREAM? We would have a need to shred those documents for queries and possibly
use the FULL TEXT SEARCH to allow for user defined searches on those documents. Does anyone have any thoughts on either approach for SQL server 2008?
Always apprecaite the input I get on this forum...very helpful.
--B