Database Storage - References In Table Or Another Location?
Mar 26, 2010
On a website such as Amazon, they usually have a prodcut description which is normally 2 - 3 paragraphs of description. Would these information be stored on a database, or would they use include files for those sections, would it be stored in an XML file? I have a website which stores everything in a database and for most of it the website works. EG, in my database, I have a table with Column Names such as ISBN Number, Book Name, Publisher Name and all of which don't go above 50 characters! In some cases, the descriptions go on and on over several paragraphs. Where should this be stored? In the table or in another location which the database references?
View 3 Replies
Similar Messages:
Feb 16, 2010
I am using Reporting Services to render a report directly to PDF. It requires that I use two web references: ReportExecution2005.asmx and ReportService2005.asmx. The performance on web references seems really poor. Since my web server (IIS7) and my SQL Server (2008) are on the same box, is there a way I can reference them directly? If not is there any way I can explicitly cache them or something. First load is really really slow, second load is perfectly acceptable.
View 2 Replies
May 8, 2010
I'm building a very simple ASP.NET MVC site that doesn't require a database and doesn't have user accounts or any other special ASP.NET stuff. When I first created the site with the ASP.NET MVC 1.0 site template in Visual Studio, the web.config page was configured to automatically connect to SQL Server Express as a User Instance.
Can I completely remove this dependency? If so, how do I get rid of all this database stuff?
View 1 Replies
Apr 18, 2010
I working on website and i have ready database from the company database. I have a table Location has only two fields : city andtate.I tried to get select the * city where state = something , but i think it is wrong,Is it a Many-to-Many realtionship
View 4 Replies
Feb 5, 2010
I am looking for opinions and best coding practices.I need to get info from a database with a query such as SELECT this, that FROM MyDB (returning 2 fields). Would it be wrong to use a hashtable for temporary storage?Is there a better way to accomplish the same thing? What about if I am returning more than 2 fields, would it be best to step up to a DataSet or something?
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
GetData();
[code]...
View 7 Replies
Sep 7, 2010
Here's a short explanation of my asp.net project.
1) the default page loads, it will read the Windows Login of the user opening the page.
2) I'll check if this login exists in a table stored on the webserver.
In this Access Database, there's a 2nd linked table, pointing to another access table on a network location. Now, I want to read data from this linked table. However, at this moment I receive an error:
"The Microsoft Jet database engine cannot open the file '\<ip><shared-folder>statistics.mdb'. It is already opened exclusively by another user, or you need permission to view its data".
Some extra info:
- The network folder has read and write permissions for everyone
- the user and group permissions on both access files are set to read/modify/administer for the Admin user (on the tables I want to read from)
- IIS authentication on the server is set to "Windows Authentication" (this is needed so I can read the Windows Login from the user). All other authentication modes are disables (like anonymous, ...)
- When the error occurs, no other program or process has access to the statistics.mdb (so, it can't be locked by someone else)
- the web.config files access connection string looks like:
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\<IP><shared-folder>statistics.mdb;User Id=admin; Password=;" />
Like I said before, in this statistics.mdb file, there are 2 tables. One normal table, and another linked table (pointing to a network location)
Searching for solutions, I discovered the following:
- if I don't use linked tables, everything works fine (however, I have to use this linked table)
- even if I connect directly to the table in the network I receive the error. So, I'm pretty sure I don't have sufficient rights to read from this table.
I read that not the Admin user is opening the file, but actually a user called ASP.NET. This user doesn't have the correct rights to do this. However, I'm not sure if this is true.
View 5 Replies
Jul 22, 2010
I have a requirement where I need to generate a pdf doc.I am using itextlibrary for that condition.I am able to generate pdf doc but alignment is not correct.The table is getting divided in to two equal parts for two columns in pdf doc for what ever width I specify.For ex if I have set width as 650px its not taking that width in pdf doc instead it is taking full doc.How to set the table at desired location in pdf doc and set width of columns.I tried to set width of column in the html table but its not working.
StringBuilder strHTMLContent = new StringBuilder();
trHTMLContent.Append("<table style='font-family:Times New Roman; font-size:18px;'>".ToString());
strHTMLContent.Append("<tr><td width='100px'>column1</td><td width='300px'>column2</td></tr>");
strHTMLContent.Append("</table>");
[Code]....
View 3 Replies
Jul 10, 2010
just installed VS2010 from MS site.it comes with some of the membership stuff like login/register etchowever, i want to know where the database is. here is what the webconfig shows:
connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
View 3 Replies
Mar 3, 2010
this might seem REALLY simple but i'm not a genius...anyway, i know i saw this somewhere: here's what i want to do: link the web.config file to my membership database...which i am going to put on a separate server on the network.
View 9 Replies
Mar 26, 2016
URL....This link shows a demo that let user to put origin and destination then get direction. I want to know how to add a option which is let user to use their current location as origin location (Location from).
View 1 Replies
Apr 7, 2010
I have a table in my database, in which a certain field holds the locations of text or doc files (the files are of a transcript for a chat session).
In the Gridview right now i able to show the link locations. But i want to have Hyperlink or Button in the links location in the Transcript Location fields.And on the click of which the txt or doc file opens up in notepad or microsoft word.
View 2 Replies
May 7, 2015
Following is my code when user enters hospital name and city, he will be navigated to this page to show location on map. Now I want to get user current location and draw the route between current location and destination. Is there any way to integrate to geocoding and geolocation?
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style>
html, body, #map-canvas
[Code] ....
View 1 Replies
May 11, 2010
I'm trying to include script and style references that will not break on deployment, however I can not even get the references to work locally. I have tried using Url.Content() and MVCContrib's <%=Html.ScriptInclude("")%>.
My scripts are in a Scripts folder on the root of the site; my styles are in the usual Content/css/ folder.
The scripts render like this:
<script type="text/javascript" src="/Scripts/MicrosoftAjax.debug.js" ></script>
This will not work in a view page in the Views folder. What am I doing wrong and what is the best way to handle this?
I would have thought Url.Content() would at least work for styles but used in my master page, the link rendered
<link href="/Content/css/Site.css rel="stylesheet" type="text/css" />
This does not work, because the Master Page is in a Shared folder, so what is really the way forward with this?
View 2 Replies
May 3, 2010
we have some files in our web app which saved in database.
how user can download files from our web site which exists in database (and not physically saved) ?
View 3 Replies
May 7, 2015
This is code for searching latitude and longitude . so how to save into database.
function GetLocation() {
var geocoder = new google.maps.Geocoder();
var address = document.getElementById("txtAddress").value;
geocoder.geocode({ 'address': address }, function (results, status) {
if (status == google.maps.GeocoderStatus.OK) {
var latitude = results[0].geometry.location.lat();
[Code] .....
View 1 Replies
Mar 28, 2013
I find this code it get me location but i don't know how to save client location in sql database to retrieval it Later
<html>
<head>
<script src="http://maps.google.com/maps/api/js?sensor=false">
</script>
<script type="text/javascript">
if (navigator.geolocation) {
[Code] ....
View 1 Replies
Sep 5, 2010
I have a table in my aspnet database. I added a bottom row "Not Selected", if the user doesn't select from a databound drop down list. This row is at the bottom, because I just added it to the table data. Is there any way to move this one row to the top of the table manually? There is not "cut" and "paste" when I select the whole row.
View 3 Replies
Nov 1, 2010
i am using this query but it is giving syntax error,
insert
into Logistics.DisInventory
values
select *
from Logistics_v1.DisInventory)
View 4 Replies
Feb 8, 2011
how to get the excel data table into sql database table..i need the code in vb....
View 1 Replies
Mar 24, 2011
then the database table is created in database(that is SQL express),how can do that.Please sir help me in that problem.I try that thing and debug the code and there is no error in the code but when I click the button in run time ,no table is created in the database(which is placed in sql express 2005).So my problem is that why the table is not created in the database.
[code]...
View 3 Replies
Mar 20, 2011
My question is that if the user click on button (which is place in default.aspx, for example) then the database table is created in database (SQL express), how can do that? I have tried but errors are occuring during debugging, errors are:the best overloaded method match for 'system.data.odbc.odbc command.odbc command(string,system.data.odbc.odbc connection)'has some invalid arguments.
Argument'2':cannot convert from 'system.data.sqlclient.sqlconnection' to 'system.data.odbc.odbc connection'.
The code written in c# behind the button (button is placed in default.aspx, for example) is:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
[code]...
View 2 Replies
Mar 24, 2010
I have a database and i what to pull different columns from a row without having to but it in a datagrid. I know this is 1st grade stuff. :)
View 5 Replies
Jan 10, 2010
A few years ago, when first being introduced to ASP.net and the .NET Framework, I built a very simple online file storage system.This system used Rijndael encryption for storing the files encrypted on the server's hard drive, and an HttpHandler to decrypt and send those files to the client. Being one of my first project with ASP.net and databases, not understanding much about how the whole thing works (as well as falling to the same trap described by Jeff Atwood on this subject), I decided to store freshly generated keys and IVs together with each file entry in the database.
To make things a bit clearer, encryption was only to protect files from direct access to the server, and keys were not generated by user-entered passwords. My question is, assuming I don't want to keep one key for all files, how should I store encryption keys for best security? What is considered best practice? (i.e: On a different server, on a plain-text file, encrypted). Also, what is the initialization vector used for in this type of encryption algorithm? Should it be constant in a system?
View 2 Replies
Dec 26, 2010
User images - database vs. filesystem storage
Where should i store photos for a facebook-like app ? locally on the server in a folder or upload them to a database ? I am not intending to make this app commercial .
View 2 Replies
Mar 8, 2011
i have database in internet ,its now on my server by using ip and username and password but this database is empty table ;i have database on my pc how can i copy all table from this database to new dabase with relation and procedure..?
View 3 Replies
