SL调用web service插入数据，请大家看看，输入插入不进去！！！！

[jieyi1106]

Page.xaml 文件 ：

private void saveButton_Click(object sender, RoutedEventArgs e)
{
if (userName.Text.Trim() == string.Empty)
{
errMessage.Foreground = new SolidColorBrush(Colors.Red);
errMessage.Text = "请输入用户名";
errMessage.Visibility = Visibility.Visible;
return;
}
else
{
SilverService.UserManageSoapClient addInfo = new SilverlightApplication1.SilverService.UserManageSoapClient();
addInfo.CreateUserAsync(userName.Text);
addInfo.CreateUserCompleted += new EventHandler<SilverlightApplication1.SilverService.CreateUserCompletedEventArgs>(addInfo_CreateUserCompleted);


}
}
void addInfo_CreateUserCompleted(object sender, SilverlightApplication1.SilverService.CreateUserCompletedEventArgs e)
{

if (e.Error == null)
{
errMessage.Text = "创建成功";
errMessage.Foreground = new SolidColorBrush(Colors.Blue);
errMessage.Visibility = Visibility.Visible;
}
else
{
errMessage.Text = "创建成功";
errMessage.Foreground = new SolidColorBrush(Colors.Red);
errMessage.Visibility = Visibility.Visible;
}

}

web service 文件：
public bool CreateUser(string userName)
{
try
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.
ConnectionStrings["sqlConnectionString"].ToString();
conn.Open();
string sql = "INSERT INTO SilverDemo (UserName) VALUES ('" + userName.ToString() + "')";
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.ExecuteNonQuery();
conn.Close();
return true;
}
catch (Exception ex)
{
return false;
}
}

小弟刚接触SL，很多地方还不是很明白。
这段代码是我仿造网上查的资料 然后自己写的
到最后没报错，页面说 创建成功

但是数据库里并没有数据~ 因为小弟这里调试 说缺少一个什么 组建 所以调试不了
只有问大家了 哪里错了！！！！！！

[拉达曼迪斯II]

调式不了。 有无错误信息。
基本没有办法 。

[jv9]

1.先确认webservice可以正常通讯,注意跨域文件的webservice调用地址;

2.把这段代码放在page_load事件执行,让系统自动执行插入数据.

SilverService.UserManageSoapClient addInfo = new SilverlightApplication1.SilverService.UserManageSoapClient();
addInfo.CreateUserAsync(userName.Text);
addInfo.CreateUserCompleted += new EventHandler <SilverlightApplication1.SilverService.CreateUserCompletedEventArgs>(addInfo_CreateUserCompleted);

3.试着设置断点debug.

[踏雪听雨]

换成WCF试试

SL3可以使用RIA Service

[wenjianfu871125]

你先在web页面里把服务调通，看在web页面里能插数据不。很快就能解决。SL里面最好再加两个参数，System.ServiceModel.BasicHttpBinding，System.ServiceModel.EndpointAddress

[惜分飞-Tel:[phone]]

addInfo.CreateUserAsync(userName.Text);
addInfo.CreateUserCompleted += new EventHandler <SilverlightApplication1.SilverService.CreateUserCompletedEventArgs>(addInfo_CreateUserCompleted);
改为
addInfo.CreateUserCompleted += new EventHandler <SilverlightApplication1.SilverService.CreateUserCompletedEventArgs>(addInfo_CreateUserCompleted);
addInfo.CreateUserAsync(userName.Text);
两个顺序换下试试看
还有建议用linq to sql 很方便的
我也才开始学习这个，外面可以交流下