|
Hi,
I had one datagrid,i need to delete one record on condition...the condition is like If the date is less than the System date,then i can do it,other wise i need to show message like 'Unable to Delete Record'.
Vasvai
|
|
|
|
|
Use Javascript for that with Date validation and check the date is less than the system date.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
i have a stored procedure with select * from employee where empid is =some id number this statement i wrote in the storedprocedure..now i want the values of the select statement return from a stored procedure.here iam giving the id value through the stored procedure only....
|
|
|
|
|
jagadeeshkumar2106 wrote: have a stored procedure with select * from employee where empid is =some id number this statement i wrote in the storedprocedure..now i want the values of the select statement return from a stored procedure.here iam giving the id value through the stored procedure only....
The fact you use a SELECT "returns" the data. Use ExecuteReader or use a Data Adapter to Fill a DataSet in order to get the data.
|
|
|
|
|
What are you using to read the data with? If your Stored Procedure uses SELECT *, then you should use either ExecuteDataReader fill a DataSet. BTW - it is really bad practice to use SELECT *. You should always explicitly name the columns you want returning.
|
|
|
|
|
Post your Question in the suitable forum.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
How to create website project using .NET Framework 3.0 in VS 2005 ?
Regards,
Ujjaval Modi
|
|
|
|
|
Get it here
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Hi,
Error: Redirect URI cannot contain newline characters.
I get this error when i execute my code on server .
Can anybody solve my Problem.
Thanks.
Regards,
Developer_vk
|
|
|
|
|
Developer_vk wrote: Error: Redirect URI cannot contain newline characters.
you should encode the exception's Message property before using it in a URL. HttpUtility.UrlEncode or HttpServerUtility.UrlEncode would do it for you.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Hi, i have a dataset having two tables. now i want to create tables in database for these dataset tables. what will be the method.
|
|
|
|
|
In SQL you write a couple of CREATE TABLE scripts.
|
|
|
|
|
Hai,
I need one message box,after inserting a record into database.Here iam filling database on Datagrid.
Vasvai
|
|
|
|
|
|
using stored procedures how to retrive the collection of table values and how i can assign these values to a particular dataset
|
|
|
|
|
IF you are using SQL server, use SQLCommand and SQLDataAdapter class. Use Fill() method in SQLDataAdapter to fill the value to a DataSet/DataTable. You need to set CommandType to StoredProcedure also.
|
|
|
|
|
hi sir how r u this is jagadeesh ..wat u said is I understood but how a stored procedure should write to get the collection of table values for example how i can get the set of values of select * from emp values ..
|
|
|
|
|
jagadeeshkumar2106 wrote: how i can get the set of values of select * from emp values ..
Writing SELECT * FROM Table will return all the rows in that table when the procedure is being executed.
|
|
|
|
|
k sir i write(select * from emp) this query in the sp but how i can hold these values in sp and how i can return these values in sp .will u plz guide me with a piece of a code.
|
|
|
|
|
I am not getting what do you mean by hold these values in SP. Do you want to do some calculations with the returned value ?
|
|
|
|
|
no sir actually my requirement is i want to get the employees of a particular table when a dept no is given .these employes i should get the data set table .so i can write an sp to retrive that much values from sp into a data set.
|
|
|
|
|
Can I freeze first column in a ASP.NET gridview web control? I've 20 columns, first 2 columns should be frozen.It should be like Excel. Also to freeze gridview header as well. It should apply to all browsers.
Thanks & Regards,
modified on Thursday, December 06, 2007 3:48:15 AM
|
|
|
|
|
Bendy Chan wrote: Can I freeze first column in a ASP.NET gridview web control?
What do you mean by freezing the column ?
|
|
|
|
|
|
It use javascript. You can try that, I don't think any ready-made code available.
|
|
|
|