求一个datagridview 编辑，更新，批量删除的例子

[无心雨云]

开始做了C/S的一个项目，后来就一直搞B/S，现在C/S都差不多都忘了，所以求一个例子,谢谢！

[芮言]

http://download.csdn.net/source/227326
http://download.csdn.net/source/694889

[Fighting_Lin]

static string source = "Data Source=.;Initial Catalog=Ticket;Integrated Security=true";
public static List<Model.TicketInfo> GetTickersAllInfo()
{
string sql = "select*from TicketInfo";
SqlConnection sqlConn = new SqlConnection(source);
SqlDataAdapter sqlDA = new SqlDataAdapter(sql, sqlConn);
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
DataTable dt=new DataTable();
sqlDA.Fill(dt);

List<Model.TicketInfo> list = new List<Model.TicketInfo>();
foreach (DataRow row in dt.Rows)
{
Model.TicketInfo t = new Model.TicketInfo();
t.FlightNo=(string)row["FlightNo"];
t.FromCity=(string)row["FromCity"];
t.ToCity = (string)row["ToCity"];
t.LeaveTime=(string)row["LeaveTime"];
t.SecondSeatPrice = Convert.ToString( row["SecondSeatPrice"]);
t.FirstSeatPrice = Convert.ToString(row["FirstSeatPrice"]);
t.SecondSeatCount = Convert.ToInt32(row["SecondSeatCount"]);
t.FirstSeatCount = Convert.ToInt32(row["FirstSeatCount"]);
list.Add(t);
}
sqlConn.Close();
return list;
}

private void ListForm_Load(object sender, EventArgs e)
{
datagridview.AutoGenerateColumns = false;
datagridview.DataSource = null;
datagridview.DataSource = BLL.TicketInfo.GetTicketsAllInfo();
}

[无心雨云]

太阳生你的人

[指间的风]

大家要注意个人的素质以及修养的培养。

[lihualiang925428]

在窗体中把输入框的内容 显示到DataGridView 不同过数据库做（我窗体中的数据和数据库没有关系）！怎么样才能 把自定义的集合绑定到 DataGridView中显示！谢谢！