You searched for the word(s): userid:699329

More Search Options

RSS Available

• Re: Breakpoints are not working in Visual Studio .net

  Make sure your page directive has the following. AutoEventWireup="true"

  Posted to Visual Studio .NET 2003 and Visual Studio .NET 2002 (Forum) by mayankparmar2000 on 8/27/2008

• Re: Debugging Has Quit Working

  Make sure your page directive has the following. AutoEventWireup="true"

  Posted to Visual Studio .NET 2003 and Visual Studio .NET 2002 (Forum) by mayankparmar2000 on 8/27/2008

• Re: Cross Tab Query

  You can't do this by cross-matrix query. But you can gather such data Datatable in asp.net. say you have three tables table a which contains columns : year_id, year. table b which contains columns : region_id, region. table c which contains columns : year_id, region_id, amt. you just do: string sql="select year_id, year from a"; datatable maindt=sqlhelper.executedatatable(cn, text, sql); sql="select region_id, region from b"; datatable tempdt=sqlhelper.executedatatable(cn

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mayankparmar2000 on 9/10/2007

• Re: Gridview and checkbox related problem

  I would suggest that you take an array of string and store it in session. Whenever you are moving to next page check for checkboxes. read string array from session. Add and delete record ids from string array. store string array in session. When new page is loaded. read string array from session. check for ids for those records and set checkboxes as checked. For exporting write sql that gives these gives there particular records using where condition. and everybody knows best way to export in excel

  Posted to Data Presentation Controls (Forum) by mayankparmar2000 on 9/10/2007

• Re: join and count

  Or this : da = New Data.SqlClient.SqlDataAdapter("SELECT [Productmaker].[products], Count([Productmaker].[Production]) AS [Total] FROM [Productmaker] where [Productmaker].[Names]='" & request.querystring("names") & "' GROUP BY [Productmaker].[products] ", strConnection).

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mayankparmar2000 on 5/8/2007

• Re: join and count

  Try this : da = New Data.SqlClient.SqlDataAdapter("SELECT [Productlist].[products], Count([Productmaker].[Production]) AS [Total] FROM [Productlist] LEFT JOIN [Productmaker] ON [Productmaker].[products] = [Productlist].[products] where [Productlist].[Names]='" & request.querystring("names") & "' GROUP BY [Productlist].[products] ", strConnection).

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mayankparmar2000 on 5/8/2007

• Re: Sorting + Paging a large table in stored procedure

  Or simple Idea is : Select somecolumn(primary key) from (select top 100 somecolumn(primary key), othercolumn,othercolumn order by anycolumn) as mytbl where somecolumn(primary key) not in (select top 0 somecolumn(primary key) order by anycolumn) This way you can get First 1 to 100 records. Sameway Select somecolumn(primary key) from (select top 200 somecolumn(primary key), othercolumn,othercolumn order by anycolumn) as mytbl where somecolumn(primary key) not in (select top 100 somecolumn(primary key

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mayankparmar2000 on 5/7/2007

• Re: DataAdapter always returns 0 or empty rows

  You can not write aggregate function like count in where condition. You need to use subquery. const string COMMAND_TEXT = @"select distinct matchcode, recordcount from ( select distinct somefield as matchcode, count(somefield) as recordcount from filteredaccount where StateCode = 0 group by somefield ) As mytbl where recordcount > 1

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mayankparmar2000 on 5/7/2007

• Re: join and count

  Sorry for a little mistake: da = New Data.SqlClient.SqlDataAdapter("SELECT [Productlist].[Names], Count([Productmaker].[Products]) AS [Total] FROM [Productlist] LEFT JOIN [Productmaker] ON [Productmaker].[products] = [Productlist].[products] where [Products].[Names]='" & request.querystring("names") & "' GROUP BY [Productlist].[products] ", strConnection).

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mayankparmar2000 on 5/7/2007

• Re: join and count

  It's easy : da = New Data.SqlClient.SqlDataAdapter("SELECT [Products].[Names], Count([Productmaker].[Products]) AS [Total] FROM [Productlist] LEFT JOIN [Productmaker] ON [Productmaker].[products] = [Productlist].[products] where [Products].[Names]='" & request.querystring("names") & "' GROUP BY [Productlist].[products] ", strConnection).

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mayankparmar2000 on 5/7/2007