im working with ms sql for few years, now i changed it to oracle..
how i can make stored procedure returns a table ?
in msssql is ..
CREATE PROCEDURE dbo.GetRecord (@ID int)
AS
select ID,Name, Value2 from tblMain Inner join tblData on tblData.fkMain = tblMain.pkMain where id=@ID
how i can write it in oracle sql ?
User Profile
Collapse
-
Store procedure question...
-
if i try this in WPF application all works fine... Then somewhere must be a problem...
btw.: In any case you dont need to get selected item in datagrid, because you only need to display values.. -
Silverlight datagrid.itemssource display problem...
Hello all I new in silverlight And i found one strange thing..
when i tried to bind List of object to datagrid all works fine. Values shows fine... But, when i try to use linq to select only one value. Datagrid return blanks rows..
but what is strange. where i try to get value of selected row it gives me right value...
here is code
Code:private void LayoutRoot_Loaded(object sender, RoutedEventArgs
-
Binding Data From LinqDataSource to TextBox
Hello Im new in asp.net.
How I can bind texbox to one property from linqdatasource?
I mean something like databinding contols in c# app -
radpidhare file download
how to download any rapidshare link with premium account ? -
Selecting count of record by hour with zero values
How simple I can make query for MSSQL for selecting number of records step by 1 hour.. Including zero value..
I need return liek this..
2010/06/24 01:00 ; 2
2010/06/24 02:00 ; 0
2010/06/24 03:00 ; 10
2010/06/24 04:00 ; 11
thanks for all replies -
Combobox Backgroud Color problem
Hello all,
i tried to set background color to combobox.. All works fine but...
when i use ComboBoxStyle.D ropDownList.. Combobox is still gray.. How simple make the cbox take color when dropdonwlist is setted? -
WebBrowser credentials problem...
Helo I have one little problem,
I need to navigate to url, fill txboxes, submmit, wait for load next page and call javascript function.
but this Pages need credentials..
I tried this..
navigate to "https://username:pass@u rl"
this work fine.
fill boxes.
submit...
all works fine and now i ned to call javascript function....
When i tired to call this by... -
program files permisions [ win 7 ]
Hello all,
I have one little question, i wana make my own updater. All works fine but, when i come to win 7. I dont have permisions for managins files in installation folder.. If any way how i can save or manage files there? -
ListView images Question
I have one small question, can I show bigger images in default listview ? -
MSSQL ID generation
hello I have one questiom im new to SQL dbs...
I need to generate ID in one table in this format
YYYYMMDDXXX
where YYYYMMDD is date of day and XXX is uniqe number raising by 1 .
and every day XXX starts from 000 -
Thx, I solve this yesterday.
I solve it another way.
Code:public void MDI_Child_closing(string strID) { any action } private void TestChild_FormClosing(object sender, FormClosingEventArgs e) { ((Form1)this.MdiParent).MDI_Child_closing(this.Text); }
Leave a comment:
-
MdiChildren
hello Im working on MDI form application.
I have one problem i need to know when the mdi child cclosing, and need to know him name or .text.
how i can do this. How I can get it ?
Or how I can use MdiChildActivat e event to get it.
thx -
-
u can try to load this page..
"http://tosivypijes.cz/"
I have problem in few pages but have.. And as usual I have problem with page what I need..Leave a comment:
-
I tried add reference to
Microsoft.Offic e.Interop.Word. dll
but, nothing happens.. Problem was still here.Leave a comment:
-
I dont have with program code. But with character coding my problem was.. When page loaded. I cna see normaly "Chybný požadavek" but when i copy text to richtextbox. I can se this "Chybn� po�adavek"Leave a comment:
-
webbowser problem..
I triet to navigate WB to some page. ale was ok but.. When I put WB.documenttext to richtextbox.. I have problem with coding.. Can anybody formard me, where is the problem... I WB page looks normaly -
OK, I collecting inforamtion, before I start learning new things.Leave a comment:
-
I looking for good books about it. I lookn on XNA but i prefer to write all myself.
But have fast look on direct x and its bit complex.. I tried write something in GDI nad its bit slow..Leave a comment:
No activity results to display
Show More
Leave a comment: