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

More Search Options

RSS Available

• Re: Detailed Search Button and StoredProcedure..

  ALTER PROCEDURE dbo.StoredProcedure7 @kategori char (23), @kategori1 char (48), @kategori2 char (55), @tfiyat money , @tfiyat1 money , @fiyat money , @fiyat1 money , @garantidurumu char (26), @sifirikinciel char (17), @kargoucreti char (17), @sehir char (30), @StartRowIndex INT , @NumRows INT AS SET NOCOUNT ON SET Statistics io ON DECLARE @Query VARCHAR (8000); DECLARE @ Where VARCHAR (8000); SET @Query = ' WITH ListEntries AS (SELECT ROW_NUMBER() OVER (ORDER BY urunnumarasi ASC) AS Row, [urunnumarasi

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Lolli on 1/9/2009

• Re: Formview - Email button.

  What do you mean by "cannot see"? Have you tried formview.Findcontrol("your label id")?

  Posted to Data Presentation Controls (Forum) by Lolli on 1/9/2009

• Re: sql database

  Is this a local server?

  Posted to Time Tracker Starter Kit (Forum) by Lolli on 1/9/2009

• Re: Detailed Search Button and StoredProcedure..

  It seems to me you need to get back to some learning stuff. Checkout the data access tutorials at http://www.asp.net/learn/data-access/. This will make much more sense to you.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Lolli on 1/9/2009

• Re: Detailed Search Button and StoredProcedure..

  Where in this do you build a dynamic query?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Lolli on 1/6/2009

• Re: Detailed Search Button and StoredProcedure..

  Post the stored proc

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Lolli on 1/6/2009

• Re: Detailed Search Button and StoredProcedure..

  Just add these in the where clause string.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Lolli on 1/5/2009

• Re: Detailed Search Button and StoredProcedure..

  I'm sorry but I don't really have time for that. The sample I posted handles both varchars and numbers as parameters, it should not be complicated fo you to apply it.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Lolli on 1/5/2009

• Re: AJAX Tab Container

  By changing the CSS related to them. What needs changing is described in the posts I sent.

  Posted to ASP.NET AJAX Control Toolkit (Forum) by Lolli on 1/5/2009

• Re: Detailed Search Button and StoredProcedure..

  What you can do is build the statement in a sting and then execute it. Here is an example: CREATE PROCEDURE MyProc ( @Param1 VARCHAR (50) = NULL , @Param2 INT = NULL ) AS DECLARE @Query VARCHAR (8000); DECLARE @ Where VARCHAR (8000); SET @Query = 'SELECT col1, col2, col3 FROM table' ; SET @ Where = '' ; IF (@Param1 IS NOT NULL AND @Param1 <> '' ) BEGIN IF (@ Where = '' ) BEGIN SET @ Where = 'WHERE ' ; END ELSE BEGIN SET @ Where = @ Where + ' AND '

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Lolli on 1/5/2009