عندما أحفظ في SQL Server أتفاجأ أن النص العربي يتم حفظه على صيغة ??? مع أنني حاولت مختلف الطرق.. وهذا هو الكود:
<%@ Page Language="C#" Debug="true" AutoEventWireup="true" Culture="ar-BH" UICulture="ar-BH" %>
<%@ Register TagPrefix="BAHRAIN" TagName="left_panel" Src="left_panel.ascx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if ((Session["admin_login_user"] == null) || (Session["admin_login_user"] == null) || (Session["admin_loggedOn"] == null))
{
// Response.Redirect("http://www.bahrainnow.net");
}
if (!Page.IsPostBack)
{
SqlConnection sql_connection = new SqlConnection("Server=xxx.xxx.xxx.xxx;User Id=bahrainnow;Password=xxxxx;Database=bahrainnow;");
sql_connection.Open();
// Create a command object for the quer;
SqlCommand sql_command = new SqlCommand("SELECT block_no, convert(char(5), block_no) + ' : ' + block_name_arabic AS block_name FROM blocks ORDER BY block_no", sql_connection);
SqlDataReader sql_reader = sql_command.ExecuteReader();
cboBlock_1.DataSource = sql_reader;
cboBlock_1.DataValueField = "block_no";
cboBlock_1.DataTextField = "block_name";
cboBlock_1.DataBind();
cboBlock_1.Items.Add("null");
cboBlock_1.Text = "null";
cboBlock_2.Items.Add("null");
cboBlock_3.Items.Add("null");
// cboBlock_2.DataSource = sql_reader;
// cboBlock_2.DataValueField = "block_no";
// cboBlock_2.DataTextField = "block_name";
// cboBlock_2.DataBind();
// cboBlock_2.Items.Add("null");
// cboBlock_2.Text = "null";
// cboBlock_3.DataSource = sql_reader_1;
// cboBlock_3.DataValueField = "block_no";
// cboBlock_3.DataTextField = "block_name";
// cboBlock_3.DataBind();
// cboBlock_3.Items.Add("null");
// cboBlock_3.Text = "null";
}
}
protected void btnView_Click(object sender, EventArgs e)
{
}
protected void btnSave_Click(object sender, EventArgs e)
{
// if ((calNewsDate.Value == null) || (cboNews_Minutes.Text == "null") || (cboNewsTime_Hour.Text == "null") || (txtNewsSource.Text == "null"))
// {
string record_guid = System.Guid.NewGuid().ToString();
DateTime news_date = calNewsDate.SelectedDate.AddHours(double.Parse(cboNewsTime_Hour.Text)).AddMinutes(double.Parse(cboNewsTime_Minutes.Text));
SqlConnection sql_connection = new SqlConnection("Persist Security Info=False;User ID=bahrainnow;Initial Catalog=bahrainnow;Data Source=xx.xxx.xxx.xxx;Password=xxxxx");
sql_connection.Open();
// SqlDataReader sql_reader;
// sql_reader = sql_command.ExecuteReader();
SqlCommand insert_command = new SqlCommand("INSERT INTO bahrainnow_news (news_guid, news_date_time, news_source, news_category_1, news_category_2, news_category_3, news_block_1, news_block_2, news_block_3, news_title, news_story, news_photo, created_user, created_ip) Values (@news_guid, @news_date_time, @news_source, @news_category_1, @news_category_2, @news_category_3, @news_block_1, @news_block_2, @news_block_3, @news_title, @news_story, @news_photo, @created_user, @created_ip)", sql_connection);
insert_command.Parameters.Add(new SqlParameter("@news_guid", record_guid));
insert_command.Parameters.Add(new SqlParameter("@news_date_time", news_date));
insert_command.Parameters.Add(new SqlParameter("@news_source", txtNewsSource.Text));
insert_command.Parameters.Add(new SqlParameter("@news_category_1", cboNewsCategory_1.Text));
insert_command.Parameters.Add(new SqlParameter("@news_category_2", cboNewsCategory_2.Text));
insert_command.Parameters.Add(new SqlParameter("@news_category_3", cboNewsCategory_3.Text));
insert_command.Parameters.Add(new SqlParameter("@news_block_1", cboBlock_1.Text));
insert_command.Parameters.Add(new SqlParameter("@news_block_2", cboBlock_2.Text));
insert_command.Parameters.Add(new SqlParameter("@news_block_3", cboBlock_3.Text));
insert_command.Parameters.Add(new SqlParameter("@news_title", txtNewsTitle.Text));
insert_command.Parameters.Add(new SqlParameter("@news_story", txtNewsStory.Text));
insert_command.Parameters.Add(new SqlParameter("@news_photo", txtNewsPhoto.Text));
insert_command.Parameters.Add(new SqlParameter("@created_user", "Jassim"));
insert_command.Parameters.Add(new SqlParameter("@created_ip", Request.UserHostAddress.ToString()));
// sql_reader.Close();
insert_command.ExecuteNonQuery();
// // sql_connection.Close();
// }
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<link rel="StyleSheet" type="text/css" href="../stylesheet_admin.css">
<title>BahrainNow.Net 4 admin</title>
</head>
<body bgcolor="#1a001a" dir="rtl" lang="ar-bh" topmargin="5" bottommargin="5" rightmargin="5" leftmargin="5">
<form id="bahrainnow_admin" runat="server">
<table align="right" dir="rtl" lang="ar-bh" width="970" border="0">
<tr><td><img src="../images/page_header.bmp" alt=""></td></tr>
<tr>
<td>
<table align="right" dir="rtl" lang="ar-bh" width="970" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="right" bgcolor="#FFFFFF" valign="top" style="padding: 8px">
<table align="right" dir="rtl" lang="ar-bh" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td align="right" style="padding: 8px">
<strong>إضافة خبر</strong><br><br><br><br>
<table align="right" dir="rtl" lang="ar-bh" cellpadding="0" cellspacing="0">
<tr>
<td align="right" valign="top">تاريخ الخبر</td>
<td align="center" valign="top" style="padding-left: 8px; padding-right: 8px">:</td>
<td align="right" valign="top"><asp:Calendar ID="calNewsDate" runat="server" Width="100" Height="100" FirstDayOfWeek="Sunday" ></asp:Calendar></td>
</tr>
<tr><td align="right" colspan="3"><br></td></tr>
<tr>
<td align="right" valign="top">توقيت الخبر</td>
<td align="center" valign="top" style="padding-left: 8px; padding-right: 8px">:</td>
<td align="right" valign="top">
<asp:DropDownList ID="cboNewsTime_Minutes" runat="server" CssClass="normal" Font-Names="Arial">
<!--#include file="time_minutes.inc"-->
</asp:DropDownList>
:
<asp:DropDownList ID="cboNewsTime_Hour" runat="server" CssClass="normal" Font-Names="Arial">
<!--#include file="time_hours.inc"-->
</asp:DropDownList>
</td>
</tr>
<tr><td align="right" colspan="3"><br></td></tr>
<tr>
<td align="right" valign="top">المصدر</td>
<td align="center" valign="top" style="padding-left: 8px; padding-right: 8px">:</td>
<td align="right" valign="top"><asp:TextBox ID="txtNewsSource" runat="server" TextMode="SingleLine" Text= "" Width="200" Font-Names="Tahoma"></asp:TextBox></td>
</tr>
<tr><td align="right" colspan="3"><br></td></tr>
<tr>
<td align="right" valign="top">عنوان الخبر</td>
<td align="center" valign="top" style="padding-left: 8px; padding-right: 8px">:</td>
<td align="right" valign="top"><asp:TextBox ID="txtNewsTitle" runat="server" TextMode="SingleLine" Text= "" Width="500" Font-Names="Tahoma"></asp:TextBox></td>
</tr>
<tr><td align="right" colspan="3"><br></td></tr>
<tr>
<td align="right" valign="top">تصنيف الخبر</td>
<td align="center" valign="top" style="padding-left: 8px; padding-right: 8px">:</td>
<td align="right" valign="top">
<asp:DropDownList ID="cboNewsCategory_1" runat="server" CssClass="normal" Font-Names="Tahoma">
<!--#include file="news_category.inc"-->
</asp:DropDownList>
-
<asp:DropDownList ID="cboNewsCategory_2" runat="server" CssClass="normal" Font-Names="Tahoma">
<!--#include file="news_category.inc"-->
</asp:DropDownList>
-
<asp:DropDownList ID="cboNewsCategory_3" runat="server" CssClass="normal" Font-Names="Tahoma">
<!--#include file="news_category.inc"-->
</asp:DropDownList>
</td>
</tr>
<tr><td align="right" colspan="3"><br></td></tr>
<tr>
<td align="right" valign="top">المجمع</td>
<td align="center" valign="top" style="padding-left: 8px; padding-right: 8px">:</td>
<td align="right" valign="top">
<asp:DropDownList ID="cboBlock_1" runat="server" CssClass="normal" Font-Names="Tahoma"></asp:DropDownList>
-
<asp:DropDownList ID="cboBlock_2" runat="server" CssClass="normal" Font-Names="Tahoma"></asp:DropDownList>
-
<asp:DropDownList ID="cboBlock_3" runat="server" CssClass="normal" Font-Names="Tahoma"></asp:DropDownList>
</td>
</tr>
<tr><td align="right" colspan="3"><br></td></tr>
<tr>
<td align="right" valign="top">نص الخبر</td>
<td align="center" valign="top" style="padding-left: 8px; padding-right: 8px">:</td>
<td align="right" valign="top"><asp:TextBox ID="txtNewsStory" runat="server" TextMode="MultiLine" Text= "" Width="500" Height="400" Font-Names="Tahoma"></asp:TextBox></td>
</tr>
<tr><td align="right" colspan="3"><br></td></tr>
<tr>
<td align="right" valign="top">ملف الصورة</td>
<td align="center" valign="top" style="padding-left: 8px; padding-right: 8px">:</td>
<td align="right" valign="top"><asp:TextBox ID="txtNewsPhoto" runat="server" TextMode="SingleLine" Text= "" Font-Names="Arial" Width="350"></asp:TextBox> <asp:Button runat="server" id="btnView" Text=" عرض الصورة " Font-Names="Tahoma" OnClick="btnView_Click" /></td>
</tr>
<tr><td align="right" colspan="3"><br><br><br></td></tr>
<tr><td align="center" colspan="3"><asp:Button runat="server" id="btnSave" Text=" حفظ الخبر " Font-Names="Tahoma" OnClick="btnSave_Click" /></td></tr>
<tr><td align="right" colspan="3"><br><br><br></td></tr>
</table>
</td>
</tr>
</table>
</td>
<td align="center" bgcolor="#FFFF99" valign="top" width="200" style="padding: 8px"><BAHRAIN:left_panel ID="left_panel" runat="server" /></td>
</tr>
</table>
</td>
</table>
</form>
</body>
</html>