62,266
社区成员
发帖
与我相关
我的任务
分享protected void Button1_Click1(object sender, EventArgs e)
{
System.Threading.Thread.Sleep(3000);
string connstr=WebConfigurationManager.ConnectionStrings["mingcai_user_conn"].ConnectionString;
SqlConnection conn = new SqlConnection(connstr);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("o_income", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Tname", 0);
cmd.Parameters.AddWithValue("@userId", "9a23d3d4-c541-4d5b-9faa-f9a8cb10d505");
cmd.Parameters.AddWithValue("@inname", "哈哈");
cmd.Parameters.AddWithValue("@tmoney", "1234567");
cmd.Parameters.AddWithValue("@inwhere", "小金库");
cmd.Parameters.AddWithValue("@tdate", "2012-7-8");
cmd.Parameters.AddWithValue("@mood", "shuang");
cmd.Parameters.AddWithValue("@remark", "ceshi");
cmd.ExecuteNonQuery();
GridView1.DataBind();
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource2">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="userid" HeaderText="userid"
SortExpression="userid" />
<asp:BoundField DataField="in_name" HeaderText="in_name"
SortExpression="in_name" />
<asp:BoundField DataField="tmoney" HeaderText="tmoney"
SortExpression="tmoney" />
<asp:BoundField DataField="inwhere" HeaderText="inwhere"
SortExpression="inwhere" />
<asp:BoundField DataField="tdate" HeaderText="tdate" SortExpression="tdate" />
<asp:BoundField DataField="mood" HeaderText="mood" SortExpression="mood" />
<asp:BoundField DataField="remark" HeaderText="remark"
SortExpression="remark" />
<asp:BoundField DataField="insert_time" HeaderText="insert_time"
SortExpression="insert_time" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="Data Source=DEVELOP-SERVER\OCHENGSHI;Initial Catalog=mingcai_database1;User ID=mc_admin"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [income]">
</asp:SqlDataSource>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="Button1" EventName="click" />
<asp:AsyncPostBackTrigger ControlID="Button2" EventName="click" />
</Triggers>
</asp:UpdatePanel>
<asp:Button ID="Button1" runat="server" Text="Button"
onclick="Button1_Click1" />
<asp:Button ID="Button2"
runat="server" Text="取消" OnClientClick="abortTask()" />
<script type="text/javascript">
function abortTask() {
var obj = Sys.WebForms.PageRequestManager.getInstance();
if (obj.get_isInAsyncPostBack())
obj.abortPostBack();
alert("终止!");
}
</script>