七仔大哥,,,我现在要用vs2005+mappoint+c#做个最简单的输入地址显示地图。windos mobile的。请假大哥,到底要如何做呢?给点思路和见解。由于初次使用c#和地图。。好多不知道如何下手,,谢谢大哥了。
解决方案 »
- C#下用DirectShow做视频播放怎么优化画面质量?
- winform 多线程
- listview填充数据的问题
- 在C#程序中怎么自动获取VC++的安装路径,然后调用VC++应用程序
- 未将对象引用设置到对象的实例是怎么回事啊?
- 如何使用System.Timers.Timer控制WEB页面每N秒刷新一次。
- treeView中的节点太长了,如何让它多行显示?在线等!
- 怎么比较快速的确定客户端(WinForm)与服务器端的WebService连接且通,在线等!!!
- 关于timer,为什么会出现不停的调用子过程?
- 如何向指定路径的文件里写入数据?
- C#中winsock的问题
- 有关C#读写XML的高难度问题,急!
//数据绑定 private void InitData()
{
string sqlselect = "";
XmlDocument document = new XmlDocument();
document.Load(Server.MapPath("BannerList.xml"));
XmlNodeList xn = document.SelectNodes("BannerList/item");
string selch = "";selch = ddlchannel.SelectedItem.Value;
if ( ddlchannel.SelectedItem.Value != "-1")
{
sqlselect = "select picid,picdiscription,piclink,picname,uploaddatetime,picchannel,picorder,isenjoin,banner,bannercode from flash where bannercode ='" + selch + " ' order by banner,picorder asc,picid desc";
}
else
{
sqlselect = "select picid,picdiscription,piclink,picname,uploaddatetime,picchannel,picorder,isenjoin,banner,bannercode from flash order by banner,picorder asc,picid desc";
}
string sqlselectnum = "select * from FlashItemNum";
using (scn = new SqlConnection())
{
scn.ConnectionString = connectionstring;
scn.Open();
using ( sda = new SqlDataAdapter())
{
sda.SelectCommand = scn.CreateCommand();
sda.SelectCommand.CommandType = CommandType.Text;
sda.SelectCommand.CommandText = sqlselect;
sda.SelectCommand.ExecuteNonQuery();
ds = new DataSet();
sda.Fill(ds,"list");
gvFlashList.DataKeyNames = new string[] { "picid" };
gvFlashList.DataSource = ds.Tables["list"];
gvFlashList.DataBind();
Label1.Text = "共" + ds.Tables[0].Rows.Count.ToString()+ "条,共" + gvFlashList.PageCount.ToString() + "页,当前第"+Convert.ToString(gvFlashList.PageIndex+1)+"页";
for ( int j=0; j<gvFlashList.Rows.Count; j++)
{
for (int i = 0; i <= 50; i++)
((DropDownList)gvFlashList.Rows[j].FindControl("ddlorder")).Items.Add(new ListItem(i.ToString(), i.ToString()));
((DropDownList)gvFlashList.Rows[j].FindControl("ddlorder")).SelectedIndex = Convert.ToInt32(ds.Tables[0].Rows[j]["picorder"]);
((DropDownList)gvFlashList.Rows[j].FindControl("ddlorder")).Visible = false;
for ( int k =0; k< xn.Count; k++)
{
((System.Web.UI.HtmlControls.HtmlSelect)gvFlashList.Rows[j].FindControl("selcode")).Items.Add(new ListItem(xn.Item(k).SelectSingleNode("option").InnerText, xn.Item(k).SelectSingleNode("option").Attributes["values"].Value.ToString()));
}
foreach ( ListItem li in ((System.Web.UI.HtmlControls.HtmlSelect)gvFlashList.Rows[j].FindControl("selcode")).Items)
{
if ( li.Value == ds.Tables[0].Rows[j]["bannercode"].ToString().Trim())
{
li.Selected = true;
}
}
((System.Web.UI.HtmlControls.HtmlSelect)gvFlashList.Rows[j].FindControl("selcode")).Visible = false;
if (((LinkButton)gvFlashList.Rows[j].FindControl("lnkbtn")).Text == "启用")
{
gvFlashList.Rows[j].Attributes.Add("style","background:#aaaaaa;");
((LinkButton)gvFlashList.Rows[j].Cells[5].Controls[0]).Enabled = false;
}
}
sda.SelectCommand.CommandText = sqlselectnum;
sda.SelectCommand.ExecuteNonQuery();
sda.Fill(ds,"num");
itemnum.Value = ds.Tables["num"].Rows[0]["itemnum"].ToString();
}
}
} //编辑
protected void gvFlashList_RowEditing(object sender, GridViewEditEventArgs e)
{
gvFlashList.EditIndex = e.NewEditIndex;
InitData();
((DropDownList)gvFlashList.Rows[e.NewEditIndex].FindControl("ddlorder")).Visible = true;
((System.Web.UI.HtmlControls.HtmlGenericControl)gvFlashList.Rows[e.NewEditIndex].FindControl("spanorderid")).Visible = false;
((LinkButton)gvFlashList.Rows[e.NewEditIndex].FindControl("lnkbtn")).Visible = false;
((System.Web.UI.HtmlControls.HtmlSelect)gvFlashList.Rows[e.NewEditIndex].FindControl("selcode")).Visible = true;
((System.Web.UI.HtmlControls.HtmlGenericControl)gvFlashList.Rows[e.NewEditIndex].FindControl("lblcode")).Visible = false; } //取消编辑
protected void gvFlashList_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvFlashList.EditIndex = -1;
InitData();
((DropDownList)gvFlashList.Rows[e.RowIndex].FindControl("ddlorder")).Visible = false;
((System.Web.UI.HtmlControls.HtmlGenericControl)gvFlashList.Rows[e.RowIndex].FindControl("spanorderid")).Visible = true;
((LinkButton)gvFlashList.Rows[e.RowIndex].FindControl("lnkbtn")).Visible = true;
((System.Web.UI.HtmlControls.HtmlSelect)gvFlashList.Rows[e.RowIndex].FindControl("selcode")).Visible = false;
((System.Web.UI.HtmlControls.HtmlGenericControl)gvFlashList.Rows[e.RowIndex].FindControl("lblcode")).Visible = true; } //更新
protected void gvFlashList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string sqlupdate = "update flash_upload set picdiscription='" + ((TextBox)gvFlashList.Rows[e.RowIndex].Cells[1].Controls[0]).Text + "',piclink='" + ((TextBox)gvFlashList.Rows[e.RowIndex].Cells[2].Controls[0]).Text + "',picorder=" + ((DropDownList)gvFlashList.Rows[e.RowIndex].FindControl("ddlorder")).Items[((DropDownList)gvFlashList.Rows[e.RowIndex].FindControl("ddlorder")).SelectedIndex].Value + ",banner='" + ((System.Web.UI.HtmlControls.HtmlSelect)gvFlashList.Rows[e.RowIndex].FindControl("selcode")).Value.ToString() + "' where picid=" + gvFlashList.DataKeys[e.RowIndex].Value;
int updnum;
using ( scn = new SqlConnection())
{
scn.ConnectionString = connectionstring;
scn.Open();
using ( sda = new SqlDataAdapter())
{
sda.UpdateCommand = scn.CreateCommand();
sda.UpdateCommand.CommandType = CommandType.Text;
sda.UpdateCommand.CommandText = sqlupdate;
updnum = sda.UpdateCommand.ExecuteNonQuery();
}
}
if ( updnum > 0)
{
gvFlashList.EditIndex = -1;
Page.ClientScript.RegisterStartupScript(Page.GetType(),"","<script>alert(\"更新成功!\");</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(),"","<script>alert(\"更新失败!\");</script>");
}
InitData();
}