This is probably simple, but I'm unsure of which tools to use for the job. Basically, the user needs to enter either an account number or name (same text box), and when they click search their account details will appear below in detailsviews and gridviews. What tools do I use so all this can happen on the same page?
View 1 RepliesHere is what I'm trying to achieve: The user enters in the textbox a date. It can be:
20.04.2010 or 20/04/2010 or
01Apr2010 or Apr 01 2010...
Any other formats should be forbidden. When the user leaves the textbox then the date should be displayed as 01-Apr-2009. I already tried but I got only when am entering the numbers only like (21-04-2010) but I want to entering the string like apr, jan, nov .
i'm trying to to create a simple string array with data retrieved from a select statement(SELECT firstname FROM customers , for ex.)
View 6 RepliesHow to select data from database to listview using a web method?
View 7 RepliesI've got a text box on my page called txtNotes - multiline textbox.
When I add the text into the sql server database, the line feeds are not getting entered.
I have a function that replaces the line feeds with "<br>" and it's still all in one line. Also I don't see the normal square type entity after each line in the database, that is normally there for a line feed.
However, when I copy from the database and paste it to Notepad, it is formatted correctly
[Code].....
There is an asp.net Page in which i have to entered the quantity in the textbox txtRQ..Now if i select yes in the dropdownlist named ddlMR,this qty of the textbox should get added to the qty field of an oracle table GOODSMASTERand if i select NO in the dropdownlist ddlMR, this qty should be added to the qty field of another table called SALESRETURNDETAILS.
View 2 RepliesI have a webform, that needs to check the values entered against a database, and then send an email if the request turns out positiv.
View 11 RepliesIn the registration page of my project i want to check whether the enterd userid is available in database or not without sendig the whole page to server and i made userid as a primery key.
View 1 Repliesi added ajax editor control in my webappliaction, when enter some text in editor control and submit into database then i have to clear entered text in the editor control. what to do ?
and also i dont need top toolbar of editor control. what to do?
My Database field :
ID Name Age
1 Sumit 23
2 Manish 25
3 John 22
i have two textboxes and 1 button and label1 in my asp.net webform. when i enter Sumit in textbox1 and 23 in textbox2 then it validates the database to check whether then value entered in textbox1 is present in Name column of database and 23 is present in Age column of database....then it redirect to ~.Default2.aspx else shows error message in label.
I'm a rookie at all this and need some insight from veterans.
I'm working on a web form that submits data to a database. I'm using C# as my code behind language and am using LINQ to SQL with a LINQ data source. I'm working in the code-behind page to format/concatenate the user's data before going into the database.
Everything looks like it's formatted and aligned correctly. I am not receiving any errors or warnings, but on submission none of my data gets entered into the database.
My question is... how should I troubleshoot or go about finding out what's keeping my data from being entered into the db.
I have a simple web form that takes data inputted by a user online but I can't get the date field formatted so it can allow UK short date format to be entered. I need to allow dates to be entered like this: dd/mm/yyyy but currently if I enter the UK format date 25/02/2011 I get an error, as the field is in US format (mm/dd/yyyy).
It's a SQL database created from within MS Visual Web Developer 2010, and I'm a SQL newbie.
How do I change the date format to UK so UK format dates can be accepted?
I am learning how to use repeater and datagrid. I've been able to update a datagrid successfully. I have two text box, which take an item description and quantity, save them in a database, and display them back in a datagrid whenever the user access the page again. If the user were to enter a value, let say description ='coffee' and quantity= '15', it would save them in the database properly. However, if the user refreshed the page, a second row with the same value ('coffee', '15') is added to the database again. How can I avoid this from happening?
View 1 RepliesI have one text box for accepting date. I want to store date column in database is null when the text box value is null and how to bind the this null value to text box when i retrieve.
View 1 RepliesI want to display all the items existing in database for ex:
If i enter just book. All the items with book work should get displayed
Example in google search as soon as we enter one word related all things get displayed. I am not talking about auto completion
I want to compare a user-entered value on a Web form against an array of existing values from the database, and do so on blur. If match, then show error. Scenario is to stop user from needlessly filling out other fields if this record has already been entered.
how to trigger this? What parts are client-side, what parts are server-side? Can I do it without Javascript?
I'm creating some url rewriting for asp.net. Now I am tobbing if I should include the id in url or just the title. Do you guys know if it's a significant performance hit to lookup an item by title instead of id?
View 4 Repliesbasically I am try to replicate a filtered list like this;
[URL]
but I need it to work on an asp.net, and rather than having to hit a button to load an xml data file I need the data to be initialised when the page loads and get the data from a SQL Server database.
is there a standard .net control I can use?
i want to fetch data from Oracle Data base using Tab key , like when user enter ID in one text box and press Tab key it should fetch data in other text boxes , i am using web form.
View 1 RepliesI got an unusual problem. The solution is most likely very simple or completely impossible. I want to dynamically select a property based on a string value. I am using LINQ which automatically creates a class for each table. The actual columns in the table become properties of the class. I need a different column based on the current culture settings as the different columns contain translations. For example, if I want to set the text of a hyperlink to English I choose the EN column as follow:
[Code]....
I am still learning about datatype conversions, but what I am trying to do is
SELECT (month + '/' + year) AS ExpirationDate
Like this it gives me an error since the two columns are int, and I am trying to add the /
I know I have to CAST or CONVERT, how this is done?
I want to create an Select SQL string by some search fields. Since I can't check the blank ones, otherwize it would look for blank, I have to do this on steps, adding them if they where not in blank, so, for that I am using something like this:
String SearchString = "SELECT * FROM Sala ";
String SelectWhere = "WHERE "; //This where is because I may receive all empty, so, the WHERE would make problems in the string.
If (TextClassroom.Text != "") {
SelectWhere += "(Classroom = " + Classroom.Text + ")";
}
But here is the issue. I may search for more than one at once, and that, would make me have to put an "AND" clause between them. How do I check that in the less number of lines as possible? I made a count variable, so I can count when it has been entered. But, getting to the third time it gets in, I have to check if the number is 1, or the number is 2, to see if I need to put an AND, right? And that would start making hard when we have, like, 10 fields. Is there an easier way to check when to put the AND without that many checks inside checks of empty texts?
I have three connection strings in my web config file one for developement db, test db, and production db.
Currently I have all three defined and using the same name and I comment out the connection out the
inappropriate strings.
So in my code I use the connection string like so:
WebConfigurationManager.ConnectionStrings(
"A_DevConnectionString").ConnectionString
and in my Web.config I have three conn strings :
a_devConnectinoString
a_testConnectionString
a_prodConnectionString.
Can the connectionstring be selected dynamically through the web.config ?
I'm trying to use a function in my code behind to let me select a different column each time by calling the function with a different parameter.
However, I keep being told 'invalid column name', even though in the error page the column name appears perfectly valid.
Private Function getData(ByVal s As String) As String
have the string with javascript call which is bound to HTML Select event:
@Html.DropDownList(Model.DropDownName, Model.ItemsForView, new { onchange = "someMethod('someArgumentValue')" })
which is rendered to the following code:
onchange="someMethod('someArgumentValue')"
Is there any way to make ' symbol render "as is"?