i am using datagrid(vb.net) and pulling out data from database(sql 2005).
i have given option of show profile.
i want that when client click on show profile link data containing that link should be open in new datagrid or gridview.
i am trying but not working.
i have a datagrid that i want to be able to select a row and be able to edit the details of the row selected. Im connected to an sql azure db.
View 1 Repliesi want to import profile image from my facebook contact list and after retrieve image i want to show it a gridview.
View 1 RepliesNew users can register on my site by completing a basic form that has the create user wizard control with some additional information i am collecting using a CheckBox List. They can then log in to the site and and view "MypProfilePage.aspx" where I display the information with the CheckBoxList boxes already ticked based their selections which they can update. My problem is I have two levels of User and each one has a different registration form.
Registration Form A
Has 20 Items in the CheckBox List
Registration Form B
Has 10 items in the CheckBox List
On the Profile Page, I just want to show the CheckBox which is relevant to the Registration form A or B and with selections by the registered user. So therefore the User who registered on B will not be able to see the selections checkbox list for A.
I currently have a label in an ItemTemplate that looks like this:
<asp:Label ID="bodyLabel" runat="server" Text='<%# Bind("body") %>' />
How do I only show the first paragraph of the article and then allow the visitor to click to view more?
[code]....
but when i run then i cant find the textbox2 at the end of the databound. i.e,at the last row of the datagrid....
how to show the textbox2 then a the last row of the datagrid?
i want to show this in order to provide the user with data insertion facility.
i show data on gridview like this:
SQL = "SELECT * FROM MEN ";
dsView = new DataSet();
adp = new SqlDataAdapter(SQL, Conn);
adp.Fill(dsView, "MEN");
adp.Dispose();
GridView1.DataSource = dsView.Tables["MEN"];
GridView1.DataBind();
but i see along list...
how to show Every time only 10 rows ?
i work on asp.net and C#
I do not know why drCertification.RecordsAffected return as -1. I tested session has value and I ran the sp , it has record. Thanks.
<asp:datagrid id="dgCertification" runat="server" Width="860px" GridLines="Horizontal" CellPadding="2" AlternatingItemStyle-BackColor="Linen" HeaderStyle-BackColor="LightGrey" HeaderStyle-Font-Bold="true" HeaderStyle-Wrap="false" AllowSorting="True" AutoGenerateColumns="False"
DataKeyField="ID" BorderWidth="1px" BorderColor="LightGray" BorderStyle="Ridge" ShowFooter="True">
<EditItemStyle BackColor=teal></EditItemStyle>
<AlternatingItemStyle BackColor="Linen"></AlternatingItemStyle>
<HeaderStyle Font-Bold="True" Wrap="False" BackColor="teal"></HeaderStyle>
<FooterStyle BackColor="LightGray"></FooterStyle>
<Columns>
<asp:TemplateColumn HeaderText="Certification" HeaderStyle-ForeColor="#0000ff">
<ItemTemplate>
<asp:Label id=lblCertification runat="server" Text='<%# Container.DataItem("Certification") %>'>
</asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="txtCertification" MaxLength=50 runat="server" Width="75px"></asp:TextBox>
</FooterTemplate>
<EditItemTemplate>
<asp:TextBox id="txtCertificationE" MaxLength=50 runat="server" Text='<%# Container.DataItem("Certification")%>' Width="75px"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Date Obtained" HeaderStyle-ForeColor="#0000ff">
<ItemTemplate>
<asp:Label id=lblCDateObtained runat="server" Text= '<%# DataBinder.Eval(Container, "DataItem.CDateObtained", "{0:d}") %>'>
</asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="txtCDateObtained" runat="server" Width="75px"></asp:TextBox>
</FooterTemplate>
<EditItemTemplate>
<asp:TextBox id="txtCDateObtainedE" runat="server" Text= '<%# DataBinder.Eval(Container, "DataItem.CDateObtained", "{0:d}") %>' Width="75px"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Expiration Date" HeaderStyle-ForeColor="#0000ff">
<ItemTemplate>
<asp:Label id=lblCDateExpiration runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CDateExpiration", "{0:d}") %>'>
</asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="txtCDateExpiration" runat="server" Width="75px"></asp:TextBox>
</FooterTemplate>
<EditItemTemplate>
<asp:TextBox id="txtCDateExpirationE" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CDateExpiration", "{0:d}") %>' Width="75px"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton id="lnkbutEdit" runat="server" Text="<img border=0 src=../images/im_edit.gif alt=edit>" CommandName="Edit" CausesValidation="false"></asp:LinkButton>
</ItemTemplate>
<EditItemTemplate>
<asp:LinkButton id="lnkbutUpdate" ValidationGroup ="CDate" runat="server" Text="<img border=0 src=../images/im_update.gif alt=save/update>" CommandName="Update"></asp:LinkButton>
<asp:LinkButton id="lnkbutCancel" runat="server" Text="<img border=0 src=../images/im_cancel.gif alt=cancel>" CommandName="Cancel" CausesValidation="false"></asp:LinkButton>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<asp:LinkButton id="lnkbutDelete" runat="server" Text="<img border=0 src=../images/im_delete.gif alt=delete>" CommandName="Delete" CausesValidation="false"></asp:LinkButton>
</ItemTemplate>
<FooterStyle HorizontalAlign="Center"></FooterStyle>
<FooterTemplate>
<asp:Button id="btnAddRow" runat="server" Text="ADD" CommandName="AddANewRow" ValidationGroup ="CDate"></asp:Button>
</FooterTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
Public Sub LoadCertification()
'Dim myConn As New SqlConnection
Dim DBComm As New SqlCommand
Dim ds As New DataSet
If myConn.State = ConnectionState.Closed Then
myConn.ConnectionString = ConfigurationManager.ConnectionStrings("NurProfileString").ConnectionString
myConn.Open()
End If
Dim drCertification As SqlDataReader
If myConn.State = ConnectionState.Closed Then
myConn.Open()
End If
Try
DBComm.Connection = myConn
DBComm.CommandType = CommandType.StoredProcedure
DBComm.Parameters.Add("@EmpID", SqlDbType.Int).Value = Session("EmplNO")
'tblNurProfileCertification
'
http://www.shotdev.com/aspnet/aspnet-vbnet-gridview/aspnet-vbnet-gridview-databound/
DBComm.CommandText = "NurCerti_Log_Read" '
drCertification = DBComm.ExecuteReader()
dgCertification.DataSource = drCertification
dgCertification.DataBind()
drCertification.Close()
drCertification = Nothing
DBComm.Dispose()
Catch objError As Exception
Dim myarraylist As New ArrayList
myarraylist.Add("fliao@holyredeemer.com")
MailHelper.SendMailMessage("fliao@holyredeemer.com", myarraylist, "fliao@holyredeemer.com", "", "Annual HR Employee Log Error ", "Nursing Profile Error")
Exit Try
Finally
End Try
End Sub
I have a datagrid where each row has information on Employees in a company. I would like to allow each row the ability to show/hide extra information. My first idea was use the CollapsiblePanelExtender from the AJAX toolkit and have each row like this:
<ajaxtoolkit:collapsiblepanelextender
TargetControlID="panel2">
ExpandControlID="LinkButton1"
[Code]....
This works very well but it can be computationally expensive. The extra information panel has a lot of textboxes/labels, all of which gets its values from the database. Everytime the page loads all the data is got from the database at the start, some of it is hidden.
Is there a better way to achieve my goal? Or is there a way to only load an employees extra details when the Show/Hide button is click?
Please guide me to acheive below results,
1)Need to display menu on right click of a data grid using Jquery,
2)I need to disable or hide some of the menu items in certain rows,
3)postback to the server with the selected row details
i have datagrid , data coming from database but data in database as formated , i want to show data wihotu format
below example:
<B> test </B> data base has this type data
but in grid i want to show test not with format,
i am getting same data from database.
Using Datagrid I am trying Web Form on click datagrid row, Any body suggest how I do this.
View 1 RepliesI've got a gridView called gvLineItems in an asp.net page..I want to throw in some jquery to allow for a double click on the row of the gridview and let it redirect to another page:
<script src="include/jquery-1.5.1.min.js" type="text/javascript"></script>
<script type="text/javascript">
var selected = null;
[code]...
Dropdownlist Show the all PatientName and save the PatientID in the database and in datagrid showing the PatientID my requirement is that the PatientName show in DataGrid.
View 4 RepliesI want to show a image in panel below datagrid if I select particular row.I want to highlite that row in a diff color.
View 3 RepliesThis should be simple but I am baffled. I have a perfectly functioning DataGrid that I can click its "Select" link to select any one of its rows. When I do, the row highlights itself in red as expected. So far, so good.I also have an independent Label on the same page and I want to update its Text value to a cell value from the DataGrid when I select a specific row.OTH the DataGrid (named GridView1) and the Label (named Label2) are within an UpdatePanel.PROBLEM: When I select a row from the DataGrid, the Label is not updated with the cell's contents. It simply retains its original default Text value.Here is my code:
[Code]....
This code was from the MSDN site, but nothing seems to happen when I select rows within the GridView.
I m having a datagrid and for client side events I m using Javascript. I have few other buttons in the same page.
when I click on datagrid and select, it is working fine. After that, if I click on any other button in the Page, It is directly going to global.asax and throwing exception.
If I click directly on other buttons, they are working fine. Once I click on Datagrid and try to click on other buttons, it is throwing that exception.
I have <span> tags in the cells of my datagrid which determine which background color to use. I also want the user to be able to click any cell and highlight the entire row. This works anywhere there's not a span tag. The span tag is somehow canceling this out. What would you do so that fields inside a span tag act like regular fields where you can click on them and the entire row is highlighted?
View 10 Repliesmy goal is to do this:a user clicks on one row on the datagrid (.net 3.5). (the user can click anywhere of the row)then the form postbacks, and then other content based on the selected row on the page will be updated.
View 5 RepliesI have gridview and want to show datalist in grid view view column on click of linkbutton show.
[Code]....
Is it possible, I have the following datagrid, want to show "filename" field info as a tooltip with first column Type in datagrid.
[Code]....
dropdownlist property datatextfield= "PatientsName" datavaluefield="PatientID"
I want to patientName show in datagrid and save the PatientID in database
in dropdownlist show the all PatientName and save the PatientID . how to show the PatientName in DataGrid.
PatientID, PatientName are Foreign Keys. In DataBase on Save the the PatientID my requiredment is PatientName show in DataGrid based on PatientID.
I have a control with a datagrid in it and I was wondering if depending on the value I get back from the a Request.QueryString if I could set the table name to that (that is the value being sent) and then have it build the columns?
I have about 3 different tables, and they have different amounts of columns, and of course with different names.
how to show the dropdownlist datatextfield selected text in the DataGrid
View 2 Replies
