Search results matching tag 'GridView'

Gridview row_updated event - Need to get updated email address and then send an email on gridview update

shawn.bordeaux — Sun, 20 Dec 2009 05:00:00 GMT

I have a basic gridview that has customers information. When a manager edit's a row I would like an email to be fired off that has the changes that were made. One of the fields that changes can be made to is the customers email address.

I have the email part working fine but when I try to get the updated values of the textboxs is where I always run into errors. What command in VB would I need to set a variable such as ; Dim Email As String = findcontrol("email", TextBox).text ?

I have the edit fields as templates in the gridview and their text boxes are like this,

<asp:TextBox ID="email" runat="server" Text='<%# Bind("email") %>'></asp:TextBox>
<asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("appointment_date") %>' />

Here is what I have emailing so far;

    Protected Sub GridView3_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs) Handles GridView3.RowUpdated
        'send an email when the gridview is updated
        Const ToAddress As String = "test@test.com"  ' need to set this as customers email that we pull from the gridview
        Const UsersEmail As String = "NoReply@justrightreferralnetwork.com"
        '(1) Create the MailMessage instance
           
        Dim email As String = CType(GridView3.FindControl("email"), TextBox).Text   ' This is not working get an error everytime
        ' for the time being set up usersemail as a known address 
        Dim mm As New MailMessage(UsersEmail, ToAddress)

        '(2) Assign the MailMessage's properties
        Dim Subject As String = "Message from the Just Right Referral Network"
        Dim Body As String = "There is updated information about your account. Please login to view the changes."


        mm.Subject = Subject
        mm.Body = Body
        mm.IsBodyHtml = False

        '(3) Create the SmtpClient object
        Dim smtp As New SmtpClient

        '(4) Send the MailMessage (will use the Web.config settings)
        smtp.Send(mm)
    End Sub

Thank you everyone and best regards!

Shawn

Displaying data from CSV file in GridView

ptownbro — Sat, 19 Dec 2009 05:00:00 GMT

I'm trying to display data from a CSV file into a GridView control and it's not working. The code does NOT error out, but for some reason the data isn't being displayed in the GridView. What am I doing wrong?

Code:

Sub Button1_OnClick(Sender As Object, e As EventArgs)
   'Declare Variables
	Dim fsName, fsObject, fsText, fsArray
	Dim myDTable As DataTable = New DataTable
	Dim myDRow As DataRow = myDTable.NewRow

   'Add Column(s) to GridView
	myDTable.Columns.Add("Column02")

   'Read CSV file
	fsName = Server.MapPath(docPathImports) & "test.csv"
	fsObject = fs.OpenTextFile(fsName)
	
   'Read Field Header
	fsText = fsObject.readLine

   'Read Data
	Do While Not fsObject.AtEndOfStream
		fsText = fsObject.readLine
		fsArray = split(fsText, ",")
	
	    If i > 0 Then
	        myDRow.ItemArray = split(fsText, ",")
	        myDTable.Rows.Add(myDRow)
	        myDRow = myDTable.NewRow
	    End If
	    i += 1
	
	    GridView1.DataSource = myDTable
	    GridView1.DataBind()
	Loop
	
   'Close Objects
	fsObject.Close
	fsObject = Nothing
	fs = Nothing
End Sub

Html:

<html>
<head>
</head>

<body>

<form id="Form1" method="post" encType="multipart/form-data" runat="server">

<asp:Button id="Button1" runat="server" Text="Display CSV" OnClick="Button1_OnClick" />

	<asp:GridView runat="server"
	id="GridView1" 
	AutoGenerateColumns="False" 
	Width="100%" 
	CellPadding="3" 
	BorderStyle="Solid" >
</asp:GridView>

</form>

</body>
</html>

Prevent user from selecting row that is either in edit or select mode?

shawn.bordeaux — Sat, 19 Dec 2009 05:00:00 GMT

I have a simple sub that changes the colors of the rows in the gridview when the user moves their cursor around them. When the user clicks anywhere in a row it jumps them directly to the row edit feature. The problem is if the user for somereason clicks in that same row while the edit row is displayed the application reports the error;

"Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation. "

So basically I am trying to find a way to prevent the user from double selecting one of these rows. I thought I could add sometype of conditional statement to either the javascript or the sub to check if the row has already been selected but I am not sure how to do it. Any help would be greatly appreciated.

The sub;

    Protected Sub GridView3_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView3.RowDataBound
        ' this sub is used so we can select rows in the gridview without using the select button
        If e.Row.RowType = DataControlRowType.DataRow Then
            e.Row.Attributes.Add("onmouseover", "this.style.cursor='hand';this.style.backgroundColor='lightpink';")
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='';")
            e.Row.Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Edit$" + e.Row.RowIndex.ToString))
        End If
    End Sub

Best regards,

Shawn

selecting an item from a gridview control and passing to next page

mattsgrandad — Fri, 18 Dec 2009 05:00:00 GMT

I have agridview control in which I have a 'Next page' button as well as data from an SQLDataSource dataset.

What I'm trying to do is to pass control to the next page when that button is pressed and to pass with it one of the data items from the selected gridview row.

I've seen various posts on passing data between web pages but, because I'm not a web or SQL expert, most of it doesn't make a great deal of sense to me.

has anyone got a simple example that I could copy that shows where code needs to be in the sending page and the receiving page for both the aspx page code and the aspx.vb code

Thanks in advance.

Linq - SQL to GridView

lookitstony — Thu, 17 Dec 2009 05:00:00 GMT

I guess I am having a hard time understanding this. I create the Grid view and I link it to the SQL-Linq datacontext and if I select all fields then the gridview works. I then cut down what fields I want to show directly in the grid view. Now I go into my Linqdatasource and moditfy the selecting event to build my custom "where" clause and everything still works. Now instead of doing r.paymentstatus and getting a "1" I want to do r.tblpaymentstatus.paymentstatus so it retrieves the actual status instead of the number. As long as I do my select for every field in the datasource it works but if I limit down to only the fields I have showing in the gridview I get errors. They range from "anonymous<2> type mismatch" to another long error I will put below.

Goal: To select what fields i want to view and allow them to be editable. I want the tables that are referenced to show the data instead of the reference number. I am also thinkign about making template fields so I can arrange the data differently.. How can I get the r.table.field to populate instead of r.field inside a databound control in the template?

ERROR:System.Web.HttpException: DataBinding: '<>f__AnonymousType0`9[[System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable`1[[System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=2.0.0.0,...' does not contain a property with the name 'ReImbursementInfoID'

C# Code:
protected void ldsReimbursement_Selecting(object sender, LinqDataSourceSelectEventArgs e)
    {
        PatientDataContext db = new PatientDataContext();

        var query = from r in db.tblReimbursementInfos
                    where r.SSN == dvPatient.Rows[3].Cells[1].Text
                    select new
                      {
                          Delivery_Date = r.Delivery_Date,
                          DeliveryType = r.tlkpDeliveryType.DeliveryType,
                          EDC = r.EDC,
                          EnrollmentDate = r.EnrollmentDate,
                          Physician_Reimbursement = r.Physician_Reimbursement,
                          PaymentStatus = r.tblPaymentStatus.PaymentStatus,
                          Notes = r.Notes,
                          DeliveryTypeID = r.DeliveryTypeID,
                          EnteredBy = r.EnteredBy


                      };

        e.Result = query;
    }

ASP.NET Code:
<asp:View ID="vwEnrollment" runat="server">
                    <asp:GridView ID="gvReimbursement" runat="server" AutoGenerateColumns="False" 
                        CellPadding="4" DataKeyNames="ReImbursementInfoID" 
                        DataSourceID="ldsReimbursement" ForeColor="#333333" GridLines="None">
                        <RowStyle BackColor="#EFF3FB" />
                        <Columns>
                            
                            <asp:BoundField DataField="Delivery_Date" HeaderText="Delivery" />
                            <asp:BoundField DataField="DeliveryType" HeaderText="DeliveryType" />
                            <asp:BoundField DataField="EDC" HeaderText="EDC"/>
                            <asp:BoundField DataField="Physician_Reimbursement" HeaderText="Physician_Reimbursement"/>
                            <asp:BoundField DataField="EnrollmentDate" HeaderText="Enrolled" />
                            <asp:BoundField DataField="Notes" HeaderText="Notes" />
                            <asp:BoundField DataField="PaymentStatus" HeaderText="Payment Status" />
                            <asp:BoundField DataField="DeliveryTypeID" HeaderText="DeliveryTypeID" />
                            <asp:BoundField DataField="EnteredBy" HeaderText="Entered By" />
                            
                        </Columns>
                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                        <EditRowStyle BackColor="#2461BF" />
                        <AlternatingRowStyle BackColor="White" />
                    </asp:GridView>

I have changed the code so many times tryign to figure out how to get this to work.. so this may not look right because it has been completely mutilated.

Thanks for the help if anyone can help!

Re: Tooltip on gridview

PeteNet — Thu, 17 Dec 2009 05:00:00 GMT

IF you have to use BoundFields you can apply the tooltip to the whole row (not just a column) by using the tooltip property of the row:

e.Row.ToolTip = "something" and you could do this in the RowDataBound event:

protected void GridView1_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
   if (e.Row.RowType == DataControlRowType.DataRow) {
       e.Row.ToolTip = DataBinder.Eval(e.Row.DataItem, "ItemDescription", string.Empty);
   }
}

Check Mike's post here: http://forums.asp.net/t/1456738.aspx

IF you have to use a single column then you will have to use a templatefield (and set the AutoGenerateColumns property to false)

<asp:templatefield>
   <itemtemplate>
       <asp:label runat="server" text='<%# Eval ( "Description" ) %>' tooltip='<%# Eval ( "Description" ) %>' />
   </itemtemplate>
</asp:templatefield>

for restricting words you could use the split (on spaces) method on the string making up the description and use the first few items (of the array which results) for the text property and the remaining as the tooltip. something like

mystring = StringFromDataBase.Substring(0, 100); //take the first hundred characters for example (check for length before!)
string[] vals = mystring.Split[' '];
string words = vals[0] + " " + vals[1] ............;

some split examples here: http://dotnetperls.com/string-split

you may want to try this cool extender too: http://devarchive.net/advanced-tooltip-control-asp-net-ajax.aspx

GridView Databound

ahmad hajou — Wed, 16 Dec 2009 05:00:00 GMT

I have a GridView that im filling according to a Post Variable inside the databinding wizard.

This variable is lost after the page is Post Back using an ASP.net control, is there a way to repass that variable to the Grid someway?

Any idea?

Thanks in advance.

Re: Gridview, objectdatasource, multiple datatables in dataset

bmoyno — Wed, 16 Dec 2009 05:00:00 GMT

Thanks for the suggestion PeteNet, but I get same message as if I declared 'DataMember' declaritively ...

The data source 'odsReport' only supports a single view named 'DefaultView'. You may also leave the view name (also called a data member) empty for the default view to be chosen.
Parameter name: viewName

Any other ideas?

How to show 'e-Mail' instead of the actual e-mail address for a database field but nothing if the field does not contain an e-mail address?

SouthendSupporter — Wed, 16 Dec 2009 05:00:00 GMT

Hi
I am using the following code in a Gridview to display a link to generate an e-mail to an email address obtained from a database:

Code:

<asp:TemplateField HeaderText="Email">
<ItemTemplate>
<asp:HyperLink ID="EmailLink" text='text='<%# bind("eMail") %>'' 
NavigateUrl='<%# Eval("eMail","mailto:{0}?Subject=Enquiry from Cobham Chamber Website")%>' 
runat="server"
target="_blank" />
</ItemTemplate>

This works just fine, displaying an e-mail address if one exists and not if it doesn't.

BUT..

I am restricted in width and the email address that will be displayed by using text='<%# Bind("eMail") %>' is too long.

I have tried using text='e-Mail' as an alternative. This shortens the field, displays as a link when the database field contains an e-mail but displays as plain text when it does not.

Can I hide the text when there is no data in the field?

Re: Conflict in Editing in Listview and Search function

nencarnacion — Wed, 16 Dec 2009 05:00:00 GMT

How do i do this? how do i check for the gridview cells index?

What i did was i compared the positions of the columns and they are all correct. in column 0 is the edit/delete buttons. and the Billcode starts at column 1.

Is there another way?