jascam / CodePlexFoo

0 stars 0 forks source link

Saving and Reading data in ap.NET 4.5 using knockoutjs #686

Open jascam opened 6 years ago

jascam commented 6 years ago

Hello,

Mm trying to implement this ( facebook-wall-posts-comments-knockout-aspnet-webapi ) in asp.NET webforms and not asp.NET MVC. I have a database table with the following structure but stomped somewhere between the viewModel script and the webmethod the JSON is supposed to call from a codebehind .aspx page.

Can someone assist me with a sample on how to do this (share and comment feature in asp.NET webforms)

TABLE STRUCTURE:

USE [PersonDB]

CREATE TABLE [dbo].[ForumWallPosts]( [sn] [int] IDENTITY(1,1) NOT NULL, [postID] nchar NULL, [comment] varchar NULL, [postDate] [datetime] NULL, [username] varchar NULL, [localeIP] nvarchar NULL, [postedBy] varchar NULL,

CONSTRAINT [PK_ForumWallPosts] PRIMARY KEY CLUSTERED ( [sn] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].[ForumUsers]( [UserID] [int] IDENTITY(1,1) NOT NULL, [UserName] nvarchar NOT NULL, [FirstName] nvarchar NULL, [LastName] nvarchar NULL, [sex] nchar NULL, [Email] nvarchar NOT NULL, [Password] nvarchar NOT NULL,
[Mobile] nvarchar NULL, [DOB] [datetime] NULL CONSTRAINT [DF_ForumUsers_DOB] DEFAULT (getdate()),

CONSTRAINT [PKForumUse1788CCAC2A4B4B5E] PRIMARY KEY CLUSTERED ( [UserID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].[ForumWallPostsComments]( [commentId] [int] IDENTITY(1,1) NOT NULL, [postID] nchar NULL, [Message] varchar NULL, [CommentedBy] varchar NULL, [CommentedDate] [datetime] NULL,

CONSTRAINT [PK_ForumWallPostsComments] PRIMARY KEY CLUSTERED ( [commentId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

CREATE TABLE [dbo].[ForumProfileImg]( [sn] [int] IDENTITY(1,1) NOT NULL,
[imgStatus] [bit] NULL CONSTRAINT [DF_ForumProfileImg_imgStatus] DEFAULT ((0)), [userName] nvarchar NULL, [fileName] varchar NULL,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

Migrated CodePlex Work Item Details

CodePlex Work Item ID: '13079' Vote count: '2'