ÎÒ³õѧC#ÓкܶණÎ÷²»Ã÷°×
ÔÚASP.NET 2.0ÖÐÒªÔÚÍøÒ³ÀïÓñí¸ñÏÔʾ²éѯ½á¹ûºÜ¼òµ¥£¬Ìí¼ÓÊý¾ÝÔ´SqlDataSource1ºÍGridView1,È»ºó°ÑGridView1µÄÊý¾ÝÔ´ÉèÖóÉSqlDataSource1¾ÍÐÐÁË¡£
µ«ÊÇÎÒÐèÒª°ÑÒ»Ìõ²éѯ½á¹ûÖеö×ֶα£´æµ½ Session À¸ÃÔõôʵÏÖÄØ£¿
ÎÒµÄVS2005¹¤¾ßÀ¸ÖÐÊý¾ÝÄÇÒ»×éûÓÐ SqlDataAdapter £¬Ò²Ã ......
ÎÒÏÈ´´½¨ÁËÓÐÒ»¸ö´°Ìå DATA
È»ºóÔÚÏÂÃæ´´½¨ÁËÒ»¸ö.csÎļþ
data.cs
ÀïÃæÊÇÊý¾ÝÁ´½Ó
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
namespace DAL
{
public class DB:System.Web.UI. ......
ÎÒÏëÓÃC#¿ª·¢Ò»¸ömysqlͼÐλ¯¹¤¾ß£¬¾ÍÏñNavicat for MySQLÒ»Ñù£¬ÎÊÏ£¬Õâ¸ö³ÌÐòÔõôÑù¸úmysqlÊý¾Ý¿â½øÐÐͨÐÅ£¿»òÕß˵£¬³ÌÐòÔõôÑùÁгömysqlµÄdatabase£¬tableµÈµÈÐÅÏ¢£¿¾ÍÏñÕâÑù£º
-test
+±í
ÊÓͼ
º¯Êý
ʼþ
+mysql
+info
SQL code:
show databases
show tables
desc tabl ......
±¾²ËÄñÔÚÁ·Ï°Ê¹ÓÃvs2005¿ª·¢oracle10gÊý¾Ý¿âʱ£¬³öÏÖÏÂÃæµÄ´íÎ󣬴Óû½Ó´¥¹ýorcale£¬Ï£Íû¸÷λ´óÏÀ°ïСµÜ½â´ðÒɻ󡫡«Ð»Ð»£¡
µ±"select * from companyinform"ȱÉÙ¡°;¡±Ê±£¬´íÎóÌáʾÈçÏÂͼ£º
PS£ºoracleÊý¾Ý¿âºÍvs2005¶¼×°ÔÚͬһ·þÎñÆ÷ÉÏ£¬·þÎñÆ÷win2003SP2
Ï£ÍûºÃÐÄÈ˰ïÐÂÊÖÏ¡«¡«
select * from dbo.compa ......
±¾È˳õѧc#,Á¬accessʱÓöµ½ÁËÒ»¸öСÎÊÌ⣬´úÂëÈçÏÂ
String connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sql1.mdb";
String sql = @"select * from table where name = 'aaa'";
OleDbConnection conn = new OleDbConnection(con ......
ÈçÏÂ語¾ä:
select sid1,sid2 from student where sname='zhang'
ÎÒÓÃC#×ö²é詢,ÔõôÔÚ³ÌÐòÖÐʹÓúͽÓÊÜsid1ºÍsid2 µÄÖµ?
當ǰÎÒÓöµ½µÄ²é詢,Ö»·µ»ØÒ»ÐÐ記錄,Ï£ÍûÔÚC#ÖÐ對±È²é詢³öµÄ數×Ö´óС,´Ë時該ÔõôÔÚ¶¨義 ......