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

More Search Options

RSS Available

• Re: Dynamic SQL Help needed.

  You are right ..exec(@sql ) will solve the problem But If I want to use sp_executesql then problem remain as it is. Why this -- Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar' -- error we are getting. Is there any solution for it.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bargemahesh on 8/3/2009

• Re: Dynamic SQL Help needed.

  is there any solution for below code statement. DECLARE @strConcept nvarchar(1000); SET @strConcept='49106,49105,49104,49103'; DECLARE @strSQL nvarchar(2000); set @strSQL = 'SELECT * FROM rb_ConceptAttributeValue where ConceptID IN (@xConceptID)' print @strSQL; EXEC sp_executesql @strSQL ,'@xConceptID nvarchar(1000)',@strConcept

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bargemahesh on 8/3/2009

• sp_executesql - Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'.

  Hi I am writing dynamic sql in a stored procedure. which dynamicaly creates input parameter for sp_executesql but it gives following error. Error Msg - Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'. I want to use sp_executesql though I can get same solution by using exec(@sql) . My Complete Code as follows. DECLARE @strConceptID varchar(1000); SET @strConceptID='49106,49105,49104,49103'; DECLARE @xxConceptID table(Id int ,Data nvarchar(100)); INSERT

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bargemahesh on 8/3/2009
  Filed under: Dynamic Query, dynamic table name, Dynamic SQL&quot, sql server 2005 express edition installation, sql server, sql management studio drop tables, "SQL Select and Update Where ", SQL 2005 SQL, SQL 2005 where clause, Sql Server 2008 Express

• Re: Incrementing a number each time the if is ran?

  int l_intCounter=0; Loop start here :- count =0; count < 235 ; count++ if ((count >= 0) && (count <= 98)) { count++; SequenceNumbers sn = new SequenceNumbers(); lblSubStr.Text =lblSubStr.Text + sn.GetNumberSequence(count); } else if ((count >99) && (count <= 333)) {// got to increment this somewhere AlphaNumberSeq ans = new AlphaNumberSeq(); lblSubStr.Text =lblSubStr.Text + ans.GetAlphaNumberSeq(l_intCounter); l_intCounter++; } End Loop OutPut :- buffal01,buffal02,buffal03

  Posted to Getting Started (Forum) by bargemahesh on 5/29/2009
  Filed under: ASP .NET 2.0

• Re: How to RUn ASP Page in ASP.NET

  Hi Arisaravanan You can run classical ASP files in to ASP.NET Solution. Use following way 'AspCompat' page property is an aid in migrating ASP pages to ASPX pages. It defaults to false but should be set to true in any ASPX file that creates apartment-threaded COM objects--that is, COM objects registered ThreadingModel=Apartment. That includes all COM objects written with Visual Basic 6.0. AspCompat should also be set to true (regardless of threading model) if the page creates COM objects

  Posted to Migrating from ASP to ASP.NET (Forum) by bargemahesh on 5/27/2009

• Re: how to session out when I click "Back" button

  Hi There are several way through which you can move from your website to another website. I think I will provide you solution for some ways. 1. If user are clicking on asp.net link button then you can easly track this event and carry out logout functionality. 2. If any client side code may navigate user to other site - in this case please minimize the session time out time in IIS, so that once user will go to other site IIS automaticaly delete the session after specified IDEAL time.

  Posted to Security (Forum) by bargemahesh on 5/27/2009
  Filed under: asp .net 2.0, IIS 6.0

• Re: a member profile address without a folder name only nickname

  Hi Wencui I think you are right. Mr. Kiyak should acquire ASP.NET MVC project path for there requirement.

  Posted to Security (Forum) by bargemahesh on 5/27/2009
  Filed under: asp .net 2.0