i put my asp.net project in one of our PC in my company in LAN.I got access through the URL http://localhost/myprojectname from my PC.But am unable to save data from aspx page of my PC to hosted PC.
View 2 Replies
How To Save Video files into folder and save path only into database in asp.net using c#.
View 1 Repliesi am new with WIZARD. i am using 4 WIZARD steps login,profile,education and business. i have four diff. tables in DB namely tbl_login,tbl_profile,tbl_educatio,tbl_business. How can I insert the data of these 4 steps in DB every time when i click on next in wizard(i have in my mind as somebody told me that when u click on next ur data will be saved in DB, am i right??).so my my problem is that how can i insert the wizard records in DB when i click on next in wizard step??
View 3 RepliesI am trying to develop a web page on which a user can paste data that he cut from excel sheet. Most probably it would be a grid control. But I am not sure how it will take shape. Need something that can do Cut and Paste and later I will have to run tests to make sure that the data looks good, its clean and in correct format, to be uploaded to database.
View 2 RepliesI wanna write values in my datagrid into a database.
[Code]....
This works fine with the first produkt. What my problem is that I want write ALL the produkts in the datagrid not just the first one.
I want to save binary information like images, files ,etc to SQL server database.
View 1 RepliesI have gridView with checkbox on each row, when user click "Submit" then I want a loop go through the gridview, then save those are checked.
ClientID | Client | Emails | chkBox |
[Code]....
On the code behind, how can I identify the data on each row to save to database?
[Code]....
i want to insert data from details view to database.i took a detailsview control and some textboxes, and one button. then how can i save the data to database.my code is below.
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False"
DataKeyNames="ProductID" AllowPaging="False" Width="500"
EnableViewState="False">
[code]...
I am developing a project using Visual Web Developer 2008 express. I am displaying the excel data set into Grid view, each execl sheet having 400 records, i want save this whole grid view data into mysql table with single clickToacheive above task shall i need to create a table in mysql database having same excel names.
View 12 RepliesI have been debating back and forth between using a database or the file server to store images for users. Finally when I decided to use the file server I found it difficult. What I am trying to do is give a user the option to save multiple profile pictures. I have looked all over for tutorials on how to save to the file server but could find nothing related. Essentially what I would like to do is create folders for each user and their images. I am having no luck. Does anyone have example code or links to what I am looking for?
View 3 Repliesactually my need is that, after uploading a doc file I want to save this doc file's text to database table, with the help of asp fileupload control. actually in real I dont want to save this whole file anywhere, but I just need the text to save in databse.
View 2 RepliesIn my application I have a formview, used for inserting/editing records in a product details table.
My problem is now, that one of the fields is used for the filename of a productimage, uploaded to a folder on the server from another page.
When inserting - or editing - a record, it should be possible somehow to get list of the files in the productimages folder, select one, and then store the filename (no path needed) in the database. basically I need some kind of 'file-picker' to select the filename and put it into a textbox. It could be anything from a dropdownlist to something more sofisticated - as long as I can include it in my formview.
how to get the value from textbox that is inside the gridview and save to database.. this is my code:
[Code]....
I want to upload images in to a folder in my project and save the URL in the database.
When you add a record into my database you provide title, date added and some other details and there it a file upload control which you browser to a image and it saves the image to a folder in my project, it all works, the record is added and the image is uploaded into the folder, but the problem I have is that there is no link from the record to the image, there is no URL path saved in the record. How do I save the image in the folder and save the URL of the image to the record?
I'm using details view to insert the records and using grid view to view the records.
one 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">
I have page with a link button.. on click of link button I want to save my quary result into excel file with save as dilog box..(like download dilog box in mozila)
View 4 RepliesI have another problem is that I have Placed a file upload control in Empty template of Gridview to have multiple record insert. I have used viewstate to save multiple record into database. But problem is that I am able to find the control but it not giving any value.I have following code.
[Code]....
in above code
[Code]....
I have a gridview and users would select some records and would click on the submit button and i will be saving those records into database using a stored proc.... now .... just below the gridview and above the submit button there are few checkboxes by default they wud be checked. How would i save the selected values and the checked boxes in database i wrote the stored proc for the gridview but how would i save the checked checkboxes into the same table.
For i As Integer = 0 To gvSelectScreen.Rows.Count - 1
Dim chkTemp As CheckBox = TryCast(gvSelectScreen.Rows(i).FindControl("cbStatus"), CheckBox)
If chkTemp.Checked Then
ContractNumber = gvSelectScreen.Rows(i).Cells(0).Text
ClientProgramNumber = gvSelectScreen.Rows(i).Cells(1).Text
ClientProgramName = gvSelectScreen.Rows(i).Cells(2).Text
StartDate = CType(gvSelectScreen.Rows(i).FindControl("txtStartDate"), TextBox).Text
EndDate = gvSelectScreen.Rows(i).Cells(5).Text
Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnectionString").ConnectionString
Dim myCon As New SqlConnection(connStr)
Dim cmd As New SqlCommand("usp_ParametersFromGrid")
Dim dt As New DataTable
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@ContractNumber", SqlDbType.VarChar, 22).Value = ContractNumber.ToString()
cmd.Parameters.Add("@ClientProgramNumber", SqlDbType.VarChar, 22).Value = ClientProgramNumber.ToString()
cmd.Parameters.Add("@ClientProgramName", SqlDbType.VarChar, 100).Value = ClientProgramName.ToString()
cmd.Parameters.Add("@StartDate", SqlDbType.VarChar, 20).Value = StartDate.ToString()
cmd.Parameters.Add("@EndDate", SqlDbType.VarChar, 20).Value = EndDate.ToString()
cmd.Parameters.Add("@RequestID", SqlDbType.VarChar, 50).Value = RequestID.ToString()
cmd.Connection = myCon
myCon.Open()
cmd.ExecuteNonQuery()
myCon.Close()
End If
Now above the submit button as i said, there are few checkboxes and they are checked by default...how would i save the selected item (in the gridview and the checked checkbox values in the same row in the database(sql server)
i am making use of two listboxes. the data from one listbox is transfered to other listbox on button click, bt teh the data which is selected must be added to the table in the sql server. but it is not storing values it is throwing execption...
private void InsertRecords(StringCollection sc)
{
SqlConnection conn = new SqlConnection("Data Source=ABCD;Integrated Security=True");
StringBuilder sb = new StringBuilder(string.Empty);
[Code].....
I am trying to build a site that will display a word ("Synset" in my code) from a "function call", (ultimately the word will come from another database but I'm ignoring that part for now). The user will click one of 4 radio buttons deciding if the word is "positive", "negative", "neutral", or "can not be determined". Then the user clicks "Save" the word is saved a MS SQL database, the function is called displaying a new word and the process is repeated.
So far I have been able to get this to mostly work by using the code below. The problem is that the function is called and the correct word displayed when the page loads the first time, when I click a radio button and then the "Submit" button, the word and value from the radio button are saved to the database but then no new word is displayed. The text just disappears. The new word is created, as I can see that new words are saved to the database when i click submit.
I'm thinking the issue might be because I'm binding the text attribute of the label I'm using to display the word to the sqldatasource, because it's probably trying to display the text from the database?
I've tried putting the code that gets and displays the new word in FormView1_PageIndexChanging() and submitButton_Click() and neither work.
I've tried to just call Response.Redirect("Default.aspx") in submitButton_Click() and this displays the word but nothing is saved to the database.
[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 am using LINQ to access and manipulate data present in the database,I have a table named SampleTable which has two rows one for Username and other forPassword, i am able to edit, read, delete, select data from this table and show the data onto theDataGridView control.My problem is when i edit the data in the this dataGridView I want the altered data to be saved back into the database, i have googled a lot before posting here.
View 1 Repliesi have a multiline textbox. for example when i write to text box something like this," it is an example for my question " i'am getting the textbox.text and save it to databese, but when i get the same value from databese and show it on page it seems like this, "it is an example for my question", without skipping line, consecutive.
how can i save and get from database as written in textbox?
When user upload new documents then this document goes for approval to supervisor and for this i use dropdowns ...when I use dropdown the exact result not occur and now i wat to approve/reject through checkboxes...
Here is code:
<table class="CSSTableGenerator" border="0" cellpadding="0" cellspacing="0" id="results">
<asp:Repeater ID="Repeater2" OnItemCommand="Repeater2_ItemCommand"
runat="server" onitemdatabound="Repeater2_ItemDataBound">
<HeaderTemplate>
[Code] ....
Now I want to use checkboxes, how I replace dropdown checkboxes in html and also in asp.net ....
Is it Possible to save the data from repeater to the database when we unloading the page(Like clicking other menu or closing the page)
View 1 Replies
