ASP操作SQL模糊查找

最新推荐文章于 2023-04-22 16:35:30 发布

C979170768

最新推荐文章于 2023-04-22 16:35:30 发布

阅读量763

点赞数

文章标签： asp sql table security string server

本文链接：https://blog.csdn.net/C979170768/article/details/6806673

版权

bool findtrue = false;
        SqlConnection con = new SqlConnection("server=.;database=tongxunlu;integrated security=true");
        GridView1.Visible = false;
        SqlCommand cmd = new SqlCommand("select * from newsmessages", con);

        int i1 = findtxt.Text.Trim().Length;    //取当前用用户输入的字符的长度
        con.Open();
        string[] sk = str.Split(new char[] { ',' });

        int sum = 0;
        SqlDataReader myreader;
        myreader = cmd.ExecuteReader();
        while (myreader.Read())
        {
            sum = 0;
            for (int bai = 0; bai < sk.Length; bai++)
            {
                if (sum < sk.Length && sk[sum] != "")     //如果不为空就执行
                {
                            for (int i = 0; i <= myreader[sk[sum]].ToString().Trim().Length - i1; i++)
                            {
                                if (myreader[sk[sum]].ToString().Trim().Substring(i, i1) == findtxt.Text.Trim())
                                {
                                    Table table = new Table();
                                    for (int m = 0; m < 1; m++)
                                    {
                                        TableRow row = new TableRow();
                                        for (int j = 1; j <= 6; j++)
                                        {
                                            TableCell cell = new TableCell();
                                            cell.Text = myreader[j].ToString();
                                            cell.Width = 100;
                                            if (j == 6)
                                                cell.Width = 400;
                                            row.Cells.Add(cell);
                                        }
                                        table.Rows.Add(row);
                                    }
                                    table.Width = 900;
                                    table.CellSpacing = 0;
                                    table.CellPadding = 10;
                                    this.div1.Controls.Add(table);
                                    findtrue = true;
                                    break;

                                }
                            }
                            sum++;             //取下一个用户设置的字段进行匹配
                            if (findtrue)   判断是否已经找到了记录
                            {
                                sum = 0;           //二级跳转如果找到了就跳出去
                                findtrue = false;
                                break;

                            }
                }
                else
                    break;
            }
        }
    }