Comments by jvamsikrishna (Top 30 by date)

Thanks for suggestions i am following those points figure out my issue.

the issue is i installed the exe in client system there is no execution error by double clicking on it.but the instacnes to update a table is not happen there.the same exe is working fine in my pc. both system H/W configurations are same.
I am notseeking the answers send code or any query to me.
guide me what i need to check in code and database where i need to check
how to perform small testing techniques to find out solution and all......
i expect good answers from you as a dot net legends it's not a big issue for you.for me facing the issue first time.
Thanks In Advance

the issue is i installed the exe in client system there is no execution error by double clicking on it.but the instacnes to update a table is not happen there.the same exe is working fine in my pc. both system H/W configurations are same.
I am notseeking the answers send code or any query to me.
guide me what i need to check in code and database where i need to check
how to perform small testing techniques to find out solution and all......
i expect good answers from you as a dot net legends it's not a big issue for you.for me facing the issue first time.
Thanks In Advance

I had achieved to reslove my problem using this code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Xml.Linq;
using System.Drawing;
using System.Data;


public partial class GridViewFilter : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
XmlTextReader xtr = new XmlTextReader(Server.MapPath("~/xml/xmltest.xml"));
DataSet ds = new DataSet();
ds.ReadXml(xtr);

GridView1.DataSource = ds;
GridView1.DataBind();
getxml();
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "name";
DropDownList1.DataValueField = "name";
DropDownList1.DataBind();

DropDownList2.DataSource = ds;
DropDownList2.DataTextField =ds.Tables[0].Columns[3].ToString();
DropDownList2.DataValueField = "location";
DropDownList2.DataBind();
}
protected void getxml()
{
XmlTextReader xtr = new XmlTextReader(Server.MapPath("~/xml/xmltest.xml"));
DataSet ds = new DataSet();
ds.ReadXml(xtr);

GridView1.DataSource = ds;
GridView1.DataBind();

}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string name= DropDownList1.SelectedItem.Text;
DataTable dt = new DataTable();
dt.Columns.Add("fname", typeof(string));
dt.Columns.Add("lname", typeof(string));
dt.Columns.Add("name", typeof(string));
dt.Columns.Add("location", typeof(string));
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(Server.MapPath("~/xml/xmltest.xml"));
XmlNodeList nodeList = xmldoc.SelectNodes("/karomi/emp");


foreach (XmlNode node in nodeList)
{
if (name== node["name"].InnerText)
{
DataRow dtrow = dt.NewRow();
dtrow["fname"] = node["fname"].InnerText;
dtrow["lname"] = node["lname"].InnerText;
dtrow["name"] = node["name"].InnerText;
dtrow["location"] = node["location"].InnerText;
dt.Rows.Add(dtrow);
}
}

GridView1.DataSource = dt;
GridView1.DataBind();



}
}

Your Link has given Detailed view about Xml and thanks for xmlhelper.

Thanks for you help to reslove my query

Thank You very much for your quick reply

thanks for your reply on my query

dear chauhan,
do you mean to check feasibility of shipping in India based on pin-codes
Indian pin-code are 6 digit numbers u can easily get in web.
First 2/3 Digits of PIN Postal Circle
11 Delhi
12 and 13 Haryana
14 to 15 Punjab
16 Chandigarh
17 Himachal Pradesh
18 to 19 Jammu & Kashmir
20 to 28 Uttar Pradesh/Uttrakhand
30 to 34 Rajasthan
36 to 39 Gujarat
40 Goa
40 to 44 Maharastra
45 to 48 Madhya Pradesh
49 Chattisgarh
50 to 53 Andhra Pradesh
56 to 59 Karnataka
60 to 64 Tamil Nadu
67 to 69 Kerala
682 Lakshadweep (Islands)
70 to 74 West Bengal
744 Andaman & Nicobar Islands
75 to 77 Orissa
78 Assam
79 Arunachal Pradesh
793, 794, 783123 Meghalaya
795 Manipur
796 Mizoram
799 Tripura
80 to 85 Bihar and Jharkhand

thanks

thanks for ur suggestion

thanks for your guidance

thank u

thank you hamid

thanks

thanks rahul

Thanks sandeep

Thank you for your suggestion

i had written that sp.

create procedure sp_schedule
as declare @qid int
declare @loc varchar(30)
begin TRANSACTION tran1
select top 1 @qid = q_id,@loc=location from QueueTable where
QueueTable.audit_date =(select top 1 audit_Date from queuetable order by audit_Date asc)
update queuetable set audit_date=GETDATE() where @qid=q_id and @loc=Location
commit tran1

Suggest me it is achivable in SP.

Is any other way if u know please inform me.
thanks for your valuable info.

sir,
thanks for your valuable reply on my query.
i just executed a update query by mistakely.
i need to rollback all modifications.

yes prasad i had updates the table without where condition that's my mistake.

is no way to rollback?

at least i need to resolve before Monday 10am otherwise i need to pay alot

thank you

Thanks Dude