ï¼1ï¼ ç¨çªä½çéææ¹æ³ä½ä¸ºæ¾ç¤ºçªä½å使ç¨çªä½åè½çå
¥å£
ä¸ä¸ªçªä½å¾å¾ä¼æ¾ç¤ºå
¶ä»çªä½ä»¥å®ç°ä¸å®çåè½ãéè¿å¨è¢«è°ç¨çªä½ä¸å®ç°ä¸ä¸ªéæå½æ°ä¾è°ç¨çªä½ä½¿ç¨å¯ä»¥ç®åçªä½é´ç交äºï¼éè½è¢«è°ç¨çªä½çæ°æ®ï¼ä»èå 强å°è£
ç¹æ§ã
å¦ä¸»çªä½ä¸ºFormMainï¼è¢«è°ç¨çªä½ä¸ºFormChildãå¨FormChildä¸å®ç°ä¸ä¸ªéææ¹æ³ï¼
Static void DoSomething()
{
new FormChild.ShowDialog();
//å®ç°åè½
//â¦
}
å¨ä¸»çªä½ä¸è°ç¨è¢«è°ç¨çªä½çDoSomething()æ¹æ³ï¼
FormChind.DoSomething();
è¿æ ·å°±å¯ä»¥æ¾ç¤ºè¢«è°ç¨çªä½å¹¶ç±è¢«è°ç¨çªä½æ§è¡é¢è®¾çåè½ï¼å¹¶ä¸è¯¥éæå½æ°å°è£
äºæé ååå§å被è°ç¨çªä½çé»è¾ãç¨åºçç»ææ´å æ¸
æ°ï¼ç±»çèè´£æ´å æç¡®ã
ï¼2ï¼ å¤æç¨æ·å¨å¯¹è¯æ¡ä¸ç¹å»çæé®
对è¯æ¡çShowDialogæ¹æ³ä¼è¿åDialogResultç±»åçè¿åå¼ãDialogResultæ¯æ举类åï¼éè¿æ£æ¥è¯¥æ举å¼ï¼å³å¯ç¥éç¨æ·æ¯éè¿åå»åªä¸ªæé®å
³é对è¯æ¡çã
ä¾å¦ï¼è¦æ£æµç¨æ·æ¯å¦æ¯åå»äºOKæé®ä»èå
³éæ件对è¯æ¡ï¼å¯ä»¥ä½¿ç¨å¦ä¸ä»£ç ï¼
if (this.openFileDialogPhoto.ShowDialog()==DialogResult.OK)
{
â¦
}
ï¼3ï¼ å°æ°æ®åºä¸è¯»åçç
§çæ件æ¾ç¤ºå¨æ§ä»¶ä¸
ä»æ°æ®åºä¸è¯»åç
§çï¼ç
§ççårow.phptoImageæ¯byte æ°ç»ç±»åãè¦å°ç
§çç´æ¥æ¾ç¤ºå¨æ§ä»¶ä¸ï¼èéå
åå¨å¨ç¡¬çä¸åè°å
¥æ§ä»¶æ¾ç¤ºï¼éè¦ä½¿ç¨MemoryStreamç±»ãå
·ä½æ¹æ³å¦ä¸ï¼
MemoryStream mstream;
if(row.photoImage.Length!=0)
{
mstream=new MemoryStream(row.photoImage);
this.picPhoto.Image= new Bitmap(mstream);
}
ï¼4ï¼ ä½¿ç¨ Command 对象ç ExecuteScalar æ¹æ³
ä¸è¬ä½¿ç¨ Command 对象ç ExecuteReader æ¹æ³æ¥å°æ°æ®åºçè¿åç»æä¿åå¨ DataReader ä¸ãå¦ä»¥ä¸ä»£ç æ示ï¼
dbReader = cmd.ExecuteReader()ï¼
ä½å¦æè¿åç»ææ¯å个æ éå¼ï¼å¦ä¸ä¸ªæ´æ°æä¸ä¸ªå符串ï¼åå¯ä»¥æ§è¡ Command 对象ç ExecuteScalar æ¹æ³ç´æ¥è·å该å¼ã
ç¼ç 示ä¾å¦ä¸ï¼
byte b;
b = (byte)cmd.ExecuteScalar();
ï¼5ï¼ ä¸º Command 对象添å åæ°ç两ç§æ¹æ³
è¿ä¸¤ç§æ¹æ³å
¶å®æ¯ Parameters 对象ç Add æ¹æ³ç两ç§åä½ã第ä¸ç§æ¹æ³æ¯è¾ç®åï¼å°±æ¯ç´æ¥ä½¿ç¨ Add æ¹æ³æ·»å åæ°ï¼å¹¶åæ¶æå®åæ°çç±»ååå¼ã代ç å¦ä¸ï¼
cmd.Parameters.Add("@EmpID",System.Data.SqlDbType.Int).Value = iEmpID;
å¦å¤ä¸ç§æ¹æ³æ¯è¾å¤æï¼å®éè¦å
声æä¸ä¸ª SqlParameter ç±»åç对象ï¼ç¶åä½¿ç¨ Add æ¹æ³æ·»å 该åæ°å¯¹è±¡ãè¿ç§æ¹æ³ä¾¿äºè°è¯ã代ç å¦ä¸ï¼
SqlParameter paramEmpID = new SqlParameter("@EmpID", System.Data.SqlDbType.Int);
paramEmpID.Value = strSelfIntro;
cmd.Parameters.Add(paramEmpID);
ï¼6ï¼ è§£å³Typed DataSetä¸ç©ºå段å¼çé®é¢
Typed DataSetå¯ä»¥å¤§å¤§æé«å¼åçæçãä½æ¯å¨æ个å段å¼ä¸ºç©ºçæ
åµä¸ï¼ä½¿ç¨Typed DataSet读å该å段ä¼å¼åç³»ç»å¼å¸¸ãè¦è§£å³è¿ä¸ªé®é¢æ两ç§æ¹æ³ï¼
1) å¨æ°æ®åºä¸ä¸ºææè¿è¡ä¸ºç©ºçå段设置缺çå¼
2) ä¿®æ¹VS.NETèªå¨çæçXSDæ件
å¨è¿éä»
ä»ç»ç¬¬äºç§æ¹æ³ã对äºå¼å¯ä»¥ä¸ºç©ºçå段ï¼XSDæ件ä¸åæ¥çæè¿°åºè¯¥ç±»ä¼¼å¦ä¸ä»£ç ï¼å
¶ä¸DeptNameãTitleåTelephoneå段å¨æ°æ®åºä¸å¯ä»¥ä¸ºç©ºå¼ï¼ï¼
<xs:elementname="Name"type="xs:string"/>
<xs:elementname="LoginName"type="xs:string"/>
<xs:elementname="Email"type="xs:string"/>
<xs:elementname="DeptName"type="xs:string"minOccurs="0"/>
<xs:elementname="Title"type="xs:string"minOccurs="0"/>
<xs:elementname="Telephone"
æç« åºå¤ï¼
http://www.diybl.com/course/4_webprogram/asp.net/netjs/2007921/72800.html