bindingNavigator 調整高度(圖片大小)

bindingNavigator 調整高度(圖片大小)

先要把bindingNavigator的 AutoSize 屬性，改為 False

才能調整高度

圖片大小，要再調整  ImageScalingSize ，才能調整大小

清空form上所有textbox的值

清空form上所有textbox的值

// 如果textbox沒放在其他容器內的話
foreach (Control obj in this.Controls)
            {
                if (obj.GetType() == typeof(TextBox))
                {
                    ((TextBox)obj).Text = "";
                }
            }

//如果有放在其他容器內的話
private void button1_Click(object sender, EventArgs e)
        {
         
            foreach (Control obj in this.Controls)
            {
                test(obj);
            }

        }



        private void test(Control controls)
        {
            if (controls.HasChildren)
            {
                foreach (Control control in controls.Controls)
                {
                    test(control);
                }
            }
            else
            {
                if (controls.GetType() == typeof(TextBox))
                {
                    ((TextBox)controls).Text = "";
                }
            }
        }

有母版的，但不一定是最好的解法，有查到更好的再更新 2015-03-05
foreach (Control obj in this.Master.FindControl("ContentPlaceHolder1").Controls)
                    {

                       if (obj.GetType() == typeof(Label))
                        {
                            if (((Label)obj).ID.ToString().Substring(0,12) == "lblmeetingmsg")
                            {
                                ((Label)obj).Text = "";
                            }

                        }

                    }

Master加了 Panel1就不行了，後來改成這樣就好了，好像用Panel1的方式比較好點

foreach (Control obj in this.Panel1.Controls)
                    {
                     if (obj.GetType() == typeof(Label))
                        {
                            if (((Label)obj).ID.ToString().Length > 12)
                            {
                                ((Label)obj).Text = "";
                            }

                        }

                        if (obj.GetType() == typeof(CheckBox))
                        {
                            ((CheckBox)obj).Checked = false;
                        }

                    }

前台 js
<script language="javascript" type="text/javascript">
function ClearAllTextBox() {
 var obj = window.document.forms[0];
 for (i = 0; i < obj.elements.length; i++) {
 var elem = obj.elements[i];
 if (elem) {
 if (elem.type == "text") {
 elem.value = "";
 }
 } 
 } 
 }
 </script>

DataReader 傳資料給 DataGridView

DataReader 傳資料給 DataGridView

Dim cn As New SqlConnection("server=wk-db;database=northwind;user id=sa;password=sa")
        Dim cmd As New SqlCommand("select * from products", cn)

        cn.Open()
        Dim dt As New DataTable
        Dim dr As SqlDataReader = cmd.ExecuteReader

        For i As Integer = 0 To dr.FieldCount - 1
            Dim col As New DataColumn(dr.GetName(i), dr.GetFieldType(i))
            dt.Columns.Add(col)
        Next


        Do While dr.Read
            Dim r As DataRow = dt.NewRow
            For i As Integer = 0 To dr.FieldCount - 1
                r(i) = dr(i)
            Next
            dt.Rows.Add(r)
        Loop

        DataGridView1.DataSource = dt