数据在页面里面执行完了，可是数据库里面查询不到页面插入的数据！！代码如下

Question

<?php
$title=$_POST['titlename'];
$source=$_POST['sourcename'];
$author=$_POST['authorname'];
$date=$_POST['datename'];
$content=$_POST['textarea'];
require("DB_connect.php");
mysql_select_db("sysp", $con);
mysql_query("set names gb2312");
$sql="INSERT INTO `sysp`.`zzjg` (
`zid` ,`ztitle` ,`zcontent` ,`zdate` ,`source` ,`author` ,
`lerder` ,`dleader` ,`members` ,`leadership` ,`respon` )VALUES (
NULL , '$title', '$content', '$date', '$source', '$author', NULL , NULL , NULL , NULL , NULL );)";
$result=mysql_query("$sql");
if(!$result){
echo "<script language='javascript'>";
echo "alert('$title'); location='addzzjg.php';";
echo "</script>";

}
else{
echo"$title";
echo "<script language='javascript'>";
echo "alert('123'); location='error.php';";
echo "</script>";
}
?>

Answer 1

private SqlConnection mycon;
private SqlConnection GetCon()
{
string strcon = "Server=服务器;Database=数据库名;Uid=用户名;Pwd=密码";
return new SqlConnection(strcon);
}
//查询
//返回的datatable你可以绑定到gridview ,girdlist 等等
public DataTable GetDataTable(string sqlstr)
{
mycon = GetCon();
mycon.Open();
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, mycon);
DataTable mydt = new DataTable();
myda.Fill(mydt);
mycon.Close();
return mydt;
}
//增加
//返回bool判断是否插入成功
public bool InsertValue(string sqlstr)
{
mycon = GetCon();
mycon.Open();
SqlCommand mycmd = new SqlCommand(sqlstr,mycon);
try
{
mycmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
mycon.Close();
}
}