110,567
社区成员
发帖
与我相关
我的任务
分享
<request>
<insert>
<fields>
<RepUser>
<RepID></RepID><!--主键-->
<OrgGrpID></OrgGrpID><!--所属部门-->
<Name></Name><!--名称-->
<Sex></Sex><!--性别-->
<LastName></LastName><!--姓-->
<FirstName></FirstName><!--名-->
<Country>0</Country><!--国家/地区-->
<ZipCode></ZipCode><!--邮编-->
<City></City><!--城市-->
<Street></Street><!--街道-->
<CountryCode></CountryCode><!--国家代码-->
<Tel1></Tel1><!--电话1-->
<Tel2></Tel2><!--电话2-->
<Fax></Fax><!--传真-->
<New></New><!--创建日期-->
<Upd></Upd><!--更新日期-->
<E-mail1></E-mail1><!--电子邮件-->
<TMRep></TMRep><!--TM用户-->
<LanguageNo></LanguageNo><!--语言编号-->
<E-mail2></E-mail2><!--电子邮件2-->
<E-mailPriv></E-mailPriv><!--私人电子邮件-->
<Type></Type><!--类型-->
<Inactive></Inactive><!--离职-->
<SuperiorID></SuperiorID><!--上级-->
<ExtSystem></ExtSystem><!--外部系统-->
<ExtKey></ExtKey><!--外部主键-->
<HierarchyCode></HierarchyCode><!--层次结构代码-->
<ApproverRole></ApproverRole><!--审批人角色-->
<RepProperty></RepProperty><!--销售属性-->
<Position></Position><!--岗位-->
</RepUser>
</fields>
</insert>
</request>
<request>
<update>
<tables>
<table tablename="RepUser"/>
</tables>
<condition>
<cond tablename="RepUser" fieldname="RepID" op="=" value="88"/>
</condition>
<fields>
<RepUser>
<RepID></RepID><!--主键-->
<OrgGrpID></OrgGrpID><!--所属部门-->
<Name></Name><!--名称-->
<Sex></Sex><!--性别-->
<LastName></LastName><!--姓-->
<FirstName></FirstName><!--名-->
...
</RepUser>
</fields>
</update>
</request>
namespace CRM_XML_Test
{
public partial class Receive : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
StreamReader reader = new StreamReader(Request.InputStream);
String xml = reader.ReadToEnd();
FileStream fs = new FileStream(Server.MapPath("test.xml"), FileMode.Create);
StreamWriter sw = new StreamWriter(fs);
sw.Write(xml);
sw.Close();
fs.Close();
Response.Write(xml);
}
}
}
namespace CRM_XML_Test
{
public partial class Receive : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
StreamReader reader = new StreamReader(Request.InputStream);
String xml = reader.ReadToEnd();
FileStream fs = new FileStream(Server.MapPath("test.xml"), FileMode.Create);
StreamWriter sw = new StreamWriter(fs);
sw.Write(xml);
sw.Close();
fs.Close();
Response.Write(xml);
}
}
}
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
s = reader[0].ToString().Trim();
}
}
finally
{
command.Dispose();
connection.Close();
}
}
改为
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
object obj = command.ExecuteScalar();
if (obj != null && !(obj is DBNull))
{
s = obj.ToString().Trim();
}
connection.Close();
}
另外,Receive.aspx这个页面的后台代码也贴过来看下