I am trying to test a SPROC from my ASP.net page by passing a date from my page or from visual studio server manager.
The date value is like so 2009-01-01.
I keep getting an error message this input parameter cannot be converted.
I tried all combinations like '2009-01-01', "2009-09-01" , 20091001.
Nothing seems to work.
But the SPROC works on the SQL side just fine.
I have 3 tables as follows:
1 - Members containing the following fields:
MemberID int
MemberName
2 - Companies containing the following:
CompanyID int
CompanyName
CompanyType (S=Supplier, R=Retailer, C=Competitor)
3 - Member_Company_Link containing the following:
MemberID int
CompanyID int
The Company table contains any Company with a potential relationship to a "Member". For example:
Companyabc = C (Competitor)
Companyxyz = S (Supplier)
When a new Member record is entered, the user selects from two dropdowns: CompanyType (Supplier, Retailer,Competitor); and CompanyName. The CompanyName dropdown is populated depending on the value selected for CompanyType so if the user selects "Supplier" for CompanyType then only those Companies with a CompanyType of "S" for Supplier will be listed in the CompanyName dropdown.
The use can enter up to 10 CompanyType/CompanyName combinations. When the record is saved, these CompanyType/CompanyName combinations are saved in the Member_Company_Link table. One record for each CompanyType/CompanyName combination is entered in the table.
The problem I'm having is in the retrieval process. I have a "search" screen in which users can select certain criteria to list Members by and one of them is CompanyName. For example they want to see all Member records with "company xyz" as a Supplier and/or "companyabc" as a Competitor. Because each Member can have multiple Supplier and/or Comptitor records I can't figure out how to loop through them to match on the value entered by the user. If Member1 has 5 corresponding records in theMember_Company_Link file and 4 of them contain Companies that are Competitors (Competitor1, Competitor2, Competitor3 and Competitor4) and the search criteria is to find records containing "Competitor3" how can I loop through the values in the Member_Company_Link file for each MemberID to see if there is a match for "Competitor3"?
I know this post is too long and most of you will have ignored it by now but I'm hoping someone will have a clue because I've already spent more than a day trying to figure it out. It seems I have to store multiple values in an array but I have no clue how to do this.
I have a problem with the text when I save them to sql server 2005.
At first, I post some news to web page. The text showed normal on home page, but after one day when I visit that web page again, I saws all text in the article part was converted to question mark. Ex: "Khó đánh giá theo thị trường" (vietnamese)-->"Khó d?nh giá theo th? tr?ng"
In the other part or the page, the text is still normal. I don't know why.
in asp.net how to fill a dropdown using stored procedure,the sp has one input parameter.
View 4 RepliesI 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 have taken a DataTable control and have added colums to it. Now i want to add rows to that DataTable but when i am trying to create a DataRow of DataTable, an error is generated, showing "Value of type 'System.Data.DataRow' cannot be converted to 'dataRow'".
exact coding that i have written is as follows:
[Code]....
So, where i am getting wrong?
The sites that I've got are still in classic ASP. I know this is a good reason to move to .net but I don't want to have to redo all the sites yet.
So here is the problem:
[Code]....
When I have "On Error Resume Next" no erros get posted and everything runs just fine, the pulls from the database work perfectly. But as soon as we take On error resume next we start getting the following erros:
err#424err desc:Object requiredsql:SELECT Name,URL,Title FROM tblMenu WHERE Parent_ID=1 AND Deleted=0 ORDER BY SortOrderScript Name: /index2.asp
I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:
<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%$ ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%$ ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
I need to pass the control parameter to Sql Datasource in code behind,
<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"
I got this actionresult which I want to call with ajax:
[Code]....
and the call I do is:
[Code]....
but the input parameter id in the action is always emty. How come? I get into the action without a problem but the input parameter is emtpy. Please explain to me why and what a workaround is with $.get.
im passing one input parameter to the SP, based on that parameter i have written the code like below create procedure SP1(@inpName varchar(10))
declare @where varchar(20);
if @inpName = 'ABCD'
@where = 'A';
else if @inpName = '1234'
@where = '1';
else if @inpName = 'AB12'
@where = 'A,B';
SELECT * FROM TABLE1 WHERE COLUMN1 IN(@where);
Now the above query was fine if its 'ABCD' or '1234', but if its 'AB12' then query failed.
How to resolve this issue.?
How do I pass an email address with a plus sign in my input parameter?
Username Value is "johnsmith+1@gmail.com"
http://domain.com/page1.aspx?username=johnsmith+1@gmail.com
for some reason i get an error saying the following. i have tried to look it up on google but there seems to be nothing about this error.
View 2 RepliesIf I have a 3 layer web forms application that takes user input, I know I can validate that input using validation controls in the presentation layer. Should I also validate in the business and data layers as well to protect against SQL injection and also issues? What validations should go in each layer?
Another example would be passing a ID to return a record. Should the data layer ensure that the id is valid or should that happen in BLL / UI?
I have a webservice method which needs to accept SOAP as input parameter. I've worked webservices between .NET clients but I've never worked using raw SOAP so I don't know what to do. The format of the input like this:
<?xml version="1.0" encoding="utf-8"?>
<S:Envelope xmlns:S = "[URL]/">
<S:Body>
<ns2:RemoteService xmlns:ns2 = "some.ns.url">
<RemoteServiceInput>
<param1>123</param1>
<param2>Asd Qwe</param2>
<param3 xsi:nil = "true" xmlns:xsi = "[URL]"/>
</RemoteServiceInput>
</ns2:RemoteService >
</S:Body>
</S:Envelope>
How should my method input be to accept this SOAP as parameter?
I try to implement a very simple search but my LINQ and MVC passing of parameter skills are not existing yet.
In SQL I want to do SELECT ItemName, ItemDescription FROM ahn_search WHERE ItemDeschription LIKE '%'+@input+'%'.
Could someone please help me to get any closer ?
[Code]....
i like to pass two i/p parameters to the SP and fetch 2 output parameters.This should done using simple ADO .NET code.
View 1 RepliesI need to have search form in my web app . I want visitor input text in textbox control and when he click on Search button it check DB table for his input text.
I dould like if user input "Windows 7" and I have the sentence in DB Records as "My be Some Windows Generation .." it list this record.
in other word I want to search for any word that users entered in DB.
Could any one tell me efficient way instead of split input text to words and then execute search query per word?
Having a bit of trouble with a logon page I created using text boxes for a User ID number and a password.
Basically, my original design was to have a textbox for a username and one for a password. Due to some complications, I changed the username to the User ID number input and as such, the input credentials went from being a string to an integer. I've changed this successfully, however when I now type in a string, rather than the integer it requires, the page fails.
how to edit this so if a user enters a string value instead of a numeric value, an error message can show up on a label instead of the whole project coming to a halt because of an error?
Here's the code I have for the page so far, which does the job (apart from this problem!)
using System;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
[Code]....
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 have the textbox input the double number like 0.5 or 2.1 then click the submit insert to database, but show the error. Server Error in '/' Application. Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: Input string was not in a correct format.
Source Error:
[Code]....
Source File: c:inetpubwwwrootInformationadd_detail_menu2.aspx.vb Line: 6 Stack Trace:
[Code]....
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Stored procedure ALTER proc [dbo].[spSearchCombo](@searchBy nvarchar(50),@searchKey nvarchar(50)) as select * from CD_DETAILS where @searchBy like '%' +@searchKey+ '%' I'm using ASP.net2.0 with c# to extract rows basedon search key from a text box and searchBy for the column to be searched. When i use column name instead of @searchBy which comes from value selected from a ddropdownlist i get the desired result . There seems to be a problem with format of @searchBy and i get a blank page.
protected void btnSearch_Click(object sender, EventArgs e)
{
string constring = ConfigurationManager.AppSettings.Get("con").ToString();
SqlConnection conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmdSP = new SqlCommand("spSearchCombo", conn);
cmdSP.CommandType=CommandType.StoredProcedure;
cmdSP.Parameters.Add(new SqlParameter("@searchBy",SqlDbType.NVarChar,50));
cmdSP.Parameters["@searchBy"].Value=ddlSearchBy.SelectedValue.ToString();
cmdSP.Parameters.Add(new SqlParameter("@searchKey", SqlDbType.NVarChar, 50));
cmdSP.Parameters["@searchKey"].Value=txtSearch.Text.Trim();
SqlDataAdapter da=new SqlDataAdapter(cmdSP);
DataSet ds=new DataSet();
da.Fill(ds);
this.dgv1.DataSource=ds.Tables[0].DefaultView;
dgv1.DataBind();
}
Using ReportViewer control v9 in .aspx page - When displaying date type parameter field in my report nothing happens when calendar icon is clicked (no calendar page, no error) in ie 8. FoxFire works.Same report works fine when viewed directly on the report server in ie8.
Report Server is SQL 2005
I am using a SQL stored procedure to insert client records into multiple tables.
this is my datasource markup:
[Code]....
I am using a multiview to step through the input pages then on the last view there is a submit button that fires this:
[Code]....
this is my stored procedure:
[Code]....