資源簡介
MySQL實用教程(第2版)[鄭阿奇][程序源代碼]

代碼片段和文件信息
using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?MySql.Data.MySqlClient;
using?System.IO;
namespace?xscj_sql
{
????public?partial?class?AddScore?:?System.Web.UI.Page
????{
????????string?stukch?=?null;
????????protected?void?Page_Load(object?sender?EventArgs?e)
????????{
????????????this.title?=?“學生成績添加“;
????????}
????????protected?void?GridView1_SelectedIndexChanged(object?sender?EventArgs?e)
????????{
????????????string?stucj?=?null;
????????????int?cj?=?0;
????????????string?select?=?((RadioButtonList)GridView1.SelectedRow.Cells[3].FindControl(“RadioButtonList1“)).Text;
????????????if?(select?==?“保存“)
????????????{
????????????????stucj?=?((TextBox)GridView1.SelectedRow.Cells[3].FindControl(“TextBox1“)).Text;
????????????????if?(stucj?==?string.Empty)
????????????????{
????????????????????Response.Write(“ript>alert(‘請輸入成績!‘) ript>“);
????????????????????return;
????????????????}
????????????????else
????????????????{
????????????????????cj?=?int.Parse(stucj);
????????????????????if?(cj?0?||?cj?>?160)
????????????????????{
????????????????????????Response.Write(“ript>alert(‘請輸入0到100之間的數‘) ript>“);
????????????????????????return;
????????????????????}
????????????????}
????????????}
????????????else
????????????{
????????????????stucj?=?“-1“;
????????????????cj?=?int.Parse(stucj);
????????????}
????????????string?stuxh?=?GridView1.SelectedRow.Cells[1].Text.Trim();
????????????string?kch?=?DropDownList2.SelectedValue;
????????????string?connStr?=?ConfigurationManager.ConnectionStrings[“xscjConnectionString“].ConnectionString;
????????????MySqlConnection?conn?=?new?MySqlConnection(connStr);
????????????try
????????????{
????????????????conn.Open();
????????????????string?sql?=?null;
????????????????MySqlCommand?mycommand?=?new?MySqlCommand();
????????????????mycommand.Connection?=?conn;
????????????????mycommand.CommandType?=?CommandType.StoredProcedure;
????????????????mycommand.CommandText?=?“CJ_Data“;
????????????????MySqlParameter?SqlStuXH?=?mycommand.Parameters.Add(“@in_xh“?SqlDbType.Char);
????????????????SqlStuXH.Direction?=?ParameterDirection.Input;
????????????????MySqlParameter?SqlStuKCH?=?mycommand.Parameters.Add(“@in_kch“?SqlDbType.Char);
????????????????SqlStuKCH.Direction?=?ParameterDirection.Input;
????????????????MySqlParameter?SqlStuCJ?=?mycommand.Parameters.Add(“@in_cj“?SqlDbType.Int);
????????????????SqlStuCJ.Direction?=?ParameterDirection.Input;
????????????????SqlStuXH.Value?=?stuxh;
????????????????SqlStuKCH.Value?=?kch;
????????????????SqlStuCJ.Value?=?cj;
????????????????mycommand.ExecuteReader();
????????????????if?(stucj?==?“-1“)
????????????????{
????????????????????Response.Write(“ript>alert(‘刪除成功!‘) ript>“);
????????????????}
????????????????else
????????????????{
???????????
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????4586??2013-11-11?11:31??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\AddScore.aspx
?????文件???????5540??2013-11-11?15:24??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\AddScore.aspx.cs
?????文件???????3284??2013-10-28?15:22??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\AddScore.aspx.designer.cs
?????文件??????15872??2013-11-11?15:24??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\bin\xscj_sql.dll
?????文件??????38400??2013-11-11?15:24??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\bin\xscj_sql.pdb
?????文件??????72415??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_01.gif
?????文件???????2116??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_02.gif
?????文件???????7316??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_03.gif
?????文件???????1351??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_04.gif
?????文件???????1333??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_05.gif
?????文件???????1145??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_06.gif
?????文件???????1476??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_07.gif
?????文件???????1388??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_08.gif
?????文件???????1442??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_09.gif
?????文件???????1234??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_10.gif
?????文件???????1398??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_11.gif
?????文件???????1347??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_12.gif
?????文件???????1167??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_13.gif
?????文件???????1159??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_14.gif
?????文件???????2461??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_15.gif
?????文件??????37825??2009-02-20?13:37??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\images\學生成績管理系統_16.gif
?????文件???????8862??2013-11-11?14:34??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\MasterPage.Master
?????文件????????338??2013-10-22?09:06??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\MasterPage.Master.cs
?????文件???????2948??2013-10-22?09:29??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\MasterPage.Master.designer.cs
?????文件??????10033??2013-11-11?15:24??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????7949??2013-10-23?15:30??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\obj\Debug\ResolveAssemblyReference.cache
?????文件????????601??2013-10-23?12:01??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\obj\Debug\xscj_sql.csproj.FileListAbsolute.txt
?????文件??????15872??2013-11-11?15:24??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\obj\Debug\xscj_sql.dll
?????文件??????38400??2013-11-11?15:24??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\obj\Debug\xscj_sql.pdb
?????文件???????1335??2013-10-22?09:04??實習源程序\實習:ASP.NET-MySQL\xscj_sql\xscj_sql\Properties\AssemblyInfo.cs
............此處省略352個文件信息
- 上一篇:20120702武魂服務端+登陸器
- 下一篇:struts2 做的用戶登陸注冊系統
評論
共有 條評論