i am trying to read CSV file ,but here the problem is csv file contains field values mixed of special characters.whil e trying to read csv wherever occur special characters it ignore that record.it take only alphabets records.i need with special characters records also.
using Microsoft provider to load the file.
Any help is greatly appreciated.
ramanan ram
Last Activity: Jan 22 '13, 04:25 AM
Joined: Feb 13 '12
Location: CHENNAI ,TAMILNADU,INDIA
-
how to read csv file in asp.net
-
how to move one schema db to another schema db using toad 9.5?
hi,
i trying to move one schema tables with constraints ,functions and procedures to another db schema.
example:
from :db name: poms,
schema :pipeline
TO:
db name: prmy
schema: tapestry
please give solution... -
How to read an Excel file in ASP
...Code:<% if session("UserName")="" then %> <script> alert("Sorry, Session timed out"); window.close(); </script> <% response.End() end if %> <!-- #include File="../../dbConn.asp"--> <!-- #include File="../../general/CommonFunctions.asp"--> <style type="text/css"> -
ramanan ram replied to ORA-01445: cannot select ROWID from, or sample, a join view without a key-preservedin Oracle...Code:select v4.JOBREFNO AS INV, V1.ORIGIN_FV_PRQ,V1.PDFNAME_PRQ,V1.COUNTRY, V1.VESSELNAME_FV_PRQ, V1.VOYAGENO_FV_PRQ, to_char(V1.ETD_FV,'dd-Mon-YYYY') as ETD_FV, to_char(V1.ETA_FV_PRQ,'dd-Mon-YYYY') as ETA_FV_PRQ, V1.ORIGIN_PRQ, V1.SHIPPER_PRQ, V1.BILLTO_PRQ,V1.BILLTOPREPAID_PRQ, V1.POID_PRQ, V1.STYLE_PRQ, V1.MVSNO_PRQ,V1.VESSELNAME_PRQ, V1.VOYAGENO_PRQ, V1.HBL_PRQ, V1.JOBREFNO_PRQ, to_char(V1.JOBDATE_JOB,'dd-Mon-YYYY') as JOBDATE_JOB, V1.SUPPLIERINVNO_PRQ,
-
ramanan ram started a topic ORA-01445: cannot select ROWID from, or sample, a join view without a key-preservedin OracleORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved
i am using a view query in oracle.if i am run the query successfully executed.but,th e same query applying in asp page(front end)it's showing ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table.
please help... -
how to take full database backup using toad
i am using oracle 10g with toad editor ,i want to take full back up of specific database .i tried through recovery manager but its not working.
please help..
thanks in advance.. -
rski i tried this query but insufficient privileges error display ..
thanks in advance..Leave a comment:
-
how to grant sysdba privileges to user
i am using toad11.5 version ,here a schema name is(ex:sa) database name(ex:wttest) .i need full backup of wttest DB.
now i am trying to get through rman(recovery manager) script in databse browser.here, its showing one message 'you must have the sysdba privilege to use RMAN'
how can i give the sysdba privilege grant to the user .
but i tried,while i am open the user in tns,mode set as sysdba .but its showing insuffient... -
dbcomm.parametr s.clear(); within in for loop
add this line.Leave a comment:
-
how to dataset values pass to procedure in asp.net
i am using .net(c#) with oracle. now,the Dataset contains five rows.using for loop that dataset value to pass the procedure argument and insert into specific table.if i am execute cannot inserted into the table .but without for loop single row inserted successfully.ho w to pass dataset more values to procedure argument.
here that coding:
...Code:for(i=0; i < objDataset.Rows.Count; i++) { if (objData -
how to pass dataset more rows in asp.net
i am using .net(c#) with oracle. now,the Dataset contains five rows.using for loop that dataset value to pass the procedure argument and insert into specific table.if i am execute cannot inserted into the table .but without for loop single row inserted successfully.ho w to pass dataset more values to procedure argument.
here that coding:
...Code:for(i=0; i < objDataset.Rows.Count; i++) { if (objDataset.Tab -
ERROR: ORA-01036: illegal variable name/number asp.net c#
i am trying to read the excel data in asp.net.now the coding status is excel data stored to dataset based on that i have a stored procedure backend oracle.
...Code:String sql = "pro_fielding_poms_insert"; dbcomm.CommandType = CommandType.StoredProcedure; for (i = 0; i < objDataset.Tables[0].Rows.Count; i++) { if (objDataset.Tables[0].Rows[i].IsNull(0)) -
System.ArugumentException in asp.net c#
i am using enterprise library program in asp.net with c#.
Database conn1 = DatabaseFactory .CreateDatabase ("con");
this line written in datalayer while execute the occur
System.Arugumen tException Unable to find the requested .Net Framework Data Provider. error
webconfig file:
...Code:<add name="con" connectionString="Provider=MSDAORA.1;Data Source =PRMY;User ID =xxxuserIDxxx;Password
Last edited by Frinavale; Apr 9 '12, 03:23 PM. Reason: Removed sensitive database connection information. -
System.IndexOutOfRangeException: Cannot find table 0.
hi..
here,i am getting
System.IndexOut OfRangeExceptio n: Cannot find table 0.this
error.
coding:...Code:OleDbConnection conn1 = new OleDbConnection(conn); conn1.Open(); string sql = "SAMPLEPROCEDURE"; OleDbCommand dbcomm = new OleDbCommand(sql, conn1); dbcomm.CommandType = CommandType.StoredProcedure; -
how to assign select statement value to text box
the above coding empid value getting from previous page .this field primary key in the table for example:the...Code:string sid; if (Request.QueryString["empid"] != null) { sid = Request.QueryString["empid"]; OleDbConnection conn1 = new OleDbConnection(conn); String sql = string.Format("SELECT * FROM ADDRESS WHERE EMPID = {0}", sid); conn1.Open(); } -
asp.net using stored procedure
I am using addinparameter( ) with in that I am getting procedure argument.
But the page cannot accept this addinparmeter() method.
error:missing system.data.ole db connection(are u missing assembley reference)like showing .but i am added this system.data.ole db namespace
program:
...Code:using System; using System.Collections; using System.Configuration; using System.Data; using
-
checkbox control in asp.net
i am using asp.net with oracle,now i am selecting the record [B]for example: table name emp it contains 50 records now display whole records in asp executing page each records end i am added checkbox control ,if i am choosing any one of the checkbox then press submit button that corresponding record want to delete based on the autoid.
this id field i am maintaining [ /B]
plz give solution
thank u
RAMANAN RA... -
calender format in asp c# page
i am creating the web page its one of the field is
date ,this is between option so i need to apply here two calender .if i am clicking date image want to show calender
plz give the solution -
how to change directory in oracle
i am creating a directory in C:\ram.txt
but i need inside D:\ram.txt how to move that file -
create new directory for that path give directory name
after creation u pass only directory nameLeave a comment:
No activity results to display
Leave a comment: