i 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'm halfway through coding a basic multi-tenant SaaS ECM solution.Each client has it's own instance of the database / datastore, but the .Net app is single instance.The documents are pretty much read only (i.e. an image archive of tiffs or PDFs)I've used MSSQL so far,but then started thinking this might be viable in a NoSQL DB (e.g. MongoDB, CouchDB).The basic premise is that it stores documents, each with their own particular indexes. Each tenant can have multiple document types.
e.g. One tenant might have an invoice type,which has Customer ID, Invoice Number and Invoice Date.Another tenant might have an application form, which has Member Number, Application Number, Member Name, and Application Date.So far I've used the old method which Sharepoint (used?) to use, and created a document table which has int_field_1, int_field_2, date_field_1, date_field_2, etc.Then, I've got a "mapping" table which stores the customer specific index name,and the database field that will map to.I've avoided the key-value pair model in the DB due to volume of documents.
This way, we can support multiple document types in the one table,and get reasonably high performance out of it,and allow for custom document type searches (i.e. user selects a document type, then they're presented with a list of search fields).
However,a NoSQL DB might make this a lot simpler,as I don't need to worry about denormalizing the document.However,I've just got concerns about the rest of the data around a document.We store an "action history" against the document.This tracks views,whether someone emails the document from within the system,and other "future" functionality (e.g. faxing).
We have control over the document load process,so we can manipulate the data however it needs to be to get it in the document store (e.g. assign unique IDs). Users will not be adding in their own documents,so we shouldn't need to worry about ACID compliance,as the documents are relatively static.
So,my questions I guess :Is a NoSQL DB a good fit Is MongoDB the best for Asp.Net (I saw Raven and Velocity,but they're still kinda beta)Can I store a key for each document,and then store the action history in a MSSQL DB with this key?I don't need to do joins,it would be if a person clicks "View History" against a document. How would performance compare between the two (NoSQL DB vs denormalized "document" table)Volumes would be up to 200,000 new documents per month for a single tenant. My current scaling plan with the SQL DB involves moving the SQL DB into a cluster when certain thresholds are reached,and then reviewing partitioning and indexing structures.
how 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 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].....
For the login control that I am using, there is a connectionstring which is automatically created in the web.config file.I ran an .exe file which populated the specified database with all the asp login related tables and stored procedures...
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=localmachineName;Initial Catalog=DBName;Persist Security Info=True;User ID=DBUserName;Password=password" providerName="System.Data.SqlClient"/>
How can I point the login control to a different Database based on the database selection by a user i.e. the user can change the name of the database and so the login should point to that database.
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 Repliesin index page I have dropdown list.. I need to get the values from database based on this dropdown list and need to show that values in the grid in same page index page..
View 9 RepliesI am using the following code to bind BusinessID as the DataValueField of the ddlIndustry dropdown. What I want to do is save the selected ID to a different table (Company). I am doing this with ddlIndustry.SelectedValue. For some reason, the first value is always saved (1), and not the selected value.
[code]....
I have Checkbox list from database and selection list also from database . i can fill check boxlist from db in below . i have one datatable for selection items .i want that values to be selected in this checklist.
dt pagelist have 1 to 10Â
dt checklist have 1,3,5,7
DataTable dt = obj.checklist();
public void pagelist() {
DataTable pl = obj.pagelist();
foreach (DataRow row in pl.Rows) {
ListItem item = new ListItem();
item.Text = row["Previlage_pageName"].ToString();
item.Value = row["Previliges_ID"].ToString();
CHpagelist.Items.Add(item);
}
}
i need to know how i can save more than 1 of the selected values from a checkboxlist to a database. I tried the following code.
ArrayList test = new ArrayList();
for (int i = 0; i < CheckBoxListMeest.Items.Count; i++)
{
[code]...
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MeestenEvaluatie_MeestGeAsp". The conflict occurred in database "GIPDatabase", table "dbo.MeestGeAsp", column 'EvMeestID'. The statement has been terminated.
I am trying to bind a record to a textbox using a Dropdown selected index change. I get the error.
Conversion failed when converting the nvarchar value 'DrFirstName DrLastName,Ph.D.' to data type int. is it because I concatenate the name and prefix of the DR into the Dropdown list like this,
Code:
SELECT ID,EmailAddress, DrName + ',' + PreFix AS DrName FROM DrNames
Here is the dropdownlist code that I want to populate the textbox with the emailaddress in the table associated with Dr name and ID.
Code:
Private Sub DropDownList1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles DropDownList1.SelectedIndexChanged
Dim dt As New DataTable()
If DropDownList1.SelectedItem.Text = "OTHER,..." Then
txtRx1.Visible = True
DropDownList1.Visible = False
End If
[Code] .....
How to query a SQL database with Dropdown Value Selected as All. Supportgrp is a Dropdown List, if i select All in the Dropdown List all
values from the database should be displayed.
I use the below code currently without All selection:
[code]....
I' using ASP.net2.0 and SQL server2005.I have installed AJAX toolkit.
i want to make a search similar to google search ie retrieve from a database a list based on user typing characters and clicking search.
i have used a text box and AJAX autocomplete extender .i have made a connection to DB and able to make a list from a field. But when i select one list elment and click search button it doesn't go into the Search button on click event.Without using autocomplete i'm able retrieve records and display it on data grid view.Do i need to convert the list returned to an array.
[code]....
I would like the user to select an item from a drop down list. Next to the drop down is a textbox or label control. From the ddl selection I would like to populate the textbox or label from a database with a corresponding field from the database the dropdownlist was populated from. On selectindexchange event I can populate the textbox with the Unique id from the value, but I need to input a different field into the textbox. Can I use some sort of variable to assign the Textbox.Text = ?
View 6 RepliesI would like to alter the query that is run, depending on the selection made by the user in a drop down list on the same page. Would this best be done using a partial page update (AJAX)? Ideally it would be great to have the textbox result change quickly once the drop-down list value has changed, without a full page postback. I would like to change the SQL query to a completely different query if the user selects an option different to the default (page_load value) in the drop-down list. I would then like the newly retrieved result to be displayed in the textbox as before.
My current VB function looks like this:
[Code]....
I was wondering if anyone can help me work out what the user has selected in this selection changed event?his is what I have so far:
protected void rblNavigation_SelectedIndexChanged(object sender, EventArgs e)
{
string url = (GetCurrentPageName()).ToString() + "?" + Request.ServerVariables["QUERY_STRING"];
[code]...
The problem is that rblNavigation.SelectedValue is not the value that the user has selected to trigger this event. How do I get the value the user has just selected?I'm using C# and this selection event is inside my MasterPage.
how to insert radio button selection into sql server database using parameter.
View 3 RepliesI have a forum on my website
what i need to do is to rewrite the url :
[URL]
to
[URL] to dogracer players
Is there any quick way to achieve this.
The rewrite should be dynamic because each posts in the forum should have a rewritten url
Just two many pages to re-write. A Microsoft consultant informed us it would cost about $750,000 to rewrite all of our pages. The school district's budget is only $67,500 so this is out of the question. Therefore I am going to have to stick to asp Classic.
View 1 RepliesI try to set the selection in the radiobuttonlist accordingly to data retrieved from the database.
This is not working (the mydata.gender contains "Mail")
mygender = myfatality.gender
i 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)
I need assistance on the following issues, i am trying to create a site which involve forum , i need code for the following. or i need schema and data type for
1. last post
2. views
3. replies
4. user onlines
5.total post
6. thread.
7.last post like less than 5 minutes
Hey guys, i have some problem here. How can i create a simple forum in asp.net? using wat toolbox?
View 12 Replies