判断是否存在某表的某个字段代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】判断是否存在某表的某个字段
作者:Dezai.CN / 发布于2011/7/8/ 419
<div>"csharp color1"><font color="#808080">/// <summary></font>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp color1"><font color="#808080">/// 判断是否存在某表的某个字段</font></td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp color1"><font color="#808080">/// </summary></font></td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp color1"><font color="#808080">/// <param name="tableName">表名称</param></font></td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp color1"><font color="#808080">/// <param name="columnName">列名称</param></font></td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp color1"><font color="#808080">/// <returns>是否存在</returns></font></td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp keyword"><strong><font color="#006699">public</font></strong> "csharp keyword"><strong><font color="#006699">static</font></strong> "csharp keyword"><strong><font color="#006699">bool</font></strong> "csharp plain">ColumnExists("csharp keyword"><strong><font color="#006699">string</font></strong> "csharp plain">tableName, "csharp keyword"><strong><font color="#006699">string</font></strong> "csharp plain">columnName)</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp plain">{</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp keyword"><strong><font color="#006699">string</font></strong> "csharp plain">sql = "csharp string"><font color="#0000ff">"select count(1) from syscolumns where [id]=object_id('"</font> "csharp plain">+ tableName + "csharp string"><font color="#0000ff">"') and [name]='"</font> "csharp plain">+ columnName + "csharp string"><font color="#0000ff">"'"</font>"csharp plain">;</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp keyword"><strong><font color="#006699">object</font></strong> "csharp plain">res = GetSingle(sql);</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp keyword"><strong><font color="#006699">if</font></strong> "csharp plain">(res == "csharp keyword"><strong><font color="#006699">null</font></strong>"csharp plain">)</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp plain">{</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp keyword"><strong><font color="#006699">return</font></strong> "csharp keyword"><strong><font color="#006699">false</font></strong>"csharp plain">;</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp plain">}</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp keyword"><strong><font color="#006699">return</font></strong> "csharp plain">Convert.ToInt32(res) > 0;</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="content">"csharp plain">}</td>
        </tr>
    </tbody>
</table>
</div>
</div>
试试其它关键字
　否存在某表的某个字段　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)