![]() |
|
|
|||||||
![]() |
General Help Related Topics - How to store dataset to a table in the database. Please be specific. Urgent |
|
|
Thread Tools | Search this Thread |
|
|
#1 |
|
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 |
|
|
|
|
![]() |
| Thread Tools | Search this Thread |
|
|
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 |