ruhi

hi..... i am searching for the query for retrieving the deleted data from the table.From the web i got "flashback" method to get the dropped table.Any one has any idea pls,help me thanks in advance

Can anyone see anything wrong with this statement? [CODE] CREATE OR REPLACE VIEW V_DEPT_AMOUNT AS SELECT DEPTNO AS DNO, DNAME AS DNAME, MAX(AMOUNT) AS MAX_AMOUNT, AVG(AMOUNT) AS AVG_AMOUNT, MIN(AMOUNT) AS MIN_AMOUNT, SUM(AMOUNT) AS TOTAL_AMOUNT FROM DEPT D, EMP E, PURCHASE P WHERE D.DEPTNO = E.DEPTNO GROUP BY DNAME, DEPTNO; [/CODE] …

hi i have the table in which date valve is like this [COLOR="Red"]11/11/2009 6:08:29 AM[/COLOR] how can i compare the value or select them , the to_date is working in SELECT but,i want to select the records using this colmn and by giving value ie:[CODE]SELECT * FROM SENTMAIL WHERE SENTMAIL_SENT_DATE='01-OCT-2011'[/CODE] …

hi all how can i sort my grid in 1.0 version? i am binding data on a click event. and after that calling a function that alters the second column for values. for ex. on 1st binding my grid is as follows date status ----------------------------- 01/01/2008 01/02/2008 01/03/2008 and on …

Hi, I have three dropdownlist: country, state and city. Based on the selection of country the data of state will be filtered and similarly depending on the selection of state , the items of the city will be filtered. That is working fine. Now there is one gridview which contains …

Hi everyone, How to use session value during fetching values from database of that particular session value? [code] SqlDataAdapter adapterprice = new SqlDataAdapter("SELECT product.productid, product.productname, product.price, product.description FROM product where product.productid= Session["productid"] ", myconnection); [/code] During writing code in such a way it is showing error.. Can any one help …

sorryy..

Hi all, Can any one tell me how to use a value generated through a button click event in another button click event in the same page.Is viewstate is helpful? If yes then how? -ruhi

Hi.. Am newbe to ASP.net, facing problem while using vaidation controls. I have a form where in have used ADD,EDIT,SEARCH, CLEAR buttons. When i press an edit button datagrid can be viewed. But when i use validation controls error messages are displayed if I click on edit,clear, add or search …

<Table id="temp1" width="100%" > <tr> <td id="temptd">...................</td> </tr> </Table> This my sample code..from this how can i get the left value of the Tabledara '[B]temptd'..[/B] i try with this in Jscript [I]document.getElementById('temptd').style.left[/I] But i didnt get anything...pls help me to get this.. Thanks, Vimal

hello everyone, how to write exit code in visual studio.Net so that whole program closes on button click event? And how Message box is created, also how to take input from user as we do in javascript using prompt command? Can anyone help me in this..... Thanx in advance.

hello everyone, i m trying to add row in database through this code: [COLOR=green]Private[/COLOR][COLOR=green]Sub[/COLOR][COLOR=green] btnadd_Click([/COLOR][COLOR=green]ByVal[/COLOR][COLOR=green] sender [/COLOR][COLOR=green]As[/COLOR][COLOR=green] System.Object, [/COLOR][COLOR=green]ByVal[/COLOR][COLOR=green] e [/COLOR][COLOR=green]As[/COLOR][COLOR=green] System.EventArgs) [/COLOR][COLOR=green]Handles[/COLOR][COLOR=green] btnadd.Click[/COLOR] [COLOR=green]Dim[/COLOR] rowNew [COLOR=green]As[/COLOR] System.Data.DataRow = DataSet31.Tables(0).NewRow [COLOR=green]Dim[/COLOR] temp [COLOR=green]As[/COLOR] Random rowNew.Item(4) = temp Response.Write(rowNew.Item(4)) '** DataSet31.Tables(0).Rows.Add(rowNew) DataGrid1.EditItemIndex = DataGrid1.Items.Count DataGrid1.DataSource = DataSet31 DataGrid1.DataBind() [COLOR=green]End[/COLOR] [COLOR=green]Sub[/COLOR] [COLOR=green]but …