asp.net ...帮助解决我的要求 [英] asp.net....help required to solve my requirement
问题描述
嗨.请帮帮我.我是初学者，需要帮助
我在数据库中有ID，主题，日期，附件.
我所做的是，我采用了一种使用连接，适配器命令的形式，并将记录插入数据库中，并在网格中显示该记录.
现在我的要求是，如果我们使用2个命令按钮，请在网格中进行编辑和删除，然后首先单击编辑"按钮.如何获取所选列的详细信息，并转到具有ID只读，主题----文本区域，日期，附件文件上传的另一页-在此屏幕中，特定的所选记录数据应在控件和如果需要的话，我可以在控件中编辑数据，然后放置一个更新按钮，当单击更新按钮时，应该对其进行更新.删除的情况相同.当我单击删除时，应删除该特定记录.您能否用2个简单的列显示这种情况.如果你有时间.我正在努力，但做得不好，而且我不知道如何进一步进行下去.
Hi. Please help me out. I am a beginner and I need help
I have id, subject, date, attachment in database.
What I''ve done is I have taken a form used connection, adapter command and inserted the record in the database and displayed the record in a grid.
Now my requirement is if we take 2 command buttons, edit and delete in the grid and first if we click on edit button; How can I get the details of that selected column and goto another page where there is ID readonly, subject----textarea, date, attachment-fileupload - and in this screen already that particular selected records data should be FILLED IN the controls and if needed then I can edit the data in the controls and then I place an update button and when the update button is clicked, it should be updated. The same case for delete. When I click on delete that particular record should be deleted. Can you show this scenario with 2 simple columns. If you have time. I am struggling but not getting it right and I don''t have any ideas how to proceed further.
<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/Admin/ADMINmaster.master" CodeFile="AddMeeting.aspx.cs" Inherits="Admin_AddMeeting" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<style type="text/css">
.style5
{
width: 101%;
}
.style12
{
width: 91px;
text-align: center;
}
.style17
{
width: 10px;
text-align: center;
}
.style20
{
width: 147px;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table class="style5">
<tr>
<td class="style20" colspan="2" align="center" >
<table align="center" width="898px" cellpadding="4" cellspacing="4" >
<tr>
<td colspan="5" style="text-align: center; font-weight: bold;" >
Add Meeting
</td>
</tr>
<%--<tr>
<td>
ID
</td>
<td align="left">
<asp:TextBox ID="txtId" runat="server" ReadOnly="true"></asp:TextBox>
</td>
</tr>--%>
<tr>
<td>
Subject
</td>
<td align="left">
<asp:TextBox ID="TextboxSubject" Height="100px" Width="400px" TextMode="MultiLine" runat ="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvSubject" runat="server"
ControlToValidate="TextboxSubject" Display="Dynamic"
ErrorMessage="Please Enter the Subject.">Please Enter the Subject.</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
Date
</td><td align="left" ><asp:TextBox ID="TextBox1" runat="server" CausesValidation="True"></asp:TextBox>
<cc1:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="TextBox1">
</cc1:CalendarExtender>
<asp:RequiredFieldValidator ID="rfvDate" runat="server"
ControlToValidate="TextBox1" Display="Dynamic"
ErrorMessage="Please Enter the Date.">Please Enter
the Date.</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
Attachment
</td><td align="left"> <asp:FileUpload ID="fileulpoad" runat="server" />
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="fileulpoad" Display="Dynamic"
ErrorMessage="Please Attach a File.">Please Attach a File.</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
</td><td align="left">
<asp:Button ID="btnAdd" runat="server"
Text="Add Meeting" OnClick = "Add"
style="height: 26px" /></td>
</tr>
<tr>
<td colspan="5">
<asp:GridView ID="GridView1" runat="server"
Width="898px" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid"
BorderWidth="3px" CellPadding="4" AutoGenerateColumns="False"
style="margin-left: 0px" CaptionAlign="Top" CellSpacing="2"
ForeColor="Blue" RowHeaderColumn="NameOfWork" AllowSorting="True"
onsorting="GridView1_Sorting1"
onselectedindexchanged="GridView1_SelectedIndexChanged"
DataKeyNames="MT_ID" >
<FooterStyle BackColor="#CCCCCC" />
<RowStyle BackColor="White" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<EditRowStyle Height="120px" />
<Columns>
<asp:BoundField DataField ="MT_ID" HeaderText="ID" ReadOnly="True" >
<ControlStyle BorderWidth="1000px" Font-Bold="true" />
<ItemStyle Width="90px" ForeColor="#CC0099" />
</asp:BoundField>
<asp:TemplateField HeaderText="Subject" ItemStyle-Width="281px" ItemStyle-ForeColor="#CC0099">
<ItemTemplate >
<asp:HyperLink ID="Open" Font-Bold="true" NavigateURL='<%# imageURL(DataBinder.Eval(Container.DataItem, "Attachment")) %>' Text='<%# Eval("Subject") %>' Target="_blank" runat="server" />
<%--asp:LinkButton ID ="linksubject" runat ="server" Text ='<%#Eval("Subject") %>' CommandArgument ="MT_ID" CommandName ="Subject"></asp:LinkButton> --%>
</ItemTemplate>
<ItemStyle ForeColor="#CC0099" Width="281px" />
</asp:TemplateField>
<asp:BoundField DataField ="ATTACHMENT" HeaderText="Attachment" >
<ControlStyle BorderWidth="1000px" Font-Bold="true" />
<ItemStyle Width="181px" ForeColor="#CC0099" />
</asp:BoundField>
<asp:BoundField DataField ="MTDATE" HeaderText="Date" SortExpression="MTDATE"
DataFormatString="{0:dd/MM/yyyy}" >
<ControlStyle BorderWidth="1000px" Font-Bold="true" />
<ItemStyle Width="181px" ForeColor="#CC0099" />
</asp:BoundField>
<asp:ButtonField ButtonType="Button" CommandName="Edit" Text="Edit" />
<asp:ButtonField ButtonType="Button" CommandName="Delete" Text="Delete" />
</Columns>
</asp:GridView>
</td>
</tr>
<tr align="right" valign="middle"><td align="center"> </td><td></td></tr>
</table>
</td>
</tr>
<tr>
<td style="text-align: center">
<asp:MultiView ID="mv_AddMeeting" runat="server" ActiveViewIndex="0">
<asp:View ID="viewAddMeeting" runat="server">
<table class="style5">
<tr align="center" >
<td>
</td></tr>
</table>
</asp:View>
</asp:MultiView>
</td>
</tr>
</table>
</asp:Content>
-----.aspx.cs-------
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class Admin_AddMeeting : System.Web.UI.Page
{
private const string ASCENDING = " ASC";
private const string DESCENDING = " DESC";
DataSet ds = new DataSet();
SqlDataAdapter da;
String strConnString = ConfigurationManager.ConnectionStrings["hmwssbConnectionString"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
BLCGM obj = new BLCGM();
obj.User = Session["UserName"].ToString();
string select = ("select MT_ID,Subject,attachment,MTDate from minutes_meeting");
SqlConnection con = new SqlConnection(strConnString);
con.Open();
SqlCommand cmd = new SqlCommand(select, con);
cmd.ExecuteNonQuery();
BindData();
if (obj.User == "Admin")
{
BindData();
}
//else
//{
// //Response.Redirect("~/Admin/ADMIN.aspx");
//}
}
private void BindData()
{
DataSet ds = DataHelper.ExecuteDataSet("Select * from MINUTES_MEETING");
GridView1.DataSource = ds;
GridView1.DataBind();
}
public string imageURL(object SmallImage)
{
return ("~/Attachment/" + SmallImage);
}
protected void Add(object sender, EventArgs e)
{
string subject = TextboxSubject.Text;
string date = TextBox1.Text;
//string filename = Path.GetFileName(fileulpoad.PostedFile.FileName);
string filename = Server.MapPath("~/Attachment/" + fileulpoad.FileName);
string file = fileulpoad.FileName;
//fileulpoad.SaveAs("~/Attachment/attachment/" + filename);
fileulpoad.SaveAs(filename);
string insert = "insert into minutes_meeting(Subject,attachment,MTDate) values(''" + subject + "'',''" + file + "'',''" + date + "'')";
SqlConnection con = new SqlConnection(strConnString);
con.Open();
SqlCommand cmd = new SqlCommand(insert, con);
cmd.ExecuteNonQuery();
BindData();
TextboxSubject.Text = "";
TextBox1.Text = "";
}
protected void lnkAdmin_Click(object sender, EventArgs e)
{
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
//DataTable dataTable = gridView1.DataSource as DataTable;
}
private void SortGridView(string sortExpression, string direction)
{
DataTable dt = new DataTable();
DataSet ds = DataHelper.ExecuteDataSet("Select * from MINUTES_MEETING");
dt = ds.Tables[0];
DataView dv = new DataView(dt);
dv.Sort = sortExpression + direction;
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void GridView1_Sorting1(object sender, GridViewSortEventArgs e)
{
string sortExpression = e.SortExpression;
ViewState["SortExpression"] = sortExpression;
if (GridViewSortDirection == SortDirection.Ascending)
{
GridViewSortDirection = SortDirection.Descending;
SortGridView(sortExpression, DESCENDING);
}
else
{
GridViewSortDirection = SortDirection.Ascending;
SortGridView(sortExpression, ASCENDING);
}
}
private SortDirection GridViewSortDirection
{
get
{
if (ViewState["sortDirection"] == null)
ViewState["sortDirection"] = SortDirection.Ascending;
return (SortDirection)ViewState["sortDirection"];
}
set { ViewState["sortDirection"] = value; }
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
}推荐答案
There are a few ways to do this:
The first way I am going to show you is an easy workaround, although not the most professional fix.
In the aspx file, place:
<asp:commandfield headertext="Edit/View" showselectbutton="True" xmlns:asp="#unknown">
inside of your gridview.
Then add
onselectedindexchanged="GridView1_SelectedIndexChanged"
into your asp gridview declaration.
Like so
There are a few ways to do this:
The first way I am going to show you is an easy workaround, although not the most professional fix.
In the aspx file, place:
<asp:commandfield headertext="Edit/View" showselectbutton="True" xmlns:asp="#unknown">
inside of your gridview.
Then add
onselectedindexchanged="GridView1_SelectedIndexChanged"
into your asp gridview declaration.
Like so
<asp:gridview id="GridView1" runat="server" datasourceid="SqlDataSource1" cssclass="GridView" xmlns:asp="#unknown">
AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False"
BorderStyle="Ridge" BorderWidth="2px"
OnRowCommand="GridView1_RowCommand"
onselectedindexchanged="GridView1_SelectedIndexChanged" ></asp:gridview>
In the code behind part create this function for the GridView1_SelectedIndexChanged.
In the code behind part create this function for the GridView1_SelectedIndexChanged.
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int index = GridView1.SelectedIndex;
Session["selectedId"] = GridView1.Rows[index].Cells[1].Text;
TabContainer1.ActiveTabIndex = 2;
}
I was using this inside of a TabContainer. If you want to change it to another aspx page replace TabContainer1.ActiveTabIndex = 2; with Response.Redirect("~/yourOtherPage.aspx"); or you can also use ServerTransfer, I believe, although I am not familiar with that method.
You can create Session variables to store the data in. Then during the page load of your other page, check these session state variables to see if they have values. If they do you can insert them into textfields to edit.
Also, GridView1.Rows[index].Cells[1].Text; is used to access the values in the gridview at specific locations. Cells[#] is which column of the gridview you want to access.
The Second Option is to follow the example in Ashrafur Rahaman''s article Editable GridView in ASP.NET 2.0, which is a more professional solution then the above.
His example is a good starting place, although it might take you a little bit more time to study and get through the entire article it is worth knowing and easy to add to once you understand how a gridview works. His example will show you how to create these commands once inside of them you will access the information, save it, and change pages like above.
For a more thorough look at how to access items in a gridview check out azamsharp''s article at Accessing the different controls inside a GridView control.
希望对您有所帮助.
I was using this inside of a TabContainer. If you want to change it to another aspx page replace TabContainer1.ActiveTabIndex = 2; with Response.Redirect("~/yourOtherPage.aspx"); or you can also use ServerTransfer, I believe, although I am not familiar with that method.
You can create Session variables to store the data in. Then during the page load of your other page, check these session state variables to see if they have values. If they do you can insert them into textfields to edit.
Also, GridView1.Rows[index].Cells[1].Text; is used to access the values in the gridview at specific locations. Cells[#] is which column of the gridview you want to access.
The Second Option is to follow the example in Ashrafur Rahaman''s article Editable GridView in ASP.NET 2.0, which is a more professional solution then the above.
His example is a good starting place, although it might take you a little bit more time to study and get through the entire article it is worth knowing and easy to add to once you understand how a gridview works. His example will show you how to create these commands once inside of them you will access the information, save it, and change pages like above.
For a more thorough look at how to access items in a gridview check out azamsharp''s article at Accessing the different controls inside a GridView control.
I hope this helps.
这篇关于asp.net ...帮助解决我的要求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
