|
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.
|
|
|
|
|
class B
{
A e = new A();
int n = e.Pro;
public void put()
{
Console.WriteLine(n);
}
}
I've done as given above but it's also throwing error
A field initializer cannot reference the nonstatic field, method, or property 'B.e'
|
|
|
|
|
You should have an constructor in Class A.
|
|
|
|
|
<br />
class A<br />
{<br />
private int num = 10;
public A()<br />
{<br />
}<br />
public int Pro<br />
{<br />
get<br />
{<br />
return num;<br />
}<br />
}<br />
<br />
}<br />
<br />
<br />
class B<br />
{<br />
<br />
A objA = new A();<br />
int n = new int ();<br />
public B()<br />
{<br />
n = objA.Pro;<br />
}<br />
public void put()<br />
{<br />
}<br />
}<br />
|
|
|
|
|
Michael Sync wrote: You should have an constructor in Class A.
Not necessary. The problem is you are trying to assign the property value inside the class, not inside any methods. This is not allowed.
|
|
|
|
|
Are you saying that Class A doesn't need to have the constructor? assigning the value is the second pro..
|
|
|
|
|
Michael Sync wrote: Are you saying that Class A doesn't need to have the constructor?
Yes.
|
|
|
|
|
N a v a n e e t h wrote: Yes
If there is no constructor then we can't create the object of class A. A objA = new A(); . I know there are a lot of ways to do.. but based on my example 1, I did create the object of A. but i missed to mention to have the constructor in class A and B.
|
|
|
|
|
Michael Sync wrote: If there is no constructor then we can't create the object of class A
This is not correct. You can have a class without constructor. It is optional. Try creating a class without any constructor ? It won't show any problem. I guess internally default constructor would be created automatically. If we don't want to do any initialization stuff, we can avoid writing constructor.
|
|
|
|
|
Hi Navaneeth,
Yeah. You are correct. This is the second time that I made the mistake. Sorry about that.. I didn't know that the default constructor is not a must. I always used to add the default constructor.. Thanks for correcting me..
|
|
|
|
|
Yes absolutly.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Vri SSK wrote: Yes absolutely.
Thanks. Vri.
|
|
|
|