in my db i have:
2011-01-28 12:03:46.223
when displaying on .aspx page,
<%# Eval("ModifiedDateTime") == null ? " " : Eval("ModifiedDateTime")%>
it displays on the grid like this:
12/2/2010 8:43:18 AM
how do I format it like the default format shown when I query my db?
I want to produce a relatively simple webpage which would contain a drop-down list and a button. When the user makes a selection on the drop-down list and clicks the button (or image), the page would query a SQL database and output the results of that query to an iFrame that would be embedded in the lower half of the page. I've managed to figure out the necessary code for populating the drop-down list by using a stored procedure, and I've managed to figure out a way of having the resultset displayed on a second page but I want to now finesse it and get all of the information displayed on a single page.
View 1 RepliesI want to create a page that will dynamically change the images displayed, based on which link the user clicked to get there. For example I have different movies listed and when you click a link for one of them it displays all the images for that movie. I need it to be on one page because at the moment I have hundreds of pages and its very hard to manage. I have the images stored in BLOBS on SQL Server 2005. I can retrieve all the images for a certain category and store the Image data for each one into a list of images. What I cant do, is display the images on the page. I can display one image by using the queryString to get the image by ID, then putting the Eval code into an asp:image, but I dont know how to do it for multiple images.
View 7 RepliesHaving trouble with a web page and connecting to SQL DB. Basically I have a form view table connected up to a SQLDataSourceControl and what I want displayed in the form is only data that has been assigned to the user that is logged on now. I have a "ViewAll" page, which lists EVERY field, regardless of who it is assigned to, but the "MyTasks" page should only retrieve the data of the current user.
I have two tables in my DB, the "Users" table, with user data (including an ID number) - this is used again in the "Tasks" table as a foreign key called "AssignTo". Therefore if user Joe Bloggs with ID number 5 logs on, whenever someone assigns a task to him, they will select number 5 in the "Task" table, as this relates to his User ID.
I am retrieving a word 2010 document that has been uploaded to a sql 2005 database. When I subsequently download and open the document in a word window it states the file is corrupted and gives the user the option of repairing the file for display. This always works fine but the corrupted message is always presented for all DOCX files. The DOC files from an older Word version work fine without incident. the section of code, VB.NET, for streaming the document out to display in Word is:
Dim bytes() AsByte = CType(dt.Rows(0).Item(2), Byte
())
Response.Buffer = True
Response.Charset =
""Response.Cache.SetCacheability(
[Code] ....
Where the content type value, in this case, is "application/vnd.openxmlformats-officedocument.wordprocessingml.document" (rather than "application/vnd.ms-word").
The filename is simply the full name of the document and the data itself is loaded into the Bytes var. I got some time back... it just doesn't like the new and improved word 2010 files.
i am currently facing some problem retrieving image for display on a gridview control. the Image data type in the data table is "image". the data that is stored inside the database is in this format "<Binary data>". may i ask if it is possible tojust retrieve a image data of this format and display in the gridview? or do i need to store the image in a image folder for retrieval?
View 3 Repliesi have a datetime column which has dates with milliseconds, but when i make a query and try to read that column i get the correct datetime but without dhe milliseconds.
I use a conversion like this: DateTime oColumn =DateTime.Parse(oRow["Start"].ToString());
Is there anyway to get the milliseconds from the column.
I'm trying to format the following:
<%# Bind("TimeOfDay","{0:HH:mm:ss}") %>
<%# Eval("TimeOfDay","{0:HH:mm:ss}") %>
<%# Bind("TimeOfDay","{0:HH:mm:ss tt}") %>
[code]...
When I select from SQL Server, I want to get a date, but omit the millisecond value, and I want it to be as a date type. So if I have a value 1/1/2009 1:23:11.923, I want to omit the millisecond but retain the date type, so that it will be the value 1/1/2009 1:23:11.000 (I know you really can't omit the millisecond value with a date, just want it to be zero).
Is there a function in SQL Server to do this? Or do I have to write my own function? Again, I don't want it as a varchar type, but a datetime type.
I'm in the process of developing a survey system. The tables / fields that are related to my question are:
[Code]....
My issues with this way were:
1) The Data Adaptors receive ALL the records from their correspondent tables. Not a good practice, I believe.
2) If, at some point, the survey had no categories, questions or choices under its child records, an error occurs when the page tries to build the Data Relation. With the work flow I had in mind for the system, this is bound to happen becuase all the Data entry pages (Add Category, Add Question, Add Choice) will be displaying the newly-created survey in a similar fashion (at which point, the survey will have no child records and so an error would occur)
I have a webservice (ASP.NET) deployed on a webfarm. A client application consumes it on daily basis. The problem is that some of its calls are duplicated (with difference of milliseconds). For example I have a function Foo(string a,string b). The client app calls this webmethod as Foo('test1','test2') once but my log shows that it is being called twice or sometimes 3 or 4 times randomly. Is this anything wrong with the webfarm or the code? Note that the webmethod has simple straighfarward insert and update statements.
View 1 RepliesI have issues when developing under Visual Studio 2010 and getting the favicon.ico to display. I have used favicons in production sites (sites running on Windows Server 2008, for example) and have no issues. But when I try to get it to display when testing new code under Visual Studio 2010, then I have difficulties getting it to display. Then sometimes it will display just fine with no assistance (see next paragraph). Before anyone says it...Yes, I have a file in the root directory called "favicon.ico". No, it will not display (in certain projects) when the site is run under VS2010...UNLESS I TREAT THE URL IN THE BROWSER THE SAME AS WHEN RUNNING UNDER FIDDLER2. That is to say, it will only work if I add a period character (.) in the url after the "localhost" entry [URL]. This url will cause the favicon to display every time. If I leave out the period (.), then the favion will not display -- and Fiddler2 will also not display the activity when the page is displayed/refreshed. As I said, this is a sporadic issue. I have some projects where the favicon displays fine. Then I have others where it does not...unless I put the period in the url after the locahost word. Can someone explain to me why:
(a) The period is required in the url to get Fiddler2 to "catch" the activity;
(b) Why does this same phenomenon affect the favicon as well; and,
(C) Why do some projects display the favicon fine when run under VS2010 WITHOUT the period being added?
I just do not understand what the period character in the url string is actually causing to happen and why it doesn't happen when it's missing.
How to keep displaying report filters while displaying the report in CrystalReportViewer.I have a web part that which uses CrystalReportViewer to display the report data. I want to keep displaying the Report parameters (filters) as I rendered the report content.
View 1 RepliesASP.Net Page layout is not displaying properly in QA machine but is displaying correctly in Dev Machine. What could be the issue? We are using ASP.Net 2.0
View 1 Repliesiam using an empty div in which i am assigning values through an external javascript via ajax call iam also using an fck editor what i want to do using an internal javascript i want to set the contents of that div in the textarea of fckeditor but in the internal javascript when iam accessing the contents of that div then it is showing "undefined"....
View 1 RepliesIn the following XML structure how do i retrieve the name value and put this into a string? (i am using a XPathNavigator in my method)
<testsystem>
<test>
<name>one</name>
<name>two</name>
<name>three</name>
</test>
</testsystem>
The name will get displayed in the boundcolumn of a datagrid. I was able to get a attribute with a syntax alike this: (but when changing the xml struture it no longer holds a attribute value)
string name = nav.GetAttribute("name", "")
But have no luck getting the value with a nav as of yet. The purpose is to be able to use it for the following object so i can put name into it.
test t = new test() { Name = name, Questions= new List<Questions>() };
On my page, whenever a DetailsView is updated, I must audit the changes into a database. On most pages this works perfect, as there were just textboxes - however on a page I am working on right now, with dropdownlists, my code isn't working.
Basically, what the code does is captures the Updating event of the SqlDataSource, creates a datareader to look at the contents of the row before it's updated, compares the contents to the parameters in the Update query of the SqlDataSource, and if one has changed to log this in a field in the Audit table. An extract of my code is below:
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
try {
if (reader[i].ToString() != [code].....
When the control is on a dropdownlist, it seems to never go 'into' the IF even though the fields are different. Do I need to do something special to compare the values of dropdownlists? Note I believe the value is stored as an int in my table.
I want to retrieve a cell from the selected row in GridView. Please tell me how to do tanks in advance
View 2 Repliesi've two tables trans-mstr having columns as acc_no_from,date,particular,wd_dt,amt,balance and third_party_transfer(table2) having columns as acc_no_frm,acc_no_to,date,amt.now i wnt to retreive date ,particular,wd_dt,acc_no_to,amt,balance where the acc_no_from in third_party_transfer is equal to the no.entered in the textbox of the webpage.i've used datagrid view to show all this.i'm using c# n sql server2005 in this i'm a beginer
View 1 RepliesERROR: Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005
a. I had configured the DCOM on the server
b. If i run the APP on the server with any user: RUN!
c. If i run the APP using the Internet Explorer from any PC everything is fine until i try to call word
e. I have put all template (.dotx) on the server, on the PC and nothing WORD.
I am using office 2003.
the syntax for retrieving a value from a SqlDataSource? I've managed to get it working using numbers to represent the column, but I'd much rather use it's DB name?
[Code]....
//Controller code
CookieContainer cookieContainer = new CookieContainer();
//makes new cookie here
cookieContainer.Add(myCookie);
//Service/Facade code
//myCookie gets passed here
How do I pull the cookie out of the container to make sure it's the right cookie?
Hey there
I have in my database emails table
and i am retrieving all the mails from that table in a string to be included in
message.To.Add()
HOW can i put it in the right format ( separated by Comma and space ) while selecting them from the database?
thank you
I have the following select statement :
string Statement = "SELECT * FROM Car WHERE brand = Bmw;
how is it possble to display the result from the statement, because when i display the result exp: LblInfo.Text = Statement;
The result is : SELECT * FROM Car WHERE Brand = Bmw
I have a stored procedure with two input parameters which calculates the distance between two points. When I call it from aspx.cs I get an error.
Here is the code:
CreateDataSet();
float raz;
String str = "";
float min = 3.4F;
String clo = "";
[Code]....
and the error I get is:
Exception Details: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Source Error:
[Code]....
When I test the procedure in SQL Server Management Studio everything is OK and I get a value 539.551855770807 for the certain input parameters.