I have a list of points and I want to make a line from them.
I found one example for using STLineFromText but it is for concrete values. For example:
[Code]....
Now how can I iterate through all the points I have and form a line, so I don't want to write exact values like -122.360 47.656 but to take them from the list?
I 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]....
Have a question about the best approach for file storage in a SQL database. I have a table called Widgets, and each row in the Widgets table can have multiple files. I also have another table called Extensions, and again each record in this table can have many files.
Here is what I am considering:
Approach #1:
[Code]....
That approach is very simple and easy to use, but I feel that I could merge the two file tables into one, then use lookup tables:
Approach #2:
[Code]....
The thing is, there are no duplicate or shared files between the two types of objects. So even though I feel better about approach #2, I am concerned that I may be adding additional complexity (and using more server resources to perform the joins), than needed.
i am reading image from database (sql server) by using handler and getting it in memory stream. now i want to store that image on server in the folder named Images.
View 2 Repliesi made an asp page for registration with the following fields name, address etc. i also created database in sql server. how to save these field data in my database.
View 2 RepliesWEB FRAMEWORK: ASP.NET in C#
I've looked all over the web for something that would show me how to do this but can't find it. I have a page that uploads information about an individual including a resume in the form of a doc docx or pdf. I can upload the file okay but I do not know how to, on another page, To download the file that was loaded to that person's row in the database. Here is the upload code
[code]....
I am a new-bie in Asp.Net.I am working in a project where I need to store an attachment which will be uploaded by the user in radGrid into Sql server 2005 database.After storing this attachment, I have to retrieve this attcahment and show the same to the other users in radGrid so that they will be able to download the attachment and see that.How should I do that?what kind of datatype would it be?
View 2 RepliesIn the header text I need to get an output of two lines. The top one in Spanish an the lower one in english. Is there a way to break a line?
[Code]....
I used code to display multiple lines in label and save it into SQL server as Varchar(max). It works fine in label.text but in SQL table, it do not work.
Code:
dim s as string
s &="Good day" & "<br/>"
s &="aspfun"
In label, it displays like below which I want:
Good day
aspfun
but in SQL table, it displays like below which I do not want:
Good day <br/> aspfun
How to code for carriage return/line feed to works in both way?
I used code to display multiple lines in label and save it into SQL server as Varchar(max). It works fine in label.text but in SQL table, it do not work.
View 1 RepliesI have a requirement to allow users in a content management system to create their own image maps through a gui interface, which I have accomplished. But instead of saving the image map to the page code, I want to save the image map code to a database (sql), which I've also accomplished. When I started down this road in my head I was thinking the whole time that I'd just add the "usemap" attribute at runtime shown below where promo1.ImageMap holds the entire map code:
if(promo1.HasImageMap) imgPromotion1.Attributes.Add("usemap", promo1.ImageMap);
I guess I didn't think it though well enough, because it seems that "usemap" only expects the name of the existing map to use from the page code, and not the map code as a string.
how to apply the map from the database to the image at run time?
I'm now working on a application which needs some pdf files (size 200kb -1Mb) to be stored into Mysql database.
View 2 Repliesi am a beginer and i want to know how to store images in the database tables like pictures of the pizzas and when the user selects one of the pizza from the dropdownlist he sees the image of the selected pizza.
View 2 RepliesI get a Exception while Storeing current datetime in sqlserver 2008.
UI-Sliverlight 4.0
BAL-WCf
DAL-ADO.Net Entity FrameWork
Tools-VS 2010
In Sqlserver 2008 DataBase one columns of a table is CreatedDate Having datatype :-datetime When i am passing Created Date as DateTime.Now i.e.( objRFEProxy.mCreateDate = DateTime.Now;) in sliverlight codebehind it through error. InnerException {"The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated."} System.Exception {System.Data.SqlClient.SqlException}
I'm working on a blog and want to show my posts in eastern time zone. i figured that storing everything UTC would be the proper way. This creates a few challenges though:I have to convert all times from UTC to Eastern. This is not a biggie but adds a lot of code.And the "biggie" is that I use a short-date time to reference the posts by passing in a query, ala blogger. The problem is that there is no way to convert the short date time to the proper UTC date because I'm lacking the posted time info.
View 4 RepliesI have a stored procedure which is working fine and also code in my vb class, which when I click on save, looks as though it has executed but no information is saved into the database....
My code used to save the data into the database is below.
[Code]....
Since I'm using Postgresql and can't use LINQ to SQL, I wrote my own wrapper classes.
This is a part of the Student class:
[code]....
It works now! I replaces all Run methods in the Student class with DB.Run
But I want to know if it will work fine with a lot of people online, not me only. I'm not sure how static things work with ASP.NET, maybe it'll eat a lot of memory?..
I'm having a bit of an issue uploading files to a database. I'll post snippets of my code below.
The table i'm uploading to has the following structure:
[Code]....
I can upload the file using my MVC application without any errors, however in the database the file stores in CoverFileContent as "0x0000000000000000......". All the other information relating to the file, e.g. MimeType, FileName, CoverID, etc uploads correctly. I took a wild guess that this wasn't correct so I downloaded the file (created a .net MVC file downloader). It seemed to download as the correct type of file, however I when I tried to open it, it told me I could not open it. I'll post some snippets of my code so people can see what I'm doing.
CoverController
[Code]....
CreateCover.aspx
[Code]....
I have inserted breakpoints to debug the code, however coming from more of a business background I'm not sure what I'm supposed to be looking for. It seems that the array is being populated with 00000000s so I'm thinking this is a problem regarding the intake of the file.
[URL] This is the tutorial I was originally following, which I got to work perfectly. However when I rewrote it to suit my own needs (using ado.net, etc) this problem seemed to occur.
I am building a web site similar to Craigslist. I would like to know how to store the html formatted text (bold / italics / font size etc) in a sql 2008 database?In order words, the user would enter their text, format it with font size, bold etc and save the information. Whats the most efficient way to store that in a database?
View 6 RepliesWhat it best location to store various configuration settings of a web site modules. Creating class (that inherit ConfigurationSection) that map the settings in web.config file?Or creating some DAL and BLL clases that work with database?
View 5 RepliesI have got an ASP.Net website, where the data is brought in from ISeries.The data connection to ISeries is quite slow and the speed is quite important for this website. Because of the slow speed of data retrieval from ISeries, I want to make as less database connections as possible.So, I was thinking about storing tables from the database which rarely changes as static properties in my website. Whenevera user logs in I submit a thread which refreshes the data in the static property. Is this approach correct? If not, what are the problems with this approach and what are the possible alternatives?
Example:-
For list of ports, I submit the below thread when user logs on:-
[Code]....
In class Ports, there are 2 methods -
one for populating the static property PortList, and the other checks if the thread is alive and waits for the thread to complete and retrieve the list of ports, once it is complete. The second method is the one which I use in my application whenever I need the list of ports (populating a dropdown, etc).
[Code]....
Using code found here : [URL] .... I was wondering if the text could be formatted as in maintaining line feeds. I'm reading from an SQL 2008 database which has a text field. When I call it up the text format is gone. as an example I get :
what colour is the sun A:Green B:Red c:Yellow
instead of :
what colour is the sunA:Green B:Red c:Yellow
I am writing an application in which a remote url web site ( says url1 that is sender) sends xml data to another web site (says url2 that is receiver) by using .NET WebRequest. On the receiver url2 if I use .NET Page.Response and .NET Page.Request to store posted/received xml data into an external text file, then the data is stored. However, if I store the received data into database, I do not see the data is stored into the database.
trouble shoot the codes so I can store such remotely posted data into database on the receiver side url2.
I host both url1 site and url2 site in my computer using IIS like [URL]
1/ Receiver page's codes that store remotely posted xml data into database do not work:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader(Page.Request.InputStream);
String xmlData= reader.ReadToEnd();
ProductNameSapce.ProductCollection.InsertReceivedProduct(xmlData).ToString(); // data is not stored ; the method is tested and works well with hard-coded data
reader.Close();
Page.Response.End();
}
2/ The version of the receiver page at url2 that stores into an external text file works:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader ( Page.Request.InputStream );
String xmlData= reader.ReadToEnd ();
StreamWriter s;
s= File.CreateText ( Server.MapPath(".")+@""+ Guid.NewGuid () + ".txt" );
s.WriteLine ( xmlData); // data is stored in an external text file
s.Close ();
reader.Close();
Page.Response.End();
}
I suppose this question has been asked to death all over the web, but I can seem to find a clear cut answer. What I am trying to achieve is as follows: I have a web application that lists various products, their descriptions, names etc and also an image of that specific product. The user will type in a product code or name of the product and a page will pop up with al the previous mentioned info and image or images of that specific product. The problem I am having is: I read somewhere that storing images in a database is 'bad idea' since it effects performance, then I read somewhere else to keep it in the images / or app_data folder. But what would be the best approach and how would I call it from the database (if that's the best way)? And if App_Data / images are the way to go how many images can I put in there (??) already the product catalog has several hundred images of various products. So how would one go about sorting everthing in those folders without having a few hundred images rolling down in my solutions explorer.
View 5 RepliesI have a web application, which I have a SQL express database attached. I tried to upload a Japanese character into a varchar (max) column, and the result when displaying in the web page is '?'.
I tried to fix by the web config and in the page display to display japanese but it doesnt work.