c#¶ÁÈ¡accessÊý¾Ý¿â
´úÂëÈçÏ£º
OleDbDataAdapter da = new OleDbDataAdapter("Select * from Grade", objConnection);
DataSet ds = new DataSet();
DataTable myDataTable = ds.Tables["Grade"];
da.Fill(ds,"Grade");
foreach (DataRow myDataRow in myDataTable.Rows)
{
Console.WriteLine("Name = " + myDataRow["name"]);
Console.WriteLine("Sex = " + myDataRow["sex"]);
Console.WriteLine("Remark = " + myDataRow["remark"]);
Console.WriteLine("Grade = " + myDataRow["grade"]);
}
ÒÔÉÏÓï¾äÔÚÖ´Ðе½foreachµÄʱºò³öÁËÒ»¸öÒì³££¬ËµÊÇObject reference not set to an instance of an object.³ö´íµÄ´úÂëÊÇmyDtaTable.Rows.
·³Çë¸ßÈËÖ¸µã£¡
ÎÒ¾õµÃ¶ÔÄã×îºÃµÄ°ì·¨¾ÍÊǵ¥²½µ÷ÊÔ£¬¿´¿´Ã¿¸ö±äÁ¿ÊÇ·ñ¶¼ÓÐÖµ£¬ÊÇ·ñ¶¼ÊÇÔÚÒýÓõÄʱºòÒѾ´´½¨ÁË¡£Õâ¸öÒì³£»ù±¾ÉϾÍÊÇÄãÒýÓõĶÔÏóûÓд´½¨³öÀ´¡£
for(int i=1;i <=myDataTable.Rows.Count;i++)
{
Console.WriteLine("Name = " + myDataTable.Rows["name"]);
Console.WriteLine("Sex = " + myDataTable.Rows["sex"]);
Console.WriteLine("Remark = " + myDataTable.Rows["remark"]);
Console.WriteLine("Grade = " + myDataTable.Rows["grade"]);
}
lzÔÙÊÔÊÔ¿´¡£
Ïà¹ØÎÊ´ð£º
//C ½Ó¿Ú
extern "C"
{
TESSDLL_API int __cdecl GetTessText(const char *imagefile, char *text);
}
//ÎÒÔÚC#ÖÐÉùÃ÷
//µ÷ÓÃC DLL Öеĺ¯Êý
[DllImport("OCRapi.dll&quo ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......