I am trying to create a type of table on sql 2008. The following sql fails saying Incorrect syntax near the keyword 'AS'. what i am doing wrong as this looks fine to me.
View 1 Repliesi am trying to export a table from access database to excel sheet but i am facing error saying Type 'System.Data.OleDb.OleDbCommand' is not defined.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:Documents and SettingsUSERDesktopD0605data.accdb")
AccessConn.Open()
'New sheet in Workbook
Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [Excel 8.0;DATABASE=C:Documents and SettingsUSERDesktopD0605data1.xlsx;HDR=NO;].[Sheet1] from [Table1]", AccessConn)
AccessCommand.ExecuteNonQuery()
AccessConn.Close()
End Sub
End Class
I have a strange problem. I am adding a LinqDatasource object, and set the context:
[Code]....
Then I get this error:The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
On web.config I already have this:
<add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.
is there another way adding a refernce to a web project? or only though teh web.config?
i have created a function to call username to pass user id as pararameter,
how to call userdefined function in asp.net
here is my function in sql
CREATE FUNCTION getusername
( @userid bigint )
RETURNS table
AS
RETURN (
SELECT login_id
FROM mst_useraccount
WHERE user_key =@userid
)
go
am having a class which contains user defined data type property. I have created an instance of that class. When I bind that object of that class to DetailsView it is showing all properties except user defined data type property. Here is the sample code.
public class Customer
public string CustomerName { get; set; }
public int Age { get; set; }
public Address CustomerAddress { get; set; }
}
Address class looks like
public class Address
{
[code]...
I use a sp to insert/update records. Parsing a DataTable (many) to a user-define table typesTable type:
[Code]....
Table to Insert/Update:
[Code]....
Will this work (snipp from sp)
[Code]....
I know that the problem is my field having NULL values. However, I don't know how to have it process the code even if the field have nullshere's my code:
[Code]....
me how can I fix this error message: Type 'dsFaq' is not defined
[Code]....
used wsdl.exe to create a .cs class for my wsdl service connection.I made a Visual Studio project to compile the .cs into a dll having namespace CalculatorService (CalculatorService.dll).I created an asp.net project added my namespace import:%@ Import Namespace="CalculatorService" %I right-clicked on the project, clicked Add Reference, found my .dll, added it, built the project, checked /bin to ensure my dll was there (and it was).All is well LOCALLY while debugging. It found the CalculatorService, connected to it, got the XML and displayed it.
View 2 RepliesWhy I am getting this error 'MVCApplication1.Purchase.ProductInfo' is not defined?
Purchase.ascx
<%@ Control Language="VB" Inherits="System.Web.Mvc.ViewUserControl(Of MVCApplication1.Purchase.ProductInfo)" %>
<%@ Import Namespace="MVCApplication1.Purchase.ProductInfo" %>
<%For Each item in Model.Product%>
[Code]....
I have this error "The given value of type String from the data source cannot be converted to type datetime of the specified target column." when I used sqlbulkcopy to do the transaction
Here is my code:
[code]....
I'm trying to get a value from a database and I'm getting an error, see code below:
[Code]....
I get and error when I'm trying to convert the value out of the stored procedure to the string SNAME. Error is as follows:
'Conversion from type 'DBNull' to type 'String' is not valid.'
and the stored procedure is as follows:
[Code]....
I get the error - Conversion from type 'DBNull' to type 'Integer' is not valid. - on the line.....
Dim newid As Integer = e.Command.Parameters("@latestRowId").Value.........in vb code behind.
I have the identical code for another page with the exception of the field names and it works fine. The only thing I did differently, as far as I know, is I copied the asp and code behind from the page that works into this page and manually changed the field and table names. I don't know what the problem is. Does anyone see any problems?
[Code]....
I am trying to attach static attachment with email but I am getting following error in my code: Type 'MailAttachment' is not defined.
My code is as follows:
asp.net Code:
[code]....
i m getting this error on my certain .aspx pages ,although i added tool kit in my project "Error4Type 'AjaxControlToolkit.ToolkitScriptManager' is not defined.C:UsersIramDocumentsVisual Studio 2008Projectsgfln1gfln1CreateNewConference.aspx.designer.vb3451gfln1
View 3 RepliesI have a simple test page in asp.net 3.5 vb with a button and a label. The code behind is;
[Code]....
I get a compliation error - Type 'MessageQueue' is not defined.I thought it was, since I have imported System.Messaging.
have been trying to get to grips with the entity framework using the music store tutorial as a base reworking it to fit an existing application i havei have a database table called AuthorDetail. I also have AuthorDetail.cs Model, and a View AuthorDetail.cshtml strongly-typed to the Model. It's also declared as DBSet in the Entities class :DbContext under the application Models namespace.
View 4 RepliesI'm getting the following error. Error Message is "BC30002: Type 'MySqlCommand' is not defined.". Here i give my code
<%@ Page Language="vb" debug="true" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Data" %> [code]....
So, I've been programming for a number of years. Finding some intricately asinine issues w/ ASP.NET and VB.NET as I learn them. How about this one:
[Code]....
The issue is not Date1
The issue is Date2.
No kidding. I had to String.Format Date1 for some odd reason, even though I'd already validated it. And, yes, I tried to parse and convert Date1 but I kept gettting the typical "Argument 'Date2' cannot be converted to type 'Date'." error. (Did you catch the copy & paste? I didn't edit it from my existing error, but Date2 should be Date1.) Yeah, that's the error I'm getting now with the above ...
"Argument 'Date2' cannot be converted to type 'Date'."
Date2 is a system defined type. Why can't the system convert and/or simply use it's own pre-defined type?
I try the example on the folow I get error on TYpe DataSet is not defined, I use net 1.1
[Code]....
im doing a registering user by the admin and i trying to use random generated password and send to the user e-mail
This the 1st time i use this MailMesage thing found from the internet
I follow accordingly but found some problem with the method for MailMessage. Below is my code
The problem is the MailAddress it say Type 'MailAddress' is not defined, and
SmtpDeliveryMethod - Name 'SmtpDeliverMethod' is not declared
[Code]....
I'm trying to create a website that allows the user to type something up and it gets stored into a database. I'm looking to give the user some control as to different formatting such as for decorations, weight, style, etc... Also I want to keep the spaceing the user inputs into the text area as well (if the user presses enter to create a blank line). Is there a control out there that would let me do something.
Pretty much what I'm thinking of is something like what you would use to create a thread on a forum (Like what I'm using as I type this), where I get to choose the font style and such.
I have an Interface that has its concrete class defined via a factory. Because of this I found no way to use the Interface tpye directly in my LINQ quesry so I had to use the concrete class types to creat a generic list. The LINQ query works but after calling.ToList() on the LINQ query result I get a List(of MyConcreteClass), but I need a List(of IMyConcreteClass). I have tried everything I can find: .Cast, Ctype, implicit casting, etc. but I always get back one of the (2) messages (depending on if I attempt to cast)message:
"Unable to cast object of type 'System.Collections.Generic.List`1[MyConcreteClass]' to type 'System.Collections.Generic.IEnumerable`1[IMyConcreteClass]'."
...or
"Unable to cast object of type '<CastIterator>d__aa`1[IMyConcreteClass]' to type 'System.Collections.Generic.List`1[MyConcreteClass]'."
Here is the sample code:
[Code]....
I am making a website to store invoices so i can mail them to clients. So i got a table for clients, invoices and one with invoice products/services. When an invoice has no products/services added to them and it returns null i get the error "the null value cannot be assigned to a member with type System.Decimal which is a non-nullable value type."
I just started with linq. Before i always used mysql. Mostly i just had to call data from 1 table so forgive me if my linq query isn't really correct.
Dim invoices = From i In db.invoices _
Group Join p In db.products On i.id Equals p.invoiceId Into invoiceProducts = Group _
Select New With {i.client.naam, i.titel, (From iP In invoiceProducts Select iP.prijs).Sum}
i show the client's name, the title of the invoice and the total amount the clients will need to pay for products and services.
I using Masterpages and user defined controls, on my user defined control I added a CalenderExtender, but I can get it to work, when I set the TargetControlID="txtPSD" the name of my textbox it vanishes from the screen. Question is am I putting it in the wrong place??? see the bold code below, TargetControlID error is name contains uppercase lettter that are not allowed.
[Code]....