fredag 31 juli 2009

Add Parameter in NavigateURL

NavigateUrl='<%# Eval("Id", "Details.aspx?id={0}") %>'

torsdag 16 juli 2009

Findcontrol in Datalist

For VB
CType(DataList1.Items(0).FindControl("myImageControl"), Image)

So go for
Dim myImageControl as Image = CType(DataList1.Items(0).FindControl("myImageControl"), Image)


So you can go through the datalist

måndag 13 juli 2009

Add Kurdish, Arabic values to SQL Server (asp.net)

So I created this stored procedure on SQL server that gets values from a Kurdish Sorani text (unicode) and inserts them into the datebase.

After some tests, the values wore inserted as ???????? instead of real کوردستان

Here is a simple solution

1. Change the fields in your table from varchar -> nvarchar, text -> ntext
2. Modify in properties for the column / Table designer / Collation -> Arabic
3. Add N next to all your SQL parameters as:

Exec spSendKurdishText "& intRandomNr & ", N'" & strKurdishString &"'

it looks like N'" or something but it is not, just add N to your parameter and since your parameter is string you obviously need '"