hi, Try this ...
protected void button1_Click(object sender, EventArgs e)
{
SqlCommand command;
SqlDataAdapter adpter = new SqlDataAdapter();
DataSet ds = new DataSet();
XmlReader xmlFile;
string sql = null;
string Product_Name = null;
string path = MapPath("XMLFile.xml");
xmlFile = XmlReader.Create(path, new XmlReaderSettings());
ds.ReadXml(xmlFile);
int i = 0;
con.Open();
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
Product_Name = ds.Tables[0].Rows[i].ItemArray[1].ToString();
sql = "insert into tab1 values('" + Product_Name + "')";
command = new SqlCommand(sql, con);
adpter.InsertCommand = command;
adpter.InsertCommand.ExecuteNonQuery();
}
con.Close();
}