如何创建动态控件取决于db中的数字 [英] how to create dynamic controls depended on number from db

问题描述

你好



i希望创建一个动态控件，取决于价值来自dgh



这里是我的代码

 cn =  new  SqlConnection（ConfigurationManager.ConnectionStrings [  lap_connection]。ConnectionString）; 
 cmd =  new  SqlCommand（  SELECT COUNT （pat_id）AS patient_test FROM patient_test_data WHERE dbo.patient_test_data.test_date> =流延（GETDATE（）作为日期）和dbo.patient_test_data.pat_id = 4;，CN）; 
 cmd.CommandType = CommandType.Text; 
 cmd.Connection.Open（）; 
 dr = cmd.ExecuteReader（CommandBehavior.CloseConnection）; 
  while （dr.Read（））
 {
  int  number_test =  int  .Parse（dr [  patient_test< /跨度>]的ToString（））; 
  for （ int  number =  int  .Parse（dr [  patient_test]。ToString（））; number <  = number_test; number ++）
 {
 TextBox txt =  new  TextBox（）; 
  //   txt.Text = dr [Col1]。ToString（）;  
 TextBox txt2 =  new  TextBox（）; 
  //   txt2.Text = dr [Col2]。ToString（）;  
 TextBox txt3 =  new  TextBox（）; 
  //   txt3.Text = dr [Col3]。ToString（）;  
  this  .Controls.Add（txt）; 
  this  .Controls.Add（txt2）; 
  this  .Controls.Add（txt3）; 
} 
} 

但是我得到了错误我可以得到一些帮助PLZ以及如何从数据库插入这些动态控件

解决方案

报价/>
感谢：

textghox txt = new textghox（）;

什么是' textghox '？你的意思是 TextBox [ ^ ]？

使用 Page_init 获取回发中动态创建的控件的值。

查看此动态控制回发 [<后保留A HREF = http://stackoverflow.com/questions/15561183/dynamic-controls-disappear-after-postback/15561515#15561515 目标= _空白 标题= 新窗口> ^ ]

hello

i want to create a dynamic controls depended on value comes from dgh

here is my code

cn = new SqlConnection(ConfigurationManager.ConnectionStrings["lap_connection"].ConnectionString);
            cmd = new SqlCommand("SELECT COUNT( pat_id) AS patient_test FROM patient_test_data WHERE dbo.patient_test_data.test_date >= cast(getdate() as Date) AND dbo.patient_test_data.pat_id = 4;", cn);
            cmd.CommandType = CommandType.Text;
            cmd.Connection.Open();
            dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            while (dr.Read())
            {
                int number_test = int.Parse(dr["patient_test"].ToString());
                for (int number = int.Parse(dr["patient_test"].ToString()); number <= number_test; number++)
                {
                    TextBox txt = new TextBox();
                    //txt.Text = dr["Col1"].ToString();
                    TextBox txt2 = new TextBox();
                    //txt2.Text = dr["Col2"].ToString();
                    TextBox txt3 = new TextBox();
                    //txt3.Text = dr["Col3"].ToString();
                    this.Controls.Add(txt);
                    this.Controls.Add(txt2);
                    this.Controls.Add(txt3);
                }
            }

but i got error can i get some help plz and how to insert to database from those dynamic controls
thanks in advanced

解决方案

Quote:

textghox txt = new textghox();

What is a 'textghox'? Do you mean TextBox[^]?

use Page_init for getting the values of dynamic created controls in post back.
check this Dynamic controls retain after postback[^]

这篇关于如何创建动态控件取决于db中的数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！