110,538
社区成员
发帖
与我相关
我的任务
分享
private void DataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string sql = "select* from s;";
string constructorString = "Dsn=学生信息;uid=root";
using (OdbcConnection conn = new OdbcConnection(constructorString))
{
OdbcDataAdapter oda = new OdbcDataAdapter(sql, conn);
DataSet ds = new DataSet();
oda.Fill(ds);
dg1.ItemsSource = ds.Tables[0].DefaultView;
}
}
private void Button_Click_Serch(object sender, RoutedEventArgs e)
{
string constructorString = "Dsn=学生信息;uid=root";
OdbcConnection myConnnect = new OdbcConnection(constructorString);
myConnnect.Open();
if (string.IsNullOrWhiteSpace(STUDENTNO.Text))
{
string sql = "select* from s";
DataSet dataSet = new DataSet();
OdbcDataAdapter odbcDataAdapter = new OdbcDataAdapter(sql, myConnnect);
odbcDataAdapter.Fill(dataSet, "s");
DataView dataView = new DataView(dataSet.Tables["s"]);
dataGrid1.ItemsSource = dataView;
}
else
{
int i = Convert.ToInt32(STUDENTNO.Text);
string sql = "select* from s where SNO=" + i + ";";
DataSet dataSet = new DataSet();
OdbcDataAdapter odbcDataAdapter = new OdbcDataAdapter(sql, myConnnect);
odbcDataAdapter.Fill(dataSet, "s");
DataView dataView = new DataView(dataSet.Tables["s"]);
dataGrid1.ItemsSource = dataView;
}
}
<DataGrid Name="dataGrid1" ItemsSource="{Binding}" AutoGenerateColumns="False" HorizontalAlignment="Left" Height="163" Margin="580,426,0,0" VerticalAlignment="Top" Width="439" Loaded="Button_Click_Serch" >
<DataGrid.Columns>
<DataGridTextColumn Header="SNO" Width="100" Binding="{Binding Path=SNO,Mode=OneWay}"/>
<DataGridTextColumn Header="SNAME" Width="100" Binding="{Binding Path=SNAME,Mode=OneWay}" />
<DataGridTextColumn Header="SAGE" Width="100" Binding="{Binding Path=SAGE,Mode=OneWay}"/>
<DataGridTextColumn Header="SDEPT" Width="100" Binding="{Binding Path=SDEPT,Mode=OneWay}"/>
</DataGrid.Columns>
</DataGrid>