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

More Search Options

RSS Available

• Management Studio Express - Accessing Local Files When Browsing a Remote Server

  Here's my issue. I have Management Studio Express installed on a server which I have full access to. The SQL Server instance lives on another server which I don't have any access to except the database that was created there for me (which I have db_owner rights on). I have my .bak file that I want to use to restore the database will all the data, but when I browse for the file, I get the directory from the server which the SQL instance is on (which seems like a security issue to me), not

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by RyanSmith345 on 9/10/2008

• Re: Expression of type 'String' can never be of type 'System.DBNull'.

  Aaron, Don't I feel like an idiot. It's been a while since I've written that code and I forgot that there were built in functions of the typed dataset that did the test for me. Odd that is so hard to Google the answer for. I feel much better about my code now. Thanks again. Ryan.

  Posted to Visual Basic .NET (Forum) by RyanSmith345 on 8/7/2008

• Re: Expression of type 'String' can never be of type 'System.DBNull'.

  dr is a data row from a data table. Volume looks like: <xs:element name="Volume" msprop:Generator_UserColumnName="Volume" msprop:Generator_ColumnPropNameInRow="Volume" msprop:Generator_ColumnVarNameInTable="columnVolume" msprop:Generator_ColumnPropNameInTable="VolumeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction>

  Posted to Visual Basic .NET (Forum) by RyanSmith345 on 8/6/2008

• Re: Expression of type 'String' can never be of type 'System.DBNull'.

  Thanks for the suggests, but no luck on either. The problem is it will throw an exception if you try to retrieve the value at all, hints why test "Is Nothing" will crash. It's the same issue with: IF NOT DbNull.Value.Equals(dr.Volume) THEN I'm really at a loss here. I guess the Try..Catch blocks will have to stay for now and I can just go on looking like a sloppy coder. Thanks again. Ryan.

  Posted to Visual Basic .NET (Forum) by RyanSmith345 on 8/5/2008

• Re: Expression of type 'String' can never be of type 'System.DBNull'.

  Thanks for the suggestion, but at compile time I get the error: Overload resolution failed because no accessible '=' can be called with these arguments: 'Public Shared Operator =(a As String, b As String) As Boolean': Value of type 'System.DBNull' cannot be converted to 'String'. I've tried everything I possible can on this error with no luck. I've finally had to resort to the ugle hack of: Try s &= dr.Volume Catch ex As Exception End Try I hate leaving

  Posted to Visual Basic .NET (Forum) by RyanSmith345 on 8/5/2008

• Expression of type 'String' can never be of type 'System.DBNull'.

  The DBNull has always caused me problems. I thought this code would work fine: If Not TypeOf (dr.Volume) Is System.DBNull Then However when I enter that code, I get the build error: Expression of type 'String' can never be of type 'System.DBNull'. I've also tried: If Not IsDBNull(dr.Volume) Then But that just chokes at run time with the "dr.Volume is DBNull" What's the right code here? This is driving me nuts!

  Posted to Visual Basic .NET (Forum) by RyanSmith345 on 8/4/2008

• Re: Simplest way to validate a number

  PLBlum, Thanks for the response. This looks like it might actually do the trick. I'm still not impressed with the Validation controls provided by ASP.NET and clearly from this post there needs to either be some better documentation or they need to be thought out better . I understand the thought behind having separate controls for each different validation situation, but for something as simple as validating numeric input, it shouldn't require this much effort. Ryan.

  Posted to Web Forms (Forum) by RyanSmith345 on 3/11/2008

• Re: Simplest way to validate a number

  Well I guess I get to remain frustrated. That's essentially the exact same code that I have and it is displaying the range error every time I post back. Maybe it has something to do with my master page... Who knows? I guess it's writing custom JavaScript for me which would have been easier in the first place. Thanks for your help Ryan.

  Posted to Web Forms (Forum) by RyanSmith345 on 3/11/2008

• Re: Simplest way to validate a number

  OK, so one last question and I have to figure this out because it's really bothering me. I have a text field that has both a range validator and required field validator set to it (apparently this is what needs to be done). It seems to work OK, but when the page reloads after a valid postback, then the range validator will display its error message. Very frustrating. Any ideas on why this is happening? <asp:TextBox ID="txtVoc" runat="server" /> <asp:RangeValidator

  Posted to Web Forms (Forum) by RyanSmith345 on 3/11/2008

• Re: Simplest way to validate a number

  One other thing that is messing this all up is the range validator will display the error message after a valid postback. Stupid controls.

  Posted to Web Forms (Forum) by RyanSmith345 on 3/11/2008