how to search data without sql query in windows form?

Question

I have no database connectivity. my data come through API.I have many data so how to search those data without sql query in windows form application?

Jignesh Trivedi · Answer

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 Shah · Answer

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 Srivastava · Answer

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 Hussain · Answer

Hi, In what format your API is returing? Can you provide your code details? Regards, Iftikar

how to search data without sql query in windows form?

Answers (4)