Search:

Hi Rohit,

You can use ROUND ( numeric_expression , length [ ,function ] ) function of SQL Server like below:
Select Round(ABC,0)

It will give you the rounded off value till decimal point.

...

Hi Smith,

It would be easier to answer if you will be specific about which platform you are working upon. Windows (WinForm or WPF) or Web


---V V---
Vikas Vaidya

Singleton class is a type of class which can have only one of it object through out the application. It does not allows its object to be created by the calling code e.g Class obj = new Class;
...

Hi Venkat,

Session objects are stored in memory alotted to IIS worker process (aspnet_wp). Sessions expired after a specified amount and time and are removed from the memory.


---V V---...

Your doubt is absolutely right.

Yes, we can have Unique constranit on more than one column, that's for sure.


---V V---
Vikas Vaidya

Hi Jai,

The query can be like

Select AvgSal, job from (
select avg(salary) AvgSal, job from [tablename] group by job
) as vw where job<>'manager'
and AvgSal > (Select Avg(Salary) from...

I think you can create a trigger on this table which will update the value of third column if there is any insert/update on that table.

That's the only way I think is to fulfill your requirement....

That's a silly mistake I have done in hurry. Sorry for that.

Actually we have to use
Select top 1 deptname, count(employee) as total from Employee group by deptname order by total.



---V...

There are many ways to do that

To use the case sensitive query in Sql u have to use its collation property along with query in format.

<Your select query> Collate SQL_Latin1_General_CP1_CS_AS
...

Select top 1 deptname, sum(deptname) as total from dept group by deptname order by total



---V V---
Vikas Vaidya

The simplest way to create report in .net is to use Crystal Report.

By wizard u just need to specify the database connection and table from where u have to display data.

By simply clicking on...

Hi,

You can do that by using the cross page postback as well.

It also seems much better from security point of view bcoz querystring can be interrupted by user.

The sample code for this can...

Hi Nishar,

There are various starter kits available free to download, some of them are of shopping cart as well. These starter kits already have some basic functionality implemented into it e.g.,...

Hi,

Basically there are two uses of using keyword.

1. Include the namespace in current code file which is done at top of the code like
using System.Data;
using System.Data.Sql;
...

ASP.Net is a technology which uses .Net Framework (class library) to provide some built-in functionality to create applications using .Net lanaguages (C#, VB.Net)

---V V---
Vikas Vaidya
...

Hi,

For this u need to create a virtual DVD on your machine. There are various tools available like Daemon.EXE which is a FREE Virtual CD/DVD-ROM-EMULATOR

You can download it from various free...

U can do that by inserting an ItemTemplate column.

Then right click on datagrid and select Edit ItemTemplate

Now u can insert a hyperlink in Header of it.


---V V---
Vikas Vaidya

Hi lijoputhuval,

There is no straight answer to your question as it depends on various factors.

Your application flow, architecture, features of .net being used and many more.

But still u...

Hi,

The simplest way to get the data from one dataset to another is use DataSet.Clone or DataSet.Copy method.


---V V---
Vikas Vaidya

Hi Raghav,

U can't make a cell editable by just selecting it.

A row can be make editable by providing an Edit column.
1. Right click on GridView, Click on SmartTag
2. Click on edit columns...

Hi Raghav,

You can do that simply by putting the cookieless="True" in Session tag of web.config.


---V V---
Vikas Vaidya
Please mark this post as Thank if u found it useful

Hi Mohsin,

here is the maximum information that u can get.

Maximum Capacity Speicification for SQL Server 2005

---V V---
Vikas Vaidya

Please mark this post as Thanks if u found it useful

Hi,

Difference between Response.Redirect and Server.Transfer are

1. Response.Redirect is a client side round trip and page History is maintained in case of it while Server.Transfer is a server...

Hi Manat,

Either u can simply do that by
putting it on the page where you dont want it to Go.
<body onLoad="history.go(+1)">


---V V---
Vikas Vaidya

Hi,

You can get an exe by creating a Windows Application project.

Just go through Create Project. Choose windows application template.


---V V---
Vikas Vaidya