62,041
社区成员
发帖
与我相关
我的任务
分享
Label2.Text = selShow.Items[selShow.SelectedIndex].Text;//取文本
<select id="selShow" runat="server">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
Label2.Text = selShow.Value.ToString();//取值
using System.Data.SqlClient;
private void GetStoredProceduresList()
{
string sql = "select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsProcedure') = 1 order by name";
string connStr = @"Data Source=(local);Initial Catalog=mydatabase; Integrated Security=True; Connection Timeout=1;";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
try
{
conn.Open();
using (SqlDataReader MyReader = cmd.ExecuteReader())
{
while (MyReader.Read())
{
//Get stored procedure name
this.listBox1.Items.Add(MyReader[0].ToString());
}
}
}
finally
{
conn.Close();
}
}
using System.Data.SqlClient;
private void GetArguments()
{
string connStr = @"Data Source=(local);Initial Catalog=mydatabase; Integrated Security=True; Connection Timeout=1;";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "mystoredprocedurename";
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
SqlCommandBuilder.DeriveParameters(cmd);
foreach (SqlParameter var in cmd.Parameters)
{
if (cmd.Parameters.IndexOf(var) == 0) continue;//Skip return value
MessageBox.Show((String.Format("Param: {0}{1}Type: {2}{1}Direction: {3}",
var.ParameterName,
Environment.NewLine,
var.SqlDbType.ToString(),
var.Direction.ToString())));
}
}
finally
{
conn.Close();
}
}
lblResult.Text = Select1.Items[Select1.SelectedIndex].Text;
DropDownList1.SelectedItem.Text;//可以取到你想要的值。
//但如果用html控件,不行,只能取Value,把value和Text设置一样的值不就行了吗?
<!--后台取值 : Select1.Value;-->
<select id="Select1" runat="server">
<option value="值1">值1</option>
<option value="值2">值2</option>
</select>