条件:1个Form窗体,1个dataGrid控件(dataGrid1),2个命令按钮(button1和button2)。(全用默认名)
连接的数据库:本机的SQL2000自带数据库:数据库名:Northwind,表名:Customers,用户名:sa,空密码。
大家的机器上要是有sql的话,应该都有这个表。要求:
1)命令按钮(button1)单击事件:在dataGrid1中显示表中所有信息。
2)在dataGrid1中添加一条记录。单击button2,则更新到数据库中,同时更新dataGrid1中显示的数据。
3)所有功能要用代码实现。不能用系统提供的SqlConnection控件。要用using System.Data.SqlClient;
这样的代码实现。
4)把你的代码贴上来,我直接copy就能使用才行。不能再设置什么。达到要求者,会再发一100分贴给分。
连接的数据库:本机的SQL2000自带数据库:数据库名:Northwind,表名:Customers,用户名:sa,空密码。
大家的机器上要是有sql的话,应该都有这个表。要求:
1)命令按钮(button1)单击事件:在dataGrid1中显示表中所有信息。
2)在dataGrid1中添加一条记录。单击button2,则更新到数据库中,同时更新dataGrid1中显示的数据。
3)所有功能要用代码实现。不能用系统提供的SqlConnection控件。要用using System.Data.SqlClient;
这样的代码实现。
4)把你的代码贴上来,我直接copy就能使用才行。不能再设置什么。达到要求者,会再发一100分贴给分。
解决方案 »
- 请问这个LINQ查询怎么写
- 对于object类型,其实际类型可能是Single、Decimal、Double三种,如何将object转为保留2位小数的字符串。
- 求助:wml转html的问题
- 关于正则表达式负声明的一个问题
- 若不打开snmp协议,能通过snmp取得信息吗
- 如何让C#中类的成员变量按照定义的顺序出现,而并非默认的字母顺序。
- 建虚拟目录,选择另一计算机上的共享位置,建完了出错,怎么解决?
- 求助---取信息问题
- 用Timer控件把系统时间显示在TEXTBOA控件中,请大家帮我写写这个代码
- 即时消息,如何维护客户端的状态
- 控件拉伸问题
- 输出字节缓存区太小,无法包含编码后的数据,请高手帮忙
不要用他啦!用lgxgrid控件更好.
参见http://lgxyslldw.512j.com
*******()
{
//////
}
自已到google搜索"C# 数据库操作类"里面下载一个,或者找一个代码生成工具,一般都会集成这个操作类,贴代码就太长了,其它的几步MSDN里面都有现成的例子,稍改一下就行
这样的代码实现。
4 )把你的代码贴上来,我直接copy就能使用才行。不能再设置什么。
恩...
哦 ....
哎......
哈.......
conn.Open();
..
conn.Close
string connectstring = "Data Source=127.0.0.1;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";
private void button1_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectstring);
string sql = "select * from Customers";
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
adapter.Fill(ds);
this.dataGrid1.DataSource = ds.Tables[0];
} private void button1_Click(object sender, EventArgs e)
{
using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectstring))
{
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select * from Customers", connection);
System.Data.SqlClient.SqlCommandBuilder builder = new System.Data.SqlClient.SqlCommandBuilder(adapter); connection.Open();
adapter.Update(ds, tableName);
}
}随手给你敲了一段,更新的,自己去查吧,如果有错误,自己去改一改吧
string connectstring = "Data Source=127.0.0.1;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";
private void button1_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectstring);
string sql = "select * from Customers";
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
adapter.Fill(ds);
this.dataGrid1.DataSource = ds.Tables[0];
} private void button2_Click(object sender, EventArgs e)
{
using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectstring))
{
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select * from Customers", connection);
System.Data.SqlClient.SqlCommandBuilder builder = new System.Data.SqlClient.SqlCommandBuilder(adapter); connection.Open();
adapter.Update(ds, tableName);
}
}随手敲的,有错误改一下吧
下面这个是连接Sqlserver的模块,lz看看吧
http://www.host01.com/article/Net/00020005/0561515445216232.htm
static string ConStr = "server=192.168.6.20;user id=sa;pwd=;database=WIT";
SqlConnection con = new SqlConnection(ConStr);//点连接BUTTON
con.Open();
string SqlStr = "select * from wit_flow";
SqlDataAdapter ada = new SqlDataAdapter(SqlStr, con);
DataSet ds = new DataSet();
ada.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView; // 显示数据
//添加数据BUTTON
string strInsert = " INSERT INTO wit_flow (flow,flow_sgm,bip,bip_sgm) VALUES ('" + 1 + "','" + 2 + "','" + 3 + "','" + 4 + "')"; SqlCommand ist = new SqlCommand(strInsert, con);
ist.ExecuteNonQuery();//添加
using System.Data.SqlClient;
//........省略无关代码
//实例化Connection对象
SqlConnection connection = new SqlConnection("Data Source=(local);Initial Catalog=AspNetStudy;Persist Security Info=True;User ID=sa;Password=sa");
//实例化Command对象
string sql = "select top 5 * from UserInfo order by UserID desc";
SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
DataTable data = new DataTable();
adapter.Fill(data); FormView1.DataSource = data;
FormView1.PageIndex = pageIndex;
FormView1.DataBind();
System.Data.SqlClient.SqlConnection conn = null;
System.Data.SqlClient.SqlDataAdapter da = null;private void button1_Click(object sender, System.EventArgs e)
{//保存
if(dt!=null)
{
System.Data.SqlClient.SqlCommandBuilder cb = new System.Data.SqlClient.SqlCommandBuilder(this.da);
da.Update(dt);
}
} private void Form1_Load(object sender, System.EventArgs e)
{//填充数据
dt = new DataTable();
conn = new System.Data.SqlClient.SqlConnection("server=.;uid=sa;pwd=;database=pubs");
da = new System.Data.SqlClient.SqlDataAdapter();
da.SelectCommand = new System.Data.SqlClient.SqlCommand("select * from authors",this.conn);
da.Fill(dt);
this.dataGrid1.DataSource = dt.DefaultView;
}
{
if (!IsPostBack)
{
this.DataBindToDataList();
}
}
private void DataBindToDataList()
{
SqlConnection con = DB.CreateConnection();
con.Open();
SqlDataAdapter mydataAdapter = new SqlDataAdapter("select*from person", con);
DataSet DS = new DataSet();
mydataAdapter.Fill(DS, "emp");
this.DataList1.DataKeyField = "pID";
this.DataList1.DataSource=DS.Tables["emp"];
this.DataList1.DataBind();
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName=="Select")
{
this.DataList1.SelectedIndex = e.Item.ItemIndex;
this.DataBindToDataList();
}
}
protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
{
this.DataList1.EditItemIndex = e.Item.ItemIndex;
this.DataBindToDataList();
}
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
string pid = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
string address = ((TextBox)e.Item.FindControl("TxtCity")).Text;
SqlConnection con = DB.CreateConnection();
SqlCommand mycommand = new SqlCommand("update person SET Address='"+address+"' where pID='"+pid+"'",con);
con.Open();
mycommand.ExecuteNonQuery();
this.DataList1.EditItemIndex = -1;
this.DataBindToDataList();
}
protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
{ this.DataList1.EditItemIndex = -1;
this.DataBindToDataList();
}
string connectstring = "Data Source=127.0.0.1;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";
System.Data.SqlClient.SqlConnection connection;
System.Data.SqlClient.SqlDataAdapter adapter;
string sql;
DataSet ds; private void Form1_Load(object sender, EventArgs e)
{
connection = new System.Data.SqlClient.SqlConnection(connectstring);
sql = "select * from Customers";
adapter = new System.Data.SqlClient.SqlDataAdapter(sql, connection);
ds = new DataSet();
} private void button1_Click(object sender, EventArgs e)
{
ds.Clear();
adapter.Fill(ds, "Customers");
this.dataGrid1.DataSource = ds.Tables[0];
} private void button2_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlCommandBuilder builder = new System.Data.SqlClient.SqlCommandBuilder(adapter);
adapter.Update(ds, "customers"); }
private void button1_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectstring);
string sql = "select * from Customers";
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
adapter.Fill(ds);
this.dataGrid1.DataSource = ds.Tables[0];
} private void button2_Click(object sender, EventArgs e)
{
using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectstring))
{
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select * from Customers", connection);
System.Data.SqlClient.SqlCommandBuilder builder = new System.Data.SqlClient.SqlCommandBuilder(adapter); connection.Open();
adapter.Update(ds, tableName);
}
}
Declaration : Operation Ms-Sql database
Author : dmh [Du minghua]
Create Date : 2008-08-01 13:21
Modify Date :
Res : */
using System;
using System.Data;
using System.Configuration;namespace CMS
{
//namespace begin
public class DataBaseConn
{
private string linkString = "";
private System.Data.SqlClient.SqlConnection conn;
private System.Data.SqlClient.SqlCommand cmd;
private System.Data.DataSet ds;
public void open()
{
try
{
linkString = "user id=sa;password=dmhlzl;Data Source=localhost;Initial Catalog=nbxx";
conn=new System.Data.SqlClient.SqlConnection(linkString);
conn.Open();
}
catch (Exception e1)
{
throw new Exception("Database connect open failure:"+e1.Message.ToString());
}
}
public void close()
{
try
{
conn.Close();
conn.Dispose();
}
catch (Exception e1)
{
throw new Exception("Database connect close failure:"+e1.Message.ToString());
}
finally
{
conn = null;
}
}
//Return query rows(To Insert,Delete,Update)
public int ExecuteNonQuery(string strSql)
{
int ret = 0;
cmd = conn.CreateCommand();
cmd.CommandText = strSql;
cmd.CommandType = CommandType.Text;
try
{
ret = cmd.ExecuteNonQuery();
}
catch (Exception ee)
{
throw new Exception("SQL:" + strSql + "<br />" + ee.Message.ToString());
}
finally
{
cmd.Cancel();
}
return ret;
}
//Read by id information
public DataSet CommReadByID(string strSql)
{
ds = GetDataSet(strSql);
return ds;
}
//Return record count result
public int GetRecordCount(string keyField, string tableName, string condition)
{
int RecordCount = 0;
string sql = "select count(" + keyField + ") as count from " + tableName + " " + condition;
System.Data.DataSet ds = GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
ds.Clear();
ds.Dispose();
return RecordCount;
}
//Return record maxid result
public int GetRecordMax(string keyField, string tableName, string condition)
{
int RecordMax = 0;
string sql = "select "+ keyField +" from "+ tableName +" where "+keyField+" in (select max(" + keyField + ") from " + tableName+")";
System.Data.DataSet ds = GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
RecordMax = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
ds.Clear();
ds.Dispose();
return RecordMax;
}
//Return recordset
public DataSet GetDataSet(string strSql)
{
System.Data.DataSet ds = new DataSet();
try
{
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(strSql,conn);
da.Fill(ds);
da.Dispose();
}
catch (Exception ee)
{
throw new Exception("SQL:" + strSql + "<br />" + ee.Message.ToString());
}
return ds;
}
}
//namespace end
}*******************************代码完******************************************************DataSet ds = new DataSet();
ds = conn.GetDataSet(sql);绑定到ds,然后自己在前台调用就行了。
给你一大堆代码.不用看了,改改一些注释就直接交给老师得了.
[code=C#]
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;namespace LgxGrid示例
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class cs : System.Windows.Forms.Form
{
ADODB.Connection mysjk=new ADODB.ConnectionClass();
bool chok;
//定义全局数据库对象
private AxLgxgridV10.Axlgxgrid axlgxgrid1;
private System.Windows.Forms.ContextMenu contextMenu1;
private System.Windows.Forms.MenuItem menuItem2;
private System.Windows.Forms.MenuItem menuItem3;
private System.Windows.Forms.MenuItem menuItem4;
private System.Windows.Forms.MenuItem menuItem5;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.MenuItem menuItem6;
private System.Windows.Forms.MenuItem menuItem7;
private System.Windows.Forms.MenuItem menuItem8;
private System.Windows.Forms.MenuItem menuItem9;
private System.Windows.Forms.MenuItem menuItem10;
private System.Windows.Forms.MenuItem menuItem11;
private System.Windows.Forms.MenuItem menuItem12;
private System.Windows.Forms.MenuItem menuItem13;
private System.Windows.Forms.MenuItem menuItem14;
private System.Windows.Forms.MenuItem menuItem15;
private System.Windows.Forms.MenuItem menuItem16;
private System.Windows.Forms.MenuItem menuItem17;
private System.Windows.Forms.MenuItem menuItem18;
private System.Windows.Forms.MenuItem menuItem19;
private System.Windows.Forms.MenuItem menuItem20;
private System.Windows.Forms.MenuItem menuItem21;
private System.Windows.Forms.MenuItem menuItem23;
private System.Windows.Forms.MenuItem menuItem24;
private System.Windows.Forms.MenuItem menuItem25;
private System.Windows.Forms.MenuItem menuItem26;
private System.Windows.Forms.MenuItem menuItem27;
private System.Windows.Forms.MenuItem menuItem28;
private System.Windows.Forms.MenuItem menuItem29;
private System.Windows.Forms.MenuItem menuItem30;
private System.Windows.Forms.MenuItem menuItem31;
private System.Windows.Forms.MenuItem menuItem32;
private System.Windows.Forms.MenuItem menuItem33;
private System.Windows.Forms.MenuItem menuItem34;
private System.Windows.Forms.MenuItem menuItem35;
private System.Windows.Forms.MenuItem menuItem36;
private System.Windows.Forms.MenuItem menuItem37;
private System.Windows.Forms.MenuItem menuItem38;
private System.Windows.Forms.MenuItem menuItem39;
private System.Windows.Forms.MenuItem menuItem40;
private System.Windows.Forms.MenuItem menuItem41;
private System.Windows.Forms.TextBox textBox1;
private System.Timers.Timer timer1;
private System.Windows.Forms.CheckBox checkBox1;
private System.Windows.Forms.MenuItem menuItem42;
private System.Windows.Forms.MenuItem menuItem43;
private System.Windows.Forms.MenuItem menuItem45;
private System.Windows.Forms.MenuItem menuItem46;
private System.Windows.Forms.MenuItem menuItem47;
private System.Windows.Forms.MenuItem menuItem48;
private System.Windows.Forms.MenuItem menuItem49;
private System.Windows.Forms.MenuItem menuItem50;
private System.Windows.Forms.MenuItem menuItem51;
private System.Windows.Forms.MenuItem menuItem52;
private System.Windows.Forms.MenuItem menuItem22;
private System.Windows.Forms.MenuItem menuItem44;
private System.Windows.Forms.MenuItem menuItem53;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.MenuItem menuItem54;
private System.Windows.Forms.MenuItem menuItem55;
private System.Windows.Forms.MenuItem menuItem56;
private System.Windows.Forms.MenuItem menuItem57;
private System.Windows.Forms.MenuItem menuItem58;
private System.Windows.Forms.MenuItem menuItem59;
private System.Windows.Forms.MenuItem menuItem60;
private System.Windows.Forms.MenuItem menuItem61;
private System.Windows.Forms.MenuItem menuItem62;
private System.Windows.Forms.MenuItem menuItem63;
private AxLgxgridV10.Axlgxgrid axlgxgrid2;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.MenuItem menuItem64;
private System.Windows.Forms.MenuItem menuItem65;
private System.Windows.Forms.MenuItem menuItem66;
private System.ComponentModel.IContainer components;
[code]
public cs()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码//
} /// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(cs));
this.contextMenu1 = new System.Windows.Forms.ContextMenu();
this.menuItem2 = new System.Windows.Forms.MenuItem();
this.menuItem3 = new System.Windows.Forms.MenuItem();
this.menuItem7 = new System.Windows.Forms.MenuItem();
this.menuItem8 = new System.Windows.Forms.MenuItem();
this.menuItem9 = new System.Windows.Forms.MenuItem();
this.menuItem10 = new System.Windows.Forms.MenuItem();
this.menuItem12 = new System.Windows.Forms.MenuItem();
this.menuItem4 = new System.Windows.Forms.MenuItem();
this.menuItem19 = new System.Windows.Forms.MenuItem();
this.menuItem58 = new System.Windows.Forms.MenuItem();
this.menuItem59 = new System.Windows.Forms.MenuItem();
this.menuItem20 = new System.Windows.Forms.MenuItem();
this.menuItem5 = new System.Windows.Forms.MenuItem();
this.menuItem18 = new System.Windows.Forms.MenuItem();
this.menuItem13 = new System.Windows.Forms.MenuItem();
this.menuItem14 = new System.Windows.Forms.MenuItem();
this.menuItem15 = new System.Windows.Forms.MenuItem();
this.menuItem16 = new System.Windows.Forms.MenuItem();
this.menuItem21 = new System.Windows.Forms.MenuItem();
this.menuItem17 = new System.Windows.Forms.MenuItem();
this.menuItem42 = new System.Windows.Forms.MenuItem();
this.menuItem1 = new System.Windows.Forms.MenuItem();
this.menuItem23 = new System.Windows.Forms.MenuItem();
this.menuItem31 = new System.Windows.Forms.MenuItem();
this.menuItem25 = new System.Windows.Forms.MenuItem();
this.menuItem28 = new System.Windows.Forms.MenuItem();
this.menuItem22 = new System.Windows.Forms.MenuItem();
this.menuItem64 = new System.Windows.Forms.MenuItem();
this.menuItem65 = new System.Windows.Forms.MenuItem();
this.menuItem40 = new System.Windows.Forms.MenuItem();
this.menuItem38 = new System.Windows.Forms.MenuItem();
this.menuItem39 = new System.Windows.Forms.MenuItem();
this.menuItem24 = new System.Windows.Forms.MenuItem();
this.menuItem6 = new System.Windows.Forms.MenuItem();
this.menuItem11 = new System.Windows.Forms.MenuItem();
this.menuItem63 = new System.Windows.Forms.MenuItem();
this.menuItem29 = new System.Windows.Forms.MenuItem();
this.menuItem54 = new System.Windows.Forms.MenuItem();
this.menuItem55 = new System.Windows.Forms.MenuItem();
this.menuItem56 = new System.Windows.Forms.MenuItem();
this.menuItem57 = new System.Windows.Forms.MenuItem();
this.menuItem30 = new System.Windows.Forms.MenuItem();
this.menuItem43 = new System.Windows.Forms.MenuItem();
this.menuItem45 = new System.Windows.Forms.MenuItem();
this.menuItem50 = new System.Windows.Forms.MenuItem();
this.menuItem51 = new System.Windows.Forms.MenuItem();
this.menuItem52 = new System.Windows.Forms.MenuItem();
this.menuItem44 = new System.Windows.Forms.MenuItem();
this.menuItem53 = new System.Windows.Forms.MenuItem();
this.menuItem26 = new System.Windows.Forms.MenuItem();
this.menuItem32 = new System.Windows.Forms.MenuItem();
this.menuItem34 = new System.Windows.Forms.MenuItem();
this.menuItem37 = new System.Windows.Forms.MenuItem();
this.menuItem46 = new System.Windows.Forms.MenuItem();
this.menuItem48 = new System.Windows.Forms.MenuItem();
this.menuItem35 = new System.Windows.Forms.MenuItem();
this.menuItem36 = new System.Windows.Forms.MenuItem();
this.menuItem47 = new System.Windows.Forms.MenuItem();
this.menuItem49 = new System.Windows.Forms.MenuItem();
this.menuItem33 = new System.Windows.Forms.MenuItem();
this.menuItem27 = new System.Windows.Forms.MenuItem();
this.menuItem41 = new System.Windows.Forms.MenuItem();
this.menuItem62 = new System.Windows.Forms.MenuItem();
this.menuItem60 = new System.Windows.Forms.MenuItem();
this.menuItem61 = new System.Windows.Forms.MenuItem();
this.textBox1 = new System.Windows.Forms.TextBox();
this.timer1 = new System.Timers.Timer();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.axlgxgrid1 = new AxLgxgridV10.Axlgxgrid();
this.button1 = new System.Windows.Forms.Button();
this.axlgxgrid2 = new AxLgxgridV10.Axlgxgrid();
this.label1 = new System.Windows.Forms.Label();
this.menuItem66 = new System.Windows.Forms.MenuItem();
((System.ComponentModel.ISupportInitialize)(this.timer1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.axlgxgrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.axlgxgrid2)).BeginInit();
this.SuspendLayout();
//
// contextMenu1
//
this.contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem2,
this.menuItem1,
this.menuItem60});
this.contextMenu1.Popup += new System.EventHandler(this.contextMenu1_Popup);
//
// menuItem2
//
this.menuItem2.Index = 0;
this.menuItem2.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem3,
this.menuItem7,
this.menuItem8,
this.menuItem9,
this.menuItem10,
this.menuItem12,
this.menuItem4,
this.menuItem19,
this.menuItem58,
this.menuItem59,
this.menuItem20,
this.menuItem5,
this.menuItem18,
this.menuItem13,
this.menuItem14,
this.menuItem15,
this.menuItem16,
this.menuItem21,
this.menuItem17,
this.menuItem42});
//
// menuItem3
//
this.menuItem3.Index = 0;
this.menuItem3.Text = "Backcolor";
this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
//
// menuItem7
//
this.menuItem7.Index = 1;
this.menuItem7.Text = "hBackColor";
this.menuItem7.Click += new System.EventHandler(this.menuItem7_Click);
//
// menuItem8
//
this.menuItem8.Index = 2;
this.menuItem8.Text = "ForeColor";
this.menuItem8.Click += new System.EventHandler(this.menuItem8_Click);
//
// menuItem9
//
this.menuItem9.Index = 3;
this.menuItem9.Text = "hForeColor";
this.menuItem9.Click += new System.EventHandler(this.menuItem9_Click);
//
// menuItem10
//
this.menuItem10.Index = 4;
this.menuItem10.Text = "LineColor";
this.menuItem10.Click += new System.EventHandler(this.menuItem10_Click);
//
// menuItem12
//
this.menuItem12.Index = 5;
this.menuItem12.Text = "-";
//
// menuItem4
//
this.menuItem4.Index = 6;
this.menuItem4.Text = "CloseAdd";
this.menuItem4.Click += new System.EventHandler(this.menuItem4_Click);
//
// menuItem19
//
this.menuItem19.Index = 7;
this.menuItem19.Text = "SlowOk";
this.menuItem19.Click += new System.EventHandler(this.menuItem19_Click);
//
// menuItem58
//
this.menuItem58.Index = 8;
this.menuItem58.Text = "RowsMode";
this.menuItem58.Click += new System.EventHandler(this.menuItem58_Click);
//
// menuItem59
//
this.menuItem59.Index = 9;
this.menuItem59.Text = "EditAspect";
this.menuItem59.Click += new System.EventHandler(this.menuItem59_Click);
//
// menuItem20
//
this.menuItem20.Index = 10;
this.menuItem20.Text = "-";
//
// menuItem5
//
this.menuItem5.Index = 11;
this.menuItem5.Text = "Lists";
this.menuItem5.Click += new System.EventHandler(this.menuItem5_Click);
//
// menuItem18
//
this.menuItem18.Index = 12;
this.menuItem18.Text = "Rows";
this.menuItem18.Click += new System.EventHandler(this.menuItem18_Click);
//
// menuItem13
//
this.menuItem13.Index = 13;
this.menuItem13.Text = "Nlist";
this.menuItem13.Click += new System.EventHandler(this.menuItem13_Click);
//
// menuItem14
//
this.menuItem14.Index = 14;
this.menuItem14.Text = "NlistEnd";
this.menuItem14.Click += new System.EventHandler(this.menuItem14_Click);
//
// menuItem15
//
this.menuItem15.Index = 15;
this.menuItem15.Text = "Nrow";
this.menuItem15.Click += new System.EventHandler(this.menuItem15_Click);
//
// menuItem16
//
this.menuItem16.Index = 16;
this.menuItem16.Text = "NrowEnd";
this.menuItem16.Click += new System.EventHandler(this.menuItem16_Click);
//
// menuItem21
//
this.menuItem21.Index = 17;
this.menuItem21.Text = "-";
//
// menuItem17
//
this.menuItem17.Index = 18;
this.menuItem17.Text = "RowHeight";
this.menuItem17.Click += new System.EventHandler(this.menuItem17_Click);
//
// menuItem42
//
this.menuItem42.Index = 19;
this.menuItem42.Text = "AutoEdit";
this.menuItem42.Click += new System.EventHandler(this.menuItem42_Click);
//
// menuItem1
//
this.menuItem1.Index = 1;
this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem23,
this.menuItem31,
this.menuItem25,
this.menuItem28,
this.menuItem22,
this.menuItem66,
this.menuItem64,
this.menuItem65,
this.menuItem40,
this.menuItem38,
this.menuItem39,
this.menuItem24,
this.menuItem6,
this.menuItem11,
this.menuItem63,
this.menuItem29,
this.menuItem54,
this.menuItem55,
this.menuItem56,
this.menuItem57,
this.menuItem30,
this.menuItem43,
this.menuItem45,
this.menuItem50,
this.menuItem51,
this.menuItem52,
this.menuItem44,
this.menuItem53,
this.menuItem26,
this.menuItem32,
this.menuItem34,
this.menuItem37,
this.menuItem46,
this.menuItem48,
this.menuItem35,
this.menuItem36,
this.menuItem47,
this.menuItem49,
this.menuItem33,
this.menuItem27,
this.menuItem41,
this.menuItem62});
//
// menuItem23
//
this.menuItem23.Index = 0;
this.menuItem23.Text = "获得数据";
this.menuItem23.Click += new System.EventHandler(this.menuItem23_Click);
//
// menuItem31
//
this.menuItem31.Index = 1;
this.menuItem31.Text = "数据排序";
this.menuItem31.Click += new System.EventHandler(this.menuItem31_Click);
//
// menuItem25
//
this.menuItem25.Index = 2;
this.menuItem25.Text = "清除选定数据";
this.menuItem25.Click += new System.EventHandler(this.menuItem25_Click);
//
// menuItem28
//
this.menuItem28.Index = 3;
this.menuItem28.Text = "清除所有数据";
this.menuItem28.Click += new System.EventHandler(this.menuItem28_Click);
//
// menuItem22
//
this.menuItem22.Index = 4;
this.menuItem22.Text = "添加30000行";
this.menuItem22.Click += new System.EventHandler(this.menuItem22_Click);
//
// menuItem64
//
this.menuItem64.Index = 6;
this.menuItem64.Text = "复制公式";
this.menuItem64.Click += new System.EventHandler(this.menuItem64_Click);
//
// menuItem65
//
this.menuItem65.Index = 7;
this.menuItem65.Text = "粘贴公式";
this.menuItem65.Click += new System.EventHandler(this.menuItem65_Click);
//
// menuItem40
//
this.menuItem40.Index = 8;
this.menuItem40.Text = "-";
//
// menuItem38
//
this.menuItem38.Index = 9;
this.menuItem38.Text = "复制";
this.menuItem38.Click += new System.EventHandler(this.menuItem38_Click);
//
// menuItem39
//
this.menuItem39.Index = 10;
this.menuItem39.Text = "粘贴";
this.menuItem39.Click += new System.EventHandler(this.menuItem39_Click);
//
// menuItem24
//
this.menuItem24.Index = 11;
this.menuItem24.Text = "-";
//
// menuItem6
//
this.menuItem6.Index = 12;
this.menuItem6.Text = "合并单元格";
this.menuItem6.Click += new System.EventHandler(this.menuItem6_Click);
//
// menuItem11
//
this.menuItem11.Index = 13;
this.menuItem11.Text = "拆分单元格";
this.menuItem11.Click += new System.EventHandler(this.menuItem11_Click);
//
// menuItem63
//
this.menuItem63.Index = 14;
this.menuItem63.Text = "设置子表";
this.menuItem63.Click += new System.EventHandler(this.menuItem63_Click);
//
// menuItem29
//
this.menuItem29.Index = 15;
this.menuItem29.Text = "插入一行";
this.menuItem29.Click += new System.EventHandler(this.menuItem29_Click);
//
// menuItem54
//
this.menuItem54.Index = 16;
this.menuItem54.Text = "增加一列";
this.menuItem54.Click += new System.EventHandler(this.menuItem54_Click);
//
// menuItem55
//
this.menuItem55.Index = 17;
this.menuItem55.Text = "删除最后一列";
this.menuItem55.Click += new System.EventHandler(this.menuItem55_Click);
//
// menuItem56
//
this.menuItem56.Index = 18;
this.menuItem56.Text = "设置行数";
this.menuItem56.Click += new System.EventHandler(this.menuItem56_Click);
//
// menuItem57
//
this.menuItem57.Index = 19;
this.menuItem57.Text = "设置列数";
this.menuItem57.Click += new System.EventHandler(this.menuItem57_Click);
//
// menuItem30
//
this.menuItem30.Text = "删除当前行";
this.menuItem30.Click += new System.EventHandler(this.menuItem30_Click);
//
// menuItem43
//
this.menuItem43.Index = 21;
this.menuItem43.Text = "设置当前选定单元格";
this.menuItem43.Click += new System.EventHandler(this.menuItem43_Click);
//
// menuItem45
//
this.menuItem45.Index = 22;
this.menuItem45.Text = "改变选定区域单元格的可编辑性";
this.menuItem45.Click += new System.EventHandler(this.menuItem45_Click);
//
// menuItem50
//
this.menuItem50.Index = 23;
this.menuItem50.Text = "选定整列";
this.menuItem50.Click += new System.EventHandler(this.menuItem50_Click);
//
// menuItem51
//
this.menuItem51.Index = 24;
this.menuItem51.Text = "设置水平对齐方式";
this.menuItem51.Click += new System.EventHandler(this.menuItem51_Click);
//
// menuItem52
//
this.menuItem52.Index = 25;
this.menuItem52.Text = "设置垂直对齐方式";
this.menuItem52.Click += new System.EventHandler(this.menuItem52_Click);
//
// menuItem44
//
this.menuItem44.Index = 26;
this.menuItem44.Text = "在当前列添加一条红色的竖线";
this.menuItem44.Click += new System.EventHandler(this.menuItem44_Click_1);
//
// menuItem53
//
this.menuItem53.Index = 27;
this.menuItem53.Text = "删除当前列的竖线";
this.menuItem53.Click += new System.EventHandler(this.menuItem53_Click);
//
// menuItem26
//
this.menuItem26.Index = 28;
this.menuItem26.Text = "-";
//
// menuItem32
//
this.menuItem32.Index = 29;
this.menuItem32.Text = "设置单元格背景色";
this.menuItem32.Click += new System.EventHandler(this.menuItem32_Click);
//
// menuItem34
//
this.menuItem34.Index = 30;
this.menuItem34.Text = "设置单元格前景色";
this.menuItem34.Click += new System.EventHandler(this.menuItem34_Click);
//
// menuItem37
//
this.menuItem37.Index = 31;
this.menuItem37.Text = "设置单元格的字体";
this.menuItem37.Click += new System.EventHandler(this.menuItem37_Click);
//
// menuItem46
//
this.menuItem46.Index = 32;
this.menuItem46.Text = "设置列标题的字体与文本";
this.menuItem46.Click += new System.EventHandler(this.menuItem46_Click);
//
// menuItem48
//
this.menuItem48.Index = 33;
this.menuItem48.Text = "设置当前列的列宽";
this.menuItem48.Click += new System.EventHandler(this.menuItem48_Click);
//
// menuItem35
//
this.menuItem35.Index = 34;
this.menuItem35.Text = "获取单元格背景色";
this.menuItem35.Click += new System.EventHandler(this.menuItem35_Click);
//
// menuItem36
//
this.menuItem36.Index = 35;
this.menuItem36.Text = "获取单元格前景色";
this.menuItem36.Click += new System.EventHandler(this.menuItem36_Click);
//
// menuItem47
//
this.menuItem47.Index = 36;
this.menuItem47.Text = "获得当前列的标题";
this.menuItem47.Click += new System.EventHandler(this.menuItem47_Click);
//
// menuItem49
//
this.menuItem49.Index = 37;
this.menuItem49.Text = "获得当前列的列宽";
this.menuItem49.Click += new System.EventHandler(this.menuItem49_Click);
//
// menuItem33
//
this.menuItem33.Index = 38;
this.menuItem33.Text = "-";
//
// menuItem27
//
this.menuItem27.Index = 39;
this.menuItem27.Text = "打印设置";
this.menuItem27.Click += new System.EventHandler(this.menuItem27_Click);
//
// menuItem41
//
this.menuItem41.Index = 40;
this.menuItem41.Text = "打印";
this.menuItem41.Click += new System.EventHandler(this.menuItem41_Click);
//
// menuItem62
//
this.menuItem62.Index = 41;
this.menuItem62.Text = "打印预览";
this.menuItem62.Click += new System.EventHandler(this.menuItem62_Click);
//
// menuItem60
//
this.menuItem60.Index = 2;
this.menuItem60.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem61});
this.menuItem60.Text = "其他操作";
//
// menuItem61
//
this.menuItem61.Index = 0;
this.menuItem61.Text = "新建窗口";
this.menuItem61.Click += new System.EventHandler(this.menuItem61_Click);
//
// textBox1
//
this.textBox1.AcceptsReturn = true;
this.textBox1.Location = new System.Drawing.Point(0, 0);
this.textBox1.Multiline = true;
this.textBox1.Name = "textBox1";
this.textBox1.ScrollBars = System.Windows.Forms.ScrollBars.Vertical;
this.textBox1.Size = new System.Drawing.Size(448, 64);
this.textBox1.TabIndex = 13;
this.textBox1.Text = "";
//
// timer1
//
this.timer1.Enabled = true;
this.timer1.Interval = 15000;
this.timer1.SynchronizingObject = this;
this.timer1.Elapsed += new System.Timers.ElapsedEventHandler(this.timer1_Elapsed);
//
// checkBox1
//
this.checkBox1.ForeColor = System.Drawing.Color.Red;
this.checkBox1.Location = new System.Drawing.Point(8, 392);
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(112, 24);
this.checkBox1.TabIndex = 14;
this.checkBox1.Text = "提示事件的发生";
this.checkBox1.CheckedChanged += new System.EventHandler(this.checkBox1_CheckedChanged);
//
// axlgxgrid1
//
private void Form1_Load(object sender, EventArgs e)
{
string connectstring = "Data Source=127.0.0.1;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";
SqlConnection connection;
SqlDataAdapter adapter;
string sql;
DataSet ds; connection = new System.Data.SqlClient.SqlConnection(connectstring);
sql = "select * from Customers";
adapter = new System.Data.SqlClient.SqlDataAdapter(sql, connection);
ds = new DataSet();
} private void button1_Click(object sender, EventArgs e)
{
ds.Clear();
adapter.Fill(ds, "Customers");
this.dataGrid1.DataSource = ds.Tables[0];
} private void button2_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlCommandBuilder builder = new System.Data.SqlClient.SqlCommandBuilder(adapter);
adapter.Update(ds, "customers"); }
我大学时候别人作业给我抄还懒得抄,作业似乎从来不交...
不要跟我一样,玩了四年helloworld都不会做
用绑定,以后又变动,需要一个一个去改,很繁琐。用程序写,可以把它们集中在一个模块中,这样方便。
一道题不要局限于一种方法。
其实,题目的显示部分很容易。难的是在dataGrid中添加数据后,如何更新到数据库中。
this.axlgxgrid1.Location = new System.Drawing.Point(0, 64);
this.axlgxgrid1.Name = "axlgxgrid1";
this.axlgxgrid1.OcxState = ((System.Windows.Forms.AxHost.State)(resources.GetObject("axlgxgrid1.OcxState")));
this.axlgxgrid1.Size = new System.Drawing.Size(448, 306);
this.axlgxgrid1.TabIndex = 15;
this.axlgxgrid1.HChange += new AxLgxgridV10.__lgxgrid_HChangeEventHandler(this.axlgxgrid1_HChange);
this.axlgxgrid1.IntoEdit += new AxLgxgridV10.__lgxgrid_IntoEditEventHandler(this.axlgxgrid1_IntoEdit);
this.axlgxgrid1.ClickEvent += new System.EventHandler(this.axlgxgrid1_ClickEvent);
this.axlgxgrid1.GotoNewRow += new AxLgxgridV10.__lgxgrid_GotoNewRowEventHandler(this.axlgxgrid1_GotoNewRow);
this.axlgxgrid1.ExitEdit += new AxLgxgridV10.__lgxgrid_ExitEditEventHandler(this.axlgxgrid1_ExitEdit);
this.axlgxgrid1.VChange += new AxLgxgridV10.__lgxgrid_VChangeEventHandler(this.axlgxgrid1_VChange);
this.axlgxgrid1.KeyPressEvent += new AxLgxgridV10.__lgxgrid_KeyPressEventHandler(this.axlgxgrid1_KeyPressEvent);
this.axlgxgrid1.DataChang += new AxLgxgridV10.__lgxgrid_DataChangEventHandler(this.axlgxgrid1_DataChang);
this.axlgxgrid1.AddNewRow += new AxLgxgridV10.__lgxgrid_AddNewRowEventHandler(this.axlgxgrid1_AddNewRow);
this.axlgxgrid1.RowShow += new AxLgxgridV10.__lgxgrid_RowShowEventHandler(this.axlgxgrid1_RowShow);
this.axlgxgrid1.SonTableClick += new AxLgxgridV10.__lgxgrid_SonTableClickEventHandler(this.axlgxgrid1_SonTableClick);
this.axlgxgrid1.MouseDownEvent += new AxLgxgridV10.__lgxgrid_MouseDownEventHandler(this.axlgxgrid1_MouseDownEvent);
this.axlgxgrid1.MouseMoveEvent += new AxLgxgridV10.__lgxgrid_MouseMoveEventHandler(this.axlgxgrid1_MouseMoveEvent);
this.axlgxgrid1.ExitEditAll += new AxLgxgridV10.__lgxgrid_ExitEditAllEventHandler(this.axlgxgrid1_ExitEditAll);
//
// button1
//
this.button1.Location = new System.Drawing.Point(288, 392);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(152, 24);
this.button1.TabIndex = 16;
this.button1.Text = "返回当前是否处于编辑状态";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// axlgxgrid2
//
this.axlgxgrid2.Enabled = true;
this.axlgxgrid2.Location = new System.Drawing.Point(104, 96);
this.axlgxgrid2.Name = "axlgxgrid2";
this.axlgxgrid2.OcxState = ((System.Windows.Forms.AxHost.State)(resources.GetObject("axlgxgrid2.OcxState")));
this.axlgxgrid2.Size = new System.Drawing.Size(258, 135);
this.axlgxgrid2.TabIndex = 17;
this.axlgxgrid2.Visible = false;
//
// label1
//
this.label1.Location = new System.Drawing.Point(8, 376);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(416, 16);
this.label1.TabIndex = 18;
this.label1.Text = "请在单元格上单击鼠标右键弹出操作菜单!";
//
// menuItem66
//
this.menuItem66.Index = 5;
this.menuItem66.Text = "设置公式";
this.menuItem66.Click += new System.EventHandler(this.menuItem66_Click);
//
// cs
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(448, 421);
this.Controls.Add(this.label1);
this.Controls.Add(this.axlgxgrid2);
this.Controls.Add(this.button1);
this.Controls.Add(this.axlgxgrid1);
this.Controls.Add(this.checkBox1);
this.Controls.Add(this.textBox1);
this.Name = "cs";
this.Text = "Lgxgrid示例";
this.Closing += new System.ComponentModel.CancelEventHandler(this.cs_Closing);
this.Load += new System.EventHandler(this.cs_Load);
((System.ComponentModel.ISupportInitialize)(this.timer1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.axlgxgrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.axlgxgrid2)).EndInit();
this.ResumeLayout(false); }
#endregion
/// 应用程序的主入口点。
/// </summary>
public static cs Mf;
[STAThread]
static void Main()
{
//Fors.Ef=new cs();
Application.Run(new cs());
} private void cs_Load(object sender, System.EventArgs e)
{
string Pt;
Pt=Application.StartupPath;
if (Pt.Length>3)
Pt=(Pt+"\\");
string dsn="server=(local);database=Northwind;Trusted_Connection=yes";
Mysjk = new SqlConnection(dsn);
mysjk.Open(sjkf,null,null,0); axlgxgrid1.UsDataBase =mysjk; //将数据对象连接到Lgxgrid控件
//为控件添加列,参数依次为:列标题,模式(1为textbox,2为combox),列宽,是否允许编辑
axlgxgrid1.hadd("班别", 1, 800, true,null);
axlgxgrid1.hadd ("学生姓名", 2, 820, true,null);
axlgxgrid1.hadd ("语文", 1, 620, true,null);
axlgxgrid1.hadd ("数学", 1, 620, true,null);
axlgxgrid1.hadd ("英语", 1, 620, true,null);
axlgxgrid1.hadd ("物理", 1, 620, true,null);
axlgxgrid1.hadd ("化学", 1, 620, true,null);
axlgxgrid1.hadd ("总分", 1, 800, false,null);
axlgxgrid1.hadd ("平均分", 1, 800, false,null);
//以下合并表头,参数依次为:列标题,起始行号,起始列号,终止行号,终止列号,标识(首次合并为1)
axlgxgrid1.Unite ("班" +(char)13+"别", 0, 0, 1, 0, 1,null);
axlgxgrid1.Unite ("学 生"+(char)13+"姓 名", 0, 1, 1, 1, 1,null);
axlgxgrid1.Unite ("各 科 成 绩", 0, 2, 0, 6, 1,null);
axlgxgrid1.Unite ("统 计", 0, 7, 0, 8, 1,null);
axlgxgrid1.Unite ("语文", 1, 2, 1, 2, 1,null);
axlgxgrid1.Unite ("数学", 1, 3, 1, 3, 1,null);
axlgxgrid1.Unite ("英语", 1, 4, 1, 4, 1,null);
axlgxgrid1.Unite ("物理", 1, 5, 1, 5, 1,null);
axlgxgrid1.Unite ("化学", 1, 6, 1, 6, 1,null);
axlgxgrid1.Unite ("总分", 1, 7, 1, 7, 1,null);
axlgxgrid1.Unite ("平均分", 1, 8, 1, 8, 1,null); axlgxgrid1.Slwok = true; //使列宽可以拖动
for(int i=1;i<=axlgxgrid1.rows;i++)
{
axlgxgrid1.SbackColor(i,8,0xf8e8d8);
}
for(int i=1;i<=axlgxgrid1.rows;i++)
{
axlgxgrid1.SbackColor(i,9,0xe8d8f8);
}
} private void axlgxgrid1_MouseDownEvent(object sender, AxLgxgridV10.__lgxgrid_MouseDownEvent e)
{
if(chok)textBox1.Text ="MouseDown事件发生,参数返回值:button="+e.button+",shift="+e.shift+",x="+e.x+",y="+e.y+(char)13+"\n"+textBox1.Text;
if(e.button ==2)
{
Point t;
t=new Point();
t.X=(int)e.x;
t.Y=(int)e.y+axlgxgrid1.Top;
this.contextMenu1.Show(this,t);
}
} private void menuItem3_Click(object sender, System.EventArgs e)
{
MessageBox.Show(axlgxgrid1.BackColor.ToString() );
} private void menuItem4_Click(object sender, System.EventArgs e)
{
if (axlgxgrid1.CloseAdd ==true)
{
axlgxgrid1.CloseAdd=false;
}
else
{
axlgxgrid1.CloseAdd =true;
} } private void menuItem5_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.lists);
} private void menuItem6_Click(object sender, System.EventArgs e)
{
axlgxgrid1.GridUnite((int)axlgxgrid1.Nrow,(short)axlgxgrid1.Nlist,(int)axlgxgrid1.NrowEnd,(short)axlgxgrid1.NlistEnd ,0);
} private void menuItem8_Click(object sender, System.EventArgs e)
{
MessageBox.Show(axlgxgrid1.ForeColor.ToString () ); } private void menuItem7_Click(object sender, System.EventArgs e)
{
axlgxgrid1.HbackColor=Color.FromArgb(100,203, 235,215);
} private void menuItem9_Click(object sender, System.EventArgs e)
{
axlgxgrid1.HforeColor =Color.Red;
} private void menuItem10_Click(object sender, System.EventArgs e)
{
axlgxgrid1.LineColor=Color.FromArgb(108,100,100,200);
} private void menuItem11_Click(object sender, System.EventArgs e)
{
axlgxgrid1.SplitGrid((int)axlgxgrid1.Nrow, (short)axlgxgrid1.Nlist);
} private void menuItem13_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.Nlist);
} private void menuItem14_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.NlistEnd);
} private void menuItem15_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.Nrow);
} private void menuItem16_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.NrowEnd);
} private void menuItem17_Click(object sender, System.EventArgs e)
{
try
{
Fors.Ef =this;
int Hs;
Form2 Nf=new Form2();
Nf.Text ="请输入要设置的行高:";
Nf.ShowDialog();
Hs=int.Parse(Nf.textBox1.Text);
int oldH;
oldH=axlgxgrid1.Height;
axlgxgrid1.RowsMode =false;
axlgxgrid1.RowHeight =Hs;
axlgxgrid1.Height =oldH;
}
catch(Exception error)
{ MessageBox.Show(error.Message,"出错啦!");}
} private void menuItem18_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.rows);
} private void menuItem19_Click(object sender, System.EventArgs e)
{
if (axlgxgrid1.Slwok ==true)
{
axlgxgrid1.Slwok =false;
}
else
{
axlgxgrid1.Slwok =true;
} }
private void menuItem23_Click(object sender, System.EventArgs e)
{
ADODB.Recordset myre;
object p=null;
myre=mysjk.Execute("select * from cjb;",out p,0);
int i=1;
int j=0;
string Dt;
while(!myre.EOF)
{
for(j=0;j<=myre.Fields.Count-1;j++)
{
Dt=""+myre.Fields[j].Value;
axlgxgrid1.SetData(i,j+1,Dt); }
myre.MoveNext();
i++;
}
myre.Close();
} private void axlgxgrid1_DataChang(object sender, AxLgxgridV10.__lgxgrid_DataChangEvent e)
{
if (e.olddata!="" && e.olddata !="0" && e.newData !="")
if(chok)textBox1.Text ="DataChang事件发生,参数返回值:hid="+e.hid+",lid="+e.lid+",oldData="+e.olddata+",newData="+e.newData+(char)13+"\n"+textBox1.Text;
int ok;
ok=(int)e.lid;
if(ok<8)
{
float Zf=0;
float Pjf=0;
//MessageBox.Show(""+axlgxgrid1.rows);
for(int i=0;i<=4;i++)
{
if(axlgxgrid1.GetData(e.hid,i+3)!="")
Zf=Zf+float.Parse(axlgxgrid1.GetData(e.hid,i+3));
}
Pjf=Zf/5;
axlgxgrid1.SetData(e.hid,8,""+Zf);
axlgxgrid1.SetData(e.hid,9,""+Pjf);
}
} private void menuItem25_Click(object sender, System.EventArgs e)
{
axlgxgrid1.Gridclear();
} private void menuItem27_Click(object sender, System.EventArgs e)
{
LgxgridV10.PrinterInfos pr;
pr = axlgxgrid1.PrinterInfoGet();
pr.TitleText = "2004年春初中学生成绩表";
pr.TableHeadFont.Size = 12;
pr.TableHeadFont.Name = "宋体";
pr.TableHeadFont.Bold = false;
pr.ColorOrBlack = 1;
pr.MainFont.Size = 12;
pr.Ltext = "填表单位:";
pr.TableTop = pr.TableTop - 0.6;
pr.ULtext = "填表人:";
pr.UBtext = "负责人:";
pr.URtest = "审批人: ";
pr.TellText = "说明:(1)各班主任要在期考后3天内把成绩交教导处。" + (char)13+"\n" + " (2)各班班主任要写好质量分析。";
//(char)13+"\n"为插入一个回车换行符
pr.ListScale = 1.7;
//pr.RowH = 600;
pr.LineWidth = 1;
axlgxgrid1.PrinterInfoSet(pr);
axlgxgrid1.SetPrintShow();
}
private void menuItem28_Click(object sender, System.EventArgs e)
{
axlgxgrid1.clear();
for(int i=1;i<=axlgxgrid1.rows;i++)
{
axlgxgrid1.SbackColor(i,8,0xf8e8d8);
}
for(int i=1;i<=axlgxgrid1.rows;i++)
{
axlgxgrid1.SbackColor(i,9,0xe8d8f8);
}
} private void menuItem29_Click(object sender, System.EventArgs e)
{
axlgxgrid1.InRow(axlgxgrid1.Nrow);
} private void menuItem30_Click(object sender, System.EventArgs e)
{
axlgxgrid1.DelRow(axlgxgrid1.Nrow);
for(int i=1;i<=axlgxgrid1.rows;i++)
{
axlgxgrid1.SbackColor(i,8,0xf8e8d8);
}
for(int i=1;i<=axlgxgrid1.rows;i++)
{
axlgxgrid1.SbackColor(i,9,0xe8d8f8);
}
} private void menuItem31_Click(object sender, System.EventArgs e)
{
axlgxgrid1.OrderList(1,axlgxgrid1.rows,1,LgxgridV10.px.Depress,LgxgridV10.pxmode.CharacterMode);
} private void menuItem32_Click(object sender, System.EventArgs e)
{
int r1,r2,l1,l2;
r1=axlgxgrid1.Nrow;
r2=axlgxgrid1.NrowEnd;
l1=axlgxgrid1.Nlist;
l2=axlgxgrid1.NlistEnd;
for(int i=r1;i<=r2;i++)
{
for(int j=l1;j<=l2;j++)
{axlgxgrid1.SbackColor(i ,j ,0x7fa8f0);}
}
} private void menuItem34_Click(object sender, System.EventArgs e)
{
int r1,r2,l1,l2;
r1=axlgxgrid1.Nrow;
r2=axlgxgrid1.NrowEnd;
l1=axlgxgrid1.Nlist;
l2=axlgxgrid1.NlistEnd;
for(int i=r1;i<=r2;i++)
{
for(int j=l1;j<=l2;j++)
{axlgxgrid1.SForeColor (i ,j ,0x9f3f00);}
}
} private void menuItem35_Click(object sender, System.EventArgs e)
{
Color ys;
ys=axlgxgrid1.GetBackColor(axlgxgrid1.Nrow,axlgxgrid1.Nlist);
MessageBox.Show(""+ys.ToString());
} private void menuItem36_Click(object sender, System.EventArgs e)
{
Color ys;
ys=axlgxgrid1.GetForeColor(axlgxgrid1.Nrow,axlgxgrid1.Nlist);
MessageBox.Show(""+ys.ToString());
} private void menuItem37_Click(object sender, System.EventArgs e)
{
stdole.StdFont zt=new stdole.StdFontClass();
zt.Name ="隶书";
zt.Size =14;
axlgxgrid1.SetFont(axlgxgrid1.Nrow,axlgxgrid1.Nlist,zt);
} private void menuItem38_Click(object sender, System.EventArgs e)
{
axlgxgrid1.Copy();
} private void menuItem39_Click(object sender, System.EventArgs e)
{
axlgxgrid1.Plaster();
} private void menuItem41_Click(object sender, System.EventArgs e)
{
LgxgridV10.PrinterInfos pr;
pr = axlgxgrid1.PrinterInfoGet();
pr.TitleText = "2004年春初中学生成绩表";
pr.TableHeadFont.Size = 9;
pr.TableHeadFont.Name = "宋体";
pr.TableHeadFont.Bold = false;
pr.ColorOrBlack = 1;
pr.MainFont.Size = 9;
pr.Ltext = "填表单位:";
pr.TableTop = pr.TableTop - 0.6;
pr.ULtext = "填表人:";
pr.UBtext = "负责人:";
pr.URtest = "审批人: ";
pr.TellText = "说明:(1)各班主任要在期考后3天内把成绩交教导处。" + (char)13+"\n" + " (2)各班班主任要写好质量分析。";
//(char)13+"\n"为插入一个回车换行符,相当于VB的vbCrLf
pr.ListScale = 1.7;
pr.RowH = 600;
pr.LineWidth = 2;
axlgxgrid1.PrinterInfoSet(pr);
axlgxgrid1. PrintYes(); }
{
mysjk.Close();
}
private void axlgxgrid1_IntoEdit(object sender, AxLgxgridV10.__lgxgrid_IntoEditEvent e)
{
if(chok)textBox1.Text ="IntoEdit事件发生,参数返回值:row="+e.row+",list="+e.list+",oldData="+e.olddata+(char)13+"\n"+textBox1.Text;
if(e.list ==2)
{
string sqltxt;
sqltxt="SELECT 姓名 FROM cjb WHERE 班别='"+axlgxgrid1.GetData(e.row,1)+"';";
axlgxgrid1.ComAdd(2,"sql",sqltxt);
}
} private void axlgxgrid1_ClickEvent(object sender, System.EventArgs e)
{
if(chok)textBox1.Text ="ClickEvent事件发生,无参数返回值"+(char)13+"\n"+textBox1.Text;
axlgxgrid2.Visible =false;
} private void axlgxgrid1_MouseMoveEvent(object sender, AxLgxgridV10.__lgxgrid_MouseMoveEvent e)
{
//if(pdr!=e.row || pdl!=e.list)
//{
//if(chok)textBox1.Text ="MouseMove事件发生,参数返回值:row="+e.row+",list="+e.list+(char)13+"\n"+textBox1.Text;
// pdr=e.row;pdl=e.list;
//}
} private void axlgxgrid1_ExitEdit(object sender, AxLgxgridV10.__lgxgrid_ExitEditEvent e)
{
if(chok)textBox1.Text ="ExitEdit事件发生,参数返回值:row="+e.row+",list="+e.list+",oldData="+e.olddata+",newData="+e.newData+",cancel="+e.cancel+(char)13+"\n"+textBox1.Text; } private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
textBox1.Text ="";
} private void checkBox1_CheckedChanged(object sender, System.EventArgs e)
{
if (checkBox1.Checked ==true)
{
chok=true;
}
else
{
chok=false;
}
} private void axlgxgrid1_RowShow(object sender, AxLgxgridV10.__lgxgrid_RowShowEvent e)
{
if(chok)textBox1.Text ="RowShow事件发生,参数返回值:rowBegin="+e.rowBegin+",rowEnd="+e.rowEnd+(char)13+"\n"+textBox1.Text;
} private void axlgxgrid1_KeyPressEvent(object sender, AxLgxgridV10.__lgxgrid_KeyPressEvent e)
{
if(chok)textBox1.Text ="KeyPressEvent事件发生,参数返回值:keyAscii="+e.keyAscii+(char)13+"\n"+textBox1.Text;
} private void menuItem42_Click(object sender, System.EventArgs e)
{
if(axlgxgrid1.AutoEdit==true)
{axlgxgrid1.AutoEdit =false;}
else
{axlgxgrid1.AutoEdit =true;}
} private void menuItem43_Click(object sender, System.EventArgs e)
{
if(axlgxgrid1.Nrow!=axlgxgrid1.rows)
{axlgxgrid1.SetNowGrid(axlgxgrid1.rows,axlgxgrid1.lists);}
else
{axlgxgrid1.SetNowGrid(1,1);}
} private void axlgxgrid1_GotoNewRow(object sender, AxLgxgridV10.__lgxgrid_GotoNewRowEvent e)
{
if(chok)textBox1.Text ="GotoNewLine事件发生,参数返回值:oldRow="+e.oldRow+",oldList="+e.oldList+",e.newRow="+e.newRow+",e.newList="+e.newList+(char)13+"\n"+textBox1.Text;
}
private void axlgxgrid1_ExitEditAll(object sender, AxLgxgridV10.__lgxgrid_ExitEditAllEvent e)
{
if(chok)textBox1.Text ="ExitEditAll事件发生,参数返回值:row="+e.row +",list="+e.list +(char)13+"\n"+textBox1.Text;
} private void axlgxgrid1_AddNewRow(object sender, AxLgxgridV10.__lgxgrid_AddNewRowEvent e)
{
axlgxgrid1.SbackColor(e.newRow,8,0xf8e8d8);
axlgxgrid1.SbackColor(e.newRow,9,0xe8d8f8);
if(chok)textBox1.Text ="AddNewRow事件发生,参数返回值:newRow="+e.newRow +(char)13+"\n"+textBox1.Text;
} private void menuItem44_Click(object sender, System.EventArgs e)
{
axlgxgrid1.SetData (30000,1,null);
} private void contextMenu1_Popup(object sender, System.EventArgs e)
{
} private void menuItem45_Click(object sender, System.EventArgs e)
{
int r1,r2,l1,l2;
r1=axlgxgrid1.Nrow;
r2=axlgxgrid1.NrowEnd;
l1=axlgxgrid1.Nlist;
l2=axlgxgrid1.NlistEnd;
for(int i=r1;i<=r2;i++)
{
for(int j=l1;j<=l2;j++)
{
if(axlgxgrid1.GetGridEditStyle(i,j)!=true)
{axlgxgrid1.SetGridEditStyle(i ,j ,true);}
else
{
axlgxgrid1.SetGridEditStyle(i,j,false);
}
}
}
}
{
stdole.StdFont hf=new stdole.StdFontClass();
hf.Name ="隶书";
hf.Size =12;
axlgxgrid1.SetHeadText(1,1,"班级"+(char)13+"名称",hf);
} private void menuItem47_Click(object sender, System.EventArgs e)
{
MessageBox.Show(axlgxgrid1.GetHeadText(1,axlgxgrid1.Nlist));
} private void menuItem48_Click(object sender, System.EventArgs e)
{
axlgxgrid1.SetListWidth (axlgxgrid1.Nlist,axlgxgrid1.GetListWidth(axlgxgrid1.Nlist)+100);
} private void menuItem49_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.GetListWidth(axlgxgrid1.Nlist));
} private void menuItem50_Click(object sender, System.EventArgs e)
{
axlgxgrid1.SetArea(1,axlgxgrid1.Nlist,axlgxgrid1.rows,axlgxgrid1.Nlist );
} private void menuItem51_Click(object sender, System.EventArgs e)
{
axlgxgrid1.SetLAlignment(axlgxgrid1.Nrow ,axlgxgrid1.Nlist ,(short)(axlgxgrid1.GetLAlignment (axlgxgrid1.Nrow ,axlgxgrid1.Nlist)+1));
} private void menuItem52_Click(object sender, System.EventArgs e)
{
axlgxgrid1.SetTAlignment(axlgxgrid1.Nrow ,axlgxgrid1.Nlist ,(short)(axlgxgrid1.GetTAlignment (axlgxgrid1.Nrow ,axlgxgrid1.Nlist)+1));
} private void menuItem22_Click(object sender, System.EventArgs e)
{
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
axlgxgrid1.RowsAdd(30000);
this.Cursor = System.Windows.Forms.Cursors.Default;
} private void menuItem44_Click_1(object sender, System.EventArgs e)
{
axlgxgrid1.ListLineAdd(axlgxgrid1.Nlist,1,0x0000ff);
} private void menuItem53_Click(object sender, System.EventArgs e)
{
axlgxgrid1.ListLineUnload (axlgxgrid1.Nlist);
} private void button1_Click(object sender, System.EventArgs e)
{
if(axlgxgrid1.EditRow >0)
{MessageBox.Show("正在编辑第"+axlgxgrid1.EditRow +"行第"+axlgxgrid1.EditList +"列的单元格。");}
else
{MessageBox.Show ("当前处于非编辑状态。");}
} private void menuItem55_Click(object sender, System.EventArgs e)
{
axlgxgrid1.DelList();
} private void menuItem54_Click(object sender, System.EventArgs e)
{
axlgxgrid1.AddList ("新增列",1,800,true,null);
axlgxgrid1.Unite("新增列",0,(short)(axlgxgrid1.lists -1),1,(short)(axlgxgrid1.lists -1),2,null); } private void menuItem56_Click(object sender, System.EventArgs e)
{
try
{
Fors.Ef =this;
int Hs;
Form2 Nf=new Form2();
Nf.Text ="请输入要设置的行数:";
Nf.ShowDialog();
Hs=int.Parse(Nf.textBox1.Text);
axlgxgrid1.SetdRows(Hs);
}
catch(Exception error)
{ MessageBox.Show(error.Message,"出错啦!");}
} private void menuItem57_Click(object sender, System.EventArgs e)
{
try
{
Fors.Ef =this;
Form2 Nf=new Form2();
int Hs;
int olists;
Nf.Text ="请输入要设置的列数:";
Nf.ShowDialog();
Hs=int.Parse(Nf.textBox1.Text);
olists=axlgxgrid1.lists;
axlgxgrid1.SetLists (Hs,1,800,true);
for(int i=olists+1;i<=axlgxgrid1.lists;i++)
{
axlgxgrid1.Unite(""+i,0,(short)(i-1),1,(short)(i-1),2,null);
}
}
catch(Exception error)
{ MessageBox.Show(error.Message,"出错啦!");}
} private void menuItem58_Click(object sender, System.EventArgs e)
{
if(axlgxgrid1.RowsMode ==true)
{axlgxgrid1.RowsMode=false;}
else
{axlgxgrid1.RowsMode =true;}
} private void menuItem59_Click(object sender, System.EventArgs e)
{
if(axlgxgrid1.EditAspect==0)
{axlgxgrid1.EditAspect =1;}
else
{axlgxgrid1.EditAspect =0;} } private void menuItem61_Click(object sender, System.EventArgs e)
{
new cs().Show();
} private void menuItem62_Click(object sender, System.EventArgs e)
{
LgxgridV10.PrinterInfos pr;
pr = axlgxgrid1.PrinterInfoGet();
pr.TitleText = "2004年春初中学生成绩表";
pr.TableHeadFont.Size = 12;
pr.TableHeadFont.Name = "宋体";
pr.TableHeadFont.Bold = false;
pr.ColorOrBlack = 1;
pr.MainFont.Size = 12;
pr.Ltext = "填表单位:";
pr.TableTop = pr.TableTop - 0.6;
pr.ULtext = "填表人:";
pr.UBtext = "负责人:";
pr.URtest = "审批人: ";
pr.TellText = "说明:(1)各班主任要在期考后3天内把成绩交教导处。" + (char)13+"\n" + " (2)各班班主任要写好质量分析。";
//(char)13+"\n"为插入一个回车换行符
pr.ListScale = 1.7;
//pr.RowH = 600;
pr.LineWidth = 1;
axlgxgrid1.PrinterInfoSet(pr);
axlgxgrid1.PrintView();
}
{
try
{
Fors.Ef =this;
int Hs;
Form2 Nf=new Form2();
Nf.Text ="请输入要设置子表的列号:";
Nf.ShowDialog();
Hs=int.Parse(Nf.textBox1.Text);
axlgxgrid1.SetSonTable(Hs);
}
catch(Exception error)
{ MessageBox.Show(error.Message,"出错啦!");}
} private void axlgxgrid1_SonTableClick(object sender, AxLgxgridV10.__lgxgrid_SonTableClickEvent e)
{
axlgxgrid2.Visible = false;
axlgxgrid2.SetLists (0, 1, 100, false);
axlgxgrid2.SetLists (10, 1, 1000, false);
axlgxgrid2.Left = (int)e.x+10;
axlgxgrid2.Top = (int)e.y +60;
if (axlgxgrid2.Top + axlgxgrid2.Height>this.Height)
{
axlgxgrid2.Top = (int)e.y+60- axlgxgrid2.Height;
}
if (axlgxgrid2.Left + axlgxgrid2.Width>this.Width)
{
axlgxgrid2.Left = (int)e.x -10- axlgxgrid2.Width;
}
axlgxgrid2.Visible = true;
for (int i = 1;i<=50;i++)
{
for (int j = 1;j<=10;j++)
{axlgxgrid2.SetData(i, j, axlgxgrid1.GetData (e.row ,e.list ) + i);}
}
} private void axlgxgrid1_HChange(object sender, AxLgxgridV10.__lgxgrid_HChangeEvent e)
{
axlgxgrid2.Visible =false;
} private void axlgxgrid1_VChange(object sender, AxLgxgridV10.__lgxgrid_VChangeEvent e)
{
axlgxgrid2.Visible =false;
} private void menuItem66_Click(object sender, System.EventArgs e)
{
axlgxgrid1.SetFunc(7,3,"sum(grid(1:6,3))");
} private void menuItem64_Click(object sender, System.EventArgs e)
{
axlgxgrid1.CopyFunc();
} private void menuItem65_Click(object sender, System.EventArgs e)
{
axlgxgrid1.PlasterFunc();
}
}}
可能不能直接交给老师,因为并不完全符合楼主的条件,也不是用dataGrid的.
怎么用楼主看着办吧.是消化吸收还是置之不理随便.反正我一分也不要.
using System.Collections;
using System.Collections.Specialized;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.IO;namespace XXX.TTTTT
/// <summary>
/// Data 的摘要说明。
/// </summary>
[WebService(Namespace="http://xxxxxx")]
public class Data : System.Web.Services.WebService
{
SqlConnection Mysjk;//定义数据库对象
//SqlCommand myC=new SqlCommand();//命令对象
public System.Xml.XmlDocument SubMxXml;
private Expression.FunctionRun functionRun1;
public System.Xml.XmlDocument SubUserMxXml;
public int MyYearD=0;
public int MyMonthD=0;
public string MyUnitD="";
public string GetBbName=""; public Data()
{
//CODEGEN:该调用是 ASP.NET Web 服务设计器所必需的
InitializeComponent();
try
{
string Uc=(string)this.Context.Session["UserClass"];
string[] Utxt=Uc.Split(new Char[]{(char)13});
if(Utxt[3].ToString()!="xxxxxxxxxx")
{
this.Context.Response.End();
}
//String dsn = (String) ((NameValueCollection) Context.GetConfig("system.web/dsnstore"))["MyDSN"];
string dsn="server=(local);database=你的数据库名;Trusted_Connection=yes";
Mysjk = new SqlConnection(dsn);
}
catch
{
this.Context.Response.End();
}
}
//连接数据库,打开数据库,基于数据库的应用程序,都是要这样做的了 #region Component Designer generated code
//Web 服务设计器所必需的
private IContainer components = null;
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.functionRun1 = new Expression.FunctionRun();
//
// functionRun1
//
this.functionRun1.ReturnData =null;
this.functionRun1.FunctionAdd += new Expression.FunctionRun.FunctionAddEventHandler(this.functionRun1_FunctionAdd); } /// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if(disposing && components != null)
{
components.Dispose();
}
base.Dispose(disposing);
}
#endregion //公用函数
public struct TableList
{
public string Name;
public string Type;
}
private string RunSql(string SqlTxt)
{
//运行Sql查询语句,返回执行结果
SqlDataReader MyRe=null;
string[] ComT=SqlTxt.Split(new char[] {' '});
string ComTxt=ComT[0].ToString();
try
{
if (ComTxt!="SELECT")
{
SqlCommand myCommand = new SqlCommand();
myCommand.Connection=Mysjk;
myCommand.CommandText=SqlTxt;
myCommand.ExecuteNonQuery();
return "SetOk";
}
else
{
SqlCommand myCommand = new SqlCommand(SqlTxt,Mysjk);
MyRe = myCommand.ExecuteReader();
MyRe.Read();
string Res=MyRe.GetValue(0).ToString();
return Res;
}
}
catch(Exception error)
{
return error.Message+"当前查询表达式为:"+SqlTxt;
}
finally
{
if(ComTxt=="SELECT")
{
MyRe.Close();
}
} } private double Set0(string Data)
{
try
{
return double.Parse(Data);
}
catch
{
return 0;
}
}
{
//执行有返回值的SELECT查询,以XML的方式返回查询结果
//参数为一条SELECT查询命令
//返回值是一个XML文档
SqlDataReader MyRe=null;
try
{
string[] ComT=SqlTxt.Split(new char[] {' '});
string ComTxt=ComT[0].ToString();
if (ComTxt=="SELECT")
{
//检测是否是SELECT查询,如果是
System.Xml.XmlDocument XmlDoc=new System.Xml.XmlDocument();
SqlCommand myCommand = new SqlCommand(SqlTxt,Mysjk);
MyRe = myCommand.ExecuteReader();
//根据查询命令字符串成,执行查询,返回结果集
string XmlTxt="";
XmlTxt="<?xml version='1.0' encoding='utf-8'?>";
XmlTxt=XmlTxt+"<Root></Root>";
XmlDoc.LoadXml(XmlTxt);
int Cs=0;
while(MyRe.Read())
{
Cs++;
System.Xml.XmlNode NewRecord=XmlDoc.CreateNode(System.Xml.XmlNodeType.Element,"Record","");
XmlDoc.DocumentElement.AppendChild(NewRecord);
string Das="";
for(int i=0;i<=MyRe.FieldCount-1;i++)
{
switch (MyRe.GetDataTypeName(i))
{
case "money":
if (MyRe.GetValue(i).ToString()!="")
{
double DoDas=Double.Parse(MyRe.GetValue(i).ToString());
Das=DoDas.ToString("0.00");
}
else
{
Das="0.00";
}
break;
case "float":
if (MyRe.GetDouble(i).ToString()!="")
{
Das=MyRe.GetDouble(i).ToString("0.00");
}
else
{
Das="";
}
break;
case "datetime":
case "smalldatetime":
if(MyRe.GetValue(i).ToString()!="")
{
DateTime DT=DateTime.Parse(MyRe.GetValue(i).ToString());
Das=DT.Year+"年"+DT.Month+"月"+DT.Day+"日";
}
else
{
Das=MyRe.GetValue(i).ToString();
}
break;
default:
Das=MyRe.GetValue(i).ToString();
break;
}
System.Xml.XmlNode newfield=XmlDoc.CreateNode(System.Xml.XmlNodeType.CDATA,"Field", "");
newfield.Value=Das;
NewRecord.AppendChild(newfield);
}
}
if(Cs==0)
{
XmlTxt="<Root><Record><![CDATA[Error,没有查到任何记录。查询表达式为:"+SqlTxt+"]]></Record></Root>";
XmlDoc.LoadXml(XmlTxt);
return XmlDoc;
}
//历遍结果集,并将它转为XML格式
//关闭结果集
//生成XML对象
return XmlDoc;
//返回XML对象
}
else
{
string XmlTxt="<Root><Record><![CDATA[Error,该查询不是可返回值的查询]]></Record></Root>";
System.Xml.XmlDocument XmlDoc=new System.Xml.XmlDocument();
XmlDoc.LoadXml(XmlTxt);
return XmlDoc;
//返回出错信息,在前面加了一个Error以方便识别它
}
}
catch(Exception error)
{
string XmlTxt="<Root><Record><![CDATA[Error,"+error.Message+"查询表达式为:"+SqlTxt+"]]></Record></Root>";
System.Xml.XmlDocument XmlDoc=new System.Xml.XmlDocument();
XmlDoc.LoadXml(XmlTxt);
return XmlDoc;
//返回系统错误信息,在前面加了一个Error以方便识别它
}
finally
{
MyRe.Close();
}
} private string Find(string RT)
{
int p=0;
try
{
p=Convert.ToInt16(RT);
if (p>0)
{
return "Fyes";
}
else
{
return "Fno";
} }
catch
{
return "Error";
} }
{
//往一个表中添加一条记录
//DataN:表名
//要添加的数据
try
{
string SqlTxt="";
System.Xml.XmlNode SqlValue=MyXmlDoc.SelectSingleNode("Root/Record");
int Datas=SqlValue.ChildNodes.Count;
SqlTxt="INSERT into "+DataN+" Values(";
TableList[] TableL=ListNameGet(DataN);
string Ltype="";
for(int i=0;i<Datas-1;i++)
{
Ltype=TableL[i].Type;
switch (Ltype)
{
case "varchar":
case "char":
case "text":
case "nchar":
case "nvarchar":
case "ntext":
if(SqlValue.ChildNodes[i].InnerText!="")
{
SqlTxt=SqlTxt+"'"+SqlValue.ChildNodes[i].InnerText+"',";
}
else
{
SqlTxt=SqlTxt+"Null,";
}
//字符串类型的数据
break;
case "bigint":
case "int":
case "smallint":
case "tinyint":
case "bit":
case "decimal":
case "numeric":
case "money":
case "smallmoney":
case "real":
if(SqlValue.ChildNodes[i].InnerText!="null" && SqlValue.ChildNodes[i].InnerText!="")
{
SqlTxt=SqlTxt+SqlValue.ChildNodes[i].InnerText+",";
}
else
{
SqlTxt=SqlTxt+"null,";
}
//数值类型的数据
break;
case "float":
if(SqlValue.ChildNodes[i].InnerText!="null")
{
double DouData=Double.Parse(SqlValue.ChildNodes[i].InnerText);
SqlTxt=SqlTxt+DouData+",";
}
else
{
SqlTxt=SqlTxt+SqlValue.ChildNodes[i].InnerText+",";
}
//数值类型的数据,可能含有百分号
break;
case "datetime":
case "smalldatetime":
if (SqlValue.ChildNodes[i].InnerText!="null")
{
DateTime DT=DateTime.Parse(SqlValue.ChildNodes[i].InnerText);
SqlTxt=SqlTxt+"'"+DT.ToString()+"',";
}
else
{
SqlTxt=SqlTxt+SqlValue.ChildNodes[i].InnerText+",";
}
//日期时间类型的数据
break; default:
SqlTxt=SqlTxt+SqlValue.ChildNodes[i].InnerText+",";
//其他类型的数据
break;
}
}
Ltype=TableL[Datas-1].Type;
switch (Ltype)
{
case "varchar":
case "char":
case "text":
case "nchar":
case "nvarchar":
case "ntext":
SqlTxt=SqlTxt+"'"+SqlValue.ChildNodes[Datas-1].InnerText+"')";
//字符串类型的数据
break;
case "bigint":
case "int":
case "smallint":
case "tinyint":
case "bit":
case "decimal":
case "numeric":
case "money":
case "smallmoney":
case "float":
case "real":
//SqlTxt=SqlTxt+SqlValue.ChildNodes[Datas-1].InnerText+")";
if(SqlValue.ChildNodes[Datas-1].InnerText!="null" && SqlValue.ChildNodes[Datas-1].InnerText!="")
{
SqlTxt=SqlTxt+SqlValue.ChildNodes[Datas-1].InnerText+")";
}
else
{
SqlTxt=SqlTxt+"null)";
}
//数值类型的数据
break;
case "datetime":
case "smalldatetime":
DateTime DT=DateTime.Parse(SqlValue.ChildNodes[Datas-1].InnerText);
SqlTxt=SqlTxt+"'"+DT.ToString()+"')";
//日期时间类型的数据
break; default:
SqlTxt=SqlTxt+SqlValue.ChildNodes[Datas-1].InnerText+")";
//其他类型的数据
break;
}
//生成插入查询命令
return RunSql(SqlTxt);
//执和命令
} catch(Exception error)
{
return error.Message;
}
}