|
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.
|
|
|
|
|
1) In old days, we used to use CSS expression to make the fixed column header. but the CSS expression doesn't work in the non-IE browsers so we stop using this trick.. However, if your website is for IE users then you can still use the CSS expression which is really easy to use.
2) You can use the pure CSS to get the fixed column header.. For example : Pure CSS Scrollable Table with Fixed Header[^] but as you want to use this in Gridview, there is one problem that we can't set the CSS class to tbody of GridView. So, I used the CSS friendly adapter[^] to customize the gridview (without creating new gridview that inherit from standard gridview)
You can check my example here[^].
3) If you don't like this example, you can find another example with ASP.NET ajax. (or something.) I'm sure that there is an example with ASP.NET because i saw once in my feed reader.. I will find this example if i'm free and will let u know..
for the time being, you can test my example..
|
|
|
|
|
Hello Friends,
I want to use the value of Class A in Class B
as in my program given below
class A
{
private int num = 10;//i want to use this num value in class B
public int Pro
{
get
{
return num;
}
}
}
class B
{
int n = //How to take value of Class A in this variable.
public void put()
{
Console.WriteLine(n);
}
}
static void Main(string[] args)
{
B e = new B();
e.put();
Console.ReadLine();
}
And when i did using the static properties it was rocking using instance properties it is not........................
|
|
|
|
|
The Knowledge wrote: class B
{
int n = //How to take value of Class A in this variable.
public void put()
{
Console.WriteLine(n);
}
}
class B<br />
{<br />
<br />
A objA = new A();<br />
int n = objA.Pro;
<br />
public void put()<br />
{<br />
Console.WriteLine(n);<br />
}<br />
}<br />
<br />
Hope it helps.
|
|
|
|