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

More Search Options

RSS Available

• Re: Stored Procedure

  Is it used to show row affected? Because if so I am using this to get the rows affected. Thanks in advance. rowsAffected = ocsDataSource.Update()

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by smaddaloni on 3/21/2008

• Re: Stored Procedure

  No I'm not. I will give it a try. I am real new to everything. I will read up on that and give it a try. Thanks

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by smaddaloni on 3/21/2008

• Re: Stored Procedure

  Ok I think the code you gave me above in C# and I am using VB so I translated it the best I could. Here is the code I added. It was only one line of code. It didn't come up with any errors but when I checked the row it didn't update it either and when I runn the debug it shows the values that I need to go in. I am not sure what is going on. Anyways here is code I added. ocsDataSource.UpdateCommand = "StoredProcedure1" ocsDataSource.UpdateParameters.Add( "CustomerID" ,

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by smaddaloni on 3/21/2008

• Re: Stored Procedure

  Sorry it should have said CustomerID I fixed the post above. It is telling me the UserN doesn't have a value when it goes into the stored procedure. I will try the code you gave me. The only thing I am using UserN for is to find the correct customer row I won't be updating it with anything. Anyways thanks.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by smaddaloni on 3/21/2008

• Stored Procedure

  I am trying to figure out how to pass a variable from my web page to the stored procedure I have. I thought this code would work. Let me know if you guys have any thoughts on this. Here is the code I used. WEB PAGE Protected Sub Button1_Click( ByVal sender As Object , ByVal e As System.EventArgs) Dim ocsDataSource As New SqlDataSource() Dim Label1 As String = CType (DetailsView2.FindControl( "Label1" ), Label).Text Dim Label3 As String = CType (DetailsView3.FindControl( "Label3"

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by smaddaloni on 3/21/2008

• Re: Writing from one table to another

  I just started learning HTML, ASP.NET, SQL, and VB and the tutorial I read did examples this way. All the user name and password stuff are in stored procedures. Would this still cause probems? I guess I still have alot more to learn.

  Posted to Data Presentation Controls (Forum) by smaddaloni on 3/20/2008

• Re: Writing from one table to another

  After three or four days of searching I found the answer to my problem. I had tried this before but could never get it working right. Anyways here is what I used to get the value. < asp : DetailsView ID ="DetailsView2" runat ="server" AutoGenerateRows ="False" DataSourceID ="SqlDataSource2" Width ="185px" > < Fields > < asp : TemplateField > < ItemTemplate > < asp : Label ID ="Label1" runat ="server"

  Posted to Data Presentation Controls (Forum) by smaddaloni on 3/20/2008

• Re: Writing from one table to another

  Yes I used the login control in Visual Web Developer. The login information is stored in a seperate database but when they sign up I put the login name in the Customers table. The way I did that was custDataSource.InsertParameters.Add("UserName", User.Identity.Name). I also enter the user name in orders when it writes the to the orders table like so custDataSource.InsertParameters.Add("UserName", User.Identity.Name). I am not exactly sure how the User.Identity.Name makes the user

  Posted to Data Presentation Controls (Forum) by smaddaloni on 3/19/2008

• Re: Writing from one table to another

  Ok so lets say they registed and a couple days later they log back in and place an order. How would I pick up the CustomerID and put it in the orders table. Thanks

  Posted to Data Presentation Controls (Forum) by smaddaloni on 3/19/2008

• Re: Writing from one table to another

  Does anyone have any idea on this? It is really fustrating me. I have been trying to figure this out for 3 days now. I have the User name stored in Customers Table and Orders Table (Customers.UserName and Orders.UserName). Should I just use that field as the Primary and Foriegn Keys? I am afraid to do that because I think I will just have problems later on when I do not have that option to do that. Anyways any help would be appreciated.

  Posted to Data Presentation Controls (Forum) by smaddaloni on 3/18/2008