i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
I want a piece of code for asp.net 3.5 using visual basic. and i am using MS access database.
I have two three text boxes and 2 image upload controls and a submit button.
I want a piece of code in which a user can upload images and store it in our database . i want an asp.net visual basic working code. also i need query behind the submit button.
when i first made the DB i used access 2010 which uses the 2007 file type which supports attachments, however asp.net doesnt support the 2007 format. and the 2003 file type doesnt support attachments, i assume i use the OLE object data type but i have no idea how i get my aspx page "new.aspx" to upload an attachment. plus i want to restrict the file type to *.jpg
I'm not a core web programmer. I'm building an web application which will track defects, using ASP.Net and MySQL. There is a requirement for me to attach multiple files to each review/defect.
how to upload files to MySQL and generate link for the uploded files in the ASP.Net form? Also when the user clicks the link I need to retrieve the file from the MySQL database and download the file to a directory in the client pc.
I have a page within our site that allows admin users the ability to upload configuration settings into the system instead of submitting 1 at a time.
While testing yesterday, i found that one of the upload pages allowed me to upload a excel file that had alot more columns than expected and when i checked the database, the first few columns that were expected took the values from the file, and everything else was ignored, but wanted to see if there is any way to check the number of columns in the file to make sure it matches the upload logic before accepting it.
I have a project using vb.net with mySql and mySql.Data.dll as a link to the database. Now when I test my website from local computer and with live server connection string all works fine. The thing is, when I upload my files to the server, it gives me an error Object reference not set to an instance of an object.I have copied the mySql.data.dll file to the bin folder of my domain and the query that gives the error is a basic insert statement that works from the local machine to the live database.
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.
i want to find data from excel sheet using c# my excel sheet like this
Sr. No. Store Code Store Name City State 1 3062 C.G.Road. Ahmedabad Gujarat 2 3103 Iscon Mega Mall 2 Rajkot Gujarat 3 3113 New Gandhi Nagar Ghaziabad Delhi 4........................
at our office we take daily backup of ASP.net application ms access backend for the next few days we need to evaluate the changes made to records in the database tables at the end of each day i want to compare 2 access databases first database is the backup of yesterday and second database is the backup of today i thought of the following algorithm, how to proceed to compare the datatables / gridviews
i need to display th rows / cells containing the differences / updates / deleted data
I am trying to make connection to a remote database server and I am getting the following message. I think i have to grant access to the client maching from my database server.. How do i grant access to an ip addess?
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'thelp'@'123.29.14.30' (using password: YES) ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'thelp'@'123.29.14.30'(using password: YES)
I created a new database with the help of Database Configuration Assistant !I created with the scott account.Now i'm not able to connect to the database with the connect identifier with the scott account.The error i get is.,
ERROR - ORA-12154: TNS:could not resolve the connect identifier specified.
I'm learning to use webmatrix via the tutorials on the website. I've had success with all table operations, when only using one table. I'm using the following address to access the site uredi_let_padalce.cshtml?LetId=4 and the is code:
[Code]....
The page works if I write: where LetId=4 instead of @0. But if I leave the variable I get the following error: The column name cannot be resolved to a table. Specify the table to which the column belongs. [ Name of ambiguous column = LetId ] If I specify the table name LetId_PadalecId. LetId=@0, then I get the parameter missing error. How could I tell the server which LetId I want?
Below is our error message. This happens around 5 - 7AM daily, and we are struggling with identifying the root cause. It's hard for me to believe it's code related, but anything's possible. Still, what's odd is the app runs fine for a day then an IIS reset is done and everything is fixed. Is there any way this could be related to code and has anyone dealt with this error before? Could a job or some permission being run behind the scenes be using this same dll and cause it to be overwritten?
Timestamp: 3/4/2010 12:11:23 PM Message: HandlingInstanceID: 3d9a795c-1256-44c1-b018-f553d4023b12 An exception of type 'System.TypeInitializationException' occurred and was caught.