נושא: פתרון לבעיית קידוד עברית +עבודה עם פרמטר

<%@ Page Language="C#" CodePage="65001"  AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" Debug="true" Culture="he-IL" %

meta content="text/html; charset=utf-8 " http-equiv="content-type"  /

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "UPdatePhoto1";


        cmd.Parameters.Add(new SqlParameter("@param2", SqlDbType.NVarChar));
        cmd.Parameters["@param2"].Direction = ParameterDirection.Input;
        cmd.Parameters["@param2"].Value = TextBoxdisHE1.Text;

USE [AMPMDB1]
GO
/****** Object:  Table [dbo].[PhotoPage]    Script Date: 09/02/2007 09:22:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PhotoPage](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [link] [nvarchar](max) NULL,
    [disHE] [nvarchar](max) NULL,    העמודה בעברית בה אנו משנים את הגדת ברירת המחדל
    [disEN] [nvarchar](max) NULL,
    [disFR] [nvarchar](max) NULL,
CONSTRAINT [PK_PhotoPage] PRIMARY KEY CLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE PhotoPage ALTER COLUMN disHE VarChar(max) COLLATE Hebrew_CS_AI

GO
SET ANSI_PADDING OFF

ALTER PROCEDURE [dbo].[UPdatePhoto1]
@param1 varchar(MAX),@param2 Nvarchar (max),@param3 varchar(MAX),@param4 varchar(MAX)



AS
INSERT INTO [PhotoPage] (link ,disHE,disEN ,disFR )
VALUES ( @param1 ,@param2,@param3 ,@param4)