Databases :: How To Alter The Controll File To Format
Apr 11, 2010
Im importing a simple data set using sql loader, below is the controll file im using...The field named 'CustName' imports all the records but surround them in the oracle table with single quotes ... eg 'Dave' .. not Dave.. how can i alter the control file to remove these sinngle quotes when the data is imported...The field named 'registered' contains data as 'true' or 'false' in the csv... i need to import this into oracle as 1 for true and 0 for false... how can i alter the control file to do this?
my control file is as follows:
OPTIONS (ERRORS=999)
LOAD DATA
INFILE "c: est.csv"
BADFILE "c: est.bad"
INSERT
INTO TABLE test
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
View 1 Replies
Similar Messages:
Feb 22, 2010
I am using asp.net 3.5 file upload control. I can browse the files when click the Browse button. Same time I can't browse the file when enter key is pressed while file upload control is in focus. I am using master page. I am in urgently need of this.I want to browse the files when enter key is pressed while upload file controll is in focus.
View 1 Replies
May 6, 2010
I have a table that contains image data type and has more than 20,000 records.I want to change its file group to the new file group. I tried to change it using table designer, but everytime I wanted to save it, it occured an error with this message:
[Code]....
Does anyone know how to change file group using Alter Table query? I'm using SQL Server 2005.
View 2 Replies
Sep 28, 2010
if i have field datetime = 2010-09-08 11:31:59.123
2010-09-08 17:42:08.737 2010-09-09 9:42:08.737
how can i group by only date? Eg: 2010-09-08 = 2 record 2010-09-09 = 10 record currently when i use group by datetime.. because of the time differece, so it show out all the row.
View 7 Replies
Sep 6, 2010
I am using Oracle 10g im my asp.net project. In my select query, i want to change the format to dd/mm/yyyy hh:mm:ss from mm/dd/yyy hh:mm:ss. The field datatype is date. How can i write a query for this?
View 7 Replies
Oct 21, 2010
I'm new to using databases with ASP.Net, and I'm trying to learn how to use the data found within one, such as MySQL, and format it to my liking. Since the transition to databases, I have been used to, and I am quite comfortable with, XML, XSD, XSLT, and the XML Data Controls. I am wondering how I go about displaying and formatting values from a database, as I would from a XML document. For example, using XML, I would say in an XLST file that for each node of a specific type, I would display the values of all the child nodes in boxes, with each node having its own box (similar to a blog). How would I go about doing this with soothing like MySQL? Are there equivalents to database style sheets like XSLT, or is there another way about styling, formatting, and displaying database values in a customizable way that doesn't only include tables?
View 1 Replies
Aug 24, 2010
My existing code converting xml in to excel and it is saving excel in .xls format.
But i need to save it in .xlsx format .
Existing code for converting xml...
[Code]....
Existing code for saving excel
var dialog = new System.Windows.Forms.SaveFileDialog();
dialog.Filter = "Excel Workbook(*.xls)|*.xls";
dialog.Title = "Save As";
I have tried by changing .xls into .xlsx but unable to open excel sheet.
View 1 Replies
Jun 27, 2010
I'm getting the above error when I get to the following line:
string result = Convert.ToString(command.ExecuteScalar());
am really confused because everything I've read tells me that that line is correct!
My code is as follows:
[Code]....
View 5 Replies
Jul 24, 2010
i have some excel file which export from sybase, but it can only export to Excel ver2.1.then I connect and import to SQL Database. The result is error and prompt cannot read the Excel format.Finally I try use Excel 2003 to open the exce v2.1 and save as 2003 version. Then import again, it can success to import to SQL database.my connection string excel properties = 8.0i tried to change 8.0 to 2.1 or 5.0, the result is still cannot import. how to import v2.1 directly. no need use Excel to open and save again.another question, if I want import more than one excel, how can I import all one time only.
View 2 Replies
Feb 17, 2010
I am a new user of ASP.NET 2.0 (VB.NET)
I am facing a problem related to GridView Control
I have a table <UsersDetail> with following structure in MySQL
[Code]....
how i can achieve this using GridView, ASP.NET 2.0, MySql.
View 5 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
Aug 15, 2010
i've been learning MVC now for 2 days, but I still can't wrap my head around it. ASP.NET MVC feels like learning Mandrin Chinese. So, I understand Classic ASP.NET and using an N-Tier archetucture, but how would you apply that to MVC? I comprehend View (the UI), Controller (the pipeline to the Model and View), and the Model (where your code goes), but how would you apply an N-tier to MVC? Or, a replica of the DAL? Yeah, it might be a stupid question, but I am not understanding the Framework. Does anyone have an article(s) that cleared your understanding of MVC? Maybe I need to buy a book....
View 4 Replies
Dec 31, 2010
is there any way to fill a controll type System.Web.UI.WebControls.Menu with data from database if i use ASP.Net MVC?
If yes how can i do this?
View 2 Replies
Feb 4, 2010
How can I set focus to a textbox while textchange event fired.The textbox placed inside a usercontroll and usercontrol place in a UpdatePanel.
View 6 Replies
May 18, 2010
I need a code which can export the data from XML file to the Excel file.
View 3 Replies
Feb 22, 2011
I wish to know how to convert the byte array file to a file in a string format and display it in a webpage. how can i perform this?
View 1 Replies
Feb 28, 2011
I am working on user controll.My user controll is loaded in .aspx page and that .aspx page is opened as Pop up window.I want to Pass control back to Parent page when i click on save button of user control which is in pop up window.
View 2 Replies
Sep 7, 2010
I have dropdown list I want to use the arror to click and control and select the value in the dropdown box , the first click select item1 .... How can I do that?
View 4 Replies
Jan 11, 2011
I've been strugelling to find a solutions to this, I've searched in the forum and none of the solutions worked for me , I need to highlight the slected item in the menu control which is in a master page. here is my code:the site is running under asp.net 4.0/.net 4.0
[Code]....
View 1 Replies
Sep 2, 2010
I have a Repeater control which contains asp:Button control in ItemTemplate. I want to handle Button's Click event, but when I'm clicking that Button the error is thrown: Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page.
View 4 Replies
Oct 26, 2010
I have a listbox controll and i want to bind it with an SqlDataSource.SqlDataSource must be declared in the code behind but i don't know where declare it(page init,page load...)and how to add sql parameter dynamically (parameters are the selected values of listbox, so they are multiple).
View 2 Replies
Jan 27, 2011
I have applied rounded corners styles to my ASP.Net button & text box controls and also to fieldset and legend.
[Code]....
But these styles aren't working in Internet Explorer(8,7,6). Please let me know any solution so that all of these styles will apply on these elements(asp.net button & textbox, fieldset & legend) in IE too!
View 8 Replies
Aug 14, 2010
I am using mysql and stored date in varchar format, and compare that with current date,i have stored like(dd-mm-yyyy) in database
i need to compare it with date in select query. How to take date from database in dd-mm-yyyy format.
View 1 Replies
Nov 9, 2010
I have this LIstView:
<asp:ListView ID="ListViewChiamate" runat="server" DataKeyNames="ID_Chiamata" EnableModelValidation="True">
<LayoutTemplate>
<table >
<tr id="itemPlaceholder" runat="server" />
</table>
</LayoutTemplate>
<ItemTemplate>
[Code]....
View 5 Replies
Feb 18, 2010
I need to change dinamic my image. So I've tried to store the value in a session and replace the null src to the new src.
But. When I do this It brings me a null value in the src;
View 2 Replies
