Search:

Type: Posts; User: vikasvaidya; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.19 seconds.

  1. Answers
    4
    Views
    6,676

    SQL Server - Re: Remove decimal places

    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.

    ...
  2. Answers
    2
    Views
    1,578

    Re: I have problem in my datagrid viewer

    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
  3. Answers
    1
    Views
    1,321

    Re: Singleton class

    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;
    ...
  4. Answers
    3
    Views
    3,590

    ASP.NET Re: Where the session objects are stored?

    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---...
  5. Answers
    5
    Views
    2,421

    SQL Server - Re: Unique Constraint in SQL

    Your doubt is absolutely right.

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


    ---V V---
    Vikas Vaidya
  6. SQL Server - Re: List all the job groups who average salary exceeds that of managers.

    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...
  7. SQL Server - Re: create a table with 3 column where sum of 2 column is 3rd column

    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....
  8. Answers
    7
    Views
    1,546

    SQL Server - Re: display deptname

    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...
  9. Answers
    3
    Views
    1,384

    SQL Server - Re: Case sensitivity while compareing

    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
    ...
  10. Answers
    7
    Views
    1,546

    SQL Server - Re: display deptname

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



    ---V V---
    Vikas Vaidya
  11. Thread: asp.net

    by vikasvaidya
    Answers
    1
    Views
    1,225

    ASP.NET Re: asp.net

    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...
  12. Answers
    3
    Views
    1,301

    ASP.NET Re: pass information

    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...
  13. Thread: ASP.net

    by vikasvaidya
    Answers
    1
    Views
    1,239

    ASP.NET Re: ASP.net

    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.,...
  14. Answers
    7
    Views
    2,115

    Re: "using" Keyword

    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;
    ...
  15. Answers
    1
    Views
    2,824

    ASP.NET Re: language or technology

    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
    ...
  16. ASP.NET Re: How to get Ms Visual Studio 2008 Express?

    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...
  17. Thread: Datagrid

    by vikasvaidya
    Answers
    2
    Views
    1,737

    ASP.NET Re: Datagrid

    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
  18. ASP.NET Re: How to increase performance of web application created in asp.net

    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...
  19. Answers
    3
    Views
    1,432

    Re: Doubt on using Dataset

    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
  20. Answers
    3
    Views
    3,747

    ASP.NET Re: Gridview Editing

    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...
  21. Answers
    1
    Views
    1,222

    ASP.NET Re: Session Variables

    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
  22. Answers
    2
    Views
    1,486

    ASP.NET Re: Columns in a table

    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
  23. Answers
    9
    Views
    2,459

    ASP.NET Re: asp question

    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...
  24. Answers
    1
    Views
    1,806

    ASP.NET Re: Disabling back button

    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
  25. Answers
    7
    Views
    10,255

    Re: how to make exe file in .net?

    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
Results 1 to 25 of 66
Page 1 of 3 1 2 3
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact