Database

ALTER PROCEDURE dbo.InsertNewSite
(
	@param_url nchar(250),
	@param_ip nchar(15),
	@param_username uniqueidentifier,
	@param_time datetime
)
AS
	SET NOCOUNT OFF;
INSERT INTO sites
                      (url, ip_address, username, access_time)
VALUES     (@param_url,@param_ip,@param_username,@param_time)

RETURN SELECT id FROM sites WHERE sites.url = @param_url AND sites.access_time = @param_time 

string newSiteId = "";
      // add the new site to the database
      lock (this.selectAllSitesNotBannedTableAdapter)
      {
        newSiteId = (string)this.selectAllSitesNotBannedTableAdapter.InsertNewSiteNotBanned(host, requestor, new Guid("bcadf8d7-c96d-4981-bf26-de9915ac6d49"), DateTime.Now);
      }

txtName.Text=String.Empty;<br />
txtFname.Text=String.Empty;

DataRow dr=dt.NewRow();<br />
dr["firstname"]=txtName.Text;<br />
dr["lastname"]=txtFname.Text;<br />
dt.Rows.Add(dr);<br />
da.Update(dt);<br />
dt.AcceptChanges();<br />
int RowTablePosition=0;<br />
RowTablePosition =dt.Rows.Count-1;

System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'BRIEN'. Unclosed quotation mark before the character string ''.

ALTER PROCEDURE MyProc<br />
(@RecordPerPage int,<br />
 @PageNumber int<br />
)<br />
AS<br />
select top @RecordPerPage *<br />
from MyTable<br />
where KeyField><br />
   select Max(KeyField) from <br />
     (select top @RecordPerPage*(@PageNumber-1) KeyField<br />
      from MyTable<br />
      order by KeyField) a<br />
order by KeyField

,nvl(some_column,'DefaultText')