Thanks for your replying. Maybe, you misunderstood my idea. It mean that I want to insert "" tag into Datagrid to running auto all rows following up to. Please help me, thanks a lot.

I am designing a webpage to show all data after scrolling auto. I choose datagrid to show data but I do not know how to scroll all rows of datagrid that freezes it's header (scrolling from down to up like marquee tag in HTML).Please give me some advices

ok, I show all code again after editing CREATE trigger In_LoaiDG1 on KhaoSat_LoaiDG1 for insert,update as declare @NgayDG smalldatetime declare @MaLoaiTT int Select @MaLoaiTT=MaLoaiTT,@NgayDG=NgayDG from inserted if exists (Select count(*) from KhaoSat_LoaiDG1 where KhaoSat_LoaiDG1.MaLoaiTT=@MaLoaiTT and KhaoSat_LoaiDG1.NgayDG=@NgayDG) begin rollback transaction update KhaoSat_LoaiDG1 set Muc1=Muc1+1 where MaLoaiTT=@MaLoaiTT and NgayDG=@NgayDG end else insert into KhaoSat_LoaiDG1(MaLoaiTT,Muc1,NgayDG) values (@MaLoaiTT,1,@NgayDG) Update is ok but not insert.I do not know why, please help me.

thanks for answering me. My idea want to update or insert "Levels" fields, @id do not primary keys, it is a foreign keys form other table. I'm a new database studying, please help me.

I have a issue when I create a trigger for insert or update Create trigger In_Name on CheckStatus for insert, update as declare @id int Select @id=id from inserted where id=@id if exists (Select * from CheckStatus where id=@id) begin rollback transaction update CheckStatus Set levels=levels+1 where id=@id end else insert into CheckStatus (id,levels) values (@id,1) But the trigger do not execute my opinion (I want to update "levels" when id field exists, inversely inserting id and levels) Please, giving a hand, thanks a lot

thanks for your answer a lot

I have a issue. I want to get the value of label control inside datagrid. I show my code

<%#getCount()%>

I want to get the value of "lblTen" control when I click image button "cmdMuc1". please people help me. Thanks a lot

Please kindly help me a question : How to load dropdownlist inside Datalist in edit mode (c#)? , and get Selectedvalue ?

I try... Dataview dv=new Dataview(TableTemp); dv.sort="order by Numbercurrent desc"; Error message Numbercurrent field no exist ? Please help me solve my problem

My code is.... DataTable TableTemp=new DataTable(); if (dt.Rows.Count>0) { TableTemp.Columns.Add("Name"); TableTemp.Columns.Add("Send_date"); TableTemp.Columns.Add("Numbercurrent"); for(int iCounter=0;iCounter<dt.rows.count;icounter++)> { //Dua DL vao Table DataRow row=TableTemp.NewRow(); row["Name"]=dt.Rows[iCounter]["Name"]; row["Send_date"]=dt.Rows[iCounter]["Send_date"]; row["Numbercurrent"] =xl.Checkdate(DateTime.Parse(dt.Rows[iCounter]["Send_date"].ToString(),DateTime.Now); TableTemp.Rows.Add(row); } } I want to create Datatable sorted by Numbercurrent but error message Numbercurrent field not exist.... DataTable dtsort = TableTemp.Clone(); foreach (DataRow dr in TableTemp.Select("", "order by Numbercurrent Desc")) { dtsort.ImportRow(dr); } Please help me solve my problem

PInvokeStackImbalance was detected Message: A call to PInvoke function 'XPExplorerBar!XPExplorerBar.NativeMethods::LoadBitmap ' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature.