有C#小程序,购买了免费送你...
有没有C#版的...
请问有数据库文件吗?源码目录结构里面没有看到有数据库文件。...
怎么样才能有钱,下东西呢
好像是免费的吧<br/><br/>没钱就到后台去兑换或充值呗
我也想知道
<table class="t_table" cellspacing="1" cellpadding="4" style="width:98%;"><tr><td><font style="font-size: 12px">本文原创:<a href="http://www.tomstudio.cn/" target="_blank">涛涛工作室</a>,如若转载,请注明出处。谢谢合作!</font><br/><font style="font-size: 12px">1、数据库设计: information.mdb 在App_Data中,about表中含三个id,name,description三个字段;<br/>2、建立数据模型:UserModel.cs<br/> public class UserModel<br/> {<br/> public int id { get; set; }<br/> public string name { get; set; }<br/> public string description { get; set; }<br/> }<br/>3、建立Web service 名为InformationWebService.asmx,作为Silverlight与Access数据库互操作的桥梁;<br/>InformationWebService.asmx.cs中添加以下代码:<br/>using System.Data.OleDb; //引入该命名空间为了操作Access数据库<br/>.......<br/> /// InformationWebService 的摘要说明<br/> /// </summary><br/> [WebService(Namespace = "<a href="http://tempuri.org/" target="_blank"><font color="#810081">http://tempuri.org/</font></a>")]<br/> [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br/> [System.ComponentModel.ToolboxItem(false)]<br/> // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。<br/> // [System.Web.Script.Services.ScriptService]<br/> public class InformationWebService : System.Web.Services.WebService<br/> {<br/> [WebMethod] //获取数据表信息<br/> public List<UserModel> GetInfo()<br/> {<br/> List<UserModel> returnedValue = new List<UserModel>();<br/> OleDbCommand cmd = new OleDbCommand();<br/> SQLExcute("SELECT * from about order by id desc", cmd);<br/> OleDbDataAdapter da = new OleDbDataAdapter();<br/> da.SelectCommand = cmd;<br/> DataSet ds = new DataSet();<br/> da.Fill(ds);<br/> foreach (DataRow dr in ds.Tables[0].Rows)<br/> {<br/> UserModel tmp = new UserModel();<br/> tmp.id = Convert.ToInt32(dr[0]);<br/> tmp.name = Convert.ToString(dr[1]);<br/> tmp.description = Convert.ToString(dr[2]);<br/> returnedValue.Add(tmp);<br/> }<br/> return returnedValue;<br/> }<br/><br/> [WebMethod] //添加信息<br/> public void insert(string name, string description)<br/> {<br/> string sql = "insert into about(name,description) values('"+name+"','"+description+"')";<br/> SQLExcute(sql);<br/> }<br/><br/> //SQL的操作 本文原创:<a href="http://www.tomstudio.cn/" target="_blank"><font color="#810081">涛涛工作室</font></a>,如若转载,请注明出处。谢谢合作!<br/> private void SQLExcute(string SQLCmd)<br/> {<br/> string C + Server.MapPath(@"App_Data\information.mdb;");<br/> OleDbConnection conn = new OleDbConnection(ConnectionString);<br/> conn.Open();<br/> OleDbCommand cmd = new OleDbCommand();<br/> cmd.Connection = conn;<br/> cmd.CommandTimeout = 15;<br/> cmd.CommandType = CommandType.Text;<br/> cmd.CommandText = SQLCmd;<br/> cmd.ExecuteNonQuery();<br/> conn.Close();<br/> }<br/> //SQL的操作 SQLExcute的重构<br/> private void SQLExcute(string SQLCmd, OleDbCommand Cmd)<br/> {<br/> string C + Server.MapPath(@"App_Data\information.mdb;");<br/> OleDbCommand cmd = new OleDbCommand();<br/> OleDbConnection Conn = new OleDbConnection(ConnectionString);<br/> Conn.Open();<br/> Cmd.Connection = Conn;<br/> Cmd.CommandTimeout = 15;<br/> Cmd.CommandType = CommandType.Text;<br/> Cmd.CommandText = SQLCmd;<br/> Cmd.ExecuteNonQuery();<br/> Conn.Close();<br/> }<br/> }<br/>4、创建Silverlight客户端应用程序Page.xaml,先在Blend中设计好页面,然后在Visual C#中添加各事件的代码;其中按钮事件的添加不像普通Web页面中添加事件,要先在初始化页面时先声明这个按钮事件,对Web service中的数据操作的引用,使用的是WebServiceSoapClient、Completed、Async()三个语句进行引用; 具体如下:<br/>先引用Web service命名空间<br/>using SL1201.ServiceReference;<br/>.....<br/> int originalNum;//记录初始时表中的数据总数<br/> public Page()<br/> {<br/> InitializeComponent();<br/> addButton.Click += new RoutedEventHandler(addButton_Click); //添加按钮事件的声明<br/> ReWriteButton.Click+=new RoutedEventHandler(ReWriteButton_Click); //重写按钮事件的声明<br/> //调用Web service<br/> InformationWebServiceSoapClient client = new InformationWebServiceSoapClient();<br/> client.GetInfoCompleted += new EventHandler<GetInfoCompletedEventArgs>(client_GetInfoCompleted);<br/> client.GetInfoAsync();<br/> <br/> }<br/> /// <summary><br/> /// 清除留言<br/> /// </summary><br/> /// <param name="sender"></param><br/> /// <param name="e"></param><br/> void ReWriteButton_Click(object sender, RoutedEventArgs e)<br/> {<br/> xm.Text = "";<br/> jj.Text = ""; <br/> }<br/> void client_GetInfoCompleted(object sender, GetInfoCompletedEventArgs e)<br/> {<br/> userDataGrid.ItemsSource = e.Result;<br/> originalNum = e.Result.Count;<br/> info.Text = "共有留言" + originalNum.ToString()+"条,具体如下:";<br/> }<br/><br/> /// <summary><br/> /// 添加按钮事件<br/> /// </summary><br/> /// <param name="sender"></param><br/> /// <param name="e"></param><br/> void addButton_Click(object sender, RoutedEventArgs e)<br/> {<br/> if (xm.Text == "")<br/> {<br/> MessageBox.Show("请输入姓名!");<br/> }<br/> else if (jj.Text.Trim() == string.Empty)<br/> {<br/> MessageBox.Show("请输入留言内容!");<br/> }<br/> else<br/> {<br/> //调用Web service事件 <br/> InformationWebServiceSoapClient client = new InformationWebServiceSoapClient();<br/> client.insertCompleted+=new EventHandler<System.ComponentModel.AsyncCompletedEventArgs>(client_insertCompleted);<br/> client.insertAsync(xm.Text.ToString(),jj.Text.ToString());<br/> }<br/> }<br/> void client_insertCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e)<br/> {<br/> if (e.Error == null)<br/> {<br/> MessageBox.Show("添加成功!");<br/> //即时更新datagrid<br/> InformationWebServiceSoapClient client = new InformationWebServiceSoapClient();<br/> client.GetInfoCompleted += new EventHandler<GetInfoCompletedEventArgs>(client_GetInfoCompleted);<br/> client.GetInfoAsync();<br/> xm.Text = "";<br/> jj.Text = "";<br/> }<br/> else<br/> {<br/> MessageBox.Show(e.Error.ToString());<br/> }<br/> }<br/><br/>运行结果:<br/><br/><p align="center"><img src="http://www.tomstudio.cn/files/image/upImgFile/2009122192120704.jpg" border="0" onload="thumbImg(this)" /></p><p align="center">本文原创:<a href="http://www.tomstudio.cn/" target="_blank"><font color="#810081">涛涛工作室</font></a>,如若转载,请注明出处。谢谢合作!</p></font></td></tr><tr><td><br/></td></tr></table>
不错
顶