SqlConnection Cn = new  SqlConnection
                (System.Configuration.ConfigurationSettings.AppSettings.Get("Cnstr"));
         SqlDataAdapter SqlDa = new SqlDataAdapter("SELECT * FROM jobs",Cn);
         DataSet ds = new DataSet();
         SqlDa.Fill(ds);
         this.DataGrid1.DataSource = ds;
         this.DataGrid1.DataBind(); 

         string javaScript;
         javaScript = "<script language='javascript'>"; 
       
         javaScript+ = @"   
         function addrow()
         {
             var oRow = document.all(obs).insertRow(0);
             var oCell0 = oRow.insertCell();
             with(oCell0)
             {
                innerText = 'hello';               
             }
            var oCell1 = oRow.insertCell();
            with(oCell1)
            {
               innerText = 'Kitty';
            }
            var oCell2 = oRow.insertCell()
            with(oCell2)
            {
               innerText = 'Lvl';
               colSpan = '2';
            }              
         }
         addrow();
         ";
         javaScript = javaScript.Replace("obs","'" + this.DataGrid1.ClientID +"'");
         javaScript+ = "<";
         javaScript+ = @"/";
         javaScript+ = "script>";

         Page.RegisterStartupScript("ss",javaScript);


以上代码是对pubs数据库的操作
总体来说是用insertRow()insertCell()来进行的..
然后用with(oCell)来进行里面的样式控制..