I have a form where a user enters their name, date etc.i also want them to be able to click on a browse button and select a file which will then appear in a textbox. when they press submit i want the file name and path to be put into the database. e.g."C:windowsworkwork.doc". Basically I don't want to UPLOAD the file
just enable the user to browse to it and send the filename and path to the database.
i want to save a text in an access database. this text is much larger than 255 characters.how can i do that?
what type should i use?
How To Save Video files into folder and save path only into database in asp.net using c#.
View 1 Repliesone button i use to save form entity.and other is to navigate to next pagwhen i click on save button i use jquery to save form entity in database. and form remains as it is
<script type="text/javascript">
Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
i have mdb filis in a folder in server...i want categorise them according to the date created...means creating the tree menuand clicking the child menu will download or prompt to save the mdb file to client machine
View 6 RepliesWe are using a DataList with a couple fields inside the ItemTemplate. The one that is giving me trouble is the Hyperlink. The code is below. When the page loads the hyperlink renders like this:
[Code].....
I cannot see where the extra # signs are coming from. They don't appear to be in the field in the table.
I'm trying to access a hyperlink on my listview. When the user logs in, the hyperlink will show on my homepage. It doesn't show.
[code]....
I am build an asp.net website that has an Access database. We are using a DataList with a couple fields inside the ItemTemplate. The one that is giving me trouble is the Hyperlink. The code is below. When the page loads the hyperlink renders like this:
<a
id="ContentPlaceHolder1_DataList1_lnk_6"
href="#http://www.washingtonfaire.com/#"
target="_blank">Washington Midsummer Renaissance Faire</a>
But when I click on the link, it tries to navigate [URL] What are we doing wrong?
[Code]....
I tried this too.
[Code]....
in asp.net i want the user to chose a photo to upload from their HD . then i want the uploaded photo displayed and an hyperlink option to save or reject this photo. if accepted the filename will be stored in a DB.
the problem is displaying the photo before it has been saved.
I display strFileName which works on my PC but not on my laptop.
[code]
What is the best way to insert and retrieve images like :
In the database in binary form retrieve it with imagehandler, or
In the database by saving the path of the folder of the images and retrieve it, or
by saving the images directly to the folder and retrieve it...
i m using asp.net 2005 with access 2003. with the fileupload control, i can store the vlc player in my folder by using tis code
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
If FileUpload1.HasFile Then
FileUpload1.SaveAs(Server.MapPath("upload/" & FileUpload1.FileName))
Label1.Text = FileUpload1.FileName.ToString
con.Open()
Dim dat As String
dat = Now()
Dim cmd As New OleDbCommand("insert into filenms values('" & Label1.Text & "','" & dat & "' ) ", con)
MsgBox("Updated")
Try
cmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox("type correct Text and not updated")
End Try
End If
End Sub
but it is showing me " The page cannot be displayed ". how can i store
I have a webform that writes respondent info to a sql data base. I want to send a email campaign and use a unique identifier so that if
1. joe clicks on his link http://www.test1.aspx?209
2. tim clicks on his link http://www.test1.aspx?603
that when they click the form submit the data gets written into the correct row where 209 and 603 are their respondent numbers already in the data base. This is my first attempt using c# and I couldn't find anything in my books about it.
I have three tables in my sql database
contacts
survey answers
respondent_initial
Contacts holds all customer data with custid.
survey answers has assigned everyone how took the survey a number in a field called
respondent_no.
respondent_initial holds input from a webform where I populated it with the custid from contacts and respondent_no from survey answers before the webform input is inserted.I want to send an email to them that had there respondent_no in a hyperlink to the webform so that when they entered their data into the webform it would use the repondent_no to determine where to insert the form data.
Example joe clicks http://www.myplace.com/order.aspx?23
Mike clicks http://www.myplace.com/order.aspx?125
it would look up respondent_no (23) from the respondent_initial table and insert the data in that row in the database for joe's webform entry and it would look up respondent_no (125) from the respondent_initial table and insert the data in that row in the database for mike's webform entry. my code behind looks like this
// Create command
comm = new SqlCommand("INSERT INTO respondent_inital (Practice_Name, Address1, Address2, City, State, Zipcode, Phone, Email, Contact, Dealer, item_9223, item_9129, item_42795, item_30695, item_42834) VALUES (@Practice_Name, @Address1, @Address2, [code]....
I want a piece of code for asp.net 3.5 using visual basic. and i am using MS access database.
I have two three text boxes and 2 image upload controls and a submit button.
I want a piece of code in which a user can upload images and store it in our database . i want an asp.net visual basic working code. also i need query behind the submit button.
I have to display data (names) in a random order on the website. The data is stored in a MS Access database. The names must be displayed in a GridView and DataList in different places. I have created a query in MS Access "zorder: Rnd([MarinaAccommodation]![ID])" which works fine in MS Access giving me a different order each time.
The problem is that when I try run it on the website the order remains the same, it does not change each time the page is loaded.
I have a situation where I am accessing a database multiple times and I'm wondering if it is necessary.
I have a GridView with a template column with a hyperlink to "Get Results" and on the RowDataBound event I have it check the batch number against the database and see if results exist and then if they don't, hide the link.
So when viewing the page if there is 20 rows in the gridview it is effectively doing 20 queries.
I was wondering if it is a better idea to query the database once with all "batches" and load it into a datatable, then on the RowDataBound event query the datatable. The only issue I see with this is there is currently 40,000 batches and grows daily.
I am using ajax html editor to write a text. I can view it without having problem but I am incapeble of storing it in a Ms Access database. which type do I need to use for this? I tried memo and OleObject type and both didn't work. I used the blow code for that.
View 6 Repliesi am using the following code for a retrieving a image stored in access database
View 12 RepliesI have a data type mismatch while inserting into a number field in an access database using a parameterized query.I think this should be pretty simple but I am still learning a lot.
[Code]....
I have some commented out as I am working one field at a time. The working fields are textboxes and the non working ones are dropdown lists. But I think it may be the field that the list is drawing from? Not sure.
I have one question here.I created a registration form using asp.net and c#.
when I entered all the fields in that form and hit the register button the data will be inserted in to the database table called xyz table
in that table I have an id field which is a text field in access database consists of guid starting with letter P
when I inserting the data from aspx form...the guid is not inserting into the table.
one of my datarecord in that table with the id field is like this.(.P11111111-1BBB-4444-A9D1-111111111111)
need to insert anoother record in that table that field must be generate with the ID starting with P..its an guid.. the creating guid in the aspx.cs page..??
I have a form wilh couple of Drop downs and text boxes and a Data Grid View which displays data from Access Table. When I hit add button on the form, I can see the data being added to the Grid View. But when I close the form and open the Access Database File (.mdb), the respective table is empty. The Access Table is not being updated. Second time if I open the form, the Grid View is also empty.I am pasting my code here.
Public Class Home
Shared OleDbConnection As System.Data.OleDb.OleDbConnection
Shared ExpensesDataAdapter As System.Data.OleDb.OleDbDataAdapter [code]....
I want to retrieve a single column from a table in a database(ms access) and then the value retrieved has to be converted to a string!!
View 4 RepliesI am trying to create a DataReader to return a counted value from an Access Database. It all works if it finds some rows, but falls apart when there is no total.
My code is as follows (highlights);
[Code]....
The error that gets thrown is:
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.IndexOutOfRangeException: BoxesOut
Source Error:
Line 43: if(reader2["BoxesOut"] != System.DBNull.Value)
I want to use sum function in access database (not MS SQL) to add array of items in a particular date.For Eg. The Access Database format like
Date
Prod. Name
Value
[code]...