ASP.NET

auto complete with ajaxcontroltoolkit and ado.net

18-Dec-13 12:56

redpoll
hi
how can i send an image in the my posts?
there aren't any option for this.
please help me Rose | [Rose]

Re: temp

Richard MacCutchan18-Dec-13 22:00

Richard MacCutchan

18-Dec-13 22:00

Please read http://www.codeproject.com/Messages/1278599/How-to-get-an-answer-to-your-question.aspx[^].

Veni, vidi, abiit domum

Ya Rasoolallah18-Dec-13 12:01

Re: auto complete with ajaxcontroltoolkit and ado.net

18-Dec-13 12:01

hello to all
i have a problem with the program that see in below;
this program has not any syntax error but doesn't work;
i thank you if help me. Rose | [Rose]

Default.aspx page:

<%@ Page Language="C#‎‎‎‎‎‎‎‎‎" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
 
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
 
<!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:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
        </asp:ToolkitScriptManager>
         
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
         
      <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server"
      TargetControlID="TextBox1" ServiceMethod="GetCompletionList"
      UseContextKey="True" MinimumPrefixLength="1" CompletionInterval="100" ServicePath="~/WebService.asmx">
      </asp:AutoCompleteExtender>
    </div>
    </form>
</body>
</html>

Default.aspx.cs

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
 
public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
}

in .asmx file

<%@ WebService Language="C#‎‎‎" CodeBehind="~/App_Code/AutoComplete.cs" Class="AutoComplete" %>

in .asmx code behind file

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Configuration;
 
/// <summary>
/// this WebService is designed for autocomplete with ajaxControlToolkit and ADO.Net
/// </summary>
[WebService(Namespace = "http://tempuri.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.ScriptService]
public class AutoComplete  : System.Web.Services.WebService {
 
    public AutoComplete()
    {
 
        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }
 
    [WebMethod]
    public string[] GetCompletionList(string prefixText, int count)
    {
       
        SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
        string query = "select * from tbl_users where username like username";
        SqlCommand cm = new SqlCommand(query,cn);
        cm.Parameters.AddWithValue("username","N%"+prefixT  ext+"%");
        cn.Open();
        SqlDataReader dr = cm.ExecuteReader();
         
        List<string> Textbox1 = new List<string>();
        String dbValues;
        while (dr.Read())
        {
            //String From DataBase(dbValues)
            dbValues = dr["username"].ToString().ToLower();
            Textbox1.Add(dbValues);
         
        }
        return Textbox1.ToArray();
        cn.Close();
    }
     
}

note:the visual studio doesn't know "Texbox1" (in asmx codbehind)

modified 18-Dec-13 18:38pm.

thatraja18-Dec-13 13:39

Re: auto complete with ajaxcontroltoolkit and ado.net

18-Dec-13 13:39

For parameter fields you should add prefix @, like below

Ya Rasoolallah wrote:

string query = "select * from tbl_users where username like @username";
SqlCommand cm = new SqlCommand(query,cn);
cm.Parameters.AddWithValue("@username","N%"+prefixT  ext+"%");

thatraja

Code converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

Ya Rasoolallah18-Dec-13 14:05

Re: auto complete with ajaxcontroltoolkit and ado.net

18-Dec-13 14:05

thanks

my friend , still does not work.
why? Frown | :(

test it please.

thatraja18-Dec-13 14:22

Re: auto complete with ajaxcontroltoolkit and ado.net

18-Dec-13 14:22

I don't think you need N in below line

cm.Parameters.AddWithValue("@username","N%"+prefixText+"%");

Debug your code & make sure you get data in SqlDataReader dr(below line)

while (dr.Read())

Before that make sure you have data in your database table tbl_users.
I think you tried example from this article[^] so make sure you didn't miss any steps mentioned there.

thatraja

Ya Rasoolallah19-Dec-13 6:10

Re: auto complete with ajaxcontroltoolkit and ado.net

19-Dec-13 6:10

hello
the problem is not from @ or N and etc...
my program doesn't have any syntax error but doesn't work not at all.
please debug my program to see why not to work?thanks. Rose | [Rose]

i worked from
that example link that you said step by step exactly.

modified 19-Dec-13 12:18pm.

joginder-banger25-Dec-13 15:36

joginder-banger

25-Dec-13 15:36

I have used many time auto complete Extender. I check out your code behind file.

  [WebMethod]
    public static string[] City(string prefixText, int count, string contextKey)
    {


        DataTable dt = new DataTable();

        dt = Bal_BindingData._city(prefixText);
//_city is dataTable type function with the string type parameter.just add the String Contextkey in your GetCompletionList method.

        string[] movies = new string[dt.Rows.Count];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            movies[i] = dt.Rows[i]["City"].ToString();

        }


        return movies;
    }

i think you forgot string Contextkey Parameter in GetCompletionList method.
don't confused my with code i have used three tire technique. I hope your problem has been solved.
Laugh | :laugh:

jsb

Are there any good "substitute" ASP.Net lessons for "C# for programmers 2e"?

That New Guy18-Dec-13 10:47

That New Guy

18-Dec-13 10:47

I know this question is kind of broad, and I apologize. I read the rules, and think I can ask this. However, if this is against the rules, I'm fine with that and will delete it.

I'm new to C# in general, and am now in the 21st chapter of the book "C# for Programmers, Second Edition" by Deitel (isbn 0-13-134591-5)*. I'm on Visual Studio 2010, and this book's examples deal with 2005. Still, that's been no obstacle up until now, with ASP. I got by OK earlier in the chapter, but I'm now being asked to link a particular database to a datagridview control. When I try to link up this database, I get an error that basically says my version of SQL Server is incompatible with the pre-release version of this database. All solutions to this problem indicate that I'm supposed to install SQL Server 2005 just to update the permissions on this database. I went through a lot just to get 2008 fine and running on my computer, and am not going to dip my toe into that river of confusion.

The thing is: it's this particular database. I tried to import another DB from previous lessons just to see, and that one come in fine. I'm going to try to continue the lesson with that one. However, I feel this will be a growing problem until I get back into non DB stuff later. So, I was wondering what ASP.Net/SQL material you guys would recommend (from here or elsewhere) that's thorough and can match what's in this book. I'm looking around here, but I'm drowning in random topics and don't know what to "trust" because I really don't know where to start.

modified 18-Dec-13 18:19pm.

Re: Are there any good "substitute" ASP.Net lessons for "C# for programmers 2e"?

Rahul Rajat Singh19-Dec-13 18:23

Rahul Rajat Singh

19-Dec-13 18:23

If you want to start with ASP.NET the perhaps the book "MCTS -70-515 self paced learning kit" is the best place to start with.
If you want to start ASP.NET MVC then "MvcMusicStore tutorial" from codeplex is the best place to start.
For SqlServer, I think get any book on sql server for developers from Microsoft press and that will do. Just check that the book is meant for developers and not the DBAs.

Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.

Re: Are there any good "substitute" ASP.Net lessons for "C# for programmers 2e"?

abdul subhan mohammed21-Dec-13 3:44

abdul subhan mohammed

21-Dec-13 3:44

tyr this website:

thenewboston.org

pass a value from custom text box control to controller

Member 1040952418-Dec-13 10:01

Member 10409524

18-Dec-13 10:01

I would like a pass value from custom text box to controller in MVC 4.

How can I do that?

Please advise.

Complex UriTemplate for WCF

Siva Kumar Balaguru 18-Dec-13 0:16

Siva Kumar Balaguru

18-Dec-13 0:16

I am totally new to WCF and web services.

I need to create a REST based wcf service for which I have got the sample walkthrough from code project.

I would like have the Uri Template like https://example.com/{v}/{resource}?ﬁlter={attribute}{op}{value}&sortBy={attributeName}&sortOrder={ascending|descending}&attributes={attribute list in csv}

attribute:attribute to be searched
op:operator( format of eq,and,or,neq,like,contains ) value:attribute value to be searched
attributeName:sortBy attribute name
sortOrder should be enum with ascending or descending. attributes:attributeslist in csv

Is this possible?

Could anyone help me in configuring UriTemplate and OperationContract for this?

Re: Complex UriTemplate for WCF

Rahul Rajat Singh19-Dec-13 18:21

Rahul Rajat Singh

19-Dec-13 18:21

It looks like you want query support in URLs so that you can pass in query like URLs and get the filtered data from the server. Why dont you create a WCF data service which will provide this support out of the box. And you can also expose a rest endpoint for the same too.

A Beginner's Tutorial for Creating WCF Data Services[^]

I want column wise gridview paging

Member 1006079517-Dec-13 21:04

Member 10060795

17-Dec-13 21:04

i am displaying records gridview vertically by converting rows into column hence i want column wise paging in gridview. thanks in advance

thatraja17-Dec-13 23:25

17-Dec-13 23:25

Use Google[^], I found this[^]

EDIT
-----------------
Better way is bring resultset from database using the PageNo & Start-End. Check this article
SQL Server 2005 Paging Results[^]

For Row to Column/Column to Row use PIVOT-UNPIVOT
Using PIVOT and UNPIVOT[^]
Pivoting data in SQL Server - (Alternate ways)[^]

Combine the above two things & customize. That's it but to get perfect version, you need to spend some time on this. And don't forget to share your final version here.

thatraja

modified 18-Dec-13 8:04am.

Snehasish_Nandy18-Dec-13 1:37

Snehasish_Nandy

18-Dec-13 1:37

I think OP asked for paging..conversion part is already over..

thatraja18-Dec-13 2:05

18-Dec-13 2:05

I won't blame my last coffee, it's my mistake. Sometime it happens. Thanks for the headsup.

thatraja

joginder-banger25-Dec-13 15:41

joginder-banger

25-Dec-13 15:41

I am not try this type but i sure this link will be help you. try this link http://forums.asp.net/t/1274497.aspx[^]

New

tsunamigang17-Dec-13 17:27

tsunamigang

17-Dec-13 17:27

Dim fourthOfJuly As New Date(1776, 7, 4)
Dim inTheMorning As New Date(1776, 7, 4, 9, 45, 30)

Why it has been declared like this?? what is the meaning??
cant we give it as simply date??

Re: New

thatraja17-Dec-13 23:35