I'm kind of new to asp.net and am bad at translating stack traces. While workign on the above function in my web services I've seem to have run into a problem. I can connect to services which return static values. But when I try to connect to a service method that accesses the database I get the following error message:
View 1 RepliesI have a method in wcf which returns stream of custom object. I need to deserialize this stream at client side, but my custom class which is exposed as data contract is not visible through client proxy. When I add a dummy operation contract which returns the custome object I am able to get this custom class. I dont want to write this dummy method as there are many such custom classes.
Is there any way to expose data contract without writing any operation contract that returns or accepts data contract type object?
Can some explain me the difference between Message Contract and DataContract .i'm new to wcf.. so please give the brief explanation or provide me some code snippets
View 3 RepliesIn the [Service Contract(Namespace=URL] what is the Namespace for? I have done WCF services and never included this. What is it's purpose?
View 2 RepliesI have just created my first WCF service and by default it has a datacontract named "Composite type" in it. I tried adding another one but i can't see it in the client application. I have already done update web reference on my client.
Code of the data contract is below.
<ServiceContract()> _
Public Interface IDocumentService
<OperationContract()> _
<FaultContract(GetType(FaultException))> _
[Code]....
why the class named "MyFaultException" is not available on my client code.Imports System.Runtime.Serialization
<ServiceContract()> _
Public Interface IDocumentService
<OperationContract()> _
[code]...
[Code]....
How find the DataType MisMatch Row In DataTable.
I added a service reference via the add service reference method. I can see all of its services in the intellisense but when I run the project and it executes the line where I instantiate the service : MyProjectName.ServiceReferenceName.IServiceReferenceClient
client = new MyProjectName.ServiceReferenceName.ServiceReferenceClient;it throws this error:Could not find default endpoint element that references contract 'ServiceReferenceName.IServiceReferenceClient' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.
I have a lot confusion on data contract .I think Data contract will create according to the Service contract and Data Base Table. For Example Let say i have service contract and i have three table product,order,customer
[ServiceContract]
public interface IMembersService
{
[OperationContract]
void insertProductDetails(clsProduct objProduct);
//What about the return type can we make it bool
[OperationContract]
List<clsProduct> getproductInfoByID(int id);
[OperationContract]
List<clsProduct> getproductInfo();
//========================================
[OperationContract]
void insertOrderDetails(clsOrder objOrder);
//What about the return type can we make it bool
[OperationContract]
List<clsOrder> getOrderInfoByID(int id);
[OperationContract]
List<clsOrder> getOrderInfo();
//========================================
[OperationContract]
void insertCustomerDetails(clsOrder objOrder);
//What about the return type can we make it bool
[OperationContract]
List<clsOrder> getCustomerInfoByID(int id);
[OperationContract]
List<clsOrder> getCustomerInfo();
}
For this case can i create three datacontact clsProduct,clsOrder,clsCustomer .i mean data contact depends on ther service contact and the table.
What is the best way to create a Contract that will consume multiple database records? The database records will have 20 fields and maximun of 1000 rows.
View 1 RepliesI am using C# windows based GUI and MS-Access as my database. Unfortunately, I cannot insert a record with a numeric value, this means that one of my field is a number data type. Below is my code;
Code:
strItemCode = lvProducts.Items[i].SubItems[0].Text.Trim();
iQty = int.Parse(lvProducts.Items[i].SubItems[2].Text);
cmAdjustedItems.CommandText = "INSERT INTO tblAdjustedItems VALUES(@itemcode, @adjustmentid, @qty)";
cmAdjustedItems.Parameters.AddWithValue("@itemcode", strItemCode);
cmAdjustedItems.Parameters.AddWithValue("@adjustmentid", strAdjustmentID);
cmAdjustedItems.Parameters.AddWithValue("@qty", iQty);
cmAdjustedItems.ExecuteNonQuery();
All the variables in my code were properly declared.
I'm using Linq to Sql to call some stored procedures for more complex work; is there any way Linq to Sql can tell me when the output columns from the stored procedure do not match the properties of my entity object? It seems that Linq to Sql tries its best to match the columns and ignores any mismatches.
View 8 RepliesI'm currently developing a website that shows multiple charts that I build using data from SQL tables. I've used and followed Scott Mitchell's tutorial [URL] and K. Scott Allen's ChartBuilder class [URL] and all works well.
However when have two series that I want to show on the same Chart, if one set of data does not have all of the X values the other series does, the chart blindly puts all the data on, ignoring trying to match the X values of the other series, therefore mismatching the X values when the chart is shown.
I know that I can fiddle the data so that both sets of data have the same X values, however I'm trying to make the class handle anomalies in the data so that I don't have to worry too much about the data.
Whats The wrong With This Code
Data type mismatch in criteria expression
Public Class Class1
Dim str As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsMasterMindsMy DocumentsVisual Studio 2008ProjectsWebApplication1WebApplication1indb1.mdb"
Dim con As New OleDb.OleDbConnection(str)
Public Sub insert(ByVal Nationalty As String, ByVal NationalID As Single, ByVal StNameA As String, ByVal Gender As String, ByVal BirthDate As Date, ByVal Address As String, ByVal TawjehiAvg As Integer, ByVal alfera As String, ByVal Phone As Integer, ByVal
Specialization As String, ByVal Period As String)
If con.State = ConnectionState.Closed Then
con.Open()
End If
Dim adp As New OleDb.OleDbCommand("insert into stinfo values (" & getmaxid() & ",'" & Nationalty & "'," & NationalID & ",'" & StNameA & "','" & Gender & "','" & BirthDate & "','" & Address & "'," & TawjehiAvg & ",'" & alfera & "'," & Phone & ",'" &
Specialization & "','" & Period & "')", con)
adp.ExecuteNonQuery()
con.Close()
End Sub
Public Function getmaxid() As Integer
Dim z As Integer = 1
If con.State = ConnectionState.Closed Then
con.Open()
End If
Dim adp As New OleDb.OleDbCommand("select max(Stnum) from stinfo", con)
Try
z = adp.ExecuteScalar
Return z + 1
Catch ex As Exception
Return z
End Try
End Function
Dim x As New Class1
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
x.insert(DropDownList5.Text, TextBox1.Text, TextBox2.Text, DropDownList1.Text, TextBox5.Text, TextBox6.Text, TextBox7.Text, TextBox8.Text, TextBox9.Text, DropDownList3.Text, DropDownList4.Text)
End Sub
I am importing data from an Excel worksheet. The columns are labelled aa, ab, ac .... in row1 and the rows are labelled with integers in col aa. Although I can import the entire worksheet (so long as it isn't too big), when I add a WHERE clause to import only a single row I get a type mismatch which I have not been able to isolate. How can I make progress.
Protected Function SetsConnection(ByVal n_cust As Integer) As OleDbCommand
'
' Create the connection string for the EXCEL file containing the filename and Provider settings.
'
Dim rope As String
[Code]....
I'm trying to make a search that would list results in an access database which is newer than the date given in the textbox. When i run my sql query and it tries to fill the dataset, i get that data type mismatch error. This is the exact error:
Data type mismatch in criteria expression.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.
Source Error:
Line 176: OleDbConnection MyConn = new OleDbConnection(ConfigurationSettings.AppSettings["strConn"]);//Luodaan yhteys
Line 177: objCommand = new OleDbDataAdapter(strSQL, MyConn);
Line 178: objCommand.Fill(DataSet1, "Testi"); //Täytetään dataset (fill on DataAdapterin komento), "Testi" on datatablen nimi
Line 179: DataSet1.Tables["Testi"].Columns[0].ReadOnly = true; //Asetetaan ID sarake vain-luku muotoon, ettei avainta pääse muuttamaan
Line 180: DataGrid1.DataSource=DataSet1.Tables["Testi"].DefaultView; //Asetetaan DataSourceksi Datasetin datatable "Testi" johon tiedot on haettu
Source File: c:inetpubwwwrootphoenixsearch.aspx.cs Line: 178
In the access database the date field is of datetime type. The dates are in european DD.MM.YYYY format which i transform using datetime variable and convert function. The sql query runs fine in access database but when i run it thru my oledb connection in my asp.net page it gives me errors. How should i modify my query, or make adjustments to my code, to not get this error? Do i need to send the datetime as a parameter? And how do i do that? Here is the code for the search event:
[Code]....
I would like to convert WSDL file to Service Contract Interface (WCF).
View 1 RepliesASP.NET 3.5I'm very confused. After inserting a record into a formview, I want to go back to readonly mode. However I need to enable a button in the ItemTemplate as well.I put my code in the ItemCreated event (tried ModeChanged event as well) as below:
If formview.currentmode = FormViewMode.ReadOnly and inprocess then
ormView.Row.FindControl("NextImageButton").Visible = True
end if
Although currentmode is ReadOnly, FormView.Row still seems to contain the EditItemTemplate (combined template for inserts and edits) controls, not the Itemtemplate controls. This seems totally wrong to me - can someone confirm?
[Code]....
<%@ Page Language="VB" AutoEventWireup="true" Debug="true" %>
i am trying to call a webmethod from a webservice within a webpart-project and just cant instanciate the class within my webservice. CongressDataExternalSoapClient wsSAP = new CongressDataExternalSoapClient(); at this line i get the following error message: Could not find default endpoint element that references contract 'com.miltenyibiotec.webservice.congress.CongressDataExternalSoap' in the ServiceModel client configuration section. This might be because no configuration file was found for your application...
attention should be paid to "SoapClient" at the end of my Class-Name: "CongressDataExternal". VS cannot find the Web-Class CongressDataExternal. in other ASP.NET-Projects, its possible... but not here!!! so the only class i can see is the CongressDataExternalSoapClient. i can also see the interfaces CongressDataExternalSoap and CongressDataExternalSoapChannel. i have already added the needed entries to the webconfig:
<applicationSettings>
<Miltenyi.Complaints.Sharepoint.Properties.Settings>
<setting name="Miltenyi_Complaints_SharePoint_com_miltenyibiotec_webservice_congress_CongressDataExternal" serializeAs="String">
<value>http://webservice.miltenyibiotec.com/CongressDataExternal.asmx</value>
</setting>
</Miltenyi.Complaints.Sharepoint.Properties.Settings>
</applicationSettings>
...
<configSections>
<sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<section name="Miltenyi.Complaints.Sharepoint.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</sectionGroup>
...
</configSections>
Miltenyi.Complaints.Sharepoint is the namespace of my sharepoint webpart project. and this entry is in my settings: Name: Miltenyi_Complaints_SharePoint_com_miltenyibiotec_webservice_congress_CongressDataExternal
Type: Webservice URL Scope: App Value: URL to my webservice... what am i doing wrong here?
How I provide Security In wcf . I have Cleared All the binding,Endpoint,Contract Concepts.
View 4 RepliesI am getting a "Data type mismatch in criteria expression" error when trying the following SELECT statement. strdt and spdate are Date types in my vb codebehind and the Contract field name is a DateTime field.
Dim
nmxSQL As
String =
"SELECT * FROM Nymex WHERE (NymexID='" & nymID &
"' And Contract>='" & strdt &
"' And Contract<='" & spdate &
"')"
I have used the repeater function in an aspx page to create a discussion/fourm style page where user can posts comments, but when I try and write a comment I get this error; Data type mismatch in criteria expression. The user gets to the discussion page from a link in a gridview so that it displays all the posts on the specific film, and the correct posts come up, its just when a user wants to post something themsevles I get the error.This is the code in the discussion.aspx.vb page
Protected
Sub Page_Load(ByVal sender
As
[code]...
In ultrawebgrid when column data is large then it(data) comes to nearest coumn data then the mismatch. i have set all the property like width,AllowColSizingDefault="Free",SelectTypeRowDefault="Extended"
Ultra web grid code:
<igtbl:UltraWebGrid ID="UwgUsageDetails" runat="server" Height="287px" Width="100%">
<Bands>
<igtbl:UltraGridBand>
<Columns>
[Code]....
I am getting this' Data type mismatch error' when i click on a submit button after tag selection. It was working before but now it is not working. It say there is an error on line 105.[Code]....
View 3 Replies