|
Hi,
AutoComplete Extender (using ajax autocompleteextender) is not working fine in VS2008 asp.net web application project.Database I used is MS Access 2007 Here is my code:
using System;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data;
using System.Data.OleDb;
/// <summary>
/// Summary description for MyWebService
/// </summary>
[WebService(Namespace = "http://microsoft.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
//[System.Web.Script.Services.ScriptMethod]
[System.Web.Script.Services.ScriptService]
public class MyWebService : System.Web.Services.WebService {
public MyWebService () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
[System.Web.Script.Services.ScriptMethod]
public string[] GetCountryInfo(string prefixText)
{
int count = 10;
string sql = "Select * from Country Where Country_Name like @prefixText";
OleDbDataAdapter da = new OleDbDataAdapter(sql, "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Documents and Settings/Leeds_Desk2/My Documents/trials.accdb");
da.SelectCommand.Parameters.Add("@prefixText", OleDbType.VarChar, 50).Value = prefixText + "%";
DataTable dt = new DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
items.SetValue(dr["Country_Name"].ToString(), i);
i++;
}
return items;
}
}
ASPX File
-------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server" ></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true"><Services><asp:ServiceReference Path="~/MyWebService.asmx" /></Services></asp:ScriptManager>
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TextBox1" CompletionInterval="1000" CompletionSetCount="20" UseContextKey="false" MinimumPrefixLength="1" ServiceMethod="GetCountryInfo" DelimiterCharacters=";," ServicePath="MyWebService.asmx"
EnableCaching="true" FirstRowSelected="true" CompletionListCssClass="completionList" CompletionListHighlightedItemCssClass="itemHighlighted"
CompletionListItemCssClass="listItem" ShowOnlyCurrentWordInCompletionListItem="true"></cc1:AutoCompleteExtender>
</div>
</form>
</body>
</html>
Please help me
|
|
|
|
|
If you are going to post code use pre tags, look at the "code block" menu item on the toolbar above the textbox where you entered your question. Also make sure you read the forum guidelines.
Have you debugged your application? Which part is not working? The extender? The database call?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
anyone knows about one API which can be used with ASP.NET to post status and share on all social networks (or at least many social networks) like twitter, linkedin, etc.. instead of using a different API for every social network?
|
|
|
|
|
These projects are not written by the same people. If you want something that can do that, you'd have to get a hold of all the APIs and create a wrapper around them that would broker your data to each using the appropriate interfaces. That way it could appear to be a single API, but in reality I don't think it would exist as you want it to.
|
|
|
|
|
Hi,
I am new to web service... I have created a simple web service to add a record to sql server by passing a parameter and returns true or false once done...
At the same time, I want to return the customer_account_number value created on the sql server.. so basically I want to return the true and false and one (or more) additional values..
how can i do that please..
|
|
|
|
|
how about returning a struct?
|
|
|
|
|
any example there for the web services?
|
|
|
|
|
You need to create a struct with both values
public struct ServiceReturnArgs
{
public string id;
public bool result;
}
then serialize it and send the resulting string as the return value from the webmethod.
Deserialize on the consumer and voila, you have your results.
|
|
|
|
|
Basically, you have two options.
One create you own custom datatype, having as many properties as you want, and return the object of that.
Another approach would be,passing a ref parameter define webmethod
parameters, like
[WebMethod]
public string myMethod(string Id, ref int status)
{
status = 3;
return "result";
}
Now you will both the values at client.
|
|
|
|
|
Hi,
I am new to web service... I have created one web service using ASP.NET to insert a record in my sql server by passing one parameter.
my question, when user type the web service address in the browser address textbox it will show him what are the parameters to enter then he can enter there..
what if I don't want this happen? I just want user to be able to pass the parameters through my application only?
how can I protect the web service then?
|
|
|
|
|
|
I have 2 user groups say LDM and DM
In DM there are 3 users.If any of the DM approves the page status is completed.
LDM send a form for Review with status Inprogress and DM reviews it and the status is changed to Reviewed.
How to handle this in workflow using a form.Can this be a layout
SNO Workflow seq PAGE PAGE SENT FOR REVIEW Assigned to If Reject Go to Email
EDIT CHECKS
1 Assigned Edit Check Customization Edit Check Customization Role: -1 yes
Assign User:
2 Assigned Edit check Review Edit check Review Assigned users: 1 Yes
If anyone approves change status to completed
FEC
1 Inprogress FEC FEC Role: -1 yes
Assign User:
2 Reviewed FEC REVIEW FEC REVIEW Assigned users 1 Yes
If anyone approves change status to completed
|
|
|
|
|
I wanna run outlook on client,just like input "D:\PROGRA~1\MICROS~4\Office12\OUTLOOK.EXE" into run.
I don't want to use "mailto:",how can I do?
|
|
|
|
|
magichi wrote: I wanna run outlook on client,just like input "D:\PROGRA~1\MICROS~4\Office12\OUTLOOK.EXE" into run.
Are you working on web application. And want to run outlook on client machine. You can not. Because browser does not have suffcient permission to run an exe on a machine.
|
|
|
|
|
Try this
using System.Diagnostics;
Process.Start("outlook.exe");
|
|
|
|
|
I tried it,but it doesn't work.
somebody says the reason is it's server code,not client code,so it doesn't work
|
|
|
|
|
Another one
function go()
{
w = new ActiveXObject("WScript.Shell");
w.run('notepad.exe');
return true;
}
onLoad="go();" event in form
|
|
|
|
|
I tried it,but it based on the security of IE option.It based on setting low security.Customs could not set same security of IE.
|
|
|
|
|
magichi wrote: I don't want to use "mailto:
Why?
magichi wrote: I wanna run outlook on client,just like input "D:\PROGRA~1\MICROS~4\Office12\OUTLOOK.EXE" into run
Think about it - what happens if the user doesn't have Outlook installed? What if it's installed to a different location?
You are writing a web based application, which users expect to honour the security sandbox. Solutions like shelling out using ActiveX scripting have the effect of giving users and experience they wouldn't expect, probably wouldn't like, and certainly won't work on none Microsoft operating systems.
|
|
|
|
|
yeah,somebody have suggest me to use ActiveX,do u have any example?
|
|
|
|
|
You might be looking into <a href="mailto:email@domain.com">open outlook new mail window</a>
For details, click here[^]
|
|
|
|
|
Like Pete said... Respect the security sandbox.
That being said, I have in a closed intranet setting implemented solutions that intertwine both client based binaries and server based web pages. But only in a closed intranet setting where that can be properly administered and controlled would that be something to be considered.
If the purpose is to launch the user's outlook, that is what the mailto directive was created for. A safe way to launch a user's email system from a web app.
|
|
|
|
|
Customs wanna open outlook just like run outlook on their client.They don't wanna see the send mail box,they wanna see the number of unread mails,or other information that could see when they open the outlook.How could I do?
|
|
|
|
|
magichi wrote: Customs wanna
Please use full words when you write here. It's truly painful for some of us older guys to read stuff like this.
magichi wrote: They don't wanna see the send mail box,they wanna see the number of unread mails,or other information that could see when they open the outloo
If they are using outlook and an exchange server, just have the exchange server admins activate the webmail front end??? I think that is what you want.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
