Database

<br />
SELECT TOP(@N) web_News.ArticleDate, web_NewsLocalized.ArticleTitle,<br />
web_NewsLocalized.ArticleText<br />
FROM web_News INNER JOIN web_NewsLocalized ON<br />
web_News.ArticleId=web_NewsLocalized.ArticleId<br />
WHERE ((web_NewsLocalized.ArticleCulture)=[@Culture]) ORDER BY web_News.ArticleDate DESC;<br />

<br />
SELECT web_News.ArticleDate, web_NewsLocalized.ArticleTitle,<br />
web_NewsLocalized.ArticleText, (SELECT COUNT(*) FROM web_News AS B WHERE B.ArticleDate>=A.ArticleDate) AS RowNumber<br />
FROM web_News AS A INNER JOIN web_NewsLocalized ON<br />
web_News.ArticleId=web_NewsLocalized.ArticleId<br />
WHERE ((web_NewsLocalized.ArticleCulture)=[@Culture] AND RowNumber<=@N) ORDER BY web_News.ArticleDate DESC;<br />

<br />
select *<br />
from order<br />
WHERE ord_date = @ComparedDate<br />

<br />
Dim cmd as new SqlCommand(select * from order WHERE ord_date = @ComparedDate", conn)<br />
cmd.Parameters.Add(new SqlParameter("@ComparedDate", SqlDataType.DateTime)).Value=Convert.ToDateTime("14/09/1994")<br />
Dim reader as SqlDataReader=cmd.ExecuteReader()<br />
...<br />

Dayekh wrote:

I used the following query for application on a DropDownList:

forename field + ', ' + surname field  as fullname<br />
<br />
DropDownList1.DataTextField = "fullname";

select ........ forename + ', ' + surname as fullname<br />
<br />
DropDownList1.DataTextField = "fullname";

CREATE PROC uspInsertWebContentLocalized
(
  @contentName varchar(n),
  @contentPage varchar(n),
  @contentCulture varchar(n),
  @contentHtml varchar(n)
)
AS
INSERT INTO web_Content ( ContentName, ContentPage )
VALUES ( @contentName, @contentPage )

INSERT INTO web_ContentLocalized 
  ( ContentId, ContentCulture, ContentHtml )
VALUES
  ( SCOPE_IDENTITY(), @contentCulture, @contentHtml )