how to show error msg in literal if no record found in database according to the text entered in textbox1 and textbox2 else if show record in gridview if the text entered in textbox1 and textbox2 will be found in database ...
View 1 Replies
I 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?
I am working on a project in .NET (C#), connected with a database. And I am entering values in database through 'text-box' control, for a part of the project. What I want is to check if the user entering value already exsists in the database and if so, shows error during that time only.
I have searched for any familiar post here, that could solve my query, but didn't get any.
my EXACT objective(if not cleared earlier):-
when the user enter the value in
textbox, automatically an event to
check any duplicate records in
database should occur. And if found,
displays an error message
I have a gridview in which dtasource binded is a List which returns class type. If no records in list, I want to display 'No records found' in GridView.
[code]...
In else part, what code i have to write to get desired output?
i m doing when i enter travel id in textbox1 and click on button1 then in textbox2 i retrieve the travel agency name according to the travel id i entered in textbox1, I want when no record is found according to the travel id i entered in textbox1 then in textbox2 it shows the message no record found ...this is coding i use to retrieve record in textbox2 by enter travel id in textbox1 : have a look ...
Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True")
Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT * FROM a1_vendors WHERE VendorId ='" & TextBox1.Text & "'", SQLData)
SQLData.Open()
Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader()
[code]...
i want if i search UserName 'xdeeeee' that is not exist in database then a label should display saying "Sorry ‘USER NAME’ not found".
have a look below picture.
<asp:TextBox ID="SearchByUserName" runat="server"></asp:TextBox>
<asp:Button ID="SearchByTagButton" runat="server" Text="SEARCH" OnClick="SearchByTagButton_Click" /><br />
[Code].....
supose i have one table nd there are many records in table .this table access by many usewhen any user inserted record in database then show message in popup boxnd this message show in all users
View 4 RepliesHow to show confirmation message after the process of saving or inserting a record to Database?
View 3 RepliesI would like to show a modal ui-dialog when a record is successfully saved to the database.
View 8 RepliesMy prob is that when data inserted in database after that without any button click the new record show in popup box ?
View 10 Repliesi add below coding in my master page.
<asp:Literal ID="Literal2" runat="server"></asp:Literal>
[Code]....
I 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 an ASP.NET Page that updates registered User Address Details for a selected record.
Below is the Update method that i am calling from Controller.
When i am calling ApplyPropertyChanges method, I am getting the below error.
Did anyone run into the same error while updating the record with Entity Framework.
[code]...
in code behind i want to show clientname and leave a line and clitntittle using a literal field.
View 7 RepliesFor my Dynamic Data site I have a table that has a join to a number of other tables. If I use the standard page for this table I get all of my columns from the primary table and related tables (which is good) and the appropriate literal values from the related table (which is great). The bad part is the order of the columns.
To address the order of the columns I created Custom Folder/Page for the table. I also have a partial class that controls date formatting. This takes care of the ordering of columns fine (which is a step forwared), but now I'm seeing the foreign key IDs instead of the literal values from related tables (which is a step backward).
All I did was copy the standard page to the Custom folder for the table, turn off AutoGenerateColumns, and specify the column order and display name. Why would the foreign key change occur? As a side note, if addressing column order in the partial class is the preferred method I could go that route, but I haven't been able to understand how to do that in VB (I've seen many examples in C#, but that's not my strong point).
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.
I want to show editor content at literal at button click using jquery. I have editor,literal,button like below.
<cc1:Editor ID="Editor2" runat="server" />
<asp:Button ID="Button1" runat="server" Text="Preview" />
<asp:Literal ID="Literal1" runat="server"></asp:Literal>
I show like below.
Literal1.Text = Editor2.Content;
how can i do it using jquery.
I recently upgraded my database to sql server 2008 and my visual studio to sp1. I did this after i uninstalled the original versions. when i run old projects made in the previos configuration i had (express and viaual studio professional) i cannot connect to database, even though i have added the connections in visual studio and made sure sql server is running. Also When i go to create a new project in visual studio i cannot see the standard project types anymore, i get an error "no template information found".
View 4 RepliesI have a javascript to enable text boxes when called, I want to trigger this code when a user picks value "Custom" from a dropdownlist, so that I can display/Hide these new textboxes.
<asp:DropDownList ID="DateRangeDropDownList" runat="server" Enabled="False" **OnSelectedIndexChanged="EnableTextBoxes('SomeValue');"**>
<asp:ListItem>Some Value</asp:ListItem>
<asp:ListItem>Custom</asp:ListItem>
</asp:DropDownList>
but when I run this code I get Too many characters in character literal
i have a web form to display information one record per page. I use database SQL server 2008 express. In my form; there is a textbox and next to the textbox, there is a button to search
[Code]....
when i click on the searchButton, it finds the correct record, the correct StudentID, but i can not achieve to navigate to the found record.
In my MasterPage, I'm using LoginView control that looks like this:
[Code]....
In the code behind, here's what I do:
[Code]....
When I try to pull up the home page -- as an unauthenticated user -- I get "Object reference not set to an instance" error pointing to where I start building the user menu i.e. litUserMenu.Text = "<li>...
I am counting from a table for that i have written code as below
protected void get_Id_Afterpoint()
{
int counter = 0;
string strSql = "select count(*) as ID from tblEnergy where ID=?";
OdbcCommand com = new OdbcCommand(strSql, con);
com.Parameters.AddWithValue("ID", DropDownList1.SelectedValue);
OdbcDataAdapter oda = new OdbcDataAdapter(com);
DataTable dt = new DataTable();
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
lblID2.Text = "1";
}
else
{
counter = dt.Rows.Count;
counter = counter + 1;
lblID2.Text = Convert.ToString(counter);
}
}
there is no record related to DropDownList1.SelectedValue. but as i am counting if(dt.rows.count) and i put break point on the bolded part it shows 1 record. how it can be possible?
I have a formview and inside it there are two textboxes taking integer as input.I put a condition that if both textboxes are empty then user should be notified that "Please put value in any one of the textbox".It is working very fine.From database side DBA checked that if user input any integer value in any one of the two textboxes and if it is already found in database then there is no insertion.The problem is that everything is working fine and i checked in the database that the record is also not inerting due to duplicate check but user is getting message that "Record inserted successfully."How to stop this message and how to notify user that you have entered duplicate value and transaction should also not been done. Means all inputs should be there rather than clearing textboxes that could be done when "Record Inserted."
[Code]....
I know this is gonna be easy for some of you. I have a page that I am making for a timekeep site for my organization. The site pulls the user's username. I have a table in MSSQL that has the users informaton. This table has an ID for each user. I need to get the ID to display in a text box or literal so that I can use it in a query. Once it is in the control. I will use it to make the entry into another table that records the users time.
There may be an easier way to do it. I am just starting out and do not know how to do it.
I try to mak a custom textbox. Something pretty easy to do but I can't figure out one thing. When I write my textbox in designmode I have this <custom:Textbox runat="server" ID="Textbox1">Test</custom:Textbox> The problem is The textbox is a webcontrol I added to my class [Parsechildren(false)] like this [Parsechildren(false)]
public class Textbox : WebControl
{
}
now the problem is I want to able to write the Text from the textbox between the beginningtag and andingtag but I want to disable every other control in designmode. When I add < between the tags then you can see you can write all tags between it. disable all controls except literal between the tage in designmode?
