I created a PageLoad event, so when the page opens it fills all the fields from a DataSource control. However, the problem is that if the DataSource control is empty (the row does not exist yet) it gives me an error. How do I check that if DataSource Control has a row of data or not?
View 5 RepliesI am getting this compilation error"
All my pages are receiving this error - website is down; here's the code:
[Code]....
Except my web config file shows linq is accounted for? [Code]....
I would note that I updated to VWD Express 2010 then had to revert back to 3.5 because my host at Arvixe had not updated my server yet. He then said he updated it and I reverted up to 4.0 again. It turned out he hadn't and I tried to revert back...and then this showed up and numerous other errors.
I have one big DataTable with X rows. I want to select Y rows from it and bind them to a new ViewList. While doing it, I want to delete these rows from the DataTable (Having X - Y rows).
What is the best and fast way to do it?
I don't know if it is better to create a new DataTable to have the Y and after that bind them to a ViewList or something else?
I'm also looking for example in code how to select/delete rows from DataTable.
[Code]....
In above query I want to have top 10 rows as well as count of all rows.
i am bulding something for myself in asp.net and SQL but am having a few problems. I will list them below and see what happens :)Please note that i have a lbl control permantly on my pages which is set in the master page, this is what displays my messages.example = message.text = "Please insert your name"1. I have a data table that calls a table with its values. its basicly 4 ddl's(day, month, date & year) select what date then search. Mon Mar 21 2010
SEARCH(btn)
" SqlExeption was unhandled by user code "
this is basicly because the table doesnt exist. How do i tell asp to return a message if the the table doesnt exist in sql server.
[Code]...
View 12 RepliesI have restored a database from the .bak file on live server.But it keeps creating error in log and I checked it through sql server 2005
management tool . I found the folloing error :"the activate proc[dbo].[procname] running on queue databasename.dbo. storedprocedurename output the following 'Cannot execute as the database prinicpal "dbo"
does not exist,this type of principal cannot be impersonated,or you do not have permission".
And the log file size is increasing with a great pace and I need to delete the log files mannualy as it reaches the size of 90gb in few days.
But if I restore the same .bak on my local system then it does not create the same error log.
I am inserting a record and want to set the value for a foreign key but I am getting an error - I initally thought that it would insert it if it didn't exist but I must be wrong and want to confirm that I need to check all values and make a record for them if they don't exist... here's what I am trying to do - does his make sense?
var newAllPart = new Part();
newAllPart.PartNumber = partNumber;
newAllPart.Manufacturer.ManufacturerName = partManufacturer; // error here if the Manufacturer doesn't exists already
newAllPart.PartType.PartTypeName = partType;
newAllPart.Category.CategoryName = partCategory;
newAllPart.DateCreated = DateTime.Now;
newAllPart.UserCreated = userCreated;
newAllPart.Package.PackageName = partPackage;
newAllPart.Statuse.StatusName = partStatus;
localDB.Parts.InsertOnSubmit(newAllPart);
localDB.SubmitChanges();
I am new to LINQ, but learning Quickly. I get this error "Error 1 The name 'DetailsView1' does not exist in the current context C:UsersUserdocumentsvisual studio 2010WebSitesDursoftHRAGeneral.aspx.cs 40 9 C:...DursoftHR" for the code behind listed below:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class AGeneral : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
viewCompanyInfo();
}.......
"The name 'DetailsView1' does not exist in the current context" is the error I get.
I get the above error using this code. What am I missing?
[Code]....
I have a drop down list inside a formview control's edititemtemplate and itemtemplate. The dropdown list is not bound to a data source. I am hard-coding the listitems for the drop down list. The formview is bound to a datasource. All I want to do is set the selectedvalue of the dropdown to what is in the record from the database. But I keep getting the error.
<asp:formview .....>
<edititemtemplate>
.... //some other controls like textboxes that are correctly bound and display the value from the datasource
<asp:dropdownlist ID=myddl runat=server cssclass=myclass selectedvalue='<%# eval("mychoice") %>'>
<asp:listitem value='0'>I dont know</asp:listitem>
<asp:listitem value='1'>Yes</asp:listitem>
<asp:listitem value='2'>No</asp:listitem>
</asp:dropdownlist
.....//rest of the edititem controls that display correctly.
</edititemtemplate>
Just for kicks, I added a textbox and set it's value to eval("mychoice") as well and it correctly prints 0,1 or 2. So, I know that there is no illegal value coming back from the datasource. It seems as something with the timing of events - when the listitems are getting bound to the ddl. The error I get is - "myddl has a selectedvalue which is invalid because it does not exist in the list of items".
I want to update the data using vb.net , my webpage has many dropdownlistlist ,
I got an error when update the dropdown field ,
"Dropdownlist error: SelectedValue which is invalid because it does not exist in the list of items."
On our company we have a intranet site which uses ASP classic to authenticate users before accesing the site. This site was working before but suddenly i throws an error which limits the users in accessing the intranet site. I made a debugger page in order to know the error of the application and it showed me this error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. On my local machine the page is accessible on my (IIS server) the connectionstring in the web server and in my localhost are the same. I just can't figure out what's causing this problem.
View 2 RepliesI just got a new desktop computer with Windows 7 Pro as the operating system. I installed Visual Studio 2008 on to this new computer and tried to open a previously existing ASP.NET 3.5 solution that displayed perfectly fine on my previous computer (this previous computer used the Windows XP operating system, IIS6, and IE7 browser). However, in Windows7/IE8, I'm receiving the following error:
Server Error in '/' Application.
Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: The file '/MasterPages/MainMaster.master' does not exist.
Source Error: Line 1: <%@ Page Language="C#"
AutoEventWireup="true"
CodeFile="default.aspx.cs"[code]....
when I tell you that the file '/MasterPages/MainMaster.master' file does, in fact, exist. In addition, this file's location is properly referenced in the code (as indicated in Line 1 above), and as I said, was displayed properly by the browser in my previous computer. It might also be helpful to note that I've tried to navigate to other pages in this site, and this browser displays the same message for any and all master pages located in my MasterPages folder. In summary, for some reason the browser cannot see any pages in the MasterPages folder. Can anybody tell me why I'm getting this error message when the folder and file is exactly where default.aspx says it is?
Error:
Executed as user: MACSTEELUSA.COMsa. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:17 PM Error: 2010-06-02 20:00:18.56 Code: 0xC0202009 Source: CRM_ORACLE_ARSUMMARY Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client
and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". End Error Error: 2010-06-02 20:00:18.58 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireCon... The package execution fa... The step failed.
Tasks Taken:Went to this folder checked for tnsnames.ora file but it is in good shape.
C:ORACLEproduct11.2.0client_1
etworkadmin
I've got data in a xml document.The xml document is generated by a stored procedure.I like to change the stored procedure so i can skip a lot of rows.The count of rows, i like to add as a Parameter.With a top of 20 i get 20 rows.But after i show the 20 rows there is some kind of paging on de website so the user can put next, and get the next 20 rows.But how can i skip in that case the first 20 rows?, and after that 20 rows, i want the next 20 rows....So i like to add it as a parameter.
But how?With linq its quite easy, but i don't want ms sql resultss the complete rows to the xml file, becasue it would be lots of them (100.000...)
How to display Top 10 Records using DataView Or DataSet, Below is my code. I am using .net 2.0 and i don't want to Modified in my SQL query.
Dim ds As New DataSet
ds = tv.GetSearchLatestEvtHosting("", "", "", "", "")
Dim dtvCust As DataView = New DataView(ds.Tables(0))
iam working with gridview in asp.net3.5,Sqlserver2008 I am retrieving data from a SP into a datatable.i need to store this table into gridview. but am getting the last row from my datatable into my gridview.
here i need to add each row to the datatable.
my grid is like this:
[Code]....
I have a problem where I would like to get a comma-separated list of items from a couple of tables as part of a set of results. All the searching I've done so far has produced results for dealing with one or two tables. I have four, and can't get my head around how to adapt the sql to deal with it.
I have the following layout:
*Table_Castings*
+---- CastingID {PK}
| MouldID
| SerialNo
| CastRef
| MeltCode
| Signature
|
|
| *Table_CastCertificates* *Table_Certificates*
| CertificateID {PK} ----------- CertificateID {PK}
+---- CastingID {PK} Description
FileID -----------------+
|
|
*Table_CertificateFiles* |
FileID {PK} -------------+
FullLocation
The results I would like include the following columns:
CastingID, MouldID, SerialNo, CastRef, MeltCode, [Certificates],
Where Certificates is a comma separated list of Description + " " + FullLocation records. (What I'll actually do is add http:// and other html codes to make FullLocation a hyperlink, but I can do that.)
Some SQL I've already got is this:
DECLARE @str VARCHAR(500)
SELECT @str = COALESCE(@str + ', ','') + '<a href="http://' + Table_CertificateFiles.FullLocation + '">' + Table_Certificates.Description + '</a>'
FROM Table_CastCertificates INNER JOIN
Table_Certificates ON Table_CastCertificates.CertificateID = Table_Certificates.CertificateID INNER JOIN
Table_CertificateFiles ON Table_CastCertificates.FileID = Table_CertificateFiles.FileID
WHERE (CastingID = 45)
SELECT output = @str
This actually gives all records in the for the specific casting, but I keep getting an error at the "=" in @str = COALESCE when I try joining it to another query to get each casting.
[Code]....
View 2 RepliesIam confronted with a really weird issue the like of which ive never seen before. I recently developed a web application using ASP.net and launched it for my company, during the bug testing stages everything seemed fine, but once it was actually in production i started getting these weird errors that all stem from it not retrieving the correct rows.
The issue is this, sometimes the queries sent to the back end only return a partial amount of the rows actualyl requested, so if a user has a page loaded thats suppose to return X number of rows, they can sometimes get X - Y number of rows, and upon refreshing the page they get X - Z number of rows, and refreshing the same exact page again they might get X number of rows they were initially suppose to see. I've never seen anything like this before so Iam stumped.
I consulted some of the old developers in the company I used to work for, for assistance but when explaining and showing the problem they too were very confused with the issue.
My query was SELECT ID FROM TBLCARS WHERE (ID IN (1, 5, 3, 6))
this will usualy produces the result 1,3,5,6 order.But i want the result in the specefied order of ids.ie:1,5,3,6;ie;first get the row with id 1,then with id 5,then id 3,and last 6.
I get the usual system.outofmemoryexception with the code below.
Is there a way to do this in small chunks?
public static void Serialize(DataTable dt, string filename)
{
FileStream fs = new FileStream(filename, FileMode.Create);
BinaryFormatter bf = new BinaryFormatter();
try
{
bf.Serialize(fs, dt);
fs.Close();
}
catch (Exception)
{
fs.Close();
fs.Dispose();
File.Delete(filename);
}
}
im using this query to select Movies from my DB
[Code]....
now thee thing is it returns only the exact value, and im tryying to get to a point where
the user puts only a letter or maybe part of the movie name and get the results by that
and not only if he puts the exact value, if anyone could should me the right sql syntax i'd be happy.
I need to select the rows between 20 to 30 from a table without using where condition. How is it possible?
View 2 Replies