How do i retrieve data from database using webclient and display in listbox?

Sarah

Hi people, may i know how can i retrieve data from database(linq to sql) using webclient and display in listbox? I realied most of the articles talk about creating xml file and use XDocument or XElement. Is there any possibility that i can consume the web service and retrieve the data?

Urgent. People please help me :(

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sarah15y ago
No error but the data doesn't display in the listbox. :( sorry for the trouble. i'm not good in codings.
0
Prabhu Raja15y ago
Hope this will work.

foreach(char str in e.result)
{
listBox1.Items.Add(str.ToString());
}

0
Sarah15y ago
Hi Pravin,
the codes doesnt work well.

error for foreach: Cannot convert type 'char' to 'string'.

error for ListBox.Add(str); : Error 1 'System.Windows.Controls.ListBox' does not contain a definition for 'Add' and no extension method 'Add' accepting a first argument of type 'System.Windows.Controls.ListBox' could be found (are you missing a using directive or an assembly reference?)
0
Pravin More15y ago
hi sarah ,
ok then you can add it by foreach.......

try like this...

foreach(string str in e.result)
{
listBox1.Add(str);
}

note:- i hope you can do any typecast or to list if required.

let me know if works or not.

Thanks,
Pravin.
0

Sarah15y ago

Hi Pravin, i have alrdy done that in my web service. The problem is i'm using web client method so i think i'm supposed to use the XDocument to help retrieve the data to the listbox successfully. i cant seems to retrieve the data from database :(

this is how my codings in xaml.cs look like:

public Details
{
InitializeComponent();WebClient proxy = new WebClient();
            string baseUri = "http://localhost:1723/ServiceImpl.svc/GetDetails";
            proxy.DownloadStringCompleted += new DownloadStringCompletedEventHandler(proxy_DownloadStringCompleted);
            proxy.DownloadStringAsync(new Uri(baseUri));
}

void proxy_DownloadStringCompleted(object sender, DownloadStringCompletedEventArgs e)
       {
           if (e.Error != null)
           { return; }
           if (e.Result == null) 
            MessageBox.Show("NUlllllllllll");
 
           XDocument xmlCurrent = XDocument.Parse(e.Result);
 

           ListBox.DataContext = xmlCurrent;
 
       }

Pravin More15y ago
Hi Sarah,

you can return List from your web service and bind it to listbox.

i.e. return type of service will be List
0