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

More Search Options

RSS Available

• Re: PopupControlExtender in a Repeater

  I figured out my own solution. In case someone is making the same mistake I am making here's what the problem was. As I mentioned I had the PopupControlExtender and the panel both in the <ItemTemplate> of the repeater. What I forgot was I had that Panel enclosed in an UpdatePanel (Bad Idea!!). I just took out the update panel and it worked as it was supposed to. Thanks.

  Posted to ASP.NET AJAX Control Toolkit (Forum) by AmNoGeek on 1/24/2008

• PopupControlExtender in a Repeater

  Has anyone tried putting the PopupControlExtender in a Repeater or a Datagrid? I have a repeater that displays a list of categories and a (?) next to it. If anyone clicks on the '?', it should open a popup window and display additional information on that category. I tried putting the PopupControlExtender inside the ItemTemplate of the repeater but it displays the popups in the repeater at all times. Normally the popup won't show up unless you click a link or a button (specified as TargetControlID

  Posted to ASP.NET AJAX Control Toolkit (Forum) by AmNoGeek on 1/24/2008

• Re: SQL Query Queue

  Well, that was my suggestion to start with, but I was asked to look into other possibilities.

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

• Re: Tricky SELECT

  I forgot to mention that I am assuming that the result of the splitter function is a comma delimited string.

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

• Re: Tricky SELECT

  Ok, now I understand the situation. Maybe this will help, or may be not. Just give it a try. The solution uses a temp table, but I can't think of a better solution right now. Execute the SQL below and you will get an idea of what is happening. Declare @name1 VARCHAR ( 50 ), @name2 VARCHAR ( 50 ), @name3 VARCHAR ( 50 ), @lastname VARCHAR ( 50 ) Set @name1 = 'Johnson|Vasques' Set @name2 = 'Adams|Fox|Johnson' Set @name3 = 'Vasques|Smith' --Result of the splitter function

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

• Re: Tricky SELECT

  I was not sure of the output you wanted, I thought that for the following cases, after you check if any of them have "FOX" or "SMITH" you need to just return the whole pipe delimited string. Johnson|Vasques Adams|Fox|Johnson Vasques|Smith I did not know if you wanted to split the names and them that way. If you can confirm what exactly you want in the output, may be I can give it another shot.

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

• Re: Tricky SELECT

  I was not sure of the output you wanted, I thought that for the following cases, after you check if any of them have "FOX" or "SMITH" you need to just return the whole pipe delimited string. I did not know if you wanted to split the names and them that way. If you can confirm what exactly you want in the output, may be I can give it another shot. Johnson|Vasques Adams|Fox|Johnson Vasques|Smith

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

• Re: how to excute stored procedure that insert record and return last inserted value

  Well, if you are using the ExecuteScalar or ExecuteNonQuery to call that stored procedure, both should have an output value, lets call it "result". So all you have to do is : int result = db.ExecuteNonQuery(command); //Where command is the command object

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

• Re: Tricky SELECT

  In the situation you are describing you are splitting first and then trying to see if you can find a match. Why not compare first, and then split the last name. I do not know what exactly your requirements are but would a siimple statement like this not work? Select * From YourTable Where LastName Like '%FOX%' Or LastName Like '%SMITH%'

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

• SQL Query Queue

  I have a requirement where once we create a new record in a table, we submit a query to fetch some data and save it in one of the columns of the newly created record. The main requirement is that the server where we fetch the data from can be down for sometime for regular maintenance and we do not want to loose the fetch query in that process. Is there a way we can implement this? Thanks.

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