i want to create functionality like
1)i have a employee table in database
2) i have fields on a form
textbox1
textbox2
when i enter employeeid in first textbox and after user leave textbox1. i want to display related employeename from database in textbox2
I have 2 gridview with add/remove buttons between them. I want the user to select an item in one gridview and based on the button clicked I need to remove the row from one gridview and add it to the other. I can idenfity which row is selected but I don't know how to remove/add the rows.
View 6 Repliesis there enter and leave event on TextBox - asp.net ?
i need that when i get into the TextBox the TextBox color will be yellow
and when i leave the color will be white,how to do it ?
As I call the Controller to exit the focus of my textbox? I need to exit the textbox, go to the database to get information that will supplement the information from my form.
View 2 RepliesHow can I validate an email id on a textbox leave event
View 8 RepliesUsing code found here : [URL] .... I was wondering if the text could be formatted as in maintaining line feeds. I'm reading from an SQL 2008 database which has a text field. When I call it up the text format is gone. as an example I get :
what colour is the sun A:Green B:Red c:Yellow
instead of :
what colour is the sunA:Green B:Red c:Yellow
How to display data from textarea the way it is been typed as ineg. hiiihello what are u doing I want to display the data typed in textarea shown above inside the panel the way it is typed.
View 1 Repliesi'm trying to retrieve the data from a sql query into several textbox and dropdownlist but can't there is my code and it send a ex "Conversation of the string "@ p2" in the "Integer" type is not valid"
Dim con As String = "Select * from tbl_Cotizacion WHERE numCotizacion = " & txt_nGuia.Text
Dim cmd As New SqlCommand(con, conexion)
conexion.Open()
cmd.Connection = conexion
[CODE]...
When i navigate to certain page, gridview should be display.
Conditions is:
1)There is no data to display.(now only i am going to enter data). I am not binding gridview to any datatable/dataset
2)Initially it can show 10 or 20 empty rows.(all row should be editable. we should enter the value in that rows.)
3)When i click next button after entering 20 rows it should add another row. and so on..
i want a gridview like excel sheet.
I would like to display students and their grades with a GridView and LinqToSQL like this:
[Code]....
I found this topic but it doesn't answer my question: http://forums.asp.net/t/1557987.aspx
I have a many-to-many relationship between students and assignments called "grades".The grade for the assignment is stored in that table in a "gradeNumber" column.The many-to-many relationship seems to be a problem.I tried adding a TemplateField to my grid:
[Code]....
It doesn't work:
...student does not contain a property with the name grade.
It does work when I use class.name however to get a student's class he is in.In code students .grade[0].something works however My LINQ entities are extended with custom code to allow me to retrieve studentx.Assignments or assignmentx.Students.(I would also like to specify which assignments should be displayed in the grid.)
I am building a user registration form in asp.net. I want to check if the username is available or not on the leave event of the TextBox. I am not able to get the Leave Event of the TextBox.
Should I use OnBlur event of the Html TextBox.
I have a gridview displaying "registrationtype id" (FK) from the registration table. I want it to display the related name instead of the id from the registartiontype table.
View 1 RepliesI am using this to display a value from database to text box. I am not using the dataset just for this text box but for other dropdown lists too (which are working alright), so the fact that I am using dataset for a textbox is not going to be very expensive in terms of performance.
Basically, I am doing something like this -
public partial class _Default : System.Web.UI.Page
{
private string varState;
protected void get_city(object sender, EventArgs e)
{... //code specific to this function which is working alright
varState = (ds.Tables(0).Rows(0).ItemArray(0)).ToString();
textbox1.text=varState;
}
}
On Build I am getting -
error CS0118: 'System.Data.DataSet.Tables' is a 'property' but is used like a 'method'
I have 2 tables:
User(Id PK, TitleId FK, Name, Active)
Title(Id PK, Text)
Title is a lookup table of titles (Mr, Miss,...) and its got a relationship with table User by TitleId.
Now I'm trying to display the data in a web page using .net and Entity Framework. I'm using a ListView control and a query as a source. it all displays fine except for the Title.
Here is my code:
MyEntities _entities = new MyEntities (); User user = new User(_entities); IQueryable u = (from x in _entities.Users where x.Active == true select x); ListView1.DataSource = u; ListView1.DataBind();
and the code in the front end:
<asp:ListView ID="ListView1" runat="server" EnableModelValidation="True" DataKeyNames="Id"><ItemTemplate> <tr> <td> <%# Eval("Id") %> </td> <td> <%# Eval("Title.Text") %> </td> <td> <%# Eval("Name") %> </td> </tr></ItemTemplate><LayoutTemplate> <table ID="itemPlaceholderContainer" runat="server"> <tr runat="server"> <th id="Th2" runat="server"> Id</th> <th id="Th1" runat="server"> Title</th> <th id="Th3" runat="server"> Name</th> <th runat="server"> </tr> <tr runat="server" ID="itemPlaceholder"> </tr> </table></LayoutTemplate>
How do I manage to get the Title Text associated with a User to display on the ListView?
I have two related ddl's on an updatepanel and would like to put the result of that query on a textbox... So pretty much using this kind of query on Sqldatasource
<
asp:SqlDataSource
ID="CmmtCurrentAmt"
runat="server"
ConnectionString="<%$
ConnectionStrings:RelationshipsConnection %>"
[Code]....
Is there a way for me to post the result of this query into a textbox?
I would like to display students and their grades with a GridView and LinqToSQL like this:
assignment1 assignment2
Student 1 55 89
Student 2 87 56
Student 3 92 34
I have a many-to-many relationship between students and assignments called "grades". The grade for the assignment is stored in that table in a "gradeNumber" column.
I would also like to specify which assignments should be displayed in the grid. Btw, my LINQ entities are extended to allow me to write/get studentx.Assignments or assignmentx.Students.
the following content I created a table (Workers) with two columns(username,userid). Now i have Dropdownlist and textbox. Dropdownlist for Userid, Textbox for Username. If i click on the userid in dropdownlist, then the particular username should get displayed on the textbox. For this i have tried codings.
private void DropDownList()
{
OleDbConnection databaseConnection = new OleDbConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);
databaseConnection.Open();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter("Select userid from workers", databaseConnection);
DataTable dataTable = new DataTable();
dataAdapter.Fill(dataTable);
DropDownListMaterials.DataSource = dataTable;
DropDownListMaterials.DataTextField = "userid";
DropDownListMaterials.DataValueField = "userid";
DropDownListMaterials.DataBind();
}
protected void DropDownListMaterials_SelectedIndexChanged(object sender, EventArgs e)
{
OleDbConnection databaseConnection = new OleDbConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);
databaseConnection.Open();
OleDbCommand MyCommand = new OleDbCommand("select username from gridview where userid=('" + DropDownListMaterials.SelectedItem + "')", databaseConnection);
TextBoxUsername.Text =
}
private void DropDownList()
I have a search textbox and when I type something to search, it shows up the lists of related items from database.
If I type "Zio" on textbox, it displays:
Zion, henry
Zion, khery
Zion, malle
Zion, henry
Zion, khery
Zion, henry
What I wanted: I want to count and display those records with the count values. e.g
Zion, henry (3)
Zion, khery (2)
Zion, malle (1)
How can I achieve this ?
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 have to create a simple application which scans, displays and stores the info from a barcode. I have been able to sort the scanning and display part of this application but I need to know how to store the infromation entered into a textbox to a database and then be able to display the stored data as a list at a later stage.E.G. Once the "STORE" button is clicked, the information/text within the textbox is stored to a database. Once the "VIEW STORED DATA" button is clicked, the stored information in the database is displayed as a list.I am a complete beginner when it comes to creating web applications using asp.net. Also, the type of database to use (i.e. sql, wamp.etc) and how to link it to my application is also puzzling.
View 1 Repliesin my asp.net_vb web there is a text box (textbox1) in which a date is dispalyed from database (eg 21-Mar-2012) in another text box (textbox2) i want to display
if the date is less than 30 Jun then the textbox2 should display 1 Jul+the year of textbox1
if the textbox1 date is greater than 30 Jun the text box2 should display 1 Dec + the year of textbox1
my web is in asp.net and code is in vb
I am very new to MVC and I have a Model like this
User :
FirstName : TextBox LastName : TexBox User Commitee : [CheckBox Textbox] [CheckBox Textbox] [CheckBox Textbox]
I store if user is in committee in a separate table.I need to insert selected check box value and related text box to database.How can I achieve this ? Can this be possible with using EditorTemplate ?
I have two SQL Server tables with Primary Keys (PK) and a Foreign Key (FK) linking the two tables:
1) Table "Order"
OrderID, int, PK
AddressID, int, FK
...
2) Table "Address"
AddressID, int, PK
City, nvarchar(50)
...
Then I've created an (ADO.NET) Entity Data Model out of those two tables. Now on my (ASP.NET) webpage I put a GridView with an EntityDataSource. In my GridView I want to display two columns:
OrderID City (belonging to that order and linked by the AddressID-key) How can I do that? My problem is: When I configure the Entity Data Source I can select an "EntitySetName" which can be either "Order" or "Address" but not both, nor can I select any kind of relationship. If I select "Order" as EntitySetName
then in the GridView I can add the columns
OrderID
Address
Address.AddressID
Adding the column "Address" displays empty cells. Adding "OrderID" and "Address.AddressID" displays the expected IDs. But how can I add the "City" of the related address to my GridView? Edit: Clarification:
The Entity Framework has created a class "Order" and a class "Address" corresponding to the database tables. The class "Order" has a reference to an "Address" object as a navigation property, corresponding to the 1-n relationship between Address and Order table. Basically I want to have a column in my GridView which displays Order.Address.City. I have tried to add a bound field with "Address.City" as data field to the GridView but it results in a runtime error ("no such property...").
After saving image in db how can we retrieve it in gridview like thumbnail size image and by clicking on image in gridview its open as preview. How can we do this in asp.net using c#.
View 1 Replies I have a table with product codes and items related to the codes.
TABLE 1
Product Codes | Item Number
RP WOEWPOI
Y OWRT0W
ZZ LDSFLSGKK
I have created a second table which contains a product group. This table holds information on where the Product Codes belong. I'm not sure if I have designed this table correctly.
TABLE 2
Product Group | Product Codes | Product Codes1 | Product Codes2 |Product Codes3 .........etc etc
Tin RP TL ER AS
Metal Y ZZ
Water EF TY AS
Coffee OP RC
My aim is to create a report in where I know a particular item is related to a certain Product Group. I'm not sure if I'm going about it the right way though. I need to know how to link it if it's one to many or many to many or...I really don't know.