Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:687031
More Search Options
RSS Available
Matching Posts
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
Page 1 of 46 (455 items) 1
2
3
4
5
Next >
...
Last »
ASP.NET:
PDC09: ASP.NET MVC 2: Ninjas Still on Fire Black Belt Tips
ASP.NET:
Hanselminutes Podcast 188: ASP.NET MVC 2 Beta with Phil Haack
ASP.NET:
Hanselminutes Podcast 186: .NET Debugging 101 with Tess Ferrandez
TechNet Edge:
WinRE and free stuff with Sean Kearney
WindowsClient:
XslCompiledTransform and large template elements
WindowsClient:
The Future of Client App Dev : WPF and Silverlight Convergence
Channel 9:
PDC09 GeekFest Party
Channel 10:
How to Use "Play to" and "Remote Media Streaming" in Windows 7
Channel 9:
The Visual Studio Documentary: Jeff Hadfield Full Length Interview
TechNet Edge:
Managing Your Entire World - Tech Focus November 2009 Part 3
Channel 9:
The Access Show: Managing Access Databases with SharePoint
Channel 10:
Show Us Your Tech - Mark Pendergrast Edition
TechNet Edge:
Mark Russinovich interview at TechEd EMEA 09
TechNet Edge:
IT Manager Podcast #31: Talking About Virtualization
TechNet Edge:
System Center Operations Manager 2007 R2 – Service Level Dashboard part 1: Introduction
WindowsClient:
MSXML XHTML DTDs - making the web better
TechNet Edge:
How it works: Active Directory Rights Management Services
Channel 9:
Inside Windows 7: Recovering Windows from System Degradation and Boot Failures
Channel 10:
Ebay Launches IE8 Webslice for Holiday Shopping
Channel 10:
New Windows Smartphone Includes Built-in PowerPoint Projector
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online