Comments by Member 10556609 (Top 31 by date)

Hai,Thanks for ur Response..My qr image with logo coding is updated above..as u said.. But the image is not mapping in imageview..Please Verify my coding and tell me the solution..Thanks in advance.I hope u definetely cleared my issue

Will You please help me anyone..Thanks in advance

Thanks for ur response sir. But i need android coding... Ur sol is related to asp.net

i represent three textview seperately for listview..but i want in coding.how to give text size for 1st row of listview

When i click the get data button . listview loaded .when i click second time listview display below the first loaded datas...now i want the 1st loaded datas should be cleared. then display the data in main page when i click second time.. below is my code..where i want to insert clear listview coding?

public void onClick(View view) {

new JSONParse().execute();

}
});

}

private class JSONParse extends AsyncTask<string, string,="" jsonobject=""> {
private ProgressDialog pDialog;
@Override
protected void onPreExecute() {
super.onPreExecute();

Status = (TextView)findViewById(R.id.textView2);
Id= (TextView)findViewById(R.id.textView1);
DateTime = (TextView)findViewById(R.id.textView3);
JobNo =(EditText)findViewById(R.id.editText1);
pDialog = new ProgressDialog(MainActivity.this);
pDialog.setMessage("Getting Data ...");
pDialog.setIndeterminate(false);
pDialog.setCancelable(true);
pDialog.show();

}

@Override
protected JSONObject doInBackground(String... args) {

JSONParser jParser = new JSONParser();

ArrayList<basicnamevaluepair> params = new ArrayList<basicnamevaluepair>();
params.clear();

params.add(new BasicNameValuePair("JobNo",JobNo.getText().toString()));

// Getting JSON from URL
JSONObject json = jParser.getJSONFromUrl(url,params);
return json;

}

@Override
protected void onPostExecute(JSONObject json) {
pDialog.dismiss();
try {
if (JobNo.getText().toString().equals(""))
{
Toast.makeText(MainActivity.this, " Enter Your JobNo", Toast.LENGTH_SHORT).show();
}
else
{

// Getting JSON Array from URL
Cargo = json.getJSONArray(TAG_CargoTrack);

for(int i = 0; i < Cargo.length(); i++){
JSONObject c = Cargo.getJSONObject(i);

// Storing JSON item in a Variable
String Status = c.getString(TAG_Status);
String Id = c.getString(TAG_Id);
String DateTime = c.getString(TAG_DateTime);

// Adding value HashMap key => value
//list.clearFocus();
HashMap<string, string=""> map = new HashMap<string, string="">();

map.put(TAG_Status, Status);
map.put(TAG_Id, Id);
map.put(TAG_DateTime, DateTime);

CargoTracklist.add(map);
list=(ListView)findViewById(R.id.listView1);

SpecialAdapter adapter = new SpecialAdapter(MainActivity.this, CargoTracklist,
//ListAdapter adapter = new SimpleAdapter(MainActivity.this, CargoTracklist,
R.layout.listview,
new String[] { TAG_Status,TAG_Id, TAG_DateTime }, new int[] {
R.id.textView2,R.id.textView1, R.id.textView3});

you didn'
t understand my qs..

thank you sir....

Thank u Very Much For Ur Solition. but i created json webservice in Asp.net in that webservice i included 1 parameter and list of datas. and also i used that websrvice in android and get value in listview .but i want to get data from that webservice by using parameter..in android..

Especially i Want format to Select command query..

i Want to Create JSON Webservice In Asp.Net USing C# .The data will Get From SQl Server. I want webService Response LIke This.
{ "Cargo": [ { "status": "pickup", "datetime": "" }, { "status": "InTransit",

"datetime": "" }, { "status": "ReachedBLR", "datetime": "" }, { "status":

"StartedDEL", "datetime": "" }, { "status": "InTransit", "datetime": "" }, { "status": "ReachedDEL", "datetime": "" }] }..

i Want to Create JSON Webservice In Asp.Net USing C# .The data will Get From SQl Server. I want webService Response LIke This.
{ "Cargo": [ { "status": "pickup", "datetime": "" }, { "status": "InTransit",

"datetime": "" }, { "status": "ReachedBLR", "datetime": "" }, { "status":

"StartedDEL", "datetime": "" }, { "status": "InTransit", "datetime": "" }, { "status": "ReachedDEL", "datetime": "" }] }..

Sorry Sir Now I Changed..

SqlCmd (" Selecting Querry ").. Give me Selecting Querry for That Sample..

Selecting querry and return Json. Please Give full Sample coding..pLease..

Yes Absolutely.. This Is i want..

I Create Table In SqlServer..That Tables Data Will Get It From Webservice.LIKE this
{ "Cargo": [ { "status": "pickup", "datetime": "" }, { "status": "InTransit",

"datetime": "" }, { "status": "ReachedBLR", "datetime": "" }, { "status":

"StartedDEL", "datetime": "" }, { "status": "InTransit", "datetime": "" }, { "status": "ReachedDEL", "datetime": "" }] }.. how to get this

Sorry I Want to Get That Data From SqlServer

Sorry I Want to Get That Data From SqlServer

Sorry I Want to Get That Data From SqlServer

Thanks for reply ..if we return string means we want to use one value know? Am returned dataset value from asp.net this ia my webservice returned dataset..


- <dataset xmlns="http://tempuri.org/">
- <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
- <xs:element name="NewDataSet" msdata:isdataset="true" msdata:usecurrentlocale="true">
- <xs:complextype>
- <xs:choice minoccurs="0" maxoccurs="unbounded">
- <xs:element name="Table">
- <xs:complextype>
- <xs:sequence>
<xs:element name="Id" type="xs:string" minoccurs="0">
<xs:element name="Status" type="xs:string" minoccurs="0">
<xs:element name="DateTime" type="xs:dateTime" minoccurs="0">







- <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
- <newdataset xmlns="">
- <Table diffgr:id="Table1" msdata:rowOrder="0">
<id>1
<status>Pickup
<datetime>2014-03-25T00:00:00+05:30
</Table>
- <Table diffgr:id="Table2" msdata:rowOrder="1">
<id>2
<status>InTransit
<datetime>2014-03-25T00:00:00+05:30
</Table>
- <Table diffgr:id="Table3" msdata:rowOrder="2">
<id>3
<status>ReachedBLR
<datetime>2014-03-25T00:00:00+05:30
</Table>
- <Table diffgr:id="Table4" msdata:rowOrder="3">
<id>4
<status>StartedDEL
<datetime>2014-03-25T00:00:00+05:30
</Table>
- <Table diffgr:id="Table5" msdata:rowOrder="4">
<id>5
<status>InTransit
<datetime>2014-03-25T00:00:00+05:30
</Table>
- <Table diffgr:id="Table6" msdata:rowOrder="5">
<id>6
<status>ReachedDEL
<datetime>2014-03-25T00:00:00+05:30
</Table>






please help me to bind that dataset in android gridview..

please help me for these two format sir..

Ya Am using this webservice sir, but i dont know how to bind the returned webservice data in to gridview..Am used sql server for webservice.. then am using alternate format that direct connection android with sql .. this is my code but no response..
public void ConnectToDatabase(){
try {

// SET CONNECTIONSTRING
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
String username = "username";
String password = "password";
Connection DbConn = DriverManager.getConnection("jdbc:jtds:sqlserver://server name:1433/DBNAME;user=" + username + ";password=" + password);

Log.w("Connection","open");
Statement stmt = DbConn.createStatement();
ResultSet reset = stmt.executeQuery(" selecting querry");


GridView num = ( GridView) findViewById(R.id.gridView1);
num.setFilterText(reset.getString(1));

DbConn.close();

} catch (Exception e)
{
Log.w("Error connection","" + e.getMessage());
}
}

Hai Sir,Sorry to disturb you sir your coding is working .but Actually i created Webservice in Asp.Net And it gives datas from Database. but i want to use to call that websrvice in android using soap action to display data in gridview ..Am new to Android sir. please help me sir...

yes i got it friend thank you..

yes i got it Friend thank you....

thank you Friend i used click event to refresh the page but now i want to add display automatic update time for every 5 secds or 10 secds..in my application..