private void UpdateData(string target)
{
using (var sqlConnection = new SqlConnection(ConString))
{
var dataSet = new DataSet();
var sqlDataAdapter = new SqlDataAdapter();
var sqlCommand = sqlConnection.CreateCommand();
if (target != "")
{
sqlCommand.CommandText = "SELECT * FROM UserBasicInfo WHERE Name LIKE '%" + target + "%'";
}
else
{
sqlCommand.CommandText = "SELECT * FROM UserBasicInfo";
}
sqlDataAdapter.SelectCommand = sqlCommand;
sqlConnection.Open();
sqlDataAdapter.Fill(dataSet);
GridViewMain.DataSource = dataSet;
GridViewMain.DataBind();
// GridView propertyData = (GridView)(GridView1.Rows[parent_index].FindControl("ChildGridView"));
}
}
public void GetStatistics()
{
InitSettings();
TestSessionStatistics[] result = LocalUser.TestClient.GetStatistics((DateTime)ViewState["StartTime"], (DateTime)ViewState["EndTime"],
int.Parse((string)ViewState["SelectedGroup"]), int.Parse((string)ViewState["SelectedTest"]),
(int)ViewState["SelectedUser"]);
result = StatisticsHelper.SortStatistics(result, ViewState["SortExpression"], ViewState["SortDirection"]);
_statistics.Clear();
_statistics.AddRange(result);
GridViewMain.DataSource = _statistics;
GridViewMain.DataBind();
selectedDate.Text = String.Format("{0} – {1}", CalendarStart.SelectedDate.ToString("dd MMMM yyyy"), CalendarEnd.SelectedDate.ToString("dd MMMM yyyy"));
selectedUser.Text = (int)ViewState["SelectedUser"] == 0 ? "не выбран" : (string)ViewState["sUser"];
if ((string)ViewState["SelectedTest"] == "0")
{
selectedTest.Text = "не выбран";
phSelTestDetails.Visible = false;
}
else
{
selectedTest.Text = (string)ViewState["sTest"];
phSelTestDetails.Visible = true;
selTestDetails.NavigateUrl = String.Format("~/Manage/TestStatistics.aspx?testId={0}&groupId={1}",
ViewState["SelectedTest"], ViewState["SelectedGroup"]);
}
selectedGroup.Text = (string)ViewState["SelectedGroup"] == "0" ? "не выбрана" : (string)ViewState["sGroup"];
InitPringUrl();
}
private void TestBuilder()
{
using (var sqlConnection = new SqlConnection(ConString))
{
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlDataAdapter.SelectCommand =
new SqlCommand(
"SELECT * FROM UserBasicInfo WHERE Gender = '女'",
sqlConnection);
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);
DataSet dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet, "UserBasicInfo");
// 添加数据
DataTable dataTable = dataSet.Tables["USerBasicInfo"];
DataRow dataRow = dataTable.NewRow();
dataRow["ID"] = "Ezio";
dataRow["Name"] = "Ezio Auditore";
dataTable.Rows.Add(dataRow);
Response.Write("<script>alert('COMMAND: " + sqlCommandBuilder.GetInsertCommand().CommandText + "')</script>");
sqlDataAdapter.Update(dataSet, "UserBasicInfo");
GridViewMain.DataSource = dataSet.Tables["UserBasicInfo"];
GridViewMain.DataBind();
}
}
public void GetHtmlStatistics()
{
try
{
if (_scoreType == ScoreType.Percent)
{
GridViewMain.Columns[11].Visible = true;
GridViewMain.Columns[10].Visible = false;
GridViewMain.Columns[8].Visible = false;
}
else if (_scoreType == ScoreType.Mark)
{
GridViewMain.Columns[12].Visible = true;
GridViewMain.Columns[10].Visible = false;
GridViewMain.Columns[9].Visible = false;
GridViewMain.Columns[8].Visible = false;
GridViewMain.Columns[7].Visible = false;
}
GridViewMain.DataSource = StatisticsHelper.GetStatistics(_scoreType, _score, _five, _four, _three);
GridViewMain.DataBind();
}
catch
{
Response.Redirect("~/Default.aspx");
}
}
/*
* Select all the column names for the selected table
*/
protected void ListBoxTables_SelectedIndexChanged(object sender, EventArgs e)
{
// Sets the array count variable makes sure index is not -1.
if (ListBoxTables.SelectedIndex >= 0)
{
// clear current query
GridViewData.DataSource = null;
GridViewData.DataBind();
// list selected table: to be removed
//Label1.Text = ListBoxTables.SelectedItem.ToString();
string sQueryText = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" +
ListBoxTables.SelectedItem.ToString() + "'ORDER BY ORDINAL_POSITION";
// execute query
SQLManager manager = new SQLManager(sSelectedDB);
DataTable objTable = new DataTable();
// handle errors
//if (manager.GetQueryResult(sQueryText) == null)
//{
// HandleQueryError();
// return;
//}
objTable.Load(manager.GetQueryResult(sQueryText));
GridViewMain.DataSource = objTable;
GridViewMain.DataBind();
manager.CloseConnection();
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("item"));
dt.Columns.Add(new DataColumn("cost"));
dt.Columns.Add(new DataColumn("person"));
string [] lines = File.ReadAllLines("thing.txt");
foreach (string line in lines)
{
string[] vals = line.Split(',');
DataRow dr = dt.NewRow();
dr["item"] = vals[0];
dr["cost"] = vals[1];
dr["person"] = vals[2];
dt.Rows.Add(dr);
}
GridViewMain.DataSource = dt;
GridViewMain.DataBind();
}
protected void ButtonNew_Click(object sender, EventArgs e)
{
DataRow dr = dt.NewRow();
dr["item"] = TextNewItem.Text;
dr["tobuy"] = "need";
dt.Rows.Add(dr);
GridViewMain.DataBind();
}
protected void GridView_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewMain.SetPageIndex(GridViewMain.SelectedIndex);
UpdateData(!IsPostBack ? "" : SearchTarget.Text.Trim());
}
protected void GridViewMain_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GetStatistics();
GridViewMain.PageIndex = e.NewPageIndex;
GridViewMain.DataBind();
}
