private void dgv_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
{
DataGridView dgv = (DataGridView)sender;//强制定义传输的对象为DataGridView
//显示行号的代码
using (SolidBrush b = new SolidBrush(dgv.RowHeadersDefaultCellStyle.ForeColor))
{
e.Graphics.DrawString(e.RowIndex.ToString(System.Globalization.CultureInfo.CurrentUICulture), e.InheritedRowStyle.Font, b, e.RowBounds.Location.X + dgv.RowHeadersWidth / 2, e.RowBounds.Location.Y + (e.RowBounds.Height - e.InheritedRowStyle.Font.GetHeight()) / 2);
}
//绘制彩色线条
Pen linePen;
switch(e.RowIndex%3)
{
case 0:
linePen = Pens.Blue;
break;
case 1:
linePen = Pens.Green;
break;
case 2:
linePen = Pens.Red;
break;
} int startX;
if(dgv.RowHeadersVisible)
{
startX=dgv.RowHeadersWidth;
}
else
{
startX=0;
}
int startY = e.RowBounds.Top + e.RowBounds.Height - 1;
int endX = startX + dgv.Columns.GetColumnsWidth(DataGridViewElementStates.Visible) - dgv.HorizontalScrollingOffset;
//e.Graphics.DrawLine(linePen, startX, startY, endX, startY);
//使用了未赋值的linepen?? }
{
DataGridView dgv = (DataGridView)sender;//强制定义传输的对象为DataGridView
//显示行号的代码
using (SolidBrush b = new SolidBrush(dgv.RowHeadersDefaultCellStyle.ForeColor))
{
e.Graphics.DrawString(e.RowIndex.ToString(System.Globalization.CultureInfo.CurrentUICulture), e.InheritedRowStyle.Font, b, e.RowBounds.Location.X + dgv.RowHeadersWidth / 2, e.RowBounds.Location.Y + (e.RowBounds.Height - e.InheritedRowStyle.Font.GetHeight()) / 2);
}
//绘制彩色线条
Pen linePen;
switch(e.RowIndex%3)
{
case 0:
linePen = Pens.Blue;
break;
case 1:
linePen = Pens.Green;
break;
case 2:
linePen = Pens.Red;
break;
} int startX;
if(dgv.RowHeadersVisible)
{
startX=dgv.RowHeadersWidth;
}
else
{
startX=0;
}
int startY = e.RowBounds.Top + e.RowBounds.Height - 1;
int endX = startX + dgv.Columns.GetColumnsWidth(DataGridViewElementStates.Visible) - dgv.HorizontalScrollingOffset;
//e.Graphics.DrawLine(linePen, startX, startY, endX, startY);
//使用了未赋值的linepen?? }
--新建一个测试数据库,并指定排序规则为Chinese_PRC_CI_AS
CREATE DATABASE TESTFT COLLATE Chinese_PRC_CI_AS
GO
USE TESTFT
GO
--新建全文目录TestCL,并将其置为默认
CREATE FULLTEXT CATALOG TestCL AS DEFAULT
GO--新建测试表
CREATE TABLE TB
(
ID INT IDENTITY,
Title VARCHAR(100),
Body VARCHAR(1000),
CONSTRAINT PK_TB PRIMARY KEY CLUSTERED (ID)
)
GO--在TB表的title和body列上创建全文索引
CREATE FULLTEXT INDEX ON TB (Title,Body) KEY INDEX PK_TB
GO--插入两行演示数据
INSERT TB(Title,Body) VALUES('艺术家评选','苍井空和小泽玛利亚是深受人民群众喜爱的著名艺术家')
INSERT TB(Title,Body) VALUES('给苍老师的一封信','宁夏固原有一位网友给敬爱的苍老师写了一封信')
GOOK,到目前为止,准备工作基本完成,下面开始查询
SQL code--例1:
SELECT * FROM TB WHERE CONTAINS(*,'小')
/*
ID Title Body
----------- ------------------------------ ------------------------------------------------------
(0 行受影响)
*/
SELECT * FROM TB WHERE CONTAINS(*,'小泽')
/*
ID Title Body
----------- ------------------------------ ------------------------------------------------------
1 艺术家评选 苍井空和小泽玛利亚是深受人民群众喜爱的著名艺术家(1 行受影响)
*/--例2:
SELECT * FROM TB WHERE CONTAINS(*,'苍')
/*
ID Title Body
----------- ------------------------------ ------------------------------------------------------
1 艺术家评选 苍井空和小泽玛利亚是深受人民群众喜爱的著名艺术家
(1 行受影响)
*/
SELECT * FROM TB WHERE CONTAINS(*,'苍老师')
/*
ID Title Body
----------- ------------------------------ ------------------------------------------------------
2 给苍老师的一封信 宁夏固原有一位网友给敬爱的苍老师写了一封信
(1 行受影响)
*/