Forum Array

Databases :: Error Executing Oracle Package / Message ORA-06550: Line 1, Column 7

I'm getting this error and I am not able to resolve somehow. I have an ASP.Net application calling an Oracle Package and I am getting this error: "Message      "ORA-06550: line 1, column 7: [code]....

View Answers

Very Similar Questions

Databases :: How To Check Space On Oracle Database Server
I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend. I need to know two things: (1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts. (2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?

Catch In Oracle Grace Period Message?
I use an Oracle database in a PHP application. A user tries to connect to the PHP application. His password has expired, but the grace period for his user's profile isn't null, so he can still connect to the application. What I would like to do is recognize that this user should change his password and display him a message. I've tried with oci_error(), but it doesn't return anything as there were no failure in connecting to the database with this user. I would like to catch ORA-28001 (and ORA-28002) Unfortunately, I can't do any change of structure in the database itself (add extra table or extra field).

Won't Boot - Error Message
I can't boot to Windows 7. It says that Windows could not verify something about this object. Windowssystem32winboot.exe Anyone got anyway to fix it so I can boot to windows 7? PS: I used Vista Boot Pro, and for the boot loader option, I clicked Install Longhorn Bootloader. Could this be the problem?

Error Messages When Speakers / Headphones Are Not Connect
I am having a rather strange issue which, although is not hindering the use of my computer, is still something that I would like to try and resolve. I purchased a Dell Inspiron 545 about a month ago (first week of Oct. 09). Given that Windows 7 wasn't available at that time to the general public, my new computer came with Vista Home Premium. My computer does not currently have an aftermarket sound card; I only have the OEM one that came with the computer. Also, I currently do not have any speakers or any other external audio devices that are currently hooked up to my computer. While I was using Vista I never had any problems or warning prompts appear when using audio programs like iTunes even though I didn't have any external audio devices connected to my computer. No problem there. When I received my copy of Windows 7 Pro I decided to do a clean install on my computer. After installing 7 I went through and manually installed all of the audio drivers that were on my computer when I received it from Dell (note: although the audio drivers were the same the re-installed ones were the updated versions designed for Win 7). I didn't use the driver disk that came with my computer though, because of the hassle of using those disks. Instead I manually downloaded the drivers that I needed from the Dell support page. After re-installing all of the drivers, updates, and programs on Win 7 I noticed the following: every time that I opened an audio program like iTunes I would receive a warning prompt claiming that "iTunes has discovered a problem with your audio configuration; audio may not operate properly". Furthermore, I have a Sony voice recorder that I use for school and the program for the recorder gives a similar error message claiming that "the file cannot be played back; check your audio drivers or operating system". In addition, this error message prevents me from editing any of the voice files I have saved on my computer. But the strange thing is that all of these error messages disappear when I plug in my headphones. The messages go away, I am allowed to edit my voice files, and the sound works great. As I said above, the audio drivers I currently have installed are identical to those that originally came with my computer. Given that I had never received similar error messages when not having speakers or headphones hooked up to any of my past computers or to my current computer before I installed Windows 7, I am assuming that the operating system is the culprit. Has anyone else experienced this problem and if so, do you know how to fix it?

Linux - Can't Connect To Database Server Error 111?
I installed mysql server on linux box IP = but when i try to connect to this IP it alway error(111). but use localhost and is OK. beer@beer-laptop# ifconfig | grep "inet addr" inet addr: Mask: inet addr: Bcast: Mask: beer@beer-laptop# mysql -ubeer -pbeer -h192.168.1.100 ERROR 2003 (HY000): Can't connect to MySQL server on '' (111) beer@beer-laptop# mysql -ubeer -pbeer -hlocalhost Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 160 Server version: 5.1.31-1ubuntu2 (Ubuntu) Type ';' or 'h' for help. Type 'c' to clear the buffer. mysql> beer@beer-laptop# mysql -ubeer -pbeer -h127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 161 Server version: 5.1.31-1ubuntu2 (Ubuntu) Type or 'h' for help. Type 'c' to clear the buffer. mysql> Connect from another machine it also error 111. another@another-laptop# mysql -ubeer -pbeer -h192.168.1.100 ERROR 2003 (HY000): Can't connect to MySQL server on '' (111) How difference between use localhost/ and in this case. I don't know how to connect to this database from another machine.

Script In The Command Line, Does Is Execute With The Read/write Permissions
When you run a php script in the command line, does is execute with the read/write permissions of the current user or what?

Jquery - Getting An XML Error Messages For JSON?
UPDATE 2: I did not mention that I do not get the error below in Chromium, but I do get it in IE8. UPDATE 1: Response Headers: HTTP/1.1 200 OK Date: Fri, 20 May 2011 15:40:23 GMT[code]..... Why does that happen and how can I stop the error message from appearing?

Compile Error -, Line 1 Unexpected '@' Encountered
I'm using Flash Pro CS5. My FLA file's code says #include "" holds my code, and starts with "@estr = function ()" When I go to export movie, I get ", Line 1 unexpected '@' encountered" Why do I get this message?

ActionScript 1/2 :: Error: "Scene=Scene 1, Layer=Nav Bar, Frame=1: Line 12: Unexpected '}' Encountered...
The following script is giving me a syntax error...    Error:  "Scene=Scene 1, Layer=Nav Bar, Frame=1: Line 12: Unexpected '}' encountered }" on(release){     if(_root.textVar != 1)     {          for(int i = 0; i < 5; i++)          {               unloadMovieNum(i);          }          _root.textVar = 1;          loadMovieNum("mc_TextBox.swf", 0); } }

Hyperlink Column In Gridview - Getting Error On Clicking Link
I have a site with a functioning database for members displaying location info. One column is shows their web address. When I set this column to be a hyper link column and then go online and click the link, I get an error. It seems that the database thinks this link should point to a page within the site instead of the home page of a completely different web site url. What property do I need to set to get the link to send the visitor to the member web site? I used VWD 2005 to create the site and use SSMS Express for changes on the remote server.

MVC :: How To Replace The Default ModelState Error Message
I need to replace the model state resource (to another language). I've seen some answers to the question above, but unfortunately I could'nt make it work using MVC 2 preview

Error Message Near The End Is Always Displayed?
I have tried to run the following code but the error message near the end is always displayed   Partial Class _Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles  Dim conn As New SqlClient.SqlConnection 8:      Dim comm As New SqlClient.SqlCommand 9:      Dim Users As SqlClient.SqlDataReader

ADO.NET :: EF4 CTP4 - Getting Error Message
Im getting this error message [Code].... global Application_start [Code]....

MVC :: Add Link To Error Message?
I have a form with username.In case if username is blocked, I need to add link to restore user profile.E.g.: In controller in validation function [Code]... It almost works,but error message is html encoded.What is your thoughts and how it should be in the right way.

Databases :: Custom Oracle Exception Handling?
I have a web page with 5 textboxes (for branch_id, street, city, state, and zip) and a button. When data is entered in the textboxes, the button is clicked and the data is populated in the database. I have the sql INSERT statement ("insert into branch values(:branch_id, location_type(:street, :city, :state, :zip), staff_nested())") in both the SELECT command and INSERT command. It was originally in just the SELECT command, but I also added into the INSERT command in case I need to do something in the on_insert or on_inserting event. I'm not sure if that would actually work since I click the button to enter. Anyway, if a duplicate key is entered in branch_id the error "ORA-00001: Unique constraint violated" is raised. I would like to change this and put my own error message, such as "ID is already used, select another." What I have so far is below. I do still get the same message. Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Try Catch ex As OleDbException [code]....

Image Insert Into Database - Oledb To Connect With Oracle
i am using oledb to connect with oracle from i am inserting image into my database.i could insert large and samll image into database. but i couldn't update large image with small image. ie if i insert small image(50kb)and if i want to update small image with large image(200kb) it is not updates with null value. i don't know why.

Databases :: Connect Oracle Using Microsoft Visual Web Developer?
I'd like to connect my Oracle Server Database 11g (in another machine) with the default project of Microsoft Visual Web Developer 2010. I did : Start A new Project : ASP.NET Web Application The design fit very well with my simple needs, so i've modified the css file and some apsx for my project, and i'm trying tu use Oracle instead of SQL-Server I've downladed ODTwithODAC112012 from the Oracle website, and installed it. First problem i thought that it will recognize Visual Web Developer as a Visual Studio solution, but it doesn't ! so in the Project/Add Class i haven't Oracle.DataAccess In fact i just want to use the authentification from Oracle to log my user, using my tnsnames. What i should i do to get it, or do i need to use another way ? In the Web.config file there's a lots of definition like "provider", that i don't know how to use  !! is there a typical way to do with oracle ?

Winform Control Hosted In IE, FileIO Security Exception / How To Solve This Error Message
I see a message on: winform control hosted in IE, FileIO security exception. I have got the same problem, which I cannot figure out what is the solution for weeks. I have Windows 7 (Home premium edition), framework 3.5 (how can I check that, if gacutil is correct version, if it metters, anyway ...) I am writting on C#. Also on assemblyInfo.cs : [code]....

Web Forms :: Date Validation Causing Multiple Error Messages?
When i click on the Search Button OR the Count Button, i get BOTH error messages - why ? I should only get one error message. [Code]....

Databases :: Getting The Column From Sql Or Dataset?
[Code].... This is the part where I check whether there is an output   [Code]....  Using the same sql as above, I obtain the value of the column using the datareader Am i doing it correctly because i dont get the output that i wanted

Getting Error While Adding Identity Column To Datatable?
I am getting the error while adding identity column to datatable. DataSet ds = new DataSet(); ds.ReadXml(_absPath); DataColumn identity = new DataColumn("ROWINDEX",typeof(int)); identity.AutoIncrement = true; identity.AutoIncrementSeed = 0; identity.AutoIncrementStep = 1; identity.ColumnMapping = System.Data.MappingType.Element; ds.Tables[0].Columns.Add(identity); I am getting the null value from "ROWINDEX" column

SQL Server :: Identity Column Reset When Shifting Database To Remote
actually recently we just shifted our website. & now when i try to transfer database from my previous server to new remote server database.all the tables auto increment field is set to 'NO' and there is no primary key anymore.

ADO.NET :: Error - Cannot Insert The Value NULL Into Column 'Cid
I have a table called category that has tow attribute (Cid,Name)  what can i do to insert  category name only without allow user to insert category id in my webpage, I use view detail control and make the wizard link but when run the error message appear (Cannot insert the value NULL into column 'Cid) note the identity properties is not pass.

Error - Cannot Insert The Value NULL Into Column 'Vid'
I have two table with a one to many relation. 1- voteChoose has (Choid PK,Choose,Vid) 2-VoteQuestion has(Vid PK,Vquestion,Action) so when insert a question and answer in a page this error message (  Cannot insert the value NULL into column 'Vid') appears i use this function to add vote  public void AddVote(string VQuestion, string[] Choose)

Databases :: Oracle.DataAccess.Client.OracleException: ORA-03113:end-of-file On Communication Channel
ORA-03113: end-of-file on communication channel Exception details: Oracle.DataAccess.Client.OracleException: ORA-03113:end-of-file on communication channel  My database is Oracle 10g, I am using .NET Framework 3.5 with Visual Studio 2008.  It happened only once when first time in the morning I open my URL in my test server then this error popup at very first page of my site.

Web Forms :: Error: "Stack Overflow At Line: 0"?
I get an error for the below code in <script>. Until this line the images is loading fine: img.src = "images/4.jpg"But if I declare that line, I have an error message box that appears on the webpage: "Stack overflow at line: 0"I have never had this error before and wonder what is causing this as I need to declare alot of images in this way. As seen I am downloading one image at a time from the server ant putting it to its controls wich works fine until this line of code. [Code]....

Getting Error Message While Calling Web Service Method From Application
i am getting this error message while calling a web service method from my application The underlying connection was closed: The connection was closed unexpectedly i am using 2.0.

Change Error Message In Control?
I have a control that holds a dropdownlist of U.S. states.   There is a required field validator with the text of the ErrorMessage="State"   I would like to change this at run time to represent the names of the different fields that this is required on.   for example it could say  ErrorMessage="State, Previous Address 1" or ErrorMessage="Driver's License State"

Security :: Change Login Error Message?
I'm starting with the prebuilt ASP.NET site in VS 2010.  The login page gives the following error message if login fails: "Your login attempt was not successful. Please try again." How can this message be changed?

Architecture :: Notify Message To Server About Change In Database
I am new to ASP.NET which is causing me a lot of problems in implementing my project. My project is to create a website for students to anonymously ask the prof. questions during the class. Basically I am able to create the website that maintains the list of questions. Now the main problem is "How to notify the Professor during class". The professor has a laptop connected to internet at all times. How can I send a notification message to the professor whenever a question is asked? I don't need a mail notification but I need to display a message in the task bar notification area.

SQL Reporting :: How To Sort Column Field And Add TOTAL Column In VS 2008
I am in VS2008 and in ReporViewer's Design page. I have "Fruits" as column fields and Months as row fields and Sales as data field. I have these columns:- Apple, Orange, Pear. However, I want it be displayed as Orange, Pear, apple. Any work around ? Also I need a 4th column adding the Apple, Orange and Peer numbers total. How to do it in design view in VS2008 ?

Get The Error Message For The Mail() Function?
I've been using the PHP mail() function. If the mail doesn't send for any reason, I'd like to echo the error message. How would I do that? Something like $this_mail = mail('', 'My Subject', $message); if($this_mail) echo 'sent!'; else echo error_message;

Cannot Send Session Cookie Error Message
An error occurred in script 'C:xampphtdocsgofasterincludesheader.php' on line 10: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at line 10 of header.php reads: session_start(); I was wondering why i keep getting this message and what it means so that i can fix it. I am just building a login for a music community site i am building!

Getting Error "unrecognized Message Version" When Enter The Url Of The File
i am trying to use my message centre platform to simulate sending and recieving of messages. the problem i am encountering is that when i enter the url of the file, an error message comes up with "unrecognized message version". the code looks like this: <?php header("Content-type: text/xml"); echo("<?xml version="1.0" ?> "); // Connects to your Database mysql_connect("localhost", "root", "random") or die(mysql_error()); mysql_select_db("trinidadnews") or die(mysql_error()); $data = mysql_query("SELECT * FROM news") or die(mysql_error()); [Code]....

Parsing - Flex 3: Getting Error Of "Parse Error At '<mx:ComboBox>'>
<mx:List columnCount="5" rowCount="11" width="100%" height="100%" dataProvider="{parentDocument.crewPositionsAC}" useRollOver="false" alternatingItemColors="[0xffffff, 0xe5e5e5]" borderStyle="none"> <mx:itemRenderer> <mx:Component> <mx:Text text="{data}" color="#840021" selectable="false" /> <mx:ComboBox id="studentType"> [Code]... Anybody able to see what's causing the error?

Flex :: Reading Large CSV File Line By Line?
I need to read a large CSV file (8-15 MB) and generate a LineChart in Flex AIR. Since Chart need data in structurd format like XML. When I read CSV and convert it to XML object 8 MB file size become 24 MB XML object and not able to graph. Best solution is to read Line by line and read only part of data. How can I acheive this in Flex AIR ? Is it possible to read line by line in Flex. Otherwise what are the best ways to draw a graph in FLEX using large data.

Databases :: Recording Individual Field Values From MySQL Database
I am using a simple Login function and need to record individual field values from MySQL database to compare with inputs. My connection code: Dim myConnection  As MySqlConnection Dim myDataAdapter As MySqlDataAdapter Dim strSQL As String myConnection = New MySqlConnection("Database=mydatabase;Data;port=3362;UId=myID;Password=1234;") strSQL = "SELECT username,password FROM Login WHERE ID = '" & 1 & "'" myDataAdapter = New MySqlDataAdapter(strSQL, myConnection) myDataSet = New Dataset() myDataAdapter.Fill(myDataSet,"Login") I have confirmed it is connecting by adding the following GridView. GridView1.DataSource = myDataSet GridView1.DataBind() My problem is isolating the individual field values.

Web Forms :: Transferring Data Between Access Database And Sql Database
I want to transfer data from a access table to a sql table. Simple by clicking a button. first off all i set up and OleDbConnection and a SqlConnection in my web.config file. This is the code i use in a b button method for transfer data for 1 tab le. [code]....

ADO.NET :: Could Not Find Stored Procedure (but It's There)?
I have stored procedure in my database but its give error "Could not find stored procedure"Is this error occuring when maked error in permision,sp code or connection code

Configuration :: Error Message:An Error Occurred On The Server When Processing The URL?
I just got a new computer with Windows 7 and installed  IIS, including support for ASP.  I am running everything locally on my computer.   A simple statement like <% response.write time() %> works fine, so ASP is working,  However, when I try to run a page that accesses a database (at least, I am assuming that that is the root of the problem) then I get the unhelpful error message:An error occurred on the server when processing the URL. Please contact the system administrator.If you are the system administrator please click here to find out more about this error. I have no idea where to begin.  the database is in the same location as it was on with my old computer, and I have adjusted permissions to the database so that everyone except Creator Owner has full permissions - for whatever reason I am not able to change Creator Owner permissions.

Error Message In Calendar / Server Error In '/please-god' Application?
i am experiencing thi error when i click on the application in the remote machine. Server Error in '/please-god' Application. Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Source Error: Line 7: Dim oBF As New BinaryFormatter() Line 8: Dim oFS As FileStream Line 9: Dim strPath As String = Path.GetTempPath & "schedule.Bin" Line 10: Line 11: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Source File: D:Hosting4423045htmlplease-godappointmentscheduler.aspx.vb Line: 9 the full codes for the application is this : Imports System.IO Imports System.Runtime.Serialization.Formatters.Binary Partial Class appointmentscheduler Inherits System.Web.UI.Page Dim arrCalendar(12, 31) As String Dim oBF As New BinaryFormatter() Dim oFS As FileStream Dim strPath As String = Path.GetTempPath & "schedule.Bin" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If (Cache("arrCalendar") Is Nothing) Then If (File.Exists(strPath)) Then oFS = New FileStream(strPath, FileMode.Open) arrCalendar = DirectCast(oBF.Deserialize(oFS), Array) oFS.Close() Cache("arrCalendar") = arrCalendar End If Else arrCalendar = Cache("arrCalendar") End If End Sub Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click arrCalendar(Me.myCalendar.SelectedDate.Month, Me.myCalendar.SelectedDate.Day) = Me.myNotes.Text oFS = New FileStream(strPath, FileMode.Create) oBF.Serialize(oFS, arrCalendar) oFS.Close() Cache("arrCalendar") = arrCalendar End Sub Protected Sub btnDelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDelete.Click arrCalendar(Me.myCalendar.SelectedDate.Month, Me.myCalendar.SelectedDate.Day) = "" oFS = New FileStream(strPath, FileMode.Create) oBF.Serialize(oFS, arrCalendar) oFS.Close() Cache("arrCalendar") = arrCalendar Me.myNotes.Text = "" End Sub Protected Sub myCalendar_DayRender(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DayRenderEventArgs) Handles myCalendar.DayRender If arrCalendar(e.Day.Date.Month, e.Day.Date.Day) <> "" Then e.Cell.BackColor = Drawing.Color.Red End If End Sub Protected Sub myCalendar_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles myCalendar.SelectionChanged Me.myNotes.Text = "" If arrCalendar(Me.myCalendar.SelectedDate.Month, Me.myCalendar.SelectedDate.Day) <> "" Then Me.myNotes.Text = arrCalendar(Me.myCalendar.SelectedDate.Month, Me.myCalendar.SelectedDate.Day) End If End Sub End Class What do i have to do to eliminate this error message?

Three Columns Layout, Want Middle Column To Stretch Wider When Column 1 And 3 Are Empty?
I have a 3 column layout using table-less design. [code].... The CSS: #left {width: 200px;float:left;display:inline;} #content {width: 600px;float:left;display:inline;padding: 0 10px;} #right {width: 160px;float:left;display:inline;} I am using a web application, and I can't change the layout. By can't change, I mean the div's with left/content/right cannot be removed. On some pages, both the left and right columns are completely empty. And I want the #content div to expand more than the 600px. is this possible, without altering the HTML?

MVC :: Error Message " 'Title' Should Not Be Empty." Instead Of "Correct The Errors" / How To Fix It
On a create / edit form I have the following: [code].... The summary shows the error message " 'Title' should not be empty." instead of "Correct the errors". And the Html.ValidationMessage does not show the message "'Title' should not be empty.".

Hi Friends, I want to know if there are a manner of replication(two-way) between MSSQL SERVER and (postgresql or mysql or ORACLE). Thanks

Motorola Droid X :: Getting Error Message To Remove Facebook Account / Fix It?
OK, I've been on the leaked version 2.3.9 pretty much since it was available and didn't upgrade to the OTA. Recently, I decided to deactivate my Facebook account since I don't really use it anymore. I have always had it listed in my accounts with Google and Twitter, and now I want it removed. Every time I try to remove it from my accounts on my phone, I get an error message. Any ideas why it's getting an error and what I can do to fix it?

Configuration :: Deployment Error -Failed To Generate A User Instance Of SQL Server Due To A Failure...
 I have created roles and users using ASP.NET configurations for login validations, it works fine if I run my application within project but when I publish my site and try to run from my Inetpub it giving this error. I tried all shorts of solutions posted in website but nothing worked for me. "Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed"

Web Forms :: Start Two Asynchronous Database Access Calls That Are Executed Onto The Separate Thread?
i have the code for asynchronous call to the database. i execute the sql command into the begin method that will executed onto the separate thread. now i want to execute the another database call asynchronously so that this also execute onto the separate thread. code for one database cal is here.... private SqlConnection con, con1; private SqlCommand cmd, cmd1; private SqlDataReader dr, dr1; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { AddOnPreRenderCompleteAsync(new BeginEventHandler(Begin), new EndEventHandler(End) ); } } /////////////BEGIN METHOD IAsyncResult Begin(object sender, EventArgs e,AsyncCallback cb, object state) { string connect = "Data Source=.\SQLEXPRESS;Asynchronous Processing=true;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"; con = new SqlConnection(connect); con.Open(); cmd = new SqlCommand("SELECT FirstName,LastName,Age,Company,Profile FROM Person",con); return cmd.BeginExecuteReader(cb, state); } //////END METHOD void End(IAsyncResult ar) { dr = cmd.EndExecuteReader(ar); Label2.Text = System.Threading.Thread.CurrentThread.GetHashCode().ToString(); GridView1.DataSource = dr; GridView1.DataBind(); }

DataSource Controls :: Select Query Not Working / Getting An Invalid Column Name Error?
i have the following select staement which deosnt work, can anyone advise me whats wrong with it: string _name = ddl_Name.SelectedValue.ToString(); string cmd = "SELECT ID, Telephone FROM User_List WHERE Name = '' + _name; i keep getting an invalid column name error? and i know the syntax next to _name isnt correct. how are the single quotes meant to go?

Create 3 Columns Layout With Left Right Column Fixed And Middle Coloum Stretch?
i have a master page , i have 3 columns in a row, i have placed the content page in the middle column . and to the right and left columns there r some buttons and images, now I want my right n left columns with a fixed width 160px and the middle column should stretch automatically to fix in to the width of the screen <form id="form1" runat="server" style="width: 100%; height: 600px;"> [Code]....

SQL Server :: Copy Data From Multiple Columns Into One Column?
My View has four columns with years, none of the rows have complete yearly data. Current View Columns 1-10, FY, Expr1, Expr2, Expr3 Some data, 2010 NULL,NULL, NULL Some data, NULL, 2010, NULL, NULL Some data, NULL, NULL, 2010, NULL Some data, NULL, 2010, 2010, 2010 Some data, 2010, NULL, 2010, 2010, Some data, NULL, NULL, 2010, NULL Some data, 2010, 2010, NULL, 2010 Some data, NULL, NULL, NULL, 2010 A new column needs to relfect 2010 for each row in the View. Goal New View Columns 1-10, FY_NEW Some data, 2010 Some data, 2010 Some data, 2010, etc. for each row in the view I can not hard code the data as time moves forward next year rows will have 2012, etc. How can I get lthe year, in this case 2010, into a new column regardless of the year?

How To Insert The Value That Is Not In Textbox Into Database Which Is Primary Key For Table Without Identity...
i have created a web form, where i have 3 textboxes into a table   and one submit button. i would like to store values from the textboxes  into my database (sql server) when i click the submit button. but how to insert the value that is not in textbox into database which is primary key for table without identity column.

SQL Server :: Database Properties Column Identity Value Will Not Accept Value Change?
In the tutorial I am doing I have been requested to change a field in the colums properties of a table.  The ID column is currentl displaying NO and NO again for "is aIdentity. I can Highlight the values but cannot change to yes.  either in the properties talbe or in the properties window on the right hand side of IDE interface.  How do I change that value?

SQL Server :: Error While Executing A Dynamic Insert Sql Storedprocedure In Sql Server 2005?
assist me rectifying the error in following sql stored procedure? Sql Query:- [Code].... I have created the above Stored Procedure for inserting datas into any table but while I execute the above proceedure its throwing some error.

.net - Get Identity Column Value In C# 'Dataset' - Access Database?
I want to retrieve identity column value after running Insert or Update (using Access DB in C#). How can I do it? i use a Typed dataset to fill and update...

SQL Server :: Connection To Database Expires Causing An Error?
I have an web page which works with a database. When I first upload it I never disposed the connections so after using the different modules of the application for sometime it would suddenly stop working saying the connection pool filled or something like that.To fix it when a user clicked a button I opened the connection, tell the database what I needed and finally disposed the connection. This seemed to fix everything, in fact you can work with application all you want, the problem comes if you stop using it for certain time.So for instance, I have a module in my webpage where user can capture information for a certain product. When the user clicks in one button the info gets into the database. If the user is continuosly capturing data everything works fine, but if it goes for about 10 min when he clicks the button he will receive an error. To fix this the user has to log-in again. Every module opens a connection to the database to verify the user identity, but then after it verifies it I dispose the connection so I don't think there is a problem.

Mixed App Session Dies / Run The Site And Login To The System, An Error Message Is Displayed?
I have a site written for ASP.NET using a library written for ASP. The library resides in a dll and the site calls it to get the number of leave days an employee has left from a database. The dll was outsourced so I don't have access to the source. I've set up the database and visual studio project locally. When I run the site and login to the system, an error message is displayed where the leave days should be displayed but the site runs normally. If I register the dll using regsvr32, the leave days are displayed when I login, but when I try to browse the rest of the site, the session is dropped and I'm automagically logged out. If I deregister the dll, then I can browse the site once I've logged in again but, once again, the error is displayed.

MVC :: Select Multiple Oracle Data & Session Data
currently, after allowing the user to login, the controller calls the function in the DAO which retrevies the info from my oracle database. this is the current part of the code that i have, which only allows me to get 1 item from the database and stores it to the string. [Code].... I would like to get more then 1 data from the database such as the the user's name, birthday, userstatus etc.. and put them all into a session data, to allow them to be used throughout the website.

How To Get Oracle Table Field Definition
from SQL*Plus, i use: DESCRIBE MyTable and I get this result (example):

Link Column
I've somehow lost the link column in the layer section.. (next to layer visibility).

Layer Link Column Missing
trying to upgrade my PS skills and working thru a PS CS book. I am working on a Layer session. The books shows a column that they call Layer Link mode. I is just to the right of the Visibility column.

Creating Column
Create Character Sequence Using Adobe Illustrator or Adobe Photoshop. Create Character Sequence. Image Size 2600x1950 pixels. Rows 50:Columns 100. Each Cell Size 26x39 pixels. this is a 640 x 480 example of the 2600 x 1950 they show

How To Put 3 Column Guide For Website...
How can i put a 3 column guide in PS like I am building a website? This way I can use each section on its own and know where my boundries are. I guess I could just draw a line, but I want something that I can adjust quickly.

Single Row/column Marquee Tool
I have used PS7 for many years but have never found a practical use for the single row/column marquee tool,am i missing something? could someone enlighten me as to practical uses.

Flex :: Actionscript 3 - Property Like 'visible Columns' In Advance Data Grid
I want to some how control the visibility of some columns in my advance data grid. I have a data provider with 115 coumns out of which I want to hide few columns. I know the column index and header field of these columns. Is there some property in Advance data grid where I can specify this directly?

Forms Data Controls :: Resize The Gridview Columns?
I m creating my application in ASP.NET 2005 with C# and SQL SERVER 2005. In standard control i have used the multiline textbox in my application and on the click event the date displays in gridview. I have used the textbox for storing the address which contains the atleast 3-4 lines... <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" autogeneratecolumns="false" AutoGenerateDeleteButton="false" AutoGenerateEditButton="false" DataKeyNames=id> <Columns> <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" /> <asp:boundfield datafield="id" readonly="True" headertext="ID"/> <asp:boundfield datafield="address" headertext="Address"/> </Columns> </asp:GridView> I think the columns of the gridview are not resizable.They are predefined for each column... Now,what i want it to look or display should be as :: ADDRESS Name of apt,soc Opp or near by Area name I want to display the text in the gridview in the same way as above. The values are stored in the database and i get them thru sqldatasource...

How To Update Particular Column Values Of Gridview On Specific Dates Using
I have column in database ID From To s1from s2to s2price fare 1 Delhi Manali 17-Dec-2010 19-Dec-2010 $900 $600 2 USA Canada 18-Dec-2010 20-Dec-2010 $500 $800 3 Newyork salinas 19-Dec-2010 22-Dec-2010 $760 $1000 I want when any user search For: Delhi to Manali on between 17-Dec-2010 to 19-Dec-2010 then the price would be automatically changes to $900 in gridview else the default price wold be displayed in fare is $600 if he search for DelHi to Manali after 19-Dec-2010. I m confused how to implement this logic ... using ...

Update Nullable Column In Db To Null?
Can anyone reliably get the EDS to save a nullable column to the databse as a "null" when bound to any of the controls such as "FormView"?I have tried using several different UpdateParameters (Session, ControlParamater, Parameter,  etc). I have tried setting "ConvertEmptyStringToNull" to true and leaving the property off entirely. Nothing works. On my "Inserts" it works fine.(I have made sure the column is set to nullable = true in the Entity Designer.....)

Update Qty Column In A Session Datatable?
I have a Datatable store in the Session. This Datatable has a column call Qty. I have one button on the page that will update the Qty.  How can I update my DataTable Qty column? [Code]....

Create Computed Column With String In Formula
I want to create a computed column in SQL SERVER and set the formula to this ([Category] + '.aspx?ID=' + [Post_ID]) Not working though......what am i missing? Category and Post_ID are current columns in the table

DataSource Controls :: Identify Row Of A Column Contains Null Value
having a table with  column having null values how to identify row of a column contains  null value? i tried isnull,nullif properties but such functions im getting emptied rows

Base64 Can Encode A Hidden Column In A Gridview
to base64 encode a hidden column in a gridview and came up with this method for doing so. It works but I'm wondering if there's a better way to do it. Code: Protected Sub gvEncode_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvEncode.RowDataBound Dim x As Byte() Dim row As GridViewRow row = e.Row row.Cells(1).Visible = False If row.RowType = DataControlRowType.DataRow Then x = Encoding.UTF8.GetBytes(row.Cells(1).Text) row.Cells(1).Text = Convert.ToBase64String(x) End If

SQL Server :: Select Query Based On Two Fileds With Different Column
This is my Table structure:-Table1 Field1        Field2     Age Dean         Chen      20          Janel         Wast       25 ann            Miller      20 I used this select statement  select Field1+' - '+Filed2 from Table1 and i binded this in dropdownlist now on selecting dropdownlist i need to show age in label. so how would be my select statement... to show age base on Filed1 and Filed2

DataSource Controls :: Cannot Insert Explicit Value For Identity Column When Identity_Insert Is Set To...
The wierd thing is this was working fine and then it just started throwing this error, "Cannot insert explicit value for identity column in table 'Reports' when IDENTITY_INSERT is set to OFF." Here is the code: [Code]....

DataSource Controls :: Multiplying Column Values On Insert Statement?
This is my code so far: SQL = "insert into " & tableNameToday _ & "(ID, Name, Calories, Of_Which_Fat, Protein, Carbohydrate, Of_which_sugars," _ & "Fat, Of_Which_Saturated, Of_Which_Monounsaturates, Of_Which_Polyunsaturates," _ [Code]....  how do i multiply the columns like this. for now static explanation would be ok but eventually i would like to make it dynamic so there would be a text box for users to enter the amout they like e.g 160g then the table would know to multiply the columns by 1.6.

DataSource Controls :: Way O Insert Statement Conflicted With Column Foriegn Key Constraint
I have a stored procedure which i pass a number of parameters into. One of these parameters is staffNo (only passed this in because i couldn't execute the query without it). The thing is this field can be Null, but when trying to pass null into it it comes up with an Foreign Key conflict. staffNo is a foreign key within the table i'm inserting the data into.This is the error i get:"INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'PropStaffFK'. The conflict occurred in database 'DewMountain', table 'TblStaff', column 'staffNo'. The statement has been terminated. The 'PropertyAdvert' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. "

Forms Data Controls :: Cannot Insert The Value NULL Into Column 'UniqueID'
so i have a FormView bound to an SQL datasource. Using the Auto generated insert/update/delete. "Cannot insert the value NULL into column 'UniqueID'" The FormView Default view = Edit I have set the PKey and the Datasource is loading the record from a session. The record is loading no problem, just wont update.

SQL Server :: Cannot Insert The Value NULL Into Column ReviewDate - Table "ProrsumDB.dbo.Review"
I've been working on this project which requires me to insert data into a database. Due to the complexities of the function that I am doing, it is more complex to use SqlDataSource and hence I've used the traditional method of inserting to the database. The codes are as follows: [Code].... I am not too sure why, but even though I've debugged numerous times and the data gets inserted into the database through the form view, I get this error on the page after everything is executed: Cannot insert the value NULL into column 'reviewDate', table 'ProrsumDB.dbo.Review'; column does not allow nulls. INSERT fails. The statement has been terminated. reviewDate wasn't null when I tried and there are no exception thrown.

Forms Data Controls :: DetailsView - Cannot Insert The Value NULL Into Column 'Title'
why I am getting this error when I try to insert data in a DetailsView 2.0?  Cannot insert the value NULL into column 'Title',table'C:INETPUBWWWROOTTESTAPP_DATAQUIZ.MDF.dbo.Question'; column does not allow nulls. INSERT fails. I used the Configure Data Source wizard to set this up and Question ID is a autonumber. When you autogenerate the Insert button on a Detailsview control and click on that button during run time the control posts back with text input areas where you are supposed to type the Title, Answer1, Answer2 etc. Obviously I typed data in to this text area labeled Title. It didn't work and that's why I'm asking about the control. Because I can't debug the control I am having a hard time figuring out where the problem is. Here is the code: [code]....

Forms Data Controls :: Cannot Insert Explicit Value For Identity Column In Table 'UserDetails'
I have error: Cannot insert explicit value for identity column in table 'UserDetails' when IDENTITY_INSERT is set to OFF. I'm trying to insert a record through a BLL (Business Logic Layer) class with an 'Insert' button attached to the FooterTemplate of a GridView2. My code:   [Code].... [Code].... BLL layer code:   [Code]....   The field 'idUser' is autoincremented. When I use SqlDataSource with a DetailsView, add option it adds a record and autoincrements the 'isUser'.

Forms Data Controls :: How To Insert Several Checkbox Values Into A Single Column In The Table
i have a form with several checkboxes....i want to insert the selected checkbox values in to a single column in the sql database..

Forms Data Controls :: MS SQL 2005 And DataSet - Computed Column
I have a datatable in MS SQL that has FirstName and LastName. In MS SQL I created a computed field called FullName that was ((rtrim([LastName])+', ')+rtrim([FirstName])) I created a DataSet and a Business Logic Layer. In my typed DataSet I saw FullName in the listing when I created it. I am able to use FullName in my webpage. I use it to populate a dropdownlist. However, now when I make changes to the Customer Table I am getting this error message (seen below) Question: Should I have created the field FullName in my MS SQL Table or should I have left it alone and somehow just added a column to the DataSet and placed an expression in the FullName column? The column "FullName" cannot be modified because it is either a computed column or is the result of a UNION operator. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: The column "FullName" cannot be modified because it is either a computed column or is the result of a UNION operator. Source Error: [Code].... Source File: c:Users ottfarmsAppDataLocalTempTemporary ASP.NET Filesinternalauburnriverside98ea0e1f2a7f0720App_Code.lbdcba1v.2.cs    Line: 1240 Stack Trace: [Code]....

Forms Data Controls :: How To Change The Column Header From A DataSet
The following query returns me the column name from the table in the database, and stores the column name in the grid. How can I change the column name in the grid using following code, if its possible? DataSet p_dsInformixDataDs = new DataSet(); string cmd = "SELECT * FROM CUSTOMERS"; try { using (IfxDataAdapter da = new IfxDataAdapter(cmd, m_InformixDBConn)) { da.Fill(p_dsInformixDataDs); } } DataView myDataView = new DataView(m_dsInformixDataDs.Tables[0]); if (myDataView .Count > 0) { GridView1.DataSource = m_dsInformixDataDs; GridView1.DataBind(); }

Forms Data Controls :: How To Change The Column's Name Of Dataset Programmatically With C#
Base on different conditions the progam uses different Sql which every one has different select names. How can I change the Dataset Columns name programmitcally which matchs the FormView  Order . Or some how change the   <%#Eval("Order")%> text in asp:TextBox <asp:FormView ID="DetailView" runat="server" Width="704px" OnPageIndexChanging="DetailView_PageIndexChanging"> <ItemTemplate> <table height="400" cellpadding="0" cellspacing="0" style="width: 511px"> <tr><td width="%50" valign="top" >TR</td><td> <asp:TextBox ID="TextBox5" Text='<%#Eval("Order")%>' runat="server" Width="192px"></asp:TextBox> </td><td></tr>,/table> </ItemTemplate> </asp:FormView>

Forms Data Controls :: How To Hide A Gridview Column Which Is Bound To A Dataset
i'm having a gridview which is bound programmatically to a dataset object , so when the page loads the gridview displays all the columns returned from the dataset object and i just want only one column to be displayedso how can i set all the unwanted columns visibility to false ? protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) e.Row.Cells[0].Visible = false; but it hides the only column that i want it to be displayed :) and when i try to change the index of the cell (ie .. e.Row.Cells[1].Visible = false;)

Forms Data Controls :: 2008 - How To Retrieve Data From GRIDVIEW1 Using Column SELECT Button
I am using ASPNET2008 with VB Scripting and not C# Scripting I am encountering new problem. On the WebFrm1, I just don't know how to write the coding to retrieve the CUSTOMERID data in order to retrieve the details from SQL SERVER table  to fill the textbox controls.Here is the decription of the GRIDVIEW column In the GRIDVIEW1 on the left edge one of the column is SELECT button which let the userclick on it to select the specific CUSTOMERID on the column next to it on the right. Here are the coding from SOURCE <asp:ButtonField ButtonType="Button" Text="Select" CommandName="SelectClick"     DataTextField="CustomerID" > </asp:ButtonField>

Can't See Dataset Column
I have a data set and I am not getting any records back.  I try to store the column in a variable, but the variable only has nothing stored in it. [Code]....

C# - Best Way To Add A Column To An Existing Dataset
I have two extremely long queries that I am running on multiple tables, using an INNER JOIN. The only difference between these two queries is that they take different input values for one of the WHERE clauses, which they get from two separate DropDownLists. The results of these queries are identical, save for the time1/time2 columns.string query1 = "select Name =, time1=(SELECT hours FROM table3 WHERE street=list1.selectedvalue), t2.address from [table1] t1 INNER JOIN [table2] t2 ON t1.param = t2.param ORDER BY Name"

Edit Dataset Column Value In C#?
i have dataset having one table have 5 columns fill data from database. When i run application datatable contains more than 50 rows, I would like to update value of datatable after getting data from databse. My requirements are This table have few cells having Null value, I would like to replace null with "-" ? One column is System.datetime datatype, where i would like to remove time. I would only like to have date? Here i am thinking that i apply one loop of rows present in datatable and update cells accordingly. But i am searching any direct update method? - Dataset Column Always Returns -1?
I have a SQL stored proc that returns a dataset to ASP.NET v3.5 dataset. One of the columns in the dataset is called Attend and is a nullable bit column in the SQL table. The SELECT for that column is this: CASE WHEN Attend IS NULL THEN -1 ELSE Attend END AS Attend When I execute the SP in Query Analyzer the row values are returned as they should be - the value for Attend is -1 is some rows, 0 in others, and 1 in others. However, when I debug the C# code and examine the dataset, the Attend column always contains -1. If I SELECT any other columns or constant values for Attend the results are always correct. It is only the above SELECT of the bit field that is behaving strangely. I suspect it has something to do with the type being bit that is causing this. So to test this I instead selected "CONVERT(int, Attend)" but the behavior is the same. I have tried using ExecuteDataset to retrieve the data and I have also created a .NET Dataset schema with TableAdapter and DataTable.

MVC :: Cannot Insert Explicit Value For Identity Column In Table
Following the MVC1 vers of Nerddinner, but using 2010 and MVC2. Never seen this error. Looked in controller, model, view. Where does MVC pass the identity value, and how to stop it? I have never had to set IDENTITY_INSERT in any app before.

SQL Server :: How To Start Identity Column From 001
I want to konw how to start my identity column from 001? [Code].... this does not work as it still takes it froom cause 001 and 1 is the same 

SQL Server :: Set Identity To Primary Key Column?
I have table with around 100 record. Now I want to set identity to primary Key column

SQL Server :: Create IDENTITY ID For Primary Key Column
how can i create IDENTITY ID for primary Key column like this AAAAA AAAAB AAAAC AAAAD AAAAE . ' ' ' AAAA1 AAAA2 AAAA3 AAAA4 . . . . AAABA AAABB AAABC

MVC :: How To Use UpdateModel With An Identity Column
I'm sure this is simple, but in all my searches, I can't find out how to do this: I'm trying to use UpdateModel, but I keep getting a "value is required" error on my ID column, which is properly defined as and identity column. 

Changing Existing Column To Be With Identity
Possible Duplicate: How to change programmatically non-identity column to identity one? I want to set a column as identity as I have already created this column in a table. What syntax do I need?

DataSource Controls :: How To Reset Identity Column Value
I have an identity column that increment by 1 on every insert. I have deleted all the rows using delete query but the identity coulumn is still not reseting to zero, how do i reset it, as it was when the table was first created.

DataSource Controls :: Add Identity To Existing Column
I have created small database prods. I have created one table Products. I have given  columns like productid, productname, price. after creating table. I got an idea to add identity to productid ie., auto increment. how to add identity to existing column.

Web Forms :: Set Text Box Height According To (table Column) Text
I have a multiline text box on page which has style "overflow: hidden" to hide the scroll bar. I want to set the vertical hight of that text box at runtime according to the string coming from table column. Is there any way of doing it? I have tried to put the text in array but its not working.... Dim myParas As Object myParas = Split(TextBox2.Text, vbNewLine) ln = UBound(myParas) + 1 TextBox2.Height = 22 * ln

SQL Reporting :: How To Change Text In Columns In SSRS
I need to create a complex report and export it to Excel.  In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. I am new to SSRS and tried out many ways but didn't get it.