Whan can i do? make "string" data type convert to "window" data type, and use a "window" name to get it ancestor "window name", thanks! i use pb5
With a string window name, you can open a window of that type if you need
to. You could, of course, query that window object for any attributes.
Another option is to use the LibraryExport function to export the definition
of the window which is specified by the string. You can then parse the
resulting file to get information on the ancestor object.
"Rich" <email@example.com> wrote in message
...How to retrieve the data from the data using the stored procedure?
Hi All, Can any one let me know "How to retreive the data from the database using the stored procedures". Once we retrieve the data from the database using the stored procedure we need to populate the fetched data into the textboxes of the application. Please let me know "How do I acheive this". And please note this, if I try to fetch the record which does not exists in the database it should throw an exception saying that the record which you are trying to search does not exist Thanks and Regards Sandeep.
For Calling Stored Proc U can re...Oracle Stored Procedure data window
I am trying to create datawindow from a stored procedure. I created a simple
SP that return a value.
I selected the Stored procedure option in datawindow creation and it showed
the procedure i created.After selcting the procedure I got a blank
datawindow painter. Menus except File,window are disabled.
Can anybody exlpain the basic procedure to create a stored procedure
datawindow with Oracle.
I am using PB6.5 and Ora 7.1
For Oracle 7.1 you need to use the pbdbms package. That version of Oracle
had no way of returning result sets.
The package is cr...Data window's Data source is Oracle Procedure
Hello I created one Packed in that i created one PROCEDURE
now i want to use that oracle procedure in data window as a
data source. but when i created a new datawindow (PB9)in
select store procedure dialog box i cant see that procedure
or package in a list what i have to please tell me .
First, the procedure has to return a ref cursor to be used as a datasource
with a datawindow (natively).
Second, your userid must have execute permission on the package/procedure.
Third, you need to configure you PB database connection on the SYSTEM tab,
there's a checkbox t...Using Oracle Stored Procedures as a data source
I am working with PowerBuilder 6.5 and Oracle 7.3. I created a stored
procedure as suggested in the 'Connecting to your Database' manual.
The stored procedure executes using Oracle Plus. When I select it as
a source for a DataWindow I'm getting an Oracle error, ORA-06550. It
says that "'Proc1' must be declared". Proc1 is the name of the stored
I would appreciate any suggestions.
Try one of these:
1. Reset PBDBMS from the database profile setting. [PBDBMS =
-> DBParm] or
2. REMOVE the instance name from in front o...Inserting data into database using store procedure
Here is my code and it's not working.protected void btnInsert_Click(object sender, EventArgs e)
SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlCommand sqlComm = new SqlCommand();
sqlComm.Connection = sqlConn;
sqlComm.CommandType = CommandType.StoredProcedure;
catch (Exception x)
Cons...data, data, data
Hello, I need some advice on the best method to keep a database updated in this scenario. I have a local Solomon SQL Server where we keep our inventory. I want to build an application that will be hosted at a remote hosting location which provides a SQL database. I want to build the application to allow clients to access the inventory items and make requests based on the remote SQL data. The order will be sent to our fulfillment department via email; they will fiill the request and ship. I'm not sure the method to do this while keeping the data current on the remote and the l...Can anyone tell me how to access data from Stored Procedures using data adapters?
Can anyone tell me how to access data from Stored Procedures using data adapters? My task is to select a row which is valid with data particular value. Suppose i had to get all values of particular user after validating username and password. Can anyone give me some hint regarding store procedure and retriving data from stored procedure using data adapters ? How can i bind data to dropdownbox of one field in the table using datasets and data adapters? How can i insert data in database using data adapters?Can any one solve this?
for your question, dataadapter's fill and update methods will sove the situation. Please look in google or in MSDN for these methods information.
also visit these links.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him forever....Using stored procedures to insert and pull data from database
I have my database: "RequestTrack"
My table (with its columns): "Request"RequestKey (automatically generated)..and the Primary KeyEntryDate (datetime)Summary (nvarchar)RequestStatusCodeKey (bigint)EntryUserID (nvarchar)EntryUserEmail (nvarchar)I am wanting to create a basic web form where my user interface has 3 text boxes and a Submit button:
**After I hit the submit button the information will then be inserted into the database. Also the RequestStatusCodeKey will be MANUALLY typed in so ...How do I resolve this problem of using a stored procedure with Data Window.
I have written a stored procedure in Sybase, which conssists of multiple
statements (including 'Select into') and at the end it has a final 'Select'
statement which gives out the output.
When I use this SP in a datawindow and try to retrieve the data using -
It gives following error message -
Select Error : Select INTO command not allowed within multi-statement
However there are other SPs written in similar manner running smoothly.
Please suggest how do I resolve...how to get data from all related tables using stored procedure
I have a situation where I want to load some entities from one table lets say the table is customers and i would like to load all the customers with first name = dummy, not only this i would like to load all the orders and order details for these specific customers (these are two different separate tables) . I want all this within one stored procedure that return me three results for three different tables. Please tell me whether it is possible and how.
You can simply have multiple SELECT's in a stored procedure. Then using a DataSet, the Tables collection will have the same num...Using a data set to hold data read from the database. And how to write it back out, getting it out of the listbox
I havent worked with data sets lately so I am hoping from some help from someone.i am working on a web application using asp.net 2.0 and c#.
Basically I need to read html text from a column in a database table(600 chars max)I then need to copy this text into a multi line listbox and allow it to be editedOnce the application user has edited the text, then they will press a save buttonand the text will be written back to the database.
I don't know if this is the best choice, but I want to use a data set to read the text into.The data set will act as the holder of the text.
The problem i...store frequently used data in session or get from database each time
i need to know user security like canRead,canWrite,canDelete,canPreview,canViewReport1,canViewReport2 ,.......canViewRport20 etc .......and then load the page.
what would be the best option
store all these information after successful login in Session
query them from database as you need them
Store in session. Will be faster than going to DB each time.
session is definetly faster.but won't the performance of the application suffer if there are around 200 concurrent users.
session is definetly faster.but won't the performance of the a...inserting xml data in sql database using store procedure
i want to write gridview data in Xml file and pass that xml file as input parameter tostore procedures and insert xml file data to sql database table.i dont how to write xml file and how to pass it to store procedurepl help me asap its urgent
"To handle XML from an xml data type column by using ADO.NET and the Microsoft .NET Framework you can use the standard behavior of the SqlCommand class. For example, an xml data type column and its values can be retrieved in the same way any SQL column is retrieved by using a SqlDataReader.However, if you want to work with the...Oracle Data in Drop Down Data Windows
When I make a Drop Down data window using SQL server it works fine and give
me the data. However, when I connect to Oracle directly it does not populate
the drop down data window. When I look at the source data window for the
DDDW, it works fine and I see all the data thats in the database.
Assuming you created the dddw while connected to SQL Server and are now
trying to use it in an Oracle database, is the dw for the dddw saved in
Also, if you do an explicit retrieval of the dddw what happens?
dw_news.GetChi...Is it possible to use stored procedure for Insert in data window ofr PB 7
We have a requirement to use insert into a particular table using a stored
procedure while we don't need stored procedure for update. Delete has been
disabled to all but dba via truncate table.
I have coded and tested a ASA 6 function and procedure for the purpose of
inserting a row into the table using pure watcom syntax. ( the function
contains special logic to generate key value for the stored procedure)
I can insert rows with the procedure in ISQL only by
call p_insert_x (................, v_trans_id, v_timestamp)
execute p_insert_x ( ................, v_trans_...How to use Oracle 7.3 stored procedures as datawindows' data sources?
We are trying to use stored procedures as datawindows' datasources using
PB5.0.03, Oracle 7.3.3, SQL*Net 2.3.3, clients with Windows 95, and the
server with NT 4.0. When we try to do that, we receive an ORA-06550 error
refering to a PLS-00306 error (wrong number or type of arguments in call to
'empleado'). We have tested the procedure directly in the database and
everything seems to be ok. Does anyone know where the problem can be? or
even better, how can we use the stored procedures as data sources for the
We created a package and the stored proc...How can I get data using as source a Store Procedure sending it a sql sentence?
I'm using Power Builder 8 and Oracle 8i, what I want, It is
to use a datawindow with a store procedure as data source
but as a parameter, I want to send it a sql sentence like a
string "select * from table". The store procedure should
execute it and then the data has to be showed in this
It's easy to do this if the store procedure only has to get
data from a static sql using:
open cursor for
where data1 = parameter1
but if I want to execute something like that:
open cursor for
parameter_sql; -- This a String ("select ...Problem use sqldatasource to access stored procedure and get data bind to label control
Hi every experts
I have a exist Stored Procedure in SQL 2005 Server, the stored procedure contain few output parameter, I have no problem to get result from output parameter to display using label control by using SqlCommand in Visual Studio 2003. Now new in Visual Studio 2005, I can't use sqlcommand wizard anymore, therefore I try to use the new sqldatasource control. When I Configure Datasource in Sqldatasource wizard, I assign select field using exist stored procedure, the wizard control return all parameter in the list with auto assign the direction type(input/ouput....), after that...How to speed up the data assignment from one data window to another data window ?
I have a report program that need to show three different periods of
sales data for my users. I used a datastore ( called 'dw_source' ) to
hold these information and then used three 'for loops' to assign
individual sales data to related period columns into the final
data window ( called 'dw_target' ) that will be displayed for the users.
The number of columns on the report group are user selected and the
program will do all grouping and subtotal when the group data
changed ( is a dynamic created data window ).
The time needed to do the the assingment from &...passing data from controls to session then taking the data and writing custom sql queries to get data from the database
Hi, I'm making a property search. I want to get data from controls and store in a session object which saved in the session until remove or close the browser so on the next page I can take the data stored in the session and use it to write a custom sql query using vb.net or stored procedure to get data from the database and then display the date in the list of results page. Can anyone help with this or forward me to some tutorials that could help me. ThanksAndy Current project: Cycle round the world
Heytry thissession["name"]=TextBoxName.Text; And in ...how to retrive the XML data by using LINQ and how to store that data in GridView(by using LINQ) Dynamically
Friend's i have 'n' number of tabels.if i select particular table that table data should bind to GridView using XML and LINQ dynamically with their column names.
Friend's what i have i done i will give that code :
XmlDataDocument MyDoc = new XmlDataDocument(Ds); MyDoc.Save(Server.MapPath("App_Data\\DsFile.xml"));
XElement MyDoc1 = XElement.Load(Server.MapPath(...Sorting in gridView: Can I use LINQ to call a stored procedure and still get sorting like I can with an SQL Data source to a sproc?
I have a gridView, it is populated by the results of a stored procedure.
I would like to be able to sort on the columns returned.
If I use an SQL Data Source control and point it to the stored procedure it will allow me to sort the columns in the gridView by enabling sorting.
However, I can not select a stored procedure using a LINQ data source. I can call a stored procedure with LINQ and assign it to the gridView's datasource, but this won't let me enable sorting.
Is there a way to call a stored procedure using a LINQ data source, so that I can enable sorting in th...