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

More Search Options

RSS Available

• trim string

  Hi I'm trying to do : upName = upName.Trim() in the code below but it doesn't appear to be doing anything. any ideas? If (fileupload1.HasFile) Then lblError.Text = "" 'Check to make sure the file to upload has a picture file format extention If (CheckFileType(fileupload1.FileName)) Then Dim newWidth As Integer = bmpW Dim newHeight As Integer = bmpH 'Use the uploaded filename without the '.' extension Dim upName As String = Mid(fileupload1.FileName, 1, (InStr(fileupload1

  Posted to Getting Started (Forum) by ajw on 11/2/2009

• selecting different sql command based on db entry

  the reader is from another datareader earlier in code.The sql command is being changed successfully but i'm getting an error of (see under code): My code: If reader("ParentPageID") Is Nothing Then SqlDataSource2.SelectCommand = "SELECT PageID, PageName, ParentPageID, PageOrder FROM(Pages) WHERE (ParentPageID = @PageID) ORDER BY PageOrder" Else SqlDataSource2.SelectCommand = "SELECT PageID, PageName, ParentPageID, PageOrder FROM(Pages) WHERE (ParentPageID = @ParentPageID

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

• gridview different row colours depending on db value

  Hi, I want to highlight rows in a gridview depending on a db entry. If ParentPageID = 1 then colour the row in blue for example Thanks Andy

  Posted to Data Presentation Controls (Forum) by ajw on 11/1/2009

• Re: gridview different row colours depending on db value

  Yeah there are some really cool color names too- like 'goldenrod'... One of bill's own. http://www.opinionatedgeek.com/DotNet/Tools/Colors/default.aspx Protected Sub parentPagesGridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound If e.Row.RowType = DataControlRowType.DataRow Then 'determine the value of the UnitsInStock field If (DataBinder.Eval(e.Row.DataItem, _ "ParentPageID").ToString

  Posted to Data Presentation Controls (Forum) by ajw on 11/1/2009

• declarative dropdownlist binding with conditions

  Hi, I want to put a condition of 'if not null' on this: http://www.opinionatedgeek.com/DotNet/Tools/Colors/default.aspx Parent Page:<br /> <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2" DataTextField="PageName" DataValueField="PageID" Height="20px" Width="300px" Text='<%# Bind("ParentPageID") %>'> </asp:DropDownList> Is that possible? Thanks Andy

  Posted to Web Forms (Forum) by ajw on 11/1/2009

• Re: selecting different sql command based on db entry

  (Pages) shouldn't have been in brackets.

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

• exporting stored procs to remote server using sql server management studio 08

  Hi, I want to export stored procs to remote server. I'm using sqlserver management studio 08 .Can anyone point me to some good articles on this or shed some light. Thanks Andy

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ajw on 10/31/2009

• Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

  Hi folks, I know this is going to be pretty basic. I'm uploading my site onto the client's remote server and getting: Where could this problem be coming from? Thanks Andy.# I've removed the user and password ;) connection string: <add name="hallam-cmsConnectionString" connectionString="Data Source=localhost;database=****;Integrated Security=True;uid=****;password=****;Pooling=False" providerName="System.Data.SqlClient"/> Server Error in '/'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ajw on 10/31/2009

• limited characters displayed

  hi I've got a repeater as below. I want to limit the length of Page Content so it only shows an excerpt. Would I do that here or in the SQL command? Thanks Andy <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1"> <ItemTemplate> <p> <asp:LinkButton ID="LinkButton3" runat="server" PostBackUrl='<%# String.Format("~/Admin/page.aspx?PageID={0}", Eval("PageID")) %>' Text='<

  Posted to Data Presentation Controls (Forum) by ajw on 10/31/2009

• Re: Object reference not set to an instance of an object.

  that actually worked, you're a genius Thanks Andy

  Posted to Getting Started (Forum) by ajw on 10/31/2009