asp.net proj

how to create data

Page 1 of 1

2 Replies - 582 Views - Last Post: 11 January 2011 - 05:46 AM Rate Topic: -----

#1 cooldudevikas  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 11-January 11

asp.net proj

Posted 11 January 2011 - 04:23 AM

hello sir
i want to create songs downloading site so these site can working as an like song download so sir how to create database and how to create procedure in sql
so sir how to create these site
please help me thankes
Is This A Good Question/Topic? 0
  • +

Replies To: asp.net proj

#2 Vishu Sukhdev  Icon User is offline

  • D.I.C Head

Reputation: 38
  • View blog
  • Posts: 150
  • Joined: 19-February 10

Re: asp.net proj

Posted 11 January 2011 - 05:30 AM

Hi,
I think you should collect website related information from google search and you should study some existing website Like PKSongs.com,Skillsongs.com etc
for Songs Downloading and after that you Analise all information and try to create database.
this is simple example of Stored Procedure in Sql

CREATE PROCEDURE [dbo].[sp_Demo]
   (
   @Field1 int,
   @Field2 varchar(75)='Not Applicable',
   @BFlag int=0
   )
	
AS
BEGIN

	BEGIN TRY
		BEGIN TRANSACTION

		IF (@BFlag=1)/*FOR INSERTING RECORDS*/
			BEGIN

				INSERT INTO table_name(
                                    Field1,Field2)
					 
				VALUES(
				    @Field1,@Field2) 

			END

		ELSE IF(@BFlag=2)/*FOR UPDATING RECORDS*/
			BEGIN
			
				UPDATE table_name SET
			    Field2=@Field2				 
				WHERE
				Field1=@Field1
					
			END
			
		ELSE IF(@BFlag=3)/*FOR DELETING RECORD*/
			BEGIN
				DELETE FROM table_name
				WHERE
					Field1=@Field1
			END

		COMMIT TRANSACTION
	END TRY

	BEGIN CATCH
		ROLLBACK TRANSACTION
	END CATCH

END


Was This Post Helpful? 0
  • +
  • -

#3 Nakor  Icon User is offline

  • Professional Lurker
  • member icon

Reputation: 444
  • View blog
  • Posts: 1,492
  • Joined: 28-April 09

Re: asp.net proj

Posted 11 January 2011 - 05:46 AM

I really doubt anyone is going to hold your hand through making an entire site from start to finish here. I would suggest getting some books and possibly taking some classes if they're available where you are. The type of site you're wanting to make is not something you just throw together when you have no experience with database operations and how to tie the database into the web site. You have to learn to walk before you can run.

edit: not to mention there's a rule against just handing out code here.

This post has been edited by Nakor: 11 January 2011 - 05:48 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1