/*************** *************** *************** *************** *************** ************/
HI IN ORACLE 8i WE CANT ABLE TO USE = OPERATOR FOR ROWNUM SO U CAN TRY USING <,<=
SELECT *
FROM ( SELECT ENAME,rownum rn
FROM EMP
WHERE UPPER(ENAME) LIKE 'A%'
ORDER BY ENAME ASC
)
WHERE rn <= 2...
Dharmaraju
Last Activity: Dec 3 '07, 01:05 PM
Joined: Sep 15 '07
Location:
-
/*************** *** TRY THIS*********** *********/
hi may be the time part will not match to that date so use truncate for sysdate then we can compare the condition
set serveroutput on
begin
select trunc(to_date(s ysdate))=to_dat e('03/12/2007','dd/mm/yyyy') from dual;
dbms_output.put _line('hi');
end;
/*************** ***** I THINK IT CAN BE USE************ ******/...Leave a comment:
-
select * from (select to_char(hire_da te,mm)aa ,to_char(hire_d ate,month), aa1 from employees ) a order by aa...Leave a comment:
-
Use only one adapter and only one select statement of the updatable table. Easily you can the error .
Otherwise
Dim cb As New OleDb.OleDbComm andBuilder(da)
Dim dsNewRow As DataRow
' add the following line
da.insertcomman d=cb.getinsertc ommand()
dsNewRow = ds.Tables("Expe nses").NewRow()
dsNewRow.Item(" Expense Description") = Expense_Descrip tionTextBox.Tex t...Leave a comment:
-
if you want to update the data from the dataadapter you should keep the priamry key in your tableLeave a comment:
-
datagrid rowcolor dynamically
How to change the datagrid rowcolor dynamically in vb.net( vs2003) . and also column backcolor
Please Help us -
datagridview comboboxcolumn
I have added datagridview combobox column with datagridview . I want to write a code for combobox events .Please give a suggestions -
Please configure smtp server in your IIS server . with appropriate values
In your coding you should mention the smtp sever as "localhost or the ipaddress of that iis server
Please check itLeave a comment:
-
Please don't mention the type of the column
dt.Columns.Add( New Data.DataColumn ("Line #", GetType(Integer )))
You should mention like this
dt.Columns.Add( New Data.DataColumn ("Quantity") )
then it will accep the value .Please doLeave a comment:
-
Don't specify the column type when you adding the column to the datatable .the Column automatically take the datatype when you update the column.Leave a comment:
-
how to create server based exe in dotnet
I have developed one vb.net application. I have around 25 computers and one server . I want to deploy that application to all the machines.
I want to access the vb.net application from the LAN (i.e server drive) .If i made any modification in that application. I update only on the server .It should update to all the clients . All the client having vb.net application shortcut from the server .I should not copy my application... -
ToolTip control with datagridview
In VB.net
======
I have datagridview and tooltip control . I want to attach the tooltip control with datagridview row . when the user move from one row to another row the tooltip text should change automatically . Please give me a useful suggestions
No activity results to display
Leave a comment: