how to search data without sql query in windows form?

my API code is:

HttpWebRequest httpWReq1 =

(HttpWebRequest)WebRequest.Create("http://projects.com/gettickets/api/Shows/getmovies.json");

ASCIIEncoding encoding1 = new ASCIIEncoding();

string postData1;

postData1 = "apikey=51";

postData1 += "&password=i41AtRcqb5vXNws2f9oLmhJ6nE";

postData1 += "&multiplex_id=51";

byte[] data1 = encoding1.GetBytes(postData1);

httpWReq1.Method = "POST";

httpWReq1.ContentType = "application/x-www-form-urlencoded";

httpWReq1.ContentLength = data1.Length;

using (Stream stream = httpWReq1.GetRequestStream())

{

stream.Write(data1, 0, data1.Length);

}

HttpWebResponse response1 = (HttpWebResponse)httpWReq1.GetResponse();

string responseString1 = new StreamReader(response1.GetResponseStream()).ReadToEnd();

// label_data_api.Text = responseString1;

JObject obj = JObject.Parse(responseString1);

JArray item_array = (JArray)obj["Movies"];

JObject aItem = (JObject)item_array[0];

string aItemName = Convert.ToString(aItem["Movie"]);

label_data_api.Text = aItemName;

JObject movieobj = JObject.Parse(aItemName);

string id = Convert.ToString(movieobj["id"]);

lbl_no1.Text = id;

string name = Convert.ToString(movieobj["name"]);

lbl_title1.Text = name;

string img = Convert.ToString(movieobj["image"]);

pictureBox_img1.ImageLocation = img;

pictureBox_img1.Size = new Size(83, 96);

string screen = Convert.ToString(movieobj["screen"]);

lbl_screen1.Text = screen;

string time = Convert.ToString(movieobj["time"]);

lbl_time1.Text = time;

JArray item_array1 = (JArray)obj["Movies"];

JObject aItem1 = (JObject)item_array1[2];

string aItemName1 = Convert.ToString(aItem1["Movie"]);

label_data_api.Text = aItemName1;

JObject movieobj1 = JObject.Parse(aItemName1);

string id1 = Convert.ToString(movieobj1["id"]);

lbl_no2.Text = id1;

string name1 = Convert.ToString(movieobj1["name"]);

lbl_title2.Text = name1;

string img1 = Convert.ToString(movieobj1["image"]);

pictureBox_img2.ImageLocation = img1;

pictureBox_img2.Size = new Size(83, 96);

string screen1 = Convert.ToString(movieobj1["screen"]);

lbl_screen2.Text = screen1;

string time1 = Convert.ToString(movieobj1["time"]);

lbl_time2.Text = time1;

how to search the data?

4 Replies

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

Jignesh Trivedi13y ago
hi,
here, Are you getting Json String?
if yes than you can use Json Deserializer to Deserialize json object to perticular type of object (may ob list of object)
Please refer
http://james.newtonking.com/projects/json/help/index.html?topic=html/SerializingJSON.htm
once it converted in to any enumerable type than you can directly write where cluase to filter the record.
hope this will help you.
Dipika Shah13y ago
my API code is:
HttpWebRequest httpWReq1 =
(HttpWebRequest)WebRequest.Create("http://projects.com/gettickets/api/Shows/getmovies.json");

ASCIIEncoding encoding1 = new ASCIIEncoding();
string postData1;
postData1 = "apikey=51";
postData1 += "&password=i41AtRcqb5vXNws2f9oLmhJ6nE";
postData1 += "&multiplex_id=51";
byte[] data1 = encoding1.GetBytes(postData1);

httpWReq1.Method = "POST";
httpWReq1.ContentType = "application/x-www-form-urlencoded";
httpWReq1.ContentLength = data1.Length;

using (Stream stream = httpWReq1.GetRequestStream())
{
stream.Write(data1, 0, data1.Length);
}

HttpWebResponse response1 = (HttpWebResponse)httpWReq1.GetResponse();

string responseString1 = new StreamReader(response1.GetResponseStream()).ReadToEnd();

// label_data_api.Text = responseString1;
JObject obj = JObject.Parse(responseString1);

JArray item_array = (JArray)obj["Movies"];
JObject aItem = (JObject)item_array[0];
string aItemName = Convert.ToString(aItem["Movie"]);
label_data_api.Text = aItemName;
JObject movieobj = JObject.Parse(aItemName);
string id = Convert.ToString(movieobj["id"]);
lbl_no1.Text = id;
string name = Convert.ToString(movieobj["name"]);
lbl_title1.Text = name;
string img = Convert.ToString(movieobj["image"]);
pictureBox_img1.ImageLocation = img;
pictureBox_img1.Size = new Size(83, 96);

string screen = Convert.ToString(movieobj["screen"]);
lbl_screen1.Text = screen;
string time = Convert.ToString(movieobj["time"]);
lbl_time1.Text = time;

JArray item_array1 = (JArray)obj["Movies"];
JObject aItem1 = (JObject)item_array1[2];
string aItemName1 = Convert.ToString(aItem1["Movie"]);
label_data_api.Text = aItemName1;
JObject movieobj1 = JObject.Parse(aItemName1);
string id1 = Convert.ToString(movieobj1["id"]);
lbl_no2.Text = id1;
string name1 = Convert.ToString(movieobj1["name"]);
lbl_title2.Text = name1;
string img1 = Convert.ToString(movieobj1["image"]);
pictureBox_img2.ImageLocation = img1;
pictureBox_img2.Size = new Size(83, 96);
string screen1 = Convert.ToString(movieobj1["screen"]);
lbl_screen2.Text = screen1;
string time1 = Convert.ToString(movieobj1["time"]);
lbl_time2.Text = time1;
how to search the data?
Hemant Srivastava13y ago
If your API is returning data in the .Net List collection, then you may follow the following link:
http://www.c-sharpcorner.com/UploadFile/0f68f2/using-lambda-expression-over-a-list-in-C-Sharp/
Iftikar Hussain13y ago
Hi,
In what format your API is returing? Can you provide your code details?

Regards,
Iftikar