tbl_Payment tbl_Payments = new tbl_Payment()
UserId = UserID,
PaymentType = DropDownList4.Text,
AmountDeposit =AmountDeposit.Text, ERROR!
Date = DateTime.Now,
If the write value: AmountDeposit =
I have a column in the table AmountDeposit (numeric).On what it takes to set the column AmountDeposit
i want to to sotre large amount of character in one field of a table i use text-nvarchar(max) and but it show me this exception
(String or binary data would be truncated The statement has been terminated.) I know that text and nvarchar can store 8000 character
I need to store a large amount of data in user's session but I guess using Session Object is not the best way of doing that. Is there any other way around??? Remember I don't have small variables to store, I have large collections.
View 5 Repliesfor ex. my amount is $ 1,234,343.00
and i want to insert the numbers ONLY in my database (1234343) how to that in c# .net???
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 have a problem. I have a textbox where i enter the amount and in another textbox the amount in words comes automatically. The function appended below works fine when the amount entered is without a decimal. But if the amount entered has a decimal, then the function gives an error. Can anyone check the same and tel me a solution.Wat i want is suppose the amount entered in 2345.68 the amount in words should come, Rupees two thousand three hundred forty fve and sixty eight paisa only. if the decimal is not entered then the function gives proper result.
[Code]....
Web 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 RepliesBelow is the code I use to store file into database but there are a few problems.
1. couldn't store file larger than 4mb
2. couldn't store doc,docx,xlsx but only .txt
my table column are:
[code]....
how can i store youtube or any other video URL or link in database and retrive from database
and what control i use in this in C sharp
If I select the today date
Then I want store 4days later date in the database
I'm developing an ASP.NET application with Visual Studio 2008 SP1 and C#. I'm also using Sql Server 2008 SP1.I'm trying to add the tables created with the command aspnet_regsql -S (local) -E -A m to my own database.
If I run that command it will create a database (Aspnetdb database) with four tables. I want to know if there is a command that creates those tables in my own database (called myDatabase, for example).And, when the tables are created. How can I connect authentication to myDatabase?
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
Does someone have the code to write/store data from asp.net c# to a sql database?
View 5 RepliesI want to store a doc file [say its a resume.docx file] into a database like sql server 2005 and i want the
file to be displayed into my aspx page if the file has been updated to the database And also is there some means by which by pressing some link he can get a edit window so that he/she can edit his/her document file.
I know that most people store the Database connection string inside the web.config file.
But my question is if we move the web.config file from dev to prod then we have to change the connection everytime.
how can we have a connection string that we do not have to change when we move our code from dev to prod.
DateTime dt = DateTime.Now; tbl_Payment tbl_Payments = new tbl_Payment() { UserId = UserID, PaymentType = DropDownList4.Text, AmountDeposit =10, Date = String.Format("{0:d/M/yyyy HH:mm}", dt); Compilation Error Compilation Error Description: An error occurred during the compilation of a resource required to service this request. review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0029: Cannot implicitly convert type 'string' to 'System.DateTime?' Source Error: Line 683: PaymentType = DropDownList4.Text, Line 684: AmountDeposit =10, Line 685: Date = String.Format("{0:d/M/yyyy HH:mm}", dt), Line 686: Line 687: }; Using LINQ for data storage. In Table I column "Date" datetime. How to save a date in the table?
View 3 RepliesI want to store image in sql server 2008(what is datatype for image??) where image uploaded by the user using asp fileupload text box and buttom control..and then i want to retrieve that image to show as profile information for users.
View 5 RepliesWhats the best way to store data from database, if you are planning to retieve all needed that once from d database only once, when the page is loaded for the first time. is arrays appropriate or is the better storage methods. dude to lack of speed. we have decided to only get all data from the database once and store them on arrays then only interate with the database when inserting, deleteing and updating. I'm using visual studio 2008 , coding on c# and using asp.net mysql connector. what other storage methods
View 5 RepliesI have the variable value 10.5710.57 If I write, it stores data: 1057.00 10.57 into database
View 12 RepliesI m reading a text file. After reading all the lines, I want to insert those records into respective fields in database.
So how to store the 1 or 2 or 3 or 4 or 5 lines of records until I read the last record.?
[code]....
first 9 number is emp id, next is name and next is salary.
While I m reading, I can store only last record. How to store all the records in a array to store in the database after reading all the lines.
I have a web application which displays set of components in the form of grid view and gives the user ability to buy and download components from the web store. I'm considering using db4o for this ? What is your suggestion ? How is the support for db4o in visual studio 2008 ?
Can i have some tutorials/links on aligning datasource/databinding of gridview with db4o ?? How to start with db4o, create a table, using stored procedures / or similar concepts of it , connecting to database ? retrieving the data ?
Is it possible to store an Image file (.jpg, .gif, etc) in MYSQL database? Or do it just stores in system and takes reference path of image? I am using ASP.NET C#, so if you have sample code
View 5 RepliesI'm creating a website with ASP.net and I have a sign up page. The user has to enter a name and password in textboxex, and choose a location and reason for joining from dropdown lists. (There is a built in wizard for new user sign-up but I chose not to use it).I would like to save the information entered in a table in a database in the App_Data folder. How do I do this?
View 3 RepliesI have a text value of javascript and I want to store this value in a mysql database.
View 1 Replies