Go Back   Velocity Reviews > General Computer Discussion > General Help Related Topics
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

General Help Related Topics - How to store dataset to a table in the database. Please be specific. Urgent

 
Thread Tools Search this Thread
Old 09-20-2006, 03:55 PM   #1
Lightbulb How to store dataset to a table in the database. Please be specific. Urgent


I have create the following datarow:

_dtProjectQuestion.Columns.Add("ProjectQuestionNo" );
_dtProjectQuestion.Columns.Add("ProjectQuestionTyp e");
_dtProjectQuestion.Columns.Add("ProjectQuestionNam e");
_dtProjectQuestion.Columns.Add("ProjectQuestionLas tModifiedDate");
_dtProjectQuestion.Columns.Add("ProjectQuestionDat eFormat");
_dtProjectQuestion.Columns.Add("ProjectQuestionSho rtLabel");
_dtProjectQuestion.Columns.Add("ProjectQuestionLon gLabel");
_dtProjectQuestion.Columns.Add("ProjectQuestionMes sage");
_dtProjectQuestion.Columns.Add("ProjectQuestionMin Answer");
_dtProjectQuestion.Columns.Add("ProjectQuestionMax Answer");
_dtProjectQuestion.Columns.Add("ProjectQuestionCod eWidth");
_dtProjectQuestion.Columns.Add("ProjectQuestionHas OpenEnd");
_dtProjectQuestion.Columns.Add("ProjectQuestionIsA ctive");
_dtProjectQuestion.Columns.Add("ProjectQuestionIsC alculated");
_dtProjectQuestion.Columns.Add("ProjectQuestionLBo undary");
_dtProjectQuestion.Columns.Add("ProjectQuestionUBo unday");
_dtProjectQuestion.Columns.Add("ProjectQuestionMax trixNo");
_dtProjectQuestion.Columns.Add("ProjectQuestionMat rixLength");

I added rows to the datatable _dtProjectQuestion. Now I have multiple rows to insert into the database table below.
_dtProjectQuestion.Rows.Add(_rowProjectQuestion);

Then I accept changes and added the datatable to a dataset.
_dtProjectQuestion.AcceptChanges();
_dsProjectQuestion.Tables.Add(_dtProjectQuestion);

Here is my database table that I want to map to.
How can I go about doing this. If create stored procedure then I need explanation on how to do this.
USE [RG_ProjectData]
GO
/****** Object: Table [dbo].[ProjectQuestion] Script Date: 09/20/2006 08:03:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProjectQuestion](
[ProjectQuestionId] [int] IDENTITY(1,1) NOT NULL,
[ProjectQuestionNo] [int] NULL,
[ProjectQuestionType] [nchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectQuestionName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectQuestionLastModifiedDate] [datetime] NULL,
[ProjectQuestionDateFormat] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectQuestionShortLabel] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectQuestionLongLabel] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectQuestionMessage] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectQuestionMinAnswer] [tinyint] NULL,
[ProjectQuestionMaxAnswer] [tinyint] NULL,
[ProjectQuestionCodeWidth] [int] NULL,
[ProjectQuestionHasOpenEnd] [bit] NULL,
[ProjectQuestionLBoundary] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectQuestionUBounday] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProjectQuestionMaxtrixNo] [int] NULL,
[ProjectQuestionMatrixLength] [int] NULL,
[ProjectQuestionIsActive] [bit] NULL,
[ProjectQuestionIsCalculated] [bit] NULL,
CONSTRAINT [pk_ProjectQuestion] PRIMARY KEY CLUSTERED
(
[ProjectQuestionId] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


fullblown
fullblown is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Store HTML table Values into Database subscribeid Software 0 09-05-2008 02:39 PM
MCITP and stored procedure permissions Darrilgibson@gmail.com MCITP 5 06-07-2008 12:37 PM
Disney store Incredibles fullscreen OUTRAGE Mike DVD Video 15 03-18-2005 03:36 AM
Urgent and CRITICAL advice offered me at video store! RichA DVD Video 18 12-12-2004 04:56 AM




SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46