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

More Search Options

RSS Available

• Re: how large file upload in asp.net at a single click ??

  You can change the default upload size from 4M to some big value. Please refer to this link: http://weblogs.asp.net/jgalloway/archive/2008/01/08/large-file-uploads-in-asp-net.aspx

  Posted to Web Forms (Forum) by limno on 11/26/2009

• Re: Pivot Question

  Hi, I have seen a solution provided by Louis Davidson a few years ago at MSDN forum. Here is the link: http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/e6c57f76-9a91-4579-bb41-af4e51b4a548/ set nocount on create table pivotTest ( pkey varchar(10) primary key, pValue varchar(10) ) insert into pivotTest (pkey,pValue) select 'K1','V1' union all select 'K2','V2' union all select 'K3','V3' go select * from pivotTest go ;with breakdown as

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by limno on 11/25/2009

• Re: displaying records without primary key

  You can use a temp table approach: SELECT TOP 60 customername INTO #t1 FROM customer ORDER BY customername SELECT TOP 30 customername INTO #t2 FROM #t1 ORDER BY customername DESC SELECT * FROM #t2 ORDER BY customername DROP TABLE #t1 DROP TABLE #t2

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by limno on 11/25/2009

• Re: Trouble using session variable for query

  protected void Page_Load(object sender, EventArgs e) { Request.QueryString["MyUserId"]; Guid MyGuid = new Guid( Request.QueryString["MyUserId"]); Session["selid"] = MyGuid; } <SelectParameters> <asp:SessionParameter Name="aspnet_id" SessionField="selid" Type="Object" /> </SelectParameters> Or <SelectParameters> <asp:SessionParameter Name="aspnet_id" SessionField="selid" /> </SelectParameters>

  Posted to State Management (Forum) by limno on 11/25/2009

• Re: Trouble using session variable for query

  It is a good idea to simply use QueryStringParameter in this case.

  Posted to State Management (Forum) by limno on 11/25/2009

• Re: Need help displaying button on page if GridView1 is empty...

  Try the EmptyDataTemplate: <EmptyDataTemplate> <asp:Button ID="btnassign" runat="server" Text="assign" /> </EmptyDataTemplate>

  Posted to Data Presentation Controls (Forum) by limno on 11/25/2009

• Re: SQL Where Clause With DateTime

  Can you post your code that includes your SQL query? By the way, you should choose right names for your objects in your database. In this particular case, the word Date is not a reserved word in Sql Server 2000, 2005 and 2008. (it is a reserved word in Access and ODBC and future release).

  Posted to Visual Basic .NET (Forum) by limno on 11/25/2009

• Re: Pivot Question

  You may try to convert the solution with a dynamic sql approach. You can search for dynamic pivot to find some samples from this forum or other places. You may need to spend some time to make it work for you. This sort of matrix transformation in sql is not simple in my view. Good luck.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by limno on 11/25/2009

• Re: How do I retrieve list of users withing a distance from a zipcode?

  George Mastros has a post at lessthandot.com to provide a solution for your question: http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-zipcode-latitude-longitude-pr

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by limno on 11/25/2009

• Re: Select distinct

  Try the second solution with ROW_NUMBER function, it will give you a right result. You may need to play with it if something is not exactly fit your need. Or you can post what do you expect from your sample data. We may come up with a different solution. Thanks.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by limno on 11/24/2009