Hi, I have a problem with an sql procedure. What i want to do is build a procedure that will add a record to a database table and after the addition of the record will return the id of that record. So the procedure is: CREATE PROCEDURE AddListing @Name varchar(150), @Description varchar(1000), @Keywords varchar(50), @Address varchar(200), @Telephone varchar(50), @Fax varchar(50), @Mobile varchar(50), @Email varchar(50), @URL varchar(50), @Aproved bit, @Premium bit, @UserID int, @nextID int Output --

Hello, I have a class in my web application that is used to connect to the database and submit or gain data from my tables. The class is called dataAccess and is as follow: Public Class DataAccess Private Function Connect() As SqlClient.SqlConnection Try myConnection = New SqlClient.SqlConnection myConnection.ConnectionString = myConnectionString myConnection.Open() Return myConnection Catch ex As Exception 'Database Cannot be reached Return Nothing End Try End Function Protected Friend Function alertDatabase(ByVal myQuery As String) As Boolean Dim myCommand As SqlClient.SqlCommand Try 'Application.Lock() myCommand = New SqlClient.SqlCommand(myQuery, Connect()) myCommand.ExecuteNonQuery() DisConnect() 'Application.UNLock() Return True Catch ex As Exception DisConnect() Return False End Try End Function End Class At Application.Lock() my compiler says that namespace is not declare!!! how can i solve this problem? Can i declare the application? Thanks in advance, Kakomalis

Hi all, Im trying to do a web application and i have a problem with inheritance. What im trying to do is to have a base class with the top banner, navigation menu and footer in it. All my derive classes will inherit these and add their content to the body of that base class using html render or similar. I havent seen anything like that in any of the articles or forusms. Is it possible? Can i have a web form that i can treat it as a normal web for and then inherit from it? What i mean is a base web form with code behind that i can inherit. Thanks in advance, Kakomalis

hey, I have a problem with my repeater. Im trying to place a link button within a repeater and then write code to handle its events but i cant get it to work... <%# Container.DataItem("ad_id") %> <%# Container.DataItem("ad_title")%>
<%#Container.DataItem("ad_body") %> <%# Container.DataItem("ad_price") %> <%# Container.DataItem("ad_city") %> <%# getSource(Container.DataItem("ad_source")) %> I want to do two things: 1) I must give to the checkbox an id so i know which checkbox in the repeater was checked. -- for that im now doing it with the tooltip as you can see in the code. Is there any other way? 2) When a checkbox is checkeded or a linkbutton is click i want to receive the event in the code behing and handle it there. It will be something like : Private Sub lbNewSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lbNewSearch.Click getSelectedAds() Response.Redirect("keywordSearch.aspx") End Sub Though for some reason something like that doesnt work. It works for link buttons that are not within the repeater (as the code i paste which is a link button outside the repeater) but not for the ones inside the repeater. Any suggestions? Thank you very much in advance!!!