锘??xml version="1.0" encoding="utf-8" standalone="yes"?>
1:灞鏁版嵁緋葷粺鐢卞師鏉ョ殑.net2.0鍗囩駭涓?/span>.net4.0
2:欏圭洰緙栬瘧鏃剁殑鐩爣騫沖彴鏀逛負x86
3:System.Data.SQLite.dll鍥犱負鍖哄垎32 64 浣嶈繕鏈?/span>for x86鐨勭増鏈?/span> 鐩墠鐢?/span>for x86鐗堟湰 1.0.76.0
4錛氱敱姝や駭鐢熺殑闂錛?/span>
姝ゆ柟娉曟樉寮忎嬌鐢ㄧ殑 CAS 絳栫暐宸茶 .NET Framework 寮冪敤銆傝嫢瑕佸嚭浜庡吋瀹規у師鍥犺屽惎鐢?/span> CAS 絳栫暐錛岃浣跨敤 NetFx40_LegacySecurityPolicy 閰嶇疆寮鍏熾?/span>
婧愭枃妗?/span> <http://bbs.csdn.net/topics/370104103>
瑙e喅濡備笅錛?/p>
鎴戠殑欏圭洰鏄簲鐢ㄧ▼搴忥紝棣栧厛鏄湪app.config 鏂囦歡閲岄潰鏍硅妭鐐瑰姞鍏ワ細
<runtime>
<NetFx40_LegacySecurityPolicy enabled="true"/>
</runtime>
浠ヤ笂鍥涗釜姝ラ渚垮彲瑙e喅闂
<UserControl x:Class="OSSDOM.DataQuality.CommonSL.Control.SelectToMonth"
xmlns=" xmlns:x=" xmlns:d=" xmlns:mc=" mc:Ignorable="d"
d:DesignHeight="27" d:DesignWidth="220" x:Name="userControl">
<Grid x:Name="LayoutRoot" Background="White">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="60"/>
<ColumnDefinition Width="63"/>
<ColumnDefinition Width="15"/>
<ColumnDefinition Width="64"/>
<ColumnDefinition Width="15*"/>
</Grid.ColumnDefinitions>
<TextBlock Height="20" Margin="2,3,1,0" Name="title" HorizontalAlignment="Stretch" VerticalAlignment="Top" Text="{Binding SelectTitle, ElementName=userControl}" /> //榪欏潡鏄帶浠?/span>鍚嶇ОuserControl
<my:SelectToMonth Grid.Row="1" x:Name="緇撴潫鏃墮棿" SelectTitle="緇撴潫鏃墮棿" />
public static void GridViewToExcel(Stream myStream, DevExpress.XtraGrid.Views.Grid.GridView dataGridView1)
{
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
string str = "";
try
{
//鍐欐爣棰?nbsp;
for (int i = 1; i < dataGridView1.Columns.Count; i++)
{
if (!string.IsNullOrEmpty(dataGridView1.Columns[i].Caption))
{
if (i > 1)
{
str += "\t";
}
str += dataGridView1.Columns[i].Caption;
}
}
sw.WriteLine(str);
//鍐欏唴瀹?nbsp;
for (int j = 0; j < dataGridView1.RowCount; j++)
{
string tempStr = "";
for (int k = 1; k < dataGridView1.Columns.Count; k++)
{
if (!string.IsNullOrEmpty(dataGridView1.Columns[k].Caption))
{
if (k > 1)
{
tempStr += "\t";
}
tempStr += dataGridView1.GetRowCellValue(j, dataGridView1.Columns[k].FieldName);
}
}
sw.WriteLine(tempStr);
}
sw.Close();
myStream.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sw.Close();
myStream.Close();
}
}{
try
{
var itemCount = new List<int>();//鏁版嵁婧愭誨叡澶氬皯鏁版嵁鐨勬暣褰㈤摼琛?/span>
int pageCount = IDList.Count / dataGridPageSize; //璁$畻鍑烘誨叡澶氬皯欏?/span>
//
for (int i = 0; i < pageCount; i++)
{
itemCount.Add(i);
}
PagedCollectionView pcv = new PagedCollectionView(itemCount);//鍒涘緩PagedCollectionView
if (pcv != null)
{
pcv.PageSize = 1;//璁劇疆PagedCollectionView鐨勬瘡欏墊樉紺?/span>1鏉℃暟鎹紙铏氭嫙瀵瑰簲鐨勶紝涓轟簡鍜?/span>datagrid瀵瑰簲錛?/span>
dataPager1.PageSize = 1;//璁劇疆dataPager姣忛〉鏄劇ず1鏉℃暟鎹紙铏氭嫙瀵瑰簲鐨勶紝涓轟簡鍜?/span>datagrid瀵瑰簲錛?/span>
this.dataPager1.Source = pcv;//璁劇疆dataPager鐨勬暟鎹簮
}
}
catch (Exception ex) { MessageBox.Show(ex.Message + ex.StackTrace); }
}
//鏍規嵁欏電儲寮曞姩鎬佺粦瀹氭暟鎹簮
private void dataPager1_PageIndexChanged(object sender, EventArgs e)
{
int curPageIdx = dataPager1.PageIndex;
int skipData = curPageIdx * dataGridPageSize;
List<IDData> curBindingDataSource = ((from p in IDList select p).Skip(skipData).Take(dataGridPageSize)).ToList();
dataGrid1.ItemsSource = curBindingDataSource;
}