I want to open a pop up input form on an onClick event of a button, and then store these values in the database.If some one have a useful links or code share it with me...
View 2 RepliesWeb service error response (code/message etc) would you store it in a database? or would you keep the error response in a method.By the time I'm done with this, there will be hundreds of error response, maybe in the future, thousands? (I dont know yet, depends how large this web service grows).EDIT: error response is the response returned back to the application via the web service, (not to be confused with error logging).
View 1 RepliesI have the variable value 10.5710.57 If I write, it stores data: 1057.00 10.57 into database
View 12 RepliesI have my form set in french as well, and it automatically changes the text format to use ','. However When I try to insert my values into the database it says cannot convert nvarchar to decimal? Worst case, Is there a way I can disable the numbers from changing to use ',' and just use '.' always regardless what language it is?
View 1 RepliesI want store the selected values of checkbox list in database, the checkbocx list is biding to datasource (means i don't know how values there are exactly) ... How can I store the values in one column or different columns knowing that I don't know how values there are ??
View 1 Replieshow to store the 'multiple check box ' record in a database in a single column .. example like "hobbies" for this we have to select multiple check boxes
View 1 RepliesPlease try to guide me how to achieve this one. my application need to do reading the PDF document and want to store the values in Database.Actually what happens is my customers sends me the OCR scanned copied in the form of PDF file. i need to read those scanned pdf files and store the customer information into my table.
View 1 RepliesI want to store Values in two table in database..
For Ex.
table 1-- Resi
if Resi is clicked then the values are stored in resi_db and then it will also get store in the HEG01_db table in database..
table 2-- NonResi
if NonResi is clicked then the values are stored in NonResi_db and then it will also get store in the HEG01_db table in database..
How to store aspx code or c# code or any server control code in database?is this possible or not?i am trying to give Aspx code in textbox and click save button comes an error...
View 6 RepliesMy problem is regarding title written above. Currently I have some functions that rely on Sessions to do the job. Everything works smoothly when it is left to default. However, I do not like the idea of losing sessions in case of crash and I have modified my web.config to use Sql Server mode instead.
I have run the necessary commands to create tables and stored procedures in my database using aspnet_sql.exe. I am able to store values into the database but have not been successful retrieving them. Since it has been working fine with InProc mode, I think I can safely assume that there's nothing wrong with my codes. Here's my web.config setting:
<sessionState mode="SQLServer" allowCustomSqlDatabase="true" cookieless="false" timeout="120" sqlCommandTimeout="30" compressionEnabled="true"
sqlConnectionString="Data Source=.SQLExpress;Initial Catalog=mytest;Persist Security Info=True;User ID=mytest;Password=mytest;"/>
I have taken 3 drop down controls and extends cascadingdropdown control to them. They work finely and show values properly. But, I want to store these valuse in sql database. I tried as we do for dropdownlist by using DropdownList1.selectedItem.ToString().
but it is showing error. It is accepting all other input values passed through text boxes, radio buttons and even combo box of ajax. So actually what should I write to take values from cascadingdropdownlist?
I am new to asp # development, well I have developed four .aspx pages using c#. These pages takes input values from TextBox. when I go to the next page and come back the values are getting null on the textbox. I would like to store them in the variable and when I get back to the page, Onload I would like to display the previously entered value. How do I do that, please help with a code example.Finally on the last page of submitt button I want to insert the stored variable value to the database.
View 3 Replieshow to store the values(code,name) from sql database in ajax combo box 4.0 framework...
View 3 RepliesI want to store the following code into the database:
[Code]....
and then get it back in the dataset and display on a page.
As of now I have successfully stored the questions with varchar(MAX) datatype but when I try to get it in the dataset i get the following error:
Failed To Enable Constraints. One Or More Rows Contain Values Violating Non-null, Unique, Or Foreign-key Constraints.
I am doing this in a ASP.NET web application.
EDIT:
Here is the Table definition of the table I am inserting the data into
The query I am using to insert the data into the table:
[Code]....
And finally the code by which I am extracting the data from the dataset
[Code]....
Using SQL and C#. I have a gridview with a template field. I need to modify the some items in the gridview when the user selects a given record and store the values back in the database. ProjectID is the unique key in the database.Gridview is done as a table. How can I do it? Here is my grid view implementation.
[Code]....
i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
I have creted a form for a job submision it has a number of text boxes / date pickers / text edittor and async file uploader, onload it creates a random string and stores it in a text box (this becomes the job id) this id is also used to create a folder (of the same name) to store any file uploaded, I have tried to store the file location so I can add it to the database but the textbox/lbl remain empty.Secondly I would like to submit this form to a database I am using asp.net 3.5 with rules / membership / state on sql I would like to be able to post the user role / name as part of the data store if this is possible.I have attached my code the asyncfileUploader was converted from C# Demo and modified using suggestions found via google.
aspx file:
[Code]....
aspx.vb file:
[Code]....
the code seems to function fine apart from not returning the uploaded file location (so it can be downloaded via a link later)
Using sql server and trying to insert decimal values using a ASP.NET C# code. I get the value for hours from a text box through user input and I'm trying to insert it to the database.
strSQLWAUpdate = " UPDATE Project SET WAHours='" + txtWAHours.Text + "' WHERE WAProjectID='" + hidWAProjectID.Value + "' ";
What happens is it rounds off the hours to interger value. So if I insert 22.3 in the text box what i get in the database is 22 and if I insert 22.7 I get 23 in the database. I do not need any rounding but need to get the values as it is. ( that is 22.3 and 22.7 respectively)
I would like to store some business flags (like: isFavorite, isOnLive etc.) per an html table row that won't be visible to user.
In practice, I have a simple ADO.Net DataTable on my code-behind which is used as a data-source for a asp.Net GridView control.
This table contains some business flags on its 0th, 1st, 2nd columns.
I need to store those columns on the rendered HTML of the grid-view -so that I can reach them via JavaScript- but I do not want them to be visible.
I have a modal popup extender and I try to setup the image url, title and text in code behind but all I get is the popup, with no text, title or image and can't see why. All I see is the OOK button near the top of the dialog box. This is what I have:
[Code]....
This is where I try to set the values:
[Code]....
This code works fine if i use this inside ssercontrol > panel and i have a checkboxes in table when no checkbox is checked its works fine .... but if i disabled and checked any of the textbox then this doesn't work .... in usercontrol why ? i didnt understand ..
<script type="text/javascript" language="javascript">
function checkboxChecked(){
var allInputs = document.getElementsByTagName("input");
for(var i=0; i<allInputs.length; i++) {
var chk = allInputs[i];
if(chk.type == "checkbox" && !chk.disabled && chk.checked) {
return true;
}
}
alert("OOps! You haven't selected all available checkboxes");
return false;
}
</script>
Its related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
View 9 RepliesIs it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
View 1 RepliesI 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 want to bring values from Database and show in Calendar. Similar to Event Calendar.
It's like Just a normal Ajax calendar but with custom data from Database on each date .