Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ninjadeathmonkey

    CLR and Scalar-valued function

    Just in case anyone is interested, I figured it out (kinda). In order to check if the parameter is null (and return null), you have to add this: CREATE FUNCTION DECRYPT_RSA ( @Expression NVARCHAR(max), @PrivateKey NVARCHAR(max) ) RETURNS NVARCHAR(max) WITH RETURNS NULL ON NULL INPUT...
  2. ninjadeathmonkey

    CLR and Scalar-valued function

    By the way, this is the error message I get: Ron Wheeler Tekdev Open Source Development
  3. ninjadeathmonkey

    CLR and Scalar-valued function

    I'm creating a function that calls a class I wrote in C# to encrypt and decrypt text. I can get this code to create the function just fine: CREATE FUNCTION DECRYPT_RSA ( @Expression NVARCHAR(max), @PrivateKey NVARCHAR(max) ) RETURNS NVARCHAR(max) AS EXTERNAL NAME...
  4. ninjadeathmonkey

    Method to add in the C# program

    You could always just run: Application.Exit(); ;-) Ron Wheeler Tekdev Open Source Development
  5. ninjadeathmonkey

    onchange event

    Well, the problem is that the date field is readonly. So technically it will never change (by that I mean it can never be changed by typing it it). I believe that the onchange event only gets called when a user physically types in it then it loses focus (and only if the text has changed). If you...
  6. ninjadeathmonkey

    Supply a stored procedure with byte array

    Haha. Yeah, I'm not sure either. I'll have to load the OleDbCommand object into Reflector or something to see how it does it. I could be wrong, but I don't think the database does the conversion. swreng, By the way, did that help at all? Ron Wheeler Tekdev Open Source Development
  7. ninjadeathmonkey

    Supply a stored procedure with byte array

    Well, I'm pretty sure you can pass a byte array to a stored procedure. Here is an example from SQL Server Magazine on how they did theirs: Article Listing A: C# Code That Calls the p_insertimage Procedure public class ImageData { public static void Main() { string sconn =...
  8. ninjadeathmonkey

    Supply a stored procedure with byte array

    Well, I don't think this has anything to do with it, but shouldn't you initialize bts like this: byte[] bts = new byte[str.Length]; I don't think you need the str.Length - 1 in there. As for the parameter, I doubt it will make much of a difference, but what if you changed it to something...
  9. ninjadeathmonkey

    Force Reload of CSS Style Sheet

    yeah, I know a lot of design companies that version their files. Something like, style1_1.css, style1_2.css, etc. But putting the version in a querystring would work just as great. Ron Wheeler Tekdev Open Source Development
  10. ninjadeathmonkey

    Force Reload of CSS Style Sheet

    It works for me. Using .net 2.0 and firefox to test. You might try IE to be sure as well. Ron Wheeler Tekdev Open Source Development
  11. ninjadeathmonkey

    Create a text file based on following

    Essentially, it's the same, just do another query and while loop. string fileLocation = @"c:\mytext.txt"; SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM Person", conn); SqlDataReader reader = cmd.ExecuteReader(); TextWriter...
  12. ninjadeathmonkey

    Page.Control

    I'm not really VB.NET programmer, but wouldn't you pass the parameter ByRef so that it's updating the original page, not just a copy? Which doesn't really matter, since he is using C#. Which would then need "ref". So, in C#: public void AddControlToPage(ref System.Web.UI.Page myPage) {...
  13. ninjadeathmonkey

    CSS alignment

    Thanks! Looks good. Ron Wheeler Tekdev Open Source Development
  14. ninjadeathmonkey

    Forms Authentication Redirect to default.aspx

    Instead of redirecting like you do in your example, you would just redirect to yahooo.com. if(user=="jack" && pass=="jill") { Response.Redirect("http://www.yahooo.com"); } Ron Wheeler Tekdev Open Source Development
  15. ninjadeathmonkey

    Page.Control

    So you want to add the control, "label", to your custom class? Does your class inherit/extend System.Web.UI.Page? If so, then I can't see why that doesn't work. I guess I just need to ask what you are trying to do. The way I'm imagining it is: namespace MyApp { using System.Web.UI...
  16. ninjadeathmonkey

    CSS alignment

    Thanks monksnake! I'm kinda in between projects at work, so just killing some time. ;-) Ron Wheeler Tekdev Open Source Development
  17. ninjadeathmonkey

    CSS alignment

    Oops, I meant to take out the "display:inline" part. Ron Wheeler Tekdev Open Source Development
  18. ninjadeathmonkey

    Browser specific css

    I'm a little confused as to why the css is being set to a new Array() to begin with though. It can only be set to a single string, right? Also, you have to make sure the document has been loaded (at least the <link> tag) before this script it run, so you may want to put the link tag before...
  19. ninjadeathmonkey

    CSS alignment

    I'm not a huge fan of inline styles, but here's what I did to somewhat fix it: <div style="padding:100px 30px 0px 25px;position:absolute;"> <div style="border:1px solid black; height:155px; width: 450px;"> <div...
  20. ninjadeathmonkey

    Forms Authentication Redirect to default.aspx

    You have to update the web.config to specify which pages are protected. In web.config (in <system.web>) <authentication mode="Forms"> <forms name="LoginAuth" loginUrl="~/login.aspx" timeout="20" cookieless="UseCookies" /> </authentication> In web.config (outside <system.web>) <location...

Part and Inventory Search

Back
Top