在page页做的事情
1:你在page里面用DataRow把数据收集起来,做成table或者DataSet类似的数据容器
2:然后GetData objGetData = new GetData 调用GetData.add(Table DT),将这个容器传递过去
在中间层做的事情
1: 你的方法收集到这个数据容器后,将里面的数据字段读出,然后就可以传递给SqlParameterCollection再调一个存储过程,就行了。
1:你在page里面用DataRow把数据收集起来,做成table或者DataSet类似的数据容器
2:然后GetData objGetData = new GetData 调用GetData.add(Table DT),将这个容器传递过去
在中间层做的事情
1: 你的方法收集到这个数据容器后,将里面的数据字段读出,然后就可以传递给SqlParameterCollection再调一个存储过程,就行了。
//初始化DataSet
CityData objCityData = new CityData();
DataRow curRow = objCityData.Tables[CityData.CITY_TABLE].NewRow();
curRow[CityData.PROVINCE_ID] = this.dropProvince.SelectedValue;
curRow[CityData.CITY_NAME] = GlobalUtility.GetHtmlRender(this.txtCity.Text);
curRow[CityData.CITY_AREA] = GlobalUtility.GetHtmlRender(this.txtArea.Text);
curRow[CityData.CITY_TYPE] = this.dropCityType.SelectedValue;
objCityData.Tables[CityData.CITY_TABLE].Rows.Add(curRow); //构造CityFacade的objCityFacade对象(非static方法)
CityFacade objCityFacade = new CityFacade(); //调用objCityFacade.AddCity方法
returnValue = objCityFacade.AddCity(objCityData);
if (returnValue)
{
Response.Redirect("ListCity.aspx",false);
}
else
{
this.Label1.Visible = true;
this.Label1.Text = "录入数据有误,请核对重录。";
}
sqlInsertCmd.Connection = sqlConn;
sqlInsertCmd.CommandType = CommandType.StoredProcedure;
sqlInsertCmd.CommandText = "SPI_B_City"; SqlParameterCollection sqlParams = sqlInsertCmd.Parameters;
sqlParams.Add(new SqlParameter(CITY_ID,System.Data.SqlDbType.Char));
sqlParams.Add(new SqlParameter(CITY_NAME,System.Data.SqlDbType.VarChar));
sqlParams.Add(new SqlParameter(CITY_AREA,System.Data.SqlDbType.VarChar));
sqlParams.Add(new SqlParameter(CITY_TYPE,System.Data.SqlDbType.Int));
sqlParams.Add(new SqlParameter(PROVINCE_ID,System.Data.SqlDbType.Char));
sqlParams[CITY_ID].SourceColumn = CityData.CITY_ID;
sqlParams[CITY_NAME].SourceColumn = CityData.CITY_NAME;
sqlParams[CITY_AREA].SourceColumn = CityData.CITY_AREA;
sqlParams[CITY_TYPE].SourceColumn = CityData.CITY_TYPE;
sqlParams[PROVINCE_ID].SourceColumn = "Province_ID";
需要用到的东西就是 DataRow ,SqlParameterCollection,DataSet 当然方法有很多种
.
curRow[CityData.CITY_NAME] = GlobalUtility.GetHtmlRender(this.txtCity.Text);
curRow[CityData.CITY_AREA] = GlobalUtility.GetHtmlRender(this.txtArea.Text);
curRow[CityData.CITY_TYPE] = this.dropCityType.SelectedValue;
第一部分是web的,不过是c#的
工程名dataservice,类名adddata
public function add(byval mc as string,byval sex as string) as bool
dim conn as new adodb.connection
conn.execute("insert into table(mc,sex) values('"& mc &"','"& sex &"')")
....出错处理
....事务处理
end functionweb层,asp
<%
set obj=server.createobject("dataservice.adddata")
flag=obj.add('张三','男')
%>