I have a database containing various datafields that I need to display to a user based on their userID (which is assigned during login).
I need the data to be displayed in a specific format. i already have a table with input (text) fields and select fields created in html.
I need to know the easiest way to populate these fields with the data found in my database in an MVC fashion.
I am trying to populate database fields by reading text from a Word or PDF document. Like if a user uploads a file then certain text from that file can be usd to populate a database table.
View 1 RepliesI'm new to ASP but not programming in general. What I'm trying to accomplish is to have an ASP page where an EU can make some selections and input some text into fields and, upon clicking a submit button, have that input transferred to an access (.Mdb) database's table. I'm not sure how to go about this though. I don't know if it would be an SQL line or a dump to a different file type and then to Access (.Mdb) or something I don't know about.
View 1 RepliesI need to populate my textfields from values in database. I also need navigation buttons to scroll through all records, similar to an access form. Below is what I have on the OnLoad event:
[code]....
Split off from http://forums.asp.net/t/1229987.aspx
How to i perform this function if the code is inside the login view?
i have a textbox with button search.
i would like to search database of input text from textbox and give result out in one view.
I am adding text fields to a page from the database. I set the .ID to match the record ID from the database. Of course becasue the text field is on the masterpage, when I grab the .ClientID, it is ctl00 contentMain$ctl00. what I don't get is where is my ID? If I set it to say AB how do I find the textbox by AB? I thought it should have AB in the ID somewhere. ID is nothing which I don't get either. I'm looping through the controls in a placeholder like this
For Each row In dtData.Rows()
Dim c As Control
For Each c In phTextRequired.Controls
If c.UniqueID = row("CustomFieldID").ToString() Then
Again though what is in the row() is say AB but the id is way off from that.
I have a question related to MDF file that store out data in. Actually I'm a newbie in ASP and I found a project that has ASP.NET plus C# so I want to start that file so placed all the file in C:inetpubwwwroot. There is a folder that call App_Data and has a database file end with .MDF Now how can I open this file to see the whole tables? I have Microsoft server 2008 Developer and I have VS 2008 and how can I start my ASP page with database loaded?
View 1 Repliescan anybody tell me how to show how long your connectionstring has been connected to the database?
View 4 RepliesI can't see it nowhere in Visual Studio's Solution Explorer. The tutorial that I am following is using the Northwind database and hence the need to add the code line "using NorthWindTableAdatpter;" statement.So I thought I needed to add "using myDBTableAdapters" statement in my code which I did, but it's giving an error saying:
"The type or namespace name 'myDbTableAdapters' could not be found (are you missing a using directive or an assembly reference?)"
What's wrong? Where is the class for myDB's table adapter? I searched the .xsd file, but there's no mention of "myDBTableAdapters".It's not there in the Solution Explorer.
So i am developing app according to official asp.net tutorials DAL Tutorial.So i created dataset connected to filebased sql database where are tables VIDEO, GENRE, LOAN! VIDEO has FK to GENRE and LOAN has FK to VIDEO! I tried to create method GetVideoByLoan with this sql command:
SELECT VIDEO.ID_VIDEO, VIDEO.TITLE, VIDEO.DIRECTOR, VIDEO.YEAR, GENRE.TITLE AS GENRE_TITLE
FROM VIDEO INNER JOIN
GENRE ON VIDEO.ID_GENRE = GENRE.ID_GENRE INNER JOIN
LOAN ON VIDEO.ID_VIDEO = LOAN.ID_VIDEO
WHERE (LOAN.USERID = @USERID OR @USERID = cast(cast(0 as binary) as uniqueidentifier) AND(LOAN.ISLOAN = @ISLOAN)
Everything is ok, no problem to return the results, but when i try this sql:
SELECT LOAN.ID_LOAN, LOAN.USERID, LOAN.ID_VIDEO, VIDEO.TITLE, VIDEO.DIRECTOR, VIDEO.YEAR, GENRE.TITLE AS GENRE_TITLE[code]...
i get error.Failed to enable constraints. One or more rows contain values violating non-null, unique,
or foreign-key constraints.
Description: An unhandled exception occurred during the execution of the current web request.
Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
If i run above sql command in query editor everything is fine, but when i try to access it through dataset the above error apperas, despite that first sql was working. I also tried to remove VIDEO DataTable from DataSet and drop it there from server explorer again but it not helped.
Q1: I have an Asp.net page , one textarea there the user can enter all his details like name age gender; how do get the get name, age, gender in seperate fields(text fields). how can i split?
Q:
dawn barric 25 male
answer:
text1: dawn barric
text2: 25
text3: male
I would like to know how i can take a backup of my database to .bak file on my pc using asp.net code?
View 8 RepliesI was develop an application (ASP.Net) Using (VS.Net C# 2010 & SQL Server 2008)
And I was applying (3-tyer Basics) and I'm not using wizard forever in my application.
The problem is :
When I try to passing the parameters to database, some fields I don't type it But it's show in database (Empty like "Space") in text fields and (01-01-1900) in date fields
Although it's must be (Null) .
How I can pass parameters with Null Values for the fields that's not typed?
have sql server, with databaste that i created with one test table.i need to disply the database i try with Gridview but it's dosn't worked, how can i display my database?b.wi know ADO c# , i know how to work with databases on winform. but i never try to do this with asp page,if enyone can send me some good guide to create the connection, and use, insert,update ect..
View 4 RepliesMy employer is changing hosting providers.Our current hosting provider offers MSSQL which we use for the database used on our website. The host we are changing to is insisting that we switch to MySQL because they only offer an older version of MSSQL and are concerned about compatibility issues.I have absolutely no experience working with MySQL and am a novice with MSSQL as well. What is the best way for me to port a database from one to the other?I have downloaded MySQL and Workbench... I've also downloaded the .Net connector as a zip file but am not sure where to extract its contents.
View 3 Replieswhen a website is entered in a browser it should take to a login page (in localhost) and if the login succeed then the site should be loaded else an error page should be displayed. the login page will be connected to local database. how to do this?
View 6 RepliesI am trying to populate a web from from a SQL table.
This is what I have right now, though I am not sure if it's the best way to do things,.
Public Class userDetails
Public address1 As String
Public address2 As String
Public city As String
[Code]....
however, there are like 50 fields in the User db, and it seems like a lot of retyping..
I have developed a webservice. Locally it works fine. But as soon as I put it online, the button which I can click when testing locally is not shown...
See here:
ticketez .nl /scanticket.asmx?op=HelloWorld
My webservice:
<WebMethod()> _
Public Function HelloWorld() As String
Return "Hello World"
End Function
I am looking for some adivce about the possbility of doing the following while working whith MVC. Firstly sorry if the subject line is not very descriptive. I have put something together in ASP WebForms where by I can put a few core fields on my page that identify an object, e.g. a Name and ID... and then I can add arbritrary fields to the aspx page that are now saved and retrieved with the "owning object". These extra fields are stored in a seperate table on the database to the primary object fields. A short explanation of how this works:
1. I have my own version of TextBox (and other input controls) called r3d:TextBox (etc.) and this text box has XmlParent and XmlElement tags, this is done by way of an interface.
2. I have a r3dBase page that all my forms inherit from and this page check for the existstance of any r3d:TextBox (and other input controls) that have the XmlParen and XmlElement tag defiened.
3. When an iheriting form is saved the controls with the Xml tags defined are also saved, but I don't have to change any code in the code behind pages. The framework I have put in place takes care of this for me. The data is saved
4. When an inheriting page is loaded all controls with the XmlParent and XmlElement tags are populated with any data that has previously been saved for them that belong to the main object being displayed on the page.
This provides for a nice easy way for me to extend my forms with non core data when clients request new fields. It also means that different clients can request different new fields and I don't have to make any modifications to the core objects. I have another mechanism that determins what fields are seen by which clients.
Anyway I am completely new to MVC (not written a single line of code) so I have no idea as to whether this paradigm will lend itself to the above described mechanisms or not. Does any one have anythoughts about this, approaches I might try to achive the above to of functionality or perhaps completely different suggestions that would achive a similar end that might work well with MVC
We have some error reporting code that, when an unhandled exception occurs, we send everything over in an email to our groups. This is great except if an unhandled exception occurs on a page with a password field then it's sent over as plain text.
Is there a way to iterate through Request.Form and figure out which item(s) are passwords? This is done at a low level so we can't look for specific controls.
Naturally, we could check to see what type the input box is but I'm not sure if that's the cleanest way. Advice?
Ive created a web site using VS2008 ASP.net and connected to a Firebird Database.
I have a page that has a GridView(added at design time) and have connected to a table at runtime.
[Code]....
All good as the table contents are displayed at 10 rows per page. Ive set the Property AllowSorting to True. Has anyone got examples on how to code the sorting? Ive had a look round the net but all the examples Ive tried dont work.
i would like to do a project that enable to capture photo from webcam, and record audio from microphone store to database. but the photo and audio store in folder and the database only store the filename. later i set the path and its play back the audio and show the photo.
View 2 RepliesIn remote db, I can be able to connect ms sql db as localhost in my connection string like below,
<
add
name="ConnectionString"
connectionString="Data
Source=localhost;Initial Catalog=DBServer;Persist Security Info=True;User ID=sa;Password=*****"
providerName="System.Data.SqlClient"
/>
This is running in server and its working fine.
If i want to make any changes in db structure or need to modify any data values, i have to login remotely to my server and has to open sql server management studio do db change or value editing stuffs. Its really getting iritating when the remote machine looks slow.
I just want to know how to configure the db hostname like dbname.domainname.com or mssql.domainname.com in server, so that we can open the server db in local using sql server management studio.
The application installed in windows server 2008 and using IIS 7.0 & SQL Server 2008
I have only little knowledge in server.
I am pretty good with HTML, PHP & MYSQL but this is my first go at working with a windows host and an ASP script. I recently purchased a script that matches my clients needs and when i have opened the folder to view the files its all double dutch to me apart from one css files which makes perfect sense to me!
Im stuck with is the database file included in the template, i ave been unable to import it into MSSQL using 'My Little Admin' which is the control panel provided by my hosting provider. Looking through the file with notepad it seems to contain the information for several tables but i cannot figure out for the life of me how i import it with 'My Little Admin'
