How To Create The Forum Database In Sqlserver
Feb 25, 2011how to create the forum database in sqlserver. what tables & columns are required in it .
View 3 Replieshow to create the forum database in sqlserver. what tables & columns are required in it .
View 3 RepliesI am a fresher and I have got a project in asp.net and c#. I have to create a forum, something like stackoverflow, so I have studied asp.net, c# and sql server 2008 but now I am unsure how I should start work on this project.
What technology and what part of asp.net, c# and the database will I use more? I have 3 days to study so I want to know which parts of asp.net, database and c# I have to cover in 3 days.It's my first live project, will I have to study any other languages or are the ones listed enough?
I want to Create a forum like "asp.net forum" in My Application.So i want to know that easy flow of making forum list in my Application and how to store it in database.I dont want to make my page loading time is slow. .
View 6 Repliesi want to create a forum like page in ASP ,C# where user can enter some question.
Administrator reply this question,according to if user does not satisfied with the solution then in same thread he may ask for further clearance.for example the forum of asp.net ( the current page)
Hey guys, i have some problem here. How can i create a simple forum in asp.net? using wat toolbox?
View 12 Repliesi wanna create a forum discussion panel for my webapplication just like ASP.Net forum....there i can apply background on each post...and that should be very user frendly....where user click on the reply button of thread than reply box should appear just bottom of that thread...and that reply box should open very stylist just like sliding.
View 2 RepliesI just wanted to create a forum for my personal purpose .....
It should be similar like our asp.net forum.
how to get started to create forum like this.
Steps i want to know
First user will register in my forum. He might post his / her question in the post. The question first should be verified by forum admin, and then it should be publish to everyone. For any question, any user will come and reply to the post. How to do so? The post should be marked as answer only by the user who posts the question other reply user cant able to marked as answered...?
For the above second (2) steps:
For Eg:
Category:-Buyer/Seller (This will be in dropdown list)
Username:-User A
Subject:- Required 1000 pens in best price
Message:- We are leading stationary products buyers in the world.
Hence we need good pen in best price.
For the above third (3) steps:
How to publish new post in new page dynamically.
For Eg: www.abc.com/0001.aspx this is the new post, posted by User A.
How do i create a forum using the toolbox for interface design with connection string connection to the database using visual studio 2005 express edition
View 5 Repliesi am developing a FORUM i am using asp.net, c# language for code. I have read a article about NoSql i inspired a lot from there advantage over RDBMS (sql) so i was thinking that should i use NoSql concept for Forum DataBase or not. I am not a expert in database. So can u suggest me should i use NoSql? Currently I am using sql(rdbms).
View 1 Repliesi do knot know how to make a forum, step by step , in the forum people show their picture and user name
View 3 RepliesI am in the process of creating a forum design from scratch, as my first official asp.net application attempt.
Overview:
I would like to handle this task in the following steps:
1) Get input from the user: txtLoginEmail, txtPassword
Form has been submitted:
2) Process inputs a) cut/trim white spaces
b) encrypt password by using SHA1 hashing method located in clsLibrary
3) Check the email address given against the database
Match: Display a message saying that the username already exists.
Doesn't: Add the email address and add encrypted password into the database
Question:
In my Register.aspx.vb code-behind file, inside of the question mark lines, how exactly do I check against
the database to see if that user exists in that database already? I thought perhaps storing the results in
an array and then looping through it to look for matches, but that sounds inefficient. I tried this idea
and after an hour I was unsuccessful. Below is my code for the class objects and pieces of code relevant to this task:
Database Design
---------------
UserID int IDENTITY(1,1) PRIMARY KEY,
UserEmail varchar(50),
UserPass varchar(50)
[code].....
there are two tables in database. one is 'books' with 4 columns pkid,title,price,writer(int) and other is 'persons' with columns pkid, name,value(int). one asp.net page is there with text boxes named title,price,writer and a submit button. i want that on filling that writer txtbox with some name which is available in 'persons' table and clicking that submit button it will store integer 'value' in 'books' writer column.
View 2 Replies I'm working with a series of 4 dropdownlists. The First and Third seem to be passing correct values to the database. The second and fourth pass correct value from 0 to 9 but will not pass two digit values. If selected value is 23 the value 1 is sent to database. The four dropdownlists are entered sequentially with other data and sent to database by submit button. All other fields seem to be updating correctly.
The data fields which will not update with two digits are integers. Value 0 to 9 works, 10 to 31 do not. I'm pretty new at this and totally stumped.
Is there a way to have a page editing tool such as the one on here here you can make text bold, italics, numbering etc on my own site and store the content in a database?
I want the user to be able to edit the text on the page and formatting then submit it and recall it as static text when the user is not logged in....
i am trying to search from 2 dropdown lit from my databse (sqlserver)
1st drop down list contain(Dr, Hospital, Bloodbank) and 2nd dropdown contain areas(like in hyderabd areas are HITECK CITY, VIDYANAGAR, DILSUKHNAGAR and so any)
how to serach from dropdown list.
I have read the article downloading the data from sqlserver .If i have to create a link in webpage and click in that link the template application must open for the client with Reg.No,name ,address etc.the form is to be printed by the client and have to filled . So how can i print the template in pdf format. Reg no must be auto generate. I am using sqlserver as back end. with data its working.
View 1 RepliesInsert html tage to sqlserver database through asp.net textbox Display it lable control
View 5 Repliesi want store all the datas of xl sheet into sqlserver database table. i am using asp.net 2.0 and sqlserver 2005. pls provide the coding.
View 2 Repliesi used database sqlserver2008 and i make website which have database on internet serveri get ip address and username and password for that databse ;it's sqlserver 2005i want to upload database to my website ; i conccet with it by sqlserver managament 2008 ;then when i attachment database i get these messagemicrosoft.sqlserver.management.sdk.sfk how can i solve this error
View 3 RepliesI have a web applicaton run at godaddy hosting and have a sqlserver 2005 database hosting also by godaddy .From 1 week My web site hacked , by putting a strange script at all my .ASPx and the same strange script at all my database row.after that I remove the permission and make only permission of view filesand after that yesterday my web site hacked again by the strange script??? but my files didn't hacked .I scaned all my web sites files with updated antiviruse and with malware application but they didn't find any thing
View 5 Repliesi've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
I'm just wondering if anyone has come across a good, easy method for updating a SQL Server 2000 DB table using the edit feature in GridView. The catch here is that I need it to encrypt, send to database, then decrypt when the page calls it to be displayed. I have successfully implemented an insert method using FormView with encryption. For some reason, I just can't seem to figure out the edit/update.
View 1 RepliesI have a very weird thing happening. I have two databases that have exactly the same tables but different database names on the same virtual machine, but in different instances of SQL Server. For some reason, when using one of them, it will save to the other. In debug, looking at my connection string..I have verified that it is correct, yet when I allow the save, I look in the table and it isn't there, it is in the other database that is in a table with a completely different name and in a different instance of SQL Server.
View 1 RepliesI have a weird thing happening. I have two identical databases installed on one virtual machine but under two different instances of SQLServer. For some reason, periodically when saving from one it will save to the other instead. Using debug, I have verified that the connection string is correct and when the item saves, it still saves to the wrong database.I use session variable, and am of the belief that it might have something to do with it...and t hat when I go from one to the other it is still getting the connection string form the other for some reason.To make sure that it isn't a problem, I make sure that I completely close out one database before opening the other in a new IE window.I assume that when I completely close out an internet explorer window that it abandons all session states. Is that true?
View 7 Repliesyou could create your own custom Profile provider that operates against existing database tables .i want u to help me out if u have an idea where i can get steps by steps to carry out the above operation.i know there are various options in creating profile , particularlly the use of web. configuration, the default ASPNETDB, and XML files, BUT i wish to use an existing database which i prefer.
View 11 Replies