Databases :: Store Data In File System Rather Than SQL Or Oracle
Jul 23, 2010
As I am working on Employee Management system, I have two table (for example) in database as given below.
EmployeeMaster (DB table structure)
EmployeeID (PK) | EmployeeName | City
MonthMaster (DB table structure)
Month | Year | EmployeeID (FK) | PrenentDays | BasicSalary
Now my question is, I want to store data in file system rather than storing data in SQL or ORACLE.
I want my data in file system storage for Insert, Edit and Delete opration with keeping relation with objects too.
I am a C# developer, Could anybody have thoughts or idea on it. (To store data in file system with keeping relations between them)
View 1 Replies
Similar Messages:
Jan 5, 2011
We have the data in excel file and want to upload the same into Oracle table.To achieve this we are using following query
insert into [ODBC:Driver={Microsoft ODBC for oracle};connectionstring].tablename (select * from sheet$ )
This is working fine for less records but when the record count increases following is the error faced. Error : System Resource Exceeded
We tried the following:
1. We tried to remove connection pooling for oracle.
2. We tried to remove connection pooling for excel.
3. We also verified that only one connection for each (oracle and excel) is open.
Our assumptions:
1. Either the server setting is the issue
2. Jet oledb Driver is the issue.
View 1 Replies
Jul 20, 2010
Getting the following error when browsing .net 2.0 application System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
I have setup a .net 2.0 application with oracle backend on windows server 2008 R2. I have oracle client 11g installed on the server for the application to talk to the oracle database. This worked well when the .net 2.0 application was hosted on windows server 2003 and oracle client 10g. But when it is hosted on server 2008 with new oracle client it is giving the above error when browsing the page. This error occurs when the connection is opened inside the c# code.
View 3 Replies
Feb 21, 2011
how to store & retrieve image in asp.net with oracle database.
View 2 Replies
Jun 9, 2010
How do I read excel(with many worksheets) using asp.net c# and load the data into oracle database?
View 2 Replies
Oct 20, 2010
I am goig to execute an oracle store procedure using C# through through ODP.NET. The store procedure executes succsfully but it does not return any value in the out parameter.
When I execute the same store procedure with the same input parameteres from within SQL*Plus. It does return values.
This is to be clearify here that in the oracle store procedure the data type for the out parameter is number and in the c# the variavle that will hold its value is Integer. I also tried using Long on the C# side but it is still not working. After the successfull execution of the store procedure the C# variable contains nulll value.
View 3 Replies
Feb 14, 2011
website using text file to store data and display it using html codings. The requested website must be able to do the following functions:
1) Browse for template using txt file and select the txt file as template. (Font-styles, headers, tables....etc)
2) Browse for txt file that stores the data and display them in a so called table format categorized properly.
3) Able to do a search function and store the search results in a new txt file. (Which means a new txt file is created everytime someone performs a search and the search results is stored in the new created txt file)
Is there any website with informations/tutorials on these?
View 5 Replies
Jan 25, 2011
How to read xls file data and store in sqldatabase...
View 1 Replies
Jan 18, 2011
I would like to upload a xlsx file to Oracle DB (Oracle 11g). I'm using VS .NET 2008 (C#, web).
The file contains around 500 rows.
View 3 Replies
Jan 28, 2011
I have a vs2008 web application. it built fine and it was runing fine use visual studio development server, but when i use IIS web server, it gave me the following error.
Server Error in '/Vendorapplication' Application.
View 10 Replies
Aug 29, 2013
I am working on a journal website where user submit manuscripts , pdf files , is it good idea to store pdf files on directory or on database.
View 1 Replies
Nov 22, 2010
Can i save the contents of a word file (which contains some formatted text) in clob field and then retrieve them in their original state i.e can i save the formatted text in clob field like we can save it in blob field?
View 1 Replies
Jan 12, 2011
i like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..
View 5 Replies
Mar 15, 2011
have a sp in oracle which has 3 input parameters and 3 output parameters( 1 ref cursor, i number, 1 varchar2)
Command.CommandText = sp name;
Command.CommandType =
CommandType.StoredProcedure;
i am doing cmd.ExecuteNonQuery();I am able to get the number and varchar2 values from output parameters. But i am unable to get output from Ref Cursor. (How can i get this...)If i use dataadaptor then i am getting the datatable in the dataset(but i am not getting the other two parameters(where will get the other two??)...
View 2 Replies
Apr 20, 2010
my data base is oracle and i'm fetching simple data id, desc from table into a data set. But i'm getting only id and my desc field is showing blank.
my table is like this id number, desc nvarchar2(100)
View 1 Replies
Jan 20, 2011
I'm using ASP.NET C# with the v3.5 framework, and need to grab data from the session and insert it into an Oracle database. I can connect to the database and manually insert data from a couple of controls I created. However, I have an application with multiple forms that stores data in the session as the user navigates between the forms. The form information is stored in DataTables, with a separate DataTable for each form. I have an idea of how to retrieve the data, but was wondering if I have to code queries to map each field in the database to the fields in the forms? Or is there a way to "give" the database the information from the DataTable and have it insert each of the values?
View 5 Replies
Dec 1, 2010
I want to do a bulk data transfer from Oracle 10.2G into CSV or Excel sheet.I would either want that an entire table's data be populated into EXcel/CSV or the result of a select query be so populated.
1)Is there any stored procedure or function that can do this?
I know of a function in postgres which does this kind of a thing.There could be something similar.The second thing is the reverse of it.I want to transfer the contents of a CSV file into a oracle table after truncating it.
2) What sp or function is available for that?
View 2 Replies
Mar 18, 2010
I am facing problem..how to read Excel file from the 5th row onwards and how to store the all records into Database Note: More over i do want store few coloumns records(3 out 8) only in my database. consider this point.
View 4 Replies
Nov 4, 2010
This is the exact error I'm getting:Server Error in '/' Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the
Source Error:
Line 1: <%@ Master Language="VB" CodeFile="MasterPage.master.vb" Inherits="MasterPage" %>
Line 2:
Line 3: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
View 3 Replies
Jan 30, 2010
Which is the better alternative when allowing file uploads on a page (through a Gridview populated by a coded DataSet)? Store the image itself in the database or to store only the path name to the saved file in file system. If it matters, I do not expect to have more than a few dozen images stored in the database at any given time.
View 7 Replies
Mar 17, 2010
I need a place to store images. My first thought was to use the database, but many seems to recommend using the filesystem. This seems to fit my case, but how do I implement it?
The filenames need to be unique, how to do that. Should I use a guid?
How to retrieve the files, should I go directly to the database using the filename, make a aspx page and passing either filename or primary key as a querystring and then read the file.
What about client side caching, is that enabled when using a page like image.aspx?id=123 ?
How do I delete the files, when the associated record is deleted?
View 1 Replies
Feb 8, 2011
How can i upload a file using fileupload control from an asp.net form and store it in systems harddisk and just have a tag of that file in sql database... and also how to retirve that file for download.
View 8 Replies
Jul 27, 2010
I want to know the best way to transfer data from a view in Oracle database 10g to Sql Server 2008.
View 1 Replies
Feb 4, 2011
am in deep trouble with retriving the data from oracle database. Please HELP ! In one line: "When i retrive the data from oracle database, it's truncate the data if it is more than 4 kb"I have oracle proc param as below:
PROCEDURE p_GetData (
ivar_id IN id_n%TYPE,
oclb_owners OUT CLOB,
onum_sqlcode OUT NUMBER,
[code]...
View 8 Replies
Feb 10, 2010
I`m extremely newbie to asp.net and oracle but i need to make a very simple project where asp.net inserts/updates data is oracle db. A managed to the connections, everything, made a DetailView of the DB data on the page, enabled in the Advanced SQL Generation Options the "Generate INSERT, DELETE and UPDATE statesments". Here is the code:
[Code]....
But unfortunately this does not work! I get the following error:
[Code]....
Oracle gives me creeps with these invalid characters and dates.
View 3 Replies
