VB或C#的问题 [英] vb or c# questions

问题描述

我下载了一个vb文件.
此vb文件为50个美国创建表结构.

一些示例代码.

I download a vb file.
This vb file create the table structure for the 50 united states.

some example code.

usaStatesDataTable = New DataTable
            usaStatesDataTable.Columns.Add(STATE_ABBREVIATION_COL_NAME, Type.GetType("System.String"))
            usaStatesDataTable.Columns.Add(STATE_COL_NAME, Type.GetType("System.String"))
            usaStatesDataTable.Columns.Add(STATE_COL_NAME_UPPER, Type.GetType("System.String"))
            'TODO: Localization: US State names
            ' Add the states rows into the dataset.
            row = usaStatesDataTable.NewRow()
            row(STATE_ABBREVIATION_IDX) = "AK"
            row(STATE_IDX) = "Alaska"
            row(STATE_UPPER_IDX) = "ALASKA"
            usaStatesDataTable.Rows.Add(row)
            row = usaStatesDataTable.NewRow()
            row(STATE_ABBREVIATION_IDX) = "AL"
            row(STATE_IDX) = "Alabama"
            row(STATE_UPPER_IDX) = "ALABAMA"
            usaStatesDataTable.Rows.Add(row)
            row = usaStatesDataTable.NewRow()
            row(STATE_ABBREVIATION_IDX) = "AR"
            row(STATE_IDX) = "Arkansas"
            row(STATE_UPPER_IDX) = "ARKANSAS"
            usaStatesDataTable.Rows.Add(row)
            row = usaStatesDataTable.NewRow()
            row(STATE_ABBREVIATION_IDX) = "AZ"
            row(STATE_IDX) = "Arizona"
            row(STATE_UPPER_IDX) = "ARIZONA"
            usaStatesDataTable.Rows.Add(row)

如何访问此文件以填充下拉列表以显示所有状态.

How do I access this file to populate a drop down list to show all the states.

推荐答案

如果您在上面的代码中显示的DataTable被类公开了(通过属性，函数或字段)，那么您所要做的就是引用项目中的库(dll)或可执行文件(exe)，您可以像使用其他任何类型的文件一样使用它，然后在表前进行操作.
如果该结构仅在内部使用(私有等)，您可能会考虑重构代码并将所需的代码包装在自己的类中.

干杯，

Manfred

If the DataTable you have shown in your code above is exposed by a class (via property, function or field) then all you have to do is refernence the library (dll) or the executable (exe) in your project and you can use it like any other type and then get at the table.
If the structure is only used internally (private etc.) you might think about refactoring the code and wrap the code you''re after in an own class.

Cheers,

Manfred

将下拉菜单的DataSource属性设置为DataTable对象，然后适当地分配DisplayMember和ValueMember属性.

Set the dropdown''s DataSource property to your DataTable object, then assign the DisplayMember and ValueMember properties appropriately.

FYI ... about类
在Asp.Net 2.0中创建用于数据库操作的类文件 [

FYI...about Class
Creating Class File in Asp.Net 2.0 for Database Manipulations[^]

Like below

ClsStates objStates=new ClsStates();//Your class file
DataTable usaStatesDataTable = new DataTable();//Datatable
usaStatesDataTable = objStates.GetStates();//Your data in your class //Here GetStates() will be return your data as a Datatable which you have mentioned
ddlStates.DataSource = usaStatesDataTable;//Result datatable which contains data
ddlStates.DataValueField = "StateID";
ddlStates.DataTextField = "StateName"
ddlStates.DataBind();

这篇关于VB或C#的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！