i am a problem in dropdownlist control.it shows very basic but it is not working insipite of i used many methods:(
There is a dropdown list.it items value and text come to database.i want o add to item using button but some of id come previous page.so that,i must return same page.I want to that: when i added record to dropdownlist i take "Record Added" to use label or literal.
its my code :
[Code]....
I am using FormView to display one record at a time and after I add a new record, it won't display the last recorded added.How can I force FormView to display the last record added?
View 2 RepliesI have a delete button bellow my gridview and I want a pop up to show when no record is selected and tell the user to first select a record. The button click event would show the pop up, but my gridview data blanks out.
Here is my code:
[Code]....
I have a DetailsView using a LinqDataSource. I have it connected to DropDown so the user can select a record to edit. This configuration works. However when I add a record after I enter the data and press insert link the DetailsView reverts to another record. How can I make the DetailsView stay on the newly added record?
My add button calls:
protected void btnAddRec_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}
In my table I have 3 fields:
[inFrmDate] (this is the key field), [inFrmData], [totFrmData] (this accepts nulls)When I try to add [inFrmDate], [inFrmData] to the GridView I get the messageto the effect that the:
@inFrmDate scalar is not declared.
But as you can see from below it is declared:
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
[code]....
Now I am using Editable Grid View in that i am using two dropdown and one text box now i click add button the previous record is cleared
View 1 RepliesI am working on a Webbased project, where we have a Master page with some child page. In the child page there is GridView control, Footer of this Gridview control have some TextBox control to get the input value from user and insert into database. Once the data is inserted into database. We are reloading the inserted data into the same Gridview control, But Gridview control is hot Binding/showing up the recently added record.
I debugged the code and seen the Dataset which is getting the data fron database have the updated row but after binding to Gridview control. The Gridview control not refreshing the data. This is happening while we have Master page and child page.
I'm trying to put a registration page together in Visual Web Designer.
I would like to send a confirmation Email after someone is leaving his registration data and pressing the INSERT button.
The key fields in my database are: Email, Name, Surname, Address
Before I send the confirmation Email I would like to check if the email value entered in the form is realy added to the database.
I was copy past already some C code in my page, therefore it will be fine if the code can be in C.
- checking if record is realy added to database after pressing INSERT button
- setup the confirmation Email
I would like to be able to send an email notification if a website user inserts a new record in a table. This will be a relatively rare occurrence so it would be very useful to have the notification as opposed to having my users check my summary page that lists all the IDs that have a record in this table. I googled but I must not be hitting on the right keywords or phrase to find the answer to this question. 1) letting me know if this is possible (I'm version ASP.NET 2.0 and using VB with a SQL Server database) and/or 2) pointing me in the right direction to find out how to do it if it is possible.
View 6 RepliesI am using Jquery and Ajax to add new record into the database. After successfully insert the record, I want the listview I have to automatically append the previous added record.
The record can be added successfuly into the database and the only problem is I want them to be display in my listview after I click submit button. So is there any solution for this?
Below is my code:
[Code]....
[Code]....
[Code]....
[Code]....
In My asp.net application i have Invoice Entry where in our company daily we are Receving some 40 Invoice or more..
Im showing this 40 Invoice Report in crystal Report.. where user can view one by one in page....
Now whatz the problem is on navigation to next (or) previous in crystal Report Toolbar it cause postback it take lot of time to show 40 invoice daily.. so my manager want without post back, so on clicking next (or) previous it show next Invoice without waiting..
I tried in Ajax Updatpanel also still it takes lot of time to show next Invoice.
I have a form that has several textboxes, I am trying to create a label that shows first and last name that was entered in those textboxes after hitting insert button. The label would say "You have successfully added 'First Name' 'Last Name'"
View 12 RepliesI have one text box in my page and 1 button
users type some number in this TB
I want when users enter their number in text box and click on button to insert it to database
it checked if in database was that number it show message that "this number is in database please type other number"
how i can do it?
Recently i am working in VS2008 installed in windows xp SP2. In the toolbox i added a new tab and added some third party controls in the toolbox, by using "Choose Item" dialog.. I also added Ajax ToolKit to the tool box. It worked fine and i could drag n drop controls.
But then if i restart VS2008, all the tabs i created and controls in it goes off and disappears ncluding Ajax Toolkit. Each time i restart it, I have to have add those controls newly?
Is this a Bug?? or Is there any solution for this?
I have the following code:
XElement Categories =
new XElement("Promotions",
from b in db.GetPromotions()
select new XElement("Promotion",
new XElement ("Category",b.CategoryName),
new XElement("Client",b.ClientName),
new XElement("ID",b.ID),
new XElement("Title",b.Title)));
XDocument mydoc = new XDocument();
mydoc.Add(Categories);
try
{
// Load the style sheet.
XslTransform xslt = new XslTransform();
xslt.Load(@"C:WebDesktopModulesPromotionsTransList.xslt");
// Execute the transform and output the results to a writer.
StringWriter sw = new StringWriter();
//XsltSettings mysettings = new XsltSettings();
XmlWriterSettings mysettings = new XmlWriterSettings();
xslt.Transform(mydoc.CreateReader(),null, sw);
String mstring = sw.ToString();
It generates the following string:
<ul id="red" class="treeview-red" xmlns:asp="http://schemas.microsoft.com/ASPNET/20">
<li><span>Arts & Entertainment</span><ul>
<li><span>Client 1</span><ul>
<li><span><asp:LinkButton ID="LinkButton2" runat="server" OnClick="LinkClicked" Text="Get your Free 2" /></span></li>
<li><span><asp:LinkButton ID="LinkButton4" runat="server" OnClick="LinkClicked" Text="Get your Free 4" /></span></li>
<li><span><asp:LinkButton ID="LinkButton5" runat="server" OnClick="LinkClicked" Text="Get your Free 5" /></span></li>
</ul>
</li>
</ul>
</li>
<li><span>Community & Neighborhood</span><ul>
<li><span>Client 2</span><ul>
<li><span><asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkClicked" Text="Get your Free 1" /></span></li>
</ul>
</li>
</ul>
</li>
<li><span>Education</span><ul>
<li><span>Client 3</span><ul>
<li><span><asp:LinkButton ID="LinkButton3" runat="server" OnClick="LinkClicked" Text="Get Your Free 3" /></span></li>
</ul>
</li>
</ul>
</li>
<li><span>Home & Garden</span><ul>
<li><span>Client 4</span><ul>
<li><span><asp:LinkButton ID="LinkButton6" runat="server" OnClick="LinkClicked" Text="Get your Free 6" /></span></li>
</ul>
</li>
</ul>
</li>
</ul>
Now I take the string and add it to a panel which is part of a view in a multiview control: Panel1.Controls.Add(new LiteralControl(mstring)); I have tried to play with Page.ParseControl, but I cannot get it to work right in the panel, the linkbuttons do not show, even though the text is there in the source. Now I tried this: Control myctrl = Page.ParseControl(mstring); Panel1.Controls.Add(myctrl); and I get this as the one of the controls:
a id="dnn_ctr954_ViewPromotions_LinkButton2" href="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("dnn$ctr954$ViewPromotions$LinkButton2", "", true, "", "", false, true))">Get your Free 2</a>
It doesn't work the way expected, dotnetnuke is doing some nutty stuff here using the parse control. it seems to drop my LinkClicked event.
after a DetailsView (DV) 'Insert' (triggered by a DropDownList (DDL)) the DV shows the first record (in the DDL)!Are there VS2008 means to keep / show the just entered data - again ready with the command row "Edit/Delete/New" enabling me to e.g. "Edit" the just entered data?This DDL/DV scenario works just fine but to show my just entered record I have to leave this page and start calling this .aspx page again in order to see the name in the DDL and, hence, in the DV.I.e. I'm looking for a kind of automatic 'postback' bringing my just entered data back
View 9 Repliesi want to show gridview footer when there is no records.
currently when i delete all record then footer not shown.
i tried
[Code]....
but not working
i want show ten record from table in the gridview at 2 column in five row.
like this:
------------gridview-------------
record1 | record2
record3 | record4
record5 | record6
record7 | record8
record9 | record10
1 2 3 ...
-----------------------
My prob is that when data inserted in database after that without any button click the new record show in popup box ?
View 10 RepliesA few questions regarding detailsview and gridview:
1) when page load, how can I default the detailsview to show the first record from the gridview? SelectedIndex does not have any effect to my detailsview.
[Code]....
2) how can I select a record in the gridview if my table has 2 key fields using below syntax?
[Code]....
I have 50000 record in two tables which need to show in grid? and the records in the table use to insert , update and delete frequently. I need to load fast all the records. which method i should bind to get as quick as early as possible. Which z best method to bind whether using SQL datasource, creating views, using datatable, creating stored procedure etc?
View 8 Replies
[Code]....
The following table contains several records.Why do I see only the last stored data?
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 radio button list that on selecting, queries a table and displays data in a textarea. now i'm trying to enhance my code so that the value of the radio button is displayed within the URL. that way i can send users links to content displayed by the radio selection (i.e. articles).
So far i've been able to place the "Article_PK" within the url successfully when the user makes a selection. now i'm just stuck on how to get my databind working again. so basically, i need to read in the value of the "Article_PK" in the url to display the data within the textarea. need someone with some mad coding skills to save the day!
code behind --------
public partial class frm_Articles : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)[code]......
i need to show for every refresh of page five categories, every time different how can i do? in SQL do not exist select RND(field)...
View 5 Replies