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

More Search Options

RSS Available

• withdrawn- no answers

  withdrawn

  Posted to Web Forms (Forum) by mlasell on 3/6/2009

• Re: Return value froma stored procedure insert

  It seems a bit of a hack, but I changed the Select stored proc used by GetData() to "SELECT TOP 1 * FROM solKit ORDER BY ID DESC" then in the .cs, I can check the last row to see if it has already been inserted, before inserting again: InfoTableAdapters. SolKitSelectCommandTableAdapter dbInsert = new InfoTableAdapters. SolKitSelectCommandTableAdapter (); string theEmail = dbInsert.GetData()[0].email.ToString(); if (theEmail != Email) { dbInsert.Insert @FirstName, @LastName, @Email); } ThanksLbl

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

• Re: Return value froma stored procedure insert

  Thank you - I think the errror came up as I was simplifying the code to put on the forum. I wonder if I can use the tableadapter > stored procedure code to access ID or if I need to go back to sql commands in the .cs. InfoTableAdapters. SolKitSelectCommandTableAdapter dbInsert = new InfoTableAdapters. SolKitSelectCommandTableAdapter (); dbInsert.Insert( @FirstName, @LastName, @Email);

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

• Re: Return value froma stored procedure insert

  Can you show me what you mean.? Thanks

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

• Re: Return value froma stored procedure insert

  Thanks, I saw this method while searching. This is quite a pain to do for all my forms. Can there really be no way to access the return value through the insert? What is the point of the shortcut code if you can't do what you need?

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

• Re: General class for character replacements for all form inputs

  I found this post to do the trick: http://forums.asp.net/t/1254125.aspx

  Posted to Web Forms (Forum) by mlasell on 1/25/2009

• Return value froma stored procedure insert

  Hello, I imagine this has been answered many time here, but I can't seem to find the answer. I have created a simple stored procedure USE [Journal] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbuser] . [SolKitInsertCommand] ( @nameFirst varchar ( 50 ), @nameLast varchar ( 50 ), @email varchar ( 50 ), AS SET NOCOUNT OFF ; INSERT INTO [dbo] . [solKit] ( [nameFirst] , [nameLast] , ) VALUES ( @nameFirst , @nameLast , @email ) RETURN SCOPE_IDENTITY () Then I called it in my

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

• Re: How to customise the ValidationSummary output...

  You can do it with no screenspace by using a MessageBox: < asp : ValidationSummary ID ="valsum" runat ="server" DisplayMode ="BulletList" ShowMessageBox ="true"/>

  Posted to Web Forms (Forum) by mlasell on 1/19/2009

• Re: How to customise the ValidationSummary output...

  Here is a hack. A javascript expert could do this more elegantly. But it does what you want. It inserts a javascript at the time of the submit which splits the content of the Validation Summary div on </li><li> and replaces it with the split. Since the css sets the ul list-style-type to none, the rest of the ul doesn't show. All the error messages after the first start with a space. In the file: < head > < style type ="text/css"> #Valsum ul li { float : left

  Posted to Web Forms (Forum) by mlasell on 1/19/2009

• Re: How to customise the ValidationSummary output...

  I played with that but it seems the javascript idea is right. All the output is already set in the page as it loads - so an OnLoad event doesn't help. If all you care about is the output in a single line you could use css. Not exactly what you wanted, but simple... < style type ="text/css"> #valsum ul li { float : left ; margin-left : 10px ; padding-right : 10px ;} </ style > < asp : ValidationSummary ID ="valsum" runat ="server" DisplayMode ="BulletList"

  Posted to Web Forms (Forum) by mlasell on 1/19/2009