|
|
Hi,
I have connect sql database with gridview. I enter details into table from StudentDetails.aspx page. Now I would like to show as "Displaying 1-10 of 120 results were found" on top of gridview control in SearchStudents.aspx page.
Plz help me to make this
|
|
|
|
|
There are lots of tutorials online. I would recommend going through some of them. Or, are you stuck in a specific spot?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Write a method to bind gridview on page load event with datasource and allow paging=true of gridview property.
|
|
|
|
|
|
i have lurn .NET then what i do?
|
|
|
|
|
|
The best way to learn is to do a project. You can download versions of Visual Studio or buy them but do a project and you'll learn best.
Then, go get a job doing it.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
|
I have been handed a project to make part of my company's website more accessible to mobile users. I would like to have the main login page detect whether the user is accessing the site from a mobile device and, if so, direct them to a mobile subdomain.
Because this is a financial services company, our legal department does not want me to use cloud based determination service in any way, shape or form: while the risk of data theft is quite small, they feel that the risk outweighs the benefit. Ideally, it would be an open-source solution that I can monitor and update myself, in order to guarantee that there are no back-doors.
I have tried using HttpBrowserCapabilities , but most of the returned properties are rubbish: IsMobileDevice returns False even on my Android phone, and every browser I've tested seems to have a screen 640 pixels wide by 480 pixels high, from smart phone to tablet to Windows desktop.
So, any suggestions on how to proceed?
|
|
|
|
|
Consider "Responsive Web Design", meaning your web application doesn't really care which device it is running on but rather responds to its browser capabilities.
Look at this example of media queries. The background will change color based on the size of the browser window. (I got this demo from somewhere, but I don't remeber where)
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Responsive Design Rocks!</title>
<style>
body { margin: 0;}
h1 { text-align: center; color: white; }
@media(min-width: 300px) {
html { background: red; }
}
@media(min-width: 600px) {
html { background: blue; }
}
@media(min-width: 900px) {
html { background: green; }
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<div class="wrapper">
<h1>Resize me.</h1>
</div>
</div>
</form>
</body>
</html>
|
|
|
|
|
I have looked into using @media styles, and they work, but....
Our website has several hundred pages, most of which will not be converted to be mobile compatible for various reasons. The few that will be converted need to be trimmed substantially: not just restyled, but given entirely new master pages to eliminate a lot of bloat that would be hidden if I went with a pure CSS solution. Also on these pages, I would like to trim out or redirect links that point to pages in the main site.
All in all, the cleanest solution will be to have a separate mobile-oriented website with only about a score of pages. A nuisance, but far less work and maintenance than trying to make the entire (censored) site mobile friendly. I just need a way to identify mobile users at the front end, when the log in, and determine which site to send them to. (The mobile site will have a link allowing users to visit the full site, if they really want to.)
|
|
|
|
|
I see your problem. I did something specific for our mobile salesforce.
When a user hits a page, it detects if it is a mobile device and redirects them to a mobile specific page.
Here is my code snipet:
If Not (Request.Headers("X-Wap-Profile") Is Nothing) Then
If (Request.Headers("X-Wap-Profile").ToString().Length > 0) Then
IsMobi = True
NewURL = BuildURL("~/ApproveQ-mobile.aspx", Request.QueryString)
Response.Redirect(NewURL, True)
End If
End If
This was working when our salesfolk were using BlackBerry, however, it it not working for the iPhone 4s which they are currently using.
I found this article and may have to investigate some of the suggested technologies.
Maybe it will help you ...
http://beradrian.wordpress.com/2008/10/10/mobile-device-recognition/[^]
|
|
|
|
|
The browser produces an error after I have published my ASP.NET C# program that is not produced in my local host in debug mode.
I get this error often and it seems to be a generic error. By this, i mean that if I do what the error suggests and change the configuration file by setting the customErrors to "off", I still get this error. The frusturating thnig is that this error does not happen in local host when running in debug mode. Is there any way to modify the configuration file so that the error message is more descriptive?
http://i67.photobucket.com/albums/h292/Athono/debug/generic_zps4499f5a5.png
I saw this error occur when I was running a Microsoft Outlook web page. Could it be a serious problem with Microsoft?
http://www.gelsana.com/Recording.avi
http://www.gelsana.com/Recording.flv59temp44.avi
http://www.gelsana.com/Recording2.flv59temp44.avi
|
|
|
|
|
Look in the event viewer on your server.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Hi there,
I'm developing a telerik report in which I just want to display a set of coloumn value in Indian currency format after excel download. I have done this with the help of calling a currency converter function.
Output came like this,
5,25,600.00
5,25,600.00
10,75,600.00
10,00,00,000.00
1000.00
1000.00
10600.00
10600.00
23.00
3333.00
Now I just want to make sum of this column, but it downloaded as text format not in number format, though I changed it to number format in format cell option, values like 5,25,600.00 ,10,75,600.00, 10,00,00,000.00 which are all having "," in between the numbers cannot be added. How to change these values into number format. Suggestions welcomed.
Thanks in advance.
Regards,
A.Sundar.
|
|
|
|
|
help me out with the GUI ,controller and model to understand.. would be grateful.. thank you
|
|
|
|
|
|
I want to design gridview inside another gridview with insert update and delete
I design database with tables are
1) tbl_Show(ShowID{P},ShowTime,Silver,Gold, Platinum,ShowTimeId) 2) tbl_STime(ShowTimeId{P},TheatreId,MovieId,FromDate,ToDate) 3) tbl_Theatre(TheatreId{P}, TName, Taddress)
I want to design same in asp.net C# like this visit http://www.codeproject.com/Articles/14293/Gridview-Inside-a-GridView-in-ASP-NET-2-0
|
|
|
|
|
You already have the example, follow the whole tutorial/article and source code to follow. Bind your data, did you received an error. Honestly, that article is your solution, you can even post the question to the author. Try it first, get errors and fix/(trouble shoot). Good luck.
I remain joe!
|
|
|
|
|
first implement it vipul add it tell me if you need a help
|
|
|
|
|
|
I need your help when I insert record then it cant insert in database.
|
|
|
|
|
|
aspx page is :
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" BackColor="#f1f1f1"
AutoGenerateColumns=false DataSourceID="SqlDataSource1" DataKeyNames="ShowTimeId"
GridLines=None OnRowDataBound="GridView1_RowDataBound"
OnRowCommand = "GridView1_RowCommand" OnRowUpdating = "GridView1_RowUpdating" BorderStyle=Outset
OnRowDeleting = "GridView1_RowDeleting" OnRowDeleted = "GridView1_RowDeleted"
OnRowUpdated = "GridView1_RowUpdated" AllowSorting=true ShowFooter=true
Width="100%" >
<RowStyle BackColor="Gainsboro" />
<AlternatingRowStyle BackColor="White" />
<HeaderStyle BackColor="#0083C1" ForeColor="White"/>
<FooterStyle BackColor="White" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<a href="javascript:expandcollapse('div<%# Eval("ShowTimeId") %>', 'one');">
<img id="imgdiv<%# Eval("ShowTimeId") %>" alt="Click to show/hide Orders for Customer <%# Eval("ShowTimeId") %>" width="9px" border="0" src="../images/plus.gif"/>
</a>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ShowTime Id" SortExpression="ShowTimeId">
<ItemTemplate>
<asp:Label ID="lblShowTimeId" Text='<%# Eval("ShowTimeId") %>' runat="server"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lblShowTimeId" Text='<%# Eval("ShowTimeId") %>' runat="server"></asp:Label>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Theatre Id" SortExpression="TheatreId">
<ItemTemplate>
<asp:Label ID="lblTheatreId" Text='<%# Eval("TheatreId") %>' runat="server"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lblTheatreId" Text='<%# Eval("TheatreId") %>' runat="server"></asp:Label>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="ddlTheatre" runat="server" CssClass="form_input" AutoPostBack="True" TabIndex="1"
DataSourceID="SqlDataSource2" DataTextField="TheatreName" DataValueField="TheatreID" Width="130px"
SelectedValue='<%# Bind("TheaterName") %>'>
</asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Movie Id" SortExpression="MovieId">
<ItemTemplate>
<asp:Label ID="lblMovieId" Text='<%# Eval("MovieName") %>' runat="server"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddlmovie" runat="server" CssClass="form_input" TabIndex="2" Width="130px">
</asp:DropDownList>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="ddlMovie" runat="server" CssClass="form_input" TabIndex="2" Width="130px">
</asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="From Date" SortExpression="FromDate">
<ItemTemplate><%# Eval("FromDate")%></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtFromDate" Text='<%# Eval("FromDate") %>' runat="server"></asp:TextBox>
<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/cal/calendar.gif" AlternateText="Click to show calendar" TabIndex="3" />
<asp:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtFromDate" Format="dd/MM/yyyy" PopupButtonID="ImageButton1">
</asp:CalendarExtender>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFromDate" Text='' runat="server"></asp:TextBox>
<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/cal/calendar.gif" AlternateText="Click to show calendar" TabIndex="3" />
<asp:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtFromDate" Format="dd/MM/yyyy" PopupButtonID="ImageButton1">
</asp:CalendarExtender>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="To Date" SortExpression="ToDate">
<ItemTemplate><%# Eval("ToDate")%></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtToDate" Text='<%# Eval("ToDate") %>' runat="server"></asp:TextBox>
<asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/cal/calendar.gif" AlternateText="Click to show calendar" TabIndex="3" />
<asp:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtToDate" Format="dd/MM/yyyy" PopupButtonID="ImageButton2">
</asp:CalendarExtender>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtToDate" Text='' runat="server"></asp:TextBox>
<asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/cal/calendar.gif" AlternateText="Click to show calendar" TabIndex="3" />
<asp:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtToDate" Format="dd/MM/yyyy" PopupButtonID="ImageButton2">
</asp:CalendarExtender>
</FooterTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="Edit" ShowEditButton="True" />
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="linkDeleteShow" CommandName="Delete" runat="server">Delete</asp:LinkButton>
</ItemTemplate>
<FooterTemplate>
<asp:LinkButton ID="linkAddShow" CommandName="AddShow" runat="server">Add</asp:LinkButton>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<tr>
<td colspan="100%">
<div id="div<%# Eval("ShowTimeId") %>" style="display:none;position:relative;left:15px;OVERFLOW: auto;WIDTH:97%" >
<asp:GridView ID="GridView2" AllowPaging="True" AllowSorting="true" BackColor="White" Width=100% Font-Size=X-Small
AutoGenerateColumns="false" Font-Names="Verdana" runat="server" ShowFooter="true"
OnPageIndexChanging="GridView2_PageIndexChanging" OnRowUpdating = "GridView2_RowUpdating" CssClass="Gridview"
OnRowCommand = "GridView2_RowCommand" OnRowEditing = "GridView2_RowEditing" GridLines=None
OnRowUpdated = "GridView2_RowUpdated" OnRowCancelingEdit = "GridView2_CancelingEdit" OnRowDataBound = "GridView2_RowDataBound"
OnRowDeleting = "GridView2_RowDeleting" OnRowDeleted = "GridView2_RowDeleted" OnSorting = "GridView2_Sorting"
BorderStyle=Double BorderColor="#0083C1">
<RowStyle BackColor="Gainsboro" />
<AlternatingRowStyle BackColor="White" />
<HeaderStyle BackColor="#0083C1" ForeColor="White"/>
<FooterStyle BackColor="White" />
<Columns>
<asp:TemplateField HeaderText="Show ID" SortExpression="ShowID">
<ItemTemplate>
<asp:Label ID="lblShowID" Text='<%# Eval("ShowID") %>' runat="server"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lblShowID" Text='<%# Eval("ShowID") %>' runat="server"></asp:Label>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ShowTime" SortExpression="ShowTime">
<ItemTemplate><%# Eval("ShowTime")%></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtShowTime" Text='<%# Eval("ShowTime")%>' runat="server"></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtShowTime" Text='' runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Silver" SortExpression="Silver">
<ItemTemplate><%# Eval("Silver")%></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtSilver" Text='<%# Eval("Silver")%>' runat="server"></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtSilver" Text='' runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Gold" SortExpression="Gold">
<ItemTemplate><%# Eval("Gold")%></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtGold" Text='<%# Eval("Gold")%>' runat="server"></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtGold" Text='' runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Platinum" SortExpression="Platinum">
<ItemTemplate><%# Eval("Platinum")%></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtPlatinum" Text='<%# Eval("Platinum")%>' runat="server"></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtPlatinum" Text='' runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="Edit" ShowEditButton="True" />
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="linkDeleteCust" CommandName="Delete" runat="server">Delete</asp:LinkButton>
</ItemTemplate>
<FooterTemplate>
<asp:LinkButton ID="linkAddOrder" CommandName="AddShow" runat="server">Add</asp:LinkButton>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</td>
</tr>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Event_MovieConnectionString %>"
SelectCommand="SELECT s.[ShowTimeId], s.[TheatreId], s.[MovieId], s.[FromDate], s.[ToDate], s.[Created],
s.[Modified], t.TheatreID, t.TheatreName, m.MovieID, m.MovieName FROM (([tbl_SShow] s inner join MST_Theatre t
on s.TheatreId = t.TheatreID)inner join MST_Movie m on s.MovieId = m.MovieID) ORDER BY s.[ShowTimeId]">
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:Event_MovieConnectionString %>"
SelectCommand="SELECT TheatreID, TheatreName FROM MST_Theatre">
</asp:SqlDataSource>
and CS file is :
using System;
using System.Collections;
using System.Configuration;
using System.Data;
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;
using System.Data.SqlClient;
using System.Drawing;
using BLL;
public partial class _Default : System.Web.UI.Page
{
clsbll b1 = new clsbll();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString.ToString());
string gvUniqueID = String.Empty;
int gvNewPageIndex = 0;
int gvEditIndex = -1;
string gvSortExpr = String.Empty;
private string gvSortDir
{
get { return ViewState["SortDirection"] as string ?? "ASC"; }
set { ViewState["SortDirection"] = value; }
}
//This procedure returns the Sort Direction
private string GetSortDirection()
{
switch (gvSortDir)
{
case "ASC":
gvSortDir = "DESC";
break;
case "DESC":
gvSortDir = "ASC";
break;
}
return gvSortDir;
}
//This procedure prepares the query to bind the child GridView
private SqlDataSource ChildDataSource(string strShowTimeId, string strSort)
{
string strQRY = "";
SqlDataSource dsTemp = new SqlDataSource();
dsTemp.ConnectionString = ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString.ToString();
//dsTemp.DataFile = "App_Data/Northwind.mdb";
strQRY = "SELECT [tbl_Time].[ShowID],[tbl_Time].[ShowTime]," +
"[tbl_Time].[Silver],[tbl_Time].[Gold],[tbl_Time].[Platinum] FROM [tbl_Time]" +
" WHERE [tbl_Time].[ShowTimeId] = '" + strShowTimeId + "'" +
"UNION ALL " +
"SELECT '" + strShowTimeId + "','','','','' FROM [tbl_Time] WHERE [tbl_Time].[ShowTimeId] = '" + strShowTimeId + "'" +
"HAVING COUNT(*)=0 " + strSort;
dsTemp.SelectCommand = strQRY;
return dsTemp;
}
protected void Page_Load(object sender, EventArgs e)
{
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
// start ddlMovie
if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList cmbType = (DropDownList)e.Row.FindControl("ddlmovie");
if (cmbType != null)
{
SqlCommand cmd = new SqlCommand("select MovieName from MST_Movie ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
cmbType.DataSource = dt;
cmbType.DataTextField = "MovieName";
cmbType.DataValueField = "MovieName";
cmbType.DataBind();
cmbType.SelectedValue = GridView1.DataKeys[e.Row.RowIndex].Values[0].ToString();
}
}
if (e.Row.RowType == DataControlRowType.Footer)
{
DropDownList cmbNewType = (DropDownList)e.Row.FindControl("ddlMovie");
SqlCommand cmd = new SqlCommand("select MovieName from MST_Movie", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
cmbNewType.DataTextField = "MovieName";
cmbNewType.DataValueField = "MovieName";
cmbNewType.DataSource = dt;
cmbNewType.DataBind();
}
// end ddlMovie
GridViewRow row = e.Row;
string strSort = string.Empty;
// Make sure we aren't in header/footer rows
if (row.DataItem == null)
{
return;
}
//Find Child GridView control
GridView gv = new GridView();
gv = (GridView)row.FindControl("GridView2");
//Check if any additional conditions (Paging, Sorting, Editing, etc) to be applied on child GridView
if (gv.UniqueID == gvUniqueID)
{
gv.PageIndex = gvNewPageIndex;
gv.EditIndex = gvEditIndex;
//Check if Sorting used
if (gvSortExpr != string.Empty)
{
GetSortDirection();
strSort = " ORDER BY " + string.Format("{0} {1}", gvSortExpr, gvSortDir);
}
//Expand the Child grid
ClientScript.RegisterStartupScript(GetType(), "Expand", "<SCRIPT LANGUAGE='javascript'>expandcollapse('div" + ((DataRowView)e.Row.DataItem)["ShowTimeId"].ToString() + "','one');</script>");
}
//Prepare the query for Child GridView by passing the Customer ID of the parent row
gv.DataSource = ChildDataSource(((DataRowView)e.Row.DataItem)["ShowTimeId"].ToString(), strSort);
gv.DataBind();
//Add delete confirmation message for Customer
LinkButton l = (LinkButton)e.Row.FindControl("linkDeleteShow");
l.Attributes.Add("onclick", "javascript:return " +
"confirm('Are you sure you want to delete this Show " +
DataBinder.Eval(e.Row.DataItem, "ShowTimeId") + "')");
}
//This event occurs for any operation on the row of the grid
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
//Check if Add button clicked
if (e.CommandName == "AddShow")
{
try
{
//Get the values stored in the text boxes
DropDownList strTheatreid = ((DropDownList)GridView1.FooterRow.FindControl("ddlTheatre"));
DropDownList strMovieid = ((DropDownList)GridView1.FooterRow.FindControl("ddlMovie"));
TextBox strFromDate = ((TextBox)GridView1.FooterRow.FindControl("txtFromDate"));
TextBox strToDate = ((TextBox)GridView1.FooterRow.FindControl("txtToDate"));
DateTime fromdate = DateTime.ParseExact(strFromDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
DateTime Todate = DateTime.ParseExact(strToDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
DateTime date = DateTime.Now;
//Prepare the Insert Command of the DataSource control
string strSQL = "";
strSQL = "INSERT INTO tbl_SShow VALUES ('" + Convert.ToInt32(strTheatreid.SelectedValue) + "','" + Convert.ToInt32(strMovieid.SelectedValue) + "','" + fromdate + "','" + Todate + "','" + date + "','" + date + "')";
SqlDataSource1.InsertCommand = strSQL;
SqlDataSource1.Insert();
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('Theatre added successfully');</script>");
//Re bind the grid to refresh the data
GridView1.DataBind();
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('" + ex.Message.ToString().Replace("'", "") + "');</script>");
}
}
}
//This event occurs on click of the Update button
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//Get the values stored in the text boxes
string strTheatreid = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlTheatre")).SelectedValue;
string strMovieid = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlMovie")).SelectedValue;
string strFromDate = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtFromDate")).Text;
string strToDate = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtToDate")).Text;
string strShowTimwid = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblShowTimeId")).Text;
try
{
//Prepare the Update Command of the DataSource control
string strSQL = "";
strSQL = "UPDATE tbl_SShow set TheatreId = '" + Convert.ToInt32(strTheatreid) + "'" +
",MovieId = '" + strMovieid + "'" +
",FromDate = '" + strFromDate + "'" +
",ToDate = '" + strToDate + "'" +
" WHERE ShowTimeId = '" + Convert.ToInt32(strShowTimwid) + "'";
SqlDataSource1.UpdateCommand = strSQL;
SqlDataSource1.Update();
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('Theatre updated successfully');</script>");
}
catch { }
}
//This event occurs after RowUpdating to catch any constraints while updating
protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
//Check if there is any exception while deleting
if (e.Exception != null)
{
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('" + e.Exception.Message.ToString().Replace("'", "") + "');</script>");
e.ExceptionHandled = true;
}
}
//This event occurs on click of the Delete button
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//Get the value
string strShowTimeID = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblShowTimeId")).Text;
//Prepare the delete Command of the DataSource control
string strSQL = "";
try
{
strSQL = "DELETE from tbl_SShow WHERE ShowTimeId = '" + Convert.ToInt32(strShowTimeID) + "'";
SqlDataSource1.DeleteCommand = strSQL;
SqlDataSource1.Delete();
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('Theatre deleted successfully');</script>");
}
catch { }
}
//This event occurs after RowDeleting to catch any constraints while deleting
protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
{
//Check if there is any exception while deleting
if (e.Exception != null)
{
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('" + e.Exception.Message.ToString().Replace("'", "") + "');</script>");
e.ExceptionHandled = true;
}
}
protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView gvTemp = (GridView)sender;
gvUniqueID = gvTemp.UniqueID;
gvNewPageIndex = e.NewPageIndex;
GridView1.DataBind();
}
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "AddShow")
{
try
{
GridView gvTemp = (GridView)sender;
gvUniqueID = gvTemp.UniqueID;
//Get the values stored in the text boxes
string strShowTimeId = gvTemp.DataKeys[0].Value.ToString(); //Customer ID is stored as DataKeyNames
string strShowTime = ((TextBox)gvTemp.FooterRow.FindControl("txtShowTime")).Text;
string strSilver = ((TextBox)gvTemp.FooterRow.FindControl("txtSilver")).Text;
string strGold = ((TextBox)gvTemp.FooterRow.FindControl("txtGold")).Text;
string strPlatinum = ((TextBox)gvTemp.FooterRow.FindControl("txtPlatinum")).Text;
//Prepare the Insert Command of the DataSource control
string strSQL = "";
strSQL = "INSERT INTO tbl_Time VALUES ('" + strShowTime + "','" + strSilver + "','" + strGold + "','" + strPlatinum + "','" + Convert.ToInt32(strShowTimeId) + "')";
SqlDataSource1.InsertCommand = strSQL;
SqlDataSource1.Insert();
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('Time added successfully');</script>");
GridView1.DataBind();
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('" + ex.Message.ToString().Replace("'", "") + "');</script>");
}
}
}
protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView gvTemp = (GridView)sender;
gvUniqueID = gvTemp.UniqueID;
gvEditIndex = e.NewEditIndex;
GridView1.DataBind();
}
protected void GridView2_CancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView gvTemp = (GridView)sender;
gvUniqueID = gvTemp.UniqueID;
gvEditIndex = -1;
GridView1.DataBind();
}
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridView gvTemp = (GridView)sender;
gvUniqueID = gvTemp.UniqueID;
//Get the values stored in the text boxes
string strShowID = ((Label)gvTemp.Rows[e.RowIndex].FindControl("lblShowID")).Text;
string strShowTime = ((TextBox)gvTemp.Rows[e.RowIndex].FindControl("txtShowTime")).Text;
string strSilver = ((TextBox)gvTemp.Rows[e.RowIndex].FindControl("txtSilver")).Text;
string strGold = ((TextBox)gvTemp.Rows[e.RowIndex].FindControl("txtGold")).Text;
string strPlatinum = ((TextBox)gvTemp.Rows[e.RowIndex].FindControl("txtPlatinum")).Text;
//Prepare the Update Command of the DataSource control
SqlDataSource dsTemp = new SqlDataSource();
dsTemp.ConnectionString = ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString.ToString();
string strSQL = "";
strSQL = "UPDATE tbl_Time set ShowTime = '" + strShowTime + "',Silver = '" + strSilver + "' ,Gold = '" + strGold + "',Platinum = '" + strPlatinum + "' WHERE ShowID = '" + strShowID+"' ";
dsTemp.UpdateCommand = strSQL;
dsTemp.Update();
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('Order updated successfully');</script>");
//Reset Edit Index
gvEditIndex = -1;
GridView1.DataBind();
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('" + ex.Message.ToString().Replace("'", "") + "');</script>");
}
}
protected void GridView2_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
//Check if there is any exception while deleting
if (e.Exception != null)
{
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('" + e.Exception.Message.ToString().Replace("'", "") + "');</script>");
e.ExceptionHandled = true;
}
}
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridView gvTemp = (GridView)sender;
gvUniqueID = gvTemp.UniqueID;
//Get the value
string strShowID = ((Label)gvTemp.Rows[e.RowIndex].FindControl("lblShowID")).Text;
//Prepare the Update Command of the DataSource control
string strSQL = "";
try
{
strSQL = "DELETE from tbl_Time WHERE ShowID = " + strShowID;
SqlDataSource dsTemp = new SqlDataSource();
dsTemp.ConnectionString = ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString.ToString();
dsTemp.DeleteCommand = strSQL;
dsTemp.Delete();
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('Show deleted successfully');</script>");
GridView1.DataBind();
}
catch { }
}
protected void GridView2_RowDeleted(object sender, GridViewDeletedEventArgs e)
{
//Check if there is any exception while deleting
if (e.Exception != null)
{
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('" + e.Exception.Message.ToString().Replace("'", "") + "');</script>");
e.ExceptionHandled = true;
}
}
protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
{
//Check if this is our Blank Row being databound, if so make the row invisible
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (((DataRowView)e.Row.DataItem)["ShowID"].ToString() == String.Empty) e.Row.Visible = false;
}
}
protected void GridView2_Sorting(object sender, GridViewSortEventArgs e)
{
GridView gvTemp = (GridView)sender;
gvUniqueID = gvTemp.UniqueID;
gvSortExpr = e.SortExpression;
GridView1.DataBind();
}
}
modified 29-Aug-13 4:07am.
|
|
|
|
|