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

More Search Options

RSS Available

• Add time to db date

  I have some visual basic the gets the selected date. Here is how I grab the date right now. Dim stopDate As Date = finishDate.DbSelectedDate finishDate is a raddatepicker. It gets the date fine i.e. 12/3/2009 but what I need to do is add 23:59:59 to that before I pass it to an sql stored procedure. Does anyone know how I can do that? Thanks,

  Posted to Visual Basic .NET (Forum) by mandrews1234 on 12/3/2009

• Re: Add time to db date

  Thanks for your replies. I ended up just putting in a date and time picker so it's up to the user now. It's good to have those pieces of information though. Thanks

  Posted to Visual Basic .NET (Forum) by mandrews1234 on 12/3/2009

• Can't find div with JS

  I have a page that is a child to a master page. However, I can't seem to find the div I need. I know it is in my code but my js debugger says that the div is not there. Here is the code for my default.aspx page. My JS debugger cannot find the divMap but it is there. Can anyone help me out with this? <%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/TempMasterPage.Master" %> <%@ Register TagPrefix="sidepanel" TagName

  Posted to Client Side Web Development (Forum) by mandrews1234 on 11/19/2009

• Re: Can't find div with JS

  Thanks

  Posted to Client Side Web Development (Forum) by mandrews1234 on 11/19/2009

• Re: Deleteing parent/child colums

  Yes I apologize. I am developing 1 project right now and managing 4 others to outsourcing companies and I sometimes forget to post back once something is fixed. I went back through and marked what helped. This is what I ended up using. ;WITH CTE AS ( SELECT CategoryID, Name, ParentId FROM Categories WHERE CategoryID=@categoryId UNION ALL SELECT c.CategoryID, c.Name, c.ParentId FROM Categories AS c INNER JOIN CTE C1 ON C1.CategoryID = c.ParentId ) DELETE FROM Categories WHERE CategoryID IN ( SELECT

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

• Re: Deleteing parent/child colums

  Sorry for not getting back. For some reason the autoresponder emails started going to my spam mail. Gmails own emails were going in there too, so I'm wondering if they were having issues. I will try it out and see what I get. Thanks

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

• Re: URL Encode with VB

  Thanks for all of your responses. In case someone else comes across this, here is a simple quick and dirty example. Dim myWebClient As New System.Net.WebClient() myWebClient.Headers.Add("Content-Type", "application/x-www-form-urlencoded") Dim postQuery As Byte() = System.Text.Encoding.ASCII.GetBytes("action=login&username=marcel&password=password") Dim theResponse As Byte() = myWebClient.UploadData("http://www.webmasterworld.com/login.cgi", "POST"

  Posted to Visual Basic .NET (Forum) by mandrews1234 on 11/4/2009

• Re: Deleteing parent/child colums

  Rushik, how would I use your query in the sp? I ran it and saw that it did get all of the children, but how would I delete the recorde then? I put some psuedo in. ;WITH CTE AS ( SELECT CategoryID, Name, ParentId FROM Categories WHERE CategoryID=3 UNION ALL SELECT c.CategoryID, c.Name, c.ParentId FROM Categories AS c INNER JOIN CTE C1 ON C1.CategoryID = c.ParentId ) SELECT * FROM CTE --while I have records here I need to delete the categories --delete from categories where category id equals the current

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

• Re: URL Encode with VB

  Thanks for the encode method. What about adding POST data? I need to assign post variables and their values, do you know how to do that?

  Posted to Visual Basic .NET (Forum) by mandrews1234 on 11/2/2009

• Re: Deleteing parent/child colums

  I'm not for sure if I understand where you are getting the @CategoryToDelete

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